eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XDP_ORDER_SYNC dependencies on FND_LOG

Line 212: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

208: x_error_message => l_ret_str
209: );
210: EXCEPTION
211: WHEN e_exec_order_failure THEN
212: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
213: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'XDP_ORDER_SYNC.Execute_Order_SYNC', SQLERRM);
214: END IF;
215: Update_XDP_Order_Status( 'ERROR',p_Order_ID);
216:

Line 213: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'XDP_ORDER_SYNC.Execute_Order_SYNC', SQLERRM);

209: );
210: EXCEPTION
211: WHEN e_exec_order_failure THEN
212: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
213: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'XDP_ORDER_SYNC.Execute_Order_SYNC', SQLERRM);
214: END IF;
215: Update_XDP_Order_Status( 'ERROR',p_Order_ID);
216:
217: WHEN OTHERS THEN

Line 218: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

214: END IF;
215: Update_XDP_Order_Status( 'ERROR',p_Order_ID);
216:
217: WHEN OTHERS THEN
218: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
219: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'XDP_ORDER_SYNC.Execute_Order_SYNC', SQLERRM);
220: END IF;
221: x_return_code := SQLCODE;
222: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

Line 219: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'XDP_ORDER_SYNC.Execute_Order_SYNC', SQLERRM);

215: Update_XDP_Order_Status( 'ERROR',p_Order_ID);
216:
217: WHEN OTHERS THEN
218: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
219: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'XDP_ORDER_SYNC.Execute_Order_SYNC', SQLERRM);
220: END IF;
221: x_return_code := SQLCODE;
222: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
223: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDP_ORDER_SYNC.Execute_Order_SYNC');

Line 264: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

260: x_return_code => x_return_code,
261: x_error_description =>x_error_description);
262:
263: IF (x_return_code <> 0 ) THEN
264: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
265: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_LineItem_Sync', 'Execute_Workitem_Sync '||'returns error');
266: END IF;
267: RAISE e_exec_line_failure;
268: END IF;

Line 265: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_LineItem_Sync', 'Execute_Workitem_Sync '||'returns error');

261: x_error_description =>x_error_description);
262:
263: IF (x_return_code <> 0 ) THEN
264: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
265: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_LineItem_Sync', 'Execute_Workitem_Sync '||'returns error');
266: END IF;
267: RAISE e_exec_line_failure;
268: END IF;
269:

Line 294: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

290: EXCEPTION
291: WHEN e_exec_line_failure THEN
292: UPDATE_XDP_ORDER_LINE_STATUS('ERROR',p_lineItem_id);
293: WHEN OTHERS THEN
294: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
295: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_LineItem_Sync', 'unexpected exception occurred.');
296: END IF;
297: x_return_code := -191266;
298: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

Line 295: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_LineItem_Sync', 'unexpected exception occurred.');

291: WHEN e_exec_line_failure THEN
292: UPDATE_XDP_ORDER_LINE_STATUS('ERROR',p_lineItem_id);
293: WHEN OTHERS THEN
294: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
295: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_LineItem_Sync', 'unexpected exception occurred.');
296: END IF;
297: x_return_code := -191266;
298: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
299: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDP_ORDER_SYNC.Execute_LineItem_Sync');

Line 403: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

399: p_return_code => x_return_code,
400: p_error_description => x_error_description);
401:
402: IF x_return_code <> 0 THEN
403: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
404: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Error returned '
405: ||x_return_code
406: ||' from XDP_ERRORS_PKG.Set_Message');
407: END IF;

Line 404: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Error returned '

400: p_error_description => x_error_description);
401:
402: IF x_return_code <> 0 THEN
403: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
404: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Error returned '
405: ||x_return_code
406: ||' from XDP_ERRORS_PKG.Set_Message');
407: END IF;
408: RAISE e_exec_wi_failure;

Line 414: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

410: ELSE
411: FND_MESSAGE.SET_NAME('XDP', 'XDP_FA_EXEC_MAP_PROC_NOT_EXIST');
412: x_error_description := FND_MESSAGE.GET;
413: x_return_code := -191156;
414: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
415: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', x_error_description);
416: END IF;
417: RAISE e_exec_wi_failure;
418: END IF;

Line 415: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', x_error_description);

411: FND_MESSAGE.SET_NAME('XDP', 'XDP_FA_EXEC_MAP_PROC_NOT_EXIST');
412: x_error_description := FND_MESSAGE.GET;
413: x_return_code := -191156;
414: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
415: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', x_error_description);
416: END IF;
417: RAISE e_exec_wi_failure;
418: END IF;
419: ELSIF lv_type = 'WORKFLOW_PROC' THEN

Line 424: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

420: IF lv_user_wi_proc is null THEN
421: FND_MESSAGE.SET_NAME('XDP', 'XDP_WF_PROC_NOT_EXIST');
422: x_error_description := FND_MESSAGE.GET;
423: x_return_code := -191266;
424: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
425: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', x_error_description);
426: END IF;
427: RAISE e_exec_wi_failure;
428: END IF;

Line 425: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', x_error_description);

421: FND_MESSAGE.SET_NAME('XDP', 'XDP_WF_PROC_NOT_EXIST');
422: x_error_description := FND_MESSAGE.GET;
423: x_return_code := -191266;
424: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
425: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', x_error_description);
426: END IF;
427: RAISE e_exec_wi_failure;
428: END IF;
429:

Line 445: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

441: P_RETURN_CODE => x_return_code,
442: P_ERROR_DESCRIPTION => x_error_description);
443:
444: IF x_return_code <> 0 THEN
445: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
446: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Error '
447: ||x_return_code
448: ||' returned from XDP_UTILITIES.CallWIWorkflowProc');
449: END IF;

Line 446: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Error '

442: P_ERROR_DESCRIPTION => x_error_description);
443:
444: IF x_return_code <> 0 THEN
445: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
446: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Error '
447: ||x_return_code
448: ||' returned from XDP_UTILITIES.CallWIWorkflowProc');
449: END IF;
450: RAISE e_exec_wi_failure;

Line 463: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

459: ErrCode => x_return_code,
460: ErrStr => x_error_description);
461:
462: IF x_return_code <> 0 THEN
463: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
464: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Error '
465: ||x_return_code
466: ||' returned from XDPCORE.CheckNAddItemAttrNumber - LINE_ITEM_ID');
467: END IF;

Line 464: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Error '

460: ErrStr => x_error_description);
461:
462: IF x_return_code <> 0 THEN
463: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
464: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Error '
465: ||x_return_code
466: ||' returned from XDPCORE.CheckNAddItemAttrNumber - LINE_ITEM_ID');
467: END IF;
468: RAISE e_exec_wi_failure;

Line 481: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

477: ErrCode => x_return_code,
478: ErrStr => x_error_description);
479:
480: IF x_return_code <> 0 THEN
481: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
482: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Error '
483: ||x_return_code
484: ||' returned from XDPCORE.CheckNAddItemAttrNumber - WORKITEM_INSTANCE_ID');
485: END IF;

Line 482: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Error '

478: ErrStr => x_error_description);
479:
480: IF x_return_code <> 0 THEN
481: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
482: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Error '
483: ||x_return_code
484: ||' returned from XDPCORE.CheckNAddItemAttrNumber - WORKITEM_INSTANCE_ID');
485: END IF;
486: RAISE e_exec_wi_failure;

Line 499: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

495: ErrCode => x_return_code,
496: ErrStr => x_error_description);
497:
498: IF x_return_code <> 0 THEN
499: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
500: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Error '
501: ||x_return_code
502: ||' returned from XDPCORE.CheckNAddItemAttrNumber - ORDER_ID');
503: END IF;

Line 500: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Error '

496: ErrStr => x_error_description);
497:
498: IF x_return_code <> 0 THEN
499: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
500: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Error '
501: ||x_return_code
502: ||' returned from XDPCORE.CheckNAddItemAttrNumber - ORDER_ID');
503: END IF;
504: RAISE e_exec_wi_failure;

Line 534: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

530: x_error_description := FND_MESSAGE.GET;
531: x_return_code := -191266;
532:
533:
534: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
535: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Some required fields for WORKFLOW are null.');
536: END IF;
537: -- dbms_output.put_line('XDP_ORDER_SYNC.Execute_Workitem_Sync 8' || x_return_code);
538: RAISE e_exec_wi_failure;

Line 535: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Some required fields for WORKFLOW are null.');

531: x_return_code := -191266;
532:
533:
534: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
535: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Some required fields for WORKFLOW are null.');
536: END IF;
537: -- dbms_output.put_line('XDP_ORDER_SYNC.Execute_Workitem_Sync 8' || x_return_code);
538: RAISE e_exec_wi_failure;
539: END IF;

Line 570: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

566: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_CONFIG_ERROR');
567: FND_MESSAGE.SET_TOKEN('WORK_ITEM_NAME', lv_wi);
568: x_error_description := FND_MESSAGE.GET;
569: x_return_code := 191272;
570: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
571: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync ', x_error_description);
572: END IF;
573: -- dbms_output.put_line('XDP_ORDER_SYNC.Execute_Workitem_Sync 9' || x_return_code);
574: RAISE e_exec_wi_failure;

Line 571: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync ', x_error_description);

567: FND_MESSAGE.SET_TOKEN('WORK_ITEM_NAME', lv_wi);
568: x_error_description := FND_MESSAGE.GET;
569: x_return_code := 191272;
570: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
571: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync ', x_error_description);
572: END IF;
573: -- dbms_output.put_line('XDP_ORDER_SYNC.Execute_Workitem_Sync 9' || x_return_code);
574: RAISE e_exec_wi_failure;
575: END IF;

Line 616: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

612:
613: UPDATE_XDP_WORKITEM_STATUS('ERROR',p_workitem_instance_id);
614:
615: WHEN OTHERS THEN
616: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
617: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Unexpected exception '||sqlcode);
618: END IF;
619: x_return_code := sqlcode;
620: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

Line 617: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Unexpected exception '||sqlcode);

613: UPDATE_XDP_WORKITEM_STATUS('ERROR',p_workitem_instance_id);
614:
615: WHEN OTHERS THEN
616: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
617: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_WI_Sync', 'Unexpected exception '||sqlcode);
618: END IF;
619: x_return_code := sqlcode;
620: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
621: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDP_ORDER_SYNC.Execute_Workitem_Sync');

Line 711: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

707: p_return_code => x_return_code,
708: p_error_description => x_error_description);
709:
710: IF x_return_code <> 0 THEN
711: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
712: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_FA_Sync', 'Error '
713: ||x_return_code
714: ||' returned when call XDP_UTILITIES.CallFERoutingProc');
715: END IF;

Line 712: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_FA_Sync', 'Error '

708: p_error_description => x_error_description);
709:
710: IF x_return_code <> 0 THEN
711: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
712: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_FA_Sync', 'Error '
713: ||x_return_code
714: ||' returned when call XDP_UTILITIES.CallFERoutingProc');
715: END IF;
716: RAISE e_exec_fa_failure;

Line 785: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

781: FND_MESSAGE.SET_TOKEN('ERROR_STRING', x_error_description);
782: FND_MESSAGE.SET_TOKEN('FE_NAME', lv_fe_name);
783: x_error_description := FND_MESSAGE.GET;
784:
785: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
786: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
787: 'XDP_ORDER_SYNC.Execute_FA_Sync',
788: x_error_description);
789: END IF;

Line 786: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

782: FND_MESSAGE.SET_TOKEN('FE_NAME', lv_fe_name);
783: x_error_description := FND_MESSAGE.GET;
784:
785: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
786: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
787: 'XDP_ORDER_SYNC.Execute_FA_Sync',
788: x_error_description);
789: END IF;
790: RAISE e_exec_fa_failure;

Line 817: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

813: lv_ret,
814: lv_str);
815:
816: IF x_return_code <> 0 THEN
817: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
818: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_FA_Sync', 'Error '
819: ||x_error_description
820: ||' returned when call XDP_UTILITIES.CallFulfillmentProc.');
821: END IF;

Line 818: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_FA_Sync', 'Error '

814: lv_str);
815:
816: IF x_return_code <> 0 THEN
817: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
818: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_FA_Sync', 'Error '
819: ||x_error_description
820: ||' returned when call XDP_UTILITIES.CallFulfillmentProc.');
821: END IF;
822: RAISE e_exec_fa_failure;

Line 842: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

838:
839: UPDATE_XDP_FA_STATUS('ERROR',p_fa_instance_id);
840:
841: WHEN OTHERS THEN
842: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
843: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_FA_Sync', 'Unexpected exception '||SQLCODE);
844: END IF;
845: x_return_code := SQLCODE;
846: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

Line 843: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_FA_Sync', 'Unexpected exception '||SQLCODE);

839: UPDATE_XDP_FA_STATUS('ERROR',p_fa_instance_id);
840:
841: WHEN OTHERS THEN
842: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
843: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'XDP_ORDER_SYNC.Execute_FA_Sync', 'Unexpected exception '||SQLCODE);
844: END IF;
845: x_return_code := SQLCODE;
846: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
847: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDP_ORDER_SYNC.Execute_FA_Sync');