999: FOR expCnt in l_deliveryIdTab.FIRST..l_deliveryIdTab.LAST
1000: LOOP
1001: -- { Loop for logging Expceptions
1002: -- Setting the Messages
1003: FND_MESSAGE.Set_Name ('WSH', l_message_name );
1004: FND_MESSAGE.Set_Token ('PS1', G_FROM_CUST_SITE_ID );
1005: FND_MESSAGE.Set_Token ('PS2', G_TO_CUST_SITE_ID );
1006: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_deliveryDetailIdTab(expCnt) );
1007:
1000: LOOP
1001: -- { Loop for logging Expceptions
1002: -- Setting the Messages
1003: FND_MESSAGE.Set_Name ('WSH', l_message_name );
1004: FND_MESSAGE.Set_Token ('PS1', G_FROM_CUST_SITE_ID );
1005: FND_MESSAGE.Set_Token ('PS2', G_TO_CUST_SITE_ID );
1006: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_deliveryDetailIdTab(expCnt) );
1007:
1008: l_message_text := FND_MESSAGE.Get;
1001: -- { Loop for logging Expceptions
1002: -- Setting the Messages
1003: FND_MESSAGE.Set_Name ('WSH', l_message_name );
1004: FND_MESSAGE.Set_Token ('PS1', G_FROM_CUST_SITE_ID );
1005: FND_MESSAGE.Set_Token ('PS2', G_TO_CUST_SITE_ID );
1006: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_deliveryDetailIdTab(expCnt) );
1007:
1008: l_message_text := FND_MESSAGE.Get;
1009:
1002: -- Setting the Messages
1003: FND_MESSAGE.Set_Name ('WSH', l_message_name );
1004: FND_MESSAGE.Set_Token ('PS1', G_FROM_CUST_SITE_ID );
1005: FND_MESSAGE.Set_Token ('PS2', G_TO_CUST_SITE_ID );
1006: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_deliveryDetailIdTab(expCnt) );
1007:
1008: l_message_text := FND_MESSAGE.Get;
1009:
1010: l_return_status := NULL;
1004: FND_MESSAGE.Set_Token ('PS1', G_FROM_CUST_SITE_ID );
1005: FND_MESSAGE.Set_Token ('PS2', G_TO_CUST_SITE_ID );
1006: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_deliveryDetailIdTab(expCnt) );
1007:
1008: l_message_text := FND_MESSAGE.Get;
1009:
1010: l_return_status := NULL;
1011: l_msg_count := NULL;
1012: l_msg_data := NULL;
2007: IF l_skip = 'N' THEN --if l_skip is 'N' then that means the delivery is not unassigned previously due to OTM integration
2008: -- CONTINUE WITH CURRENT CODE/LOGIC
2009: -- End of OTM R12 : customer merge
2010:
2011: FND_MESSAGE.Set_Name ('WSH', l_message_name );
2012: FND_MESSAGE.Set_Token ('PS1', G_FROM_CUST_SITE_ID );
2013: FND_MESSAGE.Set_Token ('PS2', G_TO_CUST_SITE_ID );
2014: FND_MESSAGE.Set_Token ('DELIVERY_ID', l_deliveryIdTab(ExpCnt) );
2015:
2008: -- CONTINUE WITH CURRENT CODE/LOGIC
2009: -- End of OTM R12 : customer merge
2010:
2011: FND_MESSAGE.Set_Name ('WSH', l_message_name );
2012: FND_MESSAGE.Set_Token ('PS1', G_FROM_CUST_SITE_ID );
2013: FND_MESSAGE.Set_Token ('PS2', G_TO_CUST_SITE_ID );
2014: FND_MESSAGE.Set_Token ('DELIVERY_ID', l_deliveryIdTab(ExpCnt) );
2015:
2016: l_message_text := FND_MESSAGE.Get;
2009: -- End of OTM R12 : customer merge
2010:
2011: FND_MESSAGE.Set_Name ('WSH', l_message_name );
2012: FND_MESSAGE.Set_Token ('PS1', G_FROM_CUST_SITE_ID );
2013: FND_MESSAGE.Set_Token ('PS2', G_TO_CUST_SITE_ID );
2014: FND_MESSAGE.Set_Token ('DELIVERY_ID', l_deliveryIdTab(ExpCnt) );
2015:
2016: l_message_text := FND_MESSAGE.Get;
2017:
2010:
2011: FND_MESSAGE.Set_Name ('WSH', l_message_name );
2012: FND_MESSAGE.Set_Token ('PS1', G_FROM_CUST_SITE_ID );
2013: FND_MESSAGE.Set_Token ('PS2', G_TO_CUST_SITE_ID );
2014: FND_MESSAGE.Set_Token ('DELIVERY_ID', l_deliveryIdTab(ExpCnt) );
2015:
2016: l_message_text := FND_MESSAGE.Get;
2017:
2018: l_return_status := NULL;
2012: FND_MESSAGE.Set_Token ('PS1', G_FROM_CUST_SITE_ID );
2013: FND_MESSAGE.Set_Token ('PS2', G_TO_CUST_SITE_ID );
2014: FND_MESSAGE.Set_Token ('DELIVERY_ID', l_deliveryIdTab(ExpCnt) );
2015:
2016: l_message_text := FND_MESSAGE.Get;
2017:
2018: l_return_status := NULL;
2019: l_msg_count := NULL;
2020: l_msg_data := NULL;
2740: IF ( l_parentDeliveryDetailIdTab(expCnt) IS NOT NULL AND
2741: l_deliveryIdTab(expCnt) IS NULL )
2742: THEN
2743: -- {
2744: FND_MESSAGE.Set_Name ('WSH', l_message_name );
2745: FND_MESSAGE.Set_Token ('PS1', G_FROM_CUST_SITE_ID );
2746: FND_MESSAGE.Set_Token ('PS2', G_TO_CUST_SITE_ID );
2747: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_deliveryDetailIdTab(ExpCnt) );
2748:
2741: l_deliveryIdTab(expCnt) IS NULL )
2742: THEN
2743: -- {
2744: FND_MESSAGE.Set_Name ('WSH', l_message_name );
2745: FND_MESSAGE.Set_Token ('PS1', G_FROM_CUST_SITE_ID );
2746: FND_MESSAGE.Set_Token ('PS2', G_TO_CUST_SITE_ID );
2747: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_deliveryDetailIdTab(ExpCnt) );
2748:
2749: l_message_text := FND_MESSAGE.Get;
2742: THEN
2743: -- {
2744: FND_MESSAGE.Set_Name ('WSH', l_message_name );
2745: FND_MESSAGE.Set_Token ('PS1', G_FROM_CUST_SITE_ID );
2746: FND_MESSAGE.Set_Token ('PS2', G_TO_CUST_SITE_ID );
2747: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_deliveryDetailIdTab(ExpCnt) );
2748:
2749: l_message_text := FND_MESSAGE.Get;
2750:
2743: -- {
2744: FND_MESSAGE.Set_Name ('WSH', l_message_name );
2745: FND_MESSAGE.Set_Token ('PS1', G_FROM_CUST_SITE_ID );
2746: FND_MESSAGE.Set_Token ('PS2', G_TO_CUST_SITE_ID );
2747: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_deliveryDetailIdTab(ExpCnt) );
2748:
2749: l_message_text := FND_MESSAGE.Get;
2750:
2751: l_return_status := NULL;
2745: FND_MESSAGE.Set_Token ('PS1', G_FROM_CUST_SITE_ID );
2746: FND_MESSAGE.Set_Token ('PS2', G_TO_CUST_SITE_ID );
2747: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_deliveryDetailIdTab(ExpCnt) );
2748:
2749: l_message_text := FND_MESSAGE.Get;
2750:
2751: l_return_status := NULL;
2752: l_msg_count := NULL;
2753: l_msg_data := NULL;