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
716: WHEN EX_PROCESS_TIME_OUT THEN
717:
718: ROLLBACK;
719:
720: FND_MESSAGE.SET_NAME('MSC', 'MSC_TIMEOUT');
721: ERRBUF:= FND_MESSAGE.GET;
722: RETCODE:= G_ERROR;
723: LOG_MESSAGE( ERRBUF);
724:
717:
718: ROLLBACK;
719:
720: FND_MESSAGE.SET_NAME('MSC', 'MSC_TIMEOUT');
721: ERRBUF:= FND_MESSAGE.GET;
722: RETCODE:= G_ERROR;
723: LOG_MESSAGE( ERRBUF);
724:
725: WHEN others THEN