[Home] [Help]
109: END IF;
110:
111: l_parameter_list.DELETE;
112:
113: -- Standard call to get message count and if count is 1,get message info.
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;
306:
307:
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,
456: );
457:
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,
637: );
638:
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,
780: );
781:
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,
1217: IF l_debug_on THEN
1218: WSH_DEBUG_SV.logmsg(l_module_name,'after CAN_PERFORM_THIS_ACTION', WSH_DEBUG_SV.C_PROC_LEVEL);
1219: END IF;
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: (
1330:
1331: --{
1332: BEGIN
1333: --
1334: -- Standard Start of API savepoint
1335: SAVEPOINT DELETE_TENDER_SNAPSHOT_PUB;
1336: --
1337: --
1338: -- Initialize message list if p_init_msg_list is set to TRUE.
1358: DELETE FROM FTE_TENDER_SNAPSHOT
1359: WHERE LOAD_TENDER_NUMBER = p_tender_id;
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,
1457:
1458: --{
1459: BEGIN
1460: --
1461: -- Standard Start of API savepoint
1462: SAVEPOINT TAKE_TENDER_SNAPSHOT_PUB;
1463: --
1464: --
1465: -- Initialize message list if p_init_msg_list is set to TRUE.
1540: WHERE LOAD_TENDER_NUMBER = p_tender_id;
1541: END IF;
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,
1625: l_action VARCHAR2(30);
1626:
1627: BEGIN
1628: --
1629: -- Standard Start of API savepoint
1630: SAVEPOINT TAKE_TENDER_SNAPSHOT_PUB;
1631: --
1632: --
1633: -- Initialize message list if p_init_msg_list is set to TRUE.
1717: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1718: END IF;
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,
1886:
1887: --{
1888: BEGIN
1889: --
1890: -- Standard Start of API savepoint
1891: SAVEPOINT CHECK_THRESHOLD_FOR_STOP_PUB;
1892: --
1893: x_return_status := FND_API.G_RET_STS_SUCCESS;
1894:
2595: IF l_debug_on THEN
2596: WSH_DEBUG_SV.pop(l_module_name);
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,
2913: END IF;
2914: -----------------------------------------------------------------------------------
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,
3162: p_contact_perf => l_role_name);
3163: END IF;
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,
3845:
3846:
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,
4157: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4158: END IF;
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,
4350: END IF;
4351:
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,
4610:
4611: l_parameter_list.DELETE;
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,
4892:
4893: l_parameter_list.DELETE;
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,
5112: p_event_key => GET_ITEM_KEY(p_trip_info.trip_id),--p_item_key,
5113: p_parameters => l_parameter_list
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,