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.CLN_PO_SYNC_CAT_PKG dependencies on FND_MESSAGE

Line 62: FND_MESSAGE.SET_NAME('CLN','CLN_G_RET_MSG_SUCCESS');

58: --l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');
59:
60: -- Initialize API return status to success
61: x_return_status := 'S';
62: FND_MESSAGE.SET_NAME('CLN','CLN_G_RET_MSG_SUCCESS');
63: x_msg_data := FND_MESSAGE.GET;
64:
65: IF (l_Debug_Level <= 2) THEN
66: cln_debug_pub.Add('ENTERING PROCESS_HEADER', 2);

Line 63: x_msg_data := FND_MESSAGE.GET;

59:
60: -- Initialize API return status to success
61: x_return_status := 'S';
62: FND_MESSAGE.SET_NAME('CLN','CLN_G_RET_MSG_SUCCESS');
63: x_msg_data := FND_MESSAGE.GET;
64:
65: IF (l_Debug_Level <= 2) THEN
66: cln_debug_pub.Add('ENTERING PROCESS_HEADER', 2);
67: END IF;

Line 107: FND_MESSAGE.SET_NAME('CLN','CLN_INVALID_TXN_CODE');

103: cln_debug_pub.Add('Invalid Transaction Code - ' || l_ctg_sync_id, 1);
104: END IF;
105:
106: -- Invalid Transaction Code - "CODE"
107: FND_MESSAGE.SET_NAME('CLN','CLN_INVALID_TXN_CODE');
108: FND_MESSAGE.SET_TOKEN('CODE', l_ctg_sync_id);
109: x_msg_data := FND_MESSAGE.GET;
110: RAISE_UPDATE_COLLABORATION(
111: x_return_status => l_return_status,

Line 108: FND_MESSAGE.SET_TOKEN('CODE', l_ctg_sync_id);

104: END IF;
105:
106: -- Invalid Transaction Code - "CODE"
107: FND_MESSAGE.SET_NAME('CLN','CLN_INVALID_TXN_CODE');
108: FND_MESSAGE.SET_TOKEN('CODE', l_ctg_sync_id);
109: x_msg_data := FND_MESSAGE.GET;
110: RAISE_UPDATE_COLLABORATION(
111: x_return_status => l_return_status,
112: x_msg_data => l_return_msg,

Line 109: x_msg_data := FND_MESSAGE.GET;

105:
106: -- Invalid Transaction Code - "CODE"
107: FND_MESSAGE.SET_NAME('CLN','CLN_INVALID_TXN_CODE');
108: FND_MESSAGE.SET_TOKEN('CODE', l_ctg_sync_id);
109: x_msg_data := FND_MESSAGE.GET;
110: RAISE_UPDATE_COLLABORATION(
111: x_return_status => l_return_status,
112: x_msg_data => l_return_msg,
113: p_ref_id => p_app_ref_id,

Line 173: FND_MESSAGE.SET_NAME('CLN','CLN_DOCUMENT_PROCESSED');

169: RETURN;
170: END;
171:
172: -- Update the collaboration
173: FND_MESSAGE.SET_NAME('CLN','CLN_DOCUMENT_PROCESSED');
174: -- Document Processed
175: l_msg_text := FND_MESSAGE.GET;
176: IF (l_Debug_Level <= 1) THEN
177: cln_debug_pub.Add('l_msg_text:' || l_msg_text, 1);

Line 175: l_msg_text := FND_MESSAGE.GET;

171:
172: -- Update the collaboration
173: FND_MESSAGE.SET_NAME('CLN','CLN_DOCUMENT_PROCESSED');
174: -- Document Processed
175: l_msg_text := FND_MESSAGE.GET;
176: IF (l_Debug_Level <= 1) THEN
177: cln_debug_pub.Add('l_msg_text:' || l_msg_text, 1);
178: END IF;
179:

Line 394: FND_MESSAGE.SET_NAME('CLN','CLN_G_RET_MSG_SUCCESS');

390: --l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');
391:
392: -- Initialize API return status to success
393: x_return_status := 'S';
394: FND_MESSAGE.SET_NAME('CLN','CLN_G_RET_MSG_SUCCESS');
395: x_msg_data := FND_MESSAGE.GET;
396:
397: IF (l_Debug_Level <= 2) THEN
398: cln_debug_pub.Add('ENTERING PROCESS_LINE', 2);

Line 395: x_msg_data := FND_MESSAGE.GET;

391:
392: -- Initialize API return status to success
393: x_return_status := 'S';
394: FND_MESSAGE.SET_NAME('CLN','CLN_G_RET_MSG_SUCCESS');
395: x_msg_data := FND_MESSAGE.GET;
396:
397: IF (l_Debug_Level <= 2) THEN
398: cln_debug_pub.Add('ENTERING PROCESS_LINE', 2);
399: END IF;

Line 464: FND_MESSAGE.SET_NAME('CLN','CLN_DUPLICATE_ITEM');

460: x_line_num := l_line_num;
461:
462: /****** Need not throw error as per bug 3430538
463: -- Duplicate Item in the Catalog: ITEM UOM - CODE
464: FND_MESSAGE.SET_NAME('CLN','CLN_DUPLICATE_ITEM');
465: FND_MESSAGE.SET_TOKEN('ITEM', p_item);
466: FND_MESSAGE.SET_TOKEN('CODE', l_uom_code);
467: x_msg_data := FND_MESSAGE.GET;
468: IF (l_Debug_Level <= 1) THEN

Line 465: FND_MESSAGE.SET_TOKEN('ITEM', p_item);

461:
462: /****** Need not throw error as per bug 3430538
463: -- Duplicate Item in the Catalog: ITEM UOM - CODE
464: FND_MESSAGE.SET_NAME('CLN','CLN_DUPLICATE_ITEM');
465: FND_MESSAGE.SET_TOKEN('ITEM', p_item);
466: FND_MESSAGE.SET_TOKEN('CODE', l_uom_code);
467: x_msg_data := FND_MESSAGE.GET;
468: IF (l_Debug_Level <= 1) THEN
469: cln_debug_pub.Add('x_msg_data:' || x_msg_data, 1);

Line 466: FND_MESSAGE.SET_TOKEN('CODE', l_uom_code);

462: /****** Need not throw error as per bug 3430538
463: -- Duplicate Item in the Catalog: ITEM UOM - CODE
464: FND_MESSAGE.SET_NAME('CLN','CLN_DUPLICATE_ITEM');
465: FND_MESSAGE.SET_TOKEN('ITEM', p_item);
466: FND_MESSAGE.SET_TOKEN('CODE', l_uom_code);
467: x_msg_data := FND_MESSAGE.GET;
468: IF (l_Debug_Level <= 1) THEN
469: cln_debug_pub.Add('x_msg_data:' || x_msg_data, 1);
470: END IF;

Line 467: x_msg_data := FND_MESSAGE.GET;

463: -- Duplicate Item in the Catalog: ITEM UOM - CODE
464: FND_MESSAGE.SET_NAME('CLN','CLN_DUPLICATE_ITEM');
465: FND_MESSAGE.SET_TOKEN('ITEM', p_item);
466: FND_MESSAGE.SET_TOKEN('CODE', l_uom_code);
467: x_msg_data := FND_MESSAGE.GET;
468: IF (l_Debug_Level <= 1) THEN
469: cln_debug_pub.Add('x_msg_data:' || x_msg_data, 1);
470: END IF;
471:

Line 792: FND_MESSAGE.SET_NAME('CLN','CLN_G_RET_MSG_SUCCESS');

788: --l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');
789:
790: -- Initialize API return status to success
791: x_return_status := 'S';
792: FND_MESSAGE.SET_NAME('CLN','CLN_G_RET_MSG_SUCCESS');
793: x_msg_data := FND_MESSAGE.GET;
794:
795: IF (l_Debug_Level <= 2) THEN
796: cln_debug_pub.Add('ENTERING PROCESS_PRICE_BREAKS', 2);

Line 793: x_msg_data := FND_MESSAGE.GET;

789:
790: -- Initialize API return status to success
791: x_return_status := 'S';
792: FND_MESSAGE.SET_NAME('CLN','CLN_G_RET_MSG_SUCCESS');
793: x_msg_data := FND_MESSAGE.GET;
794:
795: IF (l_Debug_Level <= 2) THEN
796: cln_debug_pub.Add('ENTERING PROCESS_PRICE_BREAKS', 2);
797: END IF;

Line 1052: FND_MESSAGE.SET_NAME('CLN','CLN_PO_CATALOG_SYNC_SUCCESS');

1048:
1049: IF (l_ret_status = 'S') THEN
1050: l_doc_status := 'SUCCESS';
1051: -- Successfully processed product catalog
1052: FND_MESSAGE.SET_NAME('CLN','CLN_PO_CATALOG_SYNC_SUCCESS');
1053: l_description := FND_MESSAGE.GET;
1054: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER12', l_doc_status);
1055: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', l_description);
1056: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER2', '00');

Line 1053: l_description := FND_MESSAGE.GET;

1049: IF (l_ret_status = 'S') THEN
1050: l_doc_status := 'SUCCESS';
1051: -- Successfully processed product catalog
1052: FND_MESSAGE.SET_NAME('CLN','CLN_PO_CATALOG_SYNC_SUCCESS');
1053: l_description := FND_MESSAGE.GET;
1054: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER12', l_doc_status);
1055: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', l_description);
1056: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER2', '00');
1057: ELSE

Line 1065: FND_MESSAGE.SET_NAME('CLN','CLN_PO_CATALOG_SYNC_ERROR');

1061: cln_debug_pub.Add('l_msg_data:' || l_msg_data, 1);
1062: END IF;
1063:
1064: -- Error while processing product catalog
1065: FND_MESSAGE.SET_NAME('CLN','CLN_PO_CATALOG_SYNC_ERROR');
1066: FND_MESSAGE.SET_TOKEN('ERROR', l_msg_data);
1067: l_description := FND_MESSAGE.GET;
1068: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER12', l_doc_status);
1069: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', l_description);

Line 1066: FND_MESSAGE.SET_TOKEN('ERROR', l_msg_data);

1062: END IF;
1063:
1064: -- Error while processing product catalog
1065: FND_MESSAGE.SET_NAME('CLN','CLN_PO_CATALOG_SYNC_ERROR');
1066: FND_MESSAGE.SET_TOKEN('ERROR', l_msg_data);
1067: l_description := FND_MESSAGE.GET;
1068: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER12', l_doc_status);
1069: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', l_description);
1070: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER2', '99');

Line 1067: l_description := FND_MESSAGE.GET;

1063:
1064: -- Error while processing product catalog
1065: FND_MESSAGE.SET_NAME('CLN','CLN_PO_CATALOG_SYNC_ERROR');
1066: FND_MESSAGE.SET_TOKEN('ERROR', l_msg_data);
1067: l_description := FND_MESSAGE.GET;
1068: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER12', l_doc_status);
1069: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', l_description);
1070: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER2', '99');
1071: END IF;

Line 1101: FND_MESSAGE.SET_NAME('CLN','CLN_INVALID_TXN_CODE');

1097: -- Invalid Transaction Code
1098: IF (l_ctg_sync_id IS NULL) OR (l_ctg_sync_id <> 'A'
1099: AND l_ctg_sync_id <> 'U'
1100: AND l_ctg_sync_id <> 'R') THEN
1101: FND_MESSAGE.SET_NAME('CLN','CLN_INVALID_TXN_CODE');
1102: FND_MESSAGE.SET_TOKEN('CODE', l_ctg_sync_id);
1103: l_msg_data := FND_MESSAGE.GET;
1104: IF (l_Debug_Level <= 1) THEN
1105: cln_debug_pub.Add('Invalid Trnsaction Code',1);

Line 1102: FND_MESSAGE.SET_TOKEN('CODE', l_ctg_sync_id);

1098: IF (l_ctg_sync_id IS NULL) OR (l_ctg_sync_id <> 'A'
1099: AND l_ctg_sync_id <> 'U'
1100: AND l_ctg_sync_id <> 'R') THEN
1101: FND_MESSAGE.SET_NAME('CLN','CLN_INVALID_TXN_CODE');
1102: FND_MESSAGE.SET_TOKEN('CODE', l_ctg_sync_id);
1103: l_msg_data := FND_MESSAGE.GET;
1104: IF (l_Debug_Level <= 1) THEN
1105: cln_debug_pub.Add('Invalid Trnsaction Code',1);
1106: END IF;

Line 1103: l_msg_data := FND_MESSAGE.GET;

1099: AND l_ctg_sync_id <> 'U'
1100: AND l_ctg_sync_id <> 'R') THEN
1101: FND_MESSAGE.SET_NAME('CLN','CLN_INVALID_TXN_CODE');
1102: FND_MESSAGE.SET_TOKEN('CODE', l_ctg_sync_id);
1103: l_msg_data := FND_MESSAGE.GET;
1104: IF (l_Debug_Level <= 1) THEN
1105: cln_debug_pub.Add('Invalid Trnsaction Code',1);
1106: END IF;
1107:

Line 1135: FND_MESSAGE.SET_NAME('CLN','CLN_DUPLICATE_ITEM');

1131: IF (l_Debug_Level <= 1) THEN
1132: cln_debug_pub.Add('Duplicate Item Error',1);
1133: END IF;
1134:
1135: FND_MESSAGE.SET_NAME('CLN','CLN_DUPLICATE_ITEM');
1136: l_msg_data := FND_MESSAGE.GET;
1137: CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS(
1138: x_ret_code => l_return_status,
1139: x_ret_desc => l_return_msg,

Line 1136: l_msg_data := FND_MESSAGE.GET;

1132: cln_debug_pub.Add('Duplicate Item Error',1);
1133: END IF;
1134:
1135: FND_MESSAGE.SET_NAME('CLN','CLN_DUPLICATE_ITEM');
1136: l_msg_data := FND_MESSAGE.GET;
1137: CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS(
1138: x_ret_code => l_return_status,
1139: x_ret_desc => l_return_msg,
1140: p_notification_code => 'PC_IN03',

Line 1184: FND_MESSAGE.SET_NAME('CLN','CLN_G_RET_MSG_SUCCESS');

1180: RETURN;
1181: END IF;
1182:
1183: -- Success
1184: FND_MESSAGE.SET_NAME('CLN','CLN_G_RET_MSG_SUCCESS');
1185: l_msg_data := FND_MESSAGE.GET;
1186: CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS(
1187: x_ret_code => l_return_status,
1188: x_ret_desc => l_return_msg,

Line 1185: l_msg_data := FND_MESSAGE.GET;

1181: END IF;
1182:
1183: -- Success
1184: FND_MESSAGE.SET_NAME('CLN','CLN_G_RET_MSG_SUCCESS');
1185: l_msg_data := FND_MESSAGE.GET;
1186: CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS(
1187: x_ret_code => l_return_status,
1188: x_ret_desc => l_return_msg,
1189: p_notification_code => 'PC_IN01',

Line 1820: FND_MESSAGE.SET_NAME('CLN','CLN_OPEN_IF_SUCCESS');-- Imported product catalog

1816: IF (l_Debug_Level <= 1) THEN
1817: cln_debug_pub.Add('l_bpo_number:' || l_bpo_number, 1);
1818: END IF;
1819:
1820: FND_MESSAGE.SET_NAME('CLN','CLN_OPEN_IF_SUCCESS');-- Imported product catalog
1821: l_msg_data := FND_MESSAGE.GET;
1822: RAISE_UPDATE_COLLABORATION(
1823: x_return_status => l_return_status,
1824: x_msg_data => l_return_msg,

Line 1821: l_msg_data := FND_MESSAGE.GET;

1817: cln_debug_pub.Add('l_bpo_number:' || l_bpo_number, 1);
1818: END IF;
1819:
1820: FND_MESSAGE.SET_NAME('CLN','CLN_OPEN_IF_SUCCESS');-- Imported product catalog
1821: l_msg_data := FND_MESSAGE.GET;
1822: RAISE_UPDATE_COLLABORATION(
1823: x_return_status => l_return_status,
1824: x_msg_data => l_return_msg,
1825: p_ref_id => l_app_ref_id,

Line 1835: FND_MESSAGE.SET_NAME('CLN','CLN_OPEN_IF_ERROR');

1831: IF l_return_status <> 'S' THEN
1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1833: END IF;
1834: ELSE
1835: FND_MESSAGE.SET_NAME('CLN','CLN_OPEN_IF_ERROR');
1836: l_msg_data := FND_MESSAGE.GET;
1837: l_error_status := FND_API.G_RET_STS_ERROR;
1838: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER6', l_error_status);
1839: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER7', l_msg_data);

Line 1836: l_msg_data := FND_MESSAGE.GET;

1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1833: END IF;
1834: ELSE
1835: FND_MESSAGE.SET_NAME('CLN','CLN_OPEN_IF_ERROR');
1836: l_msg_data := FND_MESSAGE.GET;
1837: l_error_status := FND_API.G_RET_STS_ERROR;
1838: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER6', l_error_status);
1839: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER7', l_msg_data);
1840: RAISE_UPDATE_COLLABORATION(

Line 1989: FND_MESSAGE.SET_NAME('CLN','CLN_CH_EVENT_RAISED');

1985:
1986: -- Initialize API return status to success
1987: x_return_status := FND_API.G_RET_STS_SUCCESS;
1988:
1989: FND_MESSAGE.SET_NAME('CLN','CLN_CH_EVENT_RAISED');
1990: FND_MESSAGE.SET_TOKEN('EVENT','Update');
1991: x_msg_data := FND_MESSAGE.GET;
1992:
1993: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

Line 1990: FND_MESSAGE.SET_TOKEN('EVENT','Update');

1986: -- Initialize API return status to success
1987: x_return_status := FND_API.G_RET_STS_SUCCESS;
1988:
1989: FND_MESSAGE.SET_NAME('CLN','CLN_CH_EVENT_RAISED');
1990: FND_MESSAGE.SET_TOKEN('EVENT','Update');
1991: x_msg_data := FND_MESSAGE.GET;
1992:
1993: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
1994:

Line 1991: x_msg_data := FND_MESSAGE.GET;

1987: x_return_status := FND_API.G_RET_STS_SUCCESS;
1988:
1989: FND_MESSAGE.SET_NAME('CLN','CLN_CH_EVENT_RAISED');
1990: FND_MESSAGE.SET_TOKEN('EVENT','Update');
1991: x_msg_data := FND_MESSAGE.GET;
1992:
1993: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
1994:
1995: IF (l_Debug_Level <= 1) THEN

Line 2105: FND_MESSAGE.SET_NAME('CLN', 'CLN_G_RET_MSG_SUCCESS');

2101:
2102:
2103: -- Initialize API return status to success
2104: x_return_status := FND_API.G_RET_STS_SUCCESS;
2105: FND_MESSAGE.SET_NAME('CLN', 'CLN_G_RET_MSG_SUCCESS');
2106: x_msg_data := FND_MESSAGE.GET;
2107:
2108:
2109: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

Line 2106: x_msg_data := FND_MESSAGE.GET;

2102:
2103: -- Initialize API return status to success
2104: x_return_status := FND_API.G_RET_STS_SUCCESS;
2105: FND_MESSAGE.SET_NAME('CLN', 'CLN_G_RET_MSG_SUCCESS');
2106: x_msg_data := FND_MESSAGE.GET;
2107:
2108:
2109: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
2110: