DBA Data[Home] [Help]

APPS.CSE_ITEM_MOVE_PKG dependencies on CSE_DEBUG_PUB

Line 153: cse_debug_pub.g_dir := nvl(FND_PROFILE.VALUE('CSE_DEBUG_LOG_DIRECTORY'), '/tmp');

149:
150: -- If the option is set turn on the debug log.
151:
152: IF (l_debug = 'Y') THEN
153: cse_debug_pub.g_dir := nvl(FND_PROFILE.VALUE('CSE_DEBUG_LOG_DIRECTORY'), '/tmp');
154: cse_debug_pub.g_file := NULL;
155: l_file := cse_debug_pub.set_debug_file('cse' || to_char(l_sysdate, 'DD-MON-YYYY') || '.log');
156: cse_debug_pub.debug_on;
157: END IF;

Line 154: cse_debug_pub.g_file := NULL;

150: -- If the option is set turn on the debug log.
151:
152: IF (l_debug = 'Y') THEN
153: cse_debug_pub.g_dir := nvl(FND_PROFILE.VALUE('CSE_DEBUG_LOG_DIRECTORY'), '/tmp');
154: cse_debug_pub.g_file := NULL;
155: l_file := cse_debug_pub.set_debug_file('cse' || to_char(l_sysdate, 'DD-MON-YYYY') || '.log');
156: cse_debug_pub.debug_on;
157: END IF;
158:

Line 155: l_file := cse_debug_pub.set_debug_file('cse' || to_char(l_sysdate, 'DD-MON-YYYY') || '.log');

151:
152: IF (l_debug = 'Y') THEN
153: cse_debug_pub.g_dir := nvl(FND_PROFILE.VALUE('CSE_DEBUG_LOG_DIRECTORY'), '/tmp');
154: cse_debug_pub.g_file := NULL;
155: l_file := cse_debug_pub.set_debug_file('cse' || to_char(l_sysdate, 'DD-MON-YYYY') || '.log');
156: cse_debug_pub.debug_on;
157: END IF;
158:
159: IF (l_debug = 'Y') THEN

Line 156: cse_debug_pub.debug_on;

152: IF (l_debug = 'Y') THEN
153: cse_debug_pub.g_dir := nvl(FND_PROFILE.VALUE('CSE_DEBUG_LOG_DIRECTORY'), '/tmp');
154: cse_debug_pub.g_file := NULL;
155: l_file := cse_debug_pub.set_debug_file('cse' || to_char(l_sysdate, 'DD-MON-YYYY') || '.log');
156: cse_debug_pub.debug_on;
157: END IF;
158:
159: IF (l_debug = 'Y') THEN
160: CSE_DEBUG_PUB.ADD('**** ITEM MOVED TRANSACTION ******');

Line 160: CSE_DEBUG_PUB.ADD('**** ITEM MOVED TRANSACTION ******');

156: cse_debug_pub.debug_on;
157: END IF;
158:
159: IF (l_debug = 'Y') THEN
160: CSE_DEBUG_PUB.ADD('**** ITEM MOVED TRANSACTION ******');
161: CSE_DEBUG_PUB.ADD('-----------------------------------------------');
162: END IF;
163:
164: l_Transaction_Type_Id := CSE_UTIL_PKG.Get_Txn_Type_ID

Line 161: CSE_DEBUG_PUB.ADD('-----------------------------------------------');

157: END IF;
158:
159: IF (l_debug = 'Y') THEN
160: CSE_DEBUG_PUB.ADD('**** ITEM MOVED TRANSACTION ******');
161: CSE_DEBUG_PUB.ADD('-----------------------------------------------');
162: END IF;
163:
164: l_Transaction_Type_Id := CSE_UTIL_PKG.Get_Txn_Type_ID
165: ('ITEM_MOVE',

Line 185: CSE_DEBUG_PUB.ADD(' from location ' ||l_from_location_type_code||'-'||l_From_hz_location_Id);

181: l_to_location_type_code :='HZ_PARTY_SITES';
182: end if;
183:
184: IF (l_debug = 'Y') THEN
185: CSE_DEBUG_PUB.ADD(' from location ' ||l_from_location_type_code||'-'||l_From_hz_location_Id);
186: CSE_DEBUG_PUB.ADD(' to location ' ||l_to_location_type_code||'-'||l_to_hz_location_Id);
187: END IF;
188:
189: --Step 2, Query for the existence of the source record

Line 186: CSE_DEBUG_PUB.ADD(' to location ' ||l_to_location_type_code||'-'||l_to_hz_location_Id);

182: end if;
183:
184: IF (l_debug = 'Y') THEN
185: CSE_DEBUG_PUB.ADD(' from location ' ||l_from_location_type_code||'-'||l_From_hz_location_Id);
186: CSE_DEBUG_PUB.ADD(' to location ' ||l_to_location_type_code||'-'||l_to_hz_location_Id);
187: END IF;
188:
189: --Step 2, Query for the existence of the source record
190:

Line 192: CSE_DEBUG_PUB.ADD('Initailizing Query Record for the source item instance - step2');

188:
189: --Step 2, Query for the existence of the source record
190:
191: IF (l_debug = 'Y') THEN
192: CSE_DEBUG_PUB.ADD('Initailizing Query Record for the source item instance - step2');
193: END IF;
194:
195: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;
196: l_Instance_Query_Rec.Inventory_Item_Id := P_Item_Move_Attr_Rec.Item_Id;

Line 206: CSE_DEBUG_PUB.ADD(l_Api_Name||' Before CSI_Item_Instance_Pub.Get_Item_Instance');

202: l_Instance_Query_Rec.Instance_Usage_Code:=CSE_DATASTRUCTURES_PUB.G_OUT_OF_SERVICE;
203: l_Active_Instance_Only := FND_API.G_TRUE; --Added for bug 7423694, base bug 7233717
204:
205: IF (l_debug = 'Y') THEN
206: CSE_DEBUG_PUB.ADD(l_Api_Name||' Before CSI_Item_Instance_Pub.Get_Item_Instance');
207: END IF;
208:
209: CSI_Item_Instance_Pub.Get_Item_Instances(
210: p_api_version =>l_api_version,

Line 292: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update of serialized item inst- step4');

288:
289: IF(P_Item_Move_Attr_Rec.Serial_Number IS NOT NULL) THEN
290:
291: IF (l_debug = 'Y') THEN
292: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update of serialized item inst- step4');
293: END IF;
294:
295: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
296: l_Instance_Rec.Instance_Id :=l_Source_Instance_Id;

Line 314: CSE_DEBUG_PUB.ADD('Before update of serialized item instanace');

310: IF NOT t_transaction_id = -1 THEN
311: l_txn_rec.transaction_id := t_transaction_id;
312: END IF;
313: IF (l_debug = 'Y') THEN
314: CSE_DEBUG_PUB.ADD('Before update of serialized item instanace');
315: END IF;
316:
317:
318: CSI_Item_Instance_Pub.Update_Item_Instance(

Line 362: CSE_DEBUG_PUB.ADD('Initailizing Query Record for the destination instance - step5.1');

358:
359: --Step 5.1 ,Check for the existence of the destination record
360:
361: IF (l_debug = 'Y') THEN
362: CSE_DEBUG_PUB.ADD('Initailizing Query Record for the destination instance - step5.1');
363: END IF;
364:
365: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;
366: l_Instance_Query_Rec.Inventory_Item_Id := P_Item_Move_Attr_Rec.Item_Id;

Line 376: CSE_DEBUG_PUB.ADD('Before querying for the existence of destination record');

372: l_Instance_Query_Rec.Instance_Usage_Code:=CSE_DATASTRUCTURES_PUB.G_OUT_OF_SERVICE;
373: l_Active_Instance_Only := FND_API.G_FALSE;
374:
375: IF (l_debug = 'Y') THEN
376: CSE_DEBUG_PUB.ADD('Before querying for the existence of destination record');
377: END IF;
378:
379: CSI_Item_Instance_Pub.Get_Item_Instances(
380: p_api_version =>l_api_version,

Line 413: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update of source qty - step5.3');

409: -- update source instance quantity
410:
411:
412: IF (l_debug = 'Y') THEN
413: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update of source qty - step5.3');
414: END IF;
415:
416: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
417: l_Instance_Rec.Instance_Id := l_Source_instance_id;

Line 438: CSE_DEBUG_PUB.ADD('Before update of source instanace qty - step 5.3');

434: IF NOT t_transaction_id = -1 THEN
435: l_txn_rec.transaction_id := t_transaction_id;
436: END IF;
437: IF (l_debug = 'Y') THEN
438: CSE_DEBUG_PUB.ADD('Before update of source instanace qty - step 5.3');
439: END IF;
440:
441:
442: CSI_Item_Instance_Pub.Update_Item_Instance(

Line 497: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update Of dest inst - step5.1');

493: l_D_object_version_number:=l_Dest_Instance_Rec.object_version_number;
494:
495:
496: IF (l_debug = 'Y') THEN
497: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update Of dest inst - step5.1');
498: END IF;
499:
500: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
501: l_Instance_Rec.Instance_Id := l_Dest_Instance_Rec.Instance_Id;

Line 530: CSE_DEBUG_PUB.ADD('Before update of destination instanace');

526: IF NOT t_transaction_id = -1 THEN
527: l_txn_rec.transaction_id := t_transaction_id;
528: END IF;
529: IF (l_debug = 'Y') THEN
530: CSE_DEBUG_PUB.ADD('Before update of destination instanace');
531: END IF;
532:
533:
534: CSI_Item_Instance_Pub.Update_Item_Instance(

Line 583: CSE_DEBUG_PUB.ADD('Initailizing instance Record for the creation Of dest inst - step5.1');

579:
580: IF (l_Create_Dest_Inst_Flag = FND_API.G_TRUE ) THEN
581:
582: IF (l_debug = 'Y') THEN
583: CSE_DEBUG_PUB.ADD('Initailizing instance Record for the creation Of dest inst - step5.1');
584: END IF;
585:
586: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Create_Rec;
587: l_Instance_Rec.Inventory_Item_id := P_Item_Move_Attr_Rec.Item_id;

Line 625: CSE_DEBUG_PUB.ADD('Before creation of destination instanace');

621: IF NOT t_transaction_id = -1 THEN
622: l_txn_rec.transaction_id := t_transaction_id;
623: END IF;
624: IF (l_debug = 'Y') THEN
625: CSE_DEBUG_PUB.ADD('Before creation of destination instanace');
626: END IF;
627:
628: CSI_Item_Instance_Pub.Create_Item_Instance(
629: p_api_version =>l_api_version,