181: '10000000'); -- NUM_OF_ERRORS
182: COMMIT;
183:
184: IF lv_request_id = 0 THEN
185: FND_MESSAGE.SET_NAME('MSC', 'MSC_PP_LAUNCH_LOADER_FAIL');
186: ERRBUF:= FND_MESSAGE.GET;
187: LOG_MESSAGE( ERRBUF);
188: RETCODE:= G_ERROR;
189: RETURN -1;
182: COMMIT;
183:
184: IF lv_request_id = 0 THEN
185: FND_MESSAGE.SET_NAME('MSC', 'MSC_PP_LAUNCH_LOADER_FAIL');
186: ERRBUF:= FND_MESSAGE.GET;
187: LOG_MESSAGE( ERRBUF);
188: RETCODE:= G_ERROR;
189: RETURN -1;
190: ELSE
187: LOG_MESSAGE( ERRBUF);
188: RETCODE:= G_ERROR;
189: RETURN -1;
190: ELSE
191: FND_MESSAGE.SET_NAME('MSC', 'MSC_PP_LOADER_REQUEST_ID');
192: FND_MESSAGE.SET_TOKEN('REQUEST_ID', lv_request_id);
193: LOG_MESSAGE(FND_MESSAGE.GET);
194: END IF;
195:
188: RETCODE:= G_ERROR;
189: RETURN -1;
190: ELSE
191: FND_MESSAGE.SET_NAME('MSC', 'MSC_PP_LOADER_REQUEST_ID');
192: FND_MESSAGE.SET_TOKEN('REQUEST_ID', lv_request_id);
193: LOG_MESSAGE(FND_MESSAGE.GET);
194: END IF;
195:
196: RETURN lv_request_id;
189: RETURN -1;
190: ELSE
191: FND_MESSAGE.SET_NAME('MSC', 'MSC_PP_LOADER_REQUEST_ID');
192: FND_MESSAGE.SET_TOKEN('REQUEST_ID', lv_request_id);
193: LOG_MESSAGE(FND_MESSAGE.GET);
194: END IF;
195:
196: RETURN lv_request_id;
197: EXCEPTION
547: WHEN EX_PROCESS_TIME_OUT THEN
548:
549: ROLLBACK;
550:
551: FND_MESSAGE.SET_NAME('MSC', 'MSC_TIMEOUT');
552: ERRBUF:= FND_MESSAGE.GET;
553: RETCODE:= G_ERROR;
554: LOG_MESSAGE( ERRBUF);
555:
548:
549: ROLLBACK;
550:
551: FND_MESSAGE.SET_NAME('MSC', 'MSC_TIMEOUT');
552: ERRBUF:= FND_MESSAGE.GET;
553: RETCODE:= G_ERROR;
554: LOG_MESSAGE( ERRBUF);
555:
556: WHEN others THEN