83:
84: BEGIN
85:
86:
87: -- Standard Start of API savepoint
88: SAVEPOINT createOutboxMessage_pvt;
89:
90: -- Standard call to check for call compatibility.
91: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
86:
87: -- Standard Start of API savepoint
88: SAVEPOINT createOutboxMessage_pvt;
89:
90: -- Standard call to check for call compatibility.
91: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
92: 1.0,
93: l_api_name,
94: G_PKG_NAME)
219: x_msg_data := l_msg_data;
220:
221: END IF;
222: -------------------End Code------------------------
223: -- Standard Check Of p_commit.
224: IF FND_API.To_Boolean(p_commit) THEN
225: COMMIT WORK;
226: END IF;
227:
224: IF FND_API.To_Boolean(p_commit) THEN
225: COMMIT WORK;
226: END IF;
227:
228: -- Standard callto get message count and if count is 1, get message info.
229: FND_MSG_PUB.Count_And_Get
230: ( p_count => x_msg_count,
231: p_data => x_msg_data
232: );
288: l_rt_interaction_id NUMBER;
289:
290: BEGIN
291:
292: -- Standard Start of API savepoint
293: SAVEPOINT cancelOutboxMessage_pvt;
294:
295: -- Standard call to check for call compatibility.
296: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
291:
292: -- Standard Start of API savepoint
293: SAVEPOINT cancelOutboxMessage_pvt;
294:
295: -- Standard call to check for call compatibility.
296: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
297: 1.0,
298: l_api_name,
299: G_PKG_NAME)
327: last_update_login = l_last_update_login
328: WHERE rt_interaction_id = l_rt_interaction_id;
329:
330: -------------------End Code------------------------
331: -- Standard Check Of p_commit.
332: IF FND_API.To_Boolean(p_commit) THEN
333: COMMIT WORK;
334: END IF;
335:
391: l_reason_id NUMBER;
392:
393: BEGIN
394:
395: -- Standard Start of API savepoint
396: SAVEPOINT submitOutboxMessage_pvt;
397:
398: -- Standard call to check for call compatibility.
399: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
394:
395: -- Standard Start of API savepoint
396: SAVEPOINT submitOutboxMessage_pvt;
397:
398: -- Standard call to check for call compatibility.
399: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
400: 1.0,
401: l_api_name,
402: G_PKG_NAME)
447: x_msg_count := l_msg_count;
448: x_msg_data := l_msg_data;
449:
450: -------------------End Code------------------------
451: -- Standard Check Of p_commit.
452: IF FND_API.To_Boolean(p_commit) THEN
453: COMMIT WORK;
454: END IF;
455:
516: l_msg_data VARCHAR2(300);
517:
518: BEGIN
519:
520: -- Standard Start of API savepoint
521: SAVEPOINT writeOutboxError_pvt;
522:
523: -- Standard call to check for call compatibility.
524: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
519:
520: -- Standard Start of API savepoint
521: SAVEPOINT writeOutboxError_pvt;
522:
523: -- Standard call to check for call compatibility.
524: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
525: 1.0,
526: l_api_name,
527: G_PKG_NAME)
548: VALUES ( l_error_id, p_rt_media_item_id, p_error_summary,
549: p_error_msg, SYSDATE, G_ACTIVE );
550:
551: -------------------End Code------------------------
552: -- Standard Check Of p_commit.
553: IF FND_API.To_Boolean(p_commit) THEN
554: COMMIT WORK;
555: END IF;
556:
637: l_relationship_id NUMBER;
638:
639: BEGIN
640:
641: -- Standard Start of API savepoint
642: SAVEPOINT createAutoReply_pvt;
643:
644: -- Standard call to check for call compatibility.
645: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
640:
641: -- Standard Start of API savepoint
642: SAVEPOINT createAutoReply_pvt;
643:
644: -- Standard call to check for call compatibility.
645: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
646: 1.0,
647: l_api_name,
648: G_PKG_NAME)
840:
841: END IF;
842:
843: -------------------End Code------------------------
844: -- Standard Check Of p_commit.
845: IF FND_API.To_Boolean(p_commit) THEN
846: COMMIT WORK;
847: END IF;
848:
845: IF FND_API.To_Boolean(p_commit) THEN
846: COMMIT WORK;
847: END IF;
848:
849: -- Standard callto get message count and if count is 1, get message info.
850: FND_MSG_PUB.Count_And_Get
851: ( p_count => x_msg_count,
852: p_data => x_msg_data
853: );
938: );
939:
940: update IEM_MSG_PARTS set PART_DATA = p_text where REF_KEY = p_outbox_item_id and PART_TYPE = 'HTMLTEXT' and PART_NAME = l_sequence;
941:
942: -- Standard check of p_commit
943: IF FND_API.To_Boolean(p_commit) THEN
944: COMMIT WORK;
945: END IF;
946:
943: IF FND_API.To_Boolean(p_commit) THEN
944: COMMIT WORK;
945: END IF;
946:
947: -- Standard call to get message count and if count is 1, get message info.
948: FND_MSG_PUB.Count_And_Get(
949: p_count => x_msg_count,
950: p_data => x_msg_data
951: );
1059: 'N',
1060: SYSDATE
1061: );
1062:
1063: -- Standard check of p_commit
1064: IF FND_API.To_Boolean(p_commit) THEN
1065: COMMIT WORK;
1066: END IF;
1067:
1064: IF FND_API.To_Boolean(p_commit) THEN
1065: COMMIT WORK;
1066: END IF;
1067:
1068: -- Standard call to get message count and if count is 1, get message info.
1069: FND_MSG_PUB.Count_And_Get(
1070: p_count => x_msg_count,
1071: p_data => x_msg_data
1072: );
1206: SYSDATE
1207: );
1208: END IF;
1209:
1210: -- Standard check of p_commit
1211: IF FND_API.To_Boolean(p_commit) THEN
1212: COMMIT WORK;
1213: END IF;
1214:
1211: IF FND_API.To_Boolean(p_commit) THEN
1212: COMMIT WORK;
1213: END IF;
1214:
1215: -- Standard call to get message count and if count is 1, get message info.
1216: FND_MSG_PUB.Count_And_Get(
1217: p_count => x_msg_count,
1218: p_data => x_msg_data
1219: );
1290: l_index NUMBER;
1291:
1292: BEGIN
1293:
1294: -- Standard Start of API savepoint
1295: SAVEPOINT getAccountList_pvt;
1296:
1297: -- Standard call to check for call compatibility.
1298: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1293:
1294: -- Standard Start of API savepoint
1295: SAVEPOINT getAccountList_pvt;
1296:
1297: -- Standard call to check for call compatibility.
1298: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1299: 1.0,
1300: l_api_name,
1301: G_PKG_NAME)
1337: x_msg_count := l_msg_count;
1338: x_msg_data := l_msg_data;
1339: END IF;
1340: -------------------End Code------------------------
1341: -- Standard Check Of p_commit.
1342: IF FND_API.To_Boolean(p_commit) THEN
1343: COMMIT WORK;
1344: END IF;
1345:
1400:
1401:
1402: BEGIN
1403:
1404: -- Standard Start of API savepoint
1405: SAVEPOINT redirectMessage_pvt;
1406:
1407: -- Standard call to check for call compatibility.
1408: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1403:
1404: -- Standard Start of API savepoint
1405: SAVEPOINT redirectMessage_pvt;
1406:
1407: -- Standard call to check for call compatibility.
1408: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1409: 1.0,
1410: l_api_name,
1411: G_PKG_NAME)
1472: );
1473:
1474: x_outbox_item_id := l_m_sequence;
1475: -------------------End Code------------------------
1476: -- Standard Check Of p_commit.
1477: IF FND_API.To_Boolean(p_commit) THEN
1478: COMMIT WORK;
1479: END IF;
1480:
1477: IF FND_API.To_Boolean(p_commit) THEN
1478: COMMIT WORK;
1479: END IF;
1480:
1481: -- Standard callto get message count and if count is 1, get message info.
1482: FND_MSG_PUB.Count_And_Get
1483: ( p_encoded => FND_API.G_TRUE,
1484: p_count => x_msg_count,
1485: p_data => x_msg_data
1581:
1582: BEGIN
1583:
1584:
1585: -- Standard Start of API savepoint
1586: SAVEPOINT autoForward_pvt;
1587:
1588: -- Standard call to check for call compatibility.
1589: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1584:
1585: -- Standard Start of API savepoint
1586: SAVEPOINT autoForward_pvt;
1587:
1588: -- Standard call to check for call compatibility.
1589: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1590: 1.0,
1591: l_api_name,
1592: G_PKG_NAME)
1791: x_msg_data := l_msg_data;
1792:
1793: END IF;
1794: -------------------End Code------------------------
1795: -- Standard Check Of p_commit.
1796: IF FND_API.To_Boolean(p_commit) THEN
1797: COMMIT WORK;
1798: END IF;
1799:
1796: IF FND_API.To_Boolean(p_commit) THEN
1797: COMMIT WORK;
1798: END IF;
1799:
1800: -- Standard callto get message count and if count is 1, get message info.
1801: FND_MSG_PUB.Count_And_Get
1802: ( p_count => x_msg_count,
1803: p_data => x_msg_data
1804: );
1891: l_reason_id NUMBER;
1892: IEM_BAD_IH_ID EXCEPTION;
1893: BEGIN
1894:
1895: -- Standard Start of API savepoint
1896: SAVEPOINT createSRAutoNotification_spt;
1897:
1898: -- Standard call to check for call compatibility.
1899: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1894:
1895: -- Standard Start of API savepoint
1896: SAVEPOINT createSRAutoNotification_spt;
1897:
1898: -- Standard call to check for call compatibility.
1899: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1900: 1.0,
1901: l_api_name,
1902: G_PKG_NAME)
2102:
2103: END IF;
2104:
2105: -------------------End Code------------------------
2106: -- Standard Check Of p_commit.
2107: IF FND_API.To_Boolean(p_commit) THEN
2108: COMMIT WORK;
2109: END IF;
2110:
2107: IF FND_API.To_Boolean(p_commit) THEN
2108: COMMIT WORK;
2109: END IF;
2110:
2111: -- Standard callto get message count and if count is 1, get message info.
2112: FND_MSG_PUB.Count_And_Get
2113: ( p_count => x_msg_count,
2114: p_data => x_msg_data
2115: );