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 WF_ENGINE

Line 1034: l_ret_status := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER6', TRUE);

1030: END IF;
1031:
1032:
1033: -- Should be S for sucess
1034: l_ret_status := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER6', TRUE);
1035: IF (l_Debug_Level <= 1) THEN
1036: cln_debug_pub.Add('l_ret_status:' || l_ret_status, 1);
1037: END IF;
1038:

Line 1039: l_int_hdr_id := to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER9', TRUE));

1035: IF (l_Debug_Level <= 1) THEN
1036: cln_debug_pub.Add('l_ret_status:' || l_ret_status, 1);
1037: END IF;
1038:
1039: l_int_hdr_id := to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER9', TRUE));
1040: IF (l_Debug_Level <= 1) THEN
1041: cln_debug_pub.Add('l_int_hdr_id:' || l_int_hdr_id, 1);
1042: END IF;
1043:

Line 1044: l_int_ctl_num := to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER1', TRUE));

1040: IF (l_Debug_Level <= 1) THEN
1041: cln_debug_pub.Add('l_int_hdr_id:' || l_int_hdr_id, 1);
1042: END IF;
1043:
1044: l_int_ctl_num := to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER1', TRUE));
1045: IF (l_Debug_Level <= 1) THEN
1046: cln_debug_pub.Add('l_int_ctl_num:' || l_int_ctl_num, 1);
1047: END IF;
1048:

Line 1054: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER12', l_doc_status);

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
1058: l_doc_status := 'ERROR';

Line 1055: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', l_description);

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
1058: l_doc_status := 'ERROR';
1059: l_msg_data := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER7', TRUE);

Line 1056: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER2', '00');

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
1058: l_doc_status := 'ERROR';
1059: l_msg_data := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER7', TRUE);
1060: IF (l_Debug_Level <= 1) THEN

Line 1059: l_msg_data := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER7', TRUE);

1055: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', l_description);
1056: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER2', '00');
1057: ELSE
1058: l_doc_status := 'ERROR';
1059: l_msg_data := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER7', TRUE);
1060: IF (l_Debug_Level <= 1) THEN
1061: cln_debug_pub.Add('l_msg_data:' || l_msg_data, 1);
1062: END IF;
1063:

Line 1068: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER12', l_doc_status);

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;
1072:

Line 1069: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', l_description);

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;
1072:
1073: l_trp_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE);

Line 1070: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER2', '99');

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;
1072:
1073: l_trp_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE);
1074: IF (l_Debug_Level <= 1) THEN

Line 1073: l_trp_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE);

1069: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', l_description);
1070: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER2', '99');
1071: END IF;
1072:
1073: l_trp_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE);
1074: IF (l_Debug_Level <= 1) THEN
1075: cln_debug_pub.Add('l_tp_id:' || l_trp_id, 1);
1076: END IF;
1077:

Line 1078: l_app_ref_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', TRUE);

1074: IF (l_Debug_Level <= 1) THEN
1075: cln_debug_pub.Add('l_tp_id:' || l_trp_id, 1);
1076: END IF;
1077:
1078: l_app_ref_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', TRUE);
1079: IF (l_Debug_Level <= 1) THEN
1080: cln_debug_pub.Add('l_app_ref_id:' || l_app_ref_id, 1);
1081: END IF;
1082:

Line 1088: l_ctg_sync_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER8', TRUE);

1084: IF (l_Debug_Level <= 1) THEN
1085: cln_debug_pub.Add('Trading Partner ID:' || l_tp_id, 1);
1086: END IF;
1087:
1088: l_ctg_sync_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER8', TRUE);
1089: IF (l_Debug_Level <= 1) THEN
1090: cln_debug_pub.Add('l_ctg_sync_id:' || l_ctg_sync_id, 1);
1091: END IF;
1092:

Line 1299: l_tp_header_id := to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE));

1295: IF (l_Debug_Level <= 1) THEN
1296: cln_debug_pub.Add('l_def_buyer:' || l_def_buyer, 1);
1297: END IF;
1298:
1299: l_tp_header_id := to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE));
1300: IF (l_Debug_Level <= 1) THEN
1301: cln_debug_pub.Add('l_tp_header_id:' || l_tp_header_id, 1);
1302: END IF;
1303:

Line 1315: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG1', l_def_buyer);

1311: IF (l_Debug_Level <= 1) THEN
1312: cln_debug_pub.Add('l_org_id:' || l_org_id, 1);
1313: END IF;
1314:
1315: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG1', l_def_buyer);
1316: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG3', l_create_upd_items);
1317: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG4', l_create_src_rules);
1318: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG5', l_approval_status);
1319: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG6', l_rel_gen_method);

Line 1316: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG3', l_create_upd_items);

1312: cln_debug_pub.Add('l_org_id:' || l_org_id, 1);
1313: END IF;
1314:
1315: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG1', l_def_buyer);
1316: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG3', l_create_upd_items);
1317: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG4', l_create_src_rules);
1318: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG5', l_approval_status);
1319: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG6', l_rel_gen_method);
1320: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_org_id);

Line 1317: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG4', l_create_src_rules);

1313: END IF;
1314:
1315: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG1', l_def_buyer);
1316: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG3', l_create_upd_items);
1317: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG4', l_create_src_rules);
1318: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG5', l_approval_status);
1319: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG6', l_rel_gen_method);
1320: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_org_id);
1321: -- Global Agreement ?

Line 1318: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG5', l_approval_status);

1314:
1315: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG1', l_def_buyer);
1316: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG3', l_create_upd_items);
1317: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG4', l_create_src_rules);
1318: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG5', l_approval_status);
1319: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG6', l_rel_gen_method);
1320: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_org_id);
1321: -- Global Agreement ?
1322: -- wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG7', TRUE);

Line 1319: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG6', l_rel_gen_method);

1315: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG1', l_def_buyer);
1316: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG3', l_create_upd_items);
1317: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG4', l_create_src_rules);
1318: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG5', l_approval_status);
1319: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG6', l_rel_gen_method);
1320: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_org_id);
1321: -- Global Agreement ?
1322: -- wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG7', TRUE);
1323:

Line 1320: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_org_id);

1316: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG3', l_create_upd_items);
1317: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG4', l_create_src_rules);
1318: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG5', l_approval_status);
1319: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG6', l_rel_gen_method);
1320: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_org_id);
1321: -- Global Agreement ?
1322: -- wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG7', TRUE);
1323:
1324: IF (l_Debug_Level <= 2) THEN

Line 1322: -- wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG7', TRUE);

1318: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG5', l_approval_status);
1319: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG6', l_rel_gen_method);
1320: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_org_id);
1321: -- Global Agreement ?
1322: -- wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ARG7', TRUE);
1323:
1324: IF (l_Debug_Level <= 2) THEN
1325: cln_debug_pub.Add('EXITING SET_ITEM_ATTRIBUTES API', 2);
1326: END IF;

Line 1534: l_operation := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', TRUE);

1530: cln_debug_pub.Add('ENTERING SET_ACTION_CREATE_OR_UPDATE API', 2);
1531: END IF;
1532:
1533: -- Get the batch ID, which is being imported
1534: l_operation := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', TRUE);
1535: IF (l_Debug_Level <= 1) THEN
1536: cln_debug_pub.Add('l_operation:' || l_operation, 1);
1537: END IF;
1538:

Line 1552: l_batch_id := to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER9', TRUE));

1548: RETURN;
1549: END IF;
1550:
1551: -- Get the batch ID, which is being imported
1552: l_batch_id := to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER9', TRUE));
1553: IF (l_Debug_Level <= 1) THEN
1554: cln_debug_pub.Add('l_batch_id:' || l_batch_id, 1);
1555: END IF;
1556:

Line 1557: l_catalog_name :=wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER5', TRUE);

1553: IF (l_Debug_Level <= 1) THEN
1554: cln_debug_pub.Add('l_batch_id:' || l_batch_id, 1);
1555: END IF;
1556:
1557: l_catalog_name :=wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER5', TRUE);
1558: IF (l_Debug_Level <= 1) THEN
1559: cln_debug_pub.Add('l_catalog_name:' || l_catalog_name, 1);
1560: END IF;
1561:

Line 1562: l_tp_hdr_id :=to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE));

1558: IF (l_Debug_Level <= 1) THEN
1559: cln_debug_pub.Add('l_catalog_name:' || l_catalog_name, 1);
1560: END IF;
1561:
1562: l_tp_hdr_id :=to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE));
1563: IF (l_Debug_Level <= 1) THEN
1564: cln_debug_pub.Add('l_tp_hdr_id:' || l_tp_hdr_id, 1);
1565: cln_debug_pub.Add('About to call CLN_UTILS.GET_TRADING_PARTNER', 1);
1566: END IF;

Line 1641: l_ret_status := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER6', TRUE);

1637: cln_debug_pub.Add('Parameters:', 1);
1638: END IF;
1639:
1640: -- Should be S for sucess
1641: l_ret_status := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER6', TRUE);
1642: IF (l_Debug_Level <= 1) THEN
1643: cln_debug_pub.Add('l_ret_status:' || l_ret_status, 1);
1644: END IF;
1645:

Line 1729: l_int_hdr_id := to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER9', TRUE));

1725: cln_debug_pub.Add('Parameters:', 1);
1726: END IF;
1727:
1728:
1729: l_int_hdr_id := to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER9', TRUE));
1730: IF (l_Debug_Level <= 1) THEN
1731: cln_debug_pub.Add('l_int_hdr_id:' || l_int_hdr_id, 1);
1732: END IF;
1733:

Line 1735: l_app_ref_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', TRUE);

1731: cln_debug_pub.Add('l_int_hdr_id:' || l_int_hdr_id, 1);
1732: END IF;
1733:
1734:
1735: l_app_ref_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', TRUE);
1736: IF (l_Debug_Level <= 1) THEN
1737: cln_debug_pub.Add('l_app_ref_id:' || l_app_ref_id, 1);
1738: END IF;
1739:

Line 1741: l_int_ctl_num := to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER1', TRUE));

1737: cln_debug_pub.Add('l_app_ref_id:' || l_app_ref_id, 1);
1738: END IF;
1739:
1740:
1741: l_int_ctl_num := to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER1', TRUE));
1742: IF (l_Debug_Level <= 1) THEN
1743: cln_debug_pub.Add('l_int_ctl_num:' || l_int_ctl_num, 1);
1744: END IF;
1745:

Line 1762: l_catalog_name := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER5', TRUE);

1758: IF (l_Debug_Level <= 1) THEN
1759: cln_debug_pub.Add('Trying to get BPO Number from PO Headers All', 1);
1760: END IF;
1761:
1762: l_catalog_name := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER5', TRUE);
1763: IF (l_Debug_Level <= 1) THEN
1764: cln_debug_pub.Add('l_catalog_name:' || l_catalog_name, 1);
1765: END IF;
1766:

Line 1767: l_tp_hdr_id :=to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE));

1763: IF (l_Debug_Level <= 1) THEN
1764: cln_debug_pub.Add('l_catalog_name:' || l_catalog_name, 1);
1765: END IF;
1766:
1767: l_tp_hdr_id :=to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE));
1768: IF (l_Debug_Level <= 1) THEN
1769: cln_debug_pub.Add('l_tp_hdr_id:' || l_tp_hdr_id, 1);
1770: cln_debug_pub.Add('About to call CLN_UTILS.GET_TRADING_PARTNER', 1);
1771: END IF;

Line 1838: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER6', l_error_status);

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(
1841: x_return_status => l_return_status,
1842: x_msg_data => l_return_msg,

Line 1839: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER7', l_msg_data);

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(
1841: x_return_status => l_return_status,
1842: x_msg_data => l_return_msg,
1843: p_ref_id => l_app_ref_id,