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');
224: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
225: x_error_description := FND_MESSAGE.GET;
226: Update_XDP_Order_Status( 'ERROR',p_Order_ID);
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');
224: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
225: x_error_description := FND_MESSAGE.GET;
226: Update_XDP_Order_Status( 'ERROR',p_Order_ID);
227:
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');
224: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
225: x_error_description := FND_MESSAGE.GET;
226: Update_XDP_Order_Status( 'ERROR',p_Order_ID);
227:
228: END Execute_Order_SYNC;
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');
224: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
225: x_error_description := FND_MESSAGE.GET;
226: Update_XDP_Order_Status( 'ERROR',p_Order_ID);
227:
228: END Execute_Order_SYNC;
229:
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');
300: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
301: x_error_description := FND_MESSAGE.GET;
302: UPDATE_XDP_ORDER_LINE_STATUS('ERROR',p_lineItem_id);
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');
300: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
301: x_error_description := FND_MESSAGE.GET;
302: UPDATE_XDP_ORDER_LINE_STATUS('ERROR',p_lineItem_id);
303: END Execute_LineItem_Sync;
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');
300: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
301: x_error_description := FND_MESSAGE.GET;
302: UPDATE_XDP_ORDER_LINE_STATUS('ERROR',p_lineItem_id);
303: END Execute_LineItem_Sync;
304:
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');
300: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
301: x_error_description := FND_MESSAGE.GET;
302: UPDATE_XDP_ORDER_LINE_STATUS('ERROR',p_lineItem_id);
303: END Execute_LineItem_Sync;
304:
305: PROCEDURE Execute_Workitem_Sync(
407: END IF;
408: RAISE e_exec_wi_failure;
409: END IF;
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);
408: RAISE e_exec_wi_failure;
409: END IF;
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;
419: ELSIF lv_type = 'WORKFLOW_PROC' 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);
418: END IF;
419: ELSIF lv_type = 'WORKFLOW_PROC' 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;
518: ELSIF lv_type = 'WORKFLOW' THEN
519: IF (lv_user_item_type IS NULL) OR
520: (lv_user_wf_process IS NULL) THEN
521:
522: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
523: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDP_ORDER_SYNC.Execute_Workitem_Sync');
524: x_error_description :=
525: 'XDP_ORDER_SYNC.execute_workitem_sync. process_name or item_type not specified for a '
526: || 'defined Workflow of workitem: '
519: IF (lv_user_item_type IS NULL) OR
520: (lv_user_wf_process IS NULL) THEN
521:
522: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
523: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDP_ORDER_SYNC.Execute_Workitem_Sync');
524: x_error_description :=
525: 'XDP_ORDER_SYNC.execute_workitem_sync. process_name or item_type not specified for a '
526: || 'defined Workflow of workitem: '
527: || lv_workitem_id ;
525: 'XDP_ORDER_SYNC.execute_workitem_sync. process_name or item_type not specified for a '
526: || 'defined Workflow of workitem: '
527: || lv_workitem_id ;
528:
529: FND_MESSAGE.SET_TOKEN('ERROR_STRING', x_error_description);
530: x_error_description := FND_MESSAGE.GET;
531: x_return_code := -191266;
532:
533:
526: || 'defined Workflow of workitem: '
527: || lv_workitem_id ;
528:
529: FND_MESSAGE.SET_TOKEN('ERROR_STRING', x_error_description);
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
562: WF_ENGINE.StartProcess(lv_user_item_type,wf_engine.eng_synch);
563: -- bypass the execution of FA List
564: GOTO UpdateStatus;
565: ELSE
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
563: -- bypass the execution of FA List
564: GOTO UpdateStatus;
565: ELSE
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);
564: GOTO UpdateStatus;
565: ELSE
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;
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');
622: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
623: x_error_description := FND_MESSAGE.GET ||' - '||lv_wi;
624:
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');
622: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
623: x_error_description := FND_MESSAGE.GET ||' - '||lv_wi;
624:
625: x_parameters := 'ERROR_STRING='||x_error_description||'#XDP#';
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');
622: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
623: x_error_description := FND_MESSAGE.GET ||' - '||lv_wi;
624:
625: x_parameters := 'ERROR_STRING='||x_error_description||'#XDP#';
626: XDP_ERRORS_PKG.Set_Message(p_object_type => 'WORKITEM',
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');
622: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
623: x_error_description := FND_MESSAGE.GET ||' - '||lv_wi;
624:
625: x_parameters := 'ERROR_STRING='||x_error_description||'#XDP#';
626: XDP_ERRORS_PKG.Set_Message(p_object_type => 'WORKITEM',
627: p_object_key => p_workitem_instance_id,
774:
775: IF lv_locked_flag = 'N' THEN
776: -- if still fails, get out
777: x_return_code := -191142;
778: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_START_ADAPTER');
779: FND_MESSAGE.SET_TOKEN('CHANNEL_NAME', lv_channel);
780: FND_MESSAGE.SET_TOKEN('ADAPTER_NAME', lv_adapter);
781: FND_MESSAGE.SET_TOKEN('ERROR_STRING', x_error_description);
782: FND_MESSAGE.SET_TOKEN('FE_NAME', lv_fe_name);
775: IF lv_locked_flag = 'N' THEN
776: -- if still fails, get out
777: x_return_code := -191142;
778: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_START_ADAPTER');
779: FND_MESSAGE.SET_TOKEN('CHANNEL_NAME', lv_channel);
780: FND_MESSAGE.SET_TOKEN('ADAPTER_NAME', lv_adapter);
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;
776: -- if still fails, get out
777: x_return_code := -191142;
778: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_START_ADAPTER');
779: FND_MESSAGE.SET_TOKEN('CHANNEL_NAME', lv_channel);
780: FND_MESSAGE.SET_TOKEN('ADAPTER_NAME', lv_adapter);
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:
777: x_return_code := -191142;
778: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_START_ADAPTER');
779: FND_MESSAGE.SET_TOKEN('CHANNEL_NAME', lv_channel);
780: FND_MESSAGE.SET_TOKEN('ADAPTER_NAME', lv_adapter);
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
778: FND_MESSAGE.SET_NAME('XDP', 'XDP_CANNOT_START_ADAPTER');
779: FND_MESSAGE.SET_TOKEN('CHANNEL_NAME', lv_channel);
780: FND_MESSAGE.SET_TOKEN('ADAPTER_NAME', lv_adapter);
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,
779: FND_MESSAGE.SET_TOKEN('CHANNEL_NAME', lv_channel);
780: FND_MESSAGE.SET_TOKEN('ADAPTER_NAME', lv_adapter);
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',
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');
848: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
849:
850: x_error_description := FND_MESSAGE.GET ||' - '||lv_fe_name;
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');
848: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
849:
850: x_error_description := FND_MESSAGE.GET ||' - '||lv_fe_name;
851:
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');
848: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
849:
850: x_error_description := FND_MESSAGE.GET ||' - '||lv_fe_name;
851:
852: x_parameters := 'ERROR_STRING='||SQLERRM||'#XDP#';
846: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');
847: FND_MESSAGE.SET_TOKEN('API_NAME', 'XDP_ORDER_SYNC.Execute_FA_Sync');
848: FND_MESSAGE.SET_TOKEN('ERROR_STRING', SQLERRM);
849:
850: x_error_description := FND_MESSAGE.GET ||' - '||lv_fe_name;
851:
852: x_parameters := 'ERROR_STRING='||SQLERRM||'#XDP#';
853: XDP_ERRORS_PKG.Set_Message(
854: p_object_type => 'FA',