73: -- If a unit effectivity does not have due date, the material forecast is not done.
74: -- Pre-reqs :
75: -- Parameters :
76: --
77: -- Standard IN Parameters :
78: -- p_api_version IN NUMBER Required
79: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
80: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
81: --
78: -- p_api_version IN NUMBER Required
79: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
80: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
81: --
82: -- Standard OUT Parameters :
83: -- x_return_status OUT VARCHAR2 Required
84: -- x_msg_count OUT NUMBER Required
85: -- x_msg_data OUT VARCHAR2 Required
86: --
182: 'At the start of PLSQL procedure'
183: );
184: END IF;
185:
186: -- Standard start of API savepoint
187: SAVEPOINT Process_Mrl_Req_Forecast;
188:
189: -- Initialize message list if p_init_msg_list is set to TRUE
190: IF FND_API.To_Boolean( p_init_msg_list) THEN
525: IF x_msg_count > 0 THEN
526: RAISE FND_API.G_EXC_ERROR;
527: END IF;
528:
529: -- Standard check of p_commit
530: IF FND_API.TO_BOOLEAN(p_commit) THEN
531: COMMIT WORK;
532: END IF;
533:
1290: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.log_error_messages',
1291: 'Start log error messages');
1292: END IF;
1293:
1294: -- Standard call to get message count.
1295: l_msg_count := FND_MSG_PUB.Count_Msg;
1296:
1297: FOR i IN 1..l_msg_count LOOP
1298: FND_MSG_PUB.get (