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 156: cse_debug_pub.g_dir := nvl(FND_PROFILE.VALUE('CSE_DEBUG_LOG_DIRECTORY'), '/tmp');

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

Line 157: cse_debug_pub.g_file := NULL;

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

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

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

Line 159: cse_debug_pub.debug_on;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 745: CSE_DEBUG_PUB.ADD(' ');

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