773: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
774:
775: WHEN ERROR_MESSAGE THEN
776: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error - Status is E or U '||sqlerrm);
777: FOR i in 1..fnd_msg_pub.count_msg LOOP
778: FND_MSG_PUB.Get(
779: p_msg_index => i,
780: p_data => x_data,
781: p_encoded => FND_API.G_FALSE,
774:
775: WHEN ERROR_MESSAGE THEN
776: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error - Status is E or U '||sqlerrm);
777: FOR i in 1..fnd_msg_pub.count_msg LOOP
778: FND_MSG_PUB.Get(
779: p_msg_index => i,
780: p_data => x_data,
781: p_encoded => FND_API.G_FALSE,
782: p_msg_index_out => l_dummy_cnt);
917: -- We shall add a check for return code also if negative means an error
918: -- Then show a message
919:
920: IF ret_code <> 0 THEN
921: l_msg_data := FND_MSG_PUB.GET(
922: p_msg_index =>FND_MSG_PUB.Count_msg,
923: p_encoded => 'F') ;
924:
925: IF l_msg_data is NOT NULL THEN
918: -- Then show a message
919:
920: IF ret_code <> 0 THEN
921: l_msg_data := FND_MSG_PUB.GET(
922: p_msg_index =>FND_MSG_PUB.Count_msg,
923: p_encoded => 'F') ;
924:
925: IF l_msg_data is NOT NULL THEN
926: FND_FILE.PUT_LINE(FND_FILE.LOG,'Return from the main process is '||l_msg_data);
1231: EXCEPTION
1232: WHEN ERROR_MESSAGE THEN
1233: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Reschedule Batch - Status Not in S '||p_batch_id||'-'||sqlerrm);
1234:
1235: FOR i in 1..fnd_msg_pub.count_msg LOOP
1236: FND_MSG_PUB.Get(
1237: p_msg_index => i,
1238: p_data => x_data,
1239: p_encoded => FND_API.G_FALSE,
1232: WHEN ERROR_MESSAGE THEN
1233: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Reschedule Batch - Status Not in S '||p_batch_id||'-'||sqlerrm);
1234:
1235: FOR i in 1..fnd_msg_pub.count_msg LOOP
1236: FND_MSG_PUB.Get(
1237: p_msg_index => i,
1238: p_data => x_data,
1239: p_encoded => FND_API.G_FALSE,
1240: p_msg_index_out => l_dummy_cnt);
1299: -- Then show a message
1300:
1301: IF ret_code <> 0 THEN
1302:
1303: l_msg_data := FND_MSG_PUB.GET(
1304: p_msg_index =>FND_MSG_PUB.Count_msg,
1305: p_encoded => 'F') ;
1306: IF l_msg_data is NOT NULL THEN
1307: FND_FILE.PUT_LINE(FND_FILE.LOG,'::'||to_char(ret_code) ||'::'||l_msg_data);
1300:
1301: IF ret_code <> 0 THEN
1302:
1303: l_msg_data := FND_MSG_PUB.GET(
1304: p_msg_index =>FND_MSG_PUB.Count_msg,
1305: p_encoded => 'F') ;
1306: IF l_msg_data is NOT NULL THEN
1307: FND_FILE.PUT_LINE(FND_FILE.LOG,'::'||to_char(ret_code) ||'::'||l_msg_data);
1308: END IF ;
1406: EXCEPTION
1407: WHEN ERROR_MESSAGE THEN
1408: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Cancel Batch - Status Not in S '||p_batch_id||'-'||sqlerrm);
1409:
1410: FOR i in 1..fnd_msg_pub.count_msg LOOP
1411: FND_MSG_PUB.Get(
1412: p_msg_index => i,
1413: p_data => x_data,
1414: p_encoded => FND_API.G_FALSE,
1407: WHEN ERROR_MESSAGE THEN
1408: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Cancel Batch - Status Not in S '||p_batch_id||'-'||sqlerrm);
1409:
1410: FOR i in 1..fnd_msg_pub.count_msg LOOP
1411: FND_MSG_PUB.Get(
1412: p_msg_index => i,
1413: p_data => x_data,
1414: p_encoded => FND_API.G_FALSE,
1415: p_msg_index_out => l_dummy_cnt);