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 60: FND_MSG_PUB.initialize;

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

Line 81: FND_MSG_PUB.Add;

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

Line 98: FND_MSG_PUB.Add;

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

Line 115: FND_MSG_PUB.Add;

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

Line 212: FND_MSG_PUB.Count_And_Get(

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

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

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

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

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

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

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

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

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

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

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

Line 299: FND_MSG_PUB.Add;

295: END IF;
296: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
297: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
298: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PROMISE_ID');
299: FND_MSG_PUB.Add;
300: RAISE FND_API.G_EXC_ERROR;
301: end if;
302:
303: if P_STATUS is null then

Line 310: FND_MSG_PUB.Add;

306: END IF;
307: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
308: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
309: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_STATUS');
310: FND_MSG_PUB.Add;
311: RAISE FND_API.G_EXC_ERROR;
312: end if;
313:
314: --begin bug#2369298 schekuri 24-Feb-2006

Line 467: FND_MSG_PUB.Add;

463: iex_debug_pub.LogMessage(G_PKG_NAME || '.SEND_FFM: Return status ' || l_return_status);
464: END IF;
465: IF l_return_status <> 'S' then
466: FND_MESSAGE.SET_NAME('IEX', 'IEX_FULFILLMENT_ERROR');
467: FND_MSG_PUB.Add;
468: end if;
469: end if;
470: end if;
471: EXCEPTION

Line 627: FND_MSG_PUB.Add;

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

Line 644: FND_MSG_PUB.Add;

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

Line 661: FND_MSG_PUB.Add;

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

Line 678: FND_MSG_PUB.Add;

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

Line 695: FND_MSG_PUB.Add;

691: END IF;
692: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
693: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
694: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
695: FND_MSG_PUB.Add;
696: RAISE FND_API.G_EXC_ERROR;
697: end if;
698:
699: /* get functional currency */

Line 734: FND_MSG_PUB.Add;

730: END IF;
731: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
732: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
733: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
734: FND_MSG_PUB.Add;
735: RAISE FND_API.G_EXC_ERROR;
736: end if;
737: else
738: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 756: FND_MSG_PUB.Add;

752: END IF;
753: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
754: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
755: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
756: FND_MSG_PUB.Add;
757: RAISE FND_API.G_EXC_ERROR;
758: end if;
759:
760: /* validate promise object */

Line 789: FND_MSG_PUB.Add;

785: END IF;
786: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
787: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
788: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
789: FND_MSG_PUB.Add;
790: RAISE FND_API.G_EXC_ERROR;
791: end if;
792:
793: /* validate promise currency */

Line 806: FND_MSG_PUB.Add;

802: END IF;
803: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
804: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
805: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
806: FND_MSG_PUB.Add;
807: RAISE FND_API.G_EXC_ERROR;
808: end if;
809:
810: elsif P_PROMISE_REC.PROMISE_TARGET = 'INVOICES' then

Line 825: FND_MSG_PUB.Add;

821: END IF;
822: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
823: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
824: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
825: FND_MSG_PUB.Add;
826: RAISE FND_API.G_EXC_ERROR;
827: end if;
828:
829: /* validate promise date */

Line 858: FND_MSG_PUB.Add;

854: END IF;
855: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
856: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
857: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
858: FND_MSG_PUB.Add;
859: RAISE FND_API.G_EXC_ERROR;
860: end if;
861:
862: /* validate promise currency */

Line 885: FND_MSG_PUB.Add;

881: END IF;
882: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
883: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
884: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
885: FND_MSG_PUB.Add;
886: RAISE FND_API.G_EXC_ERROR;
887: end if;
888:
889: elsif P_PROMISE_REC.PROMISE_TARGET = 'CNSLD' then

Line 904: FND_MSG_PUB.Add;

900: END IF;
901: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
902: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
903: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
904: FND_MSG_PUB.Add;
905: RAISE FND_API.G_EXC_ERROR;
906: end if;
907:
908: /* validate promise date */

Line 937: FND_MSG_PUB.Add;

933: END IF;
934: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
935: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
936: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
937: FND_MSG_PUB.Add;
938: RAISE FND_API.G_EXC_ERROR;
939: end if;
940:
941: /* validate promise currency */

Line 964: FND_MSG_PUB.Add;

960: END IF;
961: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
962: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
963: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
964: FND_MSG_PUB.Add;
965: RAISE FND_API.G_EXC_ERROR;
966: end if;
967:
968: elsif P_PROMISE_REC.PROMISE_TARGET = 'CONTRACTS' then

Line 983: FND_MSG_PUB.Add;

979: END IF;
980: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
981: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
982: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
983: FND_MSG_PUB.Add;
984: RAISE FND_API.G_EXC_ERROR;
985: end if;
986:
987: /* validate promise date */

Line 1016: FND_MSG_PUB.Add;

1012: END IF;
1013: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1014: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
1015: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1016: FND_MSG_PUB.Add;
1017: RAISE FND_API.G_EXC_ERROR;
1018: end if;
1019:
1020: /* validate promise currency */

Line 1050: FND_MSG_PUB.Add;

1046: END IF;
1047: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1048: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
1049: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1050: FND_MSG_PUB.Add;
1051: RAISE FND_API.G_EXC_ERROR;
1052: end if;
1053:
1054: end if;

Line 1115: FND_MSG_PUB.initialize;

1111: END IF;
1112:
1113: -- Initialize message list if p_init_msg_list is set to TRUE
1114: IF FND_API.To_Boolean(p_init_msg_list) THEN
1115: FND_MSG_PUB.initialize;
1116: END IF;
1117:
1118: -- Initialize API return status to success
1119: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1395: FND_MSG_PUB.Count_And_Get(

1391: END IF;
1392:
1393: x_return_status := l_return_status;
1394: -- Standard call to get message count and if count is 1, get message info
1395: FND_MSG_PUB.Count_And_Get(
1396: p_encoded => FND_API.G_FALSE,
1397: p_count => x_msg_count,
1398: p_data => x_msg_data);
1399:

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

1404: EXCEPTION
1405: WHEN FND_API.G_EXC_ERROR THEN
1406: ROLLBACK TO INSERT_PROMISE_PVT;
1407: x_return_status := FND_API.G_RET_STS_ERROR;
1408: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1410: ROLLBACK TO INSERT_PROMISE_PVT;
1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1412: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

1408: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1410: ROLLBACK TO INSERT_PROMISE_PVT;
1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1412: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1413: WHEN OTHERS THEN
1414: ROLLBACK TO INSERT_PROMISE_PVT;
1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1416: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

1412: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1413: WHEN OTHERS THEN
1414: ROLLBACK TO INSERT_PROMISE_PVT;
1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1416: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1417: THEN
1418: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1419: END IF;
1420: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

1414: ROLLBACK TO INSERT_PROMISE_PVT;
1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1416: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1417: THEN
1418: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1419: END IF;
1420: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1421:
1422: END;

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

1416: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1417: THEN
1418: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1419: END IF;
1420: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1421:
1422: END;
1423:
1424: PROCEDURE VALIDATE_UPDATE_INPUT(P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_UPDT_REC_TYPE)

Line 1489: FND_MSG_PUB.Add;

1485: END IF;
1486: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1487: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1488: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1489: FND_MSG_PUB.Add;
1490: RAISE FND_API.G_EXC_ERROR;
1491: end if;
1492:
1493: /* validate promise_amount */

Line 1506: FND_MSG_PUB.Add;

1502: END IF;
1503: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1504: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1505: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1506: FND_MSG_PUB.Add;
1507: RAISE FND_API.G_EXC_ERROR;
1508: end if;
1509:
1510: /* validate resource_id */

Line 1523: FND_MSG_PUB.Add;

1519: END IF;
1520: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1521: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1522: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1523: FND_MSG_PUB.Add;
1524: RAISE FND_API.G_EXC_ERROR;
1525: end if;
1526:
1527: /* pull data from db to do some validation */

Line 1563: FND_MSG_PUB.Add;

1559: END IF;
1560: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1561: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1562: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1563: FND_MSG_PUB.Add;
1564: RAISE FND_API.G_EXC_ERROR;
1565: end if;
1566:
1567: /* validate promise_state */

Line 1579: FND_MSG_PUB.Add;

1575: END IF;
1576: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1577: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1578: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1579: FND_MSG_PUB.Add;
1580: RAISE FND_API.G_EXC_ERROR;
1581: end if;
1582:
1583: /* validate remaining amount */

Line 1595: FND_MSG_PUB.Add;

1591: END IF;
1592: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1593: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1594: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1595: FND_MSG_PUB.Add;
1596: RAISE FND_API.G_EXC_ERROR;
1597: end if;
1598:
1599: /* validate promise_date */

Line 1612: FND_MSG_PUB.Add;

1608: END IF;
1609: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1610: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1611: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1612: FND_MSG_PUB.Add;
1613: RAISE FND_API.G_EXC_ERROR;
1614: end if;
1615:
1616: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1669: FND_MSG_PUB.Add;

1665: END IF;
1666: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1667: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1668: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1669: FND_MSG_PUB.Add;
1670: RAISE FND_API.G_EXC_ERROR;
1671: end if;
1672:
1673: /* validate payment_method */

Line 1697: FND_MSG_PUB.Add;

1693: END IF;
1694: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1695: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1696: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1697: FND_MSG_PUB.Add;
1698: RAISE FND_API.G_EXC_ERROR;
1699: end if;
1700: else
1701: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1753: FND_MSG_PUB.initialize;

1749: END IF;
1750:
1751: -- Initialize message list if p_init_msg_list is set to TRUE
1752: IF FND_API.To_Boolean(p_init_msg_list) THEN
1753: FND_MSG_PUB.initialize;
1754: END IF;
1755:
1756: -- Initialize API return status to success
1757: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1967: FND_MSG_PUB.Count_And_Get(

1963: -- END OF BODY OF API
1964:
1965: x_return_status := l_return_status;
1966: -- Standard call to get message count and if count is 1, get message info
1967: FND_MSG_PUB.Count_And_Get(
1968: p_encoded => FND_API.G_FALSE,
1969: p_count => x_msg_count,
1970: p_data => x_msg_data);
1971:

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

1976: EXCEPTION
1977: WHEN FND_API.G_EXC_ERROR THEN
1978: ROLLBACK TO UPDATE_PROMISE_PVT;
1979: x_return_status := FND_API.G_RET_STS_ERROR;
1980: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1982: ROLLBACK TO UPDATE_PROMISE_PVT;
1983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1984: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

1980: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1982: ROLLBACK TO UPDATE_PROMISE_PVT;
1983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1984: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1985: WHEN OTHERS THEN
1986: ROLLBACK TO UPDATE_PROMISE_PVT;
1987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1988: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

1984: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1985: WHEN OTHERS THEN
1986: ROLLBACK TO UPDATE_PROMISE_PVT;
1987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1988: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1989: THEN
1990: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1991: END IF;
1992: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

1986: ROLLBACK TO UPDATE_PROMISE_PVT;
1987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1988: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1989: THEN
1990: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1991: END IF;
1992: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1993:
1994: END;

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

1988: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1989: THEN
1990: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1991: END IF;
1992: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1993:
1994: END;
1995:
1996:

Line 2017: FND_MSG_PUB.Add;

2013: END IF;
2014: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2015: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2016: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2017: FND_MSG_PUB.Add;
2018: RAISE FND_API.G_EXC_ERROR;
2019: end if;
2020:
2021: /* validate resource_id */

Line 2034: FND_MSG_PUB.Add;

2030: END IF;
2031: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2032: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2033: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2034: FND_MSG_PUB.Add;
2035: RAISE FND_API.G_EXC_ERROR;
2036: end if;
2037:
2038: end;

Line 2086: FND_MSG_PUB.initialize;

2082: END IF;
2083:
2084: -- Initialize message list if p_init_msg_list is set to TRUE
2085: IF FND_API.To_Boolean(p_init_msg_list) THEN
2086: FND_MSG_PUB.initialize;
2087: END IF;
2088:
2089: -- Initialize API return status to success
2090: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2277: FND_MSG_PUB.Count_And_Get(

2273: -- END OF BODY OF API
2274:
2275: x_return_status := l_return_status;
2276: -- Standard call to get message count and if count is 1, get message info
2277: FND_MSG_PUB.Count_And_Get(
2278: p_encoded => FND_API.G_FALSE,
2279: p_count => x_msg_count,
2280: p_data => x_msg_data);
2281:

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

2286: EXCEPTION
2287: WHEN FND_API.G_EXC_ERROR THEN
2288: ROLLBACK TO CANCEL_PROMISE_PVT;
2289: x_return_status := FND_API.G_RET_STS_ERROR;
2290: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2292: ROLLBACK TO CANCEL_PROMISE_PVT;
2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

2290: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2292: ROLLBACK TO CANCEL_PROMISE_PVT;
2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2295: WHEN OTHERS THEN
2296: ROLLBACK TO CANCEL_PROMISE_PVT;
2297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2298: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

2294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2295: WHEN OTHERS THEN
2296: ROLLBACK TO CANCEL_PROMISE_PVT;
2297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2298: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2299: THEN
2300: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2301: END IF;
2302: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

2296: ROLLBACK TO CANCEL_PROMISE_PVT;
2297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2298: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2299: THEN
2300: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2301: END IF;
2302: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2303:
2304: END;

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

2298: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2299: THEN
2300: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2301: END IF;
2302: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2303:
2304: END;
2305:
2306:

Line 2336: FND_MSG_PUB.Add;

2332: END IF;
2333: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2334: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2335: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2336: FND_MSG_PUB.Add;
2337: RAISE FND_API.G_EXC_ERROR;
2338: end if;
2339:
2340: --commenting begin for bug 6717279 by gnramasa 25th Aug 08

Line 2373: FND_MSG_PUB.Add;

2369: END IF;
2370: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2371: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2372: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2373: FND_MSG_PUB.Add;
2374: RAISE FND_API.G_EXC_ERROR;
2375: end if;
2376: */
2377: --commenting end for bug 6717279 by gnramasa 25th Aug 08

Line 2391: FND_MSG_PUB.Add;

2387: END IF;
2388: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2389: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2390: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2391: FND_MSG_PUB.Add;
2392: RAISE FND_API.G_EXC_ERROR;
2393: end if;
2394:
2395: /* validate resource_id */

Line 2408: FND_MSG_PUB.Add;

2404: END IF;
2405: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2406: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2407: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2408: FND_MSG_PUB.Add;
2409: RAISE FND_API.G_EXC_ERROR;
2410: end if;
2411:
2412: /* validate payment_method */

Line 2436: FND_MSG_PUB.Add;

2432: END IF;
2433: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2434: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2435: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2436: FND_MSG_PUB.Add;
2437: RAISE FND_API.G_EXC_ERROR;
2438: end if;
2439: else
2440: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2518: FND_MSG_PUB.initialize;

2514: END IF;
2515:
2516: -- Initialize message list if p_init_msg_list is set to TRUE
2517: IF FND_API.To_Boolean(p_init_msg_list) THEN
2518: FND_MSG_PUB.initialize;
2519: END IF;
2520:
2521: -- Initialize API return status to success
2522: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2958: FND_MSG_PUB.Count_And_Get(

2954: -- END OF BODY OF API
2955:
2956: x_return_status := l_return_status;
2957: -- Standard call to get message count and if count is 1, get message info
2958: FND_MSG_PUB.Count_And_Get(
2959: p_encoded => FND_API.G_FALSE,
2960: p_count => x_msg_count,
2961: p_data => x_msg_data);
2962:

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

2967: EXCEPTION
2968: WHEN FND_API.G_EXC_ERROR THEN
2969: ROLLBACK TO MASS_PROMISE_PVT;
2970: x_return_status := FND_API.G_RET_STS_ERROR;
2971: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2973: ROLLBACK TO MASS_PROMISE_PVT;
2974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2975: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

2971: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2973: ROLLBACK TO MASS_PROMISE_PVT;
2974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2975: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2976: WHEN OTHERS THEN
2977: ROLLBACK TO MASS_PROMISE_PVT;
2978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2979: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

2975: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2976: WHEN OTHERS THEN
2977: ROLLBACK TO MASS_PROMISE_PVT;
2978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2979: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2980: THEN
2981: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2982: END IF;
2983: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

2977: ROLLBACK TO MASS_PROMISE_PVT;
2978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2979: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2980: THEN
2981: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2982: END IF;
2983: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2984:
2985: END;

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

2979: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2980: THEN
2981: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2982: END IF;
2983: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2984:
2985: END;
2986:
2987: Procedure update_del_stage_level (

Line 3064: FND_MSG_PUB.Count_And_Get(

3060: --end
3061:
3062: x_return_status := l_return_status;
3063: -- Standard call to get message count and if count is 1, get message info
3064: FND_MSG_PUB.Count_And_Get(
3065: p_encoded => FND_API.G_FALSE,
3066: p_count => x_msg_count,
3067: p_data => x_msg_data);
3068:

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

3069: EXCEPTION
3070: WHEN FND_API.G_EXC_ERROR THEN
3071: ROLLBACK TO UPDATE_DEL_STAGE_PVT;
3072: x_return_status := FND_API.G_RET_STS_ERROR;
3073: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3075: ROLLBACK TO UPDATE_DEL_STAGE_PVT;
3076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3077: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

3073: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3075: ROLLBACK TO UPDATE_DEL_STAGE_PVT;
3076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3077: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3078: WHEN OTHERS THEN
3079: ROLLBACK TO UPDATE_DEL_STAGE_PVT;
3080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3081: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

3077: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3078: WHEN OTHERS THEN
3079: ROLLBACK TO UPDATE_DEL_STAGE_PVT;
3080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3081: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3082: THEN
3083: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3084: END IF;
3085: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

3079: ROLLBACK TO UPDATE_DEL_STAGE_PVT;
3080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3081: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3082: THEN
3083: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3084: END IF;
3085: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3086: end update_del_stage_level;
3087:

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

3081: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3082: THEN
3083: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3084: END IF;
3085: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3086: end update_del_stage_level;
3087:
3088: begin
3089: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;