DBA Data[Home] [Help]

APPS.AMV_MATCH_PVT dependencies on STANDARD

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

58: l_message_obj SYSTEM.AMV_AQ_MSG_OBJECT_TYPE;
59: --
60: BEGIN
61: SAVEPOINT Request_ItemMatch_Pvt;
62: -- Standard call to check for call compatibility.
63: IF NOT FND_API.Compatible_API_Call (
64: l_api_version,
65: p_api_version,
66: l_api_name,

Line 112: -- Standard call to get message count and if count=1, get the message

108: EXCEPTION
109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
110: ROLLBACK TO Request_ItemMatch_Pvt;
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
112: -- Standard call to get message count and if count=1, get the message
113: FND_MSG_PUB.Count_And_Get (
114: p_encoded => FND_API.G_FALSE,
115: p_count => x_msg_count,
116: p_data => x_msg_data

Line 121: -- Standard call to get message count and if count=1, get the message

117: );
118: WHEN FND_API.G_EXC_ERROR THEN
119: ROLLBACK TO Request_ItemMatch_Pvt;
120: x_return_status := FND_API.G_RET_STS_ERROR;
121: -- Standard call to get message count and if count=1, get the message
122: FND_MSG_PUB.Count_And_Get (
123: p_encoded => FND_API.G_FALSE,
124: p_count => x_msg_count,
125: p_data => x_msg_data

Line 133: -- Standard call to get message count and if count=1, get the message

129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
131: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
132: END IF;
133: -- Standard call to get message count and if count=1, get the message
134: FND_MSG_PUB.Count_And_Get (
135: p_encoded => FND_API.G_FALSE,
136: p_count => x_msg_count,
137: p_data => x_msg_data

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

156: l_message_obj SYSTEM.AMV_AQ_MSG_OBJECT_TYPE;
157: --
158: BEGIN
159: SAVEPOINT Request_ChannelMatch_Pvt;
160: -- Standard call to check for call compatibility.
161: IF NOT FND_API.Compatible_API_Call (
162: l_api_version,
163: p_api_version,
164: l_api_name,

Line 210: -- Standard call to get message count and if count=1, get the message

206: EXCEPTION
207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
208: ROLLBACK TO Request_ChannelMatch_Pvt;
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: -- Standard call to get message count and if count=1, get the message
211: FND_MSG_PUB.Count_And_Get (
212: p_encoded => FND_API.G_FALSE,
213: p_count => x_msg_count,
214: p_data => x_msg_data

Line 219: -- Standard call to get message count and if count=1, get the message

215: );
216: WHEN FND_API.G_EXC_ERROR THEN
217: ROLLBACK TO Request_ChannelMatch_Pvt;
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: -- Standard call to get message count and if count=1, get the message
220: FND_MSG_PUB.Count_And_Get (
221: p_encoded => FND_API.G_FALSE,
222: p_count => x_msg_count,
223: p_data => x_msg_data

Line 231: -- Standard call to get message count and if count=1, get the message

227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
229: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
230: END IF;
231: -- Standard call to get message count and if count=1, get the message
232: FND_MSG_PUB.Count_And_Get (
233: p_encoded => FND_API.G_FALSE,
234: p_count => x_msg_count,
235: p_data => x_msg_data

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

254: l_message_obj SYSTEM.AMV_AQ_MSG_OBJECT_TYPE;
255: --
256: BEGIN
257: SAVEPOINT Stop_MatchingEngine_Pvt;
258: -- Standard call to check for call compatibility.
259: IF NOT FND_API.Compatible_API_Call (
260: l_api_version,
261: p_api_version,
262: l_api_name,

Line 296: -- Standard call to get message count and if count=1, get the message

292: EXCEPTION
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: ROLLBACK TO Stop_MatchingEngine_Pvt;
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296: -- Standard call to get message count and if count=1, get the message
297: FND_MSG_PUB.Count_And_Get (
298: p_encoded => FND_API.G_FALSE,
299: p_count => x_msg_count,
300: p_data => x_msg_data

Line 305: -- Standard call to get message count and if count=1, get the message

301: );
302: WHEN FND_API.G_EXC_ERROR THEN
303: ROLLBACK TO Stop_MatchingEngine_Pvt;
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: -- Standard call to get message count and if count=1, get the message
306: FND_MSG_PUB.Count_And_Get (
307: p_encoded => FND_API.G_FALSE,
308: p_count => x_msg_count,
309: p_data => x_msg_data

Line 317: -- Standard call to get message count and if count=1, get the message

313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
315: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
316: END IF;
317: -- Standard call to get message count and if count=1, get the message
318: FND_MSG_PUB.Count_And_Get (
319: p_encoded => FND_API.G_FALSE,
320: p_count => x_msg_count,
321: p_data => x_msg_data

Line 437: --Standard call to get message count and if count=1, get the message

433: null; -- maybe do something?
434: END IF;
435: END IF;
436: END LOOP;
437: --Standard call to get message count and if count=1, get the message
438: FND_MSG_PUB.Count_And_Get (
439: p_encoded => FND_API.G_FALSE,
440: p_count => l_msg_count,
441: p_data => l_msg_data

Line 447: -- Standard call to get message count and if count=1, get the message

443: errbuf := l_msg_data;
444: EXCEPTION
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ROLLBACK TO Start_MatchingEngine_Pvt;
447: -- Standard call to get message count and if count=1, get the message
448: FND_MSG_PUB.Count_And_Get (
449: p_encoded => FND_API.G_FALSE,
450: p_count => l_msg_count,
451: p_data => l_msg_data

Line 457: -- Standard call to get message count and if count=1, get the message

453: errbuf := l_msg_data;
454: retcode := 2;
455: WHEN FND_API.G_EXC_ERROR THEN
456: ROLLBACK TO Start_MatchingEngine_Pvt;
457: -- Standard call to get message count and if count=1, get the message
458: FND_MSG_PUB.Count_And_Get (
459: p_encoded => FND_API.G_FALSE,
460: p_count => l_msg_count,
461: p_data => l_msg_data

Line 470: -- Standard call to get message count and if count=1, get the message

466: ROLLBACK TO Start_MatchingEngine_Pvt;
467: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
468: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
469: END IF;
470: -- Standard call to get message count and if count=1, get the message
471: FND_MSG_PUB.Count_And_Get (
472: p_encoded => FND_API.G_FALSE,
473: p_count => l_msg_count,
474: p_data => l_msg_data

Line 781: --Standard check of commit

777: IF (G_DEBUG = TRUE) THEN
778: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('Match_ItemWithChannels: End time '
779: || to_char(sysdate, 'DD-MON-YYYY: HH:MI:SS') );
780: END IF;
781: --Standard check of commit
782: IF FND_API.To_Boolean ( p_commit ) THEN
783: COMMIT WORK;
784: END IF;
785: --Standard call to get message count and if count=1, get the message

Line 785: --Standard call to get message count and if count=1, get the message

781: --Standard check of commit
782: IF FND_API.To_Boolean ( p_commit ) THEN
783: COMMIT WORK;
784: END IF;
785: --Standard call to get message count and if count=1, get the message
786: FND_MSG_PUB.Count_And_Get (
787: p_count => x_msg_count,
788: p_data => x_msg_data
789: );

Line 794: -- Standard call to get message count and if count=1, get the message

790: EXCEPTION
791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
792: ROLLBACK TO Match_ItemWithChannels_Pvt;
793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
794: -- Standard call to get message count and if count=1, get the message
795: FND_MSG_PUB.Count_And_Get (
796: p_encoded => FND_API.G_FALSE,
797: p_count => x_msg_count,
798: p_data => x_msg_data

Line 803: -- Standard call to get message count and if count=1, get the message

799: );
800: WHEN FND_API.G_EXC_ERROR THEN
801: ROLLBACK TO Match_ItemWithChannels_Pvt;
802: x_return_status := FND_API.G_RET_STS_ERROR;
803: -- Standard call to get message count and if count=1, get the message
804: FND_MSG_PUB.Count_And_Get (
805: p_encoded => FND_API.G_FALSE,
806: p_count => x_msg_count,
807: p_data => x_msg_data

Line 815: -- Standard call to get message count and if count=1, get the message

811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
813: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
814: END IF;
815: -- Standard call to get message count and if count=1, get the message
816: FND_MSG_PUB.Count_And_Get (
817: p_encoded => FND_API.G_FALSE,
818: p_count => x_msg_count,
819: p_data => x_msg_data

Line 1090: --Standard check of commit

1086: IF (G_DEBUG = TRUE) THEN
1087: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('Match_ChannelWithItems: End time '
1088: || to_char(sysdate, 'DD-MON: HH:MI:SS') );
1089: END IF;
1090: --Standard check of commit
1091: IF FND_API.To_Boolean ( p_commit ) THEN
1092: COMMIT WORK;
1093: END IF;
1094: --Standard call to get message count and if count=1, get the message

Line 1094: --Standard call to get message count and if count=1, get the message

1090: --Standard check of commit
1091: IF FND_API.To_Boolean ( p_commit ) THEN
1092: COMMIT WORK;
1093: END IF;
1094: --Standard call to get message count and if count=1, get the message
1095: FND_MSG_PUB.Count_And_Get (
1096: p_count => x_msg_count,
1097: p_data => x_msg_data
1098: );

Line 1103: -- Standard call to get message count and if count=1, get the message

1099: EXCEPTION
1100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1101: ROLLBACK TO Match_ChannelWithItems_Pvt;
1102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1103: -- Standard call to get message count and if count=1, get the message
1104: FND_MSG_PUB.Count_And_Get (
1105: p_encoded => FND_API.G_FALSE,
1106: p_count => x_msg_count,
1107: p_data => x_msg_data

Line 1112: -- Standard call to get message count and if count=1, get the message

1108: );
1109: WHEN FND_API.G_EXC_ERROR THEN
1110: ROLLBACK TO Match_ChannelWithItems_Pvt;
1111: x_return_status := FND_API.G_RET_STS_ERROR;
1112: -- Standard call to get message count and if count=1, get the message
1113: FND_MSG_PUB.Count_And_Get (
1114: p_encoded => FND_API.G_FALSE,
1115: p_count => x_msg_count,
1116: p_data => x_msg_data

Line 1124: -- Standard call to get message count and if count=1, get the message

1120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1121: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1122: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1123: END IF;
1124: -- Standard call to get message count and if count=1, get the message
1125: FND_MSG_PUB.Count_And_Get (
1126: p_encoded => FND_API.G_FALSE,
1127: p_count => x_msg_count,
1128: p_data => x_msg_data

Line 1210: --Standard call to get message count and if count=1, get the message

1206: CLOSE Get_ChlItemApprovalStatus_csr;
1207: x_match_exist_flag := FND_API.G_FALSE;
1208: x_approval_status := FND_API.G_MISS_CHAR;
1209: END IF;
1210: --Standard call to get message count and if count=1, get the message
1211: FND_MSG_PUB.Count_And_Get (
1212: p_count => x_msg_count,
1213: p_data => x_msg_data
1214: );

Line 1218: -- Standard call to get message count and if count=1, get the message

1214: );
1215: EXCEPTION
1216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1218: -- Standard call to get message count and if count=1, get the message
1219: FND_MSG_PUB.Count_And_Get (
1220: p_encoded => FND_API.G_FALSE,
1221: p_count => x_msg_count,
1222: p_data => x_msg_data

Line 1226: -- Standard call to get message count and if count=1, get the message

1222: p_data => x_msg_data
1223: );
1224: WHEN FND_API.G_EXC_ERROR THEN
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: -- Standard call to get message count and if count=1, get the message
1227: FND_MSG_PUB.Count_And_Get (
1228: p_encoded => FND_API.G_FALSE,
1229: p_count => x_msg_count,
1230: p_data => x_msg_data

Line 1237: -- Standard call to get message count and if count=1, get the message

1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1234: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1235: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1236: END IF;
1237: -- Standard call to get message count and if count=1, get the message
1238: FND_MSG_PUB.Count_And_Get (
1239: p_encoded => FND_API.G_FALSE,
1240: p_count => x_msg_count,
1241: p_data => x_msg_data

Line 1415: --Standard call to get message count and if count=1, get the message

1411: END IF;
1412: CLOSE Check_ItemType_Match_csr;
1413: END IF;
1414: END IF;
1415: --Standard call to get message count and if count=1, get the message
1416: FND_MSG_PUB.Count_And_Get (
1417: p_encoded => FND_API.G_FALSE,
1418: p_count => x_msg_count,
1419: p_data => x_msg_data

Line 1425: -- Standard call to get message count and if count=1, get the message

1421: EXCEPTION
1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1424: x_match_flag := FND_API.G_FALSE;
1425: -- Standard call to get message count and if count=1, get the message
1426: FND_MSG_PUB.Count_And_Get (
1427: p_encoded => FND_API.G_FALSE,
1428: p_count => x_msg_count,
1429: p_data => x_msg_data

Line 1434: -- Standard call to get message count and if count=1, get the message

1430: );
1431: WHEN FND_API.G_EXC_ERROR THEN
1432: x_return_status := FND_API.G_RET_STS_ERROR;
1433: x_match_flag := FND_API.G_FALSE;
1434: -- Standard call to get message count and if count=1, get the message
1435: FND_MSG_PUB.Count_And_Get (
1436: p_encoded => FND_API.G_FALSE,
1437: p_count => x_msg_count,
1438: p_data => x_msg_data

Line 1446: -- Standard call to get message count and if count=1, get the message

1442: x_match_flag := FND_API.G_FALSE;
1443: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1444: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1445: END IF;
1446: -- Standard call to get message count and if count=1, get the message
1447: FND_MSG_PUB.Count_And_Get (
1448: p_encoded => FND_API.G_FALSE,
1449: p_count => x_msg_count,
1450: p_data => x_msg_data

Line 1584: --Standard call to get message count and if count=1, get the message

1580: ELSE
1581: x_match_flag := FND_API.G_FALSE;
1582: END IF;
1583: CLOSE l_cursor;
1584: --Standard call to get message count and if count=1, get the message
1585: FND_MSG_PUB.Count_And_Get (
1586: p_encoded => FND_API.G_FALSE,
1587: p_count => x_msg_count,
1588: p_data => x_msg_data

Line 1594: -- Standard call to get message count and if count=1, get the message

1590: EXCEPTION
1591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1593: x_match_flag := FND_API.G_FALSE;
1594: -- Standard call to get message count and if count=1, get the message
1595: FND_MSG_PUB.Count_And_Get (
1596: p_encoded => FND_API.G_FALSE,
1597: p_count => x_msg_count,
1598: p_data => x_msg_data

Line 1603: -- Standard call to get message count and if count=1, get the message

1599: );
1600: WHEN FND_API.G_EXC_ERROR THEN
1601: x_return_status := FND_API.G_RET_STS_ERROR;
1602: x_match_flag := FND_API.G_FALSE;
1603: -- Standard call to get message count and if count=1, get the message
1604: FND_MSG_PUB.Count_And_Get (
1605: p_encoded => FND_API.G_FALSE,
1606: p_count => x_msg_count,
1607: p_data => x_msg_data

Line 1615: -- Standard call to get message count and if count=1, get the message

1611: x_match_flag := FND_API.G_FALSE;
1612: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1613: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1614: END IF;
1615: -- Standard call to get message count and if count=1, get the message
1616: FND_MSG_PUB.Count_And_Get (
1617: p_encoded => FND_API.G_FALSE,
1618: p_count => x_msg_count,
1619: p_data => x_msg_data

Line 1891: --Standard check of commit

1887: p_match_type,
1888: l_current_date
1889: );
1890: END IF;
1891: --Standard check of commit
1892: IF FND_API.To_Boolean ( p_commit ) THEN
1893: COMMIT WORK;
1894: END IF;
1895: --Standard call to get message count and if count=1, get the message

Line 1895: --Standard call to get message count and if count=1, get the message

1891: --Standard check of commit
1892: IF FND_API.To_Boolean ( p_commit ) THEN
1893: COMMIT WORK;
1894: END IF;
1895: --Standard call to get message count and if count=1, get the message
1896: FND_MSG_PUB.Count_And_Get (
1897: p_encoded => FND_API.G_FALSE,
1898: p_count => x_msg_count,
1899: p_data => x_msg_data

Line 1905: -- Standard call to get message count and if count=1, get the message

1901: EXCEPTION
1902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1903: ROLLBACK TO Do_ItemChannelMatch_Pvt;
1904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1905: -- Standard call to get message count and if count=1, get the message
1906: FND_MSG_PUB.Count_And_Get (
1907: p_encoded => FND_API.G_FALSE,
1908: p_count => x_msg_count,
1909: p_data => x_msg_data

Line 1914: -- Standard call to get message count and if count=1, get the message

1910: );
1911: WHEN FND_API.G_EXC_ERROR THEN
1912: ROLLBACK TO Do_ItemChannelMatch_Pvt;
1913: x_return_status := FND_API.G_RET_STS_ERROR;
1914: -- Standard call to get message count and if count=1, get the message
1915: FND_MSG_PUB.Count_And_Get (
1916: p_encoded => FND_API.G_FALSE,
1917: p_count => x_msg_count,
1918: p_data => x_msg_data

Line 1926: -- Standard call to get message count and if count=1, get the message

1922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1923: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1924: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1925: END IF;
1926: -- Standard call to get message count and if count=1, get the message
1927: FND_MSG_PUB.Count_And_Get (
1928: p_encoded => FND_API.G_FALSE,
1929: p_count => x_msg_count,
1930: p_data => x_msg_data

Line 2306: --Standard check of commit

2302: );
2303: END IF;
2304: END IF;
2305: END IF;
2306: --Standard check of commit
2307: IF FND_API.To_Boolean ( p_commit ) THEN
2308: COMMIT WORK;
2309: END IF;
2310: --Standard call to get message count and if count=1, get the message

Line 2310: --Standard call to get message count and if count=1, get the message

2306: --Standard check of commit
2307: IF FND_API.To_Boolean ( p_commit ) THEN
2308: COMMIT WORK;
2309: END IF;
2310: --Standard call to get message count and if count=1, get the message
2311: FND_MSG_PUB.Count_And_Get (
2312: p_encoded => FND_API.G_FALSE,
2313: p_count => x_msg_count,
2314: p_data => x_msg_data

Line 2320: -- Standard call to get message count and if count=1, get the message

2316: EXCEPTION
2317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2318: ROLLBACK TO Do_ItemChannelMatch_Pvt;
2319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2320: -- Standard call to get message count and if count=1, get the message
2321: FND_MSG_PUB.Count_And_Get (
2322: p_encoded => FND_API.G_FALSE,
2323: p_count => x_msg_count,
2324: p_data => x_msg_data

Line 2329: -- Standard call to get message count and if count=1, get the message

2325: );
2326: WHEN FND_API.G_EXC_ERROR THEN
2327: ROLLBACK TO Do_ItemChannelMatch_Pvt;
2328: x_return_status := FND_API.G_RET_STS_ERROR;
2329: -- Standard call to get message count and if count=1, get the message
2330: FND_MSG_PUB.Count_And_Get (
2331: p_encoded => FND_API.G_FALSE,
2332: p_count => x_msg_count,
2333: p_data => x_msg_data

Line 2341: -- Standard call to get message count and if count=1, get the message

2337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2338: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2339: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2340: END IF;
2341: -- Standard call to get message count and if count=1, get the message
2342: FND_MSG_PUB.Count_And_Get (
2343: p_encoded => FND_API.G_FALSE,
2344: p_count => x_msg_count,
2345: p_data => x_msg_data

Line 2486: --Standard check of commit

2482: AND channel_id is null;
2483: --
2484: END IF;
2485: END IF;
2486: --Standard check of commit
2487: IF FND_API.To_Boolean ( p_commit ) THEN
2488: COMMIT WORK;
2489: END IF;
2490: --Standard call to get message count and if count=1, get the message

Line 2490: --Standard call to get message count and if count=1, get the message

2486: --Standard check of commit
2487: IF FND_API.To_Boolean ( p_commit ) THEN
2488: COMMIT WORK;
2489: END IF;
2490: --Standard call to get message count and if count=1, get the message
2491: FND_MSG_PUB.Count_And_Get (
2492: p_encoded => FND_API.G_FALSE,
2493: p_count => x_msg_count,
2494: p_data => x_msg_data

Line 2500: -- Standard call to get message count and if count=1, get the message

2496: EXCEPTION
2497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2498: ROLLBACK TO Remove_ItemChannelMatch_PVT;
2499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2500: -- Standard call to get message count and if count=1, get the message
2501: FND_MSG_PUB.Count_And_Get (
2502: p_encoded => FND_API.G_FALSE,
2503: p_count => x_msg_count,
2504: p_data => x_msg_data

Line 2509: -- Standard call to get message count and if count=1, get the message

2505: );
2506: WHEN FND_API.G_EXC_ERROR THEN
2507: ROLLBACK TO Remove_ItemChannelMatch_PVT;
2508: x_return_status := FND_API.G_RET_STS_ERROR;
2509: -- Standard call to get message count and if count=1, get the message
2510: FND_MSG_PUB.Count_And_Get (
2511: p_encoded => FND_API.G_FALSE,
2512: p_count => x_msg_count,
2513: p_data => x_msg_data

Line 2521: -- Standard call to get message count and if count=1, get the message

2517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2518: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2519: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2520: END IF;
2521: -- Standard call to get message count and if count=1, get the message
2522: FND_MSG_PUB.Count_And_Get (
2523: p_encoded => FND_API.G_FALSE,
2524: p_count => x_msg_count,
2525: p_data => x_msg_data

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

2564: AND RSC.resource_type = p_resource_type;
2565: --
2566: BEGIN
2567: --DBMS_OUTPUT.PUT_LINE('ENTER : Get_UserTerritory');
2568: -- Standard call to check for call compatibility.
2569: IF NOT FND_API.Compatible_API_Call (
2570: l_api_version,
2571: p_api_version,
2572: l_api_name,

Line 2614: --Standard call to get message count and if count=1, get the message

2610: l_rec_count := l_rec_count + 1;
2611: END LOOP;
2612: --TYPE territory_tbl_type IS TABLE OF NUMBER;
2613: --TYPE terr_name_tbl_type IS TABLE OF VARCHAR2(4000);
2614: --Standard call to get message count and if count=1, get the message
2615: FND_MSG_PUB.Count_And_Get (
2616: p_encoded => FND_API.G_FALSE,
2617: p_count => x_msg_count,
2618: p_data => x_msg_data

Line 2623: -- Standard call to get message count and if count=1, get the message

2619: );
2620: EXCEPTION
2621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2623: -- Standard call to get message count and if count=1, get the message
2624: FND_MSG_PUB.Count_And_Get (
2625: p_encoded => FND_API.G_FALSE,
2626: p_count => x_msg_count,
2627: p_data => x_msg_data

Line 2631: -- Standard call to get message count and if count=1, get the message

2627: p_data => x_msg_data
2628: );
2629: WHEN FND_API.G_EXC_ERROR THEN
2630: x_return_status := FND_API.G_RET_STS_ERROR;
2631: -- Standard call to get message count and if count=1, get the message
2632: FND_MSG_PUB.Count_And_Get (
2633: p_encoded => FND_API.G_FALSE,
2634: p_count => x_msg_count,
2635: p_data => x_msg_data

Line 2642: -- Standard call to get message count and if count=1, get the message

2638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2639: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2641: END IF;
2642: -- Standard call to get message count and if count=1, get the message
2643: FND_MSG_PUB.Count_And_Get (
2644: p_encoded => FND_API.G_FALSE,
2645: p_count => x_msg_count,
2646: p_data => x_msg_data

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

2679: AND channel_category_id IS NULL
2680: AND table_name_code = p_table_name_code;
2681: --
2682: BEGIN
2683: -- Standard call to check for call compatibility.
2684: IF NOT FND_API.Compatible_API_Call (
2685: l_api_version,
2686: p_api_version,
2687: l_api_name,

Line 2722: --Standard call to get message count and if count=1, get the message

2718: FOR cur IN c_territory_item LOOP
2719: x_item_id_tbl(l_rec_count) := cur.item_id;
2720: l_rec_count := l_rec_count + 1;
2721: END LOOP;
2722: --Standard call to get message count and if count=1, get the message
2723: FND_MSG_PUB.Count_And_Get (
2724: p_encoded => FND_API.G_FALSE,
2725: p_count => x_msg_count,
2726: p_data => x_msg_data

Line 2731: -- Standard call to get message count and if count=1, get the message

2727: );
2728: EXCEPTION
2729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2731: -- Standard call to get message count and if count=1, get the message
2732: FND_MSG_PUB.Count_And_Get (
2733: p_encoded => FND_API.G_FALSE,
2734: p_count => x_msg_count,
2735: p_data => x_msg_data

Line 2739: -- Standard call to get message count and if count=1, get the message

2735: p_data => x_msg_data
2736: );
2737: WHEN FND_API.G_EXC_ERROR THEN
2738: x_return_status := FND_API.G_RET_STS_ERROR;
2739: -- Standard call to get message count and if count=1, get the message
2740: FND_MSG_PUB.Count_And_Get (
2741: p_encoded => FND_API.G_FALSE,
2742: p_count => x_msg_count,
2743: p_data => x_msg_data

Line 2750: -- Standard call to get message count and if count=1, get the message

2746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2747: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2748: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2749: END IF;
2750: -- Standard call to get message count and if count=1, get the message
2751: FND_MSG_PUB.Count_And_Get (
2752: p_encoded => FND_API.G_FALSE,
2753: p_count => x_msg_count,
2754: p_data => x_msg_data