DBA Data[Home] [Help]

APPS.CSE_PROJ_ITEM_UNINST_PKG dependencies on CSE_DEBUG_PUB

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

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

Line 158: cse_debug_pub.g_file := NULL;

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

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

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

Line 160: cse_debug_pub.debug_on;

156: IF (l_debug = 'Y') THEN
157: cse_debug_pub.g_dir := nvl(FND_PROFILE.VALUE('CSE_DEBUG_LOG_DIRECTORY'), '/tmp');
158: cse_debug_pub.g_file := NULL;
159: l_file := cse_debug_pub.set_debug_file('cse' || to_char(l_sysdate, 'DD-MON-YYYY') || '.log');
160: cse_debug_pub.debug_on;
161: END IF;
162:
163: -- l_Network_Location_Code := P_Proj_Item_Uninst_Attr_Rec.Network_Location_Code;
164: If P_Proj_Item_Uninst_Attr_Rec.Network_Location_id is not null then

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 582: CSE_DEBUG_PUB.ADD(' ');

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