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.IEX_PROMISES_PUB dependencies on FND_MSG_PUB

Line 61: FND_MSG_PUB.initialize;

57: END IF;
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE
60: IF FND_API.To_Boolean(p_init_msg_list) THEN
61: FND_MSG_PUB.initialize;
62: END IF;
63:
64: -- Initialize API return status to success
65: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 82: FND_MSG_PUB.Add;

78: END IF;
79: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
80: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
81: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
82: FND_MSG_PUB.Add;
83: RAISE FND_API.G_EXC_ERROR;
84: end if;
85:
86: -- validating table of promises

Line 99: FND_MSG_PUB.Add;

95: END IF;
96: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
97: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
98: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
99: FND_MSG_PUB.Add;
100: RAISE FND_API.G_EXC_ERROR;
101: end if;
102:
103: -- validating p_days

Line 116: FND_MSG_PUB.Add;

112: END IF;
113: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
114: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
115: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
116: FND_MSG_PUB.Add;
117: RAISE FND_API.G_EXC_ERROR;
118: end if;
119:
120: -- filter passed promises; we need only BROKEN_PROMISE promises for update

Line 213: FND_MSG_PUB.Count_And_Get(

209: END IF;
210:
211: x_return_status := l_return_status;
212: -- Standard call to get message count and if count is 1, get message info
213: FND_MSG_PUB.Count_And_Get(
214: p_encoded => FND_API.G_FALSE,
215: p_count => x_msg_count,
216: p_data => x_msg_data);
217:

Line 222: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

218: EXCEPTION
219: WHEN FND_API.G_EXC_ERROR THEN
220: ROLLBACK TO SHOW_IN_UWQ_PVT;
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224: ROLLBACK TO SHOW_IN_UWQ_PVT;
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 226: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

222: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224: ROLLBACK TO SHOW_IN_UWQ_PVT;
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
227: WHEN OTHERS THEN
228: ROLLBACK TO SHOW_IN_UWQ_PVT;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 230: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

226: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
227: WHEN OTHERS THEN
228: ROLLBACK TO SHOW_IN_UWQ_PVT;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
231: THEN
232: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
233: END IF;
234: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 232: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

228: ROLLBACK TO SHOW_IN_UWQ_PVT;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
231: THEN
232: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
233: END IF;
234: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
235: end;
236:

Line 234: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

230: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
231: THEN
232: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
233: END IF;
234: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
235: end;
236:
237:
238: PROCEDURE SET_STRATEGY(P_PROMISE_ID IN NUMBER,

Line 292: FND_MSG_PUB.Add;

288: END IF;
289: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
290: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
291: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PROMISE_ID');
292: FND_MSG_PUB.Add;
293: RAISE FND_API.G_EXC_ERROR;
294: end if;
295:
296: if P_STATUS is null then

Line 303: FND_MSG_PUB.Add;

299: END IF;
300: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
301: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
302: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_STATUS');
303: FND_MSG_PUB.Add;
304: RAISE FND_API.G_EXC_ERROR;
305: end if;
306:
307: --begin bug#2369298 schekuri 24-Feb-2006

Line 452: FND_MSG_PUB.Add;

448: iex_debug_pub.LogMessage(G_PKG_NAME || '.SEND_FFM: Return status ' || l_return_status);
449: END IF;
450: IF l_return_status <> 'S' then
451: FND_MESSAGE.SET_NAME('IEX', 'IEX_FULFILLMENT_ERROR');
452: FND_MSG_PUB.Add;
453: end if;
454: end if;
455: end if;
456: EXCEPTION

Line 612: FND_MSG_PUB.Add;

608: END IF;
609: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
610: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
611: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
612: FND_MSG_PUB.Add;
613: RAISE FND_API.G_EXC_ERROR;
614: end if;
615:
616: /* validate promise_amount */

Line 629: FND_MSG_PUB.Add;

625: END IF;
626: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
627: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
628: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
629: FND_MSG_PUB.Add;
630: RAISE FND_API.G_EXC_ERROR;
631: end if;
632:
633: /* validate promise_date */

Line 646: FND_MSG_PUB.Add;

642: END IF;
643: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
644: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
645: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
646: FND_MSG_PUB.Add;
647: RAISE FND_API.G_EXC_ERROR;
648: end if;
649:
650: /* validate currency */

Line 663: FND_MSG_PUB.Add;

659: END IF;
660: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
661: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
662: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
663: FND_MSG_PUB.Add;
664: RAISE FND_API.G_EXC_ERROR;
665: end if;
666:
667: /* validate resource_id */

Line 680: FND_MSG_PUB.Add;

676: END IF;
677: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
678: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
679: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
680: FND_MSG_PUB.Add;
681: RAISE FND_API.G_EXC_ERROR;
682: end if;
683:
684: /* get functional currency */

Line 719: FND_MSG_PUB.Add;

715: END IF;
716: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
717: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
718: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
719: FND_MSG_PUB.Add;
720: RAISE FND_API.G_EXC_ERROR;
721: end if;
722: else
723: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 741: FND_MSG_PUB.Add;

737: END IF;
738: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
739: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
740: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
741: FND_MSG_PUB.Add;
742: RAISE FND_API.G_EXC_ERROR;
743: end if;
744:
745: /* validate promise object */

Line 774: FND_MSG_PUB.Add;

770: END IF;
771: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
772: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
773: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
774: FND_MSG_PUB.Add;
775: RAISE FND_API.G_EXC_ERROR;
776: end if;
777:
778: /* validate promise currency */

Line 791: FND_MSG_PUB.Add;

787: END IF;
788: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
789: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
790: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
791: FND_MSG_PUB.Add;
792: RAISE FND_API.G_EXC_ERROR;
793: end if;
794:
795: elsif P_PROMISE_REC.PROMISE_TARGET = 'INVOICES' then

Line 810: FND_MSG_PUB.Add;

806: END IF;
807: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
808: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
809: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
810: FND_MSG_PUB.Add;
811: RAISE FND_API.G_EXC_ERROR;
812: end if;
813:
814: /* validate promise date */

Line 843: FND_MSG_PUB.Add;

839: END IF;
840: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
841: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
842: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
843: FND_MSG_PUB.Add;
844: RAISE FND_API.G_EXC_ERROR;
845: end if;
846:
847: /* validate promise currency */

Line 870: FND_MSG_PUB.Add;

866: END IF;
867: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
868: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
869: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
870: FND_MSG_PUB.Add;
871: RAISE FND_API.G_EXC_ERROR;
872: end if;
873:
874: elsif P_PROMISE_REC.PROMISE_TARGET = 'CNSLD' then

Line 889: FND_MSG_PUB.Add;

885: END IF;
886: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
887: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
888: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
889: FND_MSG_PUB.Add;
890: RAISE FND_API.G_EXC_ERROR;
891: end if;
892:
893: /* validate promise date */

Line 922: FND_MSG_PUB.Add;

918: END IF;
919: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
920: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
921: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
922: FND_MSG_PUB.Add;
923: RAISE FND_API.G_EXC_ERROR;
924: end if;
925:
926: /* validate promise currency */

Line 949: FND_MSG_PUB.Add;

945: END IF;
946: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
947: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
948: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
949: FND_MSG_PUB.Add;
950: RAISE FND_API.G_EXC_ERROR;
951: end if;
952:
953: elsif P_PROMISE_REC.PROMISE_TARGET = 'CONTRACTS' then

Line 968: FND_MSG_PUB.Add;

964: END IF;
965: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
966: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
967: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
968: FND_MSG_PUB.Add;
969: RAISE FND_API.G_EXC_ERROR;
970: end if;
971:
972: /* validate promise date */

Line 1001: FND_MSG_PUB.Add;

997: END IF;
998: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
999: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
1000: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1001: FND_MSG_PUB.Add;
1002: RAISE FND_API.G_EXC_ERROR;
1003: end if;
1004:
1005: /* validate promise currency */

Line 1035: FND_MSG_PUB.Add;

1031: END IF;
1032: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1033: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
1034: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1035: FND_MSG_PUB.Add;
1036: RAISE FND_API.G_EXC_ERROR;
1037: end if;
1038:
1039: end if;

Line 1100: FND_MSG_PUB.initialize;

1096: END IF;
1097:
1098: -- Initialize message list if p_init_msg_list is set to TRUE
1099: IF FND_API.To_Boolean(p_init_msg_list) THEN
1100: FND_MSG_PUB.initialize;
1101: END IF;
1102:
1103: -- Initialize API return status to success
1104: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1356: FND_MSG_PUB.Count_And_Get(

1352: END IF;
1353:
1354: x_return_status := l_return_status;
1355: -- Standard call to get message count and if count is 1, get message info
1356: FND_MSG_PUB.Count_And_Get(
1357: p_encoded => FND_API.G_FALSE,
1358: p_count => x_msg_count,
1359: p_data => x_msg_data);
1360:

Line 1369: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1365: EXCEPTION
1366: WHEN FND_API.G_EXC_ERROR THEN
1367: ROLLBACK TO INSERT_PROMISE_PVT;
1368: x_return_status := FND_API.G_RET_STS_ERROR;
1369: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1371: ROLLBACK TO INSERT_PROMISE_PVT;
1372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1373: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1373: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1369: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1371: ROLLBACK TO INSERT_PROMISE_PVT;
1372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1373: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1374: WHEN OTHERS THEN
1375: ROLLBACK TO INSERT_PROMISE_PVT;
1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1377: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1377: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1373: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1374: WHEN OTHERS THEN
1375: ROLLBACK TO INSERT_PROMISE_PVT;
1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1377: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1378: THEN
1379: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1380: END IF;
1381: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1379: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1375: ROLLBACK TO INSERT_PROMISE_PVT;
1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1377: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1378: THEN
1379: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1380: END IF;
1381: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1382:
1383: END;

Line 1381: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1377: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1378: THEN
1379: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1380: END IF;
1381: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1382:
1383: END;
1384:
1385: PROCEDURE VALIDATE_UPDATE_INPUT(P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_UPDT_REC_TYPE)

Line 1450: FND_MSG_PUB.Add;

1446: END IF;
1447: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1448: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1449: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1450: FND_MSG_PUB.Add;
1451: RAISE FND_API.G_EXC_ERROR;
1452: end if;
1453:
1454: /* validate promise_amount */

Line 1467: FND_MSG_PUB.Add;

1463: END IF;
1464: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1465: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1466: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1467: FND_MSG_PUB.Add;
1468: RAISE FND_API.G_EXC_ERROR;
1469: end if;
1470:
1471: /* validate resource_id */

Line 1484: FND_MSG_PUB.Add;

1480: END IF;
1481: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1482: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1483: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1484: FND_MSG_PUB.Add;
1485: RAISE FND_API.G_EXC_ERROR;
1486: end if;
1487:
1488: /* pull data from db to do some validation */

Line 1524: FND_MSG_PUB.Add;

1520: END IF;
1521: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1522: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1523: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1524: FND_MSG_PUB.Add;
1525: RAISE FND_API.G_EXC_ERROR;
1526: end if;
1527:
1528: /* validate promise_state */

Line 1540: FND_MSG_PUB.Add;

1536: END IF;
1537: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1538: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1539: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1540: FND_MSG_PUB.Add;
1541: RAISE FND_API.G_EXC_ERROR;
1542: end if;
1543:
1544: /* validate remaining amount */

Line 1556: FND_MSG_PUB.Add;

1552: END IF;
1553: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1554: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1555: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1556: FND_MSG_PUB.Add;
1557: RAISE FND_API.G_EXC_ERROR;
1558: end if;
1559:
1560: /* validate promise_date */

Line 1573: FND_MSG_PUB.Add;

1569: END IF;
1570: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1571: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1572: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1573: FND_MSG_PUB.Add;
1574: RAISE FND_API.G_EXC_ERROR;
1575: end if;
1576:
1577: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1630: FND_MSG_PUB.Add;

1626: END IF;
1627: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1628: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1629: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1630: FND_MSG_PUB.Add;
1631: RAISE FND_API.G_EXC_ERROR;
1632: end if;
1633:
1634: /* validate payment_method */

Line 1658: FND_MSG_PUB.Add;

1654: END IF;
1655: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1656: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1657: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1658: FND_MSG_PUB.Add;
1659: RAISE FND_API.G_EXC_ERROR;
1660: end if;
1661: else
1662: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1714: FND_MSG_PUB.initialize;

1710: END IF;
1711:
1712: -- Initialize message list if p_init_msg_list is set to TRUE
1713: IF FND_API.To_Boolean(p_init_msg_list) THEN
1714: FND_MSG_PUB.initialize;
1715: END IF;
1716:
1717: -- Initialize API return status to success
1718: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1905: FND_MSG_PUB.Count_And_Get(

1901: -- END OF BODY OF API
1902:
1903: x_return_status := l_return_status;
1904: -- Standard call to get message count and if count is 1, get message info
1905: FND_MSG_PUB.Count_And_Get(
1906: p_encoded => FND_API.G_FALSE,
1907: p_count => x_msg_count,
1908: p_data => x_msg_data);
1909:

Line 1918: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1914: EXCEPTION
1915: WHEN FND_API.G_EXC_ERROR THEN
1916: ROLLBACK TO UPDATE_PROMISE_PVT;
1917: x_return_status := FND_API.G_RET_STS_ERROR;
1918: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1920: ROLLBACK TO UPDATE_PROMISE_PVT;
1921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1922: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1922: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1918: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1920: ROLLBACK TO UPDATE_PROMISE_PVT;
1921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1922: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1923: WHEN OTHERS THEN
1924: ROLLBACK TO UPDATE_PROMISE_PVT;
1925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1926: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1926: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1922: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1923: WHEN OTHERS THEN
1924: ROLLBACK TO UPDATE_PROMISE_PVT;
1925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1926: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1927: THEN
1928: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1929: END IF;
1930: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1928: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1924: ROLLBACK TO UPDATE_PROMISE_PVT;
1925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1926: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1927: THEN
1928: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1929: END IF;
1930: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1931:
1932: END;

Line 1930: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1926: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1927: THEN
1928: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1929: END IF;
1930: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1931:
1932: END;
1933:
1934:

Line 1955: FND_MSG_PUB.Add;

1951: END IF;
1952: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1953: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1954: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1955: FND_MSG_PUB.Add;
1956: RAISE FND_API.G_EXC_ERROR;
1957: end if;
1958:
1959: /* validate resource_id */

Line 1972: FND_MSG_PUB.Add;

1968: END IF;
1969: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1970: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1971: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1972: FND_MSG_PUB.Add;
1973: RAISE FND_API.G_EXC_ERROR;
1974: end if;
1975:
1976: end;

Line 2023: FND_MSG_PUB.initialize;

2019: END IF;
2020:
2021: -- Initialize message list if p_init_msg_list is set to TRUE
2022: IF FND_API.To_Boolean(p_init_msg_list) THEN
2023: FND_MSG_PUB.initialize;
2024: END IF;
2025:
2026: -- Initialize API return status to success
2027: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2176: FND_MSG_PUB.Count_And_Get(

2172: -- END OF BODY OF API
2173:
2174: x_return_status := l_return_status;
2175: -- Standard call to get message count and if count is 1, get message info
2176: FND_MSG_PUB.Count_And_Get(
2177: p_encoded => FND_API.G_FALSE,
2178: p_count => x_msg_count,
2179: p_data => x_msg_data);
2180:

Line 2189: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2185: EXCEPTION
2186: WHEN FND_API.G_EXC_ERROR THEN
2187: ROLLBACK TO CANCEL_PROMISE_PVT;
2188: x_return_status := FND_API.G_RET_STS_ERROR;
2189: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2191: ROLLBACK TO CANCEL_PROMISE_PVT;
2192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2193: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 2193: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2189: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2191: ROLLBACK TO CANCEL_PROMISE_PVT;
2192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2193: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2194: WHEN OTHERS THEN
2195: ROLLBACK TO CANCEL_PROMISE_PVT;
2196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2197: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2197: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2193: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2194: WHEN OTHERS THEN
2195: ROLLBACK TO CANCEL_PROMISE_PVT;
2196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2197: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2198: THEN
2199: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2200: END IF;
2201: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 2199: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

2195: ROLLBACK TO CANCEL_PROMISE_PVT;
2196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2197: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2198: THEN
2199: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2200: END IF;
2201: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2202:
2203: END;

Line 2201: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2197: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2198: THEN
2199: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2200: END IF;
2201: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2202:
2203: END;
2204:
2205:

Line 2235: FND_MSG_PUB.Add;

2231: END IF;
2232: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2233: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2234: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2235: FND_MSG_PUB.Add;
2236: RAISE FND_API.G_EXC_ERROR;
2237: end if;
2238:
2239: --commenting begin for bug 6717279 by gnramasa 25th Aug 08

Line 2272: FND_MSG_PUB.Add;

2268: END IF;
2269: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2270: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2271: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2272: FND_MSG_PUB.Add;
2273: RAISE FND_API.G_EXC_ERROR;
2274: end if;
2275: */
2276: --commenting end for bug 6717279 by gnramasa 25th Aug 08

Line 2290: FND_MSG_PUB.Add;

2286: END IF;
2287: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2288: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2289: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2290: FND_MSG_PUB.Add;
2291: RAISE FND_API.G_EXC_ERROR;
2292: end if;
2293:
2294: /* validate resource_id */

Line 2307: FND_MSG_PUB.Add;

2303: END IF;
2304: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2305: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2306: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2307: FND_MSG_PUB.Add;
2308: RAISE FND_API.G_EXC_ERROR;
2309: end if;
2310:
2311: /* validate payment_method */

Line 2335: FND_MSG_PUB.Add;

2331: END IF;
2332: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2333: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2334: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2335: FND_MSG_PUB.Add;
2336: RAISE FND_API.G_EXC_ERROR;
2337: end if;
2338: else
2339: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2417: FND_MSG_PUB.initialize;

2413: END IF;
2414:
2415: -- Initialize message list if p_init_msg_list is set to TRUE
2416: IF FND_API.To_Boolean(p_init_msg_list) THEN
2417: FND_MSG_PUB.initialize;
2418: END IF;
2419:
2420: -- Initialize API return status to success
2421: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2809: FND_MSG_PUB.Count_And_Get(

2805: -- END OF BODY OF API
2806:
2807: x_return_status := l_return_status;
2808: -- Standard call to get message count and if count is 1, get message info
2809: FND_MSG_PUB.Count_And_Get(
2810: p_encoded => FND_API.G_FALSE,
2811: p_count => x_msg_count,
2812: p_data => x_msg_data);
2813:

Line 2822: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2818: EXCEPTION
2819: WHEN FND_API.G_EXC_ERROR THEN
2820: ROLLBACK TO MASS_PROMISE_PVT;
2821: x_return_status := FND_API.G_RET_STS_ERROR;
2822: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2824: ROLLBACK TO MASS_PROMISE_PVT;
2825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2826: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 2826: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2822: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2824: ROLLBACK TO MASS_PROMISE_PVT;
2825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2826: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2827: WHEN OTHERS THEN
2828: ROLLBACK TO MASS_PROMISE_PVT;
2829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2830: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2830: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2826: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2827: WHEN OTHERS THEN
2828: ROLLBACK TO MASS_PROMISE_PVT;
2829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2830: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2831: THEN
2832: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2833: END IF;
2834: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 2832: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

2828: ROLLBACK TO MASS_PROMISE_PVT;
2829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2830: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2831: THEN
2832: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2833: END IF;
2834: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2835:
2836: END;

Line 2834: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2830: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2831: THEN
2832: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2833: END IF;
2834: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2835:
2836: END;
2837: begin
2838: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;