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 ARP_MESSAGE

Line 48: arp_message.set_name('AR','AR_UPDATING_TABLE');

44: --
45: PROCEDURE setARMessageUpdateTable(p_tableName IN VARCHAR2)
46: IS
47: BEGIN
48: arp_message.set_name('AR','AR_UPDATING_TABLE');
49: arp_message.set_token('TABLE_NAME', p_tableName, FALSE);
50: EXCEPTION
51: WHEN OTHERS THEN RAISE;
52: END setARMessageUpdateTable;

Line 49: arp_message.set_token('TABLE_NAME', p_tableName, FALSE);

45: PROCEDURE setARMessageUpdateTable(p_tableName IN VARCHAR2)
46: IS
47: BEGIN
48: arp_message.set_name('AR','AR_UPDATING_TABLE');
49: arp_message.set_token('TABLE_NAME', p_tableName, FALSE);
50: EXCEPTION
51: WHEN OTHERS THEN RAISE;
52: END setARMessageUpdateTable;
53:

Line 59: arp_message.set_name('AR','AR_LOCKING_TABLE');

55: --
56: PROCEDURE setARMessageLockTable(p_tableName IN VARCHAR2)
57: IS
58: BEGIN
59: arp_message.set_name('AR','AR_LOCKING_TABLE');
60: arp_message.set_token('TABLE_NAME', p_tableName, FALSE);
61: EXCEPTION
62: WHEN OTHERS THEN RAISE;
63: END setARMessageLockTable;

Line 60: arp_message.set_token('TABLE_NAME', p_tableName, FALSE);

56: PROCEDURE setARMessageLockTable(p_tableName IN VARCHAR2)
57: IS
58: BEGIN
59: arp_message.set_name('AR','AR_LOCKING_TABLE');
60: arp_message.set_token('TABLE_NAME', p_tableName, FALSE);
61: EXCEPTION
62: WHEN OTHERS THEN RAISE;
63: END setARMessageLockTable;
64:

Line 71: arp_message.set_name('AR','AR_ROWS_UPDATED');

67: --
68: PROCEDURE setARMessageRowCount(p_rowCount IN NUMBER)
69: IS
70: BEGIN
71: arp_message.set_name('AR','AR_ROWS_UPDATED');
72: arp_message.set_token('NUM_ROWS', to_char(p_rowCount));
73: EXCEPTION
74: WHEN OTHERS THEN
75: RAISE;

Line 72: arp_message.set_token('NUM_ROWS', to_char(p_rowCount));

68: PROCEDURE setARMessageRowCount(p_rowCount IN NUMBER)
69: IS
70: BEGIN
71: arp_message.set_name('AR','AR_ROWS_UPDATED');
72: arp_message.set_token('NUM_ROWS', to_char(p_rowCount));
73: EXCEPTION
74: WHEN OTHERS THEN
75: RAISE;
76: END setARMessageRowCount;

Line 85: arp_message.set_name('AR', p_mesgName);

81: -- Added for bug 4759811.
82: PROCEDURE setARMessageRowCount(p_mesgName IN VARCHAR, p_rowCount IN NUMBER)
83: IS
84: BEGIN
85: arp_message.set_name('AR', p_mesgName);
86: arp_message.set_token('NUM_ROWS', to_char(p_rowCount));
87: EXCEPTION
88: WHEN OTHERS THEN
89: RAISE;

Line 86: arp_message.set_token('NUM_ROWS', to_char(p_rowCount));

82: PROCEDURE setARMessageRowCount(p_mesgName IN VARCHAR, p_rowCount IN NUMBER)
83: IS
84: BEGIN
85: arp_message.set_name('AR', p_mesgName);
86: arp_message.set_token('NUM_ROWS', to_char(p_rowCount));
87: EXCEPTION
88: WHEN OTHERS THEN
89: RAISE;
90: END setARMessageRowCount;

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 184: ARP_MESSAGE.Set_Error('Eror Mesg : ' || sqlerrm );

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;
188:

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 270: ARP_MESSAGE.Set_Error('API WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required returned error');

266: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
267: WSH_UTIL_CORE.G_RET_STS_WARNING) ) THEN
268: --
269: IF ( l_debug_on ) THEN
270: ARP_MESSAGE.Set_Error('API WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required returned error');
271: END IF;
272: --
273: RAISE Weight_Volume_Exp;
274: END IF;

Line 314: ARP_MESSAGE.Set_Error('API WSH_WV_UTILS.DD_WV_Post_Process returned error');

310: WSH_UTIL_CORE.G_RET_STS_WARNING) )
311: THEN
312: --
313: IF ( l_debug_on ) THEN
314: ARP_MESSAGE.Set_Error('API WSH_WV_UTILS.DD_WV_Post_Process returned error');
315: END IF;
316: --
317: RAISE Weight_Volume_Exp;
318: END IF;

Line 345: ARP_MESSAGE.Set_Error('API WSH_WV_UTILS.Del_WV_Post_Process returned error');

341: WSH_UTIL_CORE.G_RET_STS_WARNING) )
342: THEN
343: --
344: IF ( l_debug_on ) THEN
345: ARP_MESSAGE.Set_Error('API WSH_WV_UTILS.Del_WV_Post_Process returned error');
346: END IF;
347: --
348: RAISE Weight_Volume_Exp;
349: END IF;

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 374: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );

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;
378: --

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 468: ARP_MESSAGE.Set_Error('API WSH_SHIPPING_PARAMS_PVT.Get returned error');

464:
465: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
466: --
467: IF ( l_debug_on ) THEN
468: ARP_MESSAGE.Set_Error('API WSH_SHIPPING_PARAMS_PVT.Get returned error');
469: END IF;
470: --
471: RAISE Weight_Volume_Exp;
472: END IF;

Line 500: ARP_MESSAGE.Set_Error('API WSH_WV_UTILS.Adjust_Parent_WV returned error');

496: WSH_UTIL_CORE.G_RET_STS_WARNING) )
497: THEN
498: --
499: IF ( l_debug_on ) THEN
500: ARP_MESSAGE.Set_Error('API WSH_WV_UTILS.Adjust_Parent_WV returned error');
501: END IF;
502: --
503: RAISE Weight_Volume_Exp;
504: END IF;

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 531: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );

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;
535:

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 789: ARP_MESSAGE.Set_Error('Error returned from API Adjust_Weight_Volume');

785: WSH_UTIL_CORE.G_RET_STS_WARNING) )
786: THEN
787: --
788: IF ( l_debug_on ) THEN
789: ARP_MESSAGE.Set_Error('Error returned from API Adjust_Weight_Volume');
790: END IF;
791: --
792: RAISE Unassign_Del_Exp;
793: END IF;

Line 832: ARP_MESSAGE.Set_Error('Error returned from API wsh_new_delivery_actions.is_delivery_empty');

828: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(l_deliveryIdTab(l_index));
829:
830: IF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
831: IF ( l_debug_on ) THEN
832: ARP_MESSAGE.Set_Error('Error returned from API wsh_new_delivery_actions.is_delivery_empty');
833: END IF;
834: raise FND_API.G_EXC_ERROR;
835: ELSIF (l_is_delivery_empty = 'Y') THEN
836: l_count := l_count + 1;

Line 840: arp_message.set_line('l_count-'||l_count||' l_delivery_id_tab-'||l_delivery_id_tab(l_count)||' l_interface_flag_tab-'||l_interface_flag_tab(l_count));

836: l_count := l_count + 1;
837: l_delivery_id_tab(l_count) := l_deliveryIdTab(l_index);
838: l_interface_flag_tab(l_count) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;
839: IF (l_debug_on) THEN
840: arp_message.set_line('l_count-'||l_count||' l_delivery_id_tab-'||l_delivery_id_tab(l_count)||' l_interface_flag_tab-'||l_interface_flag_tab(l_count));
841: END IF;
842: ELSIF (l_is_delivery_empty = 'N') THEN
843: -- do not update if assign/unassign 0/NULL weight line/LPN
844: -- to nonempty delivery

Line 852: arp_message.set_line('l_count-'||l_count||' l_delivery_id_tab-'||l_delivery_id_tab(l_count)||' l_interface_flag_tab-'||l_interface_flag_tab(l_count));

848: l_interface_flag_tab(l_count) := NULL;
849: --setting this flag here to null so that the
850: --update_tms_interface_flag procedure will take care of it.
851: IF (l_debug_on) THEN
852: arp_message.set_line('l_count-'||l_count||' l_delivery_id_tab-'||l_delivery_id_tab(l_count)||' l_interface_flag_tab-'||l_interface_flag_tab(l_count));
853: END IF;
854: END IF;
855: END IF;
856:

Line 870: ARP_MESSAGE.Set_Error('Error returned from API WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);

866:
867: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
868: --
869: IF l_debug_on THEN
870: ARP_MESSAGE.Set_Error('Error returned from API WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);
871: END IF;
872: RAISE Unassign_Del_Exp;
873: END IF;
874: END IF;

Line 905: ARP_MESSAGE.Set_Error('Not able to fetch carton_grouping_id');

901: OPEN Get_Grouping_Id;
902: FETCH Get_Grouping_Id INTO l_carton_grouping_id;
903: IF ( Get_Grouping_Id%NOTFOUND )
904: THEN
905: ARP_MESSAGE.Set_Error('Not able to fetch carton_grouping_id');
906: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
907: CLOSE Get_Grouping_Id;
908: --
909: RAISE Unassign_Del_Exp;

Line 926: ARP_MESSAGE.Set_Error('Error returned from API INV_MO_Cancel_PVT.Update_Mol_Carton_Group');

922: WSH_UTIL_CORE.G_RET_STS_WARNING) )
923: THEN
924: --
925: IF ( l_debug_on ) THEN
926: ARP_MESSAGE.Set_Error('Error returned from API INV_MO_Cancel_PVT.Update_Mol_Carton_Group');
927: END IF;
928: --
929: RAISE Unassign_Del_Exp;
930: END IF;

Line 957: ARP_MESSAGE.Set_Error('Error returned from API Adjust_Parent_WV');

953: WSH_UTIL_CORE.G_RET_STS_WARNING) )
954: THEN
955: --
956: IF ( l_debug_on ) THEN
957: ARP_MESSAGE.Set_Error('Error returned from API Adjust_Parent_WV');
958: END IF;
959: --
960: RAISE Unassign_Del_Exp;
961: END IF;

Line 1037: ARP_MESSAGE.Set_Error('API WSH_XC_UTIL.Log_Exception returned error..');

1033: );
1034:
1035: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
1036: THEN
1037: ARP_MESSAGE.Set_Error('API WSH_XC_UTIL.Log_Exception returned error..');
1038: RAISE Unassign_Del_Exp;
1039: END IF;
1040:
1041: -- }

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 1081: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );

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
1085: CLOSE Get_Cont_Unassign_Details;

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 1172: ARP_MESSAGE.Set_Error('Error returned from API Create_Hash');

1168: WSH_UTIL_CORE.G_RET_STS_WARNING) )
1169: THEN
1170: --
1171: IF ( l_debug_on ) THEN
1172: ARP_MESSAGE.Set_Error('Error returned from API Create_Hash');
1173: END IF;
1174: --
1175: RAISE Update_Hash_Exp;
1176: END IF;

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 1206: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );

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;
1210: --

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 1577: arp_message.set_line('l_tms_update-'||l_tms_update(l_index)

1573: WSH_DEBUG_SV.log('my_module','l_delivery_id-'||l_delivery_info.delivery_id
1574: ||' l_tms_update-'||l_tms_update(l_index)
1575: ||' l_tms_interface_flag-'||l_tms_interface_flag(l_index)
1576: ||' l_tms_version_number-'||l_tms_version_number(l_index));
1577: arp_message.set_line('l_tms_update-'||l_tms_update(l_index)
1578: ||' l_tms_interface_flag-'||l_tms_interface_flag(l_index)
1579: ||' l_tms_version_number-'||l_tms_version_number(l_index));
1580: END IF;
1581: l_index := l_hash_value_tab.NEXT(l_index);

Line 1699: ARP_MESSAGE.Set_Error('Error returned from API Adjust_Weight_Volume');

1695: WSH_UTIL_CORE.G_RET_STS_WARNING) )
1696: THEN
1697: --
1698: IF ( l_debug_on ) THEN
1699: ARP_MESSAGE.Set_Error('Error returned from API Adjust_Weight_Volume');
1700: END IF;
1701: --
1702: RAISE Update_Del_Exp;
1703: END IF;

Line 1867: arp_message.set_line(l_index || 'delivery id-'||l_tms_delivery_info_tab(l_index).delivery_id

1863: ||' ignore for planning-'||l_tms_delivery_info_tab(l_index).ignore_for_planning
1864: ||' tms flag-'||l_tms_delivery_info_tab(l_index).tms_interface_flag
1865: ||' delivery status-'||l_tms_delivery_info_tab(l_index).status_code
1866: ||' trip_status-'||l_tms_trip_tab(l_index).status_code);
1867: arp_message.set_line(l_index || 'delivery id-'||l_tms_delivery_info_tab(l_index).delivery_id
1868: ||' ignore for planning-'||l_tms_delivery_info_tab(l_index).ignore_for_planning
1869: ||' tms flag-'||l_tms_delivery_info_tab(l_index).tms_interface_flag
1870: ||' delivery status-'||l_tms_delivery_info_tab(l_index).status_code
1871: ||' trip_status-'||l_tms_trip_tab(l_index).status_code);

Line 1917: arp_message.set_line('unassign delivery count-'||l_dlvy_id_tab.COUNT||' aw delivery count-'||l_aw_dlvy_tab.COUNT);

1913: END IF;
1914:
1915: IF l_debug_on THEN
1916: WSH_DEBUG_SV.LOG('my module', 'unassign delivery count-'||l_dlvy_id_tab.COUNT||' aw delivery count-'||l_aw_dlvy_tab.COUNT);
1917: arp_message.set_line('unassign delivery count-'||l_dlvy_id_tab.COUNT||' aw delivery count-'||l_aw_dlvy_tab.COUNT);
1918: END IF;
1919:
1920: -- Update the Interface Flag to AW for selected deliveries
1921: -- Log appropriate exceptions(within the API)

Line 1931: ARP_MESSAGE.Set_Error('Error returned from API WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);

1927: p_tms_interface_flag_tab => l_aw_interface_flag_tab,
1928: x_return_status => l_return_status);
1929: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1930: IF l_debug_on THEN
1931: ARP_MESSAGE.Set_Error('Error returned from API WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);
1932: END IF;
1933: RAISE Update_Del_Exp;
1934: END IF;
1935: END IF;

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 2143: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );

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
2147: CLOSE Get_Del_Unassign_From_Stop;

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 2171: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );

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
2175: CLOSE Get_Del_Unassign_From_Stop;

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 2475: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );

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
2479: CLOSE Get_Empty_Deliveries;

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 2678: ARP_MESSAGE.Set_Error('Error returned from API Adjust_Weight_Volume');

2674: WSH_UTIL_CORE.G_RET_STS_WARNING) )
2675: THEN
2676: --
2677: IF ( l_debug_on ) THEN
2678: ARP_MESSAGE.Set_Error('Error returned from API Adjust_Weight_Volume');
2679: END IF;
2680: --
2681: RAISE Process_Open_Lines_Exp;
2682: END IF;

Line 2721: ARP_MESSAGE.Set_Error('Error returned from API Adjust_Parent_WV');

2717: WSH_UTIL_CORE.G_RET_STS_WARNING) )
2718: THEN
2719: --
2720: IF ( l_debug_on ) THEN
2721: ARP_MESSAGE.Set_Error('Error returned from API Adjust_Parent_WV');
2722: END IF;
2723: --
2724: RAISE Process_Open_Lines_Exp;
2725: END IF;

Line 2777: ARP_MESSAGE.Set_Error('Error returned from API WSH_XC_UTIL.Log_Exception');

2773: );
2774:
2775: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2776: THEN
2777: ARP_MESSAGE.Set_Error('Error returned from API WSH_XC_UTIL.Log_Exception');
2778: RAISE Process_Open_Lines_Exp;
2779: END IF;
2780:
2781: -- }

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 2879: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );

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
2883: IF ( Get_Open_Lines%ISOPEN ) THEN

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 3034: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );

3030: EXCEPTION
3031: WHEN NO_DATA_FOUND then
3032: raise wsh_cust_site_to_loc_err;
3033: WHEN OTHERS then
3034: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );
3035: raise;
3036: END;
3037: --
3038: --

Line 3047: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );

3043: EXCEPTION
3044: WHEN NO_DATA_FOUND then
3045: raise wsh_cust_site_to_loc_err;
3046: WHEN OTHERS then
3047: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );
3048: raise;
3049: END;
3050: --
3051:

Line 3183: ARP_MESSAGE.Set_Error('Error returned from API Insert_Log_Table');

3179: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
3180: THEN
3181: --
3182: IF ( l_debug_on ) THEN
3183: ARP_MESSAGE.Set_Error('Error returned from API Insert_Log_Table');
3184: END IF;
3185: --
3186: RAISE Merge_Exp;
3187: END IF;

Line 3210: ARP_MESSAGE.Set_Error('Error returned from API Process_Open_Lines');

3206: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
3207: THEN
3208: --
3209: IF ( l_debug_on ) THEN
3210: ARP_MESSAGE.Set_Error('Error returned from API Process_Open_Lines');
3211: END IF;
3212: --
3213: RAISE Merge_Exp;
3214: END IF;

Line 3229: ARP_MESSAGE.Set_Error('Error returned from API Process_Open_Deliveries');

3225: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
3226: THEN
3227: --
3228: IF ( l_debug_on ) THEN
3229: ARP_MESSAGE.Set_Error('Error returned from API Process_Open_Deliveries');
3230: END IF;
3231: --
3232: RAISE Merge_Exp;
3233: END IF;

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 3279: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );

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:
3283: -- Close if cursors are open

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 3358: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

3354: IF process_mode='LOCK' THEN
3355: setARMessageLockTable('WSH_PICKING_BATCHES');
3356: NULL;
3357: ELSE
3358: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
3359: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_PICKING_BATCHES',FALSE);
3360: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3361: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3362:

Line 3359: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_PICKING_BATCHES',FALSE);

3355: setARMessageLockTable('WSH_PICKING_BATCHES');
3356: NULL;
3357: ELSE
3358: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
3359: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_PICKING_BATCHES',FALSE);
3360: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3361: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3362:
3363: open merged_records;

Line 3428: arp_message.set_name('AR','AR_ROWS_UPDATED');

3424: EXIT;
3425: END IF;
3426: END LOOP;
3427:
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);

Line 3429: arp_message.set_token('NUM_ROWS',to_char(l_count));

3425: END IF;
3426: END LOOP;
3427:
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;

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 3436: arp_message.set_line( 'WSH_MERGE_PICKING_BATCHES');

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');
3437: RAISE;
3438: END Picking_batches;
3439: --
3440: --

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 3502: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

3498: IF process_mode='LOCK' THEN
3499: setARMessageLockTable('WSH_CALENDAR_ASSIGNMENTS');
3500: NULL;
3501: ELSE
3502: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
3503: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_CALENDAR_ASSIGNMENTS',FALSE);
3504: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3505: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3506:

Line 3503: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_CALENDAR_ASSIGNMENTS',FALSE);

3499: setARMessageLockTable('WSH_CALENDAR_ASSIGNMENTS');
3500: NULL;
3501: ELSE
3502: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
3503: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_CALENDAR_ASSIGNMENTS',FALSE);
3504: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3505: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3506:
3507: open merged_records;

Line 3579: arp_message.set_name('AR','AR_ROWS_UPDATED');

3575: EXIT;
3576: END IF;
3577: END LOOP;
3578:
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);

Line 3580: arp_message.set_token('NUM_ROWS',to_char(l_count));

3576: END IF;
3577: END LOOP;
3578:
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;

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 3587: arp_message.set_line( 'WSH_MERGE_CALENDAR_ASSIGNMENTS');

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');
3588: RAISE;
3589: END Calendar_Assignments;
3590:
3591: -----------------------------------------------------------------------------------------

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 3651: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

3647: IF process_mode='LOCK' THEN
3648: setARMessageLockTable('WSH_PICKING_RULES');
3649: NULL;
3650: ELSE
3651: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
3652: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_PICKING_RULES',FALSE);
3653: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3654: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3655:

Line 3652: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_PICKING_RULES',FALSE);

3648: setARMessageLockTable('WSH_PICKING_RULES');
3649: NULL;
3650: ELSE
3651: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
3652: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_PICKING_RULES',FALSE);
3653: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3654: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3655:
3656: open merged_records;

Line 3722: arp_message.set_name('AR','AR_ROWS_UPDATED');

3718: EXIT;
3719: END IF;
3720: END LOOP;
3721:
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);

Line 3723: arp_message.set_token('NUM_ROWS',to_char(l_count));

3719: END IF;
3720: END LOOP;
3721:
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;

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 3730: arp_message.set_line( 'WSH_MERGE_PICKING_RULES');

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');
3731: RAISE;
3732: END Picking_rules;
3733:
3734:

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 3794: ARP_MESSAGE.Set_Error('There exists WMS records in shipping which are Staged');

3790: FETCH C1 INTO l_count;
3791: IF ( C1%FOUND ) THEN
3792: --
3793: IF ( l_debug_on ) THEN
3794: ARP_MESSAGE.Set_Error('There exists WMS records in shipping which are Staged');
3795: END IF;
3796: --
3797: CLOSE C1;
3798: RAISE WMS_Exception;

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 3824: ARP_MESSAGE.Set_Error('Error Mesg : ' || sqlerrm );

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
3828: CLOSE C1;

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 3859: arp_message.set_line('Req_Id,Set_Num,Process_Mode:' || Req_Id||','||Set_Num||','||Process_Mode);

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: --
3862: -- For inserting record into HZ Log Table based on profile option value
3863: --

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: