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.WSH_CUST_MERGE dependencies on WSH_CUST_MERGE

Line 1: PACKAGE BODY WSH_CUST_MERGE as

1: PACKAGE BODY WSH_CUST_MERGE as
2: /* $Header: WSHCMRGB.pls 120.9.12010000.2 2008/08/04 12:29:20 suppal ship $ */
3:
4: --
5: --

Line 118: arp_message.set_line('WSH_CUST_MERGE.Insert_Log_Table()+' || getTimeStamp );

114: END IF;
115: --
116: --
117: IF l_debug_on THEN
118: arp_message.set_line('WSH_CUST_MERGE.Insert_Log_Table()+' || getTimeStamp );
119: END IF;
120: --
121:
122: -- Insert into Hz_Log_Table

Line 174: arp_message.set_line('WSH_CUST_MERGE.Insert_Log_Table()+' || getTimeStamp );

170: setARMessageRowCount( 'HZ_CUSTOMER_MERGE_LOG', SQL%ROWCOUNT );
171:
172: --
173: IF l_debug_on THEN
174: arp_message.set_line('WSH_CUST_MERGE.Insert_Log_Table()+' || getTimeStamp );
175: END IF;
176: --
177:
178: EXCEPTION

Line 183: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Insert_Log_Table()+ Others - ' || getTimeStamp);

179: WHEN OTHERS THEN
180: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
181: --
182: IF l_debug_on THEN
183: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Insert_Log_Table()+ Others - ' || getTimeStamp);
184: ARP_MESSAGE.Set_Error('Eror Mesg : ' || sqlerrm );
185: END IF;
186: --
187: END Insert_Log_Table;

Line 243: arp_message.set_line('WSH_CUST_MERGE.Adjust_Weight_Volume()+' || getTimeStamp );

239: END IF;
240:
241: --
242: IF l_debug_on THEN
243: arp_message.set_line('WSH_CUST_MERGE.Adjust_Weight_Volume()+' || getTimeStamp );
244: END IF;
245:
246: --
247: -- Call Mark_Reprice_Reqired, only when Unassigning from delivery

Line 356: arp_message.set_line('WSH_CUST_MERGE.Adjust_Weight_Volume()+' || getTimeStamp );

352: END IF;
353:
354: --
355: IF ( l_debug_on ) THEN
356: arp_message.set_line('WSH_CUST_MERGE.Adjust_Weight_Volume()+' || getTimeStamp );
357: END IF;
358: --
359:
360: EXCEPTION

Line 365: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Adjust_Weight_Volume()+ Weight_Volume_Exp - ' || getTimeStamp );

361: WHEN Weight_Volume_Exp THEN
362: x_return_status := l_return_status;
363: --
364: IF ( l_debug_on ) THEN
365: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Adjust_Weight_Volume()+ Weight_Volume_Exp - ' || getTimeStamp );
366: END IF;
367: --
368:
369: WHEN OTHERS THEN

Line 373: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Adjust_Weight_Volume()+ Others - ' || getTimeStamp);

369: WHEN OTHERS THEN
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: --
372: IF ( l_debug_on ) THEN
373: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Adjust_Weight_Volume()+ Others - ' || getTimeStamp);
374: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );
375: END IF;
376: --
377: END Adjust_Weight_Volume;

Line 433: arp_message.set_line('WSH_CUST_MERGE.Adjust_Parent_WV()+' || getTimeStamp );

429: END IF;
430: --
431: --
432: IF l_debug_on THEN
433: arp_message.set_line('WSH_CUST_MERGE.Adjust_Parent_WV()+' || getTimeStamp );
434: END IF;
435: --
436:
437: -- Weight/Volume adjustments

Line 513: arp_message.set_line('WSH_CUST_MERGE.Adjust_Parent_WV()+' || getTimeStamp );

509: END LOOP;
510:
511: --
512: IF ( l_debug_on ) THEN
513: arp_message.set_line('WSH_CUST_MERGE.Adjust_Parent_WV()+' || getTimeStamp );
514: END IF;
515: --
516:
517: EXCEPTION

Line 522: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Adjust_Parent_WV()+ Weight_Volume_Exp - ' || getTimeStamp );

518: WHEN Weight_Volume_Exp THEN
519: x_return_status := l_return_status;
520: --
521: IF ( l_debug_on ) THEN
522: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Adjust_Parent_WV()+ Weight_Volume_Exp - ' || getTimeStamp );
523: END IF;
524: --
525:
526: WHEN OTHERS THEN

Line 530: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Adjust_Parent_WV()+ Others - ' || getTimeStamp );

526: WHEN OTHERS THEN
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528: --
529: IF ( l_debug_on ) THEN
530: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Adjust_Parent_WV()+ Others - ' || getTimeStamp );
531: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );
532: END IF;
533: --
534: END Adjust_Parent_WV;

Line 690: arp_message.set_line('WSH_CUST_MERGE.Unassign_Details_From_Delivery()+' || getTimeStamp );

686: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
687: END IF;
688: --
689: IF l_debug_on THEN
690: arp_message.set_line('WSH_CUST_MERGE.Unassign_Details_From_Delivery()+' || getTimeStamp );
691: END IF;
692: --
693:
694: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1053: arp_message.set_line('WSH_CUST_MERGE.Unassign_Details_From_Delivery()+' || getTimeStamp );

1049:
1050: CLOSE Get_Wsh_Unassign_Details;
1051: --
1052: IF l_debug_on THEN
1053: arp_message.set_line('WSH_CUST_MERGE.Unassign_Details_From_Delivery()+' || getTimeStamp );
1054: END IF;
1055: --
1056: EXCEPTION
1057: WHEN Unassign_Del_Exp THEN

Line 1061: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Unassign_Details_From_Delivery()+ Unassign_Del_Exp - ' || getTimeStamp );

1057: WHEN Unassign_Del_Exp THEN
1058: x_return_status := l_return_status;
1059: --
1060: IF ( l_debug_on ) THEN
1061: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Unassign_Details_From_Delivery()+ Unassign_Del_Exp - ' || getTimeStamp );
1062: END IF;
1063: --
1064: IF ( Get_Cont_Unassign_Details%ISOPEN ) THEN
1065: CLOSE Get_Cont_Unassign_Details;

Line 1080: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Unassign_Details_From_Delivery()+ Others - ' || getTimeStamp );

1076: WHEN OTHERS THEN
1077: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1078: --
1079: IF ( l_debug_on ) THEN
1080: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Unassign_Details_From_Delivery()+ Others - ' || getTimeStamp );
1081: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );
1082: END IF;
1083: --
1084: IF ( Get_Cont_Unassign_Details%ISOPEN ) THEN

Line 1145: arp_message.set_line('WSH_CUST_MERGE.Get_Delivery_Hash()+' || getTimeStamp );

1141: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1142: END IF;
1143: --
1144: IF l_debug_on THEN
1145: arp_message.set_line('WSH_CUST_MERGE.Get_Delivery_Hash()+' || getTimeStamp );
1146: END IF;
1147: --
1148:
1149: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1190: arp_message.set_line('WSH_CUST_MERGE.Get_Delivery_Hash()+' || getTimeStamp );

1186: END LOOP;
1187:
1188: --
1189: IF l_debug_on THEN
1190: arp_message.set_line('WSH_CUST_MERGE.Get_Delivery_Hash()+' || getTimeStamp );
1191: END IF;
1192: --
1193: EXCEPTION
1194: WHEN Update_Hash_Exp THEN

Line 1198: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Get_Delivery_Hash()+ Update_Hash_Exp - ' || getTimeStamp );

1194: WHEN Update_Hash_Exp THEN
1195: x_return_status := l_return_status;
1196: --
1197: IF ( l_debug_on ) THEN
1198: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Get_Delivery_Hash()+ Update_Hash_Exp - ' || getTimeStamp );
1199: END IF;
1200: --
1201: WHEN OTHERS THEN
1202: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1205: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Get_Delivery_Hash()+ Others - ' || getTimeStamp );

1201: WHEN OTHERS THEN
1202: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1203: --
1204: IF ( l_debug_on ) THEN
1205: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Get_Delivery_Hash()+ Others - ' || getTimeStamp );
1206: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );
1207: END IF;
1208: --
1209: END Get_Delivery_Hash;

Line 1371: arp_message.set_line('WSH_CUST_MERGE.Process_Deliveries()+' || getTimeStamp );

1367: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1368: END IF;
1369: --
1370: IF l_debug_on THEN
1371: arp_message.set_line('WSH_CUST_MERGE.Process_Deliveries()+' || getTimeStamp );
1372: END IF;
1373: --
1374:
1375: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2106: arp_message.set_line('WSH_CUST_MERGE.Process_Deliveries()+' || getTimeStamp );

2102: END IF;
2103:
2104: --
2105: IF l_debug_on THEN
2106: arp_message.set_line('WSH_CUST_MERGE.Process_Deliveries()+' || getTimeStamp );
2107: END IF;
2108: --
2109: EXCEPTION
2110: WHEN Update_Del_Exp THEN

Line 2114: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Process_Deliveries()+ Update_Del_Exp - ' || getTimeStamp );

2110: WHEN Update_Del_Exp THEN
2111: x_return_status := l_return_status;
2112: --
2113: IF ( l_debug_on ) THEN
2114: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Process_Deliveries()+ Update_Del_Exp - ' || getTimeStamp );
2115: END IF;
2116: --
2117: IF ( Get_Del_Unassign_From_Stop%ISOPEN ) THEN
2118: CLOSE Get_Del_Unassign_From_Stop;

Line 2142: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Process_Deliveries()+ OTM Freight cost type not defined- ' || getTimeStamp );

2138: WHEN frcost_not_found THEN
2139: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2140: --
2141: IF ( l_debug_on ) THEN
2142: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Process_Deliveries()+ OTM Freight cost type not defined- ' || getTimeStamp );
2143: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );
2144: END IF;
2145: --
2146: IF ( Get_Del_Unassign_From_Stop%ISOPEN ) THEN

Line 2170: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Process_Deliveries()+ Others - ' || getTimeStamp );

2166: WHEN OTHERS THEN
2167: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2168: --
2169: IF ( l_debug_on ) THEN
2170: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Process_Deliveries()+ Others - ' || getTimeStamp );
2171: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );
2172: END IF;
2173: --
2174: IF ( Get_Del_Unassign_From_Stop%ISOPEN ) THEN

Line 2279: arp_message.set_line('WSH_CUST_MERGE.Process_Open_Deliveries()+' || getTimeStamp );

2275: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2276: END IF;
2277: --
2278: IF l_debug_on THEN
2279: arp_message.set_line('WSH_CUST_MERGE.Process_Open_Deliveries()+' || getTimeStamp );
2280: END IF;
2281: --
2282:
2283: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2451: arp_message.set_line('WSH_CUST_MERGE.Process_Open_Deliveries()+' || getTimeStamp );

2447: CLOSE Get_Empty_Cont_Delivery;
2448:
2449: --
2450: IF l_debug_on THEN
2451: arp_message.set_line('WSH_CUST_MERGE.Process_Open_Deliveries()+' || getTimeStamp );
2452: END IF;
2453: --
2454: EXCEPTION
2455: WHEN Process_Deliveries_Exp THEN

Line 2459: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Process_Open_Deliveries()+ Process_Deliveries_Exp - ' || getTimeStamp );

2455: WHEN Process_Deliveries_Exp THEN
2456: x_return_status := l_return_status;
2457: --
2458: IF ( l_debug_on ) THEN
2459: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Process_Open_Deliveries()+ Process_Deliveries_Exp - ' || getTimeStamp );
2460: END IF;
2461: --
2462: IF ( Get_Empty_Deliveries%ISOPEN ) THEN
2463: CLOSE Get_Empty_Deliveries;

Line 2474: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Process_Open_Deliveries()+ Others - ' || getTimeStamp );

2470: WHEN OTHERS THEN
2471: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2472: --
2473: IF ( l_debug_on ) THEN
2474: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Process_Open_Deliveries()+ Others - ' || getTimeStamp );
2475: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );
2476: END IF;
2477: --
2478: IF ( Get_Empty_Deliveries%ISOPEN ) THEN

Line 2565: arp_message.set_line('WSH_CUST_MERGE.Process_Open_Lines()+' || getTimeStamp );

2561: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2562: END IF;
2563: --
2564: IF l_debug_on THEN
2565: arp_message.set_line('WSH_CUST_MERGE.Process_Open_Lines()+' || getTimeStamp );
2566: END IF;
2567: --
2568:
2569: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2858: arp_message.set_line('WSH_CUST_MERGE.Process_Open_Lines()+' || getTimeStamp );

2854: DELETE FROM Wsh_Tmp;
2855:
2856: --
2857: IF l_debug_on THEN
2858: arp_message.set_line('WSH_CUST_MERGE.Process_Open_Lines()+' || getTimeStamp );
2859: END IF;
2860: --
2861: EXCEPTION
2862: WHEN Process_Open_Lines_Exp THEN

Line 2866: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Process_Open_Lines()+ Process_Open_Lines_Exp - ' || getTimeStamp );

2862: WHEN Process_Open_Lines_Exp THEN
2863: x_return_status := l_return_status;
2864: --
2865: IF l_debug_on THEN
2866: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Process_Open_Lines()+ Process_Open_Lines_Exp - ' || getTimeStamp );
2867: END IF;
2868: --
2869:
2870: -- Close open cursors

Line 2878: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Process_Open_Lines()+ Others - ' || getTimeStamp );

2874:
2875: WHEN OTHERS THEN
2876: --
2877: IF l_debug_on THEN
2878: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Process_Open_Lines()+ Others - ' || getTimeStamp );
2879: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );
2880: END IF;
2881: --
2882: -- Close open cursors

Line 2894: -- Usage: Called by WSH_CUST_MERGE.Merge

2890: -----------------------------------------------------------------------------------------
2891: --
2892: -- Procedure: Delivery_Details
2893: -- Description: New code to merge customer and site information in WSH_DELIVERY_DETAILS.
2894: -- Usage: Called by WSH_CUST_MERGE.Merge
2895: --
2896: --
2897: -- Assumptions
2898: -- If deliver_to_site_use id is null, it is assumed to be same as

Line 2999: arp_message.set_line('WSH_CUST_MERGE.Delivery_Details()+' || getTimeStamp );

2995: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2996: END IF;
2997: --
2998: IF l_debug_on THEN
2999: arp_message.set_line('WSH_CUST_MERGE.Delivery_Details()+' || getTimeStamp );
3000: END IF;
3001:
3002: IF (process_mode = 'LOCK') THEN
3003: setARMessageLockTable('WSH_DELIVERY_DETAILS');

Line 3245: arp_message.set_line('WSH_CUST_MERGE.Delivery_Details()-' || getTimeStamp);

3241: END IF;
3242:
3243:
3244: IF l_debug_on THEN
3245: arp_message.set_line('WSH_CUST_MERGE.Delivery_Details()-' || getTimeStamp);
3246: END IF;
3247:
3248: EXCEPTION
3249: WHEN wsh_cust_site_to_loc_err THEN

Line 3252: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Delivery_Details()+ wsh_cust_site_to_loc_err - ' || getTimeStamp );

3248: EXCEPTION
3249: WHEN wsh_cust_site_to_loc_err THEN
3250: --
3251: IF ( l_debug_on ) THEN
3252: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Delivery_Details()+ wsh_cust_site_to_loc_err - ' || getTimeStamp );
3253: END IF;
3254: --
3255:
3256: RAISE;

Line 3260: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Delivery_Details - Merge_Exp');

3256: RAISE;
3257: WHEN Merge_Exp THEN
3258: --
3259: IF ( l_debug_on ) THEN
3260: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Delivery_Details - Merge_Exp');
3261: END IF;
3262: --
3263:
3264: -- Close if cursors are open

Line 3278: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Delivery_Details()+ Others - ' || getTimeStamp );

3274:
3275: WHEN OTHERS THEN
3276: --
3277: IF ( l_debug_on ) THEN
3278: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Delivery_Details()+ Others - ' || getTimeStamp );
3279: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );
3280: END IF;
3281: --
3282:

Line 3301: -- Usage : Called by WSH_CUST_MERGE.Merge

3297: --
3298: -- Procedure : Picking_batches
3299: -- Description : New code to merge customer and site information in
3300: -- WSH_PICKING_BATCHES
3301: -- Usage : Called by WSH_CUST_MERGE.Merge
3302:
3303: Procedure Picking_batches
3304: (
3305: Req_Id IN NUMBER,

Line 3352: arp_message.set_line('WSH_CUST_MERGE.PICKING_BATCHES()+' || getTimeStamp);

3348: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3349: END IF;
3350: --
3351: IF l_debug_on THEN
3352: arp_message.set_line('WSH_CUST_MERGE.PICKING_BATCHES()+' || getTimeStamp);
3353: END IF;
3354: IF process_mode='LOCK' THEN
3355: setARMessageLockTable('WSH_PICKING_BATCHES');
3356: NULL;

Line 3432: arp_message.set_line('WSH_CUST_MERGE.PICKING_BATCHES()+' || getTimeStamp);

3428: arp_message.set_name('AR','AR_ROWS_UPDATED');
3429: arp_message.set_token('NUM_ROWS',to_char(l_count));
3430: END IF;
3431: IF l_debug_on THEN
3432: arp_message.set_line('WSH_CUST_MERGE.PICKING_BATCHES()+' || getTimeStamp);
3433: END IF;
3434: EXCEPTION
3435: WHEN OTHERS THEN
3436: arp_message.set_line( 'WSH_MERGE_PICKING_BATCHES');

Line 3444: -- Usage : Called by WSH_CUST_MERGE.Merge

3440: --
3441: -- Procedure : Calendar_Assignments
3442: -- Description : New code to merge customer and site information in
3443: -- WSH_CALENDAR_ASSIGNMENTS
3444: -- Usage : Called by WSH_CUST_MERGE.Merge
3445:
3446: Procedure Calendar_Assignments
3447: (
3448: Req_Id IN NUMBER,

Line 3495: arp_message.set_line('WSH_CUST_MERGE.CALENDAR_ASSIGNMENTS()+' || getTimeStamp);

3491: l_debug_on BOOLEAN;
3492: --
3493: BEGIN
3494: IF l_debug_on THEN
3495: arp_message.set_line('WSH_CUST_MERGE.CALENDAR_ASSIGNMENTS()+' || getTimeStamp);
3496: END IF;
3497:
3498: IF process_mode='LOCK' THEN
3499: setARMessageLockTable('WSH_CALENDAR_ASSIGNMENTS');

Line 3583: arp_message.set_line('WSH_CUST_MERGE.CALENDAR_ASSIGNMENTS()+' || getTimeStamp);

3579: arp_message.set_name('AR','AR_ROWS_UPDATED');
3580: arp_message.set_token('NUM_ROWS',to_char(l_count));
3581: END IF;
3582: IF l_debug_on THEN
3583: arp_message.set_line('WSH_CUST_MERGE.CALENDAR_ASSIGNMENTS()+' || getTimeStamp);
3584: END IF;
3585: EXCEPTION
3586: WHEN OTHERS THEN
3587: arp_message.set_line( 'WSH_MERGE_CALENDAR_ASSIGNMENTS');

Line 3597: -- Usage : Called by WSH_CUST_MERGE.Merge

3593: --
3594: -- Procedure : Picking_rules
3595: -- Description : New code to merge customer and site information in
3596: -- WSH_PICKING_RULES
3597: -- Usage : Called by WSH_CUST_MERGE.Merge
3598: --
3599: -----------------------------------------------------------------------------------------
3600:
3601: Procedure Picking_rules ( Req_Id IN NUMBER,

Line 3644: arp_message.set_line('WSH_CUST_MERGE.PICKING_RULES()+' || getTimeStamp);

3640: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3641: END IF;
3642: --
3643: IF l_debug_on THEN
3644: arp_message.set_line('WSH_CUST_MERGE.PICKING_RULES()+' || getTimeStamp);
3645: END IF;
3646:
3647: IF process_mode='LOCK' THEN
3648: setARMessageLockTable('WSH_PICKING_RULES');

Line 3726: arp_message.set_line('WSH_CUST_MERGE.PICKING_RULES()-' || getTimeStamp);

3722: arp_message.set_name('AR','AR_ROWS_UPDATED');
3723: arp_message.set_token('NUM_ROWS',to_char(l_count));
3724: END IF;
3725: IF l_debug_on THEN
3726: arp_message.set_line('WSH_CUST_MERGE.PICKING_RULES()-' || getTimeStamp);
3727: END IF;
3728: EXCEPTION
3729: WHEN OTHERS THEN
3730: arp_message.set_line( 'WSH_MERGE_PICKING_RULES');

Line 3785: arp_message.set_line('WSH_CUST_MERGE.Check_WMS_Details()+' || getTimeStamp );

3781: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3782: END IF;
3783: --
3784: IF l_debug_on THEN
3785: arp_message.set_line('WSH_CUST_MERGE.Check_WMS_Details()+' || getTimeStamp );
3786: END IF;
3787: --
3788:
3789: OPEN C1;

Line 3804: arp_message.set_line('WSH_CUST_MERGE.Check_WMS_Details()+' || getTimeStamp );

3800: CLOSE C1;
3801:
3802: --
3803: IF l_debug_on THEN
3804: arp_message.set_line('WSH_CUST_MERGE.Check_WMS_Details()+' || getTimeStamp );
3805: END IF;
3806: --
3807: EXCEPTION
3808: WHEN WMS_Exception THEN

Line 3811: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Check_WMS_Details - WMS_Exception');

3807: EXCEPTION
3808: WHEN WMS_Exception THEN
3809: --
3810: IF ( l_debug_on ) THEN
3811: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Check_WMS_Details - WMS_Exception');
3812: END IF;
3813: --
3814: IF ( C1%ISOPEN ) THEN
3815: CLOSE C1;

Line 3823: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Check_WMS_Details()+ Others - ' || getTimeStamp );

3819: --
3820: WHEN OTHERS THEN
3821: --
3822: IF ( l_debug_on ) THEN
3823: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Check_WMS_Details()+ Others - ' || getTimeStamp );
3824: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );
3825: END IF;
3826: --
3827: IF ( C1%ISOPEN ) THEN

Line 3857: arp_message.set_line('WSH_CUST_MERGE.Merge()+' || getTimeStamp);

3853: l_customerMergeHeaderIdTab g_number_tbl_type;
3854:
3855: BEGIN
3856: /* Calls to other internal procedures for customer Merge */
3857: arp_message.set_line('WSH_CUST_MERGE.Merge()+' || getTimeStamp);
3858: --
3859: arp_message.set_line('Req_Id,Set_Num,Process_Mode:' || Req_Id||','||Set_Num||','||Process_Mode);
3860:
3861: --

Line 3875: WSH_CUST_MERGE.Check_WMS_Details( Req_Id, Set_Num, Process_Mode ); -- ADDED

3871: IF ( G_FTE_INSTALLED IS NULL ) THEN
3872: G_FTE_INSTALLED := WSH_UTIL_CORE.Fte_Is_Installed;
3873: END IF;
3874:
3875: WSH_CUST_MERGE.Check_WMS_Details( Req_Id, Set_Num, Process_Mode ); -- ADDED
3876: WSH_CUST_MERGE.Delivery_Details( Req_Id, Set_Num, Process_Mode );
3877: -- WSH_CUST_MERGE.Deliveries( Req_Id, Set_Num, Process_Mode );
3878: WSH_CUST_MERGE.Picking_Rules( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3879: WSH_CUST_MERGE.Picking_Batches( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE

Line 3876: WSH_CUST_MERGE.Delivery_Details( Req_Id, Set_Num, Process_Mode );

3872: G_FTE_INSTALLED := WSH_UTIL_CORE.Fte_Is_Installed;
3873: END IF;
3874:
3875: WSH_CUST_MERGE.Check_WMS_Details( Req_Id, Set_Num, Process_Mode ); -- ADDED
3876: WSH_CUST_MERGE.Delivery_Details( Req_Id, Set_Num, Process_Mode );
3877: -- WSH_CUST_MERGE.Deliveries( Req_Id, Set_Num, Process_Mode );
3878: WSH_CUST_MERGE.Picking_Rules( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3879: WSH_CUST_MERGE.Picking_Batches( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3880: WSH_CUST_MERGE.Calendar_Assignments(Req_Id, Set_Num, Process_Mode ); -- NOCHANGE

Line 3877: -- WSH_CUST_MERGE.Deliveries( Req_Id, Set_Num, Process_Mode );

3873: END IF;
3874:
3875: WSH_CUST_MERGE.Check_WMS_Details( Req_Id, Set_Num, Process_Mode ); -- ADDED
3876: WSH_CUST_MERGE.Delivery_Details( Req_Id, Set_Num, Process_Mode );
3877: -- WSH_CUST_MERGE.Deliveries( Req_Id, Set_Num, Process_Mode );
3878: WSH_CUST_MERGE.Picking_Rules( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3879: WSH_CUST_MERGE.Picking_Batches( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3880: WSH_CUST_MERGE.Calendar_Assignments(Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3881:

Line 3878: WSH_CUST_MERGE.Picking_Rules( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE

3874:
3875: WSH_CUST_MERGE.Check_WMS_Details( Req_Id, Set_Num, Process_Mode ); -- ADDED
3876: WSH_CUST_MERGE.Delivery_Details( Req_Id, Set_Num, Process_Mode );
3877: -- WSH_CUST_MERGE.Deliveries( Req_Id, Set_Num, Process_Mode );
3878: WSH_CUST_MERGE.Picking_Rules( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3879: WSH_CUST_MERGE.Picking_Batches( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3880: WSH_CUST_MERGE.Calendar_Assignments(Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3881:
3882: arp_message.set_line('WSH_CUST_MERGE.Merge()-' || getTimeStamp);

Line 3879: WSH_CUST_MERGE.Picking_Batches( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE

3875: WSH_CUST_MERGE.Check_WMS_Details( Req_Id, Set_Num, Process_Mode ); -- ADDED
3876: WSH_CUST_MERGE.Delivery_Details( Req_Id, Set_Num, Process_Mode );
3877: -- WSH_CUST_MERGE.Deliveries( Req_Id, Set_Num, Process_Mode );
3878: WSH_CUST_MERGE.Picking_Rules( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3879: WSH_CUST_MERGE.Picking_Batches( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3880: WSH_CUST_MERGE.Calendar_Assignments(Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3881:
3882: arp_message.set_line('WSH_CUST_MERGE.Merge()-' || getTimeStamp);
3883:

Line 3880: WSH_CUST_MERGE.Calendar_Assignments(Req_Id, Set_Num, Process_Mode ); -- NOCHANGE

3876: WSH_CUST_MERGE.Delivery_Details( Req_Id, Set_Num, Process_Mode );
3877: -- WSH_CUST_MERGE.Deliveries( Req_Id, Set_Num, Process_Mode );
3878: WSH_CUST_MERGE.Picking_Rules( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3879: WSH_CUST_MERGE.Picking_Batches( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3880: WSH_CUST_MERGE.Calendar_Assignments(Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3881:
3882: arp_message.set_line('WSH_CUST_MERGE.Merge()-' || getTimeStamp);
3883:
3884: EXCEPTION

Line 3882: arp_message.set_line('WSH_CUST_MERGE.Merge()-' || getTimeStamp);

3878: WSH_CUST_MERGE.Picking_Rules( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3879: WSH_CUST_MERGE.Picking_Batches( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3880: WSH_CUST_MERGE.Calendar_Assignments(Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3881:
3882: arp_message.set_line('WSH_CUST_MERGE.Merge()-' || getTimeStamp);
3883:
3884: EXCEPTION
3885: WHEN OTHERS THEN
3886: arp_message.set_error('WSH_CUST_MERGE.Merge');

Line 3886: arp_message.set_error('WSH_CUST_MERGE.Merge');

3882: arp_message.set_line('WSH_CUST_MERGE.Merge()-' || getTimeStamp);
3883:
3884: EXCEPTION
3885: WHEN OTHERS THEN
3886: arp_message.set_error('WSH_CUST_MERGE.Merge');
3887: RAISE;
3888:
3889: END Merge;
3890:

Line 3891: END WSH_CUST_MERGE;

3887: RAISE;
3888:
3889: END Merge;
3890:
3891: END WSH_CUST_MERGE;