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
786: WHEN EX_PROCESS_TIME_OUT THEN
787:
788: ROLLBACK;
789:
790: FND_MESSAGE.SET_NAME('MSC', 'MSC_TIMEOUT');
791: ERRBUF:= FND_MESSAGE.GET;
792: RETCODE:= G_ERROR;
793: LOG_MESSAGE( ERRBUF);
794:
787:
788: ROLLBACK;
789:
790: FND_MESSAGE.SET_NAME('MSC', 'MSC_TIMEOUT');
791: ERRBUF:= FND_MESSAGE.GET;
792: RETCODE:= G_ERROR;
793: LOG_MESSAGE( ERRBUF);
794:
795: WHEN others THEN