[Home] [Help]
74: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
75: --
76: IF l_debug_on IS NULL
77: THEN
78: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
79: END IF;
80: --
81: IF l_debug_on THEN
82: WSH_DEBUG_SV.push(l_module_name);
78: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
79: END IF;
80: --
81: IF l_debug_on THEN
82: WSH_DEBUG_SV.push(l_module_name);
83: --
84: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
85: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
86: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_IDS.COUNT',P_TRIP_IDS.COUNT);
80: --
81: IF l_debug_on THEN
82: WSH_DEBUG_SV.push(l_module_name);
83: --
84: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
85: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
86: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_IDS.COUNT',P_TRIP_IDS.COUNT);
87: WSH_DEBUG_SV.log(l_module_name,'P_STOP_IDS.COUNT',P_STOP_IDS.COUNT);
88: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_IDS.COUNT',P_DELIVERY_IDS.COUNT);
81: IF l_debug_on THEN
82: WSH_DEBUG_SV.push(l_module_name);
83: --
84: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
85: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
86: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_IDS.COUNT',P_TRIP_IDS.COUNT);
87: WSH_DEBUG_SV.log(l_module_name,'P_STOP_IDS.COUNT',P_STOP_IDS.COUNT);
88: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_IDS.COUNT',P_DELIVERY_IDS.COUNT);
89:
82: WSH_DEBUG_SV.push(l_module_name);
83: --
84: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
85: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
86: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_IDS.COUNT',P_TRIP_IDS.COUNT);
87: WSH_DEBUG_SV.log(l_module_name,'P_STOP_IDS.COUNT',P_STOP_IDS.COUNT);
88: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_IDS.COUNT',P_DELIVERY_IDS.COUNT);
89:
90: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.COUNT',P_DOCUMENT_PARAM_INFO.COUNT);
83: --
84: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
85: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
86: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_IDS.COUNT',P_TRIP_IDS.COUNT);
87: WSH_DEBUG_SV.log(l_module_name,'P_STOP_IDS.COUNT',P_STOP_IDS.COUNT);
88: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_IDS.COUNT',P_DELIVERY_IDS.COUNT);
89:
90: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.COUNT',P_DOCUMENT_PARAM_INFO.COUNT);
91: /*
84: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
85: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
86: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_IDS.COUNT',P_TRIP_IDS.COUNT);
87: WSH_DEBUG_SV.log(l_module_name,'P_STOP_IDS.COUNT',P_STOP_IDS.COUNT);
88: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_IDS.COUNT',P_DELIVERY_IDS.COUNT);
89:
90: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.COUNT',P_DOCUMENT_PARAM_INFO.COUNT);
91: /*
92: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.report_set_id',P_DOCUMENT_PARAM_INFO.p_report_set_id);
86: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_IDS.COUNT',P_TRIP_IDS.COUNT);
87: WSH_DEBUG_SV.log(l_module_name,'P_STOP_IDS.COUNT',P_STOP_IDS.COUNT);
88: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_IDS.COUNT',P_DELIVERY_IDS.COUNT);
89:
90: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.COUNT',P_DOCUMENT_PARAM_INFO.COUNT);
91: /*
92: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.report_set_id',P_DOCUMENT_PARAM_INFO.p_report_set_id);
93: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.request_id',P_DOCUMENT_PARAM_INFO.p_request_id);
94: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.customer_id',P_DOCUMENT_PARAM_INFO.p_customer_id);
88: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_IDS.COUNT',P_DELIVERY_IDS.COUNT);
89:
90: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.COUNT',P_DOCUMENT_PARAM_INFO.COUNT);
91: /*
92: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.report_set_id',P_DOCUMENT_PARAM_INFO.p_report_set_id);
93: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.request_id',P_DOCUMENT_PARAM_INFO.p_request_id);
94: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.customer_id',P_DOCUMENT_PARAM_INFO.p_customer_id);
95: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_id',P_DOCUMENT_PARAM_INFO.p_item_id);
96: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_cate_set_id',P_DOCUMENT_PARAM_INFO.p_item_cate_set_id);
89:
90: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.COUNT',P_DOCUMENT_PARAM_INFO.COUNT);
91: /*
92: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.report_set_id',P_DOCUMENT_PARAM_INFO.p_report_set_id);
93: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.request_id',P_DOCUMENT_PARAM_INFO.p_request_id);
94: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.customer_id',P_DOCUMENT_PARAM_INFO.p_customer_id);
95: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_id',P_DOCUMENT_PARAM_INFO.p_item_id);
96: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_cate_set_id',P_DOCUMENT_PARAM_INFO.p_item_cate_set_id);
97: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_category_id',P_DOCUMENT_PARAM_INFO.p_item_category_id);
90: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.COUNT',P_DOCUMENT_PARAM_INFO.COUNT);
91: /*
92: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.report_set_id',P_DOCUMENT_PARAM_INFO.p_report_set_id);
93: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.request_id',P_DOCUMENT_PARAM_INFO.p_request_id);
94: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.customer_id',P_DOCUMENT_PARAM_INFO.p_customer_id);
95: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_id',P_DOCUMENT_PARAM_INFO.p_item_id);
96: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_cate_set_id',P_DOCUMENT_PARAM_INFO.p_item_cate_set_id);
97: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_category_id',P_DOCUMENT_PARAM_INFO.p_item_category_id);
98: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.transaction_type_id',P_DOCUMENT_PARAM_INFO.p_transaction_type_id);
91: /*
92: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.report_set_id',P_DOCUMENT_PARAM_INFO.p_report_set_id);
93: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.request_id',P_DOCUMENT_PARAM_INFO.p_request_id);
94: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.customer_id',P_DOCUMENT_PARAM_INFO.p_customer_id);
95: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_id',P_DOCUMENT_PARAM_INFO.p_item_id);
96: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_cate_set_id',P_DOCUMENT_PARAM_INFO.p_item_cate_set_id);
97: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_category_id',P_DOCUMENT_PARAM_INFO.p_item_category_id);
98: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.transaction_type_id',P_DOCUMENT_PARAM_INFO.p_transaction_type_id);
99: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.header_id_low',P_DOCUMENT_PARAM_INFO.p_header_id_high);
92: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.report_set_id',P_DOCUMENT_PARAM_INFO.p_report_set_id);
93: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.request_id',P_DOCUMENT_PARAM_INFO.p_request_id);
94: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.customer_id',P_DOCUMENT_PARAM_INFO.p_customer_id);
95: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_id',P_DOCUMENT_PARAM_INFO.p_item_id);
96: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_cate_set_id',P_DOCUMENT_PARAM_INFO.p_item_cate_set_id);
97: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_category_id',P_DOCUMENT_PARAM_INFO.p_item_category_id);
98: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.transaction_type_id',P_DOCUMENT_PARAM_INFO.p_transaction_type_id);
99: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.header_id_low',P_DOCUMENT_PARAM_INFO.p_header_id_high);
100: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.salesrep_id',P_DOCUMENT_PARAM_INFO.p_salesrep_id);
93: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.request_id',P_DOCUMENT_PARAM_INFO.p_request_id);
94: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.customer_id',P_DOCUMENT_PARAM_INFO.p_customer_id);
95: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_id',P_DOCUMENT_PARAM_INFO.p_item_id);
96: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_cate_set_id',P_DOCUMENT_PARAM_INFO.p_item_cate_set_id);
97: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_category_id',P_DOCUMENT_PARAM_INFO.p_item_category_id);
98: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.transaction_type_id',P_DOCUMENT_PARAM_INFO.p_transaction_type_id);
99: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.header_id_low',P_DOCUMENT_PARAM_INFO.p_header_id_high);
100: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.salesrep_id',P_DOCUMENT_PARAM_INFO.p_salesrep_id);
101: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.user_id',P_DOCUMENT_PARAM_INFO.p_user_id);
94: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.customer_id',P_DOCUMENT_PARAM_INFO.p_customer_id);
95: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_id',P_DOCUMENT_PARAM_INFO.p_item_id);
96: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_cate_set_id',P_DOCUMENT_PARAM_INFO.p_item_cate_set_id);
97: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_category_id',P_DOCUMENT_PARAM_INFO.p_item_category_id);
98: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.transaction_type_id',P_DOCUMENT_PARAM_INFO.p_transaction_type_id);
99: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.header_id_low',P_DOCUMENT_PARAM_INFO.p_header_id_high);
100: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.salesrep_id',P_DOCUMENT_PARAM_INFO.p_salesrep_id);
101: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.user_id',P_DOCUMENT_PARAM_INFO.p_user_id);
102: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.territory_name',P_DOCUMENT_PARAM_INFO.p_territory_name);
95: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_id',P_DOCUMENT_PARAM_INFO.p_item_id);
96: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_cate_set_id',P_DOCUMENT_PARAM_INFO.p_item_cate_set_id);
97: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_category_id',P_DOCUMENT_PARAM_INFO.p_item_category_id);
98: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.transaction_type_id',P_DOCUMENT_PARAM_INFO.p_transaction_type_id);
99: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.header_id_low',P_DOCUMENT_PARAM_INFO.p_header_id_high);
100: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.salesrep_id',P_DOCUMENT_PARAM_INFO.p_salesrep_id);
101: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.user_id',P_DOCUMENT_PARAM_INFO.p_user_id);
102: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.territory_name',P_DOCUMENT_PARAM_INFO.p_territory_name);
103: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.organization_id',P_DOCUMENT_PARAM_INFO.p_organization_id);
96: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_cate_set_id',P_DOCUMENT_PARAM_INFO.p_item_cate_set_id);
97: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_category_id',P_DOCUMENT_PARAM_INFO.p_item_category_id);
98: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.transaction_type_id',P_DOCUMENT_PARAM_INFO.p_transaction_type_id);
99: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.header_id_low',P_DOCUMENT_PARAM_INFO.p_header_id_high);
100: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.salesrep_id',P_DOCUMENT_PARAM_INFO.p_salesrep_id);
101: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.user_id',P_DOCUMENT_PARAM_INFO.p_user_id);
102: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.territory_name',P_DOCUMENT_PARAM_INFO.p_territory_name);
103: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.organization_id',P_DOCUMENT_PARAM_INFO.p_organization_id);
104: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_id',P_DOCUMENT_PARAM_INFO.p_trip_id);
97: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.item_category_id',P_DOCUMENT_PARAM_INFO.p_item_category_id);
98: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.transaction_type_id',P_DOCUMENT_PARAM_INFO.p_transaction_type_id);
99: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.header_id_low',P_DOCUMENT_PARAM_INFO.p_header_id_high);
100: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.salesrep_id',P_DOCUMENT_PARAM_INFO.p_salesrep_id);
101: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.user_id',P_DOCUMENT_PARAM_INFO.p_user_id);
102: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.territory_name',P_DOCUMENT_PARAM_INFO.p_territory_name);
103: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.organization_id',P_DOCUMENT_PARAM_INFO.p_organization_id);
104: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_id',P_DOCUMENT_PARAM_INFO.p_trip_id);
105: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.dleg_id',P_DOCUMENT_PARAM_INFO.p_delivery_leg_id);
98: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.transaction_type_id',P_DOCUMENT_PARAM_INFO.p_transaction_type_id);
99: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.header_id_low',P_DOCUMENT_PARAM_INFO.p_header_id_high);
100: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.salesrep_id',P_DOCUMENT_PARAM_INFO.p_salesrep_id);
101: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.user_id',P_DOCUMENT_PARAM_INFO.p_user_id);
102: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.territory_name',P_DOCUMENT_PARAM_INFO.p_territory_name);
103: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.organization_id',P_DOCUMENT_PARAM_INFO.p_organization_id);
104: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_id',P_DOCUMENT_PARAM_INFO.p_trip_id);
105: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.dleg_id',P_DOCUMENT_PARAM_INFO.p_delivery_leg_id);
106: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.bol_num',P_DOCUMENT_PARAM_INFO.p_bill_of_lading_number);
99: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.header_id_low',P_DOCUMENT_PARAM_INFO.p_header_id_high);
100: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.salesrep_id',P_DOCUMENT_PARAM_INFO.p_salesrep_id);
101: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.user_id',P_DOCUMENT_PARAM_INFO.p_user_id);
102: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.territory_name',P_DOCUMENT_PARAM_INFO.p_territory_name);
103: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.organization_id',P_DOCUMENT_PARAM_INFO.p_organization_id);
104: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_id',P_DOCUMENT_PARAM_INFO.p_trip_id);
105: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.dleg_id',P_DOCUMENT_PARAM_INFO.p_delivery_leg_id);
106: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.bol_num',P_DOCUMENT_PARAM_INFO.p_bill_of_lading_number);
107: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_stop_id',P_DOCUMENT_PARAM_INFO.p_trip_stop_id);
100: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.salesrep_id',P_DOCUMENT_PARAM_INFO.p_salesrep_id);
101: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.user_id',P_DOCUMENT_PARAM_INFO.p_user_id);
102: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.territory_name',P_DOCUMENT_PARAM_INFO.p_territory_name);
103: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.organization_id',P_DOCUMENT_PARAM_INFO.p_organization_id);
104: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_id',P_DOCUMENT_PARAM_INFO.p_trip_id);
105: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.dleg_id',P_DOCUMENT_PARAM_INFO.p_delivery_leg_id);
106: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.bol_num',P_DOCUMENT_PARAM_INFO.p_bill_of_lading_number);
107: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_stop_id',P_DOCUMENT_PARAM_INFO.p_trip_stop_id);
108: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.delivery_id',P_DOCUMENT_PARAM_INFO.p_delivery_id);
101: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.user_id',P_DOCUMENT_PARAM_INFO.p_user_id);
102: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.territory_name',P_DOCUMENT_PARAM_INFO.p_territory_name);
103: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.organization_id',P_DOCUMENT_PARAM_INFO.p_organization_id);
104: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_id',P_DOCUMENT_PARAM_INFO.p_trip_id);
105: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.dleg_id',P_DOCUMENT_PARAM_INFO.p_delivery_leg_id);
106: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.bol_num',P_DOCUMENT_PARAM_INFO.p_bill_of_lading_number);
107: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_stop_id',P_DOCUMENT_PARAM_INFO.p_trip_stop_id);
108: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.delivery_id',P_DOCUMENT_PARAM_INFO.p_delivery_id);
109: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_order_num_l);
102: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.territory_name',P_DOCUMENT_PARAM_INFO.p_territory_name);
103: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.organization_id',P_DOCUMENT_PARAM_INFO.p_organization_id);
104: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_id',P_DOCUMENT_PARAM_INFO.p_trip_id);
105: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.dleg_id',P_DOCUMENT_PARAM_INFO.p_delivery_leg_id);
106: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.bol_num',P_DOCUMENT_PARAM_INFO.p_bill_of_lading_number);
107: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_stop_id',P_DOCUMENT_PARAM_INFO.p_trip_stop_id);
108: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.delivery_id',P_DOCUMENT_PARAM_INFO.p_delivery_id);
109: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_order_num_l);
110: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_order_num_h);
103: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.organization_id',P_DOCUMENT_PARAM_INFO.p_organization_id);
104: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_id',P_DOCUMENT_PARAM_INFO.p_trip_id);
105: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.dleg_id',P_DOCUMENT_PARAM_INFO.p_delivery_leg_id);
106: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.bol_num',P_DOCUMENT_PARAM_INFO.p_bill_of_lading_number);
107: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_stop_id',P_DOCUMENT_PARAM_INFO.p_trip_stop_id);
108: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.delivery_id',P_DOCUMENT_PARAM_INFO.p_delivery_id);
109: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_order_num_l);
110: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_order_num_h);
111: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_move_order_l);
104: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_id',P_DOCUMENT_PARAM_INFO.p_trip_id);
105: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.dleg_id',P_DOCUMENT_PARAM_INFO.p_delivery_leg_id);
106: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.bol_num',P_DOCUMENT_PARAM_INFO.p_bill_of_lading_number);
107: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_stop_id',P_DOCUMENT_PARAM_INFO.p_trip_stop_id);
108: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.delivery_id',P_DOCUMENT_PARAM_INFO.p_delivery_id);
109: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_order_num_l);
110: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_order_num_h);
111: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_move_order_l);
112: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_move_order_h);
105: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.dleg_id',P_DOCUMENT_PARAM_INFO.p_delivery_leg_id);
106: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.bol_num',P_DOCUMENT_PARAM_INFO.p_bill_of_lading_number);
107: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_stop_id',P_DOCUMENT_PARAM_INFO.p_trip_stop_id);
108: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.delivery_id',P_DOCUMENT_PARAM_INFO.p_delivery_id);
109: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_order_num_l);
110: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_order_num_h);
111: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_move_order_l);
112: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_move_order_h);
113: */
106: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.bol_num',P_DOCUMENT_PARAM_INFO.p_bill_of_lading_number);
107: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_stop_id',P_DOCUMENT_PARAM_INFO.p_trip_stop_id);
108: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.delivery_id',P_DOCUMENT_PARAM_INFO.p_delivery_id);
109: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_order_num_l);
110: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_order_num_h);
111: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_move_order_l);
112: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_move_order_h);
113: */
114:
107: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.trip_stop_id',P_DOCUMENT_PARAM_INFO.p_trip_stop_id);
108: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.delivery_id',P_DOCUMENT_PARAM_INFO.p_delivery_id);
109: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_order_num_l);
110: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_order_num_h);
111: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_move_order_l);
112: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_move_order_h);
113: */
114:
115: WSH_DEBUG_SV.log(l_module_name,'X_RETURN_STATUS',X_RETURN_STATUS);
108: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.delivery_id',P_DOCUMENT_PARAM_INFO.p_delivery_id);
109: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_order_num_l);
110: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_order_num_h);
111: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_move_order_l);
112: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_move_order_h);
113: */
114:
115: WSH_DEBUG_SV.log(l_module_name,'X_RETURN_STATUS',X_RETURN_STATUS);
116: END IF;
111: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Lo',P_DOCUMENT_PARAM_INFO.p_move_order_l);
112: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_PARAM_INFO.Move_Order_Num_Hi',P_DOCUMENT_PARAM_INFO.p_move_order_h);
113: */
114:
115: WSH_DEBUG_SV.log(l_module_name,'X_RETURN_STATUS',X_RETURN_STATUS);
116: END IF;
117: --
118: DECLARE
119: l_shipping_style VARCHAR2(15);
494: l_main_conc_request_id := null;
495: end if;
496:
497: IF l_debug_on THEN
498: WSH_DEBUG_SV.logmsg(l_module_name,'entity_count is ' || entity_count );
499: END IF;
500: --
501: if (entity_count > 0) then --{ populate l_doc_set_params with entity information
502:
552: end loop;
553: end if; --{ finished populating l_doc_set_params with entity information
554:
555: IF l_debug_on THEN
556: WSH_DEBUG_SV.logmsg(l_module_name,'doc set param counts is ' || l_doc_set_params.COUNT);
557: END IF;
558: --
559: FOR i IN 1..l_doc_set_params.COUNT LOOP
560:
565: --
566: -- Debug Statements
567: --
568: IF l_debug_on THEN
569: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
570: END IF;
571: --
572: entity_name := WSH_TRIPS_PVT.Get_Name(p_trip_ids(i));
573: elsif (p_stop_ids.count <> 0) then
574: --
575: -- Debug Statements
576: --
577: IF l_debug_on THEN
578: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
579: END IF;
580: --
581: entity_name := WSH_TRIP_STOPS_PVT.Get_Name(p_stop_ids(i));
582:
593: --
594: -- Debug Statements
595: --
596: IF l_debug_on THEN
597: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
598: END IF;
599: --
600: entity_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_ids(i));
601:
633: l_copies := coalesce(document.number_of_copies,to_number(FND_PROFILE.VALUE('CONC_COPIES')),0); --Bug 9733286
634:
635: --
636: IF l_debug_on THEN
637: WSH_DEBUG_SV.logmsg(l_module_name, 'Report Set Id is :'||l_doc_set_params(i).p_report_set_id );
638: WSH_DEBUG_SV.logmsg(l_module_name, 'CONC PROGRAM IS :'||l_concurrent_program_name );
639: WSH_DEBUG_SV.logmsg(l_module_name, 'l_printer_name IS :'||l_printer_name);
640: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES for current doc :'||L_COPIES );
641: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES from fnd profile :'|| to_number(NVL(FND_PROFILE.VALUE('CONC_COPIES'),'0')) );
634:
635: --
636: IF l_debug_on THEN
637: WSH_DEBUG_SV.logmsg(l_module_name, 'Report Set Id is :'||l_doc_set_params(i).p_report_set_id );
638: WSH_DEBUG_SV.logmsg(l_module_name, 'CONC PROGRAM IS :'||l_concurrent_program_name );
639: WSH_DEBUG_SV.logmsg(l_module_name, 'l_printer_name IS :'||l_printer_name);
640: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES for current doc :'||L_COPIES );
641: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES from fnd profile :'|| to_number(NVL(FND_PROFILE.VALUE('CONC_COPIES'),'0')) );
642: END IF;
635: --
636: IF l_debug_on THEN
637: WSH_DEBUG_SV.logmsg(l_module_name, 'Report Set Id is :'||l_doc_set_params(i).p_report_set_id );
638: WSH_DEBUG_SV.logmsg(l_module_name, 'CONC PROGRAM IS :'||l_concurrent_program_name );
639: WSH_DEBUG_SV.logmsg(l_module_name, 'l_printer_name IS :'||l_printer_name);
640: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES for current doc :'||L_COPIES );
641: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES from fnd profile :'|| to_number(NVL(FND_PROFILE.VALUE('CONC_COPIES'),'0')) );
642: END IF;
643:
636: IF l_debug_on THEN
637: WSH_DEBUG_SV.logmsg(l_module_name, 'Report Set Id is :'||l_doc_set_params(i).p_report_set_id );
638: WSH_DEBUG_SV.logmsg(l_module_name, 'CONC PROGRAM IS :'||l_concurrent_program_name );
639: WSH_DEBUG_SV.logmsg(l_module_name, 'l_printer_name IS :'||l_printer_name);
640: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES for current doc :'||L_COPIES );
641: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES from fnd profile :'|| to_number(NVL(FND_PROFILE.VALUE('CONC_COPIES'),'0')) );
642: END IF;
643:
644: -- Debug Statements
637: WSH_DEBUG_SV.logmsg(l_module_name, 'Report Set Id is :'||l_doc_set_params(i).p_report_set_id );
638: WSH_DEBUG_SV.logmsg(l_module_name, 'CONC PROGRAM IS :'||l_concurrent_program_name );
639: WSH_DEBUG_SV.logmsg(l_module_name, 'l_printer_name IS :'||l_printer_name);
640: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES for current doc :'||L_COPIES );
641: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES from fnd profile :'|| to_number(NVL(FND_PROFILE.VALUE('CONC_COPIES'),'0')) );
642: END IF;
643:
644: -- Debug Statements
645: --
643:
644: -- Debug Statements
645: --
646: IF l_debug_on THEN
647: WSH_DEBUG_SV.logmsg(l_module_name, 'NUMBER OF COPIES TO BE PRINTED FOR EACH REPORT '||L_COPIES );
648: END IF;
649: --
650:
651: --
651: --
652: -- Debug Statements
653: --
654: IF l_debug_on THEN
655: WSH_DEBUG_SV.logmsg(l_module_name, 'PROCESSING DOCUMENT ' || L_CONCURRENT_PROGRAM_NAME );
656: END IF;
657: --
658:
659: -- Assigning current doc set params to language parameters
694: --
695: -- Debug Statements
696: --
697: IF l_debug_on THEN
698: WSH_DEBUG_SV.logmsg(l_module_name, 'ARGUMENT NAME ' || L_ARG_NAME );
699: END IF;
700: --
701: --
702: -- Debug Statements
701: --
702: -- Debug Statements
703: --
704: IF l_debug_on THEN
705: WSH_DEBUG_SV.logmsg(l_module_name, 'ARGUMENT VALUE ' || L_ARG_VALUE );
706: END IF;
707: --
708: --
709: -- Debug Statements
708: --
709: -- Debug Statements
710: --
711: IF l_debug_on THEN
712: WSH_DEBUG_SV.logmsg(l_module_name, 'ARGUMENT REQUIRED ' || L_ARG_REQUIRED_FLAG );
713: END IF;
714: --
715:
716: l_argument_name ( l_arg_cnt ) := l_arg_name ;
723: --
724: -- Debug Statements
725: --
726: IF l_debug_on THEN
727: WSH_DEBUG_SV.logmsg(l_module_name, 'ARGUMENT NAME ' || L_ARG_NAME||' VALUE:'||TO_CHAR ( L_ARG_CNT ) ||':'||L_ARGUMENT ( L_ARG_CNT ) );
728: END IF;
729: --
730:
731: IF l_argument(l_arg_cnt) IS NULL THEN
732: --
733: -- Debug Statements
734: --
735: IF l_debug_on THEN
736: WSH_DEBUG_SV.logmsg(l_module_name, 'ARG DEFAULT TYPE ' || L_ARG_DEFAULT_TYPE );
737: END IF;
738: --
739: IF l_arg_default_type = 'C' THEN -- Constant
740: l_argument(l_arg_cnt) := l_arg_default_value;
746: -- flex field, this will cause an error in which case continue
747: BEGIN
748: -- Added for the bug 16476696 to avoid parsing errors
749: IF l_debug_on THEN
750: WSH_DEBUG_SV.logmsg(l_module_name, 'ARG DEFAULT VALUE ' || l_arg_default_value );
751: END IF;
752: l_default_value_chk := INSTR( l_arg_default_value ,'$FLEX$');
753: IF l_debug_on THEN
754: WSH_DEBUG_SV.logmsg(l_module_name, 'l_default_value_chk ' || l_default_value_chk );
750: WSH_DEBUG_SV.logmsg(l_module_name, 'ARG DEFAULT VALUE ' || l_arg_default_value );
751: END IF;
752: l_default_value_chk := INSTR( l_arg_default_value ,'$FLEX$');
753: IF l_debug_on THEN
754: WSH_DEBUG_SV.logmsg(l_module_name, 'l_default_value_chk ' || l_default_value_chk );
755: END IF;
756: IF l_default_value_chk = 0 THEN
757: -- End of Added for the bug 16476696 to avoid parsing errors
758: BEGIN
826: --
827: -- Debug Statements
828: --
829: IF l_debug_on THEN
830: WSH_DEBUG_SV.logmsg(l_module_name, 'L_PARAMETER_NAME:' || L_PARAMETER_NAME );
831: END IF;
832: --
833: IF l_parameter_name NOT IN
834: (
844: --
845: -- Debug Statements
846: --
847: IF l_debug_on THEN
848: WSH_DEBUG_SV.logmsg(l_module_name, ' CHECK ARG NAME ' || L_ARG_NAME||' VALUE:'||TO_CHAR ( L_ARG_CNT ) ||':'||L_ARGUMENT ( L_ARG_CNT ) );
849: END IF;
850: --
851: -- if still null and its required then raise appropriate error
852: IF (l_argument(l_arg_cnt) IS NULL) AND l_arg_required_flag = 'Y' THEN
893: --
894: -- Debug Statements
895: --
896: IF l_debug_on THEN
897: WSH_DEBUG_SV.logmsg(l_module_name, 'L_VALID_PARAMS IS TRUE' );
898: END IF;
899: --
900: else
901: --
901: --
902: -- Debug Statements
903: --
904: IF l_debug_on THEN
905: WSH_DEBUG_SV.logmsg(l_module_name, 'L_VALID_PARAMS IS FALSE' );
906: END IF;
907: --
908: end if;
909:
918: --
919: -- Debug Statements
920: --
921: IF l_debug_on THEN
922: WSH_DEBUG_SV.logmsg(l_module_name, 'L_NON_DEFAULT_PARAMS IS TRUE' );
923: END IF;
924: --
925: else
926: --
926: --
927: -- Debug Statements
928: --
929: IF l_debug_on THEN
930: WSH_DEBUG_SV.logmsg(l_module_name, 'L_NON_DEFAULT_PARAMS IS FALSE' );
931: END IF;
932: --
933: end if;
934: IF NOT(l_non_default_params)
936: --
937: -- Debug Statements
938: --
939: IF l_debug_on THEN
940: WSH_DEBUG_SV.logmsg(l_module_name, 'THE DOCUMENT ' || L_CONCURRENT_PROGRAM_NAME || ' DOES NOT HAVE A PARAM SPECIFIED.' );
941: END IF;
942: --
943: l_valid_params := FALSE;
944: x_return_status := wsh_util_core.g_ret_sts_warning;
968: --
969: -- Debug Statements
970: --
971: IF l_debug_on THEN --{
972: WSH_DEBUG_SV.logmsg(l_module_name, 'THE DOCUMENT ' || L_CONCURRENT_PROGRAM_NAME || ' HAVE A PARAM SPECIFIED.' );
973: END IF; --}
974: --
975:
976: IF document.print_flag = 'Y' THEN --{
978: --
979: -- Debug Statements
980: --
981: IF l_debug_on THEN --{
982: 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 ) );
983: END IF; --}
984: --
985:
986: if ( l_printer_name IS NULL or l_printer_name = '-1' ) then --{
987: --
988: -- Debug Statements
989: --
990: IF l_debug_on THEN --{
991: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REPORT_PRINTERS_PVT.GET_PRINTER',WSH_DEBUG_SV.C_PROC_LEVEL);
992: END IF; --}
993: --
994: WSH_REPORT_PRINTERS_PVT.Get_Printer(p_concurrent_program_id => document.concurrent_program_id,
995: p_organization_id => l_organization_id , -- Bug 3534965(3510460 Frontport)
1007:
1008:
1009: IF l_error_message IS NOT NULL THEN --{
1010: IF l_debug_on THEN
1011: WSH_DEBUG_SV.logmsg(l_module_name, 'GET_PRINTER: ' || l_error_message);
1012: END IF;
1013: END IF; --}
1014:
1015: IF l_printer_name IS NULL OR l_printer_name = 'No Printer' THEN --{
1017: --
1018: -- Debug Statements
1019: --
1020: IF l_debug_on THEN --{
1021: WSH_DEBUG_SV.logmsg(l_module_name, 'PRINTER NAME IS NULL AND THE DEFAULT PRINTER IS '||L_PRINTER_NAME );
1022: END IF; --}
1023: --
1024: END IF; --}
1025:
1033: END IF ; --} if l_printer_name is null
1034:
1035: IF (document.CONCURRENT_PROGRAM_NAME NOT IN ('WSHRDPIK' ,'WSHRDPIKX','WSHRDPIK_XML') or WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.count = 0 ) then --{
1036: IF l_debug_on THEN --{
1037: WSH_DEBUG_SV.logmsg(l_module_name, DOCUMENT.CONCURRENT_PROGRAM_NAME || ' and no printers setup ' );
1038: END IF; --}
1039: --
1040: IF l_debug_on THEN --{
1041: WSH_DEBUG_SV.logmsg(l_module_name, l_copies || ' copies of ' || DOCUMENT.CONCURRENT_PROGRAM_NAME||' WILL BE PRINTED ON PRINTER '||L_PRINTER_NAME );
1037: WSH_DEBUG_SV.logmsg(l_module_name, DOCUMENT.CONCURRENT_PROGRAM_NAME || ' and no printers setup ' );
1038: END IF; --}
1039: --
1040: IF l_debug_on THEN --{
1041: WSH_DEBUG_SV.logmsg(l_module_name, l_copies || ' copies of ' || DOCUMENT.CONCURRENT_PROGRAM_NAME||' WILL BE PRINTED ON PRINTER '||L_PRINTER_NAME );
1042: END IF; --}
1043: --
1044: l_printer_setup :=
1045: fnd_request.set_print_options
1048: l_copies,
1049: l_save_output,
1050: 'N');
1051: if ( NOT l_printer_setup and l_debug_on ) then --{
1052: WSH_DEBUG_SV.logmsg(l_module_name, ' Set_Print_Options Returned False !!!!');
1053: end if ; --}
1054: END IF ; --}
1055: END IF; --} If document.print_flag = 'Y'
1056:
1062: -- Getting language if document has MLS function associated with it
1063: IF document.mls_executable_id IS NOT NULL THEN
1064: l_nls_lang.delete;
1065: IF l_debug_on THEN --{
1066: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_EXTREPS_MLS_LANG.Get_NLS_Lang ' );
1067: END IF; --}
1068: WSH_EXTREPS_MLS_LANG.Get_NLS_Lang (
1069: p_prog_name => document.concurrent_program_name,
1070: p_doc_param_info => l_lang_doc_params_info,
1073: x_return_status => x_return_status
1074: );
1075: IF x_return_status IN ( fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error ) THEN
1076: IF l_debug_on THEN --{
1077: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returning from Get_NLS_Lang :'||x_return_status );
1078: END IF; --}
1079: wsh_util_core.add_message(x_return_status);
1080: END IF;
1081: IF l_debug_on THEN --{
1078: END IF; --}
1079: wsh_util_core.add_message(x_return_status);
1080: END IF;
1081: IF l_debug_on THEN --{
1082: WSH_DEBUG_SV.logmsg(l_module_name, 'Number of NLS languages :'||l_nls_lang.COUNT );
1083: END IF; --}
1084: END IF;
1085:
1086: l_submitted := FALSE;
1092: IF l_nls_count <= l_nls_lang.COUNT THEN
1093: /* set the language and territory for this request
1094: all individual requests are protected against updates */
1095: IF l_debug_on THEN --{
1096: WSH_DEBUG_SV.logmsg(l_module_name, 'Setting option for language : '||l_nls_lang(l_nls_count).nls_language);
1097: END IF; --}
1098:
1099: --bug 13077928
1100: fnd_profile.get('ICX_NUMERIC_CHARACTERS', l_NUMERIC_Characters);
1099: --bug 13077928
1100: fnd_profile.get('ICX_NUMERIC_CHARACTERS', l_NUMERIC_Characters);
1101:
1102: IF l_debug_on THEN --{
1103: WSH_DEBUG_SV.logmsg(l_module_name, 'l_NUMERIC_Characters :'||l_NUMERIC_Characters );
1104: END IF; --}
1105:
1106: if ( not fnd_request.set_options(
1107: implicit => 'NO',
1110: territory => l_nls_lang(l_nls_count).nls_territory,
1111: numeric_characters => l_numeric_characters)) then
1112: IF l_debug_on THEN --{
1113:
1114: WSH_DEBUG_SV.logmsg(l_module_name, 'fnd_request.set_options returned false');
1115: END IF; --}
1116: wsh_util_core.add_message(x_return_status);
1117: raise no_data_found ;
1118: end if;
1129: -- document number are generated before submitting request
1130:
1131: IF document.concurrent_program_name = 'WSHRDMBL' THEN
1132: IF l_debug_on THEN
1133: WSH_DEBUG_SV.logmsg(l_module_name, 'p_trip_id for Master BOL = ' ||l_argument(1));
1134: END IF;
1135: WSH_MBOLS_PVT.Generate_MBOL(
1136: p_trip_id => l_argument(1),
1137: x_sequence_number => l_document_number,
1148: AND ( nvl(l_doc_set_params(i).bol_error_flag,'N') = 'N') THEN
1149:
1150: IF l_argument(6) is not null THEN
1151: IF l_debug_on THEN
1152: WSH_DEBUG_SV.logmsg(l_module_name, 'p_trip_id for BOL = ' ||l_argument(6));
1153: END IF;
1154: WSH_MBOLS_PVT.Generate_BOLs(
1155: p_trip_id => l_argument(6),
1156: x_return_status => l_return_status );
1169: l_ship_method_code,
1170: l_pickup_location_id,
1171: l_trip_name;
1172: IF l_debug_on THEN
1173: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_id for BOL = ' ||l_delivery_id);
1174: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_leg_id for BOL = ' ||l_delivery_leg_id);
1175: WSH_DEBUG_SV.logmsg(l_module_name, 'l_ship_method_code for BOL = ' ||l_ship_method_code);
1176: WSH_DEBUG_SV.logmsg(l_module_name, 'l_pickup_location_id for BOL = ' ||l_pickup_location_id);
1177: WSH_DEBUG_SV.logmsg(l_module_name, 'l_trip_name for BOL = ' ||l_trip_name);
1170: l_pickup_location_id,
1171: l_trip_name;
1172: IF l_debug_on THEN
1173: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_id for BOL = ' ||l_delivery_id);
1174: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_leg_id for BOL = ' ||l_delivery_leg_id);
1175: WSH_DEBUG_SV.logmsg(l_module_name, 'l_ship_method_code for BOL = ' ||l_ship_method_code);
1176: WSH_DEBUG_SV.logmsg(l_module_name, 'l_pickup_location_id for BOL = ' ||l_pickup_location_id);
1177: WSH_DEBUG_SV.logmsg(l_module_name, 'l_trip_name for BOL = ' ||l_trip_name);
1178: END IF;
1171: l_trip_name;
1172: IF l_debug_on THEN
1173: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_id for BOL = ' ||l_delivery_id);
1174: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_leg_id for BOL = ' ||l_delivery_leg_id);
1175: WSH_DEBUG_SV.logmsg(l_module_name, 'l_ship_method_code for BOL = ' ||l_ship_method_code);
1176: WSH_DEBUG_SV.logmsg(l_module_name, 'l_pickup_location_id for BOL = ' ||l_pickup_location_id);
1177: WSH_DEBUG_SV.logmsg(l_module_name, 'l_trip_name for BOL = ' ||l_trip_name);
1178: END IF;
1179: EXIT WHEN c_get_delivery_info%NOTFOUND;
1172: IF l_debug_on THEN
1173: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_id for BOL = ' ||l_delivery_id);
1174: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_leg_id for BOL = ' ||l_delivery_leg_id);
1175: WSH_DEBUG_SV.logmsg(l_module_name, 'l_ship_method_code for BOL = ' ||l_ship_method_code);
1176: WSH_DEBUG_SV.logmsg(l_module_name, 'l_pickup_location_id for BOL = ' ||l_pickup_location_id);
1177: WSH_DEBUG_SV.logmsg(l_module_name, 'l_trip_name for BOL = ' ||l_trip_name);
1178: END IF;
1179: EXIT WHEN c_get_delivery_info%NOTFOUND;
1180:
1173: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_id for BOL = ' ||l_delivery_id);
1174: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_leg_id for BOL = ' ||l_delivery_leg_id);
1175: WSH_DEBUG_SV.logmsg(l_module_name, 'l_ship_method_code for BOL = ' ||l_ship_method_code);
1176: WSH_DEBUG_SV.logmsg(l_module_name, 'l_pickup_location_id for BOL = ' ||l_pickup_location_id);
1177: WSH_DEBUG_SV.logmsg(l_module_name, 'l_trip_name for BOL = ' ||l_trip_name);
1178: END IF;
1179: EXIT WHEN c_get_delivery_info%NOTFOUND;
1180:
1181: SELECT count(*)
1192: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
1193: x_return_status := wsh_util_core.g_ret_sts_error;
1194: wsh_util_core.add_message(x_return_status);
1195: IF l_debug_on THEN
1196: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status for BOL = '||x_return_status);
1197: END IF;
1198: IF c_get_delivery_info%ISOPEN THEN
1199: CLOSE c_get_delivery_info;
1200: END IF;
1268: -- LE Uptake
1269: open m_get_ledger_id(l_argument(2));
1270: fetch m_get_ledger_id INTO l_ledger_id;
1271: IF l_debug_on THEN
1272: WSH_DEBUG_SV.logmsg(l_module_name,'l_ledger_id = '||l_ledger_id);
1273: END IF;
1274:
1275: IF m_get_ledger_id%NOTFOUND THEN
1276: FND_MESSAGE.SET_NAME('WSH','WSH_LEDGER_ID_NOT_FOUND');
1315: l_print_pdf := 'N';
1316: IF(l_output_file_type = 'XML' ) THEN
1317: --{
1318: IF l_debug_on THEN
1319: WSH_DEBUG_SV.logmsg(l_module_name, 'template' || l_template_code);
1320: END IF;
1321: --
1322: IF (l_template_code is not NULL) then
1323: --{
1332: where language_code = userenv('LANG');
1333: END IF;
1334: --
1335: IF l_debug_on THEN
1336: WSH_DEBUG_SV.logmsg(l_module_name, 'language ' || l_language );
1337: WSH_DEBUG_SV.logmsg(l_module_name, 'territory ' || l_territory);
1338: WSH_DEBUG_SV.logmsg(l_module_name, 'xml_nls_language ' || l_xml_nls_language);
1339: WSH_DEBUG_SV.logmsg(l_module_name, 'concurrent_program_name ' || document.concurrent_program_name);
1340: WSH_DEBUG_SV.logmsg(l_module_name, 'l_appl_short_name : '||l_appl_short_name);
1333: END IF;
1334: --
1335: IF l_debug_on THEN
1336: WSH_DEBUG_SV.logmsg(l_module_name, 'language ' || l_language );
1337: WSH_DEBUG_SV.logmsg(l_module_name, 'territory ' || l_territory);
1338: WSH_DEBUG_SV.logmsg(l_module_name, 'xml_nls_language ' || l_xml_nls_language);
1339: WSH_DEBUG_SV.logmsg(l_module_name, 'concurrent_program_name ' || document.concurrent_program_name);
1340: WSH_DEBUG_SV.logmsg(l_module_name, 'l_appl_short_name : '||l_appl_short_name);
1341: END IF;
1334: --
1335: IF l_debug_on THEN
1336: WSH_DEBUG_SV.logmsg(l_module_name, 'language ' || l_language );
1337: WSH_DEBUG_SV.logmsg(l_module_name, 'territory ' || l_territory);
1338: WSH_DEBUG_SV.logmsg(l_module_name, 'xml_nls_language ' || l_xml_nls_language);
1339: WSH_DEBUG_SV.logmsg(l_module_name, 'concurrent_program_name ' || document.concurrent_program_name);
1340: WSH_DEBUG_SV.logmsg(l_module_name, 'l_appl_short_name : '||l_appl_short_name);
1341: END IF;
1342: --
1335: IF l_debug_on THEN
1336: WSH_DEBUG_SV.logmsg(l_module_name, 'language ' || l_language );
1337: WSH_DEBUG_SV.logmsg(l_module_name, 'territory ' || l_territory);
1338: WSH_DEBUG_SV.logmsg(l_module_name, 'xml_nls_language ' || l_xml_nls_language);
1339: WSH_DEBUG_SV.logmsg(l_module_name, 'concurrent_program_name ' || document.concurrent_program_name);
1340: WSH_DEBUG_SV.logmsg(l_module_name, 'l_appl_short_name : '||l_appl_short_name);
1341: END IF;
1342: --
1343: --Bugfix 14520383 Start
1336: WSH_DEBUG_SV.logmsg(l_module_name, 'language ' || l_language );
1337: WSH_DEBUG_SV.logmsg(l_module_name, 'territory ' || l_territory);
1338: WSH_DEBUG_SV.logmsg(l_module_name, 'xml_nls_language ' || l_xml_nls_language);
1339: WSH_DEBUG_SV.logmsg(l_module_name, 'concurrent_program_name ' || document.concurrent_program_name);
1340: WSH_DEBUG_SV.logmsg(l_module_name, 'l_appl_short_name : '||l_appl_short_name);
1341: END IF;
1342: --
1343: --Bugfix 14520383 Start
1344: l_xml_template_obtained:= NULL;
1373: format_type =>l_xml_format_type,
1374: def_output_type =>l_xml_def_output_type) ;
1375:
1376: IF l_debug_on THEN
1377: WSH_DEBUG_SV.logmsg(l_module_name,'template_obtained : '||l_xml_template_obtained);
1378: WSH_DEBUG_SV.logmsg(l_module_name,'template_name : '||l_xml_template_name);
1379: WSH_DEBUG_SV.logmsg(l_module_name,'template_language : '||l_xml_template_language);
1380: WSH_DEBUG_SV.logmsg(l_module_name,'format : '||l_xml_format);
1381: WSH_DEBUG_SV.logmsg(l_module_name,'request_language : '||l_xml_request_language);
1374: def_output_type =>l_xml_def_output_type) ;
1375:
1376: IF l_debug_on THEN
1377: WSH_DEBUG_SV.logmsg(l_module_name,'template_obtained : '||l_xml_template_obtained);
1378: WSH_DEBUG_SV.logmsg(l_module_name,'template_name : '||l_xml_template_name);
1379: WSH_DEBUG_SV.logmsg(l_module_name,'template_language : '||l_xml_template_language);
1380: WSH_DEBUG_SV.logmsg(l_module_name,'format : '||l_xml_format);
1381: WSH_DEBUG_SV.logmsg(l_module_name,'request_language : '||l_xml_request_language);
1382: WSH_DEBUG_SV.logmsg(l_module_name,'iso_language : '||l_xml_iso_language);
1375:
1376: IF l_debug_on THEN
1377: WSH_DEBUG_SV.logmsg(l_module_name,'template_obtained : '||l_xml_template_obtained);
1378: WSH_DEBUG_SV.logmsg(l_module_name,'template_name : '||l_xml_template_name);
1379: WSH_DEBUG_SV.logmsg(l_module_name,'template_language : '||l_xml_template_language);
1380: WSH_DEBUG_SV.logmsg(l_module_name,'format : '||l_xml_format);
1381: WSH_DEBUG_SV.logmsg(l_module_name,'request_language : '||l_xml_request_language);
1382: WSH_DEBUG_SV.logmsg(l_module_name,'iso_language : '||l_xml_iso_language);
1383: WSH_DEBUG_SV.logmsg(l_module_name,'iso_territory : '||l_xml_iso_territory);
1376: IF l_debug_on THEN
1377: WSH_DEBUG_SV.logmsg(l_module_name,'template_obtained : '||l_xml_template_obtained);
1378: WSH_DEBUG_SV.logmsg(l_module_name,'template_name : '||l_xml_template_name);
1379: WSH_DEBUG_SV.logmsg(l_module_name,'template_language : '||l_xml_template_language);
1380: WSH_DEBUG_SV.logmsg(l_module_name,'format : '||l_xml_format);
1381: WSH_DEBUG_SV.logmsg(l_module_name,'request_language : '||l_xml_request_language);
1382: WSH_DEBUG_SV.logmsg(l_module_name,'iso_language : '||l_xml_iso_language);
1383: WSH_DEBUG_SV.logmsg(l_module_name,'iso_territory : '||l_xml_iso_territory);
1384: WSH_DEBUG_SV.logmsg(l_module_name,'template_app_name : '||l_xml_template_app_name);
1377: WSH_DEBUG_SV.logmsg(l_module_name,'template_obtained : '||l_xml_template_obtained);
1378: WSH_DEBUG_SV.logmsg(l_module_name,'template_name : '||l_xml_template_name);
1379: WSH_DEBUG_SV.logmsg(l_module_name,'template_language : '||l_xml_template_language);
1380: WSH_DEBUG_SV.logmsg(l_module_name,'format : '||l_xml_format);
1381: WSH_DEBUG_SV.logmsg(l_module_name,'request_language : '||l_xml_request_language);
1382: WSH_DEBUG_SV.logmsg(l_module_name,'iso_language : '||l_xml_iso_language);
1383: WSH_DEBUG_SV.logmsg(l_module_name,'iso_territory : '||l_xml_iso_territory);
1384: WSH_DEBUG_SV.logmsg(l_module_name,'template_app_name : '||l_xml_template_app_name);
1385: WSH_DEBUG_SV.logmsg(l_module_name,'template_code : '||l_xml_template_code);
1378: WSH_DEBUG_SV.logmsg(l_module_name,'template_name : '||l_xml_template_name);
1379: WSH_DEBUG_SV.logmsg(l_module_name,'template_language : '||l_xml_template_language);
1380: WSH_DEBUG_SV.logmsg(l_module_name,'format : '||l_xml_format);
1381: WSH_DEBUG_SV.logmsg(l_module_name,'request_language : '||l_xml_request_language);
1382: WSH_DEBUG_SV.logmsg(l_module_name,'iso_language : '||l_xml_iso_language);
1383: WSH_DEBUG_SV.logmsg(l_module_name,'iso_territory : '||l_xml_iso_territory);
1384: WSH_DEBUG_SV.logmsg(l_module_name,'template_app_name : '||l_xml_template_app_name);
1385: WSH_DEBUG_SV.logmsg(l_module_name,'template_code : '||l_xml_template_code);
1386: WSH_DEBUG_SV.logmsg(l_module_name,'format_type : '||l_xml_format_type);
1379: WSH_DEBUG_SV.logmsg(l_module_name,'template_language : '||l_xml_template_language);
1380: WSH_DEBUG_SV.logmsg(l_module_name,'format : '||l_xml_format);
1381: WSH_DEBUG_SV.logmsg(l_module_name,'request_language : '||l_xml_request_language);
1382: WSH_DEBUG_SV.logmsg(l_module_name,'iso_language : '||l_xml_iso_language);
1383: WSH_DEBUG_SV.logmsg(l_module_name,'iso_territory : '||l_xml_iso_territory);
1384: WSH_DEBUG_SV.logmsg(l_module_name,'template_app_name : '||l_xml_template_app_name);
1385: WSH_DEBUG_SV.logmsg(l_module_name,'template_code : '||l_xml_template_code);
1386: WSH_DEBUG_SV.logmsg(l_module_name,'format_type : '||l_xml_format_type);
1387: WSH_DEBUG_SV.logmsg(l_module_name,'def_output_type : '||l_xml_def_output_type);
1380: WSH_DEBUG_SV.logmsg(l_module_name,'format : '||l_xml_format);
1381: WSH_DEBUG_SV.logmsg(l_module_name,'request_language : '||l_xml_request_language);
1382: WSH_DEBUG_SV.logmsg(l_module_name,'iso_language : '||l_xml_iso_language);
1383: WSH_DEBUG_SV.logmsg(l_module_name,'iso_territory : '||l_xml_iso_territory);
1384: WSH_DEBUG_SV.logmsg(l_module_name,'template_app_name : '||l_xml_template_app_name);
1385: WSH_DEBUG_SV.logmsg(l_module_name,'template_code : '||l_xml_template_code);
1386: WSH_DEBUG_SV.logmsg(l_module_name,'format_type : '||l_xml_format_type);
1387: WSH_DEBUG_SV.logmsg(l_module_name,'def_output_type : '||l_xml_def_output_type);
1388: END IF;
1381: WSH_DEBUG_SV.logmsg(l_module_name,'request_language : '||l_xml_request_language);
1382: WSH_DEBUG_SV.logmsg(l_module_name,'iso_language : '||l_xml_iso_language);
1383: WSH_DEBUG_SV.logmsg(l_module_name,'iso_territory : '||l_xml_iso_territory);
1384: WSH_DEBUG_SV.logmsg(l_module_name,'template_app_name : '||l_xml_template_app_name);
1385: WSH_DEBUG_SV.logmsg(l_module_name,'template_code : '||l_xml_template_code);
1386: WSH_DEBUG_SV.logmsg(l_module_name,'format_type : '||l_xml_format_type);
1387: WSH_DEBUG_SV.logmsg(l_module_name,'def_output_type : '||l_xml_def_output_type);
1388: END IF;
1389:
1382: WSH_DEBUG_SV.logmsg(l_module_name,'iso_language : '||l_xml_iso_language);
1383: WSH_DEBUG_SV.logmsg(l_module_name,'iso_territory : '||l_xml_iso_territory);
1384: WSH_DEBUG_SV.logmsg(l_module_name,'template_app_name : '||l_xml_template_app_name);
1385: WSH_DEBUG_SV.logmsg(l_module_name,'template_code : '||l_xml_template_code);
1386: WSH_DEBUG_SV.logmsg(l_module_name,'format_type : '||l_xml_format_type);
1387: WSH_DEBUG_SV.logmsg(l_module_name,'def_output_type : '||l_xml_def_output_type);
1388: END IF;
1389:
1390: IF l_xml_def_output_type is NOT NULL THEN
1383: WSH_DEBUG_SV.logmsg(l_module_name,'iso_territory : '||l_xml_iso_territory);
1384: WSH_DEBUG_SV.logmsg(l_module_name,'template_app_name : '||l_xml_template_app_name);
1385: WSH_DEBUG_SV.logmsg(l_module_name,'template_code : '||l_xml_template_code);
1386: WSH_DEBUG_SV.logmsg(l_module_name,'format_type : '||l_xml_format_type);
1387: WSH_DEBUG_SV.logmsg(l_module_name,'def_output_type : '||l_xml_def_output_type);
1388: END IF;
1389:
1390: IF l_xml_def_output_type is NOT NULL THEN
1391: l_ret_status :=fnd_request.add_layout(l_appl_short_name,
1405: IF l_ret_status THEN
1406: l_print_pdf := 'Y';
1407: ELSE
1408: IF l_debug_on THEN
1409: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returning from fnd_request.add_layout :'||x_return_status);
1410: END IF;
1411: wsh_util_core.add_message(x_return_status);
1412: END IF;
1413: --}
1413: --}
1414: ELSE
1415: --{
1416: IF l_debug_on THEN
1417: WSH_DEBUG_SV.logmsg(l_module_name, 'No template was specified for this report. Hence could not generate the pdf output' );
1418: END IF;
1419: --
1420: --Bug 9255258 continue with report submission.
1421: /*fnd_message.set_name('WSH', 'WSH_NO_DEFAULT_TEMPLATE');
1453: --
1454: -- Debug Statements
1455: --
1456: IF l_debug_on THEN --{
1457: WSH_DEBUG_SV.logmsg(l_module_name, 'SUBMITTED '|| DOCUMENT.CONCURRENT_PROGRAM_NAME||' WITH REQUEST_ID:'||TO_CHAR ( L_REQUEST_ID ) );
1458: END IF; --}
1459: --
1460: -- increase the counter if successful
1461: IF l_request_id > 0 THEN --{
1465: --
1466: -- Debug Statements
1467: --
1468: IF l_debug_on THEN --{
1469: WSH_DEBUG_SV.logmsg(l_module_name, 'REQUEST ID ' || TO_CHAR ( L_REQUEST_ID ) );
1470: END IF; --}
1471: --
1472:
1473: if (entity_count > 0) then --{
1520: END LOOP; -- end of l_submitted loop
1521:
1522: ELSE -- It is WSHRDPIK and G_PRINTERTAB has been populated
1523: IF l_debug_on THEN --{
1524: WSH_DEBUG_SV.logmsg(l_module_name, ' Else Pick Slip Report the number of printers is ' || WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.count );
1525: END IF; --}
1526: --
1527: -- Find position of 'Printer Name' in the arguments
1528:
1528:
1529: l_printer_pos := -1 ;
1530: for j in 1..l_argument_name.count loop
1531: IF l_debug_on THEN --{
1532: WSH_DEBUG_SV.logmsg(l_module_name, 'Argument name ' || l_argument_name (j) );
1533: END IF; --}
1534: --
1535: if l_argument_name(j) = 'Printer Name' then
1536: l_printer_pos := j;
1534: --
1535: if l_argument_name(j) = 'Printer Name' then
1536: l_printer_pos := j;
1537: IF l_debug_on THEN --{
1538: WSH_DEBUG_SV.logmsg(l_module_name, 'Found printer name at pos ' || j );
1539: END IF; --}
1540: --
1541: exit ;
1542: end if ;
1545: --bugfix 13384185
1546: FOR i in 1..WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.count LOOP
1547:
1548: IF l_debug_on THEN --{
1549: WSH_DEBUG_SV.logmsg(l_module_name, ' The value for printer name is '|| WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).printer_name );
1550: WSH_DEBUG_SV.logmsg(l_module_name, ' The value for concurrent program name is '|| WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).conc_program_name);
1551: WSH_DEBUG_SV.logmsg(l_module_name, ' The value for document.concurrent_program_name is '|| document.concurrent_program_name);
1552: END IF; --}
1553:
1546: FOR i in 1..WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.count LOOP
1547:
1548: IF l_debug_on THEN --{
1549: WSH_DEBUG_SV.logmsg(l_module_name, ' The value for printer name is '|| WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).printer_name );
1550: WSH_DEBUG_SV.logmsg(l_module_name, ' The value for concurrent program name is '|| WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).conc_program_name);
1551: WSH_DEBUG_SV.logmsg(l_module_name, ' The value for document.concurrent_program_name is '|| document.concurrent_program_name);
1552: END IF; --}
1553:
1554:
1547:
1548: IF l_debug_on THEN --{
1549: WSH_DEBUG_SV.logmsg(l_module_name, ' The value for printer name is '|| WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).printer_name );
1550: WSH_DEBUG_SV.logmsg(l_module_name, ' The value for concurrent program name is '|| WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).conc_program_name);
1551: WSH_DEBUG_SV.logmsg(l_module_name, ' The value for document.concurrent_program_name is '|| document.concurrent_program_name);
1552: END IF; --}
1553:
1554:
1555: IF WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).conc_program_name = document.concurrent_program_name THEN
1556:
1557: l_argument(l_printer_pos) := WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).printer_name;
1558:
1559: IF l_debug_on THEN --{
1560: WSH_DEBUG_SV.logmsg(l_module_name, 'Setting '|| document.concurrent_program_name || ' with ' || l_copies || ' copies on printer ' || WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).printer_name );
1561: --
1562: END IF; --}
1563:
1564: l_printer_setup :=
1569: save_output => l_save_output,
1570: print_together => 'N');
1571:
1572: if ( NOT l_printer_setup and l_debug_on ) then --{
1573: WSH_DEBUG_SV.logmsg(l_module_name, 'For Printer ' || WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).printer_name || ', Set_Print_Options Returned False for Pick Slip Report!!!');
1574: end if ; --}
1575:
1576: -- Getting language if document has MLS function associated with it
1577: IF document.mls_executable_id IS NOT NULL THEN
1576: -- Getting language if document has MLS function associated with it
1577: IF document.mls_executable_id IS NOT NULL THEN
1578: l_nls_lang.delete;
1579: IF l_debug_on THEN --{
1580: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_EXTREPS_MLS_LANG.Get_NLS_Lang ' );
1581: END IF; --}
1582: WSH_EXTREPS_MLS_LANG.Get_NLS_Lang (
1583: p_prog_name => document.concurrent_program_name,
1584: p_doc_param_info => l_lang_doc_params_info,
1587: x_return_status => x_return_status
1588: );
1589: IF x_return_status IN ( fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error ) THEN
1590: IF l_debug_on THEN --{
1591: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returning from Get_NLS_Lang :'||x_return_status
1592: );
1593: END IF; --}
1594: wsh_util_core.add_message(x_return_status);
1595: END IF;
1593: END IF; --}
1594: wsh_util_core.add_message(x_return_status);
1595: END IF;
1596: IF l_debug_on THEN --{
1597: WSH_DEBUG_SV.logmsg(l_module_name, 'Number of NLS languages :'||l_nls_lang.COUNT );
1598: END IF; --}
1599: END IF;
1600:
1601: l_submitted := FALSE;
1612: IF l_nls_count <= l_nls_lang.COUNT THEN
1613: /* set the language and territory for this request
1614: all individual requests are protected against updates */
1615: IF l_debug_on THEN --{
1616: WSH_DEBUG_SV.logmsg(l_module_name, 'Setting option for language : '||l_nls_lang(l_nls_count).nls_language);
1617: END IF; --}
1618:
1619: --bug 13077928
1620: fnd_profile.get('ICX_NUMERIC_CHARACTERS', l_NUMERIC_CHARACTERS);
1619: --bug 13077928
1620: fnd_profile.get('ICX_NUMERIC_CHARACTERS', l_NUMERIC_CHARACTERS);
1621:
1622: IF l_debug_on THEN --{
1623: WSH_DEBUG_SV.logmsg(l_module_name, 'l_NUMERIC_Characters :'||l_NUMERIC_Characters );
1624: END IF; --}
1625:
1626: if ( not fnd_request.set_options(
1627: implicit => 'NO',
1629: language => l_nls_lang(l_nls_count).nls_language,
1630: territory => l_nls_lang(l_nls_count).nls_territory,
1631: numeric_characters => l_numeric_characters)) then
1632: IF l_debug_on THEN --{
1633: WSH_DEBUG_SV.logmsg(l_module_name, 'fnd_request.set_options returned false');
1634: END IF; --}
1635: wsh_util_core.add_message(x_return_status);
1636: raise no_data_found ;
1637: end if;
1648: l_print_pdf := 'N';
1649: IF (l_output_file_type = 'XML' ) then
1650: --{
1651: IF l_debug_on THEN
1652: WSH_DEBUG_SV.logmsg(l_module_name, 'template' || l_template_code);
1653: END IF;
1654: --
1655: IF (l_template_code is not NULL) then
1656: --{
1665: where language_code = userenv('LANG');
1666: END IF;
1667: --
1668: IF l_debug_on THEN
1669: WSH_DEBUG_SV.logmsg(l_module_name, 'language ' || l_language );
1670: WSH_DEBUG_SV.logmsg(l_module_name, 'territory ' || l_territory);
1671: WSH_DEBUG_SV.logmsg(l_module_name, 'xml_nls_language ' || l_xml_nls_language);
1672: WSH_DEBUG_SV.logmsg(l_module_name, 'concurrent_program_name ' || document.concurrent_program_name);
1673: WSH_DEBUG_SV.logmsg(l_module_name, 'l_appl_short_name : '||l_appl_short_name);
1666: END IF;
1667: --
1668: IF l_debug_on THEN
1669: WSH_DEBUG_SV.logmsg(l_module_name, 'language ' || l_language );
1670: WSH_DEBUG_SV.logmsg(l_module_name, 'territory ' || l_territory);
1671: WSH_DEBUG_SV.logmsg(l_module_name, 'xml_nls_language ' || l_xml_nls_language);
1672: WSH_DEBUG_SV.logmsg(l_module_name, 'concurrent_program_name ' || document.concurrent_program_name);
1673: WSH_DEBUG_SV.logmsg(l_module_name, 'l_appl_short_name : '||l_appl_short_name);
1674: END IF;
1667: --
1668: IF l_debug_on THEN
1669: WSH_DEBUG_SV.logmsg(l_module_name, 'language ' || l_language );
1670: WSH_DEBUG_SV.logmsg(l_module_name, 'territory ' || l_territory);
1671: WSH_DEBUG_SV.logmsg(l_module_name, 'xml_nls_language ' || l_xml_nls_language);
1672: WSH_DEBUG_SV.logmsg(l_module_name, 'concurrent_program_name ' || document.concurrent_program_name);
1673: WSH_DEBUG_SV.logmsg(l_module_name, 'l_appl_short_name : '||l_appl_short_name);
1674: END IF;
1675: --
1668: IF l_debug_on THEN
1669: WSH_DEBUG_SV.logmsg(l_module_name, 'language ' || l_language );
1670: WSH_DEBUG_SV.logmsg(l_module_name, 'territory ' || l_territory);
1671: WSH_DEBUG_SV.logmsg(l_module_name, 'xml_nls_language ' || l_xml_nls_language);
1672: WSH_DEBUG_SV.logmsg(l_module_name, 'concurrent_program_name ' || document.concurrent_program_name);
1673: WSH_DEBUG_SV.logmsg(l_module_name, 'l_appl_short_name : '||l_appl_short_name);
1674: END IF;
1675: --
1676: --Bugfix 14520383 Start
1669: WSH_DEBUG_SV.logmsg(l_module_name, 'language ' || l_language );
1670: WSH_DEBUG_SV.logmsg(l_module_name, 'territory ' || l_territory);
1671: WSH_DEBUG_SV.logmsg(l_module_name, 'xml_nls_language ' || l_xml_nls_language);
1672: WSH_DEBUG_SV.logmsg(l_module_name, 'concurrent_program_name ' || document.concurrent_program_name);
1673: WSH_DEBUG_SV.logmsg(l_module_name, 'l_appl_short_name : '||l_appl_short_name);
1674: END IF;
1675: --
1676: --Bugfix 14520383 Start
1677: l_xml_template_obtained:= NULL;
1706: format_type =>l_xml_format_type,
1707: def_output_type =>l_xml_def_output_type) ;
1708:
1709: IF l_debug_on THEN
1710: WSH_DEBUG_SV.logmsg(l_module_name,'template_obtained : '||l_xml_template_obtained);
1711: WSH_DEBUG_SV.logmsg(l_module_name,'template_name : '||l_xml_template_name);
1712: WSH_DEBUG_SV.logmsg(l_module_name,'template_language : '||l_xml_template_language);
1713: WSH_DEBUG_SV.logmsg(l_module_name,'format : '||l_xml_format);
1714: WSH_DEBUG_SV.logmsg(l_module_name,'request_language : '||l_xml_request_language);
1707: def_output_type =>l_xml_def_output_type) ;
1708:
1709: IF l_debug_on THEN
1710: WSH_DEBUG_SV.logmsg(l_module_name,'template_obtained : '||l_xml_template_obtained);
1711: WSH_DEBUG_SV.logmsg(l_module_name,'template_name : '||l_xml_template_name);
1712: WSH_DEBUG_SV.logmsg(l_module_name,'template_language : '||l_xml_template_language);
1713: WSH_DEBUG_SV.logmsg(l_module_name,'format : '||l_xml_format);
1714: WSH_DEBUG_SV.logmsg(l_module_name,'request_language : '||l_xml_request_language);
1715: WSH_DEBUG_SV.logmsg(l_module_name,'iso_language : '||l_xml_iso_language);
1708:
1709: IF l_debug_on THEN
1710: WSH_DEBUG_SV.logmsg(l_module_name,'template_obtained : '||l_xml_template_obtained);
1711: WSH_DEBUG_SV.logmsg(l_module_name,'template_name : '||l_xml_template_name);
1712: WSH_DEBUG_SV.logmsg(l_module_name,'template_language : '||l_xml_template_language);
1713: WSH_DEBUG_SV.logmsg(l_module_name,'format : '||l_xml_format);
1714: WSH_DEBUG_SV.logmsg(l_module_name,'request_language : '||l_xml_request_language);
1715: WSH_DEBUG_SV.logmsg(l_module_name,'iso_language : '||l_xml_iso_language);
1716: WSH_DEBUG_SV.logmsg(l_module_name,'iso_territory : '||l_xml_iso_territory);
1709: IF l_debug_on THEN
1710: WSH_DEBUG_SV.logmsg(l_module_name,'template_obtained : '||l_xml_template_obtained);
1711: WSH_DEBUG_SV.logmsg(l_module_name,'template_name : '||l_xml_template_name);
1712: WSH_DEBUG_SV.logmsg(l_module_name,'template_language : '||l_xml_template_language);
1713: WSH_DEBUG_SV.logmsg(l_module_name,'format : '||l_xml_format);
1714: WSH_DEBUG_SV.logmsg(l_module_name,'request_language : '||l_xml_request_language);
1715: WSH_DEBUG_SV.logmsg(l_module_name,'iso_language : '||l_xml_iso_language);
1716: WSH_DEBUG_SV.logmsg(l_module_name,'iso_territory : '||l_xml_iso_territory);
1717: WSH_DEBUG_SV.logmsg(l_module_name,'template_app_name : '||l_xml_template_app_name);
1710: WSH_DEBUG_SV.logmsg(l_module_name,'template_obtained : '||l_xml_template_obtained);
1711: WSH_DEBUG_SV.logmsg(l_module_name,'template_name : '||l_xml_template_name);
1712: WSH_DEBUG_SV.logmsg(l_module_name,'template_language : '||l_xml_template_language);
1713: WSH_DEBUG_SV.logmsg(l_module_name,'format : '||l_xml_format);
1714: WSH_DEBUG_SV.logmsg(l_module_name,'request_language : '||l_xml_request_language);
1715: WSH_DEBUG_SV.logmsg(l_module_name,'iso_language : '||l_xml_iso_language);
1716: WSH_DEBUG_SV.logmsg(l_module_name,'iso_territory : '||l_xml_iso_territory);
1717: WSH_DEBUG_SV.logmsg(l_module_name,'template_app_name : '||l_xml_template_app_name);
1718: WSH_DEBUG_SV.logmsg(l_module_name,'template_code : '||l_xml_template_code);
1711: WSH_DEBUG_SV.logmsg(l_module_name,'template_name : '||l_xml_template_name);
1712: WSH_DEBUG_SV.logmsg(l_module_name,'template_language : '||l_xml_template_language);
1713: WSH_DEBUG_SV.logmsg(l_module_name,'format : '||l_xml_format);
1714: WSH_DEBUG_SV.logmsg(l_module_name,'request_language : '||l_xml_request_language);
1715: WSH_DEBUG_SV.logmsg(l_module_name,'iso_language : '||l_xml_iso_language);
1716: WSH_DEBUG_SV.logmsg(l_module_name,'iso_territory : '||l_xml_iso_territory);
1717: WSH_DEBUG_SV.logmsg(l_module_name,'template_app_name : '||l_xml_template_app_name);
1718: WSH_DEBUG_SV.logmsg(l_module_name,'template_code : '||l_xml_template_code);
1719: WSH_DEBUG_SV.logmsg(l_module_name,'format_type : '||l_xml_format_type);
1712: WSH_DEBUG_SV.logmsg(l_module_name,'template_language : '||l_xml_template_language);
1713: WSH_DEBUG_SV.logmsg(l_module_name,'format : '||l_xml_format);
1714: WSH_DEBUG_SV.logmsg(l_module_name,'request_language : '||l_xml_request_language);
1715: WSH_DEBUG_SV.logmsg(l_module_name,'iso_language : '||l_xml_iso_language);
1716: WSH_DEBUG_SV.logmsg(l_module_name,'iso_territory : '||l_xml_iso_territory);
1717: WSH_DEBUG_SV.logmsg(l_module_name,'template_app_name : '||l_xml_template_app_name);
1718: WSH_DEBUG_SV.logmsg(l_module_name,'template_code : '||l_xml_template_code);
1719: WSH_DEBUG_SV.logmsg(l_module_name,'format_type : '||l_xml_format_type);
1720: WSH_DEBUG_SV.logmsg(l_module_name,'def_output_type : '||l_xml_def_output_type);
1713: WSH_DEBUG_SV.logmsg(l_module_name,'format : '||l_xml_format);
1714: WSH_DEBUG_SV.logmsg(l_module_name,'request_language : '||l_xml_request_language);
1715: WSH_DEBUG_SV.logmsg(l_module_name,'iso_language : '||l_xml_iso_language);
1716: WSH_DEBUG_SV.logmsg(l_module_name,'iso_territory : '||l_xml_iso_territory);
1717: WSH_DEBUG_SV.logmsg(l_module_name,'template_app_name : '||l_xml_template_app_name);
1718: WSH_DEBUG_SV.logmsg(l_module_name,'template_code : '||l_xml_template_code);
1719: WSH_DEBUG_SV.logmsg(l_module_name,'format_type : '||l_xml_format_type);
1720: WSH_DEBUG_SV.logmsg(l_module_name,'def_output_type : '||l_xml_def_output_type);
1721: END IF;
1714: WSH_DEBUG_SV.logmsg(l_module_name,'request_language : '||l_xml_request_language);
1715: WSH_DEBUG_SV.logmsg(l_module_name,'iso_language : '||l_xml_iso_language);
1716: WSH_DEBUG_SV.logmsg(l_module_name,'iso_territory : '||l_xml_iso_territory);
1717: WSH_DEBUG_SV.logmsg(l_module_name,'template_app_name : '||l_xml_template_app_name);
1718: WSH_DEBUG_SV.logmsg(l_module_name,'template_code : '||l_xml_template_code);
1719: WSH_DEBUG_SV.logmsg(l_module_name,'format_type : '||l_xml_format_type);
1720: WSH_DEBUG_SV.logmsg(l_module_name,'def_output_type : '||l_xml_def_output_type);
1721: END IF;
1722:
1715: WSH_DEBUG_SV.logmsg(l_module_name,'iso_language : '||l_xml_iso_language);
1716: WSH_DEBUG_SV.logmsg(l_module_name,'iso_territory : '||l_xml_iso_territory);
1717: WSH_DEBUG_SV.logmsg(l_module_name,'template_app_name : '||l_xml_template_app_name);
1718: WSH_DEBUG_SV.logmsg(l_module_name,'template_code : '||l_xml_template_code);
1719: WSH_DEBUG_SV.logmsg(l_module_name,'format_type : '||l_xml_format_type);
1720: WSH_DEBUG_SV.logmsg(l_module_name,'def_output_type : '||l_xml_def_output_type);
1721: END IF;
1722:
1723: IF l_xml_def_output_type is NOT NULL THEN
1716: WSH_DEBUG_SV.logmsg(l_module_name,'iso_territory : '||l_xml_iso_territory);
1717: WSH_DEBUG_SV.logmsg(l_module_name,'template_app_name : '||l_xml_template_app_name);
1718: WSH_DEBUG_SV.logmsg(l_module_name,'template_code : '||l_xml_template_code);
1719: WSH_DEBUG_SV.logmsg(l_module_name,'format_type : '||l_xml_format_type);
1720: WSH_DEBUG_SV.logmsg(l_module_name,'def_output_type : '||l_xml_def_output_type);
1721: END IF;
1722:
1723: IF l_xml_def_output_type is NOT NULL THEN
1724: l_ret_status :=fnd_request.add_layout(l_appl_short_name,
1738: IF l_ret_status THEN
1739: l_print_pdf := 'Y';
1740: ELSE
1741: IF l_debug_on THEN
1742: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returning from fnd_request.add_layout :'||x_return_status);
1743: END IF;
1744: wsh_util_core.add_message(x_return_status);
1745: END IF;
1746: --}
1745: END IF;
1746: --}
1747: ELSE
1748: IF l_debug_on THEN
1749: WSH_DEBUG_SV.logmsg(l_module_name, 'No template was specified for this report. Hence could not generate the pdf output' );
1750: END IF;
1751: --Bug 9255258 continue with report submission.
1752: /*fnd_message.set_name('WSH', 'WSH_NO_DEFAULT_TEMPLATE');
1753: fnd_message.set_token('CONC_PROG_NAME', document.concurrent_program_name);
1784: --
1785: -- Debug Statements
1786: --
1787: IF l_debug_on THEN --{
1788: WSH_DEBUG_SV.logmsg(l_module_name, 'SUBMITTED '|| DOCUMENT.CONCURRENT_PROGRAM_NAME||' WITH
1789: REQUEST_ID:'||TO_CHAR ( L_REQUEST_ID ) );
1790: END IF; --}
1791: --
1792: -- increase the counter if successful
1797: --
1798: -- Debug Statements
1799: --
1800: IF l_debug_on THEN --{
1801: WSH_DEBUG_SV.logmsg(l_module_name, 'REQUEST ID ' || TO_CHAR ( L_REQUEST_ID ) );
1802: END IF; --}
1803: --
1804:
1805: if (entity_count > 0) then --{
1854:
1855: ELSE -- else for document_name matching
1856: --
1857: IF l_debug_on THEN --{
1858: WSH_DEBUG_SV.logmsg(l_module_name, ' The value for document.concurrent_program_name '|| document.concurrent_program_name ||' does not match G_Printertab concurrent program '||WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).conc_program_name);
1859: END IF;
1860: --
1861: END IF ;
1862:
1886: --
1887: -- Debug Statements
1888: --
1889: IF l_debug_on THEN
1890: WSH_DEBUG_SV.logmsg(l_module_name, 'SUBMITTED ' || TO_CHAR ( L_SUBMITTED_DOCS ) || ' OUT OF ' || TO_CHAR ( L_TOTAL_DOCS ) );
1891: END IF;
1892: --
1893:
1894: fnd_message.set_name('WSH', 'WSH_DOCS_SUBMITTED');
1905: --
1906: -- Debug Statements
1907: --
1908: IF l_debug_on THEN
1909: WSH_DEBUG_SV.logmsg(l_module_name, 'NO REPORTS TO PROCESS' );
1910: END IF;
1911: --
1912: x_return_status := fnd_api.g_ret_sts_error;
1913: fnd_message.set_name('WSH','WSH_NO_REPORT_TO_PROCESS');
1917: --
1918: -- Debug Statements
1919: --
1920: IF l_debug_on THEN
1921: WSH_DEBUG_SV.logmsg(l_module_name, 'NO ORGANIZATION FOUND FOR ENTITY' );
1922: END IF;
1923: --
1924: x_return_status := wsh_util_core.g_ret_sts_error;
1925: fnd_message.set_name('WSH','WSH_NO_ENTITY_ORG');
1933: --
1934: -- Debug Statements
1935: --
1936: IF l_debug_on THEN
1937: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1938: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_DOCUMENT_ERROR');
1939: END IF;
1940: WHEN OTHERS THEN
1941: wsh_util_core.default_handler('WSH_UTIL_CORE.PRINT_DOCUMENT_SETS');
1934: -- Debug Statements
1935: --
1936: IF l_debug_on THEN
1937: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1938: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_DOCUMENT_ERROR');
1939: END IF;
1940: WHEN OTHERS THEN
1941: wsh_util_core.default_handler('WSH_UTIL_CORE.PRINT_DOCUMENT_SETS');
1942: x_return_status := fnd_api.g_ret_sts_unexp_error;
1944: --
1945: -- Debug Statements
1946: --
1947: IF l_debug_on THEN
1948: WSH_DEBUG_SV.pop(l_module_name);
1949: END IF;
1950: --
1951: END print_document_sets;
1952: