DBA Data[Home] [Help]

APPS.CST_PENDINGTXNSREPORT_PVT dependencies on STANDARD

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

478: l_module || '.begin',
479: '>>> ' || l_api_name);
480: END IF;
481:
482: -- Standard call to check for call compatibility.
483: IF NOT FND_API.Compatible_API_Call (l_api_version,
484: p_api_version,
485: l_api_name,
486: G_PKG_NAME )

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

559: DBMS_XMLGEN.closeContext(l_ctx);
560: CLOSE l_ref_cur;
561: DBMS_LOB.FREETEMPORARY (l_xml_temp);
562:
563: -- Standard call to get message count and if count is 1, get message info.
564: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
565: p_data => x_msg_data);
566:
567: IF (l_pLog) THEN

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

631: l_module || '.begin',
632: '>>> ' || l_api_name);
633: END IF;
634:
635: -- Standard call to check for call compatibility.
636: IF NOT FND_API.Compatible_API_Call (l_api_version,
637: p_api_version,
638: l_api_name,
639: G_PKG_NAME )

Line 694: mmtt.STANDARD_OPERATION_ID,

690: mmtt.PICK_SLIP_NUMBER,
691: mmtt.PICKING_LINE_ID,
692: mmtt.RESERVATION_ID,
693: mmtt.WMS_TASK_TYPE,
694: mmtt.STANDARD_OPERATION_ID,
695: mmtt.ERROR_CODE,
696: mmtt.ERROR_EXPLANATION
697: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
698: MTL_ITEM_FLEXFIELDS mif,

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

745: DBMS_XMLGEN.closeContext(l_ctx);
746: CLOSE l_ref_cur;
747: DBMS_LOB.FREETEMPORARY (l_xml_temp);
748:
749: -- Standard call to get message count and if count is 1, get message info.
750: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
751: p_data => x_msg_data);
752:
753: IF (l_pLog) THEN

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

810: l_module || '.begin',
811: '>>> ' || l_api_name);
812: END IF;
813:
814: -- Standard call to check for call compatibility.
815: IF NOT FND_API.Compatible_API_Call (l_api_version,
816: p_api_version,
817: l_api_name,
818: G_PKG_NAME)

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

909: DBMS_XMLGEN.closeContext(l_ctx);
910: CLOSE l_ref_cur;
911: DBMS_LOB.FREETEMPORARY (l_xml_temp);
912:
913: -- Standard call to get message count and if count is 1, get message info.
914: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
915: p_data => x_msg_data);
916:
917: IF (l_pLog) THEN

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

973: l_module || '.begin',
974: '>>> ' || l_api_name);
975: END IF;
976:
977: -- Standard call to check for call compatibility.
978: IF NOT FND_API.Compatible_API_Call (l_api_version,
979: p_api_version,
980: l_api_name,
981: G_PKG_NAME )

Line 1015: wcti.STANDARD_RATE_FLAG,

1011: wcti.AUTOCHARGE_TYPE,
1012: wcti.BASIS_TYPE,
1013: ml1.meaning BASIS_TYPE_CODE,
1014: wcti.RESOURCE_TYPE,
1015: wcti.STANDARD_RATE_FLAG,
1016: wcti.REQUEST_ID,
1017: wcti.GROUP_ID,
1018: wcti.OPERATION_SEQ_NUM,
1019: wcti.RESOURCE_SEQ_NUM,

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

1077: DBMS_XMLGEN.closeContext(l_ctx);
1078: CLOSE l_ref_cur;
1079: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1080:
1081: -- Standard call to get message count and if count is 1, get message info.
1082: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1083: p_data => x_msg_data);
1084: IF (l_pLog) THEN
1085: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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

1145: l_module || '.begin',
1146: '>>> ' || l_api_name);
1147: END IF;
1148:
1149: -- Standard call to check for call compatibility.
1150: IF NOT FND_API.Compatible_API_Call (l_api_version,
1151: p_api_version,
1152: l_api_name,
1153: G_PKG_NAME )

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

1404: DBMS_LOB.FREETEMPORARY (l_xml_wsmti);
1405: DBMS_LOB.FREETEMPORARY (l_xml_wlmti);
1406: DBMS_LOB.FREETEMPORARY (l_xml_wlsmi);
1407:
1408: -- Standard call to get message count and if count is 1, get message info.
1409: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1410: p_data => x_msg_data);
1411:
1412: IF (l_pLog) THEN

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

1469: l_module || '.begin',
1470: '>>> ' || l_api_name);
1471: END IF;
1472:
1473: -- Standard call to check for call compatibility.
1474: IF NOT FND_API.Compatible_API_Call (l_api_version,
1475: p_api_version,
1476: l_api_name,
1477: G_PKG_NAME )

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

1605: DBMS_XMLGEN.closeContext(l_ctx);
1606: CLOSE l_ref_cur;
1607: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1608:
1609: -- Standard call to get message count and if count is 1, get message info.
1610: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1611: p_data => x_msg_data);
1612:
1613: IF (l_pLog) THEN

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

1670: l_module || '.begin',
1671: '>>> ' || l_api_name);
1672: END IF;
1673:
1674: -- Standard call to check for call compatibility.
1675: IF NOT FND_API.Compatible_API_Call (l_api_version,
1676: p_api_version,
1677: l_api_name,
1678: G_PKG_NAME )

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

1776: DBMS_XMLGEN.closeContext(l_ctx);
1777: CLOSE l_ref_cur;
1778: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1779:
1780: -- Standard call to get message count and if count is 1, get message info.
1781: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1782: p_data => x_msg_data);
1783:
1784: IF (l_pLog) THEN

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

1840: l_module || '.begin',
1841: '>>> ' || l_api_name);
1842: END IF;
1843:
1844: -- Standard call to check for call compatibility.
1845: IF NOT FND_API.Compatible_API_Call (l_api_version,
1846: p_api_version,
1847: l_api_name,
1848: G_PKG_NAME )

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

1931: DBMS_XMLGEN.closeContext(l_ctx);
1932: CLOSE l_ref_cur;
1933: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1934:
1935: -- Standard call to get message count and if count is 1, get message info.
1936: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1937: p_data => x_msg_data);
1938:
1939: IF (l_pLog) THEN

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

1997: l_module || '.begin',
1998: '>>> ' || l_api_name);
1999: END IF;
2000:
2001: -- Standard call to check for call compatibility.
2002: IF NOT FND_API.Compatible_API_Call (l_api_version ,
2003: p_api_version ,
2004: l_api_name ,
2005: G_PKG_NAME )

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

2169: DBMS_XMLGEN.closeContext(l_ctx);
2170: CLOSE l_ref_cur;
2171: DBMS_LOB.FREETEMPORARY (l_xml_temp);
2172:
2173: -- Standard call to get message count and if count is 1, get message info.
2174: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2175: p_data => x_msg_data);
2176:
2177: IF (l_pLog) THEN

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

2233: l_module || '.begin',
2234: '>>> ' || l_api_name);
2235: END IF;
2236:
2237: -- Standard call to check for call compatibility.
2238: IF NOT FND_API.Compatible_API_Call (l_api_version ,
2239: p_api_version ,
2240: l_api_name ,
2241: G_PKG_NAME )

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

2362: DBMS_XMLGEN.closeContext(l_ctx);
2363: CLOSE l_ref_cur;
2364: DBMS_LOB.FREETEMPORARY (l_xml_temp);
2365:
2366: -- Standard call to get message count and if count is 1, get message info.
2367: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2368: p_data => x_msg_data);
2369:
2370: IF (l_pLog) THEN

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

2426: l_module || '.begin',
2427: '>>> ' || l_api_name);
2428: END IF;
2429:
2430: -- Standard call to check for call compatibility.
2431: IF NOT FND_API.Compatible_API_Call (l_api_version,
2432: p_api_version,
2433: l_api_name,
2434: G_PKG_NAME )

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

2504: DBMS_XMLGEN.closeContext(l_ctx);
2505: CLOSE l_ref_cur;
2506: DBMS_LOB.FREETEMPORARY (l_xml_temp);
2507:
2508: -- Standard call to get message count and if count is 1, get message info.
2509: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2510: p_data => x_msg_data);
2511: IF (l_pLog) THEN
2512: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,