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_DOCUMENT_SETS dependencies on WSH_DEBUG_SV

Line 65: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

61: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
62: --
63: IF l_debug_on IS NULL
64: THEN
65: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
66: END IF;
67: --
68: IF l_debug_on THEN
69: WSH_DEBUG_SV.push(l_module_name);

Line 69: WSH_DEBUG_SV.push(l_module_name);

65: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
66: END IF;
67: --
68: IF l_debug_on THEN
69: WSH_DEBUG_SV.push(l_module_name);
70: --
71: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
72: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
73: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_IDS.COUNT',P_TRIP_IDS.COUNT);

Line 71: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);

67: --
68: IF l_debug_on THEN
69: WSH_DEBUG_SV.push(l_module_name);
70: --
71: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
72: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
73: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_IDS.COUNT',P_TRIP_IDS.COUNT);
74: WSH_DEBUG_SV.log(l_module_name,'P_STOP_IDS.COUNT',P_STOP_IDS.COUNT);
75: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_IDS.COUNT',P_DELIVERY_IDS.COUNT);

Line 72: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);

68: IF l_debug_on THEN
69: WSH_DEBUG_SV.push(l_module_name);
70: --
71: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
72: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
73: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_IDS.COUNT',P_TRIP_IDS.COUNT);
74: WSH_DEBUG_SV.log(l_module_name,'P_STOP_IDS.COUNT',P_STOP_IDS.COUNT);
75: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_IDS.COUNT',P_DELIVERY_IDS.COUNT);
76:

Line 73: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_IDS.COUNT',P_TRIP_IDS.COUNT);

69: WSH_DEBUG_SV.push(l_module_name);
70: --
71: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
72: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
73: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_IDS.COUNT',P_TRIP_IDS.COUNT);
74: WSH_DEBUG_SV.log(l_module_name,'P_STOP_IDS.COUNT',P_STOP_IDS.COUNT);
75: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_IDS.COUNT',P_DELIVERY_IDS.COUNT);
76:
77: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.COUNT',P_DOCUMENT_PARAM_INFO.COUNT);

Line 74: WSH_DEBUG_SV.log(l_module_name,'P_STOP_IDS.COUNT',P_STOP_IDS.COUNT);

70: --
71: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
72: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
73: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_IDS.COUNT',P_TRIP_IDS.COUNT);
74: WSH_DEBUG_SV.log(l_module_name,'P_STOP_IDS.COUNT',P_STOP_IDS.COUNT);
75: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_IDS.COUNT',P_DELIVERY_IDS.COUNT);
76:
77: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.COUNT',P_DOCUMENT_PARAM_INFO.COUNT);
78: /*

Line 75: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_IDS.COUNT',P_DELIVERY_IDS.COUNT);

71: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
72: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
73: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_IDS.COUNT',P_TRIP_IDS.COUNT);
74: WSH_DEBUG_SV.log(l_module_name,'P_STOP_IDS.COUNT',P_STOP_IDS.COUNT);
75: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_IDS.COUNT',P_DELIVERY_IDS.COUNT);
76:
77: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.COUNT',P_DOCUMENT_PARAM_INFO.COUNT);
78: /*
79: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.report_set_id',P_DOCUMENT_PARAM_INFO.p_report_set_id);

Line 77: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.COUNT',P_DOCUMENT_PARAM_INFO.COUNT);

73: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_IDS.COUNT',P_TRIP_IDS.COUNT);
74: WSH_DEBUG_SV.log(l_module_name,'P_STOP_IDS.COUNT',P_STOP_IDS.COUNT);
75: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_IDS.COUNT',P_DELIVERY_IDS.COUNT);
76:
77: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.COUNT',P_DOCUMENT_PARAM_INFO.COUNT);
78: /*
79: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.report_set_id',P_DOCUMENT_PARAM_INFO.p_report_set_id);
80: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.request_id',P_DOCUMENT_PARAM_INFO.p_request_id);
81: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.customer_id',P_DOCUMENT_PARAM_INFO.p_customer_id);

Line 79: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.report_set_id',P_DOCUMENT_PARAM_INFO.p_report_set_id);

75: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_IDS.COUNT',P_DELIVERY_IDS.COUNT);
76:
77: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.COUNT',P_DOCUMENT_PARAM_INFO.COUNT);
78: /*
79: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.report_set_id',P_DOCUMENT_PARAM_INFO.p_report_set_id);
80: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.request_id',P_DOCUMENT_PARAM_INFO.p_request_id);
81: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.customer_id',P_DOCUMENT_PARAM_INFO.p_customer_id);
82: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_id',P_DOCUMENT_PARAM_INFO.p_item_id);
83: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_cate_set_id',P_DOCUMENT_PARAM_INFO.p_item_cate_set_id);

Line 80: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.request_id',P_DOCUMENT_PARAM_INFO.p_request_id);

76:
77: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.COUNT',P_DOCUMENT_PARAM_INFO.COUNT);
78: /*
79: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.report_set_id',P_DOCUMENT_PARAM_INFO.p_report_set_id);
80: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.request_id',P_DOCUMENT_PARAM_INFO.p_request_id);
81: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.customer_id',P_DOCUMENT_PARAM_INFO.p_customer_id);
82: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_id',P_DOCUMENT_PARAM_INFO.p_item_id);
83: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_cate_set_id',P_DOCUMENT_PARAM_INFO.p_item_cate_set_id);
84: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_category_id',P_DOCUMENT_PARAM_INFO.p_item_category_id);

Line 81: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.customer_id',P_DOCUMENT_PARAM_INFO.p_customer_id);

77: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.COUNT',P_DOCUMENT_PARAM_INFO.COUNT);
78: /*
79: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.report_set_id',P_DOCUMENT_PARAM_INFO.p_report_set_id);
80: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.request_id',P_DOCUMENT_PARAM_INFO.p_request_id);
81: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.customer_id',P_DOCUMENT_PARAM_INFO.p_customer_id);
82: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_id',P_DOCUMENT_PARAM_INFO.p_item_id);
83: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_cate_set_id',P_DOCUMENT_PARAM_INFO.p_item_cate_set_id);
84: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_category_id',P_DOCUMENT_PARAM_INFO.p_item_category_id);
85: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.transaction_type_id',P_DOCUMENT_PARAM_INFO.p_transaction_type_id);

Line 82: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_id',P_DOCUMENT_PARAM_INFO.p_item_id);

78: /*
79: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.report_set_id',P_DOCUMENT_PARAM_INFO.p_report_set_id);
80: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.request_id',P_DOCUMENT_PARAM_INFO.p_request_id);
81: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.customer_id',P_DOCUMENT_PARAM_INFO.p_customer_id);
82: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_id',P_DOCUMENT_PARAM_INFO.p_item_id);
83: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_cate_set_id',P_DOCUMENT_PARAM_INFO.p_item_cate_set_id);
84: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_category_id',P_DOCUMENT_PARAM_INFO.p_item_category_id);
85: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.transaction_type_id',P_DOCUMENT_PARAM_INFO.p_transaction_type_id);
86: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.header_id_low',P_DOCUMENT_PARAM_INFO.p_header_id_high);

Line 83: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_cate_set_id',P_DOCUMENT_PARAM_INFO.p_item_cate_set_id);

79: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.report_set_id',P_DOCUMENT_PARAM_INFO.p_report_set_id);
80: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.request_id',P_DOCUMENT_PARAM_INFO.p_request_id);
81: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.customer_id',P_DOCUMENT_PARAM_INFO.p_customer_id);
82: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_id',P_DOCUMENT_PARAM_INFO.p_item_id);
83: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_cate_set_id',P_DOCUMENT_PARAM_INFO.p_item_cate_set_id);
84: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_category_id',P_DOCUMENT_PARAM_INFO.p_item_category_id);
85: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.transaction_type_id',P_DOCUMENT_PARAM_INFO.p_transaction_type_id);
86: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.header_id_low',P_DOCUMENT_PARAM_INFO.p_header_id_high);
87: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.salesrep_id',P_DOCUMENT_PARAM_INFO.p_salesrep_id);

Line 84: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_category_id',P_DOCUMENT_PARAM_INFO.p_item_category_id);

80: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.request_id',P_DOCUMENT_PARAM_INFO.p_request_id);
81: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.customer_id',P_DOCUMENT_PARAM_INFO.p_customer_id);
82: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_id',P_DOCUMENT_PARAM_INFO.p_item_id);
83: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_cate_set_id',P_DOCUMENT_PARAM_INFO.p_item_cate_set_id);
84: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_category_id',P_DOCUMENT_PARAM_INFO.p_item_category_id);
85: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.transaction_type_id',P_DOCUMENT_PARAM_INFO.p_transaction_type_id);
86: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.header_id_low',P_DOCUMENT_PARAM_INFO.p_header_id_high);
87: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.salesrep_id',P_DOCUMENT_PARAM_INFO.p_salesrep_id);
88: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.user_id',P_DOCUMENT_PARAM_INFO.p_user_id);

Line 85: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.transaction_type_id',P_DOCUMENT_PARAM_INFO.p_transaction_type_id);

81: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.customer_id',P_DOCUMENT_PARAM_INFO.p_customer_id);
82: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_id',P_DOCUMENT_PARAM_INFO.p_item_id);
83: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_cate_set_id',P_DOCUMENT_PARAM_INFO.p_item_cate_set_id);
84: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_category_id',P_DOCUMENT_PARAM_INFO.p_item_category_id);
85: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.transaction_type_id',P_DOCUMENT_PARAM_INFO.p_transaction_type_id);
86: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.header_id_low',P_DOCUMENT_PARAM_INFO.p_header_id_high);
87: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.salesrep_id',P_DOCUMENT_PARAM_INFO.p_salesrep_id);
88: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.user_id',P_DOCUMENT_PARAM_INFO.p_user_id);
89: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.territory_name',P_DOCUMENT_PARAM_INFO.p_territory_name);

Line 86: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.header_id_low',P_DOCUMENT_PARAM_INFO.p_header_id_high);

82: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_id',P_DOCUMENT_PARAM_INFO.p_item_id);
83: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_cate_set_id',P_DOCUMENT_PARAM_INFO.p_item_cate_set_id);
84: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_category_id',P_DOCUMENT_PARAM_INFO.p_item_category_id);
85: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.transaction_type_id',P_DOCUMENT_PARAM_INFO.p_transaction_type_id);
86: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.header_id_low',P_DOCUMENT_PARAM_INFO.p_header_id_high);
87: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.salesrep_id',P_DOCUMENT_PARAM_INFO.p_salesrep_id);
88: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.user_id',P_DOCUMENT_PARAM_INFO.p_user_id);
89: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.territory_name',P_DOCUMENT_PARAM_INFO.p_territory_name);
90: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.organization_id',P_DOCUMENT_PARAM_INFO.p_organization_id);

Line 87: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.salesrep_id',P_DOCUMENT_PARAM_INFO.p_salesrep_id);

83: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_cate_set_id',P_DOCUMENT_PARAM_INFO.p_item_cate_set_id);
84: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_category_id',P_DOCUMENT_PARAM_INFO.p_item_category_id);
85: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.transaction_type_id',P_DOCUMENT_PARAM_INFO.p_transaction_type_id);
86: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.header_id_low',P_DOCUMENT_PARAM_INFO.p_header_id_high);
87: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.salesrep_id',P_DOCUMENT_PARAM_INFO.p_salesrep_id);
88: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.user_id',P_DOCUMENT_PARAM_INFO.p_user_id);
89: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.territory_name',P_DOCUMENT_PARAM_INFO.p_territory_name);
90: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.organization_id',P_DOCUMENT_PARAM_INFO.p_organization_id);
91: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_id',P_DOCUMENT_PARAM_INFO.p_trip_id);

Line 88: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.user_id',P_DOCUMENT_PARAM_INFO.p_user_id);

84: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_category_id',P_DOCUMENT_PARAM_INFO.p_item_category_id);
85: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.transaction_type_id',P_DOCUMENT_PARAM_INFO.p_transaction_type_id);
86: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.header_id_low',P_DOCUMENT_PARAM_INFO.p_header_id_high);
87: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.salesrep_id',P_DOCUMENT_PARAM_INFO.p_salesrep_id);
88: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.user_id',P_DOCUMENT_PARAM_INFO.p_user_id);
89: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.territory_name',P_DOCUMENT_PARAM_INFO.p_territory_name);
90: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.organization_id',P_DOCUMENT_PARAM_INFO.p_organization_id);
91: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_id',P_DOCUMENT_PARAM_INFO.p_trip_id);
92: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.dleg_id',P_DOCUMENT_PARAM_INFO.p_delivery_leg_id);

Line 89: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.territory_name',P_DOCUMENT_PARAM_INFO.p_territory_name);

85: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.transaction_type_id',P_DOCUMENT_PARAM_INFO.p_transaction_type_id);
86: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.header_id_low',P_DOCUMENT_PARAM_INFO.p_header_id_high);
87: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.salesrep_id',P_DOCUMENT_PARAM_INFO.p_salesrep_id);
88: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.user_id',P_DOCUMENT_PARAM_INFO.p_user_id);
89: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.territory_name',P_DOCUMENT_PARAM_INFO.p_territory_name);
90: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.organization_id',P_DOCUMENT_PARAM_INFO.p_organization_id);
91: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_id',P_DOCUMENT_PARAM_INFO.p_trip_id);
92: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.dleg_id',P_DOCUMENT_PARAM_INFO.p_delivery_leg_id);
93: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.bol_num',P_DOCUMENT_PARAM_INFO.p_bill_of_lading_number);

Line 90: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.organization_id',P_DOCUMENT_PARAM_INFO.p_organization_id);

86: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.header_id_low',P_DOCUMENT_PARAM_INFO.p_header_id_high);
87: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.salesrep_id',P_DOCUMENT_PARAM_INFO.p_salesrep_id);
88: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.user_id',P_DOCUMENT_PARAM_INFO.p_user_id);
89: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.territory_name',P_DOCUMENT_PARAM_INFO.p_territory_name);
90: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.organization_id',P_DOCUMENT_PARAM_INFO.p_organization_id);
91: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_id',P_DOCUMENT_PARAM_INFO.p_trip_id);
92: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.dleg_id',P_DOCUMENT_PARAM_INFO.p_delivery_leg_id);
93: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.bol_num',P_DOCUMENT_PARAM_INFO.p_bill_of_lading_number);
94: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_stop_id',P_DOCUMENT_PARAM_INFO.p_trip_stop_id);

Line 91: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_id',P_DOCUMENT_PARAM_INFO.p_trip_id);

87: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.salesrep_id',P_DOCUMENT_PARAM_INFO.p_salesrep_id);
88: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.user_id',P_DOCUMENT_PARAM_INFO.p_user_id);
89: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.territory_name',P_DOCUMENT_PARAM_INFO.p_territory_name);
90: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.organization_id',P_DOCUMENT_PARAM_INFO.p_organization_id);
91: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_id',P_DOCUMENT_PARAM_INFO.p_trip_id);
92: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.dleg_id',P_DOCUMENT_PARAM_INFO.p_delivery_leg_id);
93: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.bol_num',P_DOCUMENT_PARAM_INFO.p_bill_of_lading_number);
94: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_stop_id',P_DOCUMENT_PARAM_INFO.p_trip_stop_id);
95: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.delivery_id',P_DOCUMENT_PARAM_INFO.p_delivery_id);

Line 92: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.dleg_id',P_DOCUMENT_PARAM_INFO.p_delivery_leg_id);

88: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.user_id',P_DOCUMENT_PARAM_INFO.p_user_id);
89: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.territory_name',P_DOCUMENT_PARAM_INFO.p_territory_name);
90: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.organization_id',P_DOCUMENT_PARAM_INFO.p_organization_id);
91: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_id',P_DOCUMENT_PARAM_INFO.p_trip_id);
92: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.dleg_id',P_DOCUMENT_PARAM_INFO.p_delivery_leg_id);
93: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.bol_num',P_DOCUMENT_PARAM_INFO.p_bill_of_lading_number);
94: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_stop_id',P_DOCUMENT_PARAM_INFO.p_trip_stop_id);
95: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.delivery_id',P_DOCUMENT_PARAM_INFO.p_delivery_id);
96: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_order_num_l);

Line 93: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.bol_num',P_DOCUMENT_PARAM_INFO.p_bill_of_lading_number);

89: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.territory_name',P_DOCUMENT_PARAM_INFO.p_territory_name);
90: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.organization_id',P_DOCUMENT_PARAM_INFO.p_organization_id);
91: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_id',P_DOCUMENT_PARAM_INFO.p_trip_id);
92: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.dleg_id',P_DOCUMENT_PARAM_INFO.p_delivery_leg_id);
93: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.bol_num',P_DOCUMENT_PARAM_INFO.p_bill_of_lading_number);
94: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_stop_id',P_DOCUMENT_PARAM_INFO.p_trip_stop_id);
95: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.delivery_id',P_DOCUMENT_PARAM_INFO.p_delivery_id);
96: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_order_num_l);
97: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_order_num_h);

Line 94: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_stop_id',P_DOCUMENT_PARAM_INFO.p_trip_stop_id);

90: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.organization_id',P_DOCUMENT_PARAM_INFO.p_organization_id);
91: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_id',P_DOCUMENT_PARAM_INFO.p_trip_id);
92: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.dleg_id',P_DOCUMENT_PARAM_INFO.p_delivery_leg_id);
93: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.bol_num',P_DOCUMENT_PARAM_INFO.p_bill_of_lading_number);
94: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_stop_id',P_DOCUMENT_PARAM_INFO.p_trip_stop_id);
95: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.delivery_id',P_DOCUMENT_PARAM_INFO.p_delivery_id);
96: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_order_num_l);
97: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_order_num_h);
98: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_move_order_l);

Line 95: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.delivery_id',P_DOCUMENT_PARAM_INFO.p_delivery_id);

91: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_id',P_DOCUMENT_PARAM_INFO.p_trip_id);
92: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.dleg_id',P_DOCUMENT_PARAM_INFO.p_delivery_leg_id);
93: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.bol_num',P_DOCUMENT_PARAM_INFO.p_bill_of_lading_number);
94: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_stop_id',P_DOCUMENT_PARAM_INFO.p_trip_stop_id);
95: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.delivery_id',P_DOCUMENT_PARAM_INFO.p_delivery_id);
96: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_order_num_l);
97: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_order_num_h);
98: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_move_order_l);
99: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_move_order_h);

Line 96: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_order_num_l);

92: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.dleg_id',P_DOCUMENT_PARAM_INFO.p_delivery_leg_id);
93: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.bol_num',P_DOCUMENT_PARAM_INFO.p_bill_of_lading_number);
94: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_stop_id',P_DOCUMENT_PARAM_INFO.p_trip_stop_id);
95: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.delivery_id',P_DOCUMENT_PARAM_INFO.p_delivery_id);
96: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_order_num_l);
97: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_order_num_h);
98: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_move_order_l);
99: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_move_order_h);
100: */

Line 97: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_order_num_h);

93: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.bol_num',P_DOCUMENT_PARAM_INFO.p_bill_of_lading_number);
94: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_stop_id',P_DOCUMENT_PARAM_INFO.p_trip_stop_id);
95: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.delivery_id',P_DOCUMENT_PARAM_INFO.p_delivery_id);
96: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_order_num_l);
97: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_order_num_h);
98: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_move_order_l);
99: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_move_order_h);
100: */
101:

Line 98: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_move_order_l);

94: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_stop_id',P_DOCUMENT_PARAM_INFO.p_trip_stop_id);
95: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.delivery_id',P_DOCUMENT_PARAM_INFO.p_delivery_id);
96: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_order_num_l);
97: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_order_num_h);
98: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_move_order_l);
99: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_move_order_h);
100: */
101:
102: WSH_DEBUG_SV.log(l_module_name,'X_RETURN_STATUS',X_RETURN_STATUS);

Line 99: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_move_order_h);

95: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.delivery_id',P_DOCUMENT_PARAM_INFO.p_delivery_id);
96: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_order_num_l);
97: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_order_num_h);
98: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_move_order_l);
99: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_move_order_h);
100: */
101:
102: WSH_DEBUG_SV.log(l_module_name,'X_RETURN_STATUS',X_RETURN_STATUS);
103: END IF;

Line 102: WSH_DEBUG_SV.log(l_module_name,'X_RETURN_STATUS',X_RETURN_STATUS);

98: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_move_order_l);
99: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_move_order_h);
100: */
101:
102: WSH_DEBUG_SV.log(l_module_name,'X_RETURN_STATUS',X_RETURN_STATUS);
103: END IF;
104: --
105: DECLARE
106: l_shipping_style VARCHAR2(15);

Line 482: WSH_DEBUG_SV.logmsg(l_module_name,'entity_count is ' || entity_count );

478: l_main_conc_request_id := null;
479: end if;
480:
481: IF l_debug_on THEN
482: WSH_DEBUG_SV.logmsg(l_module_name,'entity_count is ' || entity_count );
483: END IF;
484: --
485: if (entity_count > 0) then --{ populate l_doc_set_params with entity information
486:

Line 540: WSH_DEBUG_SV.logmsg(l_module_name,'doc set param counts is ' || l_doc_set_params.COUNT);

536: end loop;
537: end if; --{ finished populating l_doc_set_params with entity information
538:
539: IF l_debug_on THEN
540: WSH_DEBUG_SV.logmsg(l_module_name,'doc set param counts is ' || l_doc_set_params.COUNT);
541: END IF;
542: --
543: FOR i IN 1..l_doc_set_params.COUNT LOOP
544:

Line 553: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

549: --
550: -- Debug Statements
551: --
552: IF l_debug_on THEN
553: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
554: END IF;
555: --
556: entity_name := WSH_TRIPS_PVT.Get_Name(p_trip_ids(i));
557: elsif (p_stop_ids.count <> 0) then

Line 562: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

558: --
559: -- Debug Statements
560: --
561: IF l_debug_on THEN
562: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
563: END IF;
564: --
565: entity_name := WSH_TRIP_STOPS_PVT.Get_Name(p_stop_ids(i));
566:

Line 581: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

577: --
578: -- Debug Statements
579: --
580: IF l_debug_on THEN
581: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
582: END IF;
583: --
584: entity_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_ids(i));
585:

Line 623: WSH_DEBUG_SV.logmsg(l_module_name, 'Report Set Id is :'||l_doc_set_params(i).p_report_set_id );

619: end if ;
620:
621: --
622: IF l_debug_on THEN
623: WSH_DEBUG_SV.logmsg(l_module_name, 'Report Set Id is :'||l_doc_set_params(i).p_report_set_id );
624: WSH_DEBUG_SV.logmsg(l_module_name, 'CONC PROGRAM IS :'||l_concurrent_program_name );
625: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES for current doc :'||L_COPIES );
626: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES from fnd profile :'|| to_number(NVL(FND_PROFILE.VALUE('CONC_COPIES'),'0')) );
627: END IF;

Line 624: WSH_DEBUG_SV.logmsg(l_module_name, 'CONC PROGRAM IS :'||l_concurrent_program_name );

620:
621: --
622: IF l_debug_on THEN
623: WSH_DEBUG_SV.logmsg(l_module_name, 'Report Set Id is :'||l_doc_set_params(i).p_report_set_id );
624: WSH_DEBUG_SV.logmsg(l_module_name, 'CONC PROGRAM IS :'||l_concurrent_program_name );
625: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES for current doc :'||L_COPIES );
626: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES from fnd profile :'|| to_number(NVL(FND_PROFILE.VALUE('CONC_COPIES'),'0')) );
627: END IF;
628:

Line 625: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES for current doc :'||L_COPIES );

621: --
622: IF l_debug_on THEN
623: WSH_DEBUG_SV.logmsg(l_module_name, 'Report Set Id is :'||l_doc_set_params(i).p_report_set_id );
624: WSH_DEBUG_SV.logmsg(l_module_name, 'CONC PROGRAM IS :'||l_concurrent_program_name );
625: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES for current doc :'||L_COPIES );
626: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES from fnd profile :'|| to_number(NVL(FND_PROFILE.VALUE('CONC_COPIES'),'0')) );
627: END IF;
628:
629: -- Debug Statements

Line 626: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES from fnd profile :'|| to_number(NVL(FND_PROFILE.VALUE('CONC_COPIES'),'0')) );

622: IF l_debug_on THEN
623: WSH_DEBUG_SV.logmsg(l_module_name, 'Report Set Id is :'||l_doc_set_params(i).p_report_set_id );
624: WSH_DEBUG_SV.logmsg(l_module_name, 'CONC PROGRAM IS :'||l_concurrent_program_name );
625: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES for current doc :'||L_COPIES );
626: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES from fnd profile :'|| to_number(NVL(FND_PROFILE.VALUE('CONC_COPIES'),'0')) );
627: END IF;
628:
629: -- Debug Statements
630: --

Line 632: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES TO BE PRINTED FOR EACH REPORT '||L_COPIES );

628:
629: -- Debug Statements
630: --
631: IF l_debug_on THEN
632: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES TO BE PRINTED FOR EACH REPORT '||L_COPIES );
633: END IF;
634: --
635:
636: --

Line 640: WSH_DEBUG_SV.logmsg(l_module_name, 'PROCESSING DOCUMENT ' || L_CONCURRENT_PROGRAM_NAME );

636: --
637: -- Debug Statements
638: --
639: IF l_debug_on THEN
640: WSH_DEBUG_SV.logmsg(l_module_name, 'PROCESSING DOCUMENT ' || L_CONCURRENT_PROGRAM_NAME );
641: END IF;
642: --
643:
644: -- Assigning current doc set params to language parameters

Line 678: WSH_DEBUG_SV.logmsg(l_module_name, 'ARGUMENT NAME ' || L_ARG_NAME );

674: --
675: -- Debug Statements
676: --
677: IF l_debug_on THEN
678: WSH_DEBUG_SV.logmsg(l_module_name, 'ARGUMENT NAME ' || L_ARG_NAME );
679: END IF;
680: --
681: --
682: -- Debug Statements

Line 685: WSH_DEBUG_SV.logmsg(l_module_name, 'ARGUMENT VALUE ' || L_ARG_VALUE );

681: --
682: -- Debug Statements
683: --
684: IF l_debug_on THEN
685: WSH_DEBUG_SV.logmsg(l_module_name, 'ARGUMENT VALUE ' || L_ARG_VALUE );
686: END IF;
687: --
688: --
689: -- Debug Statements

Line 692: WSH_DEBUG_SV.logmsg(l_module_name, 'ARGUMENT REQUIRED ' || L_ARG_REQUIRED_FLAG );

688: --
689: -- Debug Statements
690: --
691: IF l_debug_on THEN
692: WSH_DEBUG_SV.logmsg(l_module_name, 'ARGUMENT REQUIRED ' || L_ARG_REQUIRED_FLAG );
693: END IF;
694: --
695:
696: l_argument_name ( l_arg_cnt ) := l_arg_name ;

Line 707: WSH_DEBUG_SV.logmsg(l_module_name, 'ARGUMENT NAME ' || L_ARG_NAME||' VALUE:'||TO_CHAR ( L_ARG_CNT ) ||':'||L_ARGUMENT ( L_ARG_CNT ) );

703: --
704: -- Debug Statements
705: --
706: IF l_debug_on THEN
707: WSH_DEBUG_SV.logmsg(l_module_name, 'ARGUMENT NAME ' || L_ARG_NAME||' VALUE:'||TO_CHAR ( L_ARG_CNT ) ||':'||L_ARGUMENT ( L_ARG_CNT ) );
708: END IF;
709: --
710:
711: IF l_argument(l_arg_cnt) IS NULL THEN

Line 716: WSH_DEBUG_SV.logmsg(l_module_name, 'ARG DEFAULT TYPE ' || L_ARG_DEFAULT_TYPE );

712: --
713: -- Debug Statements
714: --
715: IF l_debug_on THEN
716: WSH_DEBUG_SV.logmsg(l_module_name, 'ARG DEFAULT TYPE ' || L_ARG_DEFAULT_TYPE );
717: END IF;
718: --
719: IF l_arg_default_type = 'C' THEN -- Constant
720: l_argument(l_arg_cnt) := l_arg_default_value;

Line 800: WSH_DEBUG_SV.logmsg(l_module_name, 'L_PARAMETER_NAME:' || L_PARAMETER_NAME );

796: --
797: -- Debug Statements
798: --
799: IF l_debug_on THEN
800: WSH_DEBUG_SV.logmsg(l_module_name, 'L_PARAMETER_NAME:' || L_PARAMETER_NAME );
801: END IF;
802: --
803: IF l_parameter_name NOT IN
804: (

Line 818: WSH_DEBUG_SV.logmsg(l_module_name, ' CHECK ARG NAME ' || L_ARG_NAME||' VALUE:'||TO_CHAR ( L_ARG_CNT ) ||':'||L_ARGUMENT ( L_ARG_CNT ) );

814: --
815: -- Debug Statements
816: --
817: IF l_debug_on THEN
818: WSH_DEBUG_SV.logmsg(l_module_name, ' CHECK ARG NAME ' || L_ARG_NAME||' VALUE:'||TO_CHAR ( L_ARG_CNT ) ||':'||L_ARGUMENT ( L_ARG_CNT ) );
819: END IF;
820: --
821: -- if still null and its required then raise appropriate error
822: IF (l_argument(l_arg_cnt) IS NULL) AND l_arg_required_flag = 'Y' THEN

Line 867: WSH_DEBUG_SV.logmsg(l_module_name, 'L_VALID_PARAMS IS TRUE' );

863: --
864: -- Debug Statements
865: --
866: IF l_debug_on THEN
867: WSH_DEBUG_SV.logmsg(l_module_name, 'L_VALID_PARAMS IS TRUE' );
868: END IF;
869: --
870: else
871: --

Line 875: WSH_DEBUG_SV.logmsg(l_module_name, 'L_VALID_PARAMS IS FALSE' );

871: --
872: -- Debug Statements
873: --
874: IF l_debug_on THEN
875: WSH_DEBUG_SV.logmsg(l_module_name, 'L_VALID_PARAMS IS FALSE' );
876: END IF;
877: --
878: end if;
879:

Line 892: WSH_DEBUG_SV.logmsg(l_module_name, 'L_NON_DEFAULT_PARAMS IS TRUE' );

888: --
889: -- Debug Statements
890: --
891: IF l_debug_on THEN
892: WSH_DEBUG_SV.logmsg(l_module_name, 'L_NON_DEFAULT_PARAMS IS TRUE' );
893: END IF;
894: --
895: else
896: --

Line 900: WSH_DEBUG_SV.logmsg(l_module_name, 'L_NON_DEFAULT_PARAMS IS FALSE' );

896: --
897: -- Debug Statements
898: --
899: IF l_debug_on THEN
900: WSH_DEBUG_SV.logmsg(l_module_name, 'L_NON_DEFAULT_PARAMS IS FALSE' );
901: END IF;
902: --
903: end if;
904: IF NOT(l_non_default_params)

Line 910: WSH_DEBUG_SV.logmsg(l_module_name, 'THE DOCUMENT ' || L_CONCURRENT_PROGRAM_NAME || ' DOES NOT HAVE A PARAM SPECIFIED.' );

906: --
907: -- Debug Statements
908: --
909: IF l_debug_on THEN
910: WSH_DEBUG_SV.logmsg(l_module_name, 'THE DOCUMENT ' || L_CONCURRENT_PROGRAM_NAME || ' DOES NOT HAVE A PARAM SPECIFIED.' );
911: END IF;
912: --
913: l_valid_params := FALSE;
914: x_return_status := wsh_util_core.g_ret_sts_warning;

Line 942: WSH_DEBUG_SV.logmsg(l_module_name, 'THE DOCUMENT ' || L_CONCURRENT_PROGRAM_NAME || ' HAVE A PARAM SPECIFIED.' );

938: --
939: -- Debug Statements
940: --
941: IF l_debug_on THEN --{
942: WSH_DEBUG_SV.logmsg(l_module_name, 'THE DOCUMENT ' || L_CONCURRENT_PROGRAM_NAME || ' HAVE A PARAM SPECIFIED.' );
943: END IF; --}
944: --
945:
946: IF document.print_flag = 'Y' THEN --{

Line 952: WSH_DEBUG_SV.logmsg(l_module_name, 'APPLICATION ID: ' || TO_CHAR ( l_application_id ) || ' RESPONSIBILITY ID: ' || TO_CHAR ( FND_GLOBAL.RESP_ID ) || ' USER ID: ' || TO_CHAR ( FND_GLOBAL.USER_ID ) );

948: --
949: -- Debug Statements
950: --
951: IF l_debug_on THEN --{
952: WSH_DEBUG_SV.logmsg(l_module_name, 'APPLICATION ID: ' || TO_CHAR ( l_application_id ) || ' RESPONSIBILITY ID: ' || TO_CHAR ( FND_GLOBAL.RESP_ID ) || ' USER ID: ' || TO_CHAR ( FND_GLOBAL.USER_ID ) );
953: END IF; --}
954: --
955:
956: if ( l_printer_name IS NULL or l_printer_name = '-1' ) then --{

Line 961: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REPORT_PRINTERS_PVT.GET_PRINTER',WSH_DEBUG_SV.C_PROC_LEVEL);

957: --
958: -- Debug Statements
959: --
960: IF l_debug_on THEN --{
961: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REPORT_PRINTERS_PVT.GET_PRINTER',WSH_DEBUG_SV.C_PROC_LEVEL);
962: END IF; --}
963: --
964: WSH_REPORT_PRINTERS_PVT.Get_Printer(p_concurrent_program_id => document.concurrent_program_id,
965: p_organization_id => l_organization_id , -- Bug 3534965(3510460 Frontport)

Line 981: WSH_DEBUG_SV.logmsg(l_module_name, 'GET_PRINTER: ' || l_error_message);

977:
978:
979: IF l_error_message IS NOT NULL THEN --{
980: IF l_debug_on THEN
981: WSH_DEBUG_SV.logmsg(l_module_name, 'GET_PRINTER: ' || l_error_message);
982: END IF;
983: END IF; --}
984:
985: IF l_printer_name IS NULL OR l_printer_name = 'No Printer' THEN --{

Line 991: WSH_DEBUG_SV.logmsg(l_module_name, 'PRINTER NAME IS NULL AND THE DEFAULT PRINTER IS '||L_PRINTER_NAME );

987: --
988: -- Debug Statements
989: --
990: IF l_debug_on THEN --{
991: WSH_DEBUG_SV.logmsg(l_module_name, 'PRINTER NAME IS NULL AND THE DEFAULT PRINTER IS '||L_PRINTER_NAME );
992: END IF; --}
993: --
994: END IF; --}
995:

Line 1007: WSH_DEBUG_SV.logmsg(l_module_name, DOCUMENT.CONCURRENT_PROGRAM_NAME || ' and no printers setup ' );

1003: END IF ; --} if l_printer_name is null
1004:
1005: IF ( document.CONCURRENT_PROGRAM_NAME <> 'WSHRDPIK' or WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.count = 0 ) then --{
1006: IF l_debug_on THEN --{
1007: WSH_DEBUG_SV.logmsg(l_module_name, DOCUMENT.CONCURRENT_PROGRAM_NAME || ' and no printers setup ' );
1008: END IF; --}
1009: --
1010: IF l_debug_on THEN --{
1011: WSH_DEBUG_SV.logmsg(l_module_name, l_copies || ' copies of ' || DOCUMENT.CONCURRENT_PROGRAM_NAME||' WILL BE PRINTED ON PRINTER '||L_PRINTER_NAME );

Line 1011: WSH_DEBUG_SV.logmsg(l_module_name, l_copies || ' copies of ' || DOCUMENT.CONCURRENT_PROGRAM_NAME||' WILL BE PRINTED ON PRINTER '||L_PRINTER_NAME );

1007: WSH_DEBUG_SV.logmsg(l_module_name, DOCUMENT.CONCURRENT_PROGRAM_NAME || ' and no printers setup ' );
1008: END IF; --}
1009: --
1010: IF l_debug_on THEN --{
1011: WSH_DEBUG_SV.logmsg(l_module_name, l_copies || ' copies of ' || DOCUMENT.CONCURRENT_PROGRAM_NAME||' WILL BE PRINTED ON PRINTER '||L_PRINTER_NAME );
1012: END IF; --}
1013: --
1014: l_printer_setup :=
1015: fnd_request.set_print_options

Line 1022: WSH_DEBUG_SV.logmsg(l_module_name, ' Set_Print_Options Returned False !!!!');

1018: l_copies,
1019: l_save_output,
1020: 'N');
1021: if ( NOT l_printer_setup and l_debug_on ) then --{
1022: WSH_DEBUG_SV.logmsg(l_module_name, ' Set_Print_Options Returned False !!!!');
1023: end if ; --}
1024: END IF ; --}
1025: END IF; --} If document.print_flag = 'Y'
1026:

Line 1036: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_EXTREPS_MLS_LANG.Get_NLS_Lang ' );

1032: -- Getting language if document has MLS function associated with it
1033: IF document.mls_executable_id IS NOT NULL THEN
1034: l_nls_lang.delete;
1035: IF l_debug_on THEN --{
1036: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_EXTREPS_MLS_LANG.Get_NLS_Lang ' );
1037: END IF; --}
1038: WSH_EXTREPS_MLS_LANG.Get_NLS_Lang (
1039: p_prog_name => document.concurrent_program_name,
1040: p_doc_param_info => l_lang_doc_params_info,

Line 1047: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returning from Get_NLS_Lang :'||x_return_status );

1043: x_return_status => x_return_status
1044: );
1045: IF x_return_status IN ( fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error ) THEN
1046: IF l_debug_on THEN --{
1047: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returning from Get_NLS_Lang :'||x_return_status );
1048: END IF; --}
1049: wsh_util_core.add_message(x_return_status);
1050: END IF;
1051: IF l_debug_on THEN --{

Line 1052: WSH_DEBUG_SV.logmsg(l_module_name, 'Number of NLS languages :'||l_nls_lang.COUNT );

1048: END IF; --}
1049: wsh_util_core.add_message(x_return_status);
1050: END IF;
1051: IF l_debug_on THEN --{
1052: WSH_DEBUG_SV.logmsg(l_module_name, 'Number of NLS languages :'||l_nls_lang.COUNT );
1053: END IF; --}
1054: END IF;
1055:
1056: l_submitted := FALSE;

Line 1066: WSH_DEBUG_SV.logmsg(l_module_name, 'Setting option for language : '||l_nls_lang(l_nls_count).nls_language);

1062: IF l_nls_count <= l_nls_lang.COUNT THEN
1063: /* set the language and territory for this request
1064: all individual requests are protected against updates */
1065: IF l_debug_on THEN --{
1066: WSH_DEBUG_SV.logmsg(l_module_name, 'Setting option for language : '||l_nls_lang(l_nls_count).nls_language);
1067: END IF; --}
1068: if ( not fnd_request.set_options(
1069: implicit => 'NO',
1070: protected => 'YES',

Line 1074: WSH_DEBUG_SV.logmsg(l_module_name, 'fnd_request.set_options returned false');

1070: protected => 'YES',
1071: language => l_nls_lang(l_nls_count).nls_language,
1072: territory => l_nls_lang(l_nls_count).nls_territory)) then
1073: IF l_debug_on THEN --{
1074: WSH_DEBUG_SV.logmsg(l_module_name, 'fnd_request.set_options returned false');
1075: END IF; --}
1076: wsh_util_core.add_message(x_return_status);
1077: raise no_data_found ;
1078: end if;

Line 1093: WSH_DEBUG_SV.logmsg(l_module_name, 'p_trip_id for Master BOL = ' ||l_argument(1));

1089: -- document number are generated before submitting request
1090:
1091: IF document.concurrent_program_name = 'WSHRDMBL' THEN
1092: IF l_debug_on THEN
1093: WSH_DEBUG_SV.logmsg(l_module_name, 'p_trip_id for Master BOL = ' ||l_argument(1));
1094: END IF;
1095: WSH_MBOLS_PVT.Generate_MBOL(
1096: p_trip_id => l_argument(1),
1097: x_sequence_number => l_document_number,

Line 1112: WSH_DEBUG_SV.logmsg(l_module_name, 'p_trip_id for BOL = ' ||l_argument(6));

1108: AND ( nvl(l_doc_set_params(i).bol_error_flag,'N') = 'N') THEN
1109:
1110: IF l_argument(6) is not null THEN
1111: IF l_debug_on THEN
1112: WSH_DEBUG_SV.logmsg(l_module_name, 'p_trip_id for BOL = ' ||l_argument(6));
1113: END IF;
1114: WSH_MBOLS_PVT.Generate_BOLs(
1115: p_trip_id => l_argument(6),
1116: x_return_status => l_return_status );

Line 1133: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_id for BOL = ' ||l_delivery_id);

1129: l_ship_method_code,
1130: l_pickup_location_id,
1131: l_trip_name;
1132: IF l_debug_on THEN
1133: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_id for BOL = ' ||l_delivery_id);
1134: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_leg_id for BOL = ' ||l_delivery_leg_id);
1135: WSH_DEBUG_SV.logmsg(l_module_name, 'l_ship_method_code for BOL = ' ||l_ship_method_code);
1136: WSH_DEBUG_SV.logmsg(l_module_name, 'l_pickup_location_id for BOL = ' ||l_pickup_location_id);
1137: WSH_DEBUG_SV.logmsg(l_module_name, 'l_trip_name for BOL = ' ||l_trip_name);

Line 1134: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_leg_id for BOL = ' ||l_delivery_leg_id);

1130: l_pickup_location_id,
1131: l_trip_name;
1132: IF l_debug_on THEN
1133: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_id for BOL = ' ||l_delivery_id);
1134: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_leg_id for BOL = ' ||l_delivery_leg_id);
1135: WSH_DEBUG_SV.logmsg(l_module_name, 'l_ship_method_code for BOL = ' ||l_ship_method_code);
1136: WSH_DEBUG_SV.logmsg(l_module_name, 'l_pickup_location_id for BOL = ' ||l_pickup_location_id);
1137: WSH_DEBUG_SV.logmsg(l_module_name, 'l_trip_name for BOL = ' ||l_trip_name);
1138: END IF;

Line 1135: WSH_DEBUG_SV.logmsg(l_module_name, 'l_ship_method_code for BOL = ' ||l_ship_method_code);

1131: l_trip_name;
1132: IF l_debug_on THEN
1133: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_id for BOL = ' ||l_delivery_id);
1134: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_leg_id for BOL = ' ||l_delivery_leg_id);
1135: WSH_DEBUG_SV.logmsg(l_module_name, 'l_ship_method_code for BOL = ' ||l_ship_method_code);
1136: WSH_DEBUG_SV.logmsg(l_module_name, 'l_pickup_location_id for BOL = ' ||l_pickup_location_id);
1137: WSH_DEBUG_SV.logmsg(l_module_name, 'l_trip_name for BOL = ' ||l_trip_name);
1138: END IF;
1139: EXIT WHEN c_get_delivery_info%NOTFOUND;

Line 1136: WSH_DEBUG_SV.logmsg(l_module_name, 'l_pickup_location_id for BOL = ' ||l_pickup_location_id);

1132: IF l_debug_on THEN
1133: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_id for BOL = ' ||l_delivery_id);
1134: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_leg_id for BOL = ' ||l_delivery_leg_id);
1135: WSH_DEBUG_SV.logmsg(l_module_name, 'l_ship_method_code for BOL = ' ||l_ship_method_code);
1136: WSH_DEBUG_SV.logmsg(l_module_name, 'l_pickup_location_id for BOL = ' ||l_pickup_location_id);
1137: WSH_DEBUG_SV.logmsg(l_module_name, 'l_trip_name for BOL = ' ||l_trip_name);
1138: END IF;
1139: EXIT WHEN c_get_delivery_info%NOTFOUND;
1140:

Line 1137: WSH_DEBUG_SV.logmsg(l_module_name, 'l_trip_name for BOL = ' ||l_trip_name);

1133: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_id for BOL = ' ||l_delivery_id);
1134: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_leg_id for BOL = ' ||l_delivery_leg_id);
1135: WSH_DEBUG_SV.logmsg(l_module_name, 'l_ship_method_code for BOL = ' ||l_ship_method_code);
1136: WSH_DEBUG_SV.logmsg(l_module_name, 'l_pickup_location_id for BOL = ' ||l_pickup_location_id);
1137: WSH_DEBUG_SV.logmsg(l_module_name, 'l_trip_name for BOL = ' ||l_trip_name);
1138: END IF;
1139: EXIT WHEN c_get_delivery_info%NOTFOUND;
1140:
1141: SELECT count(*)

Line 1156: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status for BOL = '||x_return_status);

1152: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
1153: x_return_status := wsh_util_core.g_ret_sts_error;
1154: wsh_util_core.add_message(x_return_status);
1155: IF l_debug_on THEN
1156: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status for BOL = '||x_return_status);
1157: END IF;
1158: IF c_get_delivery_info%ISOPEN THEN
1159: CLOSE c_get_delivery_info;
1160: END IF;

Line 1232: WSH_DEBUG_SV.logmsg(l_module_name,'l_ledger_id = '||l_ledger_id);

1228: -- LE Uptake
1229: open m_get_ledger_id(l_argument(2));
1230: fetch m_get_ledger_id INTO l_ledger_id;
1231: IF l_debug_on THEN
1232: WSH_DEBUG_SV.logmsg(l_module_name,'l_ledger_id = '||l_ledger_id);
1233: END IF;
1234:
1235: IF m_get_ledger_id%NOTFOUND THEN
1236: FND_MESSAGE.SET_NAME('WSH','WSH_LEDGER_ID_NOT_FOUND');

Line 1281: WSH_DEBUG_SV.logmsg(l_module_name, 'template' || l_template_code);

1277: l_print_pdf := 'N';
1278: IF(l_output_file_type = 'XML' ) THEN
1279: --{
1280: IF l_debug_on THEN
1281: WSH_DEBUG_SV.logmsg(l_module_name, 'template' || l_template_code);
1282: END IF;
1283: --
1284: IF (l_template_code is not NULL) then
1285: --{

Line 1298: WSH_DEBUG_SV.logmsg(l_module_name, ' language ' || l_language );

1294: where language_code = userenv('LANG');
1295: END IF;
1296: --
1297: IF l_debug_on THEN
1298: WSH_DEBUG_SV.logmsg(l_module_name, ' language ' || l_language );
1299: WSH_DEBUG_SV.logmsg(l_module_name, 'territory ' || l_territory);
1300: END IF;
1301: --
1302: l_ret_status :=fnd_request.add_layout(l_appl_short_name,

Line 1299: WSH_DEBUG_SV.logmsg(l_module_name, 'territory ' || l_territory);

1295: END IF;
1296: --
1297: IF l_debug_on THEN
1298: WSH_DEBUG_SV.logmsg(l_module_name, ' language ' || l_language );
1299: WSH_DEBUG_SV.logmsg(l_module_name, 'territory ' || l_territory);
1300: END IF;
1301: --
1302: l_ret_status :=fnd_request.add_layout(l_appl_short_name,
1303: l_template_code,

Line 1311: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returning from fnd_request.add_layout :'||x_return_status);

1307: IF l_ret_status THEN
1308: l_print_pdf := 'Y';
1309: ELSE
1310: IF l_debug_on THEN
1311: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returning from fnd_request.add_layout :'||x_return_status);
1312: END IF;
1313: wsh_util_core.add_message(x_return_status);
1314: END IF;
1315: --}

Line 1319: WSH_DEBUG_SV.logmsg(l_module_name, 'No template was specified for this report. Hence could not generate the pdf output' );

1315: --}
1316: ELSE
1317: --{
1318: IF l_debug_on THEN
1319: WSH_DEBUG_SV.logmsg(l_module_name, 'No template was specified for this report. Hence could not generate the pdf output' );
1320: END IF;
1321: --
1322: fnd_message.set_name('WSH', 'WSH_NO_DEFAULT_TEMPLATE');
1323: fnd_message.set_token('CONC_PROG_NAME', document.user_concurrent_program_name);

Line 1357: WSH_DEBUG_SV.logmsg(l_module_name, 'SUBMITTED '|| DOCUMENT.CONCURRENT_PROGRAM_NAME||' WITH REQUEST_ID:'||TO_CHAR ( L_REQUEST_ID ) );

1353: --
1354: -- Debug Statements
1355: --
1356: IF l_debug_on THEN --{
1357: WSH_DEBUG_SV.logmsg(l_module_name, 'SUBMITTED '|| DOCUMENT.CONCURRENT_PROGRAM_NAME||' WITH REQUEST_ID:'||TO_CHAR ( L_REQUEST_ID ) );
1358: END IF; --}
1359: --
1360: -- increase the counter if successful
1361: IF l_request_id > 0 THEN --{

Line 1369: WSH_DEBUG_SV.logmsg(l_module_name, 'REQUEST ID ' || TO_CHAR ( L_REQUEST_ID ) );

1365: --
1366: -- Debug Statements
1367: --
1368: IF l_debug_on THEN --{
1369: WSH_DEBUG_SV.logmsg(l_module_name, 'REQUEST ID ' || TO_CHAR ( L_REQUEST_ID ) );
1370: END IF; --}
1371: --
1372:
1373: if (entity_count > 0) then --{

Line 1424: WSH_DEBUG_SV.logmsg(l_module_name, 'WSHRDPIK and number of printers is ' || WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.count );

1420: END LOOP; -- end of l_submitted loop
1421:
1422: ELSE -- It is WSHRDPIK and G_PRINTERTAB has been populated
1423: IF l_debug_on THEN --{
1424: WSH_DEBUG_SV.logmsg(l_module_name, 'WSHRDPIK and number of printers is ' || WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.count );
1425: END IF; --}
1426: --
1427: -- Find position of 'Printer Name' in the arguments
1428:

Line 1432: WSH_DEBUG_SV.logmsg(l_module_name, 'Argument name ' || l_argument_name (j) );

1428:
1429: l_printer_pos := -1 ;
1430: for j in 1..l_argument_name.count loop
1431: IF l_debug_on THEN --{
1432: WSH_DEBUG_SV.logmsg(l_module_name, 'Argument name ' || l_argument_name (j) );
1433: END IF; --}
1434: --
1435: if l_argument_name(j) = 'Printer Name' then
1436: l_printer_pos := j;

Line 1438: WSH_DEBUG_SV.logmsg(l_module_name, 'Found printer name at pos ' || j );

1434: --
1435: if l_argument_name(j) = 'Printer Name' then
1436: l_printer_pos := j;
1437: IF l_debug_on THEN --{
1438: WSH_DEBUG_SV.logmsg(l_module_name, 'Found printer name at pos ' || j );
1439: END IF; --}
1440: --
1441: exit ;
1442: end if ;

Line 1452: WSH_DEBUG_SV.logmsg(l_module_name, 'Setting '|| document.concurrent_program_name || ' with ' || l_copies || ' copies on printer ' || p_document_param_info(1).p_printer_name );

1448: -- l_argument(l_printer_pos) := WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i);
1449: l_argument(l_printer_pos) := p_document_param_info(1).p_printer_name;
1450:
1451: IF l_debug_on THEN --{
1452: WSH_DEBUG_SV.logmsg(l_module_name, 'Setting '|| document.concurrent_program_name || ' with ' || l_copies || ' copies on printer ' || p_document_param_info(1).p_printer_name );
1453: --
1454: END IF; --}
1455:
1456: l_printer_setup :=

Line 1465: WSH_DEBUG_SV.logmsg(l_module_name, 'For Printer ' || p_document_param_info(1).p_printer_name || ', Set_Print_Options Returned False for WSHRDPIK!!!!');

1461: save_output => l_save_output,
1462: print_together => 'N');
1463:
1464: if ( NOT l_printer_setup and l_debug_on ) then --{
1465: WSH_DEBUG_SV.logmsg(l_module_name, 'For Printer ' || p_document_param_info(1).p_printer_name || ', Set_Print_Options Returned False for WSHRDPIK!!!!');
1466: end if ; --}
1467:
1468: -- Getting language if document has MLS function associated with it
1469: IF document.mls_executable_id IS NOT NULL THEN

Line 1472: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_EXTREPS_MLS_LANG.Get_NLS_Lang ' );

1468: -- Getting language if document has MLS function associated with it
1469: IF document.mls_executable_id IS NOT NULL THEN
1470: l_nls_lang.delete;
1471: IF l_debug_on THEN --{
1472: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_EXTREPS_MLS_LANG.Get_NLS_Lang ' );
1473: END IF; --}
1474: WSH_EXTREPS_MLS_LANG.Get_NLS_Lang (
1475: p_prog_name => document.concurrent_program_name,
1476: p_doc_param_info => l_lang_doc_params_info,

Line 1483: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returning from Get_NLS_Lang :'||x_return_status

1479: x_return_status => x_return_status
1480: );
1481: IF x_return_status IN ( fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error ) THEN
1482: IF l_debug_on THEN --{
1483: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returning from Get_NLS_Lang :'||x_return_status
1484: );
1485: END IF; --}
1486: wsh_util_core.add_message(x_return_status);
1487: END IF;

Line 1489: WSH_DEBUG_SV.logmsg(l_module_name, 'Number of NLS languages :'||l_nls_lang.COUNT );

1485: END IF; --}
1486: wsh_util_core.add_message(x_return_status);
1487: END IF;
1488: IF l_debug_on THEN --{
1489: WSH_DEBUG_SV.logmsg(l_module_name, 'Number of NLS languages :'||l_nls_lang.COUNT );
1490: END IF; --}
1491: END IF;
1492:
1493: l_submitted := FALSE;

Line 1508: WSH_DEBUG_SV.logmsg(l_module_name, 'Setting option for language : '||l_nls_lang(l_nls_count).nls_language);

1504: IF l_nls_count <= l_nls_lang.COUNT THEN
1505: /* set the language and territory for this request
1506: all individual requests are protected against updates */
1507: IF l_debug_on THEN --{
1508: WSH_DEBUG_SV.logmsg(l_module_name, 'Setting option for language : '||l_nls_lang(l_nls_count).nls_language);
1509: END IF; --}
1510: if ( not fnd_request.set_options(
1511: implicit => 'NO',
1512: protected => 'YES',

Line 1516: WSH_DEBUG_SV.logmsg(l_module_name, 'fnd_request.set_options returned false');

1512: protected => 'YES',
1513: language => l_nls_lang(l_nls_count).nls_language,
1514: territory => l_nls_lang(l_nls_count).nls_territory)) then
1515: IF l_debug_on THEN --{
1516: WSH_DEBUG_SV.logmsg(l_module_name, 'fnd_request.set_options returned false');
1517: END IF; --}
1518: wsh_util_core.add_message(x_return_status);
1519: raise no_data_found ;
1520: end if;

Line 1535: WSH_DEBUG_SV.logmsg(l_module_name, 'template' || l_template_code);

1531: l_print_pdf := 'N';
1532: IF (l_output_file_type = 'XML' ) then
1533: --{
1534: IF l_debug_on THEN
1535: WSH_DEBUG_SV.logmsg(l_module_name, 'template' || l_template_code);
1536: END IF;
1537: --
1538: IF (l_template_code is not NULL) then
1539: --{

Line 1552: WSH_DEBUG_SV.logmsg(l_module_name, ' language' || l_language );

1548: where language_code = userenv('LANG');
1549: END IF;
1550: --
1551: IF l_debug_on THEN
1552: WSH_DEBUG_SV.logmsg(l_module_name, ' language' || l_language );
1553: WSH_DEBUG_SV.logmsg(l_module_name, 'territory' || l_territory);
1554: END IF;
1555: --
1556: l_ret_status :=fnd_request.add_layout

Line 1553: WSH_DEBUG_SV.logmsg(l_module_name, 'territory' || l_territory);

1549: END IF;
1550: --
1551: IF l_debug_on THEN
1552: WSH_DEBUG_SV.logmsg(l_module_name, ' language' || l_language );
1553: WSH_DEBUG_SV.logmsg(l_module_name, 'territory' || l_territory);
1554: END IF;
1555: --
1556: l_ret_status :=fnd_request.add_layout
1557: (l_appl_short_name,

Line 1566: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returning from fnd_request.add_layout :'||x_return_status);

1562: IF l_ret_status THEN
1563: l_print_pdf := 'Y';
1564: ELSE
1565: IF l_debug_on THEN
1566: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returning from fnd_request.add_layout :'||x_return_status);
1567: END IF;
1568: wsh_util_core.add_message(x_return_status);
1569: END IF;
1570: --}

Line 1573: WSH_DEBUG_SV.logmsg(l_module_name, 'No template was specified for this report. Hence could not generate the pdf output' );

1569: END IF;
1570: --}
1571: ELSE
1572: IF l_debug_on THEN
1573: WSH_DEBUG_SV.logmsg(l_module_name, 'No template was specified for this report. Hence could not generate the pdf output' );
1574: END IF;
1575: fnd_message.set_name('WSH', 'WSH_NO_DEFAULT_TEMPLATE');
1576: fnd_message.set_token('CONC_PROG_NAME', document.concurrent_program_name);
1577: x_return_status := wsh_util_core.g_ret_sts_error;

Line 1610: WSH_DEBUG_SV.logmsg(l_module_name, 'SUBMITTED '|| DOCUMENT.CONCURRENT_PROGRAM_NAME||' WITH

1606: --
1607: -- Debug Statements
1608: --
1609: IF l_debug_on THEN --{
1610: WSH_DEBUG_SV.logmsg(l_module_name, 'SUBMITTED '|| DOCUMENT.CONCURRENT_PROGRAM_NAME||' WITH
1611: REQUEST_ID:'||TO_CHAR ( L_REQUEST_ID ) );
1612: END IF; --}
1613: --
1614: -- increase the counter if successful

Line 1623: WSH_DEBUG_SV.logmsg(l_module_name, 'REQUEST ID ' || TO_CHAR ( L_REQUEST_ID ) );

1619: --
1620: -- Debug Statements
1621: --
1622: IF l_debug_on THEN --{
1623: WSH_DEBUG_SV.logmsg(l_module_name, 'REQUEST ID ' || TO_CHAR ( L_REQUEST_ID ) );
1624: END IF; --}
1625: --
1626:
1627: if (entity_count > 0) then --{

Line 1704: WSH_DEBUG_SV.logmsg(l_module_name, 'SUBMITTED ' || TO_CHAR ( L_SUBMITTED_DOCS ) || ' OUT OF ' || TO_CHAR ( L_TOTAL_DOCS ) );

1700: --
1701: -- Debug Statements
1702: --
1703: IF l_debug_on THEN
1704: WSH_DEBUG_SV.logmsg(l_module_name, 'SUBMITTED ' || TO_CHAR ( L_SUBMITTED_DOCS ) || ' OUT OF ' || TO_CHAR ( L_TOTAL_DOCS ) );
1705: END IF;
1706: --
1707:
1708: fnd_message.set_name('WSH', 'WSH_DOCS_SUBMITTED');

Line 1723: WSH_DEBUG_SV.logmsg(l_module_name, 'NO REPORTS TO PROCESS' );

1719: --
1720: -- Debug Statements
1721: --
1722: IF l_debug_on THEN
1723: WSH_DEBUG_SV.logmsg(l_module_name, 'NO REPORTS TO PROCESS' );
1724: END IF;
1725: --
1726: x_return_status := fnd_api.g_ret_sts_error;
1727: fnd_message.set_name('WSH','WSH_NO_REPORT_TO_PROCESS');

Line 1735: WSH_DEBUG_SV.logmsg(l_module_name, 'NO ORGANIZATION FOUND FOR ENTITY' );

1731: --
1732: -- Debug Statements
1733: --
1734: IF l_debug_on THEN
1735: WSH_DEBUG_SV.logmsg(l_module_name, 'NO ORGANIZATION FOUND FOR ENTITY' );
1736: END IF;
1737: --
1738: x_return_status := wsh_util_core.g_ret_sts_error;
1739: fnd_message.set_name('WSH','WSH_NO_ENTITY_ORG');

Line 1751: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1747: --
1748: -- Debug Statements
1749: --
1750: IF l_debug_on THEN
1751: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1752: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_DOCUMENT_ERROR');
1753: END IF;
1754: WHEN OTHERS THEN
1755: wsh_util_core.default_handler('WSH_UTIL_CORE.PRINT_DOCUMENT_SETS');

Line 1752: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_DOCUMENT_ERROR');

1748: -- Debug Statements
1749: --
1750: IF l_debug_on THEN
1751: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1752: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_DOCUMENT_ERROR');
1753: END IF;
1754: WHEN OTHERS THEN
1755: wsh_util_core.default_handler('WSH_UTIL_CORE.PRINT_DOCUMENT_SETS');
1756: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1762: WSH_DEBUG_SV.pop(l_module_name);

1758: --
1759: -- Debug Statements
1760: --
1761: IF l_debug_on THEN
1762: WSH_DEBUG_SV.pop(l_module_name);
1763: END IF;
1764: --
1765: END print_document_sets;
1766: