DBA Data[Home] [Help]

APPS.FTE_TENDER_PVT dependencies on FND_MSG_PUB

Line 45: FND_MSG_PUB.initialize;

41: END IF;
42:
43: IF FND_API.to_Boolean( p_init_msg_list )
44: THEN
45: FND_MSG_PUB.initialize;
46: END IF;
47:
48: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
49: x_msg_count := 0;

Line 118: FND_MSG_PUB.Count_And_Get

114: --
115: IF l_debug_on THEN
116: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:24 ',WSH_DEBUG_SV.C_PROC_LEVEL);
117: END IF;
118: FND_MSG_PUB.Count_And_Get
119: (
120: p_count => x_msg_count,
121: p_data => x_msg_data,
122: p_encoded => FND_API.G_FALSE

Line 139: FND_MSG_PUB.Count_And_Get

135: --{
136: WHEN FND_API.G_EXC_ERROR THEN
137: ROLLBACK TO RAISE_TENDER_REQUEST_PUB;
138: x_return_status := FND_API.G_RET_STS_ERROR ;
139: FND_MSG_PUB.Count_And_Get
140: (
141: p_count => x_msg_count,
142: p_data => x_msg_data,
143: p_encoded => FND_API.G_FALSE

Line 148: FND_MSG_PUB.Count_And_Get

144: );
145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
146: ROLLBACK TO RAISE_TENDER_REQUEST_PUB;
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
148: FND_MSG_PUB.Count_And_Get
149: (
150: p_count => x_msg_count,
151: p_data => x_msg_data,
152: p_encoded => FND_API.G_FALSE

Line 158: FND_MSG_PUB.Count_And_Get

154: WHEN OTHERS THEN
155: ROLLBACK TO RAISE_TENDER_REQUEST_PUB;
156: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_REQUEST');
157: x_return_status := FND_API.G_RET_STS_ERROR;
158: FND_MSG_PUB.Count_And_Get
159: (
160: p_count => x_msg_count,
161: p_data => x_msg_data,
162: p_encoded => FND_API.G_FALSE

Line 252: FND_MSG_PUB.initialize;

248: SAVEPOINT RAISE_TENDER_CANCEL_PUB;
249:
250: IF FND_API.to_Boolean( p_init_msg_list )
251: THEN
252: FND_MSG_PUB.initialize;
253: END IF;
254:
255: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
256: x_msg_count := 0;

Line 312: FND_MSG_PUB.Count_And_Get

308: -- should delete tender snap shot
309:
310: -- Standard call to get message count and if count is 1,get message info.
311: --
312: FND_MSG_PUB.Count_And_Get
313: (
314: p_count => x_msg_count,
315: p_data => x_msg_data,
316: p_encoded => FND_API.G_FALSE

Line 328: FND_MSG_PUB.Count_And_Get

324: --{
325: WHEN FND_API.G_EXC_ERROR THEN
326: ROLLBACK TO RAISE_TENDER_CANCEL_PUB;
327: x_return_status := FND_API.G_RET_STS_ERROR ;
328: FND_MSG_PUB.Count_And_Get
329: (
330: p_count => x_msg_count,
331: p_data => x_msg_data,
332: p_encoded => FND_API.G_FALSE

Line 337: FND_MSG_PUB.Count_And_Get

333: );
334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
335: ROLLBACK TO RAISE_TENDER_CANCEL_PUB;
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
337: FND_MSG_PUB.Count_And_Get
338: (
339: p_count => x_msg_count,
340: p_data => x_msg_data,
341: p_encoded => FND_API.G_FALSE

Line 347: FND_MSG_PUB.Count_And_Get

343: WHEN OTHERS THEN
344: ROLLBACK TO RAISE_TENDER_CANCEL_PUB;
345: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_CANCEL');
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: FND_MSG_PUB.Count_And_Get
348: (
349: p_count => x_msg_count,
350: p_data => x_msg_data,
351: p_encoded => FND_API.G_FALSE

Line 390: FND_MSG_PUB.initialize;

386: SAVEPOINT RAISE_TENDER_ACCEPT_PUB;
387:
388: IF FND_API.to_Boolean( p_init_msg_list )
389: THEN
390: FND_MSG_PUB.initialize;
391: END IF;
392:
393: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
394: x_msg_count := 0;

Line 462: FND_MSG_PUB.Count_And_Get

458: l_parameter_list.DELETE;
459:
460: -- Standard call to get message count and if count is 1,get message info.
461: --
462: FND_MSG_PUB.Count_And_Get
463: (
464: p_count => x_msg_count,
465: p_data => x_msg_data,
466: p_encoded => FND_API.G_FALSE

Line 478: FND_MSG_PUB.Count_And_Get

474: --{
475: WHEN FND_API.G_EXC_ERROR THEN
476: ROLLBACK TO RAISE_TENDER_ACCEPT_PUB;
477: x_return_status := FND_API.G_RET_STS_ERROR ;
478: FND_MSG_PUB.Count_And_Get
479: (
480: p_count => x_msg_count,
481: p_data => x_msg_data,
482: p_encoded => FND_API.G_FALSE

Line 487: FND_MSG_PUB.Count_And_Get

483: );
484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
485: ROLLBACK TO RAISE_TENDER_ACCEPT_PUB;
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
487: FND_MSG_PUB.Count_And_Get
488: (
489: p_count => x_msg_count,
490: p_data => x_msg_data,
491: p_encoded => FND_API.G_FALSE

Line 497: FND_MSG_PUB.Count_And_Get

493: WHEN OTHERS THEN
494: ROLLBACK TO RAISE_TENDER_ACCEPT_PUB;
495: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_ACCEPT');
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: FND_MSG_PUB.Count_And_Get
498: (
499: p_count => x_msg_count,
500: p_data => x_msg_data,
501: p_encoded => FND_API.G_FALSE

Line 546: FND_MSG_PUB.initialize;

542: SAVEPOINT RAISE_TENDER_UPDATE_PUB;
543:
544: IF FND_API.to_Boolean( p_init_msg_list )
545: THEN
546: FND_MSG_PUB.initialize;
547: END IF;
548:
549:
550: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 643: FND_MSG_PUB.Count_And_Get

639: l_parameter_list.DELETE;
640:
641: -- Standard call to get message count and if count is 1,get message info.
642: --
643: FND_MSG_PUB.Count_And_Get
644: (
645: p_count => x_msg_count,
646: p_data => x_msg_data,
647: p_encoded => FND_API.G_FALSE

Line 659: FND_MSG_PUB.Count_And_Get

655: --{
656: WHEN FND_API.G_EXC_ERROR THEN
657: ROLLBACK TO RAISE_TENDER_UPDATE_PUB;
658: x_return_status := FND_API.G_RET_STS_ERROR ;
659: FND_MSG_PUB.Count_And_Get
660: (
661: p_count => x_msg_count,
662: p_data => x_msg_data,
663: p_encoded => FND_API.G_FALSE

Line 668: FND_MSG_PUB.Count_And_Get

664: );
665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
666: ROLLBACK TO RAISE_TENDER_UPDATE_PUB;
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
668: FND_MSG_PUB.Count_And_Get
669: (
670: p_count => x_msg_count,
671: p_data => x_msg_data,
672: p_encoded => FND_API.G_FALSE

Line 678: FND_MSG_PUB.Count_And_Get

674: WHEN OTHERS THEN
675: ROLLBACK TO RAISE_TENDER_UPDATE_PUB;
676: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_UPDATE');
677: x_return_status := FND_API.G_RET_STS_ERROR;
678: FND_MSG_PUB.Count_And_Get
679: (
680: p_count => x_msg_count,
681: p_data => x_msg_data,
682: p_encoded => FND_API.G_FALSE

Line 720: FND_MSG_PUB.initialize;

716: SAVEPOINT RAISE_TENDER_REJECT_PUB;
717:
718: IF FND_API.to_Boolean( p_init_msg_list )
719: THEN
720: FND_MSG_PUB.initialize;
721: END IF;
722:
723:
724: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 786: FND_MSG_PUB.Count_And_Get

782: l_parameter_list.DELETE;
783:
784: -- Standard call to get message count and if count is 1,get message info.
785: --
786: FND_MSG_PUB.Count_And_Get
787: (
788: p_count => x_msg_count,
789: p_data => x_msg_data,
790: p_encoded => FND_API.G_FALSE

Line 801: FND_MSG_PUB.Count_And_Get

797: --{
798: WHEN FND_API.G_EXC_ERROR THEN
799: ROLLBACK TO RAISE_TENDER_REJECT_PUB;
800: x_return_status := FND_API.G_RET_STS_ERROR ;
801: FND_MSG_PUB.Count_And_Get
802: (
803: p_count => x_msg_count,
804: p_data => x_msg_data,
805: p_encoded => FND_API.G_FALSE

Line 810: FND_MSG_PUB.Count_And_Get

806: );
807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
808: ROLLBACK TO RAISE_TENDER_REJECT_PUB;
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
810: FND_MSG_PUB.Count_And_Get
811: (
812: p_count => x_msg_count,
813: p_data => x_msg_data,
814: p_encoded => FND_API.G_FALSE

Line 820: FND_MSG_PUB.Count_And_Get

816: WHEN OTHERS THEN
817: ROLLBACK TO RAISE_TENDER_REJECT_PUB;
818: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_REJECT');
819: x_return_status := FND_API.G_RET_STS_ERROR;
820: FND_MSG_PUB.Count_And_Get
821: (
822: p_count => x_msg_count,
823: p_data => x_msg_data,
824: p_encoded => FND_API.G_FALSE

Line 1118: FND_MSG_PUB.initialize;

1114:
1115:
1116: IF FND_API.to_Boolean( p_init_msg_list )
1117: THEN
1118: FND_MSG_PUB.initialize;
1119: END IF;
1120: --
1121: IF l_debug_on THEN
1122: wsh_debug_sv.push(l_module_name);

Line 1132: FND_MSG_PUB.Count_And_Get

1128: x_msg_data := 0;
1129:
1130: IF (p_action_code = 'CREATE') THEN
1131: return;
1132: FND_MSG_PUB.Count_And_Get
1133: (
1134: p_count => x_msg_count,
1135: p_data => x_msg_data,
1136: p_encoded => FND_API.G_FALSE

Line 1224: FND_MSG_PUB.Count_And_Get

1220:
1221: -- Standard call to get message count and if count is 1,get message info.
1222: --
1223:
1224: FND_MSG_PUB.Count_And_Get
1225: (
1226: p_count => x_msg_count,
1227: p_data => x_msg_data,
1228: p_encoded => FND_API.G_FALSE

Line 1246: FND_MSG_PUB.Count_And_Get

1242: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:29 ',WSH_DEBUG_SV.C_PROC_LEVEL);
1243: END IF;
1244: ROLLBACK TO VALIDATE_TENDER_REQUEST_PUB;
1245: x_return_status := FND_API.G_RET_STS_ERROR ;
1246: FND_MSG_PUB.Count_And_Get
1247: (
1248: p_count => x_msg_count,
1249: p_data => x_msg_data,
1250: p_encoded => FND_API.G_FALSE

Line 1261: FND_MSG_PUB.Count_And_Get

1257: IF l_debug_on THEN
1258: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:30 ',WSH_DEBUG_SV.C_PROC_LEVEL);
1259: END IF;
1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1261: FND_MSG_PUB.Count_And_Get
1262: (
1263: p_count => x_msg_count,
1264: p_data => x_msg_data,
1265: p_encoded => FND_API.G_FALSE

Line 1277: FND_MSG_PUB.Count_And_Get

1273: END IF;
1274: ROLLBACK TO VALIDATE_TENDER_REQUEST_PUB;
1275: wsh_util_core.default_handler('FTE_TENDER_PVT.VALIDATE_TENDER_REQUEST');
1276: x_return_status := FND_API.G_RET_STS_ERROR;
1277: FND_MSG_PUB.Count_And_Get
1278: (
1279: p_count => x_msg_count,
1280: p_data => x_msg_data,
1281: p_encoded => FND_API.G_FALSE

Line 1343: FND_MSG_PUB.initialize;

1339: --
1340: --
1341: IF FND_API.to_Boolean( p_init_msg_list )
1342: THEN
1343: FND_MSG_PUB.initialize;
1344: END IF;
1345: --
1346: --
1347: -- Initialize API return status to success

Line 1364: FND_MSG_PUB.Count_And_Get

1360: END IF;
1361:
1362: -- Standard call to get message count and if count is 1,get message info.
1363: --
1364: FND_MSG_PUB.Count_And_Get
1365: (
1366: p_count => x_msg_count,
1367: p_data => x_msg_data,
1368: p_encoded => FND_API.G_FALSE

Line 1380: FND_MSG_PUB.Count_And_Get

1376: --{
1377: WHEN FND_API.G_EXC_ERROR THEN
1378: ROLLBACK TO DELETE_TENDER_SNAPSHOT_PUB;
1379: x_return_status := FND_API.G_RET_STS_ERROR ;
1380: FND_MSG_PUB.Count_And_Get
1381: (
1382: p_count => x_msg_count,
1383: p_data => x_msg_data,
1384: p_encoded => FND_API.G_FALSE

Line 1389: FND_MSG_PUB.Count_And_Get

1385: );
1386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1387: ROLLBACK TO DELETE_TENDER_SNAPSHOT_PUB;
1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1389: FND_MSG_PUB.Count_And_Get
1390: (
1391: p_count => x_msg_count,
1392: p_data => x_msg_data,
1393: p_encoded => FND_API.G_FALSE

Line 1399: FND_MSG_PUB.Count_And_Get

1395: WHEN OTHERS THEN
1396: ROLLBACK TO DELETE_TENDER_SNAPSHOT_PUB;
1397: wsh_util_core.default_handler('FTE_TENDER_PVT.DELETE_TENDER_SNAPSHOT');
1398: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1399: FND_MSG_PUB.Count_And_Get
1400: (
1401: p_count => x_msg_count,
1402: p_data => x_msg_data,
1403: p_encoded => FND_API.G_FALSE

Line 1470: FND_MSG_PUB.initialize;

1466: --
1467: --
1468: IF FND_API.to_Boolean( p_init_msg_list )
1469: THEN
1470: FND_MSG_PUB.initialize;
1471: END IF;
1472: --
1473: --
1474: -- Initialize API return status to success

Line 1546: FND_MSG_PUB.Count_And_Get

1542:
1543:
1544: -- Standard call to get message count and if count is 1,get message info.
1545: --
1546: FND_MSG_PUB.Count_And_Get
1547: (
1548: p_count => x_msg_count,
1549: p_data => x_msg_data,
1550: p_encoded => FND_API.G_FALSE

Line 1562: FND_MSG_PUB.Count_And_Get

1558: --{
1559: WHEN FND_API.G_EXC_ERROR THEN
1560: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: FND_MSG_PUB.Count_And_Get
1563: (
1564: p_count => x_msg_count,
1565: p_data => x_msg_data,
1566: p_encoded => FND_API.G_FALSE

Line 1571: FND_MSG_PUB.Count_And_Get

1567: );
1568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1569: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1571: FND_MSG_PUB.Count_And_Get
1572: (
1573: p_count => x_msg_count,
1574: p_data => x_msg_data,
1575: p_encoded => FND_API.G_FALSE

Line 1581: FND_MSG_PUB.Count_And_Get

1577: WHEN OTHERS THEN
1578: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1579: wsh_util_core.default_handler('FTE_TENDER_PVT.TAKE_TENDER_SNAPSHOT_PUB');
1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1581: FND_MSG_PUB.Count_And_Get
1582: (
1583: p_count => x_msg_count,
1584: p_data => x_msg_data,
1585: p_encoded => FND_API.G_FALSE

Line 1638: FND_MSG_PUB.initialize;

1634: --
1635: --
1636: IF FND_API.to_Boolean( p_init_msg_list )
1637: THEN
1638: FND_MSG_PUB.initialize;
1639: END IF;
1640: --
1641: --
1642: -- Initialize API return status to success

Line 1723: FND_MSG_PUB.Count_And_Get

1719:
1720:
1721: -- Standard call to get message count and if count is 1,get message info.
1722: --
1723: FND_MSG_PUB.Count_And_Get
1724: (
1725: p_count => x_msg_count,
1726: p_data => x_msg_data,
1727: p_encoded => FND_API.G_FALSE

Line 1739: FND_MSG_PUB.Count_And_Get

1735: --{
1736: WHEN FND_API.G_EXC_ERROR THEN
1737: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1738: x_return_status := FND_API.G_RET_STS_ERROR;
1739: FND_MSG_PUB.Count_And_Get
1740: (
1741: p_count => x_msg_count,
1742: p_data => x_msg_data,
1743: p_encoded => FND_API.G_FALSE

Line 1748: FND_MSG_PUB.Count_And_Get

1744: );
1745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1746: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1748: FND_MSG_PUB.Count_And_Get
1749: (
1750: p_count => x_msg_count,
1751: p_data => x_msg_data,
1752: p_encoded => FND_API.G_FALSE

Line 1758: FND_MSG_PUB.Count_And_Get

1754: WHEN OTHERS THEN
1755: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1756: wsh_util_core.default_handler('FTE_TENDER_PVT.TAKE_TENDER_SNAPSHOT_PUB');
1757: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1758: FND_MSG_PUB.Count_And_Get
1759: (
1760: p_count => x_msg_count,
1761: p_data => x_msg_data,
1762: p_encoded => FND_API.G_FALSE

Line 1904: FND_MSG_PUB.initialize;

1900: --
1901: --
1902: IF FND_API.to_Boolean( p_init_msg_list )
1903: THEN
1904: FND_MSG_PUB.initialize;
1905: END IF;
1906: --
1907: --
1908: -- Initialize API return status to success

Line 2142: FND_MSG_PUB.Count_And_Get

2138: FND_MESSAGE.SET_TOKEN('STOP_LOC',l_stop_location);
2139: FND_MESSAGE.SET_TOKEN('TENDER_ID',l_tender_number);
2140: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
2141: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2142: FND_MSG_PUB.Count_And_Get
2143: (
2144: p_count => x_msg_count,
2145: p_data => x_msg_data,
2146: p_encoded => FND_API.G_FALSE

Line 2189: FND_MSG_PUB.Count_And_Get

2185: IF (x_return_status = 'E') THEN
2186: FND_MESSAGE.SET_NAME('FTE','FTE_NO_THRESHOLD_INFO');
2187: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
2188: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2189: FND_MSG_PUB.Count_And_Get
2190: (
2191: p_count => x_msg_count,
2192: p_data => x_msg_data,
2193: p_encoded => FND_API.G_FALSE

Line 2601: FND_MSG_PUB.Count_And_Get

2597: END IF;
2598:
2599: -- Standard call to get message count and if count is 1,get message info.
2600: --
2601: FND_MSG_PUB.Count_And_Get
2602: (
2603: p_count => x_msg_count,
2604: p_data => x_msg_data,
2605: p_encoded => FND_API.G_FALSE

Line 2616: FND_MSG_PUB.Count_And_Get

2612: --{
2613: WHEN FND_API.G_EXC_ERROR THEN
2614: ROLLBACK TO CHECK_THRESHOLD_FOR_STOP_PUB;
2615: x_return_status := FND_API.G_RET_STS_ERROR ;
2616: FND_MSG_PUB.Count_And_Get
2617: (
2618: p_count => x_msg_count,
2619: p_data => x_msg_data,
2620: p_encoded => FND_API.G_FALSE

Line 2629: FND_MSG_PUB.Count_And_Get

2625:
2626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2627: ROLLBACK TO CHECK_THRESHOLD_FOR_STOP_PUB;
2628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2629: FND_MSG_PUB.Count_And_Get
2630: (
2631: p_count => x_msg_count,
2632: p_data => x_msg_data,
2633: p_encoded => FND_API.G_FALSE

Line 2642: FND_MSG_PUB.Count_And_Get

2638: WHEN OTHERS THEN
2639: ROLLBACK TO CHECK_THRESHOLD_FOR_STOP_PUB;
2640: wsh_util_core.default_handler('FTE_TENDER_PVT.CHECK_THRESHOLD_FOR_STOP');
2641: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2642: FND_MSG_PUB.Count_And_Get
2643: (
2644: p_count => x_msg_count,
2645: p_data => x_msg_data,
2646: p_encoded => FND_API.G_FALSE

Line 2919: FND_MSG_PUB.Count_And_Get

2915: */
2916:
2917: -- Standard call to get message count and if count is 1,get message info.
2918: --
2919: FND_MSG_PUB.Count_And_Get
2920: (
2921: p_count => x_msg_count,
2922: p_data => x_msg_data,
2923: p_encoded => FND_API.G_FALSE

Line 2934: FND_MSG_PUB.Count_And_Get

2930: --{
2931: WHEN FND_API.G_EXC_ERROR THEN
2932: ROLLBACK TO HANDLE_WF_ROLES_PUB;
2933: x_return_status := FND_API.G_RET_STS_ERROR ;
2934: FND_MSG_PUB.Count_And_Get
2935: (
2936: p_count => x_msg_count,
2937: p_data => x_msg_data,
2938: p_encoded => FND_API.G_FALSE

Line 2947: FND_MSG_PUB.Count_And_Get

2943:
2944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2945: ROLLBACK TO HANDLE_WF_ROLES_PUB;
2946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2947: FND_MSG_PUB.Count_And_Get
2948: (
2949: p_count => x_msg_count,
2950: p_data => x_msg_data,
2951: p_encoded => FND_API.G_FALSE

Line 2960: FND_MSG_PUB.Count_And_Get

2956: WHEN OTHERS THEN
2957: ROLLBACK TO HANDLE_WF_ROLES_PUB;
2958: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_WF_ROLES');
2959: x_return_status := FND_API.G_RET_STS_ERROR;
2960: FND_MSG_PUB.Count_And_Get
2961: (
2962: p_count => x_msg_count,
2963: p_data => x_msg_data,
2964: p_encoded => FND_API.G_FALSE

Line 3050: FND_MSG_PUB.initialize;

3046: x_msg_data := 0;
3047:
3048: IF FND_API.to_Boolean( p_init_msg_list )
3049: THEN
3050: FND_MSG_PUB.initialize;
3051: END IF;
3052:
3053: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3054: x_msg_count := 0;

Line 3168: FND_MSG_PUB.Count_And_Get

3164:
3165:
3166: -- Standard call to get message count and if count is 1,get message info.
3167: --
3168: FND_MSG_PUB.Count_And_Get
3169: (
3170: p_count => x_msg_count,
3171: p_data => x_msg_data,
3172: p_encoded => FND_API.G_FALSE

Line 3183: FND_MSG_PUB.Count_And_Get

3179: --{
3180: WHEN FND_API.G_EXC_ERROR THEN
3181: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3182: x_return_status := FND_API.G_RET_STS_ERROR ;
3183: FND_MSG_PUB.Count_And_Get
3184: (
3185: p_count => x_msg_count,
3186: p_data => x_msg_data,
3187: p_encoded => FND_API.G_FALSE

Line 3192: FND_MSG_PUB.Count_And_Get

3188: );
3189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3190: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3192: FND_MSG_PUB.Count_And_Get
3193: (
3194: p_count => x_msg_count,
3195: p_data => x_msg_data,
3196: p_encoded => FND_API.G_FALSE

Line 3202: FND_MSG_PUB.Count_And_Get

3198: WHEN OTHERS THEN
3199: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3200: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_EVENT');
3201: x_return_status := FND_API.G_RET_STS_ERROR;
3202: FND_MSG_PUB.Count_And_Get
3203: (
3204: p_count => x_msg_count,
3205: p_data => x_msg_data,
3206: p_encoded => FND_API.G_FALSE

Line 3288: FND_MSG_PUB.Count_And_Get

3284:
3285:
3286:
3287: --handling Errors
3288: FND_MSG_PUB.Count_And_Get
3289: (
3290: p_count => x_msg_count,
3291: p_data => x_msg_data,
3292: p_encoded => FND_API.G_FALSE

Line 3337: FND_MSG_PUB.Count_And_Get

3333: WSH_DEBUG_SV.logmsg(l_module_name,' Inside 4 '||l_dreturn_status,
3334: WSH_DEBUG_SV.C_PROC_LEVEL);
3335: END IF ;
3336: --handling Errors
3337: FND_MSG_PUB.Count_And_Get
3338: (
3339: p_count => x_msg_count,
3340: p_data => x_msg_data,
3341: p_encoded => FND_API.G_FALSE

Line 3372: FND_MSG_PUB.Count_And_Get

3368:
3369: WHEN FND_API.G_EXC_ERROR THEN
3370: ROLLBACK TO LOG_CARRIER_ARR_EXC_pub;
3371: x_return_status := FND_API.G_RET_STS_ERROR ;
3372: FND_MSG_PUB.Count_And_Get
3373: (
3374: p_count => x_msg_count,
3375: p_data => x_msg_data,
3376: p_encoded => FND_API.G_FALSE

Line 3381: FND_MSG_PUB.Count_And_Get

3377: );
3378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3379: ROLLBACK TO LOG_CARRIER_ARR_EXC_pub;
3380: x_return_status := FND_API.G_RET_STS_ERROR ;
3381: FND_MSG_PUB.Count_And_Get
3382: (
3383: p_count => x_msg_count,
3384: p_data => x_msg_data,
3385: p_encoded => FND_API.G_FALSE

Line 3391: FND_MSG_PUB.Count_And_Get

3387: WHEN OTHERS THEN
3388: ROLLBACK TO LOG_CARRIER_ARR_EXC_pub;
3389: wsh_util_core.default_handler('FTE_TENDER_PVT.LOG_CARRIER_ARR_EXC');
3390: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3391: FND_MSG_PUB.Count_And_Get
3392: (
3393: p_count => x_msg_count,
3394: p_data => x_msg_data,
3395: p_encoded => FND_API.G_FALSE

Line 3488: FND_MSG_PUB.Count_And_Get

3484:
3485: WHEN FND_API.G_EXC_ERROR THEN
3486: ROLLBACK TO CHECK_CARRIER_ARRIVAL_TIME_PUB;
3487: x_return_status := FND_API.G_RET_STS_ERROR ;
3488: FND_MSG_PUB.Count_And_Get
3489: (
3490: p_count => x_msg_count,
3491: p_data => x_msg_data,
3492: p_encoded => FND_API.G_FALSE

Line 3497: FND_MSG_PUB.Count_And_Get

3493: );
3494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3495: ROLLBACK TO CHECK_CARRIER_ARRIVAL_TIME_PUB;
3496: x_return_status := FND_API.G_RET_STS_ERROR ;
3497: FND_MSG_PUB.Count_And_Get
3498: (
3499: p_count => x_msg_count,
3500: p_data => x_msg_data,
3501: p_encoded => FND_API.G_FALSE

Line 3507: FND_MSG_PUB.Count_And_Get

3503: WHEN OTHERS THEN
3504: ROLLBACK TO CHECK_CARRIER_ARRIVAL_TIME_PUB;
3505: wsh_util_core.default_handler('FTE_TENDER_PVT.CHECK_CARRIER_ARRIVAL_TIME');
3506: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3507: FND_MSG_PUB.Count_And_Get
3508: (
3509: p_count => x_msg_count,
3510: p_data => x_msg_data,
3511: p_encoded => FND_API.G_FALSE

Line 3615: FND_MSG_PUB.Count_And_Get

3611: END LOOP;
3612: CLOSE check_exception_on_trip;
3613:
3614: --
3615: FND_MSG_PUB.Count_And_Get
3616: (
3617: p_count => x_msg_count,
3618: p_data => x_msg_data,
3619: p_encoded => FND_API.G_FALSE

Line 3649: FND_MSG_PUB.Count_And_Get

3645:
3646: WHEN FND_API.G_EXC_ERROR THEN
3647: ROLLBACK TO COMPLETE_CANCEL_TENDER_PUB;
3648: x_return_status := FND_API.G_RET_STS_ERROR ;
3649: FND_MSG_PUB.Count_And_Get
3650: (
3651: p_count => x_msg_count,
3652: p_data => x_msg_data,
3653: p_encoded => FND_API.G_FALSE

Line 3659: FND_MSG_PUB.Count_And_Get

3655:
3656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3657: ROLLBACK TO COMPLETE_CANCEL_TENDER_PUB;
3658: x_return_status := FND_API.G_RET_STS_ERROR ;
3659: FND_MSG_PUB.Count_And_Get
3660: (
3661: p_count => x_msg_count,
3662: p_data => x_msg_data,
3663: p_encoded => FND_API.G_FALSE

Line 3670: FND_MSG_PUB.Count_And_Get

3666: WHEN OTHERS THEN
3667: ROLLBACK TO COMPLETE_CANCEL_TENDER_PUB;
3668: wsh_util_core.default_handler('FTE_TENDER_PVT.COMPLETE_CANCEL_TENDER');
3669: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3670: FND_MSG_PUB.Count_And_Get
3671: (
3672: p_count => x_msg_count,
3673: p_data => x_msg_data,
3674: p_encoded => FND_API.G_FALSE

Line 3726: FND_MSG_PUB.initialize;

3722: END IF;
3723:
3724: IF FND_API.to_Boolean( p_init_msg_list )
3725: THEN
3726: FND_MSG_PUB.initialize;
3727: END IF;
3728:
3729: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3730: x_msg_count := 0;

Line 3851: FND_MSG_PUB.Count_And_Get

3847: l_parameter_list.DELETE;
3848:
3849: -- Standard call to get message count and if count is 1,get message info.
3850: --
3851: FND_MSG_PUB.Count_And_Get
3852: (
3853: p_count => x_msg_count,
3854: p_data => x_msg_data,
3855: p_encoded => FND_API.G_FALSE

Line 3872: FND_MSG_PUB.Count_And_Get

3868: --{
3869: WHEN FND_API.G_EXC_ERROR THEN
3870: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3871: x_return_status := FND_API.G_RET_STS_ERROR ;
3872: FND_MSG_PUB.Count_And_Get
3873: (
3874: p_count => x_msg_count,
3875: p_data => x_msg_data,
3876: p_encoded => FND_API.G_FALSE

Line 3886: FND_MSG_PUB.Count_And_Get

3882:
3883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3884: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3886: FND_MSG_PUB.Count_And_Get
3887: (
3888: p_count => x_msg_count,
3889: p_data => x_msg_data,
3890: p_encoded => FND_API.G_FALSE

Line 3901: FND_MSG_PUB.Count_And_Get

3897: WHEN OTHERS THEN
3898: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3899: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_EVENT');
3900: x_return_status := FND_API.G_RET_STS_ERROR;
3901: FND_MSG_PUB.Count_And_Get
3902: (
3903: p_count => x_msg_count,
3904: p_data => x_msg_data,
3905: p_encoded => FND_API.G_FALSE

Line 3988: FND_MSG_PUB.initialize;

3984: SAVEPOINT UPDATE_CARRIER_RESPONSE_PUB;
3985:
3986: IF FND_API.to_Boolean( p_init_msg_list )
3987: THEN
3988: FND_MSG_PUB.initialize;
3989: END IF;
3990: --
3991: IF l_debug_on THEN
3992: wsh_debug_sv.push(l_module_name);

Line 4163: FND_MSG_PUB.Count_And_Get

4159:
4160:
4161: -- Standard call to get message count and if count is 1,get message info.
4162: --
4163: FND_MSG_PUB.Count_And_Get
4164: (
4165: p_count => x_msg_count,
4166: p_data => x_msg_data,
4167: p_encoded => FND_API.G_FALSE

Line 4200: FND_MSG_PUB.Count_And_Get

4196:
4197: WHEN FND_API.G_EXC_ERROR THEN
4198: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
4199: x_return_status := FND_API.G_RET_STS_ERROR ;
4200: FND_MSG_PUB.Count_And_Get
4201: (
4202: p_count => x_msg_count,
4203: p_data => x_msg_data,
4204: p_encoded => FND_API.G_FALSE

Line 4209: FND_MSG_PUB.Count_And_Get

4205: );
4206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4207: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
4208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4209: FND_MSG_PUB.Count_And_Get
4210: (
4211: p_count => x_msg_count,
4212: p_data => x_msg_data,
4213: p_encoded => FND_API.G_FALSE

Line 4220: FND_MSG_PUB.Count_And_Get

4216: WHEN OTHERS THEN
4217: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
4218: wsh_util_core.default_handler('FTE_TENDER_PVT.UPDATE_CARRIER_RESPONSE');
4219: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4220: FND_MSG_PUB.Count_And_Get
4221: (
4222: p_count => x_msg_count,
4223: p_data => x_msg_data,
4224: p_encoded => FND_API.G_FALSE

Line 4276: FND_MSG_PUB.initialize;

4272: END IF;
4273:
4274: IF FND_API.to_Boolean( p_init_msg_list )
4275: THEN
4276: FND_MSG_PUB.initialize;
4277: END IF;
4278:
4279: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4280: x_msg_count := 0;

Line 4356: FND_MSG_PUB.Count_And_Get

4352:
4353:
4354: -- Standard call to get message count and if count is 1,get message info.
4355: --
4356: FND_MSG_PUB.Count_And_Get
4357: (
4358: p_count => x_msg_count,
4359: p_data => x_msg_data,
4360: p_encoded => FND_API.G_FALSE

Line 4377: FND_MSG_PUB.Count_And_Get

4373: --{
4374: WHEN FND_API.G_EXC_ERROR THEN
4375: ROLLBACK TO RELEASE_TENDER_BLOCK_PUB;
4376: x_return_status := FND_API.G_RET_STS_ERROR ;
4377: FND_MSG_PUB.Count_And_Get
4378: (
4379: p_count => x_msg_count,
4380: p_data => x_msg_data,
4381: p_encoded => FND_API.G_FALSE

Line 4391: FND_MSG_PUB.Count_And_Get

4387:
4388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4389: ROLLBACK TO RELEASE_TENDER_BLOCK_PUB;
4390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4391: FND_MSG_PUB.Count_And_Get
4392: (
4393: p_count => x_msg_count,
4394: p_data => x_msg_data,
4395: p_encoded => FND_API.G_FALSE

Line 4406: FND_MSG_PUB.Count_And_Get

4402: WHEN OTHERS THEN
4403: ROLLBACK TO RELEASE_TENDER_BLOCK_PUB;
4404: wsh_util_core.default_handler('FTE_TENDER_PVT.RELEASE_TENDER_BLOCK');
4405: x_return_status := FND_API.G_RET_STS_ERROR;
4406: FND_MSG_PUB.Count_And_Get
4407: (
4408: p_count => x_msg_count,
4409: p_data => x_msg_data,
4410: p_encoded => FND_API.G_FALSE

Line 4466: FND_MSG_PUB.initialize;

4462: END IF;
4463:
4464: IF FND_API.to_Boolean( p_init_msg_list )
4465: THEN
4466: FND_MSG_PUB.initialize;
4467: END IF;
4468:
4469: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4470: x_msg_count := 0;

Line 4616: FND_MSG_PUB.Count_And_Get

4612:
4613:
4614: -- Standard call to get message count and if count is 1,get message info.
4615: --
4616: FND_MSG_PUB.Count_And_Get
4617: (
4618: p_count => x_msg_count,
4619: p_data => x_msg_data,
4620: p_encoded => FND_API.G_FALSE

Line 4637: FND_MSG_PUB.Count_And_Get

4633: --{
4634: WHEN FND_API.G_EXC_ERROR THEN
4635: ROLLBACK TO HANDLE_TENDER_RESPONSE_PUB;
4636: x_return_status := FND_API.G_RET_STS_ERROR ;
4637: FND_MSG_PUB.Count_And_Get
4638: (
4639: p_count => x_msg_count,
4640: p_data => x_msg_data,
4641: p_encoded => FND_API.G_FALSE

Line 4651: FND_MSG_PUB.Count_And_Get

4647:
4648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4649: ROLLBACK TO HANDLE_TENDER_RESPONSE_PUB;
4650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4651: FND_MSG_PUB.Count_And_Get
4652: (
4653: p_count => x_msg_count,
4654: p_data => x_msg_data,
4655: p_encoded => FND_API.G_FALSE

Line 4666: FND_MSG_PUB.Count_And_Get

4662: WHEN OTHERS THEN
4663: ROLLBACK TO HANDLE_TENDER_RESPONSE_PUB;
4664: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_TENDER_RESPONSE');
4665: x_return_status := FND_API.G_RET_STS_ERROR;
4666: FND_MSG_PUB.Count_And_Get
4667: (
4668: p_count => x_msg_count,
4669: p_data => x_msg_data,
4670: p_encoded => FND_API.G_FALSE

Line 4732: FND_MSG_PUB.initialize;

4728: END IF;
4729:
4730: IF FND_API.to_Boolean( p_init_msg_list )
4731: THEN
4732: FND_MSG_PUB.initialize;
4733: END IF;
4734:
4735: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4736: x_msg_count := 0;

Line 4898: FND_MSG_PUB.Count_And_Get

4894:
4895:
4896: -- Standard call to get message count and if count is 1,get message info.
4897: --
4898: FND_MSG_PUB.Count_And_Get
4899: (
4900: p_count => x_msg_count,
4901: p_data => x_msg_data,
4902: p_encoded => FND_API.G_FALSE

Line 4919: FND_MSG_PUB.Count_And_Get

4915: --{
4916: WHEN FND_API.G_EXC_ERROR THEN
4917: ROLLBACK TO HANDLE_CANCEL_TENDER_PUB;
4918: x_return_status := FND_API.G_RET_STS_ERROR ;
4919: FND_MSG_PUB.Count_And_Get
4920: (
4921: p_count => x_msg_count,
4922: p_data => x_msg_data,
4923: p_encoded => FND_API.G_FALSE

Line 4933: FND_MSG_PUB.Count_And_Get

4929:
4930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4931: ROLLBACK TO HANDLE_CANCEL_TENDER_PUB;
4932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4933: FND_MSG_PUB.Count_And_Get
4934: (
4935: p_count => x_msg_count,
4936: p_data => x_msg_data,
4937: p_encoded => FND_API.G_FALSE

Line 4948: FND_MSG_PUB.Count_And_Get

4944: WHEN OTHERS THEN
4945: ROLLBACK TO HANDLE_CANCEL_TENDER_PUB;
4946: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_CANCEL_TENDER');
4947: x_return_status := FND_API.G_RET_STS_ERROR;
4948: FND_MSG_PUB.Count_And_Get
4949: (
4950: p_count => x_msg_count,
4951: p_data => x_msg_data,
4952: p_encoded => FND_API.G_FALSE

Line 4994: FND_MSG_PUB.initialize;

4990: SAVEPOINT RAISE_TENDER_UPDATE_PUB;
4991:
4992: IF FND_API.to_Boolean( p_init_msg_list )
4993: THEN
4994: FND_MSG_PUB.initialize;
4995: END IF;
4996:
4997:
4998: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 5118: FND_MSG_PUB.Count_And_Get

5114: );
5115:
5116: -- Standard call to get message count and if count is 1,get message info.
5117: --
5118: FND_MSG_PUB.Count_And_Get
5119: (
5120: p_count => x_msg_count,
5121: p_data => x_msg_data,
5122: p_encoded => FND_API.G_FALSE

Line 5134: FND_MSG_PUB.Count_And_Get

5130: --{
5131: WHEN FND_API.G_EXC_ERROR THEN
5132: ROLLBACK TO HANDLE_UPDATE_TENDER_PUB;
5133: x_return_status := FND_API.G_RET_STS_ERROR ;
5134: FND_MSG_PUB.Count_And_Get
5135: (
5136: p_count => x_msg_count,
5137: p_data => x_msg_data,
5138: p_encoded => FND_API.G_FALSE

Line 5143: FND_MSG_PUB.Count_And_Get

5139: );
5140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5141: ROLLBACK TO HANDLE_UPDATE_TENDER_PUB;
5142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5143: FND_MSG_PUB.Count_And_Get
5144: (
5145: p_count => x_msg_count,
5146: p_data => x_msg_data,
5147: p_encoded => FND_API.G_FALSE

Line 5153: FND_MSG_PUB.Count_And_Get

5149: WHEN OTHERS THEN
5150: ROLLBACK TO HANDLE_UPDATE_TENDER_PUB;
5151: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_UPDATE_TENDER');
5152: x_return_status := FND_API.G_RET_STS_ERROR;
5153: FND_MSG_PUB.Count_And_Get
5154: (
5155: p_count => x_msg_count,
5156: p_data => x_msg_data,
5157: p_encoded => FND_API.G_FALSE