DBA Data[Home] [Help]

APPS.WSH_CONTAINER_PUB dependencies on WSH_DEBUG_SV

Line 94: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

90: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
91: --
92: IF l_debug_on IS NULL
93: THEN
94: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
95: END IF;
96: --
97: SAVEPOINT Create_Containers_SP;
98:

Line 100: WSH_DEBUG_SV.push(l_module_name);

96: --
97: SAVEPOINT Create_Containers_SP;
98:
99: IF l_debug_on THEN
100: WSH_DEBUG_SV.push(l_module_name);
101: --
102: WSH_DEBUG_SV.log(l_module_name,'p_commit', p_commit);
103: WSH_DEBUG_SV.log(l_module_name,'p_container_name',p_container_name);
104: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',

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

98:
99: IF l_debug_on THEN
100: WSH_DEBUG_SV.push(l_module_name);
101: --
102: WSH_DEBUG_SV.log(l_module_name,'p_commit', p_commit);
103: WSH_DEBUG_SV.log(l_module_name,'p_container_name',p_container_name);
104: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',
105: p_validation_level);
106: WSH_DEBUG_SV.log(l_module_name,'p_container_item_id',

Line 103: WSH_DEBUG_SV.log(l_module_name,'p_container_name',p_container_name);

99: IF l_debug_on THEN
100: WSH_DEBUG_SV.push(l_module_name);
101: --
102: WSH_DEBUG_SV.log(l_module_name,'p_commit', p_commit);
103: WSH_DEBUG_SV.log(l_module_name,'p_container_name',p_container_name);
104: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',
105: p_validation_level);
106: WSH_DEBUG_SV.log(l_module_name,'p_container_item_id',
107: p_container_item_id);

Line 104: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',

100: WSH_DEBUG_SV.push(l_module_name);
101: --
102: WSH_DEBUG_SV.log(l_module_name,'p_commit', p_commit);
103: WSH_DEBUG_SV.log(l_module_name,'p_container_name',p_container_name);
104: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',
105: p_validation_level);
106: WSH_DEBUG_SV.log(l_module_name,'p_container_item_id',
107: p_container_item_id);
108: WSH_DEBUG_SV.log(l_module_name,'p_container_item_name',

Line 106: WSH_DEBUG_SV.log(l_module_name,'p_container_item_id',

102: WSH_DEBUG_SV.log(l_module_name,'p_commit', p_commit);
103: WSH_DEBUG_SV.log(l_module_name,'p_container_name',p_container_name);
104: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',
105: p_validation_level);
106: WSH_DEBUG_SV.log(l_module_name,'p_container_item_id',
107: p_container_item_id);
108: WSH_DEBUG_SV.log(l_module_name,'p_container_item_name',
109: p_container_item_name);
110: WSH_DEBUG_SV.log(l_module_name,'p_organization_code',

Line 108: WSH_DEBUG_SV.log(l_module_name,'p_container_item_name',

104: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',
105: p_validation_level);
106: WSH_DEBUG_SV.log(l_module_name,'p_container_item_id',
107: p_container_item_id);
108: WSH_DEBUG_SV.log(l_module_name,'p_container_item_name',
109: p_container_item_name);
110: WSH_DEBUG_SV.log(l_module_name,'p_organization_code',
111: p_organization_code);
112: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',

Line 110: WSH_DEBUG_SV.log(l_module_name,'p_organization_code',

106: WSH_DEBUG_SV.log(l_module_name,'p_container_item_id',
107: p_container_item_id);
108: WSH_DEBUG_SV.log(l_module_name,'p_container_item_name',
109: p_container_item_name);
110: WSH_DEBUG_SV.log(l_module_name,'p_organization_code',
111: p_organization_code);
112: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',
113: p_organization_id);
114: WSH_DEBUG_SV.log(l_module_name,'p_name_prefix',p_name_prefix);

Line 112: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',

108: WSH_DEBUG_SV.log(l_module_name,'p_container_item_name',
109: p_container_item_name);
110: WSH_DEBUG_SV.log(l_module_name,'p_organization_code',
111: p_organization_code);
112: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',
113: p_organization_id);
114: WSH_DEBUG_SV.log(l_module_name,'p_name_prefix',p_name_prefix);
115: WSH_DEBUG_SV.log(l_module_name,'p_name_suffix',p_name_suffix);
116: WSH_DEBUG_SV.log(l_module_name,'p_base_number',p_base_number);

Line 114: WSH_DEBUG_SV.log(l_module_name,'p_name_prefix',p_name_prefix);

110: WSH_DEBUG_SV.log(l_module_name,'p_organization_code',
111: p_organization_code);
112: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',
113: p_organization_id);
114: WSH_DEBUG_SV.log(l_module_name,'p_name_prefix',p_name_prefix);
115: WSH_DEBUG_SV.log(l_module_name,'p_name_suffix',p_name_suffix);
116: WSH_DEBUG_SV.log(l_module_name,'p_base_number',p_base_number);
117: WSH_DEBUG_SV.log(l_module_name,'p_num_digits',p_num_digits);
118: WSH_DEBUG_SV.log(l_module_name,'p_api_version',p_api_version);

Line 115: WSH_DEBUG_SV.log(l_module_name,'p_name_suffix',p_name_suffix);

111: p_organization_code);
112: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',
113: p_organization_id);
114: WSH_DEBUG_SV.log(l_module_name,'p_name_prefix',p_name_prefix);
115: WSH_DEBUG_SV.log(l_module_name,'p_name_suffix',p_name_suffix);
116: WSH_DEBUG_SV.log(l_module_name,'p_base_number',p_base_number);
117: WSH_DEBUG_SV.log(l_module_name,'p_num_digits',p_num_digits);
118: WSH_DEBUG_SV.log(l_module_name,'p_api_version',p_api_version);
119: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);

Line 116: WSH_DEBUG_SV.log(l_module_name,'p_base_number',p_base_number);

112: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',
113: p_organization_id);
114: WSH_DEBUG_SV.log(l_module_name,'p_name_prefix',p_name_prefix);
115: WSH_DEBUG_SV.log(l_module_name,'p_name_suffix',p_name_suffix);
116: WSH_DEBUG_SV.log(l_module_name,'p_base_number',p_base_number);
117: WSH_DEBUG_SV.log(l_module_name,'p_num_digits',p_num_digits);
118: WSH_DEBUG_SV.log(l_module_name,'p_api_version',p_api_version);
119: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
120: WSH_DEBUG_SV.log(l_module_name,'p_quantity',p_quantity);

Line 117: WSH_DEBUG_SV.log(l_module_name,'p_num_digits',p_num_digits);

113: p_organization_id);
114: WSH_DEBUG_SV.log(l_module_name,'p_name_prefix',p_name_prefix);
115: WSH_DEBUG_SV.log(l_module_name,'p_name_suffix',p_name_suffix);
116: WSH_DEBUG_SV.log(l_module_name,'p_base_number',p_base_number);
117: WSH_DEBUG_SV.log(l_module_name,'p_num_digits',p_num_digits);
118: WSH_DEBUG_SV.log(l_module_name,'p_api_version',p_api_version);
119: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
120: WSH_DEBUG_SV.log(l_module_name,'p_quantity',p_quantity);
121: WSH_DEBUG_SV.log(l_module_name,'ucc_128_suffix_flag',

Line 118: WSH_DEBUG_SV.log(l_module_name,'p_api_version',p_api_version);

114: WSH_DEBUG_SV.log(l_module_name,'p_name_prefix',p_name_prefix);
115: WSH_DEBUG_SV.log(l_module_name,'p_name_suffix',p_name_suffix);
116: WSH_DEBUG_SV.log(l_module_name,'p_base_number',p_base_number);
117: WSH_DEBUG_SV.log(l_module_name,'p_num_digits',p_num_digits);
118: WSH_DEBUG_SV.log(l_module_name,'p_api_version',p_api_version);
119: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
120: WSH_DEBUG_SV.log(l_module_name,'p_quantity',p_quantity);
121: WSH_DEBUG_SV.log(l_module_name,'ucc_128_suffix_flag',
122: p_ucc_128_suffix_flag);

Line 119: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);

115: WSH_DEBUG_SV.log(l_module_name,'p_name_suffix',p_name_suffix);
116: WSH_DEBUG_SV.log(l_module_name,'p_base_number',p_base_number);
117: WSH_DEBUG_SV.log(l_module_name,'p_num_digits',p_num_digits);
118: WSH_DEBUG_SV.log(l_module_name,'p_api_version',p_api_version);
119: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
120: WSH_DEBUG_SV.log(l_module_name,'p_quantity',p_quantity);
121: WSH_DEBUG_SV.log(l_module_name,'ucc_128_suffix_flag',
122: p_ucc_128_suffix_flag);
123: END IF;

Line 120: WSH_DEBUG_SV.log(l_module_name,'p_quantity',p_quantity);

116: WSH_DEBUG_SV.log(l_module_name,'p_base_number',p_base_number);
117: WSH_DEBUG_SV.log(l_module_name,'p_num_digits',p_num_digits);
118: WSH_DEBUG_SV.log(l_module_name,'p_api_version',p_api_version);
119: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
120: WSH_DEBUG_SV.log(l_module_name,'p_quantity',p_quantity);
121: WSH_DEBUG_SV.log(l_module_name,'ucc_128_suffix_flag',
122: p_ucc_128_suffix_flag);
123: END IF;
124:

Line 121: WSH_DEBUG_SV.log(l_module_name,'ucc_128_suffix_flag',

117: WSH_DEBUG_SV.log(l_module_name,'p_num_digits',p_num_digits);
118: WSH_DEBUG_SV.log(l_module_name,'p_api_version',p_api_version);
119: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
120: WSH_DEBUG_SV.log(l_module_name,'p_quantity',p_quantity);
121: WSH_DEBUG_SV.log(l_module_name,'ucc_128_suffix_flag',
122: p_ucc_128_suffix_flag);
123: END IF;
124:
125:

Line 207: WSH_DEBUG_SV.pop(l_module_name);

203: );
204: --
205:
206: IF l_debug_on THEN
207: WSH_DEBUG_SV.pop(l_module_name);
208: END IF;
209:
210: EXCEPTION
211:

Line 226: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_QTY');

222: p_encoded => FND_API.G_FALSE
223: );
224: --
225: IF l_debug_on THEN
226: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_QTY');
227: END IF;
228:
229: WHEN WSH_FAIL_CONT_CREATION then
230: rollback to Create_Containers_SP;

Line 243: WSH_DEBUG_SV.pop(l_module_name,

239: p_encoded => FND_API.G_FALSE
240: );
241: --
242: IF l_debug_on THEN
243: WSH_DEBUG_SV.pop(l_module_name,
244: 'EXCEPTION:WSH_FAIL_CONT_CREATION');
245: END IF;
246:
247: WHEN OTHERS then

Line 261: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

257: p_encoded => FND_API.G_FALSE
258: );
259: --
260: IF l_debug_on THEN
261: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
262: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
263:
264: END IF;
265:

Line 262: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

258: );
259: --
260: IF l_debug_on THEN
261: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
262: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
263:
264: END IF;
265:
266:

Line 288: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

284: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
285: --
286: IF l_debug_on IS NULL
287: THEN
288: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
289: END IF;
290: --
291: IF l_debug_on THEN
292: WSH_DEBUG_SV.push(l_module_name);

Line 292: WSH_DEBUG_SV.push(l_module_name);

288: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
289: END IF;
290: --
291: IF l_debug_on THEN
292: WSH_DEBUG_SV.push(l_module_name);
293: END IF;
294: p_outrec.delivery_detail_id := p_in_rec.delivery_detail_id;
295: p_outrec.source_code := FND_API.G_MISS_CHAR;
296: p_outrec.source_header_id := p_in_rec.source_header_id;

Line 463: WSH_DEBUG_SV.pop(l_module_name);

459: p_outrec.source_line_set_id := FND_API.G_MISS_NUM;
460:
461:
462: IF l_debug_on THEN
463: WSH_DEBUG_SV.pop(l_module_name);
464: END IF;
465:
466: EXCEPTION
467:

Line 471: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

467:
468: WHEN OTHERS THEN
469: wsh_util_core.default_handler('WSH_CONTAINER_PUB.populate_record',l_module_name) ;
470: IF l_debug_on THEN
471: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
472: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
473:
474: END IF;
475:

Line 472: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

468: WHEN OTHERS THEN
469: wsh_util_core.default_handler('WSH_CONTAINER_PUB.populate_record',l_module_name) ;
470: IF l_debug_on THEN
471: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
472: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
473:
474: END IF;
475:
476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 545: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

541: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
542: --
543: IF l_debug_on IS NULL
544: THEN
545: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
546: END IF;
547: --
548: SAVEPOINT Update_Containers_SP;
549:

Line 551: WSH_DEBUG_SV.push(l_module_name);

547: --
548: SAVEPOINT Update_Containers_SP;
549:
550: IF l_debug_on THEN
551: WSH_DEBUG_SV.push(l_module_name);
552: WSH_DEBUG_SV.log(l_module_name,'p_commit', p_commit);
553: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',
554: p_validation_level);
555: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list', p_init_msg_list);

Line 552: WSH_DEBUG_SV.log(l_module_name,'p_commit', p_commit);

548: SAVEPOINT Update_Containers_SP;
549:
550: IF l_debug_on THEN
551: WSH_DEBUG_SV.push(l_module_name);
552: WSH_DEBUG_SV.log(l_module_name,'p_commit', p_commit);
553: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',
554: p_validation_level);
555: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list', p_init_msg_list);
556: WSH_DEBUG_SV.log(l_module_name,'p_api_version', p_api_version);

Line 553: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',

549:
550: IF l_debug_on THEN
551: WSH_DEBUG_SV.push(l_module_name);
552: WSH_DEBUG_SV.log(l_module_name,'p_commit', p_commit);
553: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',
554: p_validation_level);
555: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list', p_init_msg_list);
556: WSH_DEBUG_SV.log(l_module_name,'p_api_version', p_api_version);
557: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',

Line 555: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list', p_init_msg_list);

551: WSH_DEBUG_SV.push(l_module_name);
552: WSH_DEBUG_SV.log(l_module_name,'p_commit', p_commit);
553: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',
554: p_validation_level);
555: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list', p_init_msg_list);
556: WSH_DEBUG_SV.log(l_module_name,'p_api_version', p_api_version);
557: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',
558: p_container_rec.delivery_detail_id);
559: END IF;

Line 556: WSH_DEBUG_SV.log(l_module_name,'p_api_version', p_api_version);

552: WSH_DEBUG_SV.log(l_module_name,'p_commit', p_commit);
553: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',
554: p_validation_level);
555: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list', p_init_msg_list);
556: WSH_DEBUG_SV.log(l_module_name,'p_api_version', p_api_version);
557: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',
558: p_container_rec.delivery_detail_id);
559: END IF;
560:

Line 557: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',

553: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',
554: p_validation_level);
555: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list', p_init_msg_list);
556: WSH_DEBUG_SV.log(l_module_name,'p_api_version', p_api_version);
557: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',
558: p_container_rec.delivery_detail_id);
559: END IF;
560:
561: IF NOT FND_API.compatible_api_call (

Line 629: WSH_DEBUG_SV.pop(l_module_name);

625: --
626:
627:
628: IF l_debug_on THEN
629: WSH_DEBUG_SV.pop(l_module_name);
630: END IF;
631:
632:
633: EXCEPTION

Line 650: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONT_UPDATE');

646: );
647: --
648:
649: IF l_debug_on THEN
650: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONT_UPDATE');
651: END IF;
652:
653: WHEN WSH_FAIL_CONT_UPDATE then
654: rollback to Update_Containers_SP;

Line 667: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_CONT_UPDATE');

663: p_encoded => FND_API.G_FALSE
664: );
665: --
666: IF l_debug_on THEN
667: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_CONT_UPDATE');
668: END IF;
669:
670: WHEN OTHERS then
671: rollback to Update_Containers_SP;

Line 684: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

680: );
681: --
682:
683: IF l_debug_on THEN
684: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
685: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
686:
687: END IF;
688: END Update_Container;

Line 685: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

681: --
682:
683: IF l_debug_on THEN
684: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
685: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
686:
687: END IF;
688: END Update_Container;
689:

Line 787: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

783: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
784: --
785: IF l_debug_on IS NULL
786: THEN
787: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
788: END IF;
789: --
790: SAVEPOINT Autopack_SP;
791: IF l_debug_on THEN

Line 792: WSH_DEBUG_SV.push(l_module_name);

788: END IF;
789: --
790: SAVEPOINT Autopack_SP;
791: IF l_debug_on THEN
792: WSH_DEBUG_SV.push(l_module_name);
793: WSH_DEBUG_SV.log(l_module_name,'p_commit', p_commit);
794: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',
795: p_validation_level);
796: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list', p_init_msg_list);

Line 793: WSH_DEBUG_SV.log(l_module_name,'p_commit', p_commit);

789: --
790: SAVEPOINT Autopack_SP;
791: IF l_debug_on THEN
792: WSH_DEBUG_SV.push(l_module_name);
793: WSH_DEBUG_SV.log(l_module_name,'p_commit', p_commit);
794: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',
795: p_validation_level);
796: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list', p_init_msg_list);
797: WSH_DEBUG_SV.log(l_module_name,'p_api_version', p_api_version);

Line 794: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',

790: SAVEPOINT Autopack_SP;
791: IF l_debug_on THEN
792: WSH_DEBUG_SV.push(l_module_name);
793: WSH_DEBUG_SV.log(l_module_name,'p_commit', p_commit);
794: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',
795: p_validation_level);
796: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list', p_init_msg_list);
797: WSH_DEBUG_SV.log(l_module_name,'p_api_version', p_api_version);
798: WSH_DEBUG_SV.log(l_module_name,'p_entity_type', p_entity_type);

Line 796: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list', p_init_msg_list);

792: WSH_DEBUG_SV.push(l_module_name);
793: WSH_DEBUG_SV.log(l_module_name,'p_commit', p_commit);
794: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',
795: p_validation_level);
796: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list', p_init_msg_list);
797: WSH_DEBUG_SV.log(l_module_name,'p_api_version', p_api_version);
798: WSH_DEBUG_SV.log(l_module_name,'p_entity_type', p_entity_type);
799: WSH_DEBUG_SV.log(l_module_name,'p_pack_cont_flag',p_pack_cont_flag);
800: END IF;

Line 797: WSH_DEBUG_SV.log(l_module_name,'p_api_version', p_api_version);

793: WSH_DEBUG_SV.log(l_module_name,'p_commit', p_commit);
794: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',
795: p_validation_level);
796: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list', p_init_msg_list);
797: WSH_DEBUG_SV.log(l_module_name,'p_api_version', p_api_version);
798: WSH_DEBUG_SV.log(l_module_name,'p_entity_type', p_entity_type);
799: WSH_DEBUG_SV.log(l_module_name,'p_pack_cont_flag',p_pack_cont_flag);
800: END IF;
801:

Line 798: WSH_DEBUG_SV.log(l_module_name,'p_entity_type', p_entity_type);

794: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',
795: p_validation_level);
796: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list', p_init_msg_list);
797: WSH_DEBUG_SV.log(l_module_name,'p_api_version', p_api_version);
798: WSH_DEBUG_SV.log(l_module_name,'p_entity_type', p_entity_type);
799: WSH_DEBUG_SV.log(l_module_name,'p_pack_cont_flag',p_pack_cont_flag);
800: END IF;
801:
802: IF NOT FND_API.compatible_api_call (

Line 799: WSH_DEBUG_SV.log(l_module_name,'p_pack_cont_flag',p_pack_cont_flag);

795: p_validation_level);
796: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list', p_init_msg_list);
797: WSH_DEBUG_SV.log(l_module_name,'p_api_version', p_api_version);
798: WSH_DEBUG_SV.log(l_module_name,'p_entity_type', p_entity_type);
799: WSH_DEBUG_SV.log(l_module_name,'p_pack_cont_flag',p_pack_cont_flag);
800: END IF;
801:
802: IF NOT FND_API.compatible_api_call (
803: l_api_version,

Line 930: WSH_DEBUG_SV.pop(l_module_name);

926: );
927: --
928:
929: IF l_debug_on THEN
930: WSH_DEBUG_SV.pop(l_module_name);
931: END IF;
932:
933: EXCEPTION
934:

Line 949: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DETAIL');

945: p_encoded => FND_API.G_FALSE
946: );
947: --
948: IF l_debug_on THEN
949: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DETAIL');
950: END IF;
951:
952: WHEN WSH_INVALID_DELIVERY then
953: rollback to Autopack_SP;

Line 967: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DELIVERY');

963: );
964: --
965:
966: IF l_debug_on THEN
967: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DELIVERY');
968: END IF;
969: WHEN WSH_FAIL_AUTOPACK then
970: rollback to Autopack_SP;
971: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 983: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_AUTOPACK');

979: p_encoded => FND_API.G_FALSE
980: );
981: --
982: IF l_debug_on THEN
983: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_AUTOPACK');
984: END IF;
985:
986: WHEN WSH_INVALID_ENTITY_TYPE then
987: rollback to Autopack_SP;

Line 1001: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ENTITY_TYPE');

997: );
998: --
999:
1000: IF l_debug_on THEN
1001: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ENTITY_TYPE');
1002: END IF;
1003: WHEN OTHERS then
1004: rollback to Autopack_SP;
1005: wsh_util_core.default_handler('WSH_CONTAINER_PUB.Auto_Pack',l_module_name);

Line 1017: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1013: p_encoded => FND_API.G_FALSE
1014: );
1015: --
1016: IF l_debug_on THEN
1017: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1018: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1019:
1020: END IF;
1021:

Line 1018: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1014: );
1015: --
1016: IF l_debug_on THEN
1017: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1018: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1019:
1020: END IF;
1021:
1022: END Auto_Pack;

Line 1105: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1101: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1102: --
1103: IF l_debug_on IS NULL
1104: THEN
1105: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1106: END IF;
1107: --
1108: SAVEPOINT Container_Action_SP;
1109:

Line 1111: wsh_debug_sv.push (l_module_name);

1107: --
1108: SAVEPOINT Container_Action_SP;
1109:
1110: IF l_debug_on THEN
1111: wsh_debug_sv.push (l_module_name);
1112: wsh_debug_sv.log (l_module_name,'p_api_version', p_api_version);
1113: wsh_debug_sv.log (l_module_name,'p_init_msg_list', p_init_msg_list);
1114: wsh_debug_sv.log (l_module_name,'p_commit', p_commit);
1115: wsh_debug_sv.log (l_module_name,'p_validation_level', p_validation_level);

Line 1112: wsh_debug_sv.log (l_module_name,'p_api_version', p_api_version);

1108: SAVEPOINT Container_Action_SP;
1109:
1110: IF l_debug_on THEN
1111: wsh_debug_sv.push (l_module_name);
1112: wsh_debug_sv.log (l_module_name,'p_api_version', p_api_version);
1113: wsh_debug_sv.log (l_module_name,'p_init_msg_list', p_init_msg_list);
1114: wsh_debug_sv.log (l_module_name,'p_commit', p_commit);
1115: wsh_debug_sv.log (l_module_name,'p_validation_level', p_validation_level);
1116: wsh_debug_sv.log (l_module_name,'p_container_name', p_container_name);

Line 1113: wsh_debug_sv.log (l_module_name,'p_init_msg_list', p_init_msg_list);

1109:
1110: IF l_debug_on THEN
1111: wsh_debug_sv.push (l_module_name);
1112: wsh_debug_sv.log (l_module_name,'p_api_version', p_api_version);
1113: wsh_debug_sv.log (l_module_name,'p_init_msg_list', p_init_msg_list);
1114: wsh_debug_sv.log (l_module_name,'p_commit', p_commit);
1115: wsh_debug_sv.log (l_module_name,'p_validation_level', p_validation_level);
1116: wsh_debug_sv.log (l_module_name,'p_container_name', p_container_name);
1117: wsh_debug_sv.log (l_module_name,'p_cont_instance_id', p_cont_instance_id);

Line 1114: wsh_debug_sv.log (l_module_name,'p_commit', p_commit);

1110: IF l_debug_on THEN
1111: wsh_debug_sv.push (l_module_name);
1112: wsh_debug_sv.log (l_module_name,'p_api_version', p_api_version);
1113: wsh_debug_sv.log (l_module_name,'p_init_msg_list', p_init_msg_list);
1114: wsh_debug_sv.log (l_module_name,'p_commit', p_commit);
1115: wsh_debug_sv.log (l_module_name,'p_validation_level', p_validation_level);
1116: wsh_debug_sv.log (l_module_name,'p_container_name', p_container_name);
1117: wsh_debug_sv.log (l_module_name,'p_cont_instance_id', p_cont_instance_id);
1118: wsh_debug_sv.log (l_module_name,'p_container_flag', p_container_flag);

Line 1115: wsh_debug_sv.log (l_module_name,'p_validation_level', p_validation_level);

1111: wsh_debug_sv.push (l_module_name);
1112: wsh_debug_sv.log (l_module_name,'p_api_version', p_api_version);
1113: wsh_debug_sv.log (l_module_name,'p_init_msg_list', p_init_msg_list);
1114: wsh_debug_sv.log (l_module_name,'p_commit', p_commit);
1115: wsh_debug_sv.log (l_module_name,'p_validation_level', p_validation_level);
1116: wsh_debug_sv.log (l_module_name,'p_container_name', p_container_name);
1117: wsh_debug_sv.log (l_module_name,'p_cont_instance_id', p_cont_instance_id);
1118: wsh_debug_sv.log (l_module_name,'p_container_flag', p_container_flag);
1119: wsh_debug_sv.log (l_module_name,'p_delivery_flag', p_delivery_flag);

Line 1116: wsh_debug_sv.log (l_module_name,'p_container_name', p_container_name);

1112: wsh_debug_sv.log (l_module_name,'p_api_version', p_api_version);
1113: wsh_debug_sv.log (l_module_name,'p_init_msg_list', p_init_msg_list);
1114: wsh_debug_sv.log (l_module_name,'p_commit', p_commit);
1115: wsh_debug_sv.log (l_module_name,'p_validation_level', p_validation_level);
1116: wsh_debug_sv.log (l_module_name,'p_container_name', p_container_name);
1117: wsh_debug_sv.log (l_module_name,'p_cont_instance_id', p_cont_instance_id);
1118: wsh_debug_sv.log (l_module_name,'p_container_flag', p_container_flag);
1119: wsh_debug_sv.log (l_module_name,'p_delivery_flag', p_delivery_flag);
1120: wsh_debug_sv.log (l_module_name,'p_delivery_id', p_delivery_id);

Line 1117: wsh_debug_sv.log (l_module_name,'p_cont_instance_id', p_cont_instance_id);

1113: wsh_debug_sv.log (l_module_name,'p_init_msg_list', p_init_msg_list);
1114: wsh_debug_sv.log (l_module_name,'p_commit', p_commit);
1115: wsh_debug_sv.log (l_module_name,'p_validation_level', p_validation_level);
1116: wsh_debug_sv.log (l_module_name,'p_container_name', p_container_name);
1117: wsh_debug_sv.log (l_module_name,'p_cont_instance_id', p_cont_instance_id);
1118: wsh_debug_sv.log (l_module_name,'p_container_flag', p_container_flag);
1119: wsh_debug_sv.log (l_module_name,'p_delivery_flag', p_delivery_flag);
1120: wsh_debug_sv.log (l_module_name,'p_delivery_id', p_delivery_id);
1121: wsh_debug_sv.log (l_module_name,'p_delivery_name', p_delivery_name);

Line 1118: wsh_debug_sv.log (l_module_name,'p_container_flag', p_container_flag);

1114: wsh_debug_sv.log (l_module_name,'p_commit', p_commit);
1115: wsh_debug_sv.log (l_module_name,'p_validation_level', p_validation_level);
1116: wsh_debug_sv.log (l_module_name,'p_container_name', p_container_name);
1117: wsh_debug_sv.log (l_module_name,'p_cont_instance_id', p_cont_instance_id);
1118: wsh_debug_sv.log (l_module_name,'p_container_flag', p_container_flag);
1119: wsh_debug_sv.log (l_module_name,'p_delivery_flag', p_delivery_flag);
1120: wsh_debug_sv.log (l_module_name,'p_delivery_id', p_delivery_id);
1121: wsh_debug_sv.log (l_module_name,'p_delivery_name', p_delivery_name);
1122: wsh_debug_sv.log (l_module_name,'p_action_code', p_action_code);

Line 1119: wsh_debug_sv.log (l_module_name,'p_delivery_flag', p_delivery_flag);

1115: wsh_debug_sv.log (l_module_name,'p_validation_level', p_validation_level);
1116: wsh_debug_sv.log (l_module_name,'p_container_name', p_container_name);
1117: wsh_debug_sv.log (l_module_name,'p_cont_instance_id', p_cont_instance_id);
1118: wsh_debug_sv.log (l_module_name,'p_container_flag', p_container_flag);
1119: wsh_debug_sv.log (l_module_name,'p_delivery_flag', p_delivery_flag);
1120: wsh_debug_sv.log (l_module_name,'p_delivery_id', p_delivery_id);
1121: wsh_debug_sv.log (l_module_name,'p_delivery_name', p_delivery_name);
1122: wsh_debug_sv.log (l_module_name,'p_action_code', p_action_code);
1123: END IF;

Line 1120: wsh_debug_sv.log (l_module_name,'p_delivery_id', p_delivery_id);

1116: wsh_debug_sv.log (l_module_name,'p_container_name', p_container_name);
1117: wsh_debug_sv.log (l_module_name,'p_cont_instance_id', p_cont_instance_id);
1118: wsh_debug_sv.log (l_module_name,'p_container_flag', p_container_flag);
1119: wsh_debug_sv.log (l_module_name,'p_delivery_flag', p_delivery_flag);
1120: wsh_debug_sv.log (l_module_name,'p_delivery_id', p_delivery_id);
1121: wsh_debug_sv.log (l_module_name,'p_delivery_name', p_delivery_name);
1122: wsh_debug_sv.log (l_module_name,'p_action_code', p_action_code);
1123: END IF;
1124:

Line 1121: wsh_debug_sv.log (l_module_name,'p_delivery_name', p_delivery_name);

1117: wsh_debug_sv.log (l_module_name,'p_cont_instance_id', p_cont_instance_id);
1118: wsh_debug_sv.log (l_module_name,'p_container_flag', p_container_flag);
1119: wsh_debug_sv.log (l_module_name,'p_delivery_flag', p_delivery_flag);
1120: wsh_debug_sv.log (l_module_name,'p_delivery_id', p_delivery_id);
1121: wsh_debug_sv.log (l_module_name,'p_delivery_name', p_delivery_name);
1122: wsh_debug_sv.log (l_module_name,'p_action_code', p_action_code);
1123: END IF;
1124:
1125: IF NOT FND_API.compatible_api_call (

Line 1122: wsh_debug_sv.log (l_module_name,'p_action_code', p_action_code);

1118: wsh_debug_sv.log (l_module_name,'p_container_flag', p_container_flag);
1119: wsh_debug_sv.log (l_module_name,'p_delivery_flag', p_delivery_flag);
1120: wsh_debug_sv.log (l_module_name,'p_delivery_id', p_delivery_id);
1121: wsh_debug_sv.log (l_module_name,'p_delivery_name', p_delivery_name);
1122: wsh_debug_sv.log (l_module_name,'p_action_code', p_action_code);
1123: END IF;
1124:
1125: IF NOT FND_API.compatible_api_call (
1126: l_api_version,

Line 1191: WSH_DEBUG_SV.pop(l_module_name);

1187: --
1188:
1189:
1190: IF l_debug_on THEN
1191: WSH_DEBUG_SV.pop(l_module_name);
1192: END IF;
1193: EXCEPTION
1194:
1195: WHEN WSH_INVALID_DETAIL then

Line 1210: wsh_debug_sv.log (l_module_name,'EXCEPTION:WSH_INVALID_DETAIL');

1206: );
1207: --
1208:
1209: IF l_debug_on THEN
1210: wsh_debug_sv.log (l_module_name,'EXCEPTION:WSH_INVALID_DETAIL');
1211: WSH_DEBUG_SV.pop(l_module_name);
1212: END IF;
1213:
1214: WHEN FND_API.G_EXC_ERROR THEN

Line 1211: WSH_DEBUG_SV.pop(l_module_name);

1207: --
1208:
1209: IF l_debug_on THEN
1210: wsh_debug_sv.log (l_module_name,'EXCEPTION:WSH_INVALID_DETAIL');
1211: WSH_DEBUG_SV.pop(l_module_name);
1212: END IF;
1213:
1214: WHEN FND_API.G_EXC_ERROR THEN
1215: rollback to Container_Action_SP;

Line 1228: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_ERROR');

1224: );
1225: --
1226:
1227: IF l_debug_on THEN
1228: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_ERROR');
1229: WSH_DEBUG_SV.pop(l_module_name);
1230: END IF;
1231:
1232:

Line 1229: WSH_DEBUG_SV.pop(l_module_name);

1225: --
1226:
1227: IF l_debug_on THEN
1228: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_ERROR');
1229: WSH_DEBUG_SV.pop(l_module_name);
1230: END IF;
1231:
1232:
1233:

Line 1246: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_UNEXP_ERROR');

1242: p_encoded => FND_API.G_FALSE
1243: );
1244: --
1245: IF l_debug_on THEN
1246: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_UNEXP_ERROR');
1247: WSH_DEBUG_SV.pop(l_module_name);
1248: END IF;
1249:
1250: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 1247: WSH_DEBUG_SV.pop(l_module_name);

1243: );
1244: --
1245: IF l_debug_on THEN
1246: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_UNEXP_ERROR');
1247: WSH_DEBUG_SV.pop(l_module_name);
1248: END IF;
1249:
1250: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1251: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1262: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_WARNING');

1258: );
1259: --
1260:
1261: IF l_debug_on THEN
1262: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_WARNING');
1263: WSH_DEBUG_SV.pop(l_module_name);
1264: END IF;
1265:
1266: WHEN OTHERS then

Line 1263: WSH_DEBUG_SV.pop(l_module_name);

1259: --
1260:
1261: IF l_debug_on THEN
1262: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_WARNING');
1263: WSH_DEBUG_SV.pop(l_module_name);
1264: END IF;
1265:
1266: WHEN OTHERS then
1267: rollback to Container_Action_SP;

Line 1279: wsh_debug_sv.log (l_module_name,'Others',substr(sqlerrm,1,200));

1275: p_encoded => FND_API.G_FALSE
1276: );
1277: --
1278: IF l_debug_on THEN
1279: wsh_debug_sv.log (l_module_name,'Others',substr(sqlerrm,1,200));
1280: WSH_DEBUG_SV.pop(l_module_name);
1281: END IF;
1282:
1283:

Line 1280: WSH_DEBUG_SV.pop(l_module_name);

1276: );
1277: --
1278: IF l_debug_on THEN
1279: wsh_debug_sv.log (l_module_name,'Others',substr(sqlerrm,1,200));
1280: WSH_DEBUG_SV.pop(l_module_name);
1281: END IF;
1282:
1283:
1284: END Container_Actions;