DBA Data[Home] [Help]

APPS.CLN_SYNC_ITEM_PKG dependencies on FND_MESSAGE

Line 210: FND_MESSAGE.SET_NAME('CLN','CLN_CH_SYNC_ITEMS_CONSUMED');

206: -- Initialize API return status to success
207: x_return_status := FND_API.G_RET_STS_SUCCESS;
208: l_msg_data := 'XML Gateway successfully consumes SYNC ITEM inbound document';
209:
210: FND_MESSAGE.SET_NAME('CLN','CLN_CH_SYNC_ITEMS_CONSUMED');
211: x_msg_data := FND_MESSAGE.GET;
212:
213: -- get a unique key for set process id based on which the concurrent program will
214: -- select the rows from the interface table and import them

Line 211: x_msg_data := FND_MESSAGE.GET;

207: x_return_status := FND_API.G_RET_STS_SUCCESS;
208: l_msg_data := 'XML Gateway successfully consumes SYNC ITEM inbound document';
209:
210: FND_MESSAGE.SET_NAME('CLN','CLN_CH_SYNC_ITEMS_CONSUMED');
211: x_msg_data := FND_MESSAGE.GET;
212:
213: -- get a unique key for set process id based on which the concurrent program will
214: -- select the rows from the interface table and import them
215: -- If the inventory folks come up with sequence..we haveto replace this

Line 293: FND_MESSAGE.SET_NAME('CLN','CLN_CH_INCORRECT_TP_DETAILS');

289:
290: EXCEPTION
291: WHEN NO_DATA_FOUND THEN
292: l_msg_data :='ERROR : Incorrect Trading Partner Details';
293: FND_MESSAGE.SET_NAME('CLN','CLN_CH_INCORRECT_TP_DETAILS');
294: x_msg_data := FND_MESSAGE.GET;
295: RAISE FND_API.G_EXC_ERROR;
296: END;
297:

Line 294: x_msg_data := FND_MESSAGE.GET;

290: EXCEPTION
291: WHEN NO_DATA_FOUND THEN
292: l_msg_data :='ERROR : Incorrect Trading Partner Details';
293: FND_MESSAGE.SET_NAME('CLN','CLN_CH_INCORRECT_TP_DETAILS');
294: x_msg_data := FND_MESSAGE.GET;
295: RAISE FND_API.G_EXC_ERROR;
296: END;
297:
298: -- get a unique key for raising update collaboration event.

Line 422: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ITEM_DETAILS');

418: -- Initialize API return status to success
419: x_return_status := FND_API.G_RET_STS_SUCCESS;
420: l_msg_data := 'Item Details recorded in the collaboration history';
421:
422: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ITEM_DETAILS');
423: x_msg_data := FND_MESSAGE.GET;
424:
425: -- get a unique key for raising add collaboration event.
426: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

Line 423: x_msg_data := FND_MESSAGE.GET;

419: x_return_status := FND_API.G_RET_STS_SUCCESS;
420: l_msg_data := 'Item Details recorded in the collaboration history';
421:
422: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ITEM_DETAILS');
423: x_msg_data := FND_MESSAGE.GET;
424:
425: -- get a unique key for raising add collaboration event.
426: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
427:

Line 460: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ITEM_DELETION');

456: IF (l_Debug_Level <= 1) THEN
457: cln_debug_pub.Add('Item Marked For deletion : Item Number ='||p_item_number,1);
458: END IF;
459:
460: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ITEM_DELETION');
461: FND_MESSAGE.SET_TOKEN('ITEMNUM',p_item_number);
462: l_dtl_msg := FND_MESSAGE.GET;
463:
464: l_reference1 := 'Sync Ind: Delete';

Line 461: FND_MESSAGE.SET_TOKEN('ITEMNUM',p_item_number);

457: cln_debug_pub.Add('Item Marked For deletion : Item Number ='||p_item_number,1);
458: END IF;
459:
460: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ITEM_DELETION');
461: FND_MESSAGE.SET_TOKEN('ITEMNUM',p_item_number);
462: l_dtl_msg := FND_MESSAGE.GET;
463:
464: l_reference1 := 'Sync Ind: Delete';
465: x_notification_code := 'SYN_ITM02';

Line 462: l_dtl_msg := FND_MESSAGE.GET;

458: END IF;
459:
460: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ITEM_DELETION');
461: FND_MESSAGE.SET_TOKEN('ITEMNUM',p_item_number);
462: l_dtl_msg := FND_MESSAGE.GET;
463:
464: l_reference1 := 'Sync Ind: Delete';
465: x_notification_code := 'SYN_ITM02';
466:

Line 476: FND_MESSAGE.SET_NAME('CLN','CLN_CH_INCORRECT_SYNC_IND');

472: ELSIF (p_sync_indicator = 'C') THEN
473: l_reference1 := 'Sync Ind:'||p_sync_indicator;
474: ELSE
475: l_msg_data :='Unknown SYNC Indicator - '||p_sync_indicator;
476: FND_MESSAGE.SET_NAME('CLN','CLN_CH_INCORRECT_SYNC_IND');
477: FND_MESSAGE.SET_TOKEN('IND',p_sync_indicator);
478: FND_MESSAGE.SET_TOKEN('SUPNAME',p_supplier_name);
479: FND_MESSAGE.SET_TOKEN('ITEMNO',p_item_number);
480: x_msg_data := FND_MESSAGE.GET;

Line 477: FND_MESSAGE.SET_TOKEN('IND',p_sync_indicator);

473: l_reference1 := 'Sync Ind:'||p_sync_indicator;
474: ELSE
475: l_msg_data :='Unknown SYNC Indicator - '||p_sync_indicator;
476: FND_MESSAGE.SET_NAME('CLN','CLN_CH_INCORRECT_SYNC_IND');
477: FND_MESSAGE.SET_TOKEN('IND',p_sync_indicator);
478: FND_MESSAGE.SET_TOKEN('SUPNAME',p_supplier_name);
479: FND_MESSAGE.SET_TOKEN('ITEMNO',p_item_number);
480: x_msg_data := FND_MESSAGE.GET;
481:

Line 478: FND_MESSAGE.SET_TOKEN('SUPNAME',p_supplier_name);

474: ELSE
475: l_msg_data :='Unknown SYNC Indicator - '||p_sync_indicator;
476: FND_MESSAGE.SET_NAME('CLN','CLN_CH_INCORRECT_SYNC_IND');
477: FND_MESSAGE.SET_TOKEN('IND',p_sync_indicator);
478: FND_MESSAGE.SET_TOKEN('SUPNAME',p_supplier_name);
479: FND_MESSAGE.SET_TOKEN('ITEMNO',p_item_number);
480: x_msg_data := FND_MESSAGE.GET;
481:
482: l_cln_ch_parameters := wf_parameter_list_t();

Line 479: FND_MESSAGE.SET_TOKEN('ITEMNO',p_item_number);

475: l_msg_data :='Unknown SYNC Indicator - '||p_sync_indicator;
476: FND_MESSAGE.SET_NAME('CLN','CLN_CH_INCORRECT_SYNC_IND');
477: FND_MESSAGE.SET_TOKEN('IND',p_sync_indicator);
478: FND_MESSAGE.SET_TOKEN('SUPNAME',p_supplier_name);
479: FND_MESSAGE.SET_TOKEN('ITEMNO',p_item_number);
480: x_msg_data := FND_MESSAGE.GET;
481:
482: l_cln_ch_parameters := wf_parameter_list_t();
483:

Line 480: x_msg_data := FND_MESSAGE.GET;

476: FND_MESSAGE.SET_NAME('CLN','CLN_CH_INCORRECT_SYNC_IND');
477: FND_MESSAGE.SET_TOKEN('IND',p_sync_indicator);
478: FND_MESSAGE.SET_TOKEN('SUPNAME',p_supplier_name);
479: FND_MESSAGE.SET_TOKEN('ITEMNO',p_item_number);
480: x_msg_data := FND_MESSAGE.GET;
481:
482: l_cln_ch_parameters := wf_parameter_list_t();
483:
484: IF (l_Debug_Level <= 1) THEN

Line 542: FND_MESSAGE.SET_NAME('CLN','CLN_CH_NEW_ITEM_REVISION');

538: IF (l_Debug_Level <= 1) THEN
539: cln_debug_pub.Add('Item with new Revision : Item Number ='||p_item_number,1);
540: END IF;
541:
542: FND_MESSAGE.SET_NAME('CLN','CLN_CH_NEW_ITEM_REVISION');
543: FND_MESSAGE.SET_TOKEN('ITEMNUM',p_item_number);
544: l_dtl_msg := FND_MESSAGE.GET;
545:
546: IF(p_new_revision_flag = 'N')THEN

Line 543: FND_MESSAGE.SET_TOKEN('ITEMNUM',p_item_number);

539: cln_debug_pub.Add('Item with new Revision : Item Number ='||p_item_number,1);
540: END IF;
541:
542: FND_MESSAGE.SET_NAME('CLN','CLN_CH_NEW_ITEM_REVISION');
543: FND_MESSAGE.SET_TOKEN('ITEMNUM',p_item_number);
544: l_dtl_msg := FND_MESSAGE.GET;
545:
546: IF(p_new_revision_flag = 'N')THEN
547: p_new_revision_flag := 'Y';

Line 544: l_dtl_msg := FND_MESSAGE.GET;

540: END IF;
541:
542: FND_MESSAGE.SET_NAME('CLN','CLN_CH_NEW_ITEM_REVISION');
543: FND_MESSAGE.SET_TOKEN('ITEMNUM',p_item_number);
544: l_dtl_msg := FND_MESSAGE.GET;
545:
546: IF(p_new_revision_flag = 'N')THEN
547: p_new_revision_flag := 'Y';
548:

Line 831: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');

827: WHEN OTHERS THEN
828: l_error_code :=SQLCODE;
829: l_error_msg :=SQLERRM;
830: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
831: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
832: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
833: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
834: x_msg_data :=FND_MESSAGE.GET;
835: l_msg_data :='Unexpected Error in ERROR_HANDLER -'||l_error_code||' : '||l_error_msg;

Line 832: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);

828: l_error_code :=SQLCODE;
829: l_error_msg :=SQLERRM;
830: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
831: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
832: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
833: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
834: x_msg_data :=FND_MESSAGE.GET;
835: l_msg_data :='Unexpected Error in ERROR_HANDLER -'||l_error_code||' : '||l_error_msg;
836: IF (l_Debug_Level <= 6) THEN

Line 833: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);

829: l_error_msg :=SQLERRM;
830: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
831: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
832: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
833: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
834: x_msg_data :=FND_MESSAGE.GET;
835: l_msg_data :='Unexpected Error in ERROR_HANDLER -'||l_error_code||' : '||l_error_msg;
836: IF (l_Debug_Level <= 6) THEN
837: cln_debug_pub.Add(l_msg_data,6);

Line 834: x_msg_data :=FND_MESSAGE.GET;

830: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
831: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
832: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
833: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
834: x_msg_data :=FND_MESSAGE.GET;
835: l_msg_data :='Unexpected Error in ERROR_HANDLER -'||l_error_code||' : '||l_error_msg;
836: IF (l_Debug_Level <= 6) THEN
837: cln_debug_pub.Add(l_msg_data,6);
838: END IF;

Line 1056: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');

1052: EXCEPTION
1053: WHEN OTHERS THEN
1054: WF_CORE.CONTEXT('CLN_SYNC_ITEM_PKG', 'XGM_CHECK_STATUS', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
1055:
1056: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');
1057: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);
1058: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);
1059: FND_MESSAGE.SET_TOKEN('ACTIVITY','CHECK_STATUS');
1060:

Line 1057: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);

1053: WHEN OTHERS THEN
1054: WF_CORE.CONTEXT('CLN_SYNC_ITEM_PKG', 'XGM_CHECK_STATUS', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
1055:
1056: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');
1057: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);
1058: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);
1059: FND_MESSAGE.SET_TOKEN('ACTIVITY','CHECK_STATUS');
1060:
1061: -- we are not stopping the process becoz of this error,

Line 1058: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);

1054: WF_CORE.CONTEXT('CLN_SYNC_ITEM_PKG', 'XGM_CHECK_STATUS', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
1055:
1056: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');
1057: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);
1058: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);
1059: FND_MESSAGE.SET_TOKEN('ACTIVITY','CHECK_STATUS');
1060:
1061: -- we are not stopping the process becoz of this error,
1062: -- negative confirm bod is sent out with error occured here

Line 1059: FND_MESSAGE.SET_TOKEN('ACTIVITY','CHECK_STATUS');

1055:
1056: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');
1057: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);
1058: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);
1059: FND_MESSAGE.SET_TOKEN('ACTIVITY','CHECK_STATUS');
1060:
1061: -- we are not stopping the process becoz of this error,
1062: -- negative confirm bod is sent out with error occured here
1063: l_return_status_tp := '99';

Line 1064: l_return_desc_tp := FND_MESSAGE.GET;

1060:
1061: -- we are not stopping the process becoz of this error,
1062: -- negative confirm bod is sent out with error occured here
1063: l_return_status_tp := '99';
1064: l_return_desc_tp := FND_MESSAGE.GET;
1065:
1066: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1067: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1068: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');

Line 1198: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_RQST');

1194:
1195: EXCEPTION
1196: WHEN NO_DATA_FOUND THEN
1197: cln_debug_pub.Add('ERROR : Could not find the details for the Concurrent Request'||l_request_id, 1);
1198: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_RQST');
1199: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
1200: l_msg_data := FND_MESSAGE.GET;
1201: -- default the status code so as to account for it in the collaboration hstry
1202: l_status_code := 'E';

Line 1199: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);

1195: EXCEPTION
1196: WHEN NO_DATA_FOUND THEN
1197: cln_debug_pub.Add('ERROR : Could not find the details for the Concurrent Request'||l_request_id, 1);
1198: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_RQST');
1199: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
1200: l_msg_data := FND_MESSAGE.GET;
1201: -- default the status code so as to account for it in the collaboration hstry
1202: l_status_code := 'E';
1203: l_concurrent_msg := l_msg_data;

Line 1200: l_msg_data := FND_MESSAGE.GET;

1196: WHEN NO_DATA_FOUND THEN
1197: cln_debug_pub.Add('ERROR : Could not find the details for the Concurrent Request'||l_request_id, 1);
1198: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_RQST');
1199: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
1200: l_msg_data := FND_MESSAGE.GET;
1201: -- default the status code so as to account for it in the collaboration hstry
1202: l_status_code := 'E';
1203: l_concurrent_msg := l_msg_data;
1204: END;

Line 1214: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_FAILED');

1210:
1211: --IF (l_concurrent_msg IS NOT NULL) THEN
1212: -- l_update_coll_msg := l_concurrent_msg;
1213: --ELSE
1214: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_FAILED');
1215: FND_MESSAGE.SET_TOKEN('REQNAME','Item Import');
1216: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
1217: l_update_coll_msg := FND_MESSAGE.GET;
1218: --END IF;

Line 1215: FND_MESSAGE.SET_TOKEN('REQNAME','Item Import');

1211: --IF (l_concurrent_msg IS NOT NULL) THEN
1212: -- l_update_coll_msg := l_concurrent_msg;
1213: --ELSE
1214: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_FAILED');
1215: FND_MESSAGE.SET_TOKEN('REQNAME','Item Import');
1216: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
1217: l_update_coll_msg := FND_MESSAGE.GET;
1218: --END IF;
1219: l_return_status_tp := '99';

Line 1216: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);

1212: -- l_update_coll_msg := l_concurrent_msg;
1213: --ELSE
1214: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_FAILED');
1215: FND_MESSAGE.SET_TOKEN('REQNAME','Item Import');
1216: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
1217: l_update_coll_msg := FND_MESSAGE.GET;
1218: --END IF;
1219: l_return_status_tp := '99';
1220: l_return_desc_tp := l_update_coll_msg;

Line 1217: l_update_coll_msg := FND_MESSAGE.GET;

1213: --ELSE
1214: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_FAILED');
1215: FND_MESSAGE.SET_TOKEN('REQNAME','Item Import');
1216: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
1217: l_update_coll_msg := FND_MESSAGE.GET;
1218: --END IF;
1219: l_return_status_tp := '99';
1220: l_return_desc_tp := l_update_coll_msg;
1221: l_notification_code := 'SYN_ITM05';

Line 1273: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_1');

1269: cln_debug_pub.Add('Few items failed to be imported ', 1);
1270: END IF;
1271:
1272: IF (l_update_coll_msg IS NULL) THEN
1273: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_1');
1274: FND_MESSAGE.SET_TOKEN('REQNAME','Item Import');
1275: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
1276: l_update_coll_msg := FND_MESSAGE.GET;
1277: END IF;

Line 1274: FND_MESSAGE.SET_TOKEN('REQNAME','Item Import');

1270: END IF;
1271:
1272: IF (l_update_coll_msg IS NULL) THEN
1273: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_1');
1274: FND_MESSAGE.SET_TOKEN('REQNAME','Item Import');
1275: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
1276: l_update_coll_msg := FND_MESSAGE.GET;
1277: END IF;
1278:

Line 1275: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);

1271:
1272: IF (l_update_coll_msg IS NULL) THEN
1273: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_1');
1274: FND_MESSAGE.SET_TOKEN('REQNAME','Item Import');
1275: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
1276: l_update_coll_msg := FND_MESSAGE.GET;
1277: END IF;
1278:
1279: l_return_desc_tp := l_update_coll_msg;

Line 1276: l_update_coll_msg := FND_MESSAGE.GET;

1272: IF (l_update_coll_msg IS NULL) THEN
1273: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_1');
1274: FND_MESSAGE.SET_TOKEN('REQNAME','Item Import');
1275: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
1276: l_update_coll_msg := FND_MESSAGE.GET;
1277: END IF;
1278:
1279: l_return_desc_tp := l_update_coll_msg;
1280: l_process_each_row_for_errors := 'TRUE';

Line 1283: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_2');

1279: l_return_desc_tp := l_update_coll_msg;
1280: l_process_each_row_for_errors := 'TRUE';
1281: ELSE
1282: IF (l_update_coll_msg IS NULL) THEN
1283: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_2');
1284: FND_MESSAGE.SET_TOKEN('REQNAME','Item Import');
1285: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
1286: l_update_coll_msg := FND_MESSAGE.GET;
1287: END IF;

Line 1284: FND_MESSAGE.SET_TOKEN('REQNAME','Item Import');

1280: l_process_each_row_for_errors := 'TRUE';
1281: ELSE
1282: IF (l_update_coll_msg IS NULL) THEN
1283: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_2');
1284: FND_MESSAGE.SET_TOKEN('REQNAME','Item Import');
1285: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
1286: l_update_coll_msg := FND_MESSAGE.GET;
1287: END IF;
1288:

Line 1285: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);

1281: ELSE
1282: IF (l_update_coll_msg IS NULL) THEN
1283: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_2');
1284: FND_MESSAGE.SET_TOKEN('REQNAME','Item Import');
1285: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
1286: l_update_coll_msg := FND_MESSAGE.GET;
1287: END IF;
1288:
1289: l_return_desc_tp := l_update_coll_msg;

Line 1286: l_update_coll_msg := FND_MESSAGE.GET;

1282: IF (l_update_coll_msg IS NULL) THEN
1283: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_2');
1284: FND_MESSAGE.SET_TOKEN('REQNAME','Item Import');
1285: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
1286: l_update_coll_msg := FND_MESSAGE.GET;
1287: END IF;
1288:
1289: l_return_desc_tp := l_update_coll_msg;
1290: l_process_each_row_for_errors := 'FALSE';

Line 1447: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');

1443: END IF;
1444:
1445: WF_CORE.CONTEXT('CLN_SYNC_ITEM_PKG', 'ITEM_IMPORT_STATUS_HANDLER', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
1446:
1447: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');
1448: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);
1449: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);
1450: FND_MESSAGE.SET_TOKEN('ACTIVITY','STATUS_HANDLER');
1451:

Line 1448: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);

1444:
1445: WF_CORE.CONTEXT('CLN_SYNC_ITEM_PKG', 'ITEM_IMPORT_STATUS_HANDLER', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
1446:
1447: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');
1448: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);
1449: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);
1450: FND_MESSAGE.SET_TOKEN('ACTIVITY','STATUS_HANDLER');
1451:
1452: -- we are not stopping the process becoz of this error,

Line 1449: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);

1445: WF_CORE.CONTEXT('CLN_SYNC_ITEM_PKG', 'ITEM_IMPORT_STATUS_HANDLER', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
1446:
1447: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');
1448: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);
1449: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);
1450: FND_MESSAGE.SET_TOKEN('ACTIVITY','STATUS_HANDLER');
1451:
1452: -- we are not stopping the process becoz of this error,
1453: -- negative confirm bod is sent out with error occured here

Line 1450: FND_MESSAGE.SET_TOKEN('ACTIVITY','STATUS_HANDLER');

1446:
1447: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');
1448: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);
1449: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);
1450: FND_MESSAGE.SET_TOKEN('ACTIVITY','STATUS_HANDLER');
1451:
1452: -- we are not stopping the process becoz of this error,
1453: -- negative confirm bod is sent out with error occured here
1454: l_return_status_tp := '99';

Line 1455: l_return_desc_tp := FND_MESSAGE.GET;

1451:
1452: -- we are not stopping the process becoz of this error,
1453: -- negative confirm bod is sent out with error occured here
1454: l_return_status_tp := '99';
1455: l_return_desc_tp := FND_MESSAGE.GET;
1456:
1457: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1458: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1459: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );

Line 1582: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COST_TYPE_NS');

1578: END IF;
1579:
1580: /*
1581: IF (l_cost_type IS NULL) THEN
1582: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COST_TYPE_NS');
1583: l_return_desc_tp := FND_MESSAGE.GET;
1584: l_check := 'ERROR';
1585: END IF;
1586: */

Line 1583: l_return_desc_tp := FND_MESSAGE.GET;

1579:
1580: /*
1581: IF (l_cost_type IS NULL) THEN
1582: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COST_TYPE_NS');
1583: l_return_desc_tp := FND_MESSAGE.GET;
1584: l_check := 'ERROR';
1585: END IF;
1586: */
1587:

Line 1613: FND_MESSAGE.SET_NAME('CLN','CLN_CH_RESOURCEID_NF');

1609:
1610: EXCEPTION
1611: WHEN NO_DATA_FOUND THEN
1612: cln_debug_pub.Add('ERROR : Could not find the resource id for the particular cost_element_id and organization', 1);
1613: FND_MESSAGE.SET_NAME('CLN','CLN_CH_RESOURCEID_NF');
1614: l_return_desc_tp := FND_MESSAGE.GET;
1615: l_check := 'ERROR';
1616: END;
1617:

Line 1614: l_return_desc_tp := FND_MESSAGE.GET;

1610: EXCEPTION
1611: WHEN NO_DATA_FOUND THEN
1612: cln_debug_pub.Add('ERROR : Could not find the resource id for the particular cost_element_id and organization', 1);
1613: FND_MESSAGE.SET_NAME('CLN','CLN_CH_RESOURCEID_NF');
1614: l_return_desc_tp := FND_MESSAGE.GET;
1615: l_check := 'ERROR';
1616: END;
1617:
1618: IF (l_check = 'ERROR') THEN

Line 1846: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');

1842: END IF;
1843:
1844: WF_CORE.CONTEXT('CLN_SYNC_ITEM_PKG', 'SETUP_CST_INTERFACE_TABLE', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
1845:
1846: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');
1847: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);
1848: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);
1849: FND_MESSAGE.SET_TOKEN('ACTIVITY','SET_CST_INTERFACE_TABLE');
1850:

Line 1847: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);

1843:
1844: WF_CORE.CONTEXT('CLN_SYNC_ITEM_PKG', 'SETUP_CST_INTERFACE_TABLE', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
1845:
1846: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');
1847: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);
1848: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);
1849: FND_MESSAGE.SET_TOKEN('ACTIVITY','SET_CST_INTERFACE_TABLE');
1850:
1851: -- we are not stopping the process becoz of this error,

Line 1848: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);

1844: WF_CORE.CONTEXT('CLN_SYNC_ITEM_PKG', 'SETUP_CST_INTERFACE_TABLE', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
1845:
1846: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');
1847: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);
1848: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);
1849: FND_MESSAGE.SET_TOKEN('ACTIVITY','SET_CST_INTERFACE_TABLE');
1850:
1851: -- we are not stopping the process becoz of this error,
1852: -- negative confirm bod is sent out with error occured here

Line 1849: FND_MESSAGE.SET_TOKEN('ACTIVITY','SET_CST_INTERFACE_TABLE');

1845:
1846: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');
1847: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);
1848: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);
1849: FND_MESSAGE.SET_TOKEN('ACTIVITY','SET_CST_INTERFACE_TABLE');
1850:
1851: -- we are not stopping the process becoz of this error,
1852: -- negative confirm bod is sent out with error occured here
1853: l_return_status_tp := '99';

Line 1854: l_return_desc_tp := FND_MESSAGE.GET;

1850:
1851: -- we are not stopping the process becoz of this error,
1852: -- negative confirm bod is sent out with error occured here
1853: l_return_status_tp := '99';
1854: l_return_desc_tp := FND_MESSAGE.GET;
1855:
1856: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1857: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1858: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );

Line 2063: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_RQST');

2059:
2060: EXCEPTION
2061: WHEN NO_DATA_FOUND THEN
2062: cln_debug_pub.Add('ERROR : Could not find the details for the Concurrent Request'||l_request_id, 1);
2063: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_RQST');
2064: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
2065: l_msg_data := FND_MESSAGE.GET;
2066: l_status_code := 'E'; -- so that this case should be considered.
2067: l_concurrent_msg := l_msg_data;

Line 2064: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);

2060: EXCEPTION
2061: WHEN NO_DATA_FOUND THEN
2062: cln_debug_pub.Add('ERROR : Could not find the details for the Concurrent Request'||l_request_id, 1);
2063: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_RQST');
2064: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
2065: l_msg_data := FND_MESSAGE.GET;
2066: l_status_code := 'E'; -- so that this case should be considered.
2067: l_concurrent_msg := l_msg_data;
2068: END;

Line 2065: l_msg_data := FND_MESSAGE.GET;

2061: WHEN NO_DATA_FOUND THEN
2062: cln_debug_pub.Add('ERROR : Could not find the details for the Concurrent Request'||l_request_id, 1);
2063: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_RQST');
2064: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
2065: l_msg_data := FND_MESSAGE.GET;
2066: l_status_code := 'E'; -- so that this case should be considered.
2067: l_concurrent_msg := l_msg_data;
2068: END;
2069:

Line 2078: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_FAILED');

2074:
2075: --IF (l_concurrent_msg IS NOT NULL) THEN
2076: -- l_update_coll_msg := l_concurrent_msg;
2077: --ELSE
2078: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_FAILED');
2079: FND_MESSAGE.SET_TOKEN('REQNAME','Cost Import');
2080: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
2081: l_update_coll_msg := FND_MESSAGE.GET;
2082: --END IF;

Line 2079: FND_MESSAGE.SET_TOKEN('REQNAME','Cost Import');

2075: --IF (l_concurrent_msg IS NOT NULL) THEN
2076: -- l_update_coll_msg := l_concurrent_msg;
2077: --ELSE
2078: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_FAILED');
2079: FND_MESSAGE.SET_TOKEN('REQNAME','Cost Import');
2080: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
2081: l_update_coll_msg := FND_MESSAGE.GET;
2082: --END IF;
2083: l_return_status_tp := '99';

Line 2080: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);

2076: -- l_update_coll_msg := l_concurrent_msg;
2077: --ELSE
2078: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_FAILED');
2079: FND_MESSAGE.SET_TOKEN('REQNAME','Cost Import');
2080: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
2081: l_update_coll_msg := FND_MESSAGE.GET;
2082: --END IF;
2083: l_return_status_tp := '99';
2084: l_return_desc_tp := l_update_coll_msg;

Line 2081: l_update_coll_msg := FND_MESSAGE.GET;

2077: --ELSE
2078: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_FAILED');
2079: FND_MESSAGE.SET_TOKEN('REQNAME','Cost Import');
2080: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
2081: l_update_coll_msg := FND_MESSAGE.GET;
2082: --END IF;
2083: l_return_status_tp := '99';
2084: l_return_desc_tp := l_update_coll_msg;
2085:

Line 2112: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_1');

2108: IF (l_count_failed_rows > 0) THEN
2109: IF (l_Debug_Level <= 1) THEN
2110: cln_debug_pub.Add('Few items failed to be imported ', 1);
2111: END IF;
2112: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_1');
2113: FND_MESSAGE.SET_TOKEN('REQNAME','Cost Import');
2114: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
2115: l_update_coll_msg := FND_MESSAGE.GET;
2116: l_return_desc_tp := l_update_coll_msg;

Line 2113: FND_MESSAGE.SET_TOKEN('REQNAME','Cost Import');

2109: IF (l_Debug_Level <= 1) THEN
2110: cln_debug_pub.Add('Few items failed to be imported ', 1);
2111: END IF;
2112: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_1');
2113: FND_MESSAGE.SET_TOKEN('REQNAME','Cost Import');
2114: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
2115: l_update_coll_msg := FND_MESSAGE.GET;
2116: l_return_desc_tp := l_update_coll_msg;
2117: l_process_each_row_for_errors := 'TRUE';

Line 2114: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);

2110: cln_debug_pub.Add('Few items failed to be imported ', 1);
2111: END IF;
2112: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_1');
2113: FND_MESSAGE.SET_TOKEN('REQNAME','Cost Import');
2114: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
2115: l_update_coll_msg := FND_MESSAGE.GET;
2116: l_return_desc_tp := l_update_coll_msg;
2117: l_process_each_row_for_errors := 'TRUE';
2118: ELSE

Line 2115: l_update_coll_msg := FND_MESSAGE.GET;

2111: END IF;
2112: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_1');
2113: FND_MESSAGE.SET_TOKEN('REQNAME','Cost Import');
2114: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
2115: l_update_coll_msg := FND_MESSAGE.GET;
2116: l_return_desc_tp := l_update_coll_msg;
2117: l_process_each_row_for_errors := 'TRUE';
2118: ELSE
2119: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_2');

Line 2119: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_2');

2115: l_update_coll_msg := FND_MESSAGE.GET;
2116: l_return_desc_tp := l_update_coll_msg;
2117: l_process_each_row_for_errors := 'TRUE';
2118: ELSE
2119: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_2');
2120: FND_MESSAGE.SET_TOKEN('REQNAME','Cost Import');
2121: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
2122: l_update_coll_msg := FND_MESSAGE.GET;
2123: l_return_desc_tp := l_update_coll_msg;

Line 2120: FND_MESSAGE.SET_TOKEN('REQNAME','Cost Import');

2116: l_return_desc_tp := l_update_coll_msg;
2117: l_process_each_row_for_errors := 'TRUE';
2118: ELSE
2119: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_2');
2120: FND_MESSAGE.SET_TOKEN('REQNAME','Cost Import');
2121: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
2122: l_update_coll_msg := FND_MESSAGE.GET;
2123: l_return_desc_tp := l_update_coll_msg;
2124: l_process_each_row_for_errors := 'FALSE';

Line 2121: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);

2117: l_process_each_row_for_errors := 'TRUE';
2118: ELSE
2119: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_2');
2120: FND_MESSAGE.SET_TOKEN('REQNAME','Cost Import');
2121: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
2122: l_update_coll_msg := FND_MESSAGE.GET;
2123: l_return_desc_tp := l_update_coll_msg;
2124: l_process_each_row_for_errors := 'FALSE';
2125:

Line 2122: l_update_coll_msg := FND_MESSAGE.GET;

2118: ELSE
2119: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_SUCCESS_2');
2120: FND_MESSAGE.SET_TOKEN('REQNAME','Cost Import');
2121: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
2122: l_update_coll_msg := FND_MESSAGE.GET;
2123: l_return_desc_tp := l_update_coll_msg;
2124: l_process_each_row_for_errors := 'FALSE';
2125:
2126: END IF;

Line 2275: FND_MESSAGE.SET_NAME('CLN','CLN_CH_MFG_DTLS_NF');

2271:
2272: EXCEPTION
2273: WHEN NO_DATA_FOUND THEN
2274: cln_debug_pub.Add('ERROR : Could not find details for the manufacturer',1);
2275: FND_MESSAGE.SET_NAME('CLN','CLN_CH_MFG_DTLS_NF');
2276: l_return_desc_tp := FND_MESSAGE.GET;
2277: l_mfg_details := '99';
2278: END;
2279:

Line 2276: l_return_desc_tp := FND_MESSAGE.GET;

2272: EXCEPTION
2273: WHEN NO_DATA_FOUND THEN
2274: cln_debug_pub.Add('ERROR : Could not find details for the manufacturer',1);
2275: FND_MESSAGE.SET_NAME('CLN','CLN_CH_MFG_DTLS_NF');
2276: l_return_desc_tp := FND_MESSAGE.GET;
2277: l_mfg_details := '99';
2278: END;
2279:
2280:

Line 2387: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');

2383: END IF;
2384:
2385: WF_CORE.CONTEXT('CLN_SYNC_ITEM_PKG', 'UPDATE_COLLB_STATUS', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2386:
2387: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');
2388: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);
2389: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);
2390: FND_MESSAGE.SET_TOKEN('ACTIVITY','STATUS_UPDATE');
2391:

Line 2388: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);

2384:
2385: WF_CORE.CONTEXT('CLN_SYNC_ITEM_PKG', 'UPDATE_COLLB_STATUS', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2386:
2387: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');
2388: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);
2389: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);
2390: FND_MESSAGE.SET_TOKEN('ACTIVITY','STATUS_UPDATE');
2391:
2392: -- we are not stopping the process becoz of this error,

Line 2389: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);

2385: WF_CORE.CONTEXT('CLN_SYNC_ITEM_PKG', 'UPDATE_COLLB_STATUS', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2386:
2387: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');
2388: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);
2389: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);
2390: FND_MESSAGE.SET_TOKEN('ACTIVITY','STATUS_UPDATE');
2391:
2392: -- we are not stopping the process becoz of this error,
2393: -- negative confirm bod is sent out with error occured here

Line 2390: FND_MESSAGE.SET_TOKEN('ACTIVITY','STATUS_UPDATE');

2386:
2387: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');
2388: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);
2389: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);
2390: FND_MESSAGE.SET_TOKEN('ACTIVITY','STATUS_UPDATE');
2391:
2392: -- we are not stopping the process becoz of this error,
2393: -- negative confirm bod is sent out with error occured here
2394: l_return_status_tp := '99';

Line 2395: l_return_desc_tp := FND_MESSAGE.GET;

2391:
2392: -- we are not stopping the process becoz of this error,
2393: -- negative confirm bod is sent out with error occured here
2394: l_return_status_tp := '99';
2395: l_return_desc_tp := FND_MESSAGE.GET;
2396:
2397: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
2398: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
2399: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );

Line 2401: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(FND_MESSAGE.GET);

2397: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
2398: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
2399: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
2400:
2401: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(FND_MESSAGE.GET);
2402:
2403: IF (l_Debug_Level <= 6) THEN
2404: cln_debug_pub.Add('------- ERROR:Exiting UPDATE_COLLB_STATUS API --------- ',6);
2405: END IF;

Line 2533: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_RQST');

2529:
2530: EXCEPTION
2531: WHEN NO_DATA_FOUND THEN
2532: cln_debug_pub.Add('ERROR : Could not find the details for the Concurrent Request'||l_request_id, 1);
2533: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_RQST');
2534: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
2535: l_msg_data := FND_MESSAGE.GET;
2536: l_status_code := 'E'; -- so that this case should be considered.
2537: l_concurrent_msg := l_msg_data;

Line 2534: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);

2530: EXCEPTION
2531: WHEN NO_DATA_FOUND THEN
2532: cln_debug_pub.Add('ERROR : Could not find the details for the Concurrent Request'||l_request_id, 1);
2533: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_RQST');
2534: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
2535: l_msg_data := FND_MESSAGE.GET;
2536: l_status_code := 'E'; -- so that this case should be considered.
2537: l_concurrent_msg := l_msg_data;
2538: END;

Line 2535: l_msg_data := FND_MESSAGE.GET;

2531: WHEN NO_DATA_FOUND THEN
2532: cln_debug_pub.Add('ERROR : Could not find the details for the Concurrent Request'||l_request_id, 1);
2533: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_RQST');
2534: FND_MESSAGE.SET_TOKEN('REQID',l_request_id);
2535: l_msg_data := FND_MESSAGE.GET;
2536: l_status_code := 'E'; -- so that this case should be considered.
2537: l_concurrent_msg := l_msg_data;
2538: END;
2539:

Line 2546: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_FAILED');

2542:
2543: IF (l_concurrent_msg IS NOT NULL) THEN
2544: l_update_coll_msg := l_concurrent_msg;
2545: ELSE
2546: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_FAILED');
2547: FND_MESSAGE.SET_TOKEN('REQNAME','MFG Part Number Import');
2548: l_update_coll_msg := FND_MESSAGE.GET;
2549: END IF;
2550: l_return_status_tp := '99';

Line 2547: FND_MESSAGE.SET_TOKEN('REQNAME','MFG Part Number Import');

2543: IF (l_concurrent_msg IS NOT NULL) THEN
2544: l_update_coll_msg := l_concurrent_msg;
2545: ELSE
2546: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_FAILED');
2547: FND_MESSAGE.SET_TOKEN('REQNAME','MFG Part Number Import');
2548: l_update_coll_msg := FND_MESSAGE.GET;
2549: END IF;
2550: l_return_status_tp := '99';
2551: l_return_desc_tp := l_update_coll_msg;

Line 2548: l_update_coll_msg := FND_MESSAGE.GET;

2544: l_update_coll_msg := l_concurrent_msg;
2545: ELSE
2546: FND_MESSAGE.SET_NAME('CLN','CLN_CH_CONCURRENT_FAILED');
2547: FND_MESSAGE.SET_TOKEN('REQNAME','MFG Part Number Import');
2548: l_update_coll_msg := FND_MESSAGE.GET;
2549: END IF;
2550: l_return_status_tp := '99';
2551: l_return_desc_tp := l_update_coll_msg;
2552:

Line 2645: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');

2641: END IF;
2642:
2643: WF_CORE.CONTEXT('CLN_SYNC_ITEM_PKG', 'MFG_PARTNUM_STATUS_CHECK', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2644:
2645: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');
2646: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);
2647: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);
2648: FND_MESSAGE.SET_TOKEN('ACTIVITY','MFG_PARTNUM_STATUS_CHECK');
2649:

Line 2646: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);

2642:
2643: WF_CORE.CONTEXT('CLN_SYNC_ITEM_PKG', 'MFG_PARTNUM_STATUS_CHECK', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2644:
2645: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');
2646: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);
2647: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);
2648: FND_MESSAGE.SET_TOKEN('ACTIVITY','MFG_PARTNUM_STATUS_CHECK');
2649:
2650: -- we are not stopping the process becoz of this error,

Line 2647: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);

2643: WF_CORE.CONTEXT('CLN_SYNC_ITEM_PKG', 'MFG_PARTNUM_STATUS_CHECK', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2644:
2645: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');
2646: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);
2647: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);
2648: FND_MESSAGE.SET_TOKEN('ACTIVITY','MFG_PARTNUM_STATUS_CHECK');
2649:
2650: -- we are not stopping the process becoz of this error,
2651: -- negative confirm bod is sent out with error occured here

Line 2648: FND_MESSAGE.SET_TOKEN('ACTIVITY','MFG_PARTNUM_STATUS_CHECK');

2644:
2645: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACTIVITY_ERROR');
2646: FND_MESSAGE.SET_TOKEN('ITMTYPE',p_itemtype);
2647: FND_MESSAGE.SET_TOKEN('ITMKEY',p_itemkey);
2648: FND_MESSAGE.SET_TOKEN('ACTIVITY','MFG_PARTNUM_STATUS_CHECK');
2649:
2650: -- we are not stopping the process becoz of this error,
2651: -- negative confirm bod is sent out with error occured here
2652: l_return_status_tp := '99';

Line 2653: l_return_desc_tp := FND_MESSAGE.GET;

2649:
2650: -- we are not stopping the process becoz of this error,
2651: -- negative confirm bod is sent out with error occured here
2652: l_return_status_tp := '99';
2653: l_return_desc_tp := FND_MESSAGE.GET;
2654:
2655: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
2656: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
2657: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );

Line 2659: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(FND_MESSAGE.GET);

2655: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
2656: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
2657: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
2658:
2659: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(FND_MESSAGE.GET);
2660:
2661: IF (l_Debug_Level <= 6) THEN
2662: cln_debug_pub.Add('------- ERROR:Exiting MFG_PARTNUM_STATUS_CHECK API --------- ',6);
2663: END IF;

Line 2743: FND_MESSAGE.SET_NAME('CLN','CLN_2A12_SYNC_TRANX_COMPLETE');

2739: IF (l_doc_status = 'ERROR') THEN
2740: l_completed_status := 'ERROR';
2741: END IF;
2742:
2743: FND_MESSAGE.SET_NAME('CLN','CLN_2A12_SYNC_TRANX_COMPLETE');
2744: -- 'Sync Item Transaction Completed';
2745: l_update_coll_msg := FND_MESSAGE.GET;
2746:
2747:

Line 2745: l_update_coll_msg := FND_MESSAGE.GET;

2741: END IF;
2742:
2743: FND_MESSAGE.SET_NAME('CLN','CLN_2A12_SYNC_TRANX_COMPLETE');
2744: -- 'Sync Item Transaction Completed';
2745: l_update_coll_msg := FND_MESSAGE.GET;
2746:
2747:
2748: -- generate an event key which is also passed as event key for update collaboration .
2749: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

Line 2839: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ITEM_DETAILS_ROLLED');

2835: -- Initialize API return status to success
2836: x_return_status := FND_API.G_RET_STS_SUCCESS;
2837: l_msg_data := 'Item Details rolled back and recorded in the collaboration history';
2838:
2839: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ITEM_DETAILS_ROLLED');
2840: x_msg_data := FND_MESSAGE.GET;
2841:
2842: ROLLBACK TO CHECK_ITEM_DELETION_PUB;
2843:

Line 2840: x_msg_data := FND_MESSAGE.GET;

2836: x_return_status := FND_API.G_RET_STS_SUCCESS;
2837: l_msg_data := 'Item Details rolled back and recorded in the collaboration history';
2838:
2839: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ITEM_DETAILS_ROLLED');
2840: x_msg_data := FND_MESSAGE.GET;
2841:
2842: ROLLBACK TO CHECK_ITEM_DELETION_PUB;
2843:
2844:

Line 2874: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ITEM_DELETION');

2870: IF (l_Debug_Level <= 1) THEN
2871: cln_debug_pub.Add('Item Marked For deletion : Item Number ='||p_item_number,1);
2872: END IF;
2873:
2874: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ITEM_DELETION');
2875: FND_MESSAGE.SET_TOKEN('ITEMNUM',p_item_number);
2876: l_dtl_msg := FND_MESSAGE.GET;
2877:
2878: l_reference1 := 'Sync Ind: Delete';

Line 2875: FND_MESSAGE.SET_TOKEN('ITEMNUM',p_item_number);

2871: cln_debug_pub.Add('Item Marked For deletion : Item Number ='||p_item_number,1);
2872: END IF;
2873:
2874: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ITEM_DELETION');
2875: FND_MESSAGE.SET_TOKEN('ITEMNUM',p_item_number);
2876: l_dtl_msg := FND_MESSAGE.GET;
2877:
2878: l_reference1 := 'Sync Ind: Delete';
2879: x_notification_code := 'SYN_ITM02';

Line 2876: l_dtl_msg := FND_MESSAGE.GET;

2872: END IF;
2873:
2874: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ITEM_DELETION');
2875: FND_MESSAGE.SET_TOKEN('ITEMNUM',p_item_number);
2876: l_dtl_msg := FND_MESSAGE.GET;
2877:
2878: l_reference1 := 'Sync Ind: Delete';
2879: x_notification_code := 'SYN_ITM02';
2880: