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 825: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');

821: WHEN stop_trip_locked THEN
822: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
823: CLOSE lock_stop_trip ;
824: WSH_UTIL_CORE.PrintMsg('ERROR: Failed to lock stop and trip, stop ID '||to_char(p_stop_id));
825: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');
826: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_stop_id));
827: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
828: IF l_debug_on THEN
829: WSH_DEBUG_SV.log(l_module_name, 'ERROR: Failed to lock stop and trip, stop ID '||to_char(p_stop_id));

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

822: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
823: CLOSE lock_stop_trip ;
824: WSH_UTIL_CORE.PrintMsg('ERROR: Failed to lock stop and trip, stop ID '||to_char(p_stop_id));
825: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');
826: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_stop_id));
827: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
828: IF l_debug_on THEN
829: WSH_DEBUG_SV.log(l_module_name, 'ERROR: Failed to lock stop and trip, stop ID '||to_char(p_stop_id));
830: WSH_DEBUG_SV.POP(l_module_name);

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

833: WHEN others THEN
834: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
835: CLOSE lock_stop_trip;
836: WSH_UTIL_CORE.PrintMsg('ERROR: Failed to lock stop and trip, stop ID '||to_char(p_stop_id));
837: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');
838: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_stop_id));
839: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
840: IF l_debug_on THEN
841: WSH_DEBUG_SV.log(l_module_name, 'ERROR: Failed to lock stop and trip, stop ID '||to_char(p_stop_id));

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

834: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
835: CLOSE lock_stop_trip;
836: WSH_UTIL_CORE.PrintMsg('ERROR: Failed to lock stop and trip, stop ID '||to_char(p_stop_id));
837: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');
838: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_stop_id));
839: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
840: IF l_debug_on THEN
841: WSH_DEBUG_SV.log(l_module_name, 'ERROR: Failed to lock stop and trip, stop ID '||to_char(p_stop_id));
842: WSH_DEBUG_SV.POP(l_module_name);

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

1058:
1059: WHEN delivery_locked THEN
1060: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1061: WSH_UTIL_CORE.PrintMsg('ERROR2: Failed to lock delivery ID '||to_char(p_del_tab(i).delivery_id));
1062: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');
1063: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));
1064: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
1065: log_batch_messages(p_sc_batch_id, NULL ,NULL, p_del_tab(i).initial_pickup_location_id, NULL);
1066: IF l_debug_on THEN

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

1059: WHEN delivery_locked THEN
1060: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1061: WSH_UTIL_CORE.PrintMsg('ERROR2: Failed to lock delivery ID '||to_char(p_del_tab(i).delivery_id));
1062: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');
1063: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));
1064: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
1065: log_batch_messages(p_sc_batch_id, NULL ,NULL, p_del_tab(i).initial_pickup_location_id, NULL);
1066: IF l_debug_on THEN
1067: 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 1075: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');

1071: WHEN OTHERS THEN
1072: /* this will catch the exception when failing to obtain the lock on the delivery */
1073: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1074: WSH_UTIL_CORE.PrintMsg('ERROR3: Failed to lock delivery ID '||to_char(p_del_tab(i).delivery_id));
1075: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');
1076: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));
1077: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
1078: IF l_debug_on THEN
1079: 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 1076: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));

1072: /* this will catch the exception when failing to obtain the lock on the delivery */
1073: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1074: WSH_UTIL_CORE.PrintMsg('ERROR3: Failed to lock delivery ID '||to_char(p_del_tab(i).delivery_id));
1075: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');
1076: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));
1077: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
1078: IF l_debug_on THEN
1079: 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));
1080: WSH_DEBUG_SV.POP('wsh.plsql.' || G_PKG_NAME || '.' || 'Ship_Confirm_A_Delivery');

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

1271: WSH_DEBUG_SV.logmsg(l_module_name,'Failed to close stop '|| l_stops_to_close(i));
1272: END IF;
1273:
1274: IF l_lock_error = 'Y' THEN
1275: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');
1276: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(l_stops_to_close(i)));
1277: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
1278: END IF;
1279: l_closing_stop_failure := l_closing_stop_failure + 1;

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

1272: END IF;
1273:
1274: IF l_lock_error = 'Y' THEN
1275: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');
1276: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(l_stops_to_close(i)));
1277: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
1278: END IF;
1279: l_closing_stop_failure := l_closing_stop_failure + 1;
1280: log_batch_messages(p_sc_batch_id, NULL , l_stops_to_close(i) , l_stop_location_ids(i), NULL);

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

1707:
1708: WHEN delivery_locked THEN
1709: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1710: WSH_UTIL_CORE.PrintMsg('ERROR => Failed to lock delivery '|| to_char(p_del_tab(i).delivery_id));
1711: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');
1712: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));
1713: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
1714: log_batch_messages(p_ap_batch_id, NULL ,NULL, p_del_tab(i).initial_pickup_location_id, 'E');
1715:

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

1708: WHEN delivery_locked THEN
1709: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1710: WSH_UTIL_CORE.PrintMsg('ERROR => Failed to lock delivery '|| to_char(p_del_tab(i).delivery_id));
1711: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');
1712: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));
1713: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
1714: log_batch_messages(p_ap_batch_id, NULL ,NULL, p_del_tab(i).initial_pickup_location_id, 'E');
1715:
1716: IF l_debug_on THEN

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

1720:
1721: WHEN OTHERS THEN
1722: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1723: WSH_UTIL_CORE.PrintMsg('ERROR => Failed to lock delivery '|| to_char(p_del_tab(i).delivery_id));
1724: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');
1725: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));
1726: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
1727:
1728: IF l_debug_on THEN

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

1721: WHEN OTHERS THEN
1722: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1723: WSH_UTIL_CORE.PrintMsg('ERROR => Failed to lock delivery '|| to_char(p_del_tab(i).delivery_id));
1724: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LOCK_FAILED');
1725: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(p_del_tab(i).delivery_id));
1726: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
1727:
1728: IF l_debug_on THEN
1729: WSH_DEBUG_SV.logmsg(l_module_name, 'Failed to lock delivery '|| to_char(p_del_tab(i).delivery_id));

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

1842: EXCEPTION
1843:
1844: WHEN WSH_INVALID_AUTO_PACK_LEVEL THEN
1845: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1846: FND_MESSAGE.SET_NAME('WSH' , 'WSH_INVALID_AUTO_PACK_LEVEL');
1847: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
1848: IF l_debug_on THEN
1849: WSH_DEBUG_SV.pop(l_module_name);
1850: END IF;

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

1850: END IF;
1851:
1852: WHEN WSH_SUBMIT_AP_REPORT_ERR THEN
1853: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1854: FND_MESSAGE.SET_NAME('WSH' , 'WSH_SUBMIT_AP_REPORT_ERR');
1855: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
1856: IF l_debug_on THEN
1857: WSH_DEBUG_SV.pop(l_module_name);
1858: END IF;

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

2778: /* IF p_error_status = 'W' THEN
2779:
2780: IF g_error_message is NULL THEN
2781:
2782: g_error_message := substrb(FND_MESSAGE.Get_String('FND', 'FND_MBOX_WARN_CONSTANT'), 1,500);
2783:
2784: END IF;
2785:
2786: l_error_message := g_error_message;

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

2956: l_sc_WHERE := l_sc_WHERE || ' AND wdd.move_order_line_id IS NOT NULL ';
2957: END IF;
2958: -- End Bug 5624475 and ECO 5676263
2959: --
2960: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_STATUS');
2961: l_msg_string := NULL;
2962: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
2963: p_lookup_code => p_select_criteria.delivery_lines_status,
2964: p_lookup_type => 'WSH_PD_DEL_LINE_STATUS' );

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

2961: l_msg_string := NULL;
2962: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
2963: p_lookup_code => p_select_criteria.delivery_lines_status,
2964: p_lookup_type => 'WSH_PD_DEL_LINE_STATUS' );
2965: FND_MESSAGE.SET_TOKEN('DETAILS_STATUS', l_msg_string);
2966: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
2967:
2968: WSH_UTIL_CORE.PrintMsg(' Delivery Lines Status: '|| p_select_criteria.delivery_lines_status);
2969: END IF;

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

2962: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
2963: p_lookup_code => p_select_criteria.delivery_lines_status,
2964: p_lookup_type => 'WSH_PD_DEL_LINE_STATUS' );
2965: FND_MESSAGE.SET_TOKEN('DETAILS_STATUS', l_msg_string);
2966: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
2967:
2968: WSH_UTIL_CORE.PrintMsg(' Delivery Lines Status: '|| p_select_criteria.delivery_lines_status);
2969: END IF;
2970:

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

2970:
2971: -- put organization in the where clause if it is part of selection criteria
2972: IF p_select_criteria.organization_id IS NOT NULL THEN
2973: l_sc_WHERE := l_sc_WHERE ||'AND wdd.organization_id = :x_organization_id ';
2974: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_ORGANIZATION');
2975: FND_MESSAGE.SET_TOKEN('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(p_select_criteria.organization_id));
2976: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
2977:
2978: WSH_UTIL_CORE.PrintMsg(' Organization ID: '|| p_select_criteria.organization_id);

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

2971: -- put organization in the where clause if it is part of selection criteria
2972: IF p_select_criteria.organization_id IS NOT NULL THEN
2973: l_sc_WHERE := l_sc_WHERE ||'AND wdd.organization_id = :x_organization_id ';
2974: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_ORGANIZATION');
2975: FND_MESSAGE.SET_TOKEN('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(p_select_criteria.organization_id));
2976: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
2977:
2978: WSH_UTIL_CORE.PrintMsg(' Organization ID: '|| p_select_criteria.organization_id);
2979: END IF;

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

2972: IF p_select_criteria.organization_id IS NOT NULL THEN
2973: l_sc_WHERE := l_sc_WHERE ||'AND wdd.organization_id = :x_organization_id ';
2974: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_ORGANIZATION');
2975: FND_MESSAGE.SET_TOKEN('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(p_select_criteria.organization_id));
2976: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
2977:
2978: WSH_UTIL_CORE.PrintMsg(' Organization ID: '|| p_select_criteria.organization_id);
2979: END IF;
2980:

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

2988:
2989: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled BETWEEN :x_scheduled_ship_date_lo AND :x_scheduled_ship_date_hi ';
2990:
2991:
2992: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');
2993: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
2994: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
2995:
2996: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');

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

2989: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled BETWEEN :x_scheduled_ship_date_lo AND :x_scheduled_ship_date_hi ';
2990:
2991:
2992: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');
2993: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
2994: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
2995:
2996: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
2997: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));

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

2990:
2991:
2992: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');
2993: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
2994: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
2995:
2996: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
2997: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
2998: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);

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

2992: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');
2993: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
2994: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
2995:
2996: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
2997: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
2998: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
2999:
3000: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date Start: '|| to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));

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

2993: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
2994: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
2995:
2996: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
2997: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
2998: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
2999:
3000: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date Start: '|| to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3001: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date End: '|| to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));

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

2994: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
2995:
2996: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
2997: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
2998: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
2999:
3000: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date Start: '|| to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3001: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date End: '|| to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3002:

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

3003: ELSIF p_select_criteria.scheduled_ship_date_lo IS NOT NULL THEN
3004: l_scheduled_ship_date_lo := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_lo);
3005: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled >= :x_scheduled_ship_date_lo ';
3006:
3007: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');
3008: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3009: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3010: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date Start: '|| to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3011:

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

3004: l_scheduled_ship_date_lo := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_lo);
3005: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled >= :x_scheduled_ship_date_lo ';
3006:
3007: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');
3008: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3009: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3010: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date Start: '|| to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3011:
3012: ELSE

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

3005: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled >= :x_scheduled_ship_date_lo ';
3006:
3007: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');
3008: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3009: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3010: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date Start: '|| to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3011:
3012: ELSE
3013: l_scheduled_ship_date_hi := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_hi);

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

3011:
3012: ELSE
3013: l_scheduled_ship_date_hi := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_hi);
3014: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled <= :x_scheduled_ship_date_hi ';
3015: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
3016: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3017: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3018: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date End: '|| to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3019: END IF;

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

3012: ELSE
3013: l_scheduled_ship_date_hi := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_hi);
3014: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled <= :x_scheduled_ship_date_hi ';
3015: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
3016: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3017: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3018: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date End: '|| to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3019: END IF;
3020: END IF;

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

3013: l_scheduled_ship_date_hi := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_hi);
3014: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled <= :x_scheduled_ship_date_hi ';
3015: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
3016: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3017: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3018: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date End: '|| to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3019: END IF;
3020: END IF;
3021:

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

3027: p_location_id => p_select_criteria.ship_to_loc_id,
3028: p_format => 'NEW UI CODE'),
3029: 1, 80);
3030:
3031: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_TO');
3032: FND_MESSAGE.SET_TOKEN('SHIP_TO', l_msg_string);
3033:
3034: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3035:

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

3028: p_format => 'NEW UI CODE'),
3029: 1, 80);
3030:
3031: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_TO');
3032: FND_MESSAGE.SET_TOKEN('SHIP_TO', l_msg_string);
3033:
3034: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3035:
3036: WSH_UTIL_CORE.PrintMsg(' Ship to Location ID: '|| to_char(p_select_criteria.ship_to_loc_id));

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

3030:
3031: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_TO');
3032: FND_MESSAGE.SET_TOKEN('SHIP_TO', l_msg_string);
3033:
3034: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3035:
3036: WSH_UTIL_CORE.PrintMsg(' Ship to Location ID: '|| to_char(p_select_criteria.ship_to_loc_id));
3037: END IF;
3038:

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

3047: l_msg_string := NULL;
3048: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3049: p_lookup_code => p_select_criteria.source_code,
3050: p_lookup_type => 'WSH_PD_SOURCE_SYSTEM' );
3051: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SOURCE_SYSTEM');
3052: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', l_msg_string);
3053: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3054: WSH_UTIL_CORE.PrintMsg(' Source System: '|| p_select_criteria.source_code);
3055: ELSE

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

3048: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3049: p_lookup_code => p_select_criteria.source_code,
3050: p_lookup_type => 'WSH_PD_SOURCE_SYSTEM' );
3051: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SOURCE_SYSTEM');
3052: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', l_msg_string);
3053: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3054: WSH_UTIL_CORE.PrintMsg(' Source System: '|| p_select_criteria.source_code);
3055: ELSE
3056: l_sc_WHERE := l_sc_WHERE ||'AND wdd.source_code in (''OE'', ''OKE'') ';

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

3049: p_lookup_code => p_select_criteria.source_code,
3050: p_lookup_type => 'WSH_PD_SOURCE_SYSTEM' );
3051: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SOURCE_SYSTEM');
3052: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', l_msg_string);
3053: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3054: WSH_UTIL_CORE.PrintMsg(' Source System: '|| p_select_criteria.source_code);
3055: ELSE
3056: l_sc_WHERE := l_sc_WHERE ||'AND wdd.source_code in (''OE'', ''OKE'') ';
3057: END IF;

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

3066: OPEN get_customer_name(p_select_criteria.customer_id);
3067: FETCH get_customer_name INTO l_msg_string;
3068: CLOSE get_customer_name;
3069:
3070: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_CUSTOMER');
3071: FND_MESSAGE.SET_TOKEN('CUSTOMER_NAME', l_msg_string);
3072: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3073:
3074: WSH_UTIL_CORE.PrintMsg(' Customer ID: '|| p_select_criteria.customer_id);

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

3067: FETCH get_customer_name INTO l_msg_string;
3068: CLOSE get_customer_name;
3069:
3070: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_CUSTOMER');
3071: FND_MESSAGE.SET_TOKEN('CUSTOMER_NAME', l_msg_string);
3072: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3073:
3074: WSH_UTIL_CORE.PrintMsg(' Customer ID: '|| p_select_criteria.customer_id);
3075: END IF;

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

3068: CLOSE get_customer_name;
3069:
3070: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_CUSTOMER');
3071: FND_MESSAGE.SET_TOKEN('CUSTOMER_NAME', l_msg_string);
3072: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3073:
3074: WSH_UTIL_CORE.PrintMsg(' Customer ID: '|| p_select_criteria.customer_id);
3075: END IF;
3076:

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

3076:
3077: -- put ship method code in the where clause if it is part of selection criteria
3078: IF p_select_criteria.ship_method_code IS NOT NULL THEN
3079: l_sc_WHERE := l_sc_WHERE || 'AND wdd.ship_method_code = :x_ship_method_code ';
3080: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_METHOD');
3081: l_msg_string := NULL;
3082: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3083: p_lookup_code => p_select_criteria.ship_method_code,
3084: p_lookup_type => 'SHIP_METHOD' );

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

3081: l_msg_string := NULL;
3082: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3083: p_lookup_code => p_select_criteria.ship_method_code,
3084: p_lookup_type => 'SHIP_METHOD' );
3085: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_msg_string);
3086: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3087: WSH_UTIL_CORE.PrintMsg(' Ship Method Code: '|| p_select_criteria.ship_method_code);
3088: END IF;
3089:

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

3082: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3083: p_lookup_code => p_select_criteria.ship_method_code,
3084: p_lookup_type => 'SHIP_METHOD' );
3085: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_msg_string);
3086: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3087: WSH_UTIL_CORE.PrintMsg(' Ship Method Code: '|| p_select_criteria.ship_method_code);
3088: END IF;
3089:
3090: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');

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

3086: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3087: WSH_UTIL_CORE.PrintMsg(' Ship Method Code: '|| p_select_criteria.ship_method_code);
3088: END IF;
3089:
3090: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');
3091: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(p_select_criteria.log_level));
3092: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3093: WSH_UTIL_CORE.PrintMsg(' Log Level: '|| p_select_criteria.log_level);
3094:

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

3087: WSH_UTIL_CORE.PrintMsg(' Ship Method Code: '|| p_select_criteria.ship_method_code);
3088: END IF;
3089:
3090: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');
3091: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(p_select_criteria.log_level));
3092: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3093: WSH_UTIL_CORE.PrintMsg(' Log Level: '|| p_select_criteria.log_level);
3094:
3095: l_sc_FINAL := 'SELECT ' ||l_sc_SELECT||' FROM '||l_sc_FROM||' WHERE '||l_sc_WHERE ;

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

3088: END IF;
3089:
3090: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');
3091: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(p_select_criteria.log_level));
3092: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3093: WSH_UTIL_CORE.PrintMsg(' Log Level: '|| p_select_criteria.log_level);
3094:
3095: l_sc_FINAL := 'SELECT ' ||l_sc_SELECT||' FROM '||l_sc_FROM||' WHERE '||l_sc_WHERE ;
3096:

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

3644: -- set the log level for the whole session
3645: WSH_UTIL_CORE.Set_Log_Level(l_log_level);
3646:
3647:
3648: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PARM');
3649: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3650: FND_FILE.put_line(FND_FILE.output,'====================');
3651:
3652: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PROCESSED_ENTITIES');

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

3645: WSH_UTIL_CORE.Set_Log_Level(l_log_level);
3646:
3647:
3648: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PARM');
3649: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3650: FND_FILE.put_line(FND_FILE.output,'====================');
3651:
3652: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PROCESSED_ENTITIES');
3653: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(

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

3648: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PARM');
3649: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3650: FND_FILE.put_line(FND_FILE.output,'====================');
3651:
3652: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PROCESSED_ENTITIES');
3653: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3654: p_lookup_code => p_entity_type,
3655: p_lookup_type => 'WSH_PD_ENTITY' );
3656: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE', l_msg_string);

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

3652: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PROCESSED_ENTITIES');
3653: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3654: p_lookup_code => p_entity_type,
3655: p_lookup_type => 'WSH_PD_ENTITY' );
3656: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE', l_msg_string);
3657: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3658:
3659:
3660: -- print required input parameters

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

3653: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3654: p_lookup_code => p_entity_type,
3655: p_lookup_type => 'WSH_PD_ENTITY' );
3656: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE', l_msg_string);
3657: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3658:
3659:
3660: -- print required input parameters
3661: WSH_UTIL_CORE.PrintMsg('Input Parameters: ' );

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

3666: IF WSH_UTIL_CORE.TP_Is_Installed = 'Y' THEN
3667: FND_FILE.put_line(FND_FILE.output, ' ');
3668: FND_FILE.put_line(FND_FILE.output, ' ');
3669: -- print the summary results of auto create trips action
3670: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_TRIP_CONSOLIDATION');
3671: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3672: WSH_UTIL_CORE.PrintMsg('Trip Consolidation is disabled because Transportation Planning is installed. ');
3673: ELSE
3674: --

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

3667: FND_FILE.put_line(FND_FILE.output, ' ');
3668: FND_FILE.put_line(FND_FILE.output, ' ');
3669: -- print the summary results of auto create trips action
3670: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_TRIP_CONSOLIDATION');
3671: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3672: WSH_UTIL_CORE.PrintMsg('Trip Consolidation is disabled because Transportation Planning is installed. ');
3673: ELSE
3674: --
3675: l_pickup_date_lo := fnd_date.canonical_to_date(p_pickup_date_lo);

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

3679:
3680: -- bug 3319789
3681: IF p_scheduled_ship_date_lo is not NULL OR
3682: p_scheduled_ship_date_hi is not NULL THEN
3683: FND_MESSAGE.SET_NAME('WSH', 'WSH_SCHD_DATE_NOT_ALLOWED');
3684: FND_FILE.put_line(FND_FILE.output,' ');
3685: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3686: 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.');
3687: raise Parameters_ERR;

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

3681: IF p_scheduled_ship_date_lo is not NULL OR
3682: p_scheduled_ship_date_hi is not NULL THEN
3683: FND_MESSAGE.SET_NAME('WSH', 'WSH_SCHD_DATE_NOT_ALLOWED');
3684: FND_FILE.put_line(FND_FILE.output,' ');
3685: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3686: 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.');
3687: raise Parameters_ERR;
3688: END IF;
3689:

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

3720:
3721: -- print Input Parameters
3722:
3723: IF l_deliveries_status IS NOT NULL THEN
3724: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_STATUS');
3725: l_msg_string := NULL;
3726: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3727: p_lookup_code => p_deliveries_status,
3728: p_lookup_type => 'WSH_PD_DEL_STATUS' );

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

3725: l_msg_string := NULL;
3726: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3727: p_lookup_code => p_deliveries_status,
3728: p_lookup_type => 'WSH_PD_DEL_STATUS' );
3729: FND_MESSAGE.SET_TOKEN('DELIVERIES_STATUS', l_msg_string);
3730: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3731: WSH_UTIL_CORE.PrintMsg(' Deliveries Status: '|| l_deliveries_status);
3732: END IF;
3733:

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

3726: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3727: p_lookup_code => p_deliveries_status,
3728: p_lookup_type => 'WSH_PD_DEL_STATUS' );
3729: FND_MESSAGE.SET_TOKEN('DELIVERIES_STATUS', l_msg_string);
3730: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3731: WSH_UTIL_CORE.PrintMsg(' Deliveries Status: '|| l_deliveries_status);
3732: END IF;
3733:
3734: IF p_pickup_date_lo IS NOT NULL THEN

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

3731: WSH_UTIL_CORE.PrintMsg(' Deliveries Status: '|| l_deliveries_status);
3732: END IF;
3733:
3734: IF p_pickup_date_lo IS NOT NULL THEN
3735: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_LO');
3736: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3737: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3738: WSH_UTIL_CORE.PrintMsg(' Pick Up Date Start: '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3739: END IF;

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

3732: END IF;
3733:
3734: IF p_pickup_date_lo IS NOT NULL THEN
3735: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_LO');
3736: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3737: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3738: WSH_UTIL_CORE.PrintMsg(' Pick Up Date Start: '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3739: END IF;
3740:

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

3733:
3734: IF p_pickup_date_lo IS NOT NULL THEN
3735: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_LO');
3736: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3737: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3738: WSH_UTIL_CORE.PrintMsg(' Pick Up Date Start: '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3739: END IF;
3740:
3741: IF p_pickup_date_hi IS NOT NULL THEN

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

3738: WSH_UTIL_CORE.PrintMsg(' Pick Up Date Start: '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3739: END IF;
3740:
3741: IF p_pickup_date_hi IS NOT NULL THEN
3742: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_HI');
3743: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3744: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3745: WSH_UTIL_CORE.PrintMsg(' Pick Up Date End: '|| to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3746: END IF;

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

3739: END IF;
3740:
3741: IF p_pickup_date_hi IS NOT NULL THEN
3742: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_HI');
3743: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3744: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3745: WSH_UTIL_CORE.PrintMsg(' Pick Up Date End: '|| to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3746: END IF;
3747:

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

3740:
3741: IF p_pickup_date_hi IS NOT NULL THEN
3742: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_HI');
3743: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3744: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3745: WSH_UTIL_CORE.PrintMsg(' Pick Up Date End: '|| to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3746: END IF;
3747:
3748: -- bug 3332670

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

3748: -- bug 3332670
3749: IF p_pickup_date_hi is NOT NULL and
3750: p_pickup_date_lo is NOT NULL THEN
3751: IF l_pickup_date_hi < l_pickup_date_lo THEN
3752: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_RANGE');
3753: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3754: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3755: FND_FILE.put_line(FND_FILE.output,' ');
3756: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

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

3749: IF p_pickup_date_hi is NOT NULL and
3750: p_pickup_date_lo is NOT NULL THEN
3751: IF l_pickup_date_hi < l_pickup_date_lo THEN
3752: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_RANGE');
3753: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3754: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3755: FND_FILE.put_line(FND_FILE.output,' ');
3756: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3757: 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 3754: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));

3750: p_pickup_date_lo is NOT NULL THEN
3751: IF l_pickup_date_hi < l_pickup_date_lo THEN
3752: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_RANGE');
3753: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3754: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3755: FND_FILE.put_line(FND_FILE.output,' ');
3756: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3757: 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'));
3758: raise Parameters_ERR;

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

3752: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_RANGE');
3753: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3754: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3755: FND_FILE.put_line(FND_FILE.output,' ');
3756: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3757: 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'));
3758: raise Parameters_ERR;
3759: END IF;
3760: END IF;

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

3759: END IF;
3760: END IF;
3761:
3762: IF p_dropoff_date_lo IS NOT NULL THEN
3763: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_LO');
3764: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3765: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3766: WSH_UTIL_CORE.PrintMsg(' Drop Off Date Start: '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3767: END IF;

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

3760: END IF;
3761:
3762: IF p_dropoff_date_lo IS NOT NULL THEN
3763: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_LO');
3764: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3765: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3766: WSH_UTIL_CORE.PrintMsg(' Drop Off Date Start: '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3767: END IF;
3768:

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

3761:
3762: IF p_dropoff_date_lo IS NOT NULL THEN
3763: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_LO');
3764: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3765: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3766: WSH_UTIL_CORE.PrintMsg(' Drop Off Date Start: '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3767: END IF;
3768:
3769: IF p_dropoff_date_hi IS NOT NULL THEN

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

3766: WSH_UTIL_CORE.PrintMsg(' Drop Off Date Start: '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3767: END IF;
3768:
3769: IF p_dropoff_date_hi IS NOT NULL THEN
3770: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_HI');
3771: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3772: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3773: WSH_UTIL_CORE.PrintMsg(' Drop Off Date End: '|| to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3774: END IF;

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

3767: END IF;
3768:
3769: IF p_dropoff_date_hi IS NOT NULL THEN
3770: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_HI');
3771: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3772: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3773: WSH_UTIL_CORE.PrintMsg(' Drop Off Date End: '|| to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3774: END IF;
3775:

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

3768:
3769: IF p_dropoff_date_hi IS NOT NULL THEN
3770: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_HI');
3771: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3772: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3773: WSH_UTIL_CORE.PrintMsg(' Drop Off Date End: '|| to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3774: END IF;
3775:
3776: -- bug 3332670

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

3776: -- bug 3332670
3777: IF p_dropoff_date_hi is NOT NULL and
3778: p_dropoff_date_lo is NOT NULL THEN
3779: IF l_dropoff_date_hi < l_dropoff_date_lo THEN
3780: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_RANGE');
3781: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3782: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3783: FND_FILE.put_line(FND_FILE.output,' ');
3784: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

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

3777: IF p_dropoff_date_hi is NOT NULL and
3778: p_dropoff_date_lo is NOT NULL THEN
3779: IF l_dropoff_date_hi < l_dropoff_date_lo THEN
3780: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_RANGE');
3781: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3782: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3783: FND_FILE.put_line(FND_FILE.output,' ');
3784: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3785: 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 3782: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));

3778: p_dropoff_date_lo is NOT NULL THEN
3779: IF l_dropoff_date_hi < l_dropoff_date_lo THEN
3780: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_RANGE');
3781: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3782: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3783: FND_FILE.put_line(FND_FILE.output,' ');
3784: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3785: 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'));
3786: raise Parameters_ERR;

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

3780: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_RANGE');
3781: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3782: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3783: FND_FILE.put_line(FND_FILE.output,' ');
3784: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3785: 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'));
3786: raise Parameters_ERR;
3787: END IF;
3788: END IF;

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

3787: END IF;
3788: END IF;
3789:
3790: IF p_organization_id IS NOT NULL THEN
3791: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_ORGANIZATION');
3792: FND_MESSAGE.SET_TOKEN('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(p_organization_id));
3793: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3794: WSH_UTIL_CORE.PrintMsg(' Organization ID: '|| to_char(p_organization_id));
3795: END IF;

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

3788: END IF;
3789:
3790: IF p_organization_id IS NOT NULL THEN
3791: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_ORGANIZATION');
3792: FND_MESSAGE.SET_TOKEN('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(p_organization_id));
3793: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3794: WSH_UTIL_CORE.PrintMsg(' Organization ID: '|| to_char(p_organization_id));
3795: END IF;
3796:

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

3789:
3790: IF p_organization_id IS NOT NULL THEN
3791: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_ORGANIZATION');
3792: FND_MESSAGE.SET_TOKEN('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(p_organization_id));
3793: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3794: WSH_UTIL_CORE.PrintMsg(' Organization ID: '|| to_char(p_organization_id));
3795: END IF;
3796:
3797: IF p_customer_id IS NOT NULL THEN

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

3799: OPEN get_customer_name(p_customer_id);
3800: FETCH get_customer_name INTO l_msg_string;
3801: CLOSE get_customer_name;
3802:
3803: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_CUSTOMER');
3804: FND_MESSAGE.SET_TOKEN('CUSTOMER_NAME', l_msg_string);
3805: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3806: --bug fix 3286811
3807: WSH_UTIL_CORE.PrintMsg(' Customer ID: '|| (p_customer_id));

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

3800: FETCH get_customer_name INTO l_msg_string;
3801: CLOSE get_customer_name;
3802:
3803: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_CUSTOMER');
3804: FND_MESSAGE.SET_TOKEN('CUSTOMER_NAME', l_msg_string);
3805: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3806: --bug fix 3286811
3807: WSH_UTIL_CORE.PrintMsg(' Customer ID: '|| (p_customer_id));
3808: END IF;

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

3801: CLOSE get_customer_name;
3802:
3803: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_CUSTOMER');
3804: FND_MESSAGE.SET_TOKEN('CUSTOMER_NAME', l_msg_string);
3805: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3806: --bug fix 3286811
3807: WSH_UTIL_CORE.PrintMsg(' Customer ID: '|| (p_customer_id));
3808: END IF;
3809:

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

3812: p_location_id => p_ship_to_loc_id,
3813: p_format => 'NEW UI CODE'),
3814: 1, 80);
3815:
3816: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_TO');
3817: FND_MESSAGE.SET_TOKEN('SHIP_TO', l_msg_string);
3818: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3819: WSH_UTIL_CORE.PrintMsg(' Ship to Location ID: '|| to_char(p_ship_to_loc_id));
3820: END IF;

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

3813: p_format => 'NEW UI CODE'),
3814: 1, 80);
3815:
3816: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_TO');
3817: FND_MESSAGE.SET_TOKEN('SHIP_TO', l_msg_string);
3818: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3819: WSH_UTIL_CORE.PrintMsg(' Ship to Location ID: '|| to_char(p_ship_to_loc_id));
3820: END IF;
3821:

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

3814: 1, 80);
3815:
3816: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_TO');
3817: FND_MESSAGE.SET_TOKEN('SHIP_TO', l_msg_string);
3818: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3819: WSH_UTIL_CORE.PrintMsg(' Ship to Location ID: '|| to_char(p_ship_to_loc_id));
3820: END IF;
3821:
3822: IF p_ship_method_code IS NOT NULL THEN

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

3820: END IF;
3821:
3822: IF p_ship_method_code IS NOT NULL THEN
3823:
3824: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_METHOD');
3825: l_msg_string := NULL;
3826: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3827: p_lookup_code => p_ship_method_code,
3828: p_lookup_type => 'SHIP_METHOD' );

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

3825: l_msg_string := NULL;
3826: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3827: p_lookup_code => p_ship_method_code,
3828: p_lookup_type => 'SHIP_METHOD' );
3829: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_msg_string);
3830: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3831: WSH_UTIL_CORE.PrintMsg(' Ship Method Code: '|| p_ship_method_code);
3832: END IF;
3833:

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

3826: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3827: p_lookup_code => p_ship_method_code,
3828: p_lookup_type => 'SHIP_METHOD' );
3829: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_msg_string);
3830: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3831: WSH_UTIL_CORE.PrintMsg(' Ship Method Code: '|| p_ship_method_code);
3832: END IF;
3833:
3834: IF l_grp_ship_method IS NOT NULL THEN

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

3831: WSH_UTIL_CORE.PrintMsg(' Ship Method Code: '|| p_ship_method_code);
3832: END IF;
3833:
3834: IF l_grp_ship_method IS NOT NULL THEN
3835: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_GRP_SHIP_METHOD');
3836: l_msg_string := NULL;
3837: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3838: p_lookup_code => l_grp_ship_method,
3839: p_lookup_type => 'YES_NO' );

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

3836: l_msg_string := NULL;
3837: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3838: p_lookup_code => l_grp_ship_method,
3839: p_lookup_type => 'YES_NO' );
3840: FND_MESSAGE.SET_TOKEN('GRP_SHIP_METHOD', l_msg_string);
3841: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3842: WSH_UTIL_CORE.PrintMsg(' Group Deliveries by Ship Method: '|| l_grp_ship_method);
3843: END IF;
3844:

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

3837: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3838: p_lookup_code => l_grp_ship_method,
3839: p_lookup_type => 'YES_NO' );
3840: FND_MESSAGE.SET_TOKEN('GRP_SHIP_METHOD', l_msg_string);
3841: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3842: WSH_UTIL_CORE.PrintMsg(' Group Deliveries by Ship Method: '|| l_grp_ship_method);
3843: END IF;
3844:
3845: IF l_grp_ship_from IS NOT NULL THEN

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

3842: WSH_UTIL_CORE.PrintMsg(' Group Deliveries by Ship Method: '|| l_grp_ship_method);
3843: END IF;
3844:
3845: IF l_grp_ship_from IS NOT NULL THEN
3846: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_GRP_SHIP_FROM');
3847: l_msg_string := NULL;
3848: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3849: p_lookup_code => l_grp_ship_from,
3850: p_lookup_type => 'YES_NO' );

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

3847: l_msg_string := NULL;
3848: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3849: p_lookup_code => l_grp_ship_from,
3850: p_lookup_type => 'YES_NO' );
3851: FND_MESSAGE.SET_TOKEN('GRP_SHIP_FROM', l_msg_string);
3852: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3853: WSH_UTIL_CORE.PrintMsg(' Group Deliveries by Ship from Organization: '|| l_grp_ship_from);
3854: END IF;
3855:

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

3848: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3849: p_lookup_code => l_grp_ship_from,
3850: p_lookup_type => 'YES_NO' );
3851: FND_MESSAGE.SET_TOKEN('GRP_SHIP_FROM', l_msg_string);
3852: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3853: WSH_UTIL_CORE.PrintMsg(' Group Deliveries by Ship from Organization: '|| l_grp_ship_from);
3854: END IF;
3855:
3856: IF l_max_del_number IS NOT NULL THEN

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

3853: WSH_UTIL_CORE.PrintMsg(' Group Deliveries by Ship from Organization: '|| l_grp_ship_from);
3854: END IF;
3855:
3856: IF l_max_del_number IS NOT NULL THEN
3857: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MAX_DEL_NUMBER');
3858: FND_MESSAGE.SET_TOKEN('MAX_DEL_NUMBER', to_char(l_max_del_number));
3859: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3860: WSH_UTIL_CORE.PrintMsg(' Maximum Number of Deliveries per Trip: '|| to_char(l_max_del_number));
3861: END IF;

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

3854: END IF;
3855:
3856: IF l_max_del_number IS NOT NULL THEN
3857: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MAX_DEL_NUMBER');
3858: FND_MESSAGE.SET_TOKEN('MAX_DEL_NUMBER', to_char(l_max_del_number));
3859: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3860: WSH_UTIL_CORE.PrintMsg(' Maximum Number of Deliveries per Trip: '|| to_char(l_max_del_number));
3861: END IF;
3862:

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

3855:
3856: IF l_max_del_number IS NOT NULL THEN
3857: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MAX_DEL_NUMBER');
3858: FND_MESSAGE.SET_TOKEN('MAX_DEL_NUMBER', to_char(l_max_del_number));
3859: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3860: WSH_UTIL_CORE.PrintMsg(' Maximum Number of Deliveries per Trip: '|| to_char(l_max_del_number));
3861: END IF;
3862:
3863: IF l_log_level IS NOT NULL THEN

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

3860: WSH_UTIL_CORE.PrintMsg(' Maximum Number of Deliveries per Trip: '|| to_char(l_max_del_number));
3861: END IF;
3862:
3863: IF l_log_level IS NOT NULL THEN
3864: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');
3865: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(l_log_level));
3866: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3867: WSH_UTIL_CORE.PrintMsg(' Log Level: '|| l_log_level );
3868: END IF;

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

3861: END IF;
3862:
3863: IF l_log_level IS NOT NULL THEN
3864: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');
3865: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(l_log_level));
3866: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3867: WSH_UTIL_CORE.PrintMsg(' Log Level: '|| l_log_level );
3868: END IF;
3869:

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

3862:
3863: IF l_log_level IS NOT NULL THEN
3864: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');
3865: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(l_log_level));
3866: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3867: WSH_UTIL_CORE.PrintMsg(' Log Level: '|| l_log_level );
3868: END IF;
3869:
3870: IF l_debug_on THEN

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

3892:
3893: -- print the summary results of auto create trips action
3894: FND_FILE.put_line(FND_FILE.output,' ');
3895: FND_FILE.put_line(FND_FILE.output,' ');
3896: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
3897: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3898: FND_FILE.put_line(FND_FILE.output,'====================');
3899:
3900: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_SELECTED');

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

3893: -- print the summary results of auto create trips action
3894: FND_FILE.put_line(FND_FILE.output,' ');
3895: FND_FILE.put_line(FND_FILE.output,' ');
3896: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
3897: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3898: FND_FILE.put_line(FND_FILE.output,'====================');
3899:
3900: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_SELECTED');
3901: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_num));

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

3896: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
3897: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3898: FND_FILE.put_line(FND_FILE.output,'====================');
3899:
3900: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_SELECTED');
3901: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_num));
3902: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3903:
3904: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_GROUPED');

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

3897: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3898: FND_FILE.put_line(FND_FILE.output,'====================');
3899:
3900: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_SELECTED');
3901: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_num));
3902: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3903:
3904: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_GROUPED');
3905: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_grouped_num));

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

3898: FND_FILE.put_line(FND_FILE.output,'====================');
3899:
3900: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_SELECTED');
3901: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_num));
3902: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3903:
3904: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_GROUPED');
3905: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_grouped_num));
3906: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

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

3900: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_SELECTED');
3901: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_num));
3902: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3903:
3904: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_GROUPED');
3905: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_grouped_num));
3906: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3907:
3908: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_TRIPS_CREATED');

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

3901: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_num));
3902: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3903:
3904: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_GROUPED');
3905: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_grouped_num));
3906: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3907:
3908: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_TRIPS_CREATED');
3909: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRIPS', to_char(l_trip_num));

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

3902: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3903:
3904: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_GROUPED');
3905: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_grouped_num));
3906: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3907:
3908: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_TRIPS_CREATED');
3909: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRIPS', to_char(l_trip_num));
3910: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

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

3904: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_GROUPED');
3905: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_grouped_num));
3906: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3907:
3908: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_TRIPS_CREATED');
3909: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRIPS', to_char(l_trip_num));
3910: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3911:
3912: WSH_UTIL_CORE.PrintDateTime;

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

3905: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_grouped_num));
3906: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3907:
3908: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_TRIPS_CREATED');
3909: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRIPS', to_char(l_trip_num));
3910: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3911:
3912: WSH_UTIL_CORE.PrintDateTime;
3913: WSH_UTIL_CORE.PrintMsg('Summary: ');

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

3906: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3907:
3908: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_TRIPS_CREATED');
3909: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRIPS', to_char(l_trip_num));
3910: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3911:
3912: WSH_UTIL_CORE.PrintDateTime;
3913: WSH_UTIL_CORE.PrintMsg('Summary: ');
3914: WSH_UTIL_CORE.PrintMsg(to_char(l_del_num)|| ' deliveries selected for processing');

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

3921: END IF;
3922:
3923: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3924: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
3925: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_ERROR');
3926: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3927: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_WARNING');
3928: END IF;
3929:

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

3923: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3924: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
3925: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_ERROR');
3926: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3927: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_WARNING');
3928: END IF;
3929:
3930: FND_FILE.put_line(FND_FILE.output,' ');
3931: FND_FILE.put_line(FND_FILE.output,' ');

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

3928: END IF;
3929:
3930: FND_FILE.put_line(FND_FILE.output,' ');
3931: FND_FILE.put_line(FND_FILE.output,' ');
3932: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3933:
3934: -- print warning or error messages Process_Delivery_Lines_Batch
3935: l_msg_count := FND_MSG_PUB.count_msg;
3936:

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

3934: -- print warning or error messages Process_Delivery_Lines_Batch
3935: l_msg_count := FND_MSG_PUB.count_msg;
3936:
3937: IF l_msg_count > 0 THEN
3938: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MESSAGE_LIST');
3939: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3940: FND_FILE.put_line(FND_FILE.output,'====================');
3941: WSH_UTIL_CORE.PrintMsg('List of Messages: ');
3942: WSH_UTIL_CORE.PrintMsg('====================');

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

3935: l_msg_count := FND_MSG_PUB.count_msg;
3936:
3937: IF l_msg_count > 0 THEN
3938: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MESSAGE_LIST');
3939: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3940: FND_FILE.put_line(FND_FILE.output,'====================');
3941: WSH_UTIL_CORE.PrintMsg('List of Messages: ');
3942: WSH_UTIL_CORE.PrintMsg('====================');
3943: FOR i in 1..l_msg_count LOOP

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

3964:
3965: -- bug 3319789
3966: IF p_pickup_date_lo is not NULL OR
3967: p_pickup_date_hi is not NULL THEN
3968: FND_MESSAGE.SET_NAME('WSH', 'WSH_PICKUP_DATE_NOT_ALLOWED');
3969: FND_FILE.put_line(FND_FILE.output,' ');
3970: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3971: 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.');
3972: raise Parameters_ERR;

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

3966: IF p_pickup_date_lo is not NULL OR
3967: p_pickup_date_hi is not NULL THEN
3968: FND_MESSAGE.SET_NAME('WSH', 'WSH_PICKUP_DATE_NOT_ALLOWED');
3969: FND_FILE.put_line(FND_FILE.output,' ');
3970: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3971: 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.');
3972: raise Parameters_ERR;
3973: END IF;
3974:

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

3974:
3975: -- bug 3319789
3976: IF p_dropoff_date_lo is not NULL OR
3977: p_dropoff_date_hi is not NULL THEN
3978: FND_MESSAGE.SET_NAME('WSH', 'WSH_DROPOFF_DATE_NOT_ALLOWED');
3979: FND_FILE.put_line(FND_FILE.output,' ');
3980: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3981: 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.');
3982: raise Parameters_ERR;

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

3976: IF p_dropoff_date_lo is not NULL OR
3977: p_dropoff_date_hi is not NULL THEN
3978: FND_MESSAGE.SET_NAME('WSH', 'WSH_DROPOFF_DATE_NOT_ALLOWED');
3979: FND_FILE.put_line(FND_FILE.output,' ');
3980: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3981: 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.');
3982: raise Parameters_ERR;
3983: END IF;
3984:

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

3994: p_scheduled_ship_date_hi is not NULL THEN
3995: l_scheduled_date_lo := fnd_date.canonical_to_date(p_scheduled_ship_date_lo);
3996: l_scheduled_date_hi := fnd_date.canonical_to_date(p_scheduled_ship_date_hi);
3997: IF l_scheduled_date_hi < l_scheduled_date_lo THEN
3998: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCH_SHIP_DATE_RANGE');
3999: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_LO', to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
4000: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_HI', to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
4001: FND_FILE.put_line(FND_FILE.output,' ');
4002: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

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

3995: l_scheduled_date_lo := fnd_date.canonical_to_date(p_scheduled_ship_date_lo);
3996: l_scheduled_date_hi := fnd_date.canonical_to_date(p_scheduled_ship_date_hi);
3997: IF l_scheduled_date_hi < l_scheduled_date_lo THEN
3998: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCH_SHIP_DATE_RANGE');
3999: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_LO', to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
4000: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_HI', to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
4001: FND_FILE.put_line(FND_FILE.output,' ');
4002: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4003: 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 4000: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_HI', to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS'));

3996: l_scheduled_date_hi := fnd_date.canonical_to_date(p_scheduled_ship_date_hi);
3997: IF l_scheduled_date_hi < l_scheduled_date_lo THEN
3998: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCH_SHIP_DATE_RANGE');
3999: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_LO', to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
4000: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_HI', to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
4001: FND_FILE.put_line(FND_FILE.output,' ');
4002: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4003: 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'));
4004: raise Parameters_ERR;

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

3998: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCH_SHIP_DATE_RANGE');
3999: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_LO', to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
4000: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_HI', to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
4001: FND_FILE.put_line(FND_FILE.output,' ');
4002: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4003: 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'));
4004: raise Parameters_ERR;
4005: END IF;
4006: END IF;

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

4084: l_msg_string := NULL;
4085: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
4086: p_lookup_code => l_autocreate_deliveries,
4087: p_lookup_type => 'YES_NO');
4088: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_AUTOCREATE_DEL');
4089: FND_MESSAGE.SET_TOKEN('AUTOCREATE_DEL', l_msg_string);
4090: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4091: END IF;
4092:

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

4085: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
4086: p_lookup_code => l_autocreate_deliveries,
4087: p_lookup_type => 'YES_NO');
4088: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_AUTOCREATE_DEL');
4089: FND_MESSAGE.SET_TOKEN('AUTOCREATE_DEL', l_msg_string);
4090: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4091: END IF;
4092:
4093: IF l_ac_del_criteria is not NULL THEN

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

4086: p_lookup_code => l_autocreate_deliveries,
4087: p_lookup_type => 'YES_NO');
4088: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_AUTOCREATE_DEL');
4089: FND_MESSAGE.SET_TOKEN('AUTOCREATE_DEL', l_msg_string);
4090: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4091: END IF;
4092:
4093: IF l_ac_del_criteria is not NULL THEN
4094: l_msg_string := NULL;

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

4094: l_msg_string := NULL;
4095: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
4096: p_lookup_code => l_ac_del_criteria,
4097: p_lookup_type => 'WSH_AC_DEL_CRITERIA');
4098: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_AC_DEL_CRITERIA');
4099: FND_MESSAGE.SET_TOKEN('AC_DEL_CRITERIA', l_msg_string);
4100: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4101: END IF;
4102:

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

4095: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
4096: p_lookup_code => l_ac_del_criteria,
4097: p_lookup_type => 'WSH_AC_DEL_CRITERIA');
4098: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_AC_DEL_CRITERIA');
4099: FND_MESSAGE.SET_TOKEN('AC_DEL_CRITERIA', l_msg_string);
4100: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4101: END IF;
4102:
4103: IF l_append_deliveries is not NULL THEN

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

4096: p_lookup_code => l_ac_del_criteria,
4097: p_lookup_type => 'WSH_AC_DEL_CRITERIA');
4098: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_AC_DEL_CRITERIA');
4099: FND_MESSAGE.SET_TOKEN('AC_DEL_CRITERIA', l_msg_string);
4100: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4101: END IF;
4102:
4103: IF l_append_deliveries is not NULL THEN
4104: l_msg_string := NULL;

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

4104: l_msg_string := NULL;
4105: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
4106: p_lookup_code => l_append_deliveries,
4107: p_lookup_type => 'YES_NO');
4108: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_APPEND_DEL');
4109: FND_MESSAGE.SET_TOKEN('APPEND_DEL', l_msg_string);
4110: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4111: END IF;
4112:

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

4105: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
4106: p_lookup_code => l_append_deliveries,
4107: p_lookup_type => 'YES_NO');
4108: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_APPEND_DEL');
4109: FND_MESSAGE.SET_TOKEN('APPEND_DEL', l_msg_string);
4110: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4111: END IF;
4112:
4113: -- populate the selection criteria record and call select_delivery_lines

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

4106: p_lookup_code => l_append_deliveries,
4107: p_lookup_type => 'YES_NO');
4108: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_APPEND_DEL');
4109: FND_MESSAGE.SET_TOKEN('APPEND_DEL', l_msg_string);
4110: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4111: END IF;
4112:
4113: -- populate the selection criteria record and call select_delivery_lines
4114: Select_Delivery_Lines(

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

4166: x_return_status => l_return_status);
4167:
4168: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4169: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
4170: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_DET_ERROR');
4171: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4172: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_DET_WARNING');
4173: END IF;
4174: FND_FILE.put_line(FND_FILE.output,' ');

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

4168: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4169: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
4170: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_DET_ERROR');
4171: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4172: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_DET_WARNING');
4173: END IF;
4174: FND_FILE.put_line(FND_FILE.output,' ');
4175: FND_FILE.put_line(FND_FILE.output,' ');
4176: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

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

4172: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_DET_WARNING');
4173: END IF;
4174: FND_FILE.put_line(FND_FILE.output,' ');
4175: FND_FILE.put_line(FND_FILE.output,' ');
4176: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4177:
4178: -- print warning or error messages Process_Delivery_Lines_Batch
4179: l_msg_count := FND_MSG_PUB.count_msg;
4180:

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

4178: -- print warning or error messages Process_Delivery_Lines_Batch
4179: l_msg_count := FND_MSG_PUB.count_msg;
4180:
4181: IF l_msg_count > 0 THEN
4182: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MESSAGE_LIST');
4183: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4184: FND_FILE.put_line(FND_FILE.output,'====================');
4185:
4186: WSH_UTIL_CORE.PrintMsg('====================');

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

4179: l_msg_count := FND_MSG_PUB.count_msg;
4180:
4181: IF l_msg_count > 0 THEN
4182: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MESSAGE_LIST');
4183: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4184: FND_FILE.put_line(FND_FILE.output,'====================');
4185:
4186: WSH_UTIL_CORE.PrintMsg('====================');
4187: FOR i in 1..l_msg_count LOOP

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

4235: -- print results of appending deliveries and autocreate deliveries
4236: -- print the summary results of auto create trips action
4237: FND_FILE.put_line(FND_FILE.output,' ');
4238: FND_FILE.put_line(FND_FILE.output,' ');
4239: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4240: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4241: FND_FILE.put_line(FND_FILE.output,'====================');
4242:
4243: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');

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

4236: -- print the summary results of auto create trips action
4237: FND_FILE.put_line(FND_FILE.output,' ');
4238: FND_FILE.put_line(FND_FILE.output,' ');
4239: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4240: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4241: FND_FILE.put_line(FND_FILE.output,'====================');
4242:
4243: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4244: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_selected_det_count));

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

4239: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4240: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4241: FND_FILE.put_line(FND_FILE.output,'====================');
4242:
4243: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4244: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_selected_det_count));
4245: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4246:
4247: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_APPENDED');

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

4240: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4241: FND_FILE.put_line(FND_FILE.output,'====================');
4242:
4243: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4244: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_selected_det_count));
4245: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4246:
4247: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_APPENDED');
4248: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_appended_det_num));

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

4241: FND_FILE.put_line(FND_FILE.output,'====================');
4242:
4243: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4244: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_selected_det_count));
4245: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4246:
4247: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_APPENDED');
4248: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_appended_det_num));
4249: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

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

4243: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4244: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_selected_det_count));
4245: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4246:
4247: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_APPENDED');
4248: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_appended_det_num));
4249: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4250:
4251: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_GROUPED');

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

4244: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_selected_det_count));
4245: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4246:
4247: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_APPENDED');
4248: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_appended_det_num));
4249: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4250:
4251: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_GROUPED');
4252: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_autocreate_del_det_num));

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

4245: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4246:
4247: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_APPENDED');
4248: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_appended_det_num));
4249: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4250:
4251: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_GROUPED');
4252: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_autocreate_del_det_num));
4253: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

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

4247: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_APPENDED');
4248: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_appended_det_num));
4249: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4250:
4251: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_GROUPED');
4252: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_autocreate_del_det_num));
4253: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4254:
4255: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_CREATED');

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

4248: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_appended_det_num));
4249: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4250:
4251: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_GROUPED');
4252: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_autocreate_del_det_num));
4253: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4254:
4255: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_CREATED');
4256: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(g_new_del_num));

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

4249: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4250:
4251: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_GROUPED');
4252: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_autocreate_del_det_num));
4253: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4254:
4255: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_CREATED');
4256: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(g_new_del_num));
4257: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

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

4251: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_GROUPED');
4252: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_autocreate_del_det_num));
4253: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4254:
4255: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_CREATED');
4256: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(g_new_del_num));
4257: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4258:
4259: WSH_UTIL_CORE.PrintDateTime;

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

4252: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_autocreate_del_det_num));
4253: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4254:
4255: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_CREATED');
4256: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(g_new_del_num));
4257: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4258:
4259: WSH_UTIL_CORE.PrintDateTime;
4260: WSH_UTIL_CORE.PrintMsg('Summary: ');

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

4253: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4254:
4255: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_CREATED');
4256: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(g_new_del_num));
4257: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4258:
4259: WSH_UTIL_CORE.PrintDateTime;
4260: WSH_UTIL_CORE.PrintMsg('Summary: ');
4261: WSH_UTIL_CORE.PrintMsg(to_char(g_selected_det_count)|| ' delivery lines selected for processing');

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

4268: ELSE
4269: -- no delivery lines selected
4270: FND_FILE.put_line(FND_FILE.output,' ');
4271: FND_FILE.put_line(FND_FILE.output,' ');
4272: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4273: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4274: FND_FILE.put_line(FND_FILE.output,'====================');
4275:
4276: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');

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

4269: -- no delivery lines selected
4270: FND_FILE.put_line(FND_FILE.output,' ');
4271: FND_FILE.put_line(FND_FILE.output,' ');
4272: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4273: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4274: FND_FILE.put_line(FND_FILE.output,'====================');
4275:
4276: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4277: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(l_selected_det_tbl.count));

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

4272: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4273: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4274: FND_FILE.put_line(FND_FILE.output,'====================');
4275:
4276: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4277: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(l_selected_det_tbl.count));
4278: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4279:
4280: WSH_UTIL_CORE.PrintDateTime;

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

4273: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4274: FND_FILE.put_line(FND_FILE.output,'====================');
4275:
4276: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4277: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(l_selected_det_tbl.count));
4278: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4279:
4280: WSH_UTIL_CORE.PrintDateTime;
4281: WSH_UTIL_CORE.PrintMsg('Summary: ');

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

4274: FND_FILE.put_line(FND_FILE.output,'====================');
4275:
4276: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4277: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(l_selected_det_tbl.count));
4278: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4279:
4280: WSH_UTIL_CORE.PrintDateTime;
4281: WSH_UTIL_CORE.PrintMsg('Summary: ');
4282: WSH_UTIL_CORE.PrintMsg(to_char(l_selected_det_tbl.count)|| ' delivery lines selected for processing');