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.4 2009/12/03 16:10:33 gbhargav 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 1050: arp_message.set_line('WSH_CUST_MERGE.Unassign_Details_From_Delivery()+' || getTimeStamp );

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3872: arp_message.set_line('WSH_CUST_MERGE.Check_LSP_Install()+' || getTimeStamp );

3868: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3869: END IF;
3870: --
3871: IF l_debug_on THEN
3872: arp_message.set_line('WSH_CUST_MERGE.Check_LSP_Install()+' || getTimeStamp );
3873: END IF;
3874: --
3875: IF WMS_DEPLOY.WMS_DEPLOYMENT_MODE = 'L' THEN
3876: IF l_debug_on THEN

Line 3898: arp_message.set_line('WSH_CUST_MERGE.Check_LSP_Install()+' || getTimeStamp );

3894: END IF;
3895: END IF;
3896: --
3897: IF l_debug_on THEN
3898: arp_message.set_line('WSH_CUST_MERGE.Check_LSP_Install()+' || getTimeStamp );
3899: END IF;
3900: --
3901: EXCEPTION
3902: WHEN LSP_Exception THEN

Line 3905: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Check_LSP_Install - LSP_Exception');

3901: EXCEPTION
3902: WHEN LSP_Exception THEN
3903: --
3904: IF ( l_debug_on ) THEN
3905: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Check_LSP_Install - LSP_Exception');
3906: END IF;
3907: --
3908: IF ( C1%ISOPEN ) THEN
3909: CLOSE C1;

Line 3917: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Check_LSP_Install()+ Others - ' || getTimeStamp );

3913: --
3914: WHEN OTHERS THEN
3915: --
3916: IF ( l_debug_on ) THEN
3917: ARP_MESSAGE.Set_Error('WSH_CUST_MERGE.Check_LSP_Install()+ Others - ' || getTimeStamp );
3918: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );
3919: END IF;
3920: --
3921: IF ( C1%ISOPEN ) THEN

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

3949: l_customerMergeHeaderIdTab g_number_tbl_type;
3950:
3951: BEGIN
3952: /* Calls to other internal procedures for customer Merge */
3953: arp_message.set_line('WSH_CUST_MERGE.Merge()+' || getTimeStamp);
3954: --
3955: arp_message.set_line('Req_Id,Set_Num,Process_Mode:' || Req_Id||','||Set_Num||','||Process_Mode);
3956:
3957: --

Line 3971: WSH_CUST_MERGE.Check_Lsp_Install( Req_Id, Set_Num, Process_Mode ); -- ADDED

3967: IF ( G_FTE_INSTALLED IS NULL ) THEN
3968: G_FTE_INSTALLED := WSH_UTIL_CORE.Fte_Is_Installed;
3969: END IF;
3970: -- LSP PROJECT : Check for LSP clients.
3971: WSH_CUST_MERGE.Check_Lsp_Install( Req_Id, Set_Num, Process_Mode ); -- ADDED
3972: WSH_CUST_MERGE.Check_WMS_Details( Req_Id, Set_Num, Process_Mode ); -- ADDED
3973: WSH_CUST_MERGE.Delivery_Details( Req_Id, Set_Num, Process_Mode );
3974: -- WSH_CUST_MERGE.Deliveries( Req_Id, Set_Num, Process_Mode );
3975: WSH_CUST_MERGE.Picking_Rules( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE

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

3968: G_FTE_INSTALLED := WSH_UTIL_CORE.Fte_Is_Installed;
3969: END IF;
3970: -- LSP PROJECT : Check for LSP clients.
3971: WSH_CUST_MERGE.Check_Lsp_Install( Req_Id, Set_Num, Process_Mode ); -- ADDED
3972: WSH_CUST_MERGE.Check_WMS_Details( Req_Id, Set_Num, Process_Mode ); -- ADDED
3973: WSH_CUST_MERGE.Delivery_Details( Req_Id, Set_Num, Process_Mode );
3974: -- WSH_CUST_MERGE.Deliveries( Req_Id, Set_Num, Process_Mode );
3975: WSH_CUST_MERGE.Picking_Rules( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3976: WSH_CUST_MERGE.Picking_Batches( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE

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

3969: END IF;
3970: -- LSP PROJECT : Check for LSP clients.
3971: WSH_CUST_MERGE.Check_Lsp_Install( Req_Id, Set_Num, Process_Mode ); -- ADDED
3972: WSH_CUST_MERGE.Check_WMS_Details( Req_Id, Set_Num, Process_Mode ); -- ADDED
3973: WSH_CUST_MERGE.Delivery_Details( Req_Id, Set_Num, Process_Mode );
3974: -- WSH_CUST_MERGE.Deliveries( Req_Id, Set_Num, Process_Mode );
3975: WSH_CUST_MERGE.Picking_Rules( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3976: WSH_CUST_MERGE.Picking_Batches( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3977: WSH_CUST_MERGE.Calendar_Assignments(Req_Id, Set_Num, Process_Mode ); -- NOCHANGE

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

3970: -- LSP PROJECT : Check for LSP clients.
3971: WSH_CUST_MERGE.Check_Lsp_Install( Req_Id, Set_Num, Process_Mode ); -- ADDED
3972: WSH_CUST_MERGE.Check_WMS_Details( Req_Id, Set_Num, Process_Mode ); -- ADDED
3973: WSH_CUST_MERGE.Delivery_Details( Req_Id, Set_Num, Process_Mode );
3974: -- WSH_CUST_MERGE.Deliveries( Req_Id, Set_Num, Process_Mode );
3975: WSH_CUST_MERGE.Picking_Rules( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3976: WSH_CUST_MERGE.Picking_Batches( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3977: WSH_CUST_MERGE.Calendar_Assignments(Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3978:

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

3971: WSH_CUST_MERGE.Check_Lsp_Install( Req_Id, Set_Num, Process_Mode ); -- ADDED
3972: WSH_CUST_MERGE.Check_WMS_Details( Req_Id, Set_Num, Process_Mode ); -- ADDED
3973: WSH_CUST_MERGE.Delivery_Details( Req_Id, Set_Num, Process_Mode );
3974: -- WSH_CUST_MERGE.Deliveries( Req_Id, Set_Num, Process_Mode );
3975: WSH_CUST_MERGE.Picking_Rules( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3976: WSH_CUST_MERGE.Picking_Batches( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3977: WSH_CUST_MERGE.Calendar_Assignments(Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3978:
3979: arp_message.set_line('WSH_CUST_MERGE.Merge()-' || getTimeStamp);

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

3972: WSH_CUST_MERGE.Check_WMS_Details( Req_Id, Set_Num, Process_Mode ); -- ADDED
3973: WSH_CUST_MERGE.Delivery_Details( Req_Id, Set_Num, Process_Mode );
3974: -- WSH_CUST_MERGE.Deliveries( Req_Id, Set_Num, Process_Mode );
3975: WSH_CUST_MERGE.Picking_Rules( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3976: WSH_CUST_MERGE.Picking_Batches( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3977: WSH_CUST_MERGE.Calendar_Assignments(Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3978:
3979: arp_message.set_line('WSH_CUST_MERGE.Merge()-' || getTimeStamp);
3980:

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

3973: WSH_CUST_MERGE.Delivery_Details( Req_Id, Set_Num, Process_Mode );
3974: -- WSH_CUST_MERGE.Deliveries( Req_Id, Set_Num, Process_Mode );
3975: WSH_CUST_MERGE.Picking_Rules( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3976: WSH_CUST_MERGE.Picking_Batches( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3977: WSH_CUST_MERGE.Calendar_Assignments(Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3978:
3979: arp_message.set_line('WSH_CUST_MERGE.Merge()-' || getTimeStamp);
3980:
3981: EXCEPTION

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

3975: WSH_CUST_MERGE.Picking_Rules( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3976: WSH_CUST_MERGE.Picking_Batches( Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3977: WSH_CUST_MERGE.Calendar_Assignments(Req_Id, Set_Num, Process_Mode ); -- NOCHANGE
3978:
3979: arp_message.set_line('WSH_CUST_MERGE.Merge()-' || getTimeStamp);
3980:
3981: EXCEPTION
3982: WHEN OTHERS THEN
3983: arp_message.set_error('WSH_CUST_MERGE.Merge');

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

3979: arp_message.set_line('WSH_CUST_MERGE.Merge()-' || getTimeStamp);
3980:
3981: EXCEPTION
3982: WHEN OTHERS THEN
3983: arp_message.set_error('WSH_CUST_MERGE.Merge');
3984: RAISE;
3985:
3986: END Merge;
3987:

Line 3988: END WSH_CUST_MERGE;

3984: RAISE;
3985:
3986: END Merge;
3987:
3988: END WSH_CUST_MERGE;