eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSE_PROJ_ITEM_INST_PKG dependencies on CSE_DEBUG_PUB

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

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

Line 156: cse_debug_pub.g_file := NULL;

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

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

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

Line 158: cse_debug_pub.debug_on;

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

Line 162: CSE_DEBUG_PUB.ADD(' PROJECT ITEM INSTALLED TRANSACTION **');

158: cse_debug_pub.debug_on;
159: END IF;
160:
161: IF (l_debug = 'Y') THEN
162: CSE_DEBUG_PUB.ADD('**** PROJECT ITEM INSTALLED TRANSACTION ******');
163: CSE_DEBUG_PUB.ADD('-----------------------------------------------');
164: END IF;
165: --Step 1, Get Hz Location id
166:

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

159: END IF;
160:
161: IF (l_debug = 'Y') THEN
162: CSE_DEBUG_PUB.ADD('**** PROJECT ITEM INSTALLED TRANSACTION ******');
163: CSE_DEBUG_PUB.ADD('-----------------------------------------------');
164: END IF;
165: --Step 1, Get Hz Location id
166:
167: -- CSE_DEBUG_PUB.ADD('Calling get_hz_location');

Line 167: -- CSE_DEBUG_PUB.ADD('Calling get_hz_location');

163: CSE_DEBUG_PUB.ADD('-----------------------------------------------');
164: END IF;
165: --Step 1, Get Hz Location id
166:
167: -- CSE_DEBUG_PUB.ADD('Calling get_hz_location');
168:
169: -- CSE_UTIL_PKG.Get_Hz_Location(
170: -- P_Network_Location_Code => l_Network_Location_Code,
171: -- X_Hz_Location_Id => l_Hz_Location_Id,

Line 181: CSE_DEBUG_PUB.ADD('before cse_util_pkg.check_depreciable');

177: -- END IF;
178:
179: --check whether the the item is depreciable
180: IF (l_debug = 'Y') THEN
181: CSE_DEBUG_PUB.ADD('before cse_util_pkg.check_depreciable');
182: END IF;
183: cse_util_pkg.check_depreciable(
184: p_inventory_item_id => P_Proj_Item_Inst_Attr_Rec.Item_Id,
185: p_depreciable =>l_depreciable);

Line 188: CSE_DEBUG_PUB.ADD('item is depreciable');

184: p_inventory_item_id => P_Proj_Item_Inst_Attr_Rec.Item_Id,
185: p_depreciable =>l_depreciable);
186: IF l_depreciable='Y' THEN
187: IF (l_debug = 'Y') THEN
188: CSE_DEBUG_PUB.ADD('item is depreciable');
189: END IF;
190: l_Transaction_Status_Code :=CSE_DATASTRUCTURES_PUB.G_PENDING;
191: ELSE
192: IF (l_debug = 'Y') THEN

Line 193: CSE_DEBUG_PUB.ADD('item is not depreciable');

189: END IF;
190: l_Transaction_Status_Code :=CSE_DATASTRUCTURES_PUB.G_PENDING;
191: ELSE
192: IF (l_debug = 'Y') THEN
193: CSE_DEBUG_PUB.ADD('item is not depreciable');
194: END IF;
195: l_Transaction_Status_Code :=CSE_DATASTRUCTURES_PUB.G_COMPLETE;
196: END IF;
197:

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

197:
198: --Step 2, Query for the existence of the source record
199:
200: IF (l_debug = 'Y') THEN
201: CSE_DEBUG_PUB.ADD('Initailizing Query Record for the source item instance - step2');
202: END IF;
203:
204: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;
205: l_Instance_Query_Rec.Inventory_Item_Id := P_Proj_Item_Inst_Attr_Rec.Item_Id;

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

210: l_Instance_Query_Rec.Pa_Project_Task_Id:= P_Proj_Item_Inst_Attr_Rec.Task_Id;
211: l_Instance_Query_Rec.Instance_Usage_Code:= CSE_DATASTRUCTURES_PUB.G_IN_PROCESS;
212:
213: IF (l_debug = 'Y') THEN
214: CSE_DEBUG_PUB.ADD(l_Api_Name||' Before CSI_Item_Instance_Pub.Get_Item_Instance');
215: END IF;
216:
217: CSI_Item_Instance_Pub.Get_Item_Instances(
218: p_api_version =>l_api_version,

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

298: IF(P_Proj_Item_Inst_Attr_Rec.Serial_Number IS NOT NULL) THEN
299:
300:
301: IF (l_debug = 'Y') THEN
302: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update of serialized item inst- step4');
303: END IF;
304:
305: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
306: l_Instance_Rec.Instance_Id := l_Source_Instance_Id;

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

330: END IF;
331:
332:
333: IF (l_debug = 'Y') THEN
334: CSE_DEBUG_PUB.ADD('Before update of serialized item instanace');
335: END IF;
336:
337:
338: CSI_Item_Instance_Pub.Update_Item_Instance(

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

378:
379: --Step 5.1 ,Check for the existence of the destination record
380:
381: IF (l_debug = 'Y') THEN
382: CSE_DEBUG_PUB.ADD('Initailizing Query Record for the destination instance - step5.1');
383: END IF;
384:
385: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;
386: l_Instance_Query_Rec.Inventory_Item_Id := P_Proj_Item_Inst_Attr_Rec.Item_Id;

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

395:
396: l_Active_Instance_Only := FND_API.G_FALSE;
397:
398: IF (l_debug = 'Y') THEN
399: CSE_DEBUG_PUB.ADD('Before querying for the existence of destination record');
400: END IF;
401:
402: CSI_Item_Instance_Pub.Get_Item_Instances(
403: p_api_version => l_api_version,

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

430:
431: -- update source instance quantity
432:
433: IF (l_debug = 'Y') THEN
434: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update of source qty - step5.3');
435: END IF;
436:
437: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
438: l_Instance_Rec.Instance_Id := l_Source_instance_id;

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

455: l_txn_rec.transaction_id := t_transaction_id;
456: END IF;
457:
458: IF (l_debug = 'Y') THEN
459: CSE_DEBUG_PUB.ADD('Before update of source instanace qty - step 5.3');
460: END IF;
461:
462: CSI_Item_Instance_Pub.Update_Item_Instance(
463: p_api_version => l_api_version,

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

516: l_D_object_version_number:=l_Dest_Instance_Rec.object_version_number;
517:
518:
519: IF (l_debug = 'Y') THEN
520: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update Of dest inst - step5.1');
521: END IF;
522:
523: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
524: l_Instance_Rec.Instance_Id := l_Dest_Instance_Rec.Instance_Id;

Line 546: CSE_DEBUG_PUB.ADD('source txn id-'||l_upd_txn_rec.transaction_id);

542: l_Txn_Rec.Transaction_Type_Id :=L_Transaction_Type_Id;
543: l_Txn_Rec.Source_Group_Ref :=P_Proj_Item_Inst_Attr_Rec.Work_Order_Number;
544: l_Txn_Rec.source_dist_ref_id2 :=l_upd_txn_rec.transaction_id;
545: IF (l_debug = 'Y') THEN
546: CSE_DEBUG_PUB.ADD('source txn id-'||l_upd_txn_rec.transaction_id);
547: END IF;
548: l_Txn_Rec.Transaction_Quantity :=P_Proj_Item_Inst_Attr_Rec.Quantity;
549: l_Txn_Rec.Transacted_By :=P_Proj_Item_Inst_Attr_Rec.Transacted_By;
550: l_Txn_Rec.Transaction_Status_Code :=l_Transaction_Status_Code;

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

555: l_txn_rec.transaction_id := t_transaction_id;
556: END IF;
557:
558: IF (l_debug = 'Y') THEN
559: CSE_DEBUG_PUB.ADD('Before update of destination instanace');
560: END IF;
561:
562: CSI_Item_Instance_Pub.Update_Item_Instance(
563: p_api_version =>l_api_version,

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

609:
610: IF (l_Create_Dest_Inst_Flag = FND_API.G_TRUE ) THEN
611:
612: IF (l_debug = 'Y') THEN
613: CSE_DEBUG_PUB.ADD('Initailizing instance Record for the creation Of dest inst - step5.1');
614: END IF;
615:
616: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Create_Rec;
617: l_Instance_Rec.Inventory_Item_id := P_Proj_Item_Inst_Attr_Rec.Item_id;

Line 650: CSE_DEBUG_PUB.ADD('source txn id-'||l_upd_txn_rec.transaction_id);

646: l_Txn_Rec.Transaction_Type_Id := l_transaction_type_id;
647: l_Txn_Rec.Source_Group_Ref:= P_Proj_Item_Inst_Attr_Rec.Work_Order_Number;
648: --l_Txn_Rec.source_dist_ref_id2:=l_upd_txn_rec.transaction_id;
649: IF (l_debug = 'Y') THEN
650: CSE_DEBUG_PUB.ADD('source txn id-'||l_upd_txn_rec.transaction_id);
651: END IF;
652: l_Txn_Rec.Transaction_Quantity := P_Proj_Item_Inst_Attr_Rec.Quantity;
653: l_Txn_Rec.Transacted_By := P_Proj_Item_Inst_Attr_Rec.Transacted_By;
654: l_Txn_Rec.Transaction_Status_Code := l_Transaction_Status_Code;

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

657: l_txn_rec.transaction_id := t_transaction_id;
658: END IF;
659:
660: IF (l_debug = 'Y') THEN
661: CSE_DEBUG_PUB.ADD('Before creation of destination instanace');
662: END IF;
663:
664: CSI_Item_Instance_Pub.Create_Item_Instance(
665: p_api_version =>l_api_version,

Line 706: CSE_DEBUG_PUB.ADD('dest txn id-'||l_upd_txn_rec.source_dist_ref_id2);

702: --l_upd_txn_rec.source_dist_ref_id2:= l_dest_transaction_id;
703:
704: END IF;
705: IF (l_debug = 'Y') THEN
706: CSE_DEBUG_PUB.ADD('dest txn id-'||l_upd_txn_rec.source_dist_ref_id2);
707: END IF;
708: -- update the source transaction with destination transaction_id
709: IF (l_debug = 'Y') THEN
710: CSE_DEBUG_PUB.ADD('Before calling csi_transactions_pvt.update_transactions');

Line 710: CSE_DEBUG_PUB.ADD('Before calling csi_transactions_pvt.update_transactions');

706: CSE_DEBUG_PUB.ADD('dest txn id-'||l_upd_txn_rec.source_dist_ref_id2);
707: END IF;
708: -- update the source transaction with destination transaction_id
709: IF (l_debug = 'Y') THEN
710: CSE_DEBUG_PUB.ADD('Before calling csi_transactions_pvt.update_transactions');
711: END IF;
712: csi_transactions_pvt.update_transactions(
713: P_api_version => l_api_version,
714: P_Init_Msg_List => l_Init_Msg_List,

Line 723: CSE_DEBUG_PUB.ADD('after calling csi_transactions_pvt.update_transactions');

719: X_Msg_Count => l_Msg_Count,
720: X_Msg_Data => l_Msg_Data);
721:
722: IF (l_debug = 'Y') THEN
723: CSE_DEBUG_PUB.ADD('after calling csi_transactions_pvt.update_transactions');
724: END IF;
725:
726: IF NOT(l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
727: l_msg_index := 1;

Line 743: CSE_DEBUG_PUB.ADD(' END OF PROJECT ITEM INSTALLED TRANSACTION **');

739: END IF;
740: END IF;
741: END IF;
742: IF (l_debug = 'Y') THEN
743: CSE_DEBUG_PUB.ADD('**** END OF PROJECT ITEM INSTALLED TRANSACTION ******');
744: CSE_DEBUG_PUB.ADD(' ');
745: END IF;
746: EXCEPTION
747: WHEN Update_Ib_Exp THEN

Line 744: CSE_DEBUG_PUB.ADD(' ');

740: END IF;
741: END IF;
742: IF (l_debug = 'Y') THEN
743: CSE_DEBUG_PUB.ADD('**** END OF PROJECT ITEM INSTALLED TRANSACTION ******');
744: CSE_DEBUG_PUB.ADD(' ');
745: END IF;
746: EXCEPTION
747: WHEN Update_Ib_Exp THEN
748: X_Return_Status := l_Return_Status;