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_BATCH_PROCESS dependencies on FND_MESSAGE

Line 849: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');

845: WHEN stop_trip_locked THEN
846: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
847: CLOSE lock_stop_trip ;
848: WSH_UTIL_CORE.PrintMsg('ERROR: Failed to lock stop and trip, stop ID '||to_char(p_stop_id));
849: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');
850: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_stop_id));
851: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
852: IF l_debug_on THEN
853: WSH_DEBUG_SV.log(l_module_name, 'ERROR: Failed to lock stop and trip, stop ID '||to_char(p_stop_id));

Line 850: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_stop_id));

846: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
847: CLOSE lock_stop_trip ;
848: WSH_UTIL_CORE.PrintMsg('ERROR: Failed to lock stop and trip, stop ID '||to_char(p_stop_id));
849: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');
850: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_stop_id));
851: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
852: IF l_debug_on THEN
853: WSH_DEBUG_SV.log(l_module_name, 'ERROR: Failed to lock stop and trip, stop ID '||to_char(p_stop_id));
854: WSH_DEBUG_SV.POP(l_module_name);

Line 861: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');

857: WHEN others THEN
858: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
859: CLOSE lock_stop_trip;
860: WSH_UTIL_CORE.PrintMsg('ERROR: Failed to lock stop and trip, stop ID '||to_char(p_stop_id));
861: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');
862: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_stop_id));
863: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
864: IF l_debug_on THEN
865: WSH_DEBUG_SV.log(l_module_name, 'ERROR: Failed to lock stop and trip, stop ID '||to_char(p_stop_id));

Line 862: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_stop_id));

858: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
859: CLOSE lock_stop_trip;
860: WSH_UTIL_CORE.PrintMsg('ERROR: Failed to lock stop and trip, stop ID '||to_char(p_stop_id));
861: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');
862: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_stop_id));
863: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
864: IF l_debug_on THEN
865: WSH_DEBUG_SV.log(l_module_name, 'ERROR: Failed to lock stop and trip, stop ID '||to_char(p_stop_id));
866: WSH_DEBUG_SV.POP(l_module_name);

Line 1086: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');

1082:
1083: WHEN delivery_locked THEN
1084: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1085: WSH_UTIL_CORE.PrintMsg('ERROR2: Failed to lock delivery ID '||to_char(p_del_tab(i).delivery_id));
1086: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');
1087: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));
1088: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
1089: log_batch_messages(p_sc_batch_id, NULL ,NULL, p_del_tab(i).initial_pickup_location_id, NULL);
1090: IF l_debug_on THEN

Line 1087: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));

1083: WHEN delivery_locked THEN
1084: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1085: WSH_UTIL_CORE.PrintMsg('ERROR2: Failed to lock delivery ID '||to_char(p_del_tab(i).delivery_id));
1086: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');
1087: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));
1088: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
1089: log_batch_messages(p_sc_batch_id, NULL ,NULL, p_del_tab(i).initial_pickup_location_id, NULL);
1090: IF l_debug_on THEN
1091: WSH_DEBUG_SV.logmsg('wsh.plsql.' || G_PKG_NAME || '.' || 'Ship_Confirm_A_Delivery', 'ERROR: Failed to lock delivery ID '||to_char(p_del_tab(i).delivery_id));

Line 1099: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');

1095: WHEN OTHERS THEN
1096: /* this will catch the exception when failing to obtain the lock on the delivery */
1097: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1098: WSH_UTIL_CORE.PrintMsg('ERROR3: Failed to lock delivery ID '||to_char(p_del_tab(i).delivery_id));
1099: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');
1100: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));
1101: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
1102: IF l_debug_on THEN
1103: WSH_DEBUG_SV.logmsg('wsh.plsql.' || G_PKG_NAME || '.' || 'Ship_Confirm_A_Delivery', 'ERROR: Failed to lock delivery ID '||to_char(p_del_tab(i).delivery_id));

Line 1100: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));

1096: /* this will catch the exception when failing to obtain the lock on the delivery */
1097: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1098: WSH_UTIL_CORE.PrintMsg('ERROR3: Failed to lock delivery ID '||to_char(p_del_tab(i).delivery_id));
1099: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');
1100: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));
1101: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
1102: IF l_debug_on THEN
1103: WSH_DEBUG_SV.logmsg('wsh.plsql.' || G_PKG_NAME || '.' || 'Ship_Confirm_A_Delivery', 'ERROR: Failed to lock delivery ID '||to_char(p_del_tab(i).delivery_id));
1104: WSH_DEBUG_SV.POP('wsh.plsql.' || G_PKG_NAME || '.' || 'Ship_Confirm_A_Delivery');

Line 1299: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');

1295: WSH_DEBUG_SV.logmsg(l_module_name,'Failed to close stop '|| l_stops_to_close(i));
1296: END IF;
1297:
1298: IF l_lock_error = 'Y' THEN
1299: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');
1300: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(l_stops_to_close(i)));
1301: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
1302: END IF;
1303: l_closing_stop_failure := l_closing_stop_failure + 1;

Line 1300: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(l_stops_to_close(i)));

1296: END IF;
1297:
1298: IF l_lock_error = 'Y' THEN
1299: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');
1300: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(l_stops_to_close(i)));
1301: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
1302: END IF;
1303: l_closing_stop_failure := l_closing_stop_failure + 1;
1304: log_batch_messages(p_sc_batch_id, NULL , l_stops_to_close(i) , l_stop_location_ids(i), NULL);

Line 1735: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');

1731:
1732: WHEN delivery_locked THEN
1733: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1734: WSH_UTIL_CORE.PrintMsg('ERROR => Failed to lock delivery '|| to_char(p_del_tab(i).delivery_id));
1735: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');
1736: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));
1737: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
1738: log_batch_messages(p_ap_batch_id, NULL ,NULL, p_del_tab(i).initial_pickup_location_id, 'E');
1739:

Line 1736: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));

1732: WHEN delivery_locked THEN
1733: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1734: WSH_UTIL_CORE.PrintMsg('ERROR => Failed to lock delivery '|| to_char(p_del_tab(i).delivery_id));
1735: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');
1736: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));
1737: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
1738: log_batch_messages(p_ap_batch_id, NULL ,NULL, p_del_tab(i).initial_pickup_location_id, 'E');
1739:
1740: IF l_debug_on THEN

Line 1748: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');

1744:
1745: WHEN OTHERS THEN
1746: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1747: WSH_UTIL_CORE.PrintMsg('ERROR => Failed to lock delivery '|| to_char(p_del_tab(i).delivery_id));
1748: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');
1749: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));
1750: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
1751:
1752: IF l_debug_on THEN

Line 1749: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));

1745: WHEN OTHERS THEN
1746: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1747: WSH_UTIL_CORE.PrintMsg('ERROR => Failed to lock delivery '|| to_char(p_del_tab(i).delivery_id));
1748: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');
1749: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));
1750: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
1751:
1752: IF l_debug_on THEN
1753: WSH_DEBUG_SV.logmsg(l_module_name, 'Failed to lock delivery '|| to_char(p_del_tab(i).delivery_id));

Line 1870: FND_MESSAGE.SET_NAME('WSH' , 'WSH_INVALID_AUTO_PACK_LEVEL');

1866: EXCEPTION
1867:
1868: WHEN WSH_INVALID_AUTO_PACK_LEVEL THEN
1869: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1870: FND_MESSAGE.SET_NAME('WSH' , 'WSH_INVALID_AUTO_PACK_LEVEL');
1871: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
1872: IF l_debug_on THEN
1873: WSH_DEBUG_SV.pop(l_module_name);
1874: END IF;

Line 1878: FND_MESSAGE.SET_NAME('WSH' , 'WSH_SUBMIT_AP_REPORT_ERR');

1874: END IF;
1875:
1876: WHEN WSH_SUBMIT_AP_REPORT_ERR THEN
1877: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1878: FND_MESSAGE.SET_NAME('WSH' , 'WSH_SUBMIT_AP_REPORT_ERR');
1879: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
1880: IF l_debug_on THEN
1881: WSH_DEBUG_SV.pop(l_module_name);
1882: END IF;

Line 2812: g_error_message := substrb(FND_MESSAGE.Get_String('FND', 'FND_MBOX_WARN_CONSTANT'), 1,500);

2808: /* IF p_error_status = 'W' THEN
2809:
2810: IF g_error_message is NULL THEN
2811:
2812: g_error_message := substrb(FND_MESSAGE.Get_String('FND', 'FND_MBOX_WARN_CONSTANT'), 1,500);
2813:
2814: END IF;
2815:
2816: l_error_message := g_error_message;

Line 3003: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_STATUS');

2999: l_sc_WHERE := l_sc_WHERE || ' AND wdd.move_order_line_id IS NOT NULL ';
3000: END IF;
3001: -- End Bug 5624475 and ECO 5676263
3002: --
3003: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_STATUS');
3004: l_msg_string := NULL;
3005: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3006: p_lookup_code => p_select_criteria.delivery_lines_status,
3007: p_lookup_type => 'WSH_PD_DEL_LINE_STATUS' );

Line 3008: FND_MESSAGE.SET_TOKEN('DETAILS_STATUS', l_msg_string);

3004: l_msg_string := NULL;
3005: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3006: p_lookup_code => p_select_criteria.delivery_lines_status,
3007: p_lookup_type => 'WSH_PD_DEL_LINE_STATUS' );
3008: FND_MESSAGE.SET_TOKEN('DETAILS_STATUS', l_msg_string);
3009: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3010:
3011: WSH_UTIL_CORE.PrintMsg(' Delivery Lines Status: '|| p_select_criteria.delivery_lines_status);
3012: END IF;

Line 3009: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3005: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3006: p_lookup_code => p_select_criteria.delivery_lines_status,
3007: p_lookup_type => 'WSH_PD_DEL_LINE_STATUS' );
3008: FND_MESSAGE.SET_TOKEN('DETAILS_STATUS', l_msg_string);
3009: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3010:
3011: WSH_UTIL_CORE.PrintMsg(' Delivery Lines Status: '|| p_select_criteria.delivery_lines_status);
3012: END IF;
3013:

Line 3017: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_ORGANIZATION');

3013:
3014: -- put organization in the where clause if it is part of selection criteria
3015: IF p_select_criteria.organization_id IS NOT NULL THEN
3016: l_sc_WHERE := l_sc_WHERE ||'AND wdd.organization_id = :x_organization_id ';
3017: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_ORGANIZATION');
3018: FND_MESSAGE.SET_TOKEN('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(p_select_criteria.organization_id));
3019: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3020:
3021: WSH_UTIL_CORE.PrintMsg(' Organization ID: '|| p_select_criteria.organization_id);

Line 3018: FND_MESSAGE.SET_TOKEN('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(p_select_criteria.organization_id));

3014: -- put organization in the where clause if it is part of selection criteria
3015: IF p_select_criteria.organization_id IS NOT NULL THEN
3016: l_sc_WHERE := l_sc_WHERE ||'AND wdd.organization_id = :x_organization_id ';
3017: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_ORGANIZATION');
3018: FND_MESSAGE.SET_TOKEN('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(p_select_criteria.organization_id));
3019: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3020:
3021: WSH_UTIL_CORE.PrintMsg(' Organization ID: '|| p_select_criteria.organization_id);
3022: END IF;

Line 3019: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3015: IF p_select_criteria.organization_id IS NOT NULL THEN
3016: l_sc_WHERE := l_sc_WHERE ||'AND wdd.organization_id = :x_organization_id ';
3017: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_ORGANIZATION');
3018: FND_MESSAGE.SET_TOKEN('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(p_select_criteria.organization_id));
3019: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3020:
3021: WSH_UTIL_CORE.PrintMsg(' Organization ID: '|| p_select_criteria.organization_id);
3022: END IF;
3023:

Line 3035: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');

3031:
3032: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled BETWEEN :x_scheduled_ship_date_lo AND :x_scheduled_ship_date_hi ';
3033:
3034:
3035: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');
3036: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3037: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3038:
3039: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');

Line 3036: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));

3032: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled BETWEEN :x_scheduled_ship_date_lo AND :x_scheduled_ship_date_hi ';
3033:
3034:
3035: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');
3036: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3037: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3038:
3039: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
3040: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));

Line 3037: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);

3033:
3034:
3035: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');
3036: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3037: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3038:
3039: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
3040: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3041: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);

Line 3039: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');

3035: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');
3036: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3037: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3038:
3039: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
3040: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3041: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3042:
3043: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date Start: '|| to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));

Line 3040: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));

3036: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3037: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3038:
3039: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
3040: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3041: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3042:
3043: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date Start: '|| to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3044: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date End: '|| to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));

Line 3041: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);

3037: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3038:
3039: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
3040: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3041: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3042:
3043: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date Start: '|| to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3044: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date End: '|| to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3045:

Line 3050: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');

3046: ELSIF p_select_criteria.scheduled_ship_date_lo IS NOT NULL THEN
3047: l_scheduled_ship_date_lo := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_lo);
3048: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled >= :x_scheduled_ship_date_lo ';
3049:
3050: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');
3051: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3052: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3053: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date Start: '|| to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3054:

Line 3051: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));

3047: l_scheduled_ship_date_lo := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_lo);
3048: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled >= :x_scheduled_ship_date_lo ';
3049:
3050: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');
3051: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3052: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3053: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date Start: '|| to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3054:
3055: ELSE

Line 3052: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);

3048: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled >= :x_scheduled_ship_date_lo ';
3049:
3050: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');
3051: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3052: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3053: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date Start: '|| to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3054:
3055: ELSE
3056: l_scheduled_ship_date_hi := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_hi);

Line 3058: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');

3054:
3055: ELSE
3056: l_scheduled_ship_date_hi := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_hi);
3057: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled <= :x_scheduled_ship_date_hi ';
3058: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
3059: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3060: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3061: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date End: '|| to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3062: END IF;

Line 3059: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));

3055: ELSE
3056: l_scheduled_ship_date_hi := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_hi);
3057: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled <= :x_scheduled_ship_date_hi ';
3058: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
3059: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3060: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3061: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date End: '|| to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3062: END IF;
3063: END IF;

Line 3060: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);

3056: l_scheduled_ship_date_hi := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_hi);
3057: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled <= :x_scheduled_ship_date_hi ';
3058: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
3059: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3060: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3061: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date End: '|| to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3062: END IF;
3063: END IF;
3064:

Line 3074: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_TO');

3070: p_location_id => p_select_criteria.ship_to_loc_id,
3071: p_format => 'NEW UI CODE'),
3072: 1, 80);
3073:
3074: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_TO');
3075: FND_MESSAGE.SET_TOKEN('SHIP_TO', l_msg_string);
3076:
3077: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3078:

Line 3075: FND_MESSAGE.SET_TOKEN('SHIP_TO', l_msg_string);

3071: p_format => 'NEW UI CODE'),
3072: 1, 80);
3073:
3074: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_TO');
3075: FND_MESSAGE.SET_TOKEN('SHIP_TO', l_msg_string);
3076:
3077: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3078:
3079: WSH_UTIL_CORE.PrintMsg(' Ship to Location ID: '|| to_char(p_select_criteria.ship_to_loc_id));

Line 3077: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3073:
3074: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_TO');
3075: FND_MESSAGE.SET_TOKEN('SHIP_TO', l_msg_string);
3076:
3077: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3078:
3079: WSH_UTIL_CORE.PrintMsg(' Ship to Location ID: '|| to_char(p_select_criteria.ship_to_loc_id));
3080: END IF;
3081:

Line 3090: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SOURCE_SYSTEM');

3086: l_sc_WHERE := l_sc_WHERE ||'AND wdd.source_code not in (''PO'', ''WSH'') ';
3087: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3088: p_lookup_code => p_select_criteria.source_code,
3089: p_lookup_type => 'WSH_PD_SOURCE_SYSTEM' );
3090: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SOURCE_SYSTEM');
3091: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', l_msg_string);
3092: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3093: WSH_UTIL_CORE.PrintMsg(' Source System: '|| p_select_criteria.source_code);
3094: ELSE

Line 3091: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', l_msg_string);

3087: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3088: p_lookup_code => p_select_criteria.source_code,
3089: p_lookup_type => 'WSH_PD_SOURCE_SYSTEM' );
3090: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SOURCE_SYSTEM');
3091: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', l_msg_string);
3092: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3093: WSH_UTIL_CORE.PrintMsg(' Source System: '|| p_select_criteria.source_code);
3094: ELSE
3095: l_sc_WHERE := l_sc_WHERE ||'AND wdd.source_code = :x_source_code ';

Line 3092: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3088: p_lookup_code => p_select_criteria.source_code,
3089: p_lookup_type => 'WSH_PD_SOURCE_SYSTEM' );
3090: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SOURCE_SYSTEM');
3091: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', l_msg_string);
3092: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3093: WSH_UTIL_CORE.PrintMsg(' Source System: '|| p_select_criteria.source_code);
3094: ELSE
3095: l_sc_WHERE := l_sc_WHERE ||'AND wdd.source_code = :x_source_code ';
3096: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(

Line 3099: FND_MESSAGE.SET_NAME('WSH', 'SOURCE_SYSTEM');

3095: l_sc_WHERE := l_sc_WHERE ||'AND wdd.source_code = :x_source_code ';
3096: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3097: p_lookup_code => p_select_criteria.source_code,
3098: p_lookup_type => 'SOURCE_SYSTEM' );
3099: FND_MESSAGE.SET_NAME('WSH', 'SOURCE_SYSTEM');
3100: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', l_msg_string);
3101: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3102: WSH_UTIL_CORE.PrintMsg(' Source System: '|| p_select_criteria.source_code);
3103: END IF;

Line 3100: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', l_msg_string);

3096: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3097: p_lookup_code => p_select_criteria.source_code,
3098: p_lookup_type => 'SOURCE_SYSTEM' );
3099: FND_MESSAGE.SET_NAME('WSH', 'SOURCE_SYSTEM');
3100: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', l_msg_string);
3101: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3102: WSH_UTIL_CORE.PrintMsg(' Source System: '|| p_select_criteria.source_code);
3103: END IF;
3104:

Line 3101: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3097: p_lookup_code => p_select_criteria.source_code,
3098: p_lookup_type => 'SOURCE_SYSTEM' );
3099: FND_MESSAGE.SET_NAME('WSH', 'SOURCE_SYSTEM');
3100: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', l_msg_string);
3101: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3102: WSH_UTIL_CORE.PrintMsg(' Source System: '|| p_select_criteria.source_code);
3103: END IF;
3104:
3105: l_msg_string := NULL;

Line 3129: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_CUSTOMER');

3125: OPEN get_customer_name(p_select_criteria.customer_id);
3126: FETCH get_customer_name INTO l_msg_string;
3127: CLOSE get_customer_name;
3128:
3129: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_CUSTOMER');
3130: FND_MESSAGE.SET_TOKEN('CUSTOMER_NAME', l_msg_string);
3131: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3132:
3133: WSH_UTIL_CORE.PrintMsg(' Customer ID: '|| SubStr(p_select_criteria.customer_id,3)); --RTV changes

Line 3130: FND_MESSAGE.SET_TOKEN('CUSTOMER_NAME', l_msg_string);

3126: FETCH get_customer_name INTO l_msg_string;
3127: CLOSE get_customer_name;
3128:
3129: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_CUSTOMER');
3130: FND_MESSAGE.SET_TOKEN('CUSTOMER_NAME', l_msg_string);
3131: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3132:
3133: WSH_UTIL_CORE.PrintMsg(' Customer ID: '|| SubStr(p_select_criteria.customer_id,3)); --RTV changes
3134: END IF;

Line 3131: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3127: CLOSE get_customer_name;
3128:
3129: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_CUSTOMER');
3130: FND_MESSAGE.SET_TOKEN('CUSTOMER_NAME', l_msg_string);
3131: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3132:
3133: WSH_UTIL_CORE.PrintMsg(' Customer ID: '|| SubStr(p_select_criteria.customer_id,3)); --RTV changes
3134: END IF;
3135:

Line 3139: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_METHOD');

3135:
3136: -- put ship method code in the where clause if it is part of selection criteria
3137: IF p_select_criteria.ship_method_code IS NOT NULL THEN
3138: l_sc_WHERE := l_sc_WHERE || 'AND wdd.ship_method_code = :x_ship_method_code ';
3139: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_METHOD');
3140: l_msg_string := NULL;
3141: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3142: p_lookup_code => p_select_criteria.ship_method_code,
3143: p_lookup_type => 'SHIP_METHOD' );

Line 3144: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_msg_string);

3140: l_msg_string := NULL;
3141: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3142: p_lookup_code => p_select_criteria.ship_method_code,
3143: p_lookup_type => 'SHIP_METHOD' );
3144: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_msg_string);
3145: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3146: WSH_UTIL_CORE.PrintMsg(' Ship Method Code: '|| p_select_criteria.ship_method_code);
3147: END IF;
3148:

Line 3145: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3141: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3142: p_lookup_code => p_select_criteria.ship_method_code,
3143: p_lookup_type => 'SHIP_METHOD' );
3144: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_msg_string);
3145: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3146: WSH_UTIL_CORE.PrintMsg(' Ship Method Code: '|| p_select_criteria.ship_method_code);
3147: END IF;
3148:
3149: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');

Line 3149: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');

3145: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3146: WSH_UTIL_CORE.PrintMsg(' Ship Method Code: '|| p_select_criteria.ship_method_code);
3147: END IF;
3148:
3149: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');
3150: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(p_select_criteria.log_level));
3151: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3152: WSH_UTIL_CORE.PrintMsg(' Log Level: '|| p_select_criteria.log_level);
3153: --

Line 3150: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(p_select_criteria.log_level));

3146: WSH_UTIL_CORE.PrintMsg(' Ship Method Code: '|| p_select_criteria.ship_method_code);
3147: END IF;
3148:
3149: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');
3150: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(p_select_criteria.log_level));
3151: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3152: WSH_UTIL_CORE.PrintMsg(' Log Level: '|| p_select_criteria.log_level);
3153: --
3154: -- LSP PROJECT : put client id in the where clause if it is part of selection criteria

Line 3151: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3147: END IF;
3148:
3149: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');
3150: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(p_select_criteria.log_level));
3151: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3152: WSH_UTIL_CORE.PrintMsg(' Log Level: '|| p_select_criteria.log_level);
3153: --
3154: -- LSP PROJECT : put client id in the where clause if it is part of selection criteria
3155: IF p_select_criteria.client_id IS NOT NULL THEN

Line 3170: FND_MESSAGE.SET_NAME('WSH', 'WSH_CLIENT');

3166: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occured in WMS_DEPLOY.GET_CLIENT_DETAILS');
3167: RETURN;
3168: END IF;
3169: END IF;
3170: FND_MESSAGE.SET_NAME('WSH', 'WSH_CLIENT');
3171: FND_MESSAGE.SET_TOKEN('CLIENT_NAME', l_msg_string);
3172: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3173: WSH_UTIL_CORE.PrintMsg(' Client ID: '|| p_select_criteria.client_id);
3174: END IF;

Line 3171: FND_MESSAGE.SET_TOKEN('CLIENT_NAME', l_msg_string);

3167: RETURN;
3168: END IF;
3169: END IF;
3170: FND_MESSAGE.SET_NAME('WSH', 'WSH_CLIENT');
3171: FND_MESSAGE.SET_TOKEN('CLIENT_NAME', l_msg_string);
3172: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3173: WSH_UTIL_CORE.PrintMsg(' Client ID: '|| p_select_criteria.client_id);
3174: END IF;
3175: -- LSP PROJECT : end

Line 3172: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3168: END IF;
3169: END IF;
3170: FND_MESSAGE.SET_NAME('WSH', 'WSH_CLIENT');
3171: FND_MESSAGE.SET_TOKEN('CLIENT_NAME', l_msg_string);
3172: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3173: WSH_UTIL_CORE.PrintMsg(' Client ID: '|| p_select_criteria.client_id);
3174: END IF;
3175: -- LSP PROJECT : end
3176: --

Line 3761: FND_MESSAGE.SET_NAME('WSH','WSH_PD_PARM');

3757: -- set the log level for the whole session
3758: WSH_UTIL_CORE.Set_Log_Level(l_log_level);
3759:
3760:
3761: FND_MESSAGE.SET_NAME('WSH','WSH_PD_PARM');
3762: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3763: FND_FILE.put_line(FND_FILE.output,'====================');
3764:
3765: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PROCESSED_ENTITIES');

Line 3762: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3758: WSH_UTIL_CORE.Set_Log_Level(l_log_level);
3759:
3760:
3761: FND_MESSAGE.SET_NAME('WSH','WSH_PD_PARM');
3762: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3763: FND_FILE.put_line(FND_FILE.output,'====================');
3764:
3765: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PROCESSED_ENTITIES');
3766: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(

Line 3765: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PROCESSED_ENTITIES');

3761: FND_MESSAGE.SET_NAME('WSH','WSH_PD_PARM');
3762: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3763: FND_FILE.put_line(FND_FILE.output,'====================');
3764:
3765: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PROCESSED_ENTITIES');
3766: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3767: p_lookup_code => p_entity_type,
3768: p_lookup_type => 'WSH_PD_ENTITY' );
3769: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE', l_msg_string);

Line 3769: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE', l_msg_string);

3765: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PROCESSED_ENTITIES');
3766: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3767: p_lookup_code => p_entity_type,
3768: p_lookup_type => 'WSH_PD_ENTITY' );
3769: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE', l_msg_string);
3770: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3771:
3772:
3773: -- print required input parameters

Line 3770: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3766: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3767: p_lookup_code => p_entity_type,
3768: p_lookup_type => 'WSH_PD_ENTITY' );
3769: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE', l_msg_string);
3770: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3771:
3772:
3773: -- print required input parameters
3774: WSH_UTIL_CORE.PrintMsg('Input Parameters: ' );

Line 3783: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_TRIP_CONSOLIDATION');

3779: IF WSH_UTIL_CORE.TP_Is_Installed = 'Y' THEN
3780: FND_FILE.put_line(FND_FILE.output, ' ');
3781: FND_FILE.put_line(FND_FILE.output, ' ');
3782: -- print the summary results of auto create trips action
3783: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_TRIP_CONSOLIDATION');
3784: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3785: WSH_UTIL_CORE.PrintMsg('Trip Consolidation is disabled because Transportation Planning is installed. ');
3786: ELSE
3787: --

Line 3784: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3780: FND_FILE.put_line(FND_FILE.output, ' ');
3781: FND_FILE.put_line(FND_FILE.output, ' ');
3782: -- print the summary results of auto create trips action
3783: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_TRIP_CONSOLIDATION');
3784: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3785: WSH_UTIL_CORE.PrintMsg('Trip Consolidation is disabled because Transportation Planning is installed. ');
3786: ELSE
3787: --
3788: l_pickup_date_lo := fnd_date.canonical_to_date(p_pickup_date_lo);

Line 3796: FND_MESSAGE.SET_NAME('WSH', 'WSH_SCHD_DATE_NOT_ALLOWED');

3792:
3793: -- bug 3319789
3794: IF p_scheduled_ship_date_lo is not NULL OR
3795: p_scheduled_ship_date_hi is not NULL THEN
3796: FND_MESSAGE.SET_NAME('WSH', 'WSH_SCHD_DATE_NOT_ALLOWED');
3797: FND_FILE.put_line(FND_FILE.output,' ');
3798: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3799: WSH_UTIL_CORE.PrintMsg('Scheduled Ship Date parameters are not applicable for entity Deliveries Only. Please do not enter Sheduled Ship Date range when selecting entity Deliveries Only.');
3800: raise Parameters_ERR;

Line 3798: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3794: IF p_scheduled_ship_date_lo is not NULL OR
3795: p_scheduled_ship_date_hi is not NULL THEN
3796: FND_MESSAGE.SET_NAME('WSH', 'WSH_SCHD_DATE_NOT_ALLOWED');
3797: FND_FILE.put_line(FND_FILE.output,' ');
3798: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3799: WSH_UTIL_CORE.PrintMsg('Scheduled Ship Date parameters are not applicable for entity Deliveries Only. Please do not enter Sheduled Ship Date range when selecting entity Deliveries Only.');
3800: raise Parameters_ERR;
3801: END IF;
3802:

Line 3837: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_STATUS');

3833:
3834: -- print Input Parameters
3835:
3836: IF l_deliveries_status IS NOT NULL THEN
3837: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_STATUS');
3838: l_msg_string := NULL;
3839: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3840: p_lookup_code => p_deliveries_status,
3841: p_lookup_type => 'WSH_PD_DEL_STATUS' );

Line 3842: FND_MESSAGE.SET_TOKEN('DELIVERIES_STATUS', l_msg_string);

3838: l_msg_string := NULL;
3839: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3840: p_lookup_code => p_deliveries_status,
3841: p_lookup_type => 'WSH_PD_DEL_STATUS' );
3842: FND_MESSAGE.SET_TOKEN('DELIVERIES_STATUS', l_msg_string);
3843: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3844: WSH_UTIL_CORE.PrintMsg(' Deliveries Status: '|| l_deliveries_status);
3845: END IF;
3846:

Line 3843: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3839: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3840: p_lookup_code => p_deliveries_status,
3841: p_lookup_type => 'WSH_PD_DEL_STATUS' );
3842: FND_MESSAGE.SET_TOKEN('DELIVERIES_STATUS', l_msg_string);
3843: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3844: WSH_UTIL_CORE.PrintMsg(' Deliveries Status: '|| l_deliveries_status);
3845: END IF;
3846:
3847: IF p_pickup_date_lo IS NOT NULL THEN

Line 3848: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_LO');

3844: WSH_UTIL_CORE.PrintMsg(' Deliveries Status: '|| l_deliveries_status);
3845: END IF;
3846:
3847: IF p_pickup_date_lo IS NOT NULL THEN
3848: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_LO');
3849: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3850: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3851: WSH_UTIL_CORE.PrintMsg(' Pick Up Date Start: '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3852: END IF;

Line 3849: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));

3845: END IF;
3846:
3847: IF p_pickup_date_lo IS NOT NULL THEN
3848: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_LO');
3849: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3850: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3851: WSH_UTIL_CORE.PrintMsg(' Pick Up Date Start: '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3852: END IF;
3853:

Line 3850: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3846:
3847: IF p_pickup_date_lo IS NOT NULL THEN
3848: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_LO');
3849: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3850: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3851: WSH_UTIL_CORE.PrintMsg(' Pick Up Date Start: '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3852: END IF;
3853:
3854: IF p_pickup_date_hi IS NOT NULL THEN

Line 3855: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_HI');

3851: WSH_UTIL_CORE.PrintMsg(' Pick Up Date Start: '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3852: END IF;
3853:
3854: IF p_pickup_date_hi IS NOT NULL THEN
3855: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_HI');
3856: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3857: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3858: WSH_UTIL_CORE.PrintMsg(' Pick Up Date End: '|| to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3859: END IF;

Line 3856: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));

3852: END IF;
3853:
3854: IF p_pickup_date_hi IS NOT NULL THEN
3855: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_HI');
3856: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3857: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3858: WSH_UTIL_CORE.PrintMsg(' Pick Up Date End: '|| to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3859: END IF;
3860:

Line 3857: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3853:
3854: IF p_pickup_date_hi IS NOT NULL THEN
3855: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_HI');
3856: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3857: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3858: WSH_UTIL_CORE.PrintMsg(' Pick Up Date End: '|| to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3859: END IF;
3860:
3861: -- bug 3332670

Line 3865: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_RANGE');

3861: -- bug 3332670
3862: IF p_pickup_date_hi is NOT NULL and
3863: p_pickup_date_lo is NOT NULL THEN
3864: IF l_pickup_date_hi < l_pickup_date_lo THEN
3865: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_RANGE');
3866: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3867: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3868: FND_FILE.put_line(FND_FILE.output,' ');
3869: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 3866: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));

3862: IF p_pickup_date_hi is NOT NULL and
3863: p_pickup_date_lo is NOT NULL THEN
3864: IF l_pickup_date_hi < l_pickup_date_lo THEN
3865: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_RANGE');
3866: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3867: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3868: FND_FILE.put_line(FND_FILE.output,' ');
3869: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3870: WSH_UTIL_CORE.PrintMsg('The end date of Pick Up Date range '||to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS')||' should not precede the start date '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));

Line 3867: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));

3863: p_pickup_date_lo is NOT NULL THEN
3864: IF l_pickup_date_hi < l_pickup_date_lo THEN
3865: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_RANGE');
3866: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3867: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3868: FND_FILE.put_line(FND_FILE.output,' ');
3869: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3870: WSH_UTIL_CORE.PrintMsg('The end date of Pick Up Date range '||to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS')||' should not precede the start date '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3871: raise Parameters_ERR;

Line 3869: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3865: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_RANGE');
3866: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3867: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3868: FND_FILE.put_line(FND_FILE.output,' ');
3869: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3870: WSH_UTIL_CORE.PrintMsg('The end date of Pick Up Date range '||to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS')||' should not precede the start date '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3871: raise Parameters_ERR;
3872: END IF;
3873: END IF;

Line 3876: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_LO');

3872: END IF;
3873: END IF;
3874:
3875: IF p_dropoff_date_lo IS NOT NULL THEN
3876: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_LO');
3877: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3878: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3879: WSH_UTIL_CORE.PrintMsg(' Drop Off Date Start: '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3880: END IF;

Line 3877: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));

3873: END IF;
3874:
3875: IF p_dropoff_date_lo IS NOT NULL THEN
3876: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_LO');
3877: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3878: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3879: WSH_UTIL_CORE.PrintMsg(' Drop Off Date Start: '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3880: END IF;
3881:

Line 3878: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3874:
3875: IF p_dropoff_date_lo IS NOT NULL THEN
3876: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_LO');
3877: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3878: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3879: WSH_UTIL_CORE.PrintMsg(' Drop Off Date Start: '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3880: END IF;
3881:
3882: IF p_dropoff_date_hi IS NOT NULL THEN

Line 3883: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_HI');

3879: WSH_UTIL_CORE.PrintMsg(' Drop Off Date Start: '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3880: END IF;
3881:
3882: IF p_dropoff_date_hi IS NOT NULL THEN
3883: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_HI');
3884: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3885: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3886: WSH_UTIL_CORE.PrintMsg(' Drop Off Date End: '|| to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3887: END IF;

Line 3884: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));

3880: END IF;
3881:
3882: IF p_dropoff_date_hi IS NOT NULL THEN
3883: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_HI');
3884: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3885: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3886: WSH_UTIL_CORE.PrintMsg(' Drop Off Date End: '|| to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3887: END IF;
3888:

Line 3885: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3881:
3882: IF p_dropoff_date_hi IS NOT NULL THEN
3883: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_HI');
3884: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3885: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3886: WSH_UTIL_CORE.PrintMsg(' Drop Off Date End: '|| to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3887: END IF;
3888:
3889: -- bug 3332670

Line 3893: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_RANGE');

3889: -- bug 3332670
3890: IF p_dropoff_date_hi is NOT NULL and
3891: p_dropoff_date_lo is NOT NULL THEN
3892: IF l_dropoff_date_hi < l_dropoff_date_lo THEN
3893: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_RANGE');
3894: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3895: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3896: FND_FILE.put_line(FND_FILE.output,' ');
3897: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 3894: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));

3890: IF p_dropoff_date_hi is NOT NULL and
3891: p_dropoff_date_lo is NOT NULL THEN
3892: IF l_dropoff_date_hi < l_dropoff_date_lo THEN
3893: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_RANGE');
3894: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3895: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3896: FND_FILE.put_line(FND_FILE.output,' ');
3897: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3898: WSH_UTIL_CORE.PrintMsg('The end date of Drop Off Date range '||to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS')||' should not precede the start date '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));

Line 3895: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));

3891: p_dropoff_date_lo is NOT NULL THEN
3892: IF l_dropoff_date_hi < l_dropoff_date_lo THEN
3893: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_RANGE');
3894: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3895: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3896: FND_FILE.put_line(FND_FILE.output,' ');
3897: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3898: WSH_UTIL_CORE.PrintMsg('The end date of Drop Off Date range '||to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS')||' should not precede the start date '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3899: raise Parameters_ERR;

Line 3897: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3893: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_RANGE');
3894: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3895: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3896: FND_FILE.put_line(FND_FILE.output,' ');
3897: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3898: WSH_UTIL_CORE.PrintMsg('The end date of Drop Off Date range '||to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS')||' should not precede the start date '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3899: raise Parameters_ERR;
3900: END IF;
3901: END IF;

Line 3919: FND_MESSAGE.SET_NAME('WSH', 'WSH_CLIENT');

3915: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occured in WMS_DEPLOY.GET_CLIENT_DETAILS');
3916: END IF;
3917: END IF;
3918:
3919: FND_MESSAGE.SET_NAME('WSH', 'WSH_CLIENT');
3920: FND_MESSAGE.SET_TOKEN('CLIENT_NAME', l_msg_string);
3921: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3922: WSH_UTIL_CORE.PrintMsg(' Client ID: '|| (p_client_id));
3923: END IF;

Line 3920: FND_MESSAGE.SET_TOKEN('CLIENT_NAME', l_msg_string);

3916: END IF;
3917: END IF;
3918:
3919: FND_MESSAGE.SET_NAME('WSH', 'WSH_CLIENT');
3920: FND_MESSAGE.SET_TOKEN('CLIENT_NAME', l_msg_string);
3921: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3922: WSH_UTIL_CORE.PrintMsg(' Client ID: '|| (p_client_id));
3923: END IF;
3924: /*Modified R12.1.1 LSP PROJECT*/

Line 3921: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3917: END IF;
3918:
3919: FND_MESSAGE.SET_NAME('WSH', 'WSH_CLIENT');
3920: FND_MESSAGE.SET_TOKEN('CLIENT_NAME', l_msg_string);
3921: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3922: WSH_UTIL_CORE.PrintMsg(' Client ID: '|| (p_client_id));
3923: END IF;
3924: /*Modified R12.1.1 LSP PROJECT*/
3925:

Line 3927: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_ORGANIZATION');

3923: END IF;
3924: /*Modified R12.1.1 LSP PROJECT*/
3925:
3926: IF p_organization_id IS NOT NULL THEN
3927: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_ORGANIZATION');
3928: FND_MESSAGE.SET_TOKEN('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(p_organization_id));
3929: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3930: WSH_UTIL_CORE.PrintMsg(' Organization ID: '|| to_char(p_organization_id));
3931: END IF;

Line 3928: FND_MESSAGE.SET_TOKEN('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(p_organization_id));

3924: /*Modified R12.1.1 LSP PROJECT*/
3925:
3926: IF p_organization_id IS NOT NULL THEN
3927: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_ORGANIZATION');
3928: FND_MESSAGE.SET_TOKEN('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(p_organization_id));
3929: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3930: WSH_UTIL_CORE.PrintMsg(' Organization ID: '|| to_char(p_organization_id));
3931: END IF;
3932:

Line 3929: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3925:
3926: IF p_organization_id IS NOT NULL THEN
3927: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_ORGANIZATION');
3928: FND_MESSAGE.SET_TOKEN('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(p_organization_id));
3929: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3930: WSH_UTIL_CORE.PrintMsg(' Organization ID: '|| to_char(p_organization_id));
3931: END IF;
3932:
3933: IF p_customer_id IS NOT NULL THEN

Line 3939: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_CUSTOMER');

3935: OPEN get_customer_name(p_customer_id);
3936: FETCH get_customer_name INTO l_msg_string;
3937: CLOSE get_customer_name;
3938:
3939: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_CUSTOMER');
3940: FND_MESSAGE.SET_TOKEN('CUSTOMER_NAME', l_msg_string);
3941: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3942: --bug fix 3286811
3943: WSH_UTIL_CORE.PrintMsg(' Customer ID: '||(SubStr(p_customer_id,3))); --RTV changes

Line 3940: FND_MESSAGE.SET_TOKEN('CUSTOMER_NAME', l_msg_string);

3936: FETCH get_customer_name INTO l_msg_string;
3937: CLOSE get_customer_name;
3938:
3939: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_CUSTOMER');
3940: FND_MESSAGE.SET_TOKEN('CUSTOMER_NAME', l_msg_string);
3941: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3942: --bug fix 3286811
3943: WSH_UTIL_CORE.PrintMsg(' Customer ID: '||(SubStr(p_customer_id,3))); --RTV changes
3944: END IF;

Line 3941: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3937: CLOSE get_customer_name;
3938:
3939: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_CUSTOMER');
3940: FND_MESSAGE.SET_TOKEN('CUSTOMER_NAME', l_msg_string);
3941: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3942: --bug fix 3286811
3943: WSH_UTIL_CORE.PrintMsg(' Customer ID: '||(SubStr(p_customer_id,3))); --RTV changes
3944: END IF;
3945:

Line 3952: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_TO');

3948: p_location_id => p_ship_to_loc_id,
3949: p_format => 'NEW UI CODE'),
3950: 1, 80);
3951:
3952: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_TO');
3953: FND_MESSAGE.SET_TOKEN('SHIP_TO', l_msg_string);
3954: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3955: WSH_UTIL_CORE.PrintMsg(' Ship to Location ID: '|| to_char(p_ship_to_loc_id));
3956: END IF;

Line 3953: FND_MESSAGE.SET_TOKEN('SHIP_TO', l_msg_string);

3949: p_format => 'NEW UI CODE'),
3950: 1, 80);
3951:
3952: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_TO');
3953: FND_MESSAGE.SET_TOKEN('SHIP_TO', l_msg_string);
3954: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3955: WSH_UTIL_CORE.PrintMsg(' Ship to Location ID: '|| to_char(p_ship_to_loc_id));
3956: END IF;
3957:

Line 3954: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3950: 1, 80);
3951:
3952: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_TO');
3953: FND_MESSAGE.SET_TOKEN('SHIP_TO', l_msg_string);
3954: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3955: WSH_UTIL_CORE.PrintMsg(' Ship to Location ID: '|| to_char(p_ship_to_loc_id));
3956: END IF;
3957:
3958: IF p_ship_method_code IS NOT NULL THEN

Line 3960: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_METHOD');

3956: END IF;
3957:
3958: IF p_ship_method_code IS NOT NULL THEN
3959:
3960: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_METHOD');
3961: l_msg_string := NULL;
3962: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3963: p_lookup_code => p_ship_method_code,
3964: p_lookup_type => 'SHIP_METHOD' );

Line 3965: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_msg_string);

3961: l_msg_string := NULL;
3962: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3963: p_lookup_code => p_ship_method_code,
3964: p_lookup_type => 'SHIP_METHOD' );
3965: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_msg_string);
3966: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3967: WSH_UTIL_CORE.PrintMsg(' Ship Method Code: '|| p_ship_method_code);
3968: END IF;
3969:

Line 3966: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3962: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3963: p_lookup_code => p_ship_method_code,
3964: p_lookup_type => 'SHIP_METHOD' );
3965: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_msg_string);
3966: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3967: WSH_UTIL_CORE.PrintMsg(' Ship Method Code: '|| p_ship_method_code);
3968: END IF;
3969:
3970: IF l_grp_ship_method IS NOT NULL THEN

Line 3971: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_GRP_SHIP_METHOD');

3967: WSH_UTIL_CORE.PrintMsg(' Ship Method Code: '|| p_ship_method_code);
3968: END IF;
3969:
3970: IF l_grp_ship_method IS NOT NULL THEN
3971: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_GRP_SHIP_METHOD');
3972: l_msg_string := NULL;
3973: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3974: p_lookup_code => l_grp_ship_method,
3975: p_lookup_type => 'YES_NO' );

Line 3976: FND_MESSAGE.SET_TOKEN('GRP_SHIP_METHOD', l_msg_string);

3972: l_msg_string := NULL;
3973: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3974: p_lookup_code => l_grp_ship_method,
3975: p_lookup_type => 'YES_NO' );
3976: FND_MESSAGE.SET_TOKEN('GRP_SHIP_METHOD', l_msg_string);
3977: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3978: WSH_UTIL_CORE.PrintMsg(' Group Deliveries by Ship Method: '|| l_grp_ship_method);
3979: END IF;
3980:

Line 3977: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3973: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3974: p_lookup_code => l_grp_ship_method,
3975: p_lookup_type => 'YES_NO' );
3976: FND_MESSAGE.SET_TOKEN('GRP_SHIP_METHOD', l_msg_string);
3977: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3978: WSH_UTIL_CORE.PrintMsg(' Group Deliveries by Ship Method: '|| l_grp_ship_method);
3979: END IF;
3980:
3981: IF l_grp_ship_from IS NOT NULL THEN

Line 3982: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_GRP_SHIP_FROM');

3978: WSH_UTIL_CORE.PrintMsg(' Group Deliveries by Ship Method: '|| l_grp_ship_method);
3979: END IF;
3980:
3981: IF l_grp_ship_from IS NOT NULL THEN
3982: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_GRP_SHIP_FROM');
3983: l_msg_string := NULL;
3984: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3985: p_lookup_code => l_grp_ship_from,
3986: p_lookup_type => 'YES_NO' );

Line 3987: FND_MESSAGE.SET_TOKEN('GRP_SHIP_FROM', l_msg_string);

3983: l_msg_string := NULL;
3984: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3985: p_lookup_code => l_grp_ship_from,
3986: p_lookup_type => 'YES_NO' );
3987: FND_MESSAGE.SET_TOKEN('GRP_SHIP_FROM', l_msg_string);
3988: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3989: WSH_UTIL_CORE.PrintMsg(' Group Deliveries by Ship from Organization: '|| l_grp_ship_from);
3990: END IF;
3991:

Line 3988: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3984: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3985: p_lookup_code => l_grp_ship_from,
3986: p_lookup_type => 'YES_NO' );
3987: FND_MESSAGE.SET_TOKEN('GRP_SHIP_FROM', l_msg_string);
3988: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3989: WSH_UTIL_CORE.PrintMsg(' Group Deliveries by Ship from Organization: '|| l_grp_ship_from);
3990: END IF;
3991:
3992: IF l_max_del_number IS NOT NULL THEN

Line 3993: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MAX_DEL_NUMBER');

3989: WSH_UTIL_CORE.PrintMsg(' Group Deliveries by Ship from Organization: '|| l_grp_ship_from);
3990: END IF;
3991:
3992: IF l_max_del_number IS NOT NULL THEN
3993: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MAX_DEL_NUMBER');
3994: FND_MESSAGE.SET_TOKEN('MAX_DEL_NUMBER', to_char(l_max_del_number));
3995: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3996: WSH_UTIL_CORE.PrintMsg(' Maximum Number of Deliveries per Trip: '|| to_char(l_max_del_number));
3997: END IF;

Line 3994: FND_MESSAGE.SET_TOKEN('MAX_DEL_NUMBER', to_char(l_max_del_number));

3990: END IF;
3991:
3992: IF l_max_del_number IS NOT NULL THEN
3993: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MAX_DEL_NUMBER');
3994: FND_MESSAGE.SET_TOKEN('MAX_DEL_NUMBER', to_char(l_max_del_number));
3995: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3996: WSH_UTIL_CORE.PrintMsg(' Maximum Number of Deliveries per Trip: '|| to_char(l_max_del_number));
3997: END IF;
3998:

Line 3995: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3991:
3992: IF l_max_del_number IS NOT NULL THEN
3993: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MAX_DEL_NUMBER');
3994: FND_MESSAGE.SET_TOKEN('MAX_DEL_NUMBER', to_char(l_max_del_number));
3995: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3996: WSH_UTIL_CORE.PrintMsg(' Maximum Number of Deliveries per Trip: '|| to_char(l_max_del_number));
3997: END IF;
3998:
3999: IF l_log_level IS NOT NULL THEN

Line 4000: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');

3996: WSH_UTIL_CORE.PrintMsg(' Maximum Number of Deliveries per Trip: '|| to_char(l_max_del_number));
3997: END IF;
3998:
3999: IF l_log_level IS NOT NULL THEN
4000: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');
4001: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(l_log_level));
4002: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4003: WSH_UTIL_CORE.PrintMsg(' Log Level: '|| l_log_level );
4004: END IF;

Line 4001: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(l_log_level));

3997: END IF;
3998:
3999: IF l_log_level IS NOT NULL THEN
4000: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');
4001: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(l_log_level));
4002: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4003: WSH_UTIL_CORE.PrintMsg(' Log Level: '|| l_log_level );
4004: END IF;
4005:

Line 4002: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3998:
3999: IF l_log_level IS NOT NULL THEN
4000: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');
4001: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(l_log_level));
4002: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4003: WSH_UTIL_CORE.PrintMsg(' Log Level: '|| l_log_level );
4004: END IF;
4005:
4006: IF l_debug_on THEN

Line 4033: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');

4029:
4030: -- print the summary results of auto create trips action
4031: FND_FILE.put_line(FND_FILE.output,' ');
4032: FND_FILE.put_line(FND_FILE.output,' ');
4033: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4034: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4035: FND_FILE.put_line(FND_FILE.output,'====================');
4036:
4037: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_SELECTED');

Line 4034: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4030: -- print the summary results of auto create trips action
4031: FND_FILE.put_line(FND_FILE.output,' ');
4032: FND_FILE.put_line(FND_FILE.output,' ');
4033: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4034: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4035: FND_FILE.put_line(FND_FILE.output,'====================');
4036:
4037: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_SELECTED');
4038: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_num));

Line 4037: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_SELECTED');

4033: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4034: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4035: FND_FILE.put_line(FND_FILE.output,'====================');
4036:
4037: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_SELECTED');
4038: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_num));
4039: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4040:
4041: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_GROUPED');

Line 4038: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_num));

4034: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4035: FND_FILE.put_line(FND_FILE.output,'====================');
4036:
4037: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_SELECTED');
4038: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_num));
4039: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4040:
4041: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_GROUPED');
4042: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_grouped_num));

Line 4039: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4035: FND_FILE.put_line(FND_FILE.output,'====================');
4036:
4037: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_SELECTED');
4038: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_num));
4039: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4040:
4041: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_GROUPED');
4042: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_grouped_num));
4043: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 4041: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_GROUPED');

4037: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_SELECTED');
4038: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_num));
4039: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4040:
4041: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_GROUPED');
4042: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_grouped_num));
4043: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4044:
4045: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_TRIPS_CREATED');

Line 4042: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_grouped_num));

4038: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_num));
4039: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4040:
4041: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_GROUPED');
4042: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_grouped_num));
4043: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4044:
4045: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_TRIPS_CREATED');
4046: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRIPS', to_char(l_trip_num));

Line 4043: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4039: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4040:
4041: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_GROUPED');
4042: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_grouped_num));
4043: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4044:
4045: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_TRIPS_CREATED');
4046: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRIPS', to_char(l_trip_num));
4047: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 4045: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_TRIPS_CREATED');

4041: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_GROUPED');
4042: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_grouped_num));
4043: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4044:
4045: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_TRIPS_CREATED');
4046: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRIPS', to_char(l_trip_num));
4047: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4048:
4049: WSH_UTIL_CORE.PrintDateTime;

Line 4046: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRIPS', to_char(l_trip_num));

4042: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_grouped_num));
4043: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4044:
4045: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_TRIPS_CREATED');
4046: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRIPS', to_char(l_trip_num));
4047: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4048:
4049: WSH_UTIL_CORE.PrintDateTime;
4050: WSH_UTIL_CORE.PrintMsg('Summary: ');

Line 4047: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4043: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4044:
4045: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_TRIPS_CREATED');
4046: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRIPS', to_char(l_trip_num));
4047: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4048:
4049: WSH_UTIL_CORE.PrintDateTime;
4050: WSH_UTIL_CORE.PrintMsg('Summary: ');
4051: WSH_UTIL_CORE.PrintMsg(to_char(l_del_num)|| ' deliveries selected for processing');

Line 4062: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_ERROR');

4058: END IF;
4059:
4060: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4061: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
4062: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_ERROR');
4063: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4064: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_WARNING');
4065: END IF;
4066:

Line 4064: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_WARNING');

4060: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4061: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
4062: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_ERROR');
4063: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4064: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_WARNING');
4065: END IF;
4066:
4067: FND_FILE.put_line(FND_FILE.output,' ');
4068: FND_FILE.put_line(FND_FILE.output,' ');

Line 4069: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4065: END IF;
4066:
4067: FND_FILE.put_line(FND_FILE.output,' ');
4068: FND_FILE.put_line(FND_FILE.output,' ');
4069: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4070:
4071: -- print warning or error messages Process_Delivery_Lines_Batch
4072: l_msg_count := FND_MSG_PUB.count_msg;
4073:

Line 4075: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MESSAGE_LIST');

4071: -- print warning or error messages Process_Delivery_Lines_Batch
4072: l_msg_count := FND_MSG_PUB.count_msg;
4073:
4074: IF l_msg_count > 0 THEN
4075: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MESSAGE_LIST');
4076: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4077: FND_FILE.put_line(FND_FILE.output,'====================');
4078: WSH_UTIL_CORE.PrintMsg('List of Messages: ');
4079: WSH_UTIL_CORE.PrintMsg('====================');

Line 4076: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4072: l_msg_count := FND_MSG_PUB.count_msg;
4073:
4074: IF l_msg_count > 0 THEN
4075: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MESSAGE_LIST');
4076: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4077: FND_FILE.put_line(FND_FILE.output,'====================');
4078: WSH_UTIL_CORE.PrintMsg('List of Messages: ');
4079: WSH_UTIL_CORE.PrintMsg('====================');
4080: FOR i in 1..l_msg_count LOOP

Line 4105: FND_MESSAGE.SET_NAME('WSH', 'WSH_PICKUP_DATE_NOT_ALLOWED');

4101:
4102: -- bug 3319789
4103: IF p_pickup_date_lo is not NULL OR
4104: p_pickup_date_hi is not NULL THEN
4105: FND_MESSAGE.SET_NAME('WSH', 'WSH_PICKUP_DATE_NOT_ALLOWED');
4106: FND_FILE.put_line(FND_FILE.output,' ');
4107: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4108: WSH_UTIL_CORE.PrintMsg('Pick Up Date parameters are not applicable for entity Delivery Lines Only. Please do not enter Pick Up Date range when selecting entity Delivery Lines Only.');
4109: raise Parameters_ERR;

Line 4107: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4103: IF p_pickup_date_lo is not NULL OR
4104: p_pickup_date_hi is not NULL THEN
4105: FND_MESSAGE.SET_NAME('WSH', 'WSH_PICKUP_DATE_NOT_ALLOWED');
4106: FND_FILE.put_line(FND_FILE.output,' ');
4107: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4108: WSH_UTIL_CORE.PrintMsg('Pick Up Date parameters are not applicable for entity Delivery Lines Only. Please do not enter Pick Up Date range when selecting entity Delivery Lines Only.');
4109: raise Parameters_ERR;
4110: END IF;
4111:

Line 4115: FND_MESSAGE.SET_NAME('WSH', 'WSH_DROPOFF_DATE_NOT_ALLOWED');

4111:
4112: -- bug 3319789
4113: IF p_dropoff_date_lo is not NULL OR
4114: p_dropoff_date_hi is not NULL THEN
4115: FND_MESSAGE.SET_NAME('WSH', 'WSH_DROPOFF_DATE_NOT_ALLOWED');
4116: FND_FILE.put_line(FND_FILE.output,' ');
4117: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4118: WSH_UTIL_CORE.PrintMsg('Drop Off Date parameters are not applicable for entity Delivery Lines Only. Please do not enter Drop Off Date range when selecting entity Delivery Lines Only.');
4119: raise Parameters_ERR;

Line 4117: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4113: IF p_dropoff_date_lo is not NULL OR
4114: p_dropoff_date_hi is not NULL THEN
4115: FND_MESSAGE.SET_NAME('WSH', 'WSH_DROPOFF_DATE_NOT_ALLOWED');
4116: FND_FILE.put_line(FND_FILE.output,' ');
4117: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4118: WSH_UTIL_CORE.PrintMsg('Drop Off Date parameters are not applicable for entity Delivery Lines Only. Please do not enter Drop Off Date range when selecting entity Delivery Lines Only.');
4119: raise Parameters_ERR;
4120: END IF;
4121:

Line 4135: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCH_SHIP_DATE_RANGE');

4131: p_scheduled_ship_date_hi is not NULL THEN
4132: l_scheduled_date_lo := fnd_date.canonical_to_date(p_scheduled_ship_date_lo);
4133: l_scheduled_date_hi := fnd_date.canonical_to_date(p_scheduled_ship_date_hi);
4134: IF l_scheduled_date_hi < l_scheduled_date_lo THEN
4135: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCH_SHIP_DATE_RANGE');
4136: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_LO', to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
4137: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_HI', to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
4138: FND_FILE.put_line(FND_FILE.output,' ');
4139: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 4136: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_LO', to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));

4132: l_scheduled_date_lo := fnd_date.canonical_to_date(p_scheduled_ship_date_lo);
4133: l_scheduled_date_hi := fnd_date.canonical_to_date(p_scheduled_ship_date_hi);
4134: IF l_scheduled_date_hi < l_scheduled_date_lo THEN
4135: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCH_SHIP_DATE_RANGE');
4136: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_LO', to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
4137: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_HI', to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
4138: FND_FILE.put_line(FND_FILE.output,' ');
4139: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4140: WSH_UTIL_CORE.PrintMsg('The end date of Scheduled Ship Date range '||to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS')||' should not precede the start date '|| to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));

Line 4137: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_HI', to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS'));

4133: l_scheduled_date_hi := fnd_date.canonical_to_date(p_scheduled_ship_date_hi);
4134: IF l_scheduled_date_hi < l_scheduled_date_lo THEN
4135: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCH_SHIP_DATE_RANGE');
4136: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_LO', to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
4137: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_HI', to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
4138: FND_FILE.put_line(FND_FILE.output,' ');
4139: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4140: WSH_UTIL_CORE.PrintMsg('The end date of Scheduled Ship Date range '||to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS')||' should not precede the start date '|| to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
4141: raise Parameters_ERR;

Line 4139: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4135: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCH_SHIP_DATE_RANGE');
4136: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_LO', to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
4137: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_HI', to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
4138: FND_FILE.put_line(FND_FILE.output,' ');
4139: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4140: WSH_UTIL_CORE.PrintMsg('The end date of Scheduled Ship Date range '||to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS')||' should not precede the start date '|| to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
4141: raise Parameters_ERR;
4142: END IF;
4143: END IF;

Line 4226: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_AUTOCREATE_DEL');

4222: l_msg_string := NULL;
4223: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
4224: p_lookup_code => l_autocreate_deliveries,
4225: p_lookup_type => 'YES_NO');
4226: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_AUTOCREATE_DEL');
4227: FND_MESSAGE.SET_TOKEN('AUTOCREATE_DEL', l_msg_string);
4228: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4229: --Bug10353854
4230: IF ((l_ac_del_criteria is NULL OR l_ac_del_criteria = 'SP') and p_organization_id is not null and l_sp_ac_del_criteria is NOT NULL) THEN

Line 4227: FND_MESSAGE.SET_TOKEN('AUTOCREATE_DEL', l_msg_string);

4223: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
4224: p_lookup_code => l_autocreate_deliveries,
4225: p_lookup_type => 'YES_NO');
4226: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_AUTOCREATE_DEL');
4227: FND_MESSAGE.SET_TOKEN('AUTOCREATE_DEL', l_msg_string);
4228: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4229: --Bug10353854
4230: IF ((l_ac_del_criteria is NULL OR l_ac_del_criteria = 'SP') and p_organization_id is not null and l_sp_ac_del_criteria is NOT NULL) THEN
4231: l_ac_del_criteria := l_sp_ac_del_criteria;

Line 4228: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4224: p_lookup_code => l_autocreate_deliveries,
4225: p_lookup_type => 'YES_NO');
4226: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_AUTOCREATE_DEL');
4227: FND_MESSAGE.SET_TOKEN('AUTOCREATE_DEL', l_msg_string);
4228: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4229: --Bug10353854
4230: IF ((l_ac_del_criteria is NULL OR l_ac_del_criteria = 'SP') and p_organization_id is not null and l_sp_ac_del_criteria is NOT NULL) THEN
4231: l_ac_del_criteria := l_sp_ac_del_criteria;
4232: END IF;

Line 4240: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_AC_DEL_CRITERIA');

4236: l_msg_string := NULL;
4237: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
4238: p_lookup_code => l_ac_del_criteria,
4239: p_lookup_type => 'WSH_AC_DEL_CRITERIA');
4240: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_AC_DEL_CRITERIA');
4241: FND_MESSAGE.SET_TOKEN('AC_DEL_CRITERIA', l_msg_string);
4242: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4243: END IF;
4244:

Line 4241: FND_MESSAGE.SET_TOKEN('AC_DEL_CRITERIA', l_msg_string);

4237: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
4238: p_lookup_code => l_ac_del_criteria,
4239: p_lookup_type => 'WSH_AC_DEL_CRITERIA');
4240: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_AC_DEL_CRITERIA');
4241: FND_MESSAGE.SET_TOKEN('AC_DEL_CRITERIA', l_msg_string);
4242: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4243: END IF;
4244:
4245: IF l_append_deliveries is not NULL THEN

Line 4242: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4238: p_lookup_code => l_ac_del_criteria,
4239: p_lookup_type => 'WSH_AC_DEL_CRITERIA');
4240: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_AC_DEL_CRITERIA');
4241: FND_MESSAGE.SET_TOKEN('AC_DEL_CRITERIA', l_msg_string);
4242: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4243: END IF;
4244:
4245: IF l_append_deliveries is not NULL THEN
4246: l_msg_string := NULL;

Line 4250: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_APPEND_DEL');

4246: l_msg_string := NULL;
4247: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
4248: p_lookup_code => l_append_deliveries,
4249: p_lookup_type => 'YES_NO');
4250: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_APPEND_DEL');
4251: FND_MESSAGE.SET_TOKEN('APPEND_DEL', l_msg_string);
4252: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4253: END IF;
4254:

Line 4251: FND_MESSAGE.SET_TOKEN('APPEND_DEL', l_msg_string);

4247: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
4248: p_lookup_code => l_append_deliveries,
4249: p_lookup_type => 'YES_NO');
4250: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_APPEND_DEL');
4251: FND_MESSAGE.SET_TOKEN('APPEND_DEL', l_msg_string);
4252: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4253: END IF;
4254:
4255: -- populate the selection criteria record and call select_delivery_lines

Line 4252: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4248: p_lookup_code => l_append_deliveries,
4249: p_lookup_type => 'YES_NO');
4250: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_APPEND_DEL');
4251: FND_MESSAGE.SET_TOKEN('APPEND_DEL', l_msg_string);
4252: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4253: END IF;
4254:
4255: -- populate the selection criteria record and call select_delivery_lines
4256: Select_Delivery_Lines(

Line 4323: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_DET_ERROR');

4319: x_return_status => l_return_status);
4320:
4321: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4322: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
4323: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_DET_ERROR');
4324: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4325: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_DET_WARNING');
4326: END IF;
4327: FND_FILE.put_line(FND_FILE.output,' ');

Line 4325: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_DET_WARNING');

4321: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4322: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
4323: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_DET_ERROR');
4324: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4325: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_DET_WARNING');
4326: END IF;
4327: FND_FILE.put_line(FND_FILE.output,' ');
4328: FND_FILE.put_line(FND_FILE.output,' ');
4329: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 4329: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4325: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_DET_WARNING');
4326: END IF;
4327: FND_FILE.put_line(FND_FILE.output,' ');
4328: FND_FILE.put_line(FND_FILE.output,' ');
4329: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4330:
4331: -- print warning or error messages Process_Delivery_Lines_Batch
4332: l_msg_count := FND_MSG_PUB.count_msg;
4333:

Line 4335: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MESSAGE_LIST');

4331: -- print warning or error messages Process_Delivery_Lines_Batch
4332: l_msg_count := FND_MSG_PUB.count_msg;
4333:
4334: IF l_msg_count > 0 THEN
4335: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MESSAGE_LIST');
4336: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4337: FND_FILE.put_line(FND_FILE.output,'====================');
4338:
4339: WSH_UTIL_CORE.PrintMsg('====================');

Line 4336: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4332: l_msg_count := FND_MSG_PUB.count_msg;
4333:
4334: IF l_msg_count > 0 THEN
4335: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MESSAGE_LIST');
4336: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4337: FND_FILE.put_line(FND_FILE.output,'====================');
4338:
4339: WSH_UTIL_CORE.PrintMsg('====================');
4340: FOR i in 1..l_msg_count LOOP

Line 4392: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');

4388: -- print results of appending deliveries and autocreate deliveries
4389: -- print the summary results of auto create trips action
4390: FND_FILE.put_line(FND_FILE.output,' ');
4391: FND_FILE.put_line(FND_FILE.output,' ');
4392: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4393: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4394: FND_FILE.put_line(FND_FILE.output,'====================');
4395:
4396: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');

Line 4393: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4389: -- print the summary results of auto create trips action
4390: FND_FILE.put_line(FND_FILE.output,' ');
4391: FND_FILE.put_line(FND_FILE.output,' ');
4392: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4393: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4394: FND_FILE.put_line(FND_FILE.output,'====================');
4395:
4396: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4397: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_selected_det_count));

Line 4396: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');

4392: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4393: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4394: FND_FILE.put_line(FND_FILE.output,'====================');
4395:
4396: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4397: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_selected_det_count));
4398: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4399:
4400: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_APPENDED');

Line 4397: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_selected_det_count));

4393: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4394: FND_FILE.put_line(FND_FILE.output,'====================');
4395:
4396: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4397: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_selected_det_count));
4398: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4399:
4400: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_APPENDED');
4401: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_appended_det_num));

Line 4398: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4394: FND_FILE.put_line(FND_FILE.output,'====================');
4395:
4396: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4397: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_selected_det_count));
4398: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4399:
4400: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_APPENDED');
4401: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_appended_det_num));
4402: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 4400: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_APPENDED');

4396: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4397: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_selected_det_count));
4398: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4399:
4400: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_APPENDED');
4401: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_appended_det_num));
4402: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4403:
4404: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_GROUPED');

Line 4401: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_appended_det_num));

4397: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_selected_det_count));
4398: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4399:
4400: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_APPENDED');
4401: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_appended_det_num));
4402: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4403:
4404: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_GROUPED');
4405: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_autocreate_del_det_num));

Line 4402: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4398: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4399:
4400: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_APPENDED');
4401: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_appended_det_num));
4402: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4403:
4404: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_GROUPED');
4405: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_autocreate_del_det_num));
4406: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 4404: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_GROUPED');

4400: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_APPENDED');
4401: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_appended_det_num));
4402: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4403:
4404: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_GROUPED');
4405: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_autocreate_del_det_num));
4406: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4407:
4408: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_CREATED');

Line 4405: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_autocreate_del_det_num));

4401: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_appended_det_num));
4402: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4403:
4404: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_GROUPED');
4405: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_autocreate_del_det_num));
4406: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4407:
4408: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_CREATED');
4409: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(g_new_del_num));

Line 4406: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4402: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4403:
4404: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_GROUPED');
4405: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_autocreate_del_det_num));
4406: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4407:
4408: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_CREATED');
4409: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(g_new_del_num));
4410: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 4408: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_CREATED');

4404: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_GROUPED');
4405: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_autocreate_del_det_num));
4406: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4407:
4408: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_CREATED');
4409: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(g_new_del_num));
4410: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4411:
4412: WSH_UTIL_CORE.PrintDateTime;

Line 4409: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(g_new_del_num));

4405: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_autocreate_del_det_num));
4406: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4407:
4408: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_CREATED');
4409: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(g_new_del_num));
4410: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4411:
4412: WSH_UTIL_CORE.PrintDateTime;
4413: WSH_UTIL_CORE.PrintMsg('Summary: ');

Line 4410: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4406: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4407:
4408: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_CREATED');
4409: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(g_new_del_num));
4410: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4411:
4412: WSH_UTIL_CORE.PrintDateTime;
4413: WSH_UTIL_CORE.PrintMsg('Summary: ');
4414: WSH_UTIL_CORE.PrintMsg(to_char(g_selected_det_count)|| ' delivery lines selected for processing');

Line 4425: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');

4421: ELSE
4422: -- no delivery lines selected
4423: FND_FILE.put_line(FND_FILE.output,' ');
4424: FND_FILE.put_line(FND_FILE.output,' ');
4425: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4426: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4427: FND_FILE.put_line(FND_FILE.output,'====================');
4428:
4429: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');

Line 4426: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4422: -- no delivery lines selected
4423: FND_FILE.put_line(FND_FILE.output,' ');
4424: FND_FILE.put_line(FND_FILE.output,' ');
4425: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4426: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4427: FND_FILE.put_line(FND_FILE.output,'====================');
4428:
4429: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4430: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(l_selected_det_tbl.count));

Line 4429: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');

4425: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4426: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4427: FND_FILE.put_line(FND_FILE.output,'====================');
4428:
4429: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4430: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(l_selected_det_tbl.count));
4431: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4432:
4433: WSH_UTIL_CORE.PrintDateTime;

Line 4430: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(l_selected_det_tbl.count));

4426: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4427: FND_FILE.put_line(FND_FILE.output,'====================');
4428:
4429: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4430: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(l_selected_det_tbl.count));
4431: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4432:
4433: WSH_UTIL_CORE.PrintDateTime;
4434: WSH_UTIL_CORE.PrintMsg('Summary: ');

Line 4431: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4427: FND_FILE.put_line(FND_FILE.output,'====================');
4428:
4429: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4430: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(l_selected_det_tbl.count));
4431: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4432:
4433: WSH_UTIL_CORE.PrintDateTime;
4434: WSH_UTIL_CORE.PrintMsg('Summary: ');
4435: WSH_UTIL_CORE.PrintMsg(to_char(l_selected_det_tbl.count)|| ' delivery lines selected for processing');