DBA Data[Home] [Help]

APPS.CSE_PROJ_ITEM_UNINST_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: -- l_Network_Location_Code := P_Proj_Item_Uninst_Attr_Rec.Network_Location_Code;

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: -- l_Network_Location_Code := P_Proj_Item_Uninst_Attr_Rec.Network_Location_Code;
163: If P_Proj_Item_Uninst_Attr_Rec.Network_Location_id is not null then

Line 175: CSE_DEBUG_PUB.ADD('**** PROJECT ITEM UNINSTALLED TRANSACTION ******');

171: ('PROJECT_ITEM_UNINSTALLED',
172: l_App_Short_Name);
173:
174: IF (l_debug = 'Y') THEN
175: CSE_DEBUG_PUB.ADD('**** PROJECT ITEM UNINSTALLED TRANSACTION ******');
176: CSE_DEBUG_PUB.ADD('-----------------------------------------------');
177: END IF;
178:
179: --Step 2, Query for the existence of the source record

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

172: l_App_Short_Name);
173:
174: IF (l_debug = 'Y') THEN
175: CSE_DEBUG_PUB.ADD('**** PROJECT ITEM UNINSTALLED TRANSACTION ******');
176: CSE_DEBUG_PUB.ADD('-----------------------------------------------');
177: END IF;
178:
179: --Step 2, Query for the existence of the source record
180:

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

178:
179: --Step 2, Query for the existence of the source record
180:
181: IF (l_debug = 'Y') THEN
182: CSE_DEBUG_PUB.ADD('Initailizing Query Record for the source item instance - step2');
183: END IF;
184:
185: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;
186: l_Instance_Query_Rec.Inventory_Item_Id:= P_Proj_Item_Uninst_Attr_Rec.Item_Id;

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

193: l_Instance_Query_Rec.Location_Type_Code:= l_Location_Type_Code;
194: l_Instance_Query_Rec.Instance_Usage_Code:=CSE_DATASTRUCTURES_PUB.G_INSTALLED;
195:
196: IF (l_debug = 'Y') THEN
197: CSE_DEBUG_PUB.ADD(l_Api_Name||' Before CSI_Item_Instance_Pub.Get_Item_Instance');
198: END IF;
199:
200: CSI_Item_Instance_Pub.Get_Item_Instances(
201: p_api_version =>l_api_version,

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

277:
278: IF(P_Proj_Item_Uninst_Attr_Rec.Serial_Number IS NOT NULL) THEN
279:
280: IF (l_debug = 'Y') THEN
281: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update of serialized item inst- step4');
282: END IF;
283:
284: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
285: l_Instance_Rec.Instance_Id :=l_Source_Instance_Id;

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

306: IF NOT t_transaction_id = -1 THEN
307: l_txn_rec.transaction_id := t_transaction_id;
308: END IF;
309: IF (l_debug = 'Y') THEN
310: CSE_DEBUG_PUB.ADD('Before update of serialized item instanace');
311: END IF;
312:
313: CSI_Item_Instance_Pub.Update_Item_Instance(
314: p_api_version => l_api_version,

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

351:
352: --Step 5.1 ,Check for the existence of the destination record
353:
354: IF (l_debug = 'Y') THEN
355: CSE_DEBUG_PUB.ADD('Initailizing Query Record for the destination instance - step5.1');
356: END IF;
357:
358: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;
359: l_Instance_Query_Rec.Inventory_Item_Id:= P_Proj_Item_Uninst_Attr_Rec.Item_Id;

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

366:
367: l_Active_Instance_Only := FND_API.G_FALSE;
368:
369: IF (l_debug = 'Y') THEN
370: CSE_DEBUG_PUB.ADD('Before querying for the existence of destination record');
371: END IF;
372:
373: CSI_Item_Instance_Pub.Get_Item_Instances(
374: p_api_version => l_api_version,

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

403: -- update source instance quantity
404:
405:
406: IF (l_debug = 'Y') THEN
407: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update of source qty - step5.3');
408: END IF;
409:
410: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
411: l_Instance_Rec.Instance_Id := l_Source_instance_id;

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

428: IF NOT t_transaction_id = -1 THEN
429: l_txn_rec.transaction_id := t_transaction_id;
430: END IF;
431: IF (l_debug = 'Y') THEN
432: CSE_DEBUG_PUB.ADD('Before update of source instanace qty - step 5.3');
433: END IF;
434:
435:
436: CSI_Item_Instance_Pub.Update_Item_Instance(

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

486: IF l_Dest_Instance_Rec.Instance_Id IS NOT NULL THEN
487: l_D_object_version_number:=l_Dest_Instance_Rec.object_version_number;
488:
489: IF (l_debug = 'Y') THEN
490: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update Of dest inst - step5.1');
491: END IF;
492:
493: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
494: l_Instance_Rec.Instance_Id := l_Dest_Instance_Rec.Instance_Id;

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

519: IF NOT t_transaction_id = -1 THEN
520: l_txn_rec.transaction_id := t_transaction_id;
521: END IF;
522: IF (l_debug = 'Y') THEN
523: CSE_DEBUG_PUB.ADD('Before update of destination instanace');
524: END IF;
525:
526: CSI_Item_Instance_Pub.Update_Item_Instance(
527: p_api_version =>l_api_version,

Line 580: CSE_DEBUG_PUB.ADD('**** END OF PROJECT ITEM UNINSTALLED TRANSACTION ******');

576:
577: END IF;
578: END IF;
579: IF (l_debug = 'Y') THEN
580: CSE_DEBUG_PUB.ADD('**** END OF PROJECT ITEM UNINSTALLED TRANSACTION ******');
581: CSE_DEBUG_PUB.ADD(' ');
582: END IF;
583: EXCEPTION
584: WHEN Update_Ib_Exp THEN

Line 581: CSE_DEBUG_PUB.ADD(' ');

577: END IF;
578: END IF;
579: IF (l_debug = 'Y') THEN
580: CSE_DEBUG_PUB.ADD('**** END OF PROJECT ITEM UNINSTALLED TRANSACTION ******');
581: CSE_DEBUG_PUB.ADD(' ');
582: END IF;
583: EXCEPTION
584: WHEN Update_Ib_Exp THEN
585: X_Return_Status := l_Return_Status;