DBA Data[Home] [Help]

APPS.CSE_OUT_OF_SERVICE_PKG dependencies on CSE_DEBUG_PUB

Line 152: CSE_DEBUG_PUB.ADD('***** OUT NOCOPY OF SERVICE TRANSACTION ******');

148: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
149: X_Error_Message := Null;
150: t_transaction_id := -1;
151: IF (l_debug = 'Y') THEN
152: CSE_DEBUG_PUB.ADD('***** OUT NOCOPY OF SERVICE TRANSACTION ******');
153: CSE_DEBUG_PUB.ADD('-----------------------------------------------');
154: END IF;
155:
156: -- If the option is set turn on the debug log.

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

149: X_Error_Message := Null;
150: t_transaction_id := -1;
151: IF (l_debug = 'Y') THEN
152: CSE_DEBUG_PUB.ADD('***** OUT NOCOPY OF SERVICE TRANSACTION ******');
153: CSE_DEBUG_PUB.ADD('-----------------------------------------------');
154: END IF;
155:
156: -- If the option is set turn on the debug log.
157:

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

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

Line 160: cse_debug_pub.g_file := NULL;

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

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

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

Line 162: cse_debug_pub.debug_on;

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

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

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

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

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

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

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

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

301: IF NOT t_transaction_id = -1 THEN
302: l_txn_rec.transaction_id := t_transaction_id;
303: END IF;
304: IF (l_debug = 'Y') THEN
305: CSE_DEBUG_PUB.ADD('Before update of serialized item instanace');
306: END IF;
307:
308:
309: CSI_Item_Instance_Pub.Update_Item_Instance(

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

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

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

363: l_Instance_Query_Rec.Instance_Usage_Code:=CSE_DATASTRUCTURES_PUB.G_OUT_OF_SERVICE;
364: l_Active_Instance_Only:= FND_API.G_FALSE;
365:
366: IF (l_debug = 'Y') THEN
367: CSE_DEBUG_PUB.ADD('Before querying for the existence of destination record');
368: END IF;
369:
370: CSI_Item_Instance_Pub.Get_Item_Instances(
371: p_api_version => l_api_version,

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

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

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

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

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

485:
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: -- CSE_DEBUG_PUB.ADD('Initailizing instance Record for update Of dest inst - step5.1');
490:
491: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
492: l_Instance_Rec.Instance_Id := l_Dest_Instance_Rec.Instance_Id;
493: l_Instance_Rec.Quantity := (P_Out_Of_Service_Attr_Rec.Quantity +

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

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

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

568:
569: IF (l_Create_Dest_Inst_Flag = FND_API.G_TRUE ) THEN
570:
571: IF (l_debug = 'Y') THEN
572: CSE_DEBUG_PUB.ADD('Initailizing instance Record for the creation Of dest inst - step5.1');
573: END IF;
574:
575: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Create_Rec;
576: l_Instance_Rec.Inventory_Item_id := P_Out_Of_Service_Attr_Rec.Item_id;

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

611: IF NOT t_transaction_id = -1 THEN
612: l_txn_rec.transaction_id := t_transaction_id;
613: END IF;
614: IF (l_debug = 'Y') THEN
615: CSE_DEBUG_PUB.ADD('Before creation of destination instanace');
616: END IF;
617:
618:
619: CSI_Item_Instance_Pub.Create_Item_Instance(