DBA Data[Home] [Help]

APPS.CST_PENDINGTXNSREPORT_PVT dependencies on STANDARD

Line 496: -- Standard call to check for call compatibility.

492: l_module || '.begin',
493: '>>> ' || l_api_name);
494: END IF;
495:
496: -- Standard call to check for call compatibility.
497: IF NOT FND_API.Compatible_API_Call (l_api_version,
498: p_api_version,
499: l_api_name,
500: G_PKG_NAME )

Line 577: -- Standard call to get message count and if count is 1, get message info.

573: DBMS_XMLGEN.closeContext(l_ctx);
574: CLOSE l_ref_cur;
575: DBMS_LOB.FREETEMPORARY (l_xml_temp);
576:
577: -- Standard call to get message count and if count is 1, get message info.
578: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
579: p_data => x_msg_data);
580:
581: IF (l_pLog) THEN

Line 649: -- Standard call to check for call compatibility.

645: l_module || '.begin',
646: '>>> ' || l_api_name);
647: END IF;
648:
649: -- Standard call to check for call compatibility.
650: IF NOT FND_API.Compatible_API_Call (l_api_version,
651: p_api_version,
652: l_api_name,
653: G_PKG_NAME )

Line 708: mmtt.STANDARD_OPERATION_ID,

704: mmtt.PICK_SLIP_NUMBER,
705: mmtt.PICKING_LINE_ID,
706: mmtt.RESERVATION_ID,
707: mmtt.WMS_TASK_TYPE,
708: mmtt.STANDARD_OPERATION_ID,
709: mmtt.ERROR_CODE,
710: mmtt.ERROR_EXPLANATION
711: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
712: MTL_ITEM_FLEXFIELDS mif,

Line 763: -- Standard call to get message count and if count is 1, get message info.

759: DBMS_XMLGEN.closeContext(l_ctx);
760: CLOSE l_ref_cur;
761: DBMS_LOB.FREETEMPORARY (l_xml_temp);
762:
763: -- Standard call to get message count and if count is 1, get message info.
764: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
765: p_data => x_msg_data);
766:
767: IF (l_pLog) THEN

Line 828: -- Standard call to check for call compatibility.

824: l_module || '.begin',
825: '>>> ' || l_api_name);
826: END IF;
827:
828: -- Standard call to check for call compatibility.
829: IF NOT FND_API.Compatible_API_Call (l_api_version,
830: p_api_version,
831: l_api_name,
832: G_PKG_NAME)

Line 927: -- Standard call to get message count and if count is 1, get message info.

923: DBMS_XMLGEN.closeContext(l_ctx);
924: CLOSE l_ref_cur;
925: DBMS_LOB.FREETEMPORARY (l_xml_temp);
926:
927: -- Standard call to get message count and if count is 1, get message info.
928: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
929: p_data => x_msg_data);
930:
931: IF (l_pLog) THEN

Line 991: -- Standard call to check for call compatibility.

987: l_module || '.begin',
988: '>>> ' || l_api_name);
989: END IF;
990:
991: -- Standard call to check for call compatibility.
992: IF NOT FND_API.Compatible_API_Call (l_api_version,
993: p_api_version,
994: l_api_name,
995: G_PKG_NAME )

Line 1029: wcti.STANDARD_RATE_FLAG,

1025: wcti.AUTOCHARGE_TYPE,
1026: wcti.BASIS_TYPE,
1027: ml1.meaning BASIS_TYPE_CODE,
1028: wcti.RESOURCE_TYPE,
1029: wcti.STANDARD_RATE_FLAG,
1030: wcti.REQUEST_ID,
1031: wcti.GROUP_ID,
1032: wcti.OPERATION_SEQ_NUM,
1033: wcti.RESOURCE_SEQ_NUM,

Line 1095: -- Standard call to get message count and if count is 1, get message info.

1091: DBMS_XMLGEN.closeContext(l_ctx);
1092: CLOSE l_ref_cur;
1093: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1094:
1095: -- Standard call to get message count and if count is 1, get message info.
1096: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1097: p_data => x_msg_data);
1098: IF (l_pLog) THEN
1099: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

Line 1163: -- Standard call to check for call compatibility.

1159: l_module || '.begin',
1160: '>>> ' || l_api_name);
1161: END IF;
1162:
1163: -- Standard call to check for call compatibility.
1164: IF NOT FND_API.Compatible_API_Call (l_api_version,
1165: p_api_version,
1166: l_api_name,
1167: G_PKG_NAME )

Line 1422: -- Standard call to get message count and if count is 1, get message info.

1418: DBMS_LOB.FREETEMPORARY (l_xml_wsmti);
1419: DBMS_LOB.FREETEMPORARY (l_xml_wlmti);
1420: DBMS_LOB.FREETEMPORARY (l_xml_wlsmi);
1421:
1422: -- Standard call to get message count and if count is 1, get message info.
1423: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1424: p_data => x_msg_data);
1425:
1426: IF (l_pLog) THEN

Line 1487: -- Standard call to check for call compatibility.

1483: l_module || '.begin',
1484: '>>> ' || l_api_name);
1485: END IF;
1486:
1487: -- Standard call to check for call compatibility.
1488: IF NOT FND_API.Compatible_API_Call (l_api_version,
1489: p_api_version,
1490: l_api_name,
1491: G_PKG_NAME )

Line 1623: -- Standard call to get message count and if count is 1, get message info.

1619: DBMS_XMLGEN.closeContext(l_ctx);
1620: CLOSE l_ref_cur;
1621: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1622:
1623: -- Standard call to get message count and if count is 1, get message info.
1624: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1625: p_data => x_msg_data);
1626:
1627: IF (l_pLog) THEN

Line 1688: -- Standard call to check for call compatibility.

1684: l_module || '.begin',
1685: '>>> ' || l_api_name);
1686: END IF;
1687:
1688: -- Standard call to check for call compatibility.
1689: IF NOT FND_API.Compatible_API_Call (l_api_version,
1690: p_api_version,
1691: l_api_name,
1692: G_PKG_NAME )

Line 1794: -- Standard call to get message count and if count is 1, get message info.

1790: DBMS_XMLGEN.closeContext(l_ctx);
1791: CLOSE l_ref_cur;
1792: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1793:
1794: -- Standard call to get message count and if count is 1, get message info.
1795: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1796: p_data => x_msg_data);
1797:
1798: IF (l_pLog) THEN

Line 1858: -- Standard call to check for call compatibility.

1854: l_module || '.begin',
1855: '>>> ' || l_api_name);
1856: END IF;
1857:
1858: -- Standard call to check for call compatibility.
1859: IF NOT FND_API.Compatible_API_Call (l_api_version,
1860: p_api_version,
1861: l_api_name,
1862: G_PKG_NAME )

Line 1949: -- Standard call to get message count and if count is 1, get message info.

1945: DBMS_XMLGEN.closeContext(l_ctx);
1946: CLOSE l_ref_cur;
1947: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1948:
1949: -- Standard call to get message count and if count is 1, get message info.
1950: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1951: p_data => x_msg_data);
1952:
1953: IF (l_pLog) THEN

Line 2015: -- Standard call to check for call compatibility.

2011: l_module || '.begin',
2012: '>>> ' || l_api_name);
2013: END IF;
2014:
2015: -- Standard call to check for call compatibility.
2016: IF NOT FND_API.Compatible_API_Call (l_api_version ,
2017: p_api_version ,
2018: l_api_name ,
2019: G_PKG_NAME )

Line 2187: -- Standard call to get message count and if count is 1, get message info.

2183: DBMS_XMLGEN.closeContext(l_ctx);
2184: CLOSE l_ref_cur;
2185: DBMS_LOB.FREETEMPORARY (l_xml_temp);
2186:
2187: -- Standard call to get message count and if count is 1, get message info.
2188: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2189: p_data => x_msg_data);
2190:
2191: IF (l_pLog) THEN

Line 2251: -- Standard call to check for call compatibility.

2247: l_module || '.begin',
2248: '>>> ' || l_api_name);
2249: END IF;
2250:
2251: -- Standard call to check for call compatibility.
2252: IF NOT FND_API.Compatible_API_Call (l_api_version ,
2253: p_api_version ,
2254: l_api_name ,
2255: G_PKG_NAME )

Line 2380: -- Standard call to get message count and if count is 1, get message info.

2376: DBMS_XMLGEN.closeContext(l_ctx);
2377: CLOSE l_ref_cur;
2378: DBMS_LOB.FREETEMPORARY (l_xml_temp);
2379:
2380: -- Standard call to get message count and if count is 1, get message info.
2381: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2382: p_data => x_msg_data);
2383:
2384: IF (l_pLog) THEN

Line 2444: -- Standard call to check for call compatibility.

2440: l_module || '.begin',
2441: '>>> ' || l_api_name);
2442: END IF;
2443:
2444: -- Standard call to check for call compatibility.
2445: IF NOT FND_API.Compatible_API_Call (l_api_version,
2446: p_api_version,
2447: l_api_name,
2448: G_PKG_NAME )

Line 2522: -- Standard call to get message count and if count is 1, get message info.

2518: DBMS_XMLGEN.closeContext(l_ctx);
2519: CLOSE l_ref_cur;
2520: DBMS_LOB.FREETEMPORARY (l_xml_temp);
2521:
2522: -- Standard call to get message count and if count is 1, get message info.
2523: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2524: p_data => x_msg_data);
2525: IF (l_pLog) THEN
2526: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,