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.CSD_DEPOT_UPDATE_PVT dependencies on CSD_GEN_UTILITY_PVT

Line 10: g_debug number := csd_gen_utility_pvt.g_debug_level;

6: -- ---------------------------------------------------------
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_DEPOT_UPDATE_PVT';
9: G_FILE_NAME CONSTANT VARCHAR2(30) := 'csddrupb.pls';
10: g_debug number := csd_gen_utility_pvt.g_debug_level;
11: -----------------------------------
12: -- Convert to primary uom
13: -----------------------------------
14: procedure convert_to_primary_uom

Line 35: csd_gen_utility_pvt.add('no_data_found error for unit_of_measure ='||p_from_uom);

31: where unit_of_measure = p_from_uom;
32: EXCEPTION
33: WHEN NO_DATA_FOUND THEN
34: IF (g_debug > 0 ) THEN
35: csd_gen_utility_pvt.add('no_data_found error for unit_of_measure ='||p_from_uom);
36: END IF;
37:
38: WHEN OTHERS THEN
39: IF (g_debug > 0 ) THEN

Line 40: csd_gen_utility_pvt.add('More than one row found for unit_of_measure ='||p_from_uom);

36: END IF;
37:
38: WHEN OTHERS THEN
39: IF (g_debug > 0 ) THEN
40: csd_gen_utility_pvt.add('More than one row found for unit_of_measure ='||p_from_uom);
41: END IF;
42:
43: End;
44:

Line 54: csd_gen_utility_pvt.add('no_data_found error(primary UOM) for inventory_item_id ='||TO_CHAR(p_item_id));

50: and inventory_item_id = p_item_id;
51: EXCEPTION
52: WHEN NO_DATA_FOUND THEN
53: IF (g_debug > 0 ) THEN
54: csd_gen_utility_pvt.add('no_data_found error(primary UOM) for inventory_item_id ='||TO_CHAR(p_item_id));
55: END IF;
56:
57: WHEN OTHERS THEN
58: IF (g_debug > 0 ) THEN

Line 59: csd_gen_utility_pvt.add('More than one row found(Primary UOM) for inventory_item_id ='||TO_CHAR(p_item_id));

55: END IF;
56:
57: WHEN OTHERS THEN
58: IF (g_debug > 0 ) THEN
59: csd_gen_utility_pvt.add('More than one row found(Primary UOM) for inventory_item_id ='||TO_CHAR(p_item_id));
60: END IF;
61:
62: End;
63:

Line 71: csd_gen_utility_pvt.add('inv_convert returned with error message');

67: p_from_quantity,p_from_uom_code,v_primary_uom_code,null,null);
68: EXCEPTION
69: WHEN OTHERS THEN
70: IF (g_debug > 0 ) THEN
71: csd_gen_utility_pvt.add('inv_convert returned with error message');
72: END IF;
73:
74: END;
75: End convert_to_primary_uom;

Line 201: csd_gen_utility_pvt.dump_api_info

197: x_return_status := FND_API.G_RET_STS_SUCCESS;
198:
199: -- Api body starts
200: if (g_debug > 0) then
201: csd_gen_utility_pvt.dump_api_info
202: ( p_pkg_name => G_PKG_NAME,
203: p_api_name => l_api_name );
204: end if;
205: -- Validate the incident_id

Line 208: csd_gen_utility_pvt.add('Incident Id ='||p_incident_id);

204: end if;
205: -- Validate the incident_id
206:
207: IF (g_debug > 0 ) THEN
208: csd_gen_utility_pvt.add('Incident Id ='||p_incident_id);
209: END IF;
210:
211: l_validate_flag := csd_process_util.validate_incident_id(p_incident_id );
212:

Line 215: csd_gen_utility_pvt.add('The Incident Id is invalid ');

211: l_validate_flag := csd_process_util.validate_incident_id(p_incident_id );
212:
213: IF NOT(l_validate_flag) then
214: IF (g_debug > 0 ) THEN
215: csd_gen_utility_pvt.add('The Incident Id is invalid ');
216: END IF;
217:
218: Raise FND_API.G_EXC_ERROR;
219: END IF;

Line 231: csd_gen_utility_pvt.ADD('In C6 get_xref_id');

227: -- Get the xref for wip_entity_id update
228: FOR C6 in get_xref_id (C5.repair_group_id)
229: LOOP
230: IF (g_debug > 0 ) THEN
231: csd_gen_utility_pvt.ADD('In C6 get_xref_id');
232: END IF;
233:
234:
235: BEGIN

Line 243: csd_gen_utility_pvt.add('Invalid WIP_ENTITY_NAME : CSD'||C6.group_id);

239: WHERE wip_entity_name = 'CSD'||C6.group_id;
240: Exception
241: When no_data_found then
242: IF (g_debug > 0 ) THEN
243: csd_gen_utility_pvt.add('Invalid WIP_ENTITY_NAME : CSD'||C6.group_id);
244: END IF;
245:
246: when others then
247: IF (g_debug > 0 ) THEN

Line 248: csd_gen_utility_pvt.add('Others exception WIP_ENTITY_NAME : CSD'||C6.group_id);

244: END IF;
245:
246: when others then
247: IF (g_debug > 0 ) THEN
248: csd_gen_utility_pvt.add('Others exception WIP_ENTITY_NAME : CSD'||C6.group_id);
249: END IF;
250:
251: End;
252:

Line 254: csd_gen_utility_pvt.ADD('Updating the xref table repair_job_xref_id = '|| C6.repair_job_xref_id);

250:
251: End;
252:
253: IF (g_debug > 0 ) THEN
254: csd_gen_utility_pvt.ADD('Updating the xref table repair_job_xref_id = '|| C6.repair_job_xref_id);
255: END IF;
256:
257:
258: if( v_weid is not null) then

Line 261: csd_gen_utility_pvt.ADD('In C6 updating xref : '||C6.repair_job_xref_id||' for wip_entity_id');

257:
258: if( v_weid is not null) then
259: Begin
260: IF (g_debug > 0 ) THEN
261: csd_gen_utility_pvt.ADD('In C6 updating xref : '||C6.repair_job_xref_id||' for wip_entity_id');
262: END IF;
263:
264: -- updating xref for wip_entity_id
265: UPDATE csd_repair_job_xref

Line 273: csd_gen_utility_pvt.add('Others exception repair_job_xref_id : '||C6.repair_job_xref_id);

269: AND object_version_number = C6.object_version_number;
270: Exception
271: when others then
272: IF (g_debug > 0 ) THEN
273: csd_gen_utility_pvt.add('Others exception repair_job_xref_id : '||C6.repair_job_xref_id);
274: END IF;
275:
276: End;
277: end if;

Line 284: csd_gen_utility_pvt.ADD('In C5 updating group : '||C5.repair_group_id||' for wip_entity_id');

280:
281: if( v_weid is not null) then
282: Begin
283: IF (g_debug > 0 ) THEN
284: csd_gen_utility_pvt.ADD('In C5 updating group : '||C5.repair_group_id||' for wip_entity_id');
285: END IF;
286:
287: -- update group level csd_repair_order_groups
288: UPDATE csd_repair_order_groups

Line 294: csd_gen_utility_pvt.add('Others exception repair_group_id : '||C5.repair_group_id);

290: WHERE repair_group_id = C5.repair_group_id;
291: Exception
292: when others then
293: IF (g_debug > 0 ) THEN
294: csd_gen_utility_pvt.add('Others exception repair_group_id : '||C5.repair_group_id);
295: END IF;
296:
297: End;
298: end if;

Line 334: csd_gen_utility_pvt.add('No WIP Job found for the wip_entity_id '||TO_CHAR(p_WIP_ENTITY_ID));

330: AND status_type in ( 4,12,5);
331: EXCEPTION
332: WHEN NO_DATA_FOUND THEN
333: IF (g_debug > 0 ) THEN
334: csd_gen_utility_pvt.add('No WIP Job found for the wip_entity_id '||TO_CHAR(p_WIP_ENTITY_ID));
335: END IF;
336:
337: v_quantity_completed := 0;
338: -- Raise FND_API.G_EXC_ERROR;

Line 341: csd_gen_utility_pvt.add('when other exception at - get_wip_job_completed_qty_gr');

337: v_quantity_completed := 0;
338: -- Raise FND_API.G_EXC_ERROR;
339: WHEN OTHERS THEN
340: IF (g_debug > 0 ) THEN
341: csd_gen_utility_pvt.add('when other exception at - get_wip_job_completed_qty_gr');
342: END IF;
343:
344: Raise FND_API.G_EXC_ERROR;
345: END;

Line 372: csd_gen_utility_pvt.add('Updated qty completed in csd_repair_job_xref for :'||C1.wip_entity_id);

368: set quantity_completed = quantity
369: where repair_line_id = C3.repair_line_id;
370:
371: IF (g_debug > 0 ) THEN
372: csd_gen_utility_pvt.add('Updated qty completed in csd_repair_job_xref for :'||C1.wip_entity_id);
373: END IF;
374:
375:
376: -- Update csd_repairs

Line 382: csd_gen_utility_pvt.add('Updated txn status in csd_repairs :'||C3.repair_line_id);

378: set ro_txn_status = 'WIP_COMPLETED'
379: where repair_line_id = C3.repair_line_id;
380:
381: IF (g_debug > 0 ) THEN
382: csd_gen_utility_pvt.add('Updated txn status in csd_repairs :'||C3.repair_line_id);
383: END IF;
384:
385:
386: v_total_rec := v_total_rec + 1;

Line 390: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write');

386: v_total_rec := v_total_rec + 1;
387:
388: -- Call API to Validate and Write to history
389: IF (g_debug > 0 ) THEN
390: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write');
391: END IF;
392:
393: CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write (
394: P_Api_Version_Number => 1.0,

Line 466: csd_gen_utility_pvt.ADD('validate_and_write failed ');

462: X_Msg_Data => l_msg_data );
463:
464: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
465: IF (g_debug > 0 ) THEN
466: csd_gen_utility_pvt.ADD('validate_and_write failed ');
467: END IF;
468:
469: RAISE FND_API.G_EXC_ERROR;
470: END IF;

Line 482: csd_gen_utility_pvt.add('Successfully completed Depot Repair WIP Job Update');

478: WHERE repair_group_id = C2.repair_group_id;
479:
480: END LOOP; -- END LOOP FOR C2
481: IF (g_debug > 0 ) THEN
482: csd_gen_utility_pvt.add('Successfully completed Depot Repair WIP Job Update');
483: END IF;
484:
485:
486: END IF; -- END IF for p_quantity_completed <> 0 T

Line 590: csd_gen_utility_pvt.dump_api_info

586: x_return_status := FND_API.G_RET_STS_SUCCESS;
587:
588: -- Api body starts
589: if (g_debug > 0) then
590: csd_gen_utility_pvt.dump_api_info
591: ( p_pkg_name => G_PKG_NAME,
592: p_api_name => l_api_name );
593: end if;
594: -- Validate the incident_id

Line 596: csd_gen_utility_pvt.add('Incident Id ='||p_incident_id);

592: p_api_name => l_api_name );
593: end if;
594: -- Validate the incident_id
595: IF (g_debug > 0 ) THEN
596: csd_gen_utility_pvt.add('Incident Id ='||p_incident_id);
597: END IF;
598:
599:
600: l_validate_flag := csd_process_util.validate_incident_id(p_incident_id );

Line 604: csd_gen_utility_pvt.add('The Incident Id is invalid ');

600: l_validate_flag := csd_process_util.validate_incident_id(p_incident_id );
601:
602: IF NOT(l_validate_flag) then
603: IF (g_debug > 0 ) THEN
604: csd_gen_utility_pvt.add('The Incident Id is invalid ');
605: END IF;
606:
607: Raise FND_API.G_EXC_ERROR;
608: END IF;

Line 614: csd_gen_utility_pvt.add('grp.repair_type_ref ='||grp.repair_type_ref );

610: FOR grp in get_rep_group (p_incident_id )
611: LOOP
612:
613: IF (g_debug > 0 ) THEN
614: csd_gen_utility_pvt.add('grp.repair_type_ref ='||grp.repair_type_ref );
615: END IF;
616:
617: IF (g_debug > 0 ) THEN
618: csd_gen_utility_pvt.add('grp.group_txn_status ='||grp.group_txn_status);

Line 618: csd_gen_utility_pvt.add('grp.group_txn_status ='||grp.group_txn_status);

614: csd_gen_utility_pvt.add('grp.repair_type_ref ='||grp.repair_type_ref );
615: END IF;
616:
617: IF (g_debug > 0 ) THEN
618: csd_gen_utility_pvt.add('grp.group_txn_status ='||grp.group_txn_status);
619: END IF;
620:
621:
622: IF grp.repair_type_ref in ('RR','E','WR') THEN

Line 627: csd_gen_utility_pvt.add('grp.recd qty ='||grp.received_quantity );

623:
624: --IF grp.group_txn_status = 'OM_BOOKED' then
625:
626: IF (g_debug > 0 ) THEN
627: csd_gen_utility_pvt.add('grp.recd qty ='||grp.received_quantity );
628: END IF;
629:
630: -- Calling Group_Rma_Update to update
631: -- all the RO that have been recd

Line 644: csd_gen_utility_pvt.add('x_update_count ='||x_update_count );

640: x_msg_count => x_msg_count,
641: x_msg_data => x_msg_data );
642:
643: IF (g_debug > 0 ) THEN
644: csd_gen_utility_pvt.add('x_update_count ='||x_update_count );
645: END IF;
646:
647:
648: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 650: csd_gen_utility_pvt.ADD('Group_ship_update failed ');

646:
647:
648: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
649: IF (g_debug > 0 ) THEN
650: csd_gen_utility_pvt.ADD('Group_ship_update failed ');
651: END IF;
652:
653: RAISE FND_API.G_EXC_ERROR;
654: END IF;

Line 659: csd_gen_utility_pvt.add('Updating group txn status and qty ');

655:
656: IF (nvl(grp.received_quantity,0) + nvl(x_update_count,0) = nvl(grp.repair_order_quantity,0)) then
657:
658: IF (g_debug > 0 ) THEN
659: csd_gen_utility_pvt.add('Updating group txn status and qty ');
660: END IF;
661:
662: -- Update txn_status and rcvd qty
663: Update csd_repair_order_groups

Line 669: csd_gen_utility_pvt.add('Updating recd qty');

665: group_txn_status = 'OM_RECEIVED'
666: where repair_group_id = grp.repair_group_id ;
667: ELSIF nvl(x_update_count,0) > 0 then
668: IF (g_debug > 0 ) THEN
669: csd_gen_utility_pvt.add('Updating recd qty');
670: END IF;
671:
672: -- Update only the rcvd qty
673: Update csd_repair_order_groups

Line 698: csd_gen_utility_pvt.add('grp.recd qty ='||grp.received_quantity );

694: x_msg_count => x_msg_count,
695: x_msg_data => x_msg_data );
696:
697: IF (g_debug > 0 ) THEN
698: csd_gen_utility_pvt.add('grp.recd qty ='||grp.received_quantity );
699: END IF;
700:
701: IF (g_debug > 0 ) THEN
702: csd_gen_utility_pvt.add('x_update_count ='||x_update_count );

Line 702: csd_gen_utility_pvt.add('x_update_count ='||x_update_count );

698: csd_gen_utility_pvt.add('grp.recd qty ='||grp.received_quantity );
699: END IF;
700:
701: IF (g_debug > 0 ) THEN
702: csd_gen_utility_pvt.add('x_update_count ='||x_update_count );
703: END IF;
704:
705:
706: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 708: csd_gen_utility_pvt.ADD('Group_rma_update failed ');

704:
705:
706: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
707: IF (g_debug > 0 ) THEN
708: csd_gen_utility_pvt.ADD('Group_rma_update failed ');
709: END IF;
710:
711: RAISE FND_API.G_EXC_ERROR;
712: END IF;

Line 717: csd_gen_utility_pvt.add('Updating group txn status and qty ');

713:
714: IF (nvl(grp.received_quantity,0) + nvl(x_update_count,0) = nvl(grp.repair_order_quantity,0)) then
715:
716: IF (g_debug > 0 ) THEN
717: csd_gen_utility_pvt.add('Updating group txn status and qty ');
718: END IF;
719:
720: -- Update txn_status and rcvd qty
721: Update csd_repair_order_groups

Line 727: csd_gen_utility_pvt.add('Updating recd qty');

723: group_txn_status = 'OM_RECEIVED'
724: where repair_group_id = grp.repair_group_id ;
725: ELSIF nvl(x_update_count,0) > 0 then
726: IF (g_debug > 0 ) THEN
727: csd_gen_utility_pvt.add('Updating recd qty');
728: END IF;
729:
730: -- Update only the rcvd qty
731: Update csd_repair_order_groups

Line 752: csd_gen_utility_pvt.ADD('Group_ship_update failed ');

748: x_msg_data => x_msg_data );
749:
750: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
751: IF (g_debug > 0 ) THEN
752: csd_gen_utility_pvt.ADD('Group_ship_update failed ');
753: END IF;
754:
755: RAISE FND_API.G_EXC_ERROR;
756: END IF;

Line 778: csd_gen_utility_pvt.add('grp.shipped qty ='||grp.shipped_quantity );

774: x_msg_count => x_msg_count,
775: x_msg_data => x_msg_data );
776:
777: IF (g_debug > 0 ) THEN
778: csd_gen_utility_pvt.add('grp.shipped qty ='||grp.shipped_quantity );
779: END IF;
780:
781: IF (g_debug > 0 ) THEN
782: csd_gen_utility_pvt.add('x_update_count ='||x_update_count );

Line 782: csd_gen_utility_pvt.add('x_update_count ='||x_update_count );

778: csd_gen_utility_pvt.add('grp.shipped qty ='||grp.shipped_quantity );
779: END IF;
780:
781: IF (g_debug > 0 ) THEN
782: csd_gen_utility_pvt.add('x_update_count ='||x_update_count );
783: END IF;
784:
785:
786: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 788: csd_gen_utility_pvt.ADD('Group_ship_update failed ');

784:
785:
786: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
787: IF (g_debug > 0 ) THEN
788: csd_gen_utility_pvt.ADD('Group_ship_update failed ');
789: END IF;
790:
791: RAISE FND_API.G_EXC_ERROR;
792: END IF;

Line 796: csd_gen_utility_pvt.add('Updating group status and qty ');

792: END IF;
793:
794: IF (nvl(grp.shipped_quantity,0) + nvl(x_update_count,0)) = nvl(grp.repair_order_quantity,0) then
795: IF (g_debug > 0 ) THEN
796: csd_gen_utility_pvt.add('Updating group status and qty ');
797: END IF;
798:
799: -- Update txn_status and rcvd qty
800: Update csd_repair_order_groups

Line 806: csd_gen_utility_pvt.add('updating shipped qty ='||x_update_count );

802: group_txn_status = 'OM_SHIPPED'
803: where repair_group_id = grp.repair_group_id ;
804: ELSIF nvl(x_update_count,0) > 0 then
805: IF (g_debug > 0 ) THEN
806: csd_gen_utility_pvt.add('updating shipped qty ='||x_update_count );
807: END IF;
808:
809: -- Update only rcvd qty
810: Update csd_repair_order_groups

Line 910: csd_gen_utility_pvt.dump_api_info

906: x_return_status := FND_API.G_RET_STS_SUCCESS;
907:
908: -- Api body starts
909: if (g_debug > 0 ) then
910: csd_gen_utility_pvt.dump_api_info
911: ( p_pkg_name => G_PKG_NAME,
912: p_api_name => l_api_name );
913: end if;
914: -- Validate the incident_id

Line 916: csd_gen_utility_pvt.add('Incident Id ='||p_incident_id);

912: p_api_name => l_api_name );
913: end if;
914: -- Validate the incident_id
915: IF (g_debug > 0 ) THEN
916: csd_gen_utility_pvt.add('Incident Id ='||p_incident_id);
917: END IF;
918:
919: l_validate_flag := csd_process_util.validate_incident_id(p_incident_id );
920:

Line 923: csd_gen_utility_pvt.add('The Incident Id is invalid ');

919: l_validate_flag := csd_process_util.validate_incident_id(p_incident_id );
920:
921: IF NOT(l_validate_flag) then
922: IF (g_debug > 0 ) THEN
923: csd_gen_utility_pvt.add('The Incident Id is invalid ');
924: END IF;
925:
926: Raise FND_API.G_EXC_ERROR ;
927: END IF;

Line 933: csd_gen_utility_pvt.add('grp.repair_type_ref ='||grp.repair_type_ref );

929: FOR grp in get_rep_group (p_incident_id )
930: LOOP
931:
932: IF (g_debug > 0 ) THEN
933: csd_gen_utility_pvt.add('grp.repair_type_ref ='||grp.repair_type_ref );
934: END IF;
935:
936: IF (g_debug > 0 ) THEN
937: csd_gen_utility_pvt.add('grp.group_txn_status ='||grp.group_txn_status);

Line 937: csd_gen_utility_pvt.add('grp.group_txn_status ='||grp.group_txn_status);

933: csd_gen_utility_pvt.add('grp.repair_type_ref ='||grp.repair_type_ref );
934: END IF;
935:
936: IF (g_debug > 0 ) THEN
937: csd_gen_utility_pvt.add('grp.group_txn_status ='||grp.group_txn_status);
938: END IF;
939:
940:
941: IF grp.repair_type_ref in ('AE','AL') THEN

Line 959: csd_gen_utility_pvt.add('grp.recd qty ='||grp.received_quantity );

955: x_msg_count => x_msg_count,
956: x_msg_data => x_msg_data );
957:
958: IF (g_debug > 0 ) THEN
959: csd_gen_utility_pvt.add('grp.recd qty ='||grp.received_quantity );
960: END IF;
961:
962: IF (g_debug > 0 ) THEN
963: csd_gen_utility_pvt.add('x_update_count ='||x_update_count );

Line 963: csd_gen_utility_pvt.add('x_update_count ='||x_update_count );

959: csd_gen_utility_pvt.add('grp.recd qty ='||grp.received_quantity );
960: END IF;
961:
962: IF (g_debug > 0 ) THEN
963: csd_gen_utility_pvt.add('x_update_count ='||x_update_count );
964: END IF;
965:
966:
967: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 969: csd_gen_utility_pvt.ADD('Group_ship_update failed ');

965:
966:
967: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
968: IF (g_debug > 0 ) THEN
969: csd_gen_utility_pvt.ADD('Group_ship_update failed ');
970: END IF;
971:
972: RAISE FND_API.G_EXC_ERROR;
973: END IF;

Line 977: csd_gen_utility_pvt.add('Updating the group txn status ');

973: END IF;
974:
975: IF nvl(grp.received_quantity,0)+nvl(x_update_count,0) = nvl(grp.repair_order_quantity,0) then
976: IF (g_debug > 0 ) THEN
977: csd_gen_utility_pvt.add('Updating the group txn status ');
978: END IF;
979:
980: -- Update txn_status and rcvd qty
981: Update csd_repair_order_groups

Line 987: csd_gen_utility_pvt.add('Updating the recd qty ');

983: group_txn_status = 'OM_RECEIVED'
984: where repair_group_id = grp.repair_group_id ;
985: ELSIF nvl(x_update_count,0) > 0 then
986: IF (g_debug > 0 ) THEN
987: csd_gen_utility_pvt.add('Updating the recd qty ');
988: END IF;
989:
990: -- Update only rcvd qty
991: Update csd_repair_order_groups

Line 1017: csd_gen_utility_pvt.add('grp.shipped qty ='||grp.shipped_quantity );

1013: x_msg_count => x_msg_count,
1014: x_msg_data => x_msg_data );
1015:
1016: IF (g_debug > 0 ) THEN
1017: csd_gen_utility_pvt.add('grp.shipped qty ='||grp.shipped_quantity );
1018: END IF;
1019:
1020: IF (g_debug > 0 ) THEN
1021: csd_gen_utility_pvt.add('x_update_count ='||x_update_count );

Line 1021: csd_gen_utility_pvt.add('x_update_count ='||x_update_count );

1017: csd_gen_utility_pvt.add('grp.shipped qty ='||grp.shipped_quantity );
1018: END IF;
1019:
1020: IF (g_debug > 0 ) THEN
1021: csd_gen_utility_pvt.add('x_update_count ='||x_update_count );
1022: END IF;
1023:
1024:
1025: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 1027: csd_gen_utility_pvt.ADD('Group_ship_update failed ');

1023:
1024:
1025: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1026: IF (g_debug > 0 ) THEN
1027: csd_gen_utility_pvt.ADD('Group_ship_update failed ');
1028: END IF;
1029:
1030: RAISE FND_API.G_EXC_ERROR;
1031: END IF;

Line 1035: csd_gen_utility_pvt.add('updating group txn status');

1031: END IF;
1032:
1033: IF nvl(grp.shipped_quantity,0) + nvl(x_update_count,0) = grp.repair_order_quantity then
1034: IF (g_debug > 0 ) THEN
1035: csd_gen_utility_pvt.add('updating group txn status');
1036: END IF;
1037:
1038:
1039: -- Update txn_status and rcvd qty

Line 1047: csd_gen_utility_pvt.add('updating only shipped qty');

1043: where repair_group_id = grp.repair_group_id ;
1044:
1045: ELSIF nvl(x_update_count,0) > 0 THEN
1046: IF (g_debug > 0 ) THEN
1047: csd_gen_utility_pvt.add('updating only shipped qty');
1048: END IF;
1049:
1050: -- Update txn_status and rcvd qty
1051: Update csd_repair_order_groups

Line 1076: csd_gen_utility_pvt.add('grp.shipped qty ='||grp.shipped_quantity );

1072: x_msg_count => x_msg_count,
1073: x_msg_data => x_msg_data );
1074:
1075: IF (g_debug > 0 ) THEN
1076: csd_gen_utility_pvt.add('grp.shipped qty ='||grp.shipped_quantity );
1077: END IF;
1078:
1079: IF (g_debug > 0 ) THEN
1080: csd_gen_utility_pvt.add('x_update_count ='||x_update_count );

Line 1080: csd_gen_utility_pvt.add('x_update_count ='||x_update_count );

1076: csd_gen_utility_pvt.add('grp.shipped qty ='||grp.shipped_quantity );
1077: END IF;
1078:
1079: IF (g_debug > 0 ) THEN
1080: csd_gen_utility_pvt.add('x_update_count ='||x_update_count );
1081: END IF;
1082:
1083:
1084: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 1086: csd_gen_utility_pvt.ADD('Group_ship_update failed ');

1082:
1083:
1084: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1085: IF (g_debug > 0 ) THEN
1086: csd_gen_utility_pvt.ADD('Group_ship_update failed ');
1087: END IF;
1088:
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;

Line 1095: csd_gen_utility_pvt.add('updating group txn status');

1091:
1092: IF nvl(grp.shipped_quantity,0) + nvl(x_update_count,0) = grp.repair_order_quantity then
1093:
1094: IF (g_debug > 0 ) THEN
1095: csd_gen_utility_pvt.add('updating group txn status');
1096: END IF;
1097:
1098: -- Update txn_status and rcvd qty
1099: Update csd_repair_order_groups

Line 1106: csd_gen_utility_pvt.add('updating only shipped qty');

1102: where repair_group_id = grp.repair_group_id ;
1103:
1104: ELSIF nvl(x_update_count,0) > 0 THEN
1105: IF (g_debug > 0 ) THEN
1106: csd_gen_utility_pvt.add('updating only shipped qty');
1107: END IF;
1108:
1109: -- Update txn_status and rcvd qty
1110: Update csd_repair_order_groups

Line 1131: csd_gen_utility_pvt.ADD('Group_rma_update failed ');

1127: x_msg_data => x_msg_data );
1128:
1129: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1130: IF (g_debug > 0 ) THEN
1131: csd_gen_utility_pvt.ADD('Group_rma_update failed ');
1132: END IF;
1133:
1134: RAISE FND_API.G_EXC_ERROR;
1135: END IF;

Line 1290: csd_gen_utility_pvt.dump_api_info

1286: x_return_status := FND_API.G_RET_STS_SUCCESS;
1287:
1288: -- Api body starts
1289: if (g_debug > 0) then
1290: csd_gen_utility_pvt.dump_api_info
1291: ( p_pkg_name => G_PKG_NAME,
1292: p_api_name => l_api_name );
1293: end if;
1294: v_total_records := 0;

Line 1308: csd_gen_utility_pvt.add('p_result_quantity='|| p_result_quantity);

1304: C1.received_quantity,
1305: p_result_quantity);
1306:
1307: IF (g_debug > 0 ) THEN
1308: csd_gen_utility_pvt.add('p_result_quantity='|| p_result_quantity);
1309: END IF;
1310:
1311:
1312: IF C1.action_code <> 'LOANER' THEN

Line 1317: csd_gen_utility_pvt.add('Before update csd_repairs');

1313:
1314: -- Update csd_repairs with txn_status
1315: -- and the rscd_qty
1316: IF (g_debug > 0 ) THEN
1317: csd_gen_utility_pvt.add('Before update csd_repairs');
1318: END IF;
1319:
1320:
1321: update csd_repairs

Line 1327: csd_gen_utility_pvt.add('After update csd_repairs');

1323: ro_txn_status = 'OM_RECEIVED'
1324: where repair_line_id = C1.repair_line_id;
1325:
1326: IF (g_debug > 0 ) THEN
1327: csd_gen_utility_pvt.add('After update csd_repairs');
1328: END IF;
1329:
1330: END IF;
1331:

Line 1337: csd_gen_utility_pvt.add('Before select ib_flag');

1333:
1334: Begin
1335:
1336: IF (g_debug > 0 ) THEN
1337: csd_gen_utility_pvt.add('Before select ib_flag');
1338: END IF;
1339:
1340:
1341: select

Line 1350: csd_gen_utility_pvt.add('After select ib_flag');

1346: and organization_id = C1.organization_id
1347: and rownum < 2; -- travi
1348:
1349: IF (g_debug > 0 ) THEN
1350: csd_gen_utility_pvt.add('After select ib_flag');
1351: END IF;
1352:
1353:
1354: Exception

Line 1357: csd_gen_utility_pvt.ADD('Invalid Inv item Id ');

1353:
1354: Exception
1355: When No_data_found then
1356: IF (g_debug > 0 ) THEN
1357: csd_gen_utility_pvt.ADD('Invalid Inv item Id ');
1358: END IF;
1359:
1360: fnd_message.set_name('CSD','CSD_INVALID_ITEM_ID');
1361: fnd_message.set_token('INVENTORY_ITEM_ID',C1.inventory_item_id);

Line 1371: csd_gen_utility_pvt.add('Serial number : '||C1.serial_number);

1367:
1368: Begin
1369:
1370: IF (g_debug > 0 ) THEN
1371: csd_gen_utility_pvt.add('Serial number : '||C1.serial_number);
1372: END IF;
1373:
1374: IF (g_debug > 0 ) THEN
1375: csd_gen_utility_pvt.add('inventory_item_id : '||C1.inventory_item_id);

Line 1375: csd_gen_utility_pvt.add('inventory_item_id : '||C1.inventory_item_id);

1371: csd_gen_utility_pvt.add('Serial number : '||C1.serial_number);
1372: END IF;
1373:
1374: IF (g_debug > 0 ) THEN
1375: csd_gen_utility_pvt.add('inventory_item_id : '||C1.inventory_item_id);
1376: END IF;
1377:
1378:
1379: -- travi fix for muliple rows picked for inctance id problem

Line 1381: csd_gen_utility_pvt.add('Before select account_id, customer_id');

1377:
1378:
1379: -- travi fix for muliple rows picked for inctance id problem
1380: IF (g_debug > 0 ) THEN
1381: csd_gen_utility_pvt.add('Before select account_id, customer_id');
1382: END IF;
1383:
1384: select account_id, customer_id
1385: into l_account_id, l_customer_id

Line 1390: csd_gen_utility_pvt.add('After select account_id, customer_id');

1386: from csd_incidents_v
1387: where incident_id = C1.incident_id;
1388:
1389: IF (g_debug > 0 ) THEN
1390: csd_gen_utility_pvt.add('After select account_id, customer_id');
1391: END IF;
1392:
1393: -- travi fix for muliple rows picked for inctance id problem
1394: Exception

Line 1397: csd_gen_utility_pvt.ADD('No data found for the incident id');

1393: -- travi fix for muliple rows picked for inctance id problem
1394: Exception
1395: When No_data_found then
1396: IF (g_debug > 0 ) THEN
1397: csd_gen_utility_pvt.ADD('No data found for the incident id');
1398: END IF;
1399:
1400: End;
1401:

Line 1405: csd_gen_utility_pvt.add('Before select instance_id');

1401:
1402: Begin
1403:
1404: IF (g_debug > 0 ) THEN
1405: csd_gen_utility_pvt.add('Before select instance_id');
1406: END IF;
1407:
1408:
1409: Select instance_id

Line 1420: csd_gen_utility_pvt.add('After select instance_id');

1416: and owner_party_account_id = nvl(l_account_id, owner_party_account_id) -- sr.account_id
1417: and owner_party_id = l_customer_id; -- sr.customer_id
1418:
1419: IF (g_debug > 0 ) THEN
1420: csd_gen_utility_pvt.add('After select instance_id');
1421: END IF;
1422:
1423:
1424: Exception

Line 1427: csd_gen_utility_pvt.ADD('Invalid Serial Number ');

1423:
1424: Exception
1425: When No_data_found then
1426: IF (g_debug > 0 ) THEN
1427: csd_gen_utility_pvt.ADD('Invalid Serial Number ');
1428: END IF;
1429:
1430: fnd_message.set_name('CSD','CSD_INVALID_SERIAL_NUMBER');
1431: fnd_message.set_token('SERIAL_NUMBER',C1.serial_number );

Line 1465: csd_gen_utility_pvt.add(fnd_message.get);

1461: fnd_message.set_token('RMA_NO',C1.rma_number);
1462: fnd_message.set_token('REP_NO',C1.repair_number);
1463: fnd_message.set_token('QTY_RCVD',to_char(C1.received_quantity));
1464: IF (g_debug > 0 ) THEN
1465: csd_gen_utility_pvt.add(fnd_message.get);
1466: END IF;
1467:
1468:
1469: IF (g_debug > 0 ) THEN

Line 1470: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write ');

1466: END IF;
1467:
1468:
1469: IF (g_debug > 0 ) THEN
1470: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write ');
1471: END IF;
1472:
1473:
1474: CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write (

Line 1546: csd_gen_utility_pvt.add('CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write l_return_status'||l_return_status);

1542: X_Msg_Count => l_msg_count,
1543: X_Msg_Data => l_msg_data );
1544:
1545: IF (g_debug > 0 ) THEN
1546: csd_gen_utility_pvt.add('CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write l_return_status'||l_return_status);
1547: END IF;
1548:
1549: IF (g_debug > 0 ) THEN
1550: csd_gen_utility_pvt.add('Successfully completed Depot RMA receipt update ');

Line 1550: csd_gen_utility_pvt.add('Successfully completed Depot RMA receipt update ');

1546: csd_gen_utility_pvt.add('CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write l_return_status'||l_return_status);
1547: END IF;
1548:
1549: IF (g_debug > 0 ) THEN
1550: csd_gen_utility_pvt.add('Successfully completed Depot RMA receipt update ');
1551: END IF;
1552:
1553:
1554: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 1556: csd_gen_utility_pvt.ADD('validate_and_write failed ');

1552:
1553:
1554: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1555: IF (g_debug > 0 ) THEN
1556: csd_gen_utility_pvt.ADD('validate_and_write failed ');
1557: END IF;
1558:
1559: RAISE FND_API.G_EXC_ERROR;
1560: END IF;

Line 1569: csd_gen_utility_pvt.add(fnd_message.get);

1565:
1566: fnd_message.set_name('CSD','CSD_DRC_WIP_TOT_REC_PROC');
1567: fnd_message.set_token('TOT_REC',to_char(v_total_records));
1568: IF (g_debug > 0 ) THEN
1569: csd_gen_utility_pvt.add(fnd_message.get);
1570: END IF;
1571:
1572:
1573: -- Return the count of number of records updated

Line 1709: csd_gen_utility_pvt.add('at the begin Group_ship_update');

1705: -- Initialize API return status to success
1706: x_return_status := FND_API.G_RET_STS_SUCCESS;
1707:
1708: IF (g_debug > 0 ) THEN
1709: csd_gen_utility_pvt.add('at the begin Group_ship_update');
1710: END IF;
1711:
1712:
1713: -- Api body starts

Line 1715: csd_gen_utility_pvt.dump_api_info

1711:
1712:
1713: -- Api body starts
1714: if (g_debug > 0) then
1715: csd_gen_utility_pvt.dump_api_info
1716: ( p_pkg_name => G_PKG_NAME,
1717: p_api_name => l_api_name );
1718: end if;
1719: v_total_records := 0;

Line 1725: csd_gen_utility_pvt.add('Calling the convert to primary uom ');

1721: For I in depot_shipment_lines(p_repair_group_id)
1722: LOOP
1723:
1724: IF (g_debug > 0 ) THEN
1725: csd_gen_utility_pvt.add('Calling the convert to primary uom ');
1726: END IF;
1727:
1728:
1729: csd_depot_repair_cntr.convert_to_primary_uom

Line 1737: csd_gen_utility_pvt.add(' p_result_ship_quantity= '|| p_result_ship_quantity);

1733: i.shipped_quantity,
1734: p_result_ship_quantity);
1735:
1736: IF (g_debug > 0 ) THEN
1737: csd_gen_utility_pvt.add(' p_result_ship_quantity= '|| p_result_ship_quantity);
1738: END IF;
1739:
1740:
1741: IF I.action_code <> 'LOANER' THEN

Line 1756: csd_gen_utility_pvt.add('Updated csd_repairs table');

1752: set prod_txn_status= 'SHIPPED'
1753: where product_transaction_id = I.product_transaction_id;
1754:
1755: IF (g_debug > 0 ) THEN
1756: csd_gen_utility_pvt.add('Updated csd_repairs table');
1757: END IF;
1758:
1759:
1760: fnd_message.set_name('CSD','CSD_DRC_QTY_SHIPPED');

Line 1765: csd_gen_utility_pvt.add(fnd_message.get);

1761: fnd_message.set_token('ORDER_NO',i.order_number);
1762: fnd_message.set_token('REP_NO',i.repair_number);
1763: fnd_message.set_token('QTY_SHIP',to_char(p_result_ship_quantity));
1764: IF (g_debug > 0 ) THEN
1765: csd_gen_utility_pvt.add(fnd_message.get);
1766: END IF;
1767:
1768:
1769: IF (g_debug > 0 ) THEN

Line 1770: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write');

1766: END IF;
1767:
1768:
1769: IF (g_debug > 0 ) THEN
1770: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write');
1771: END IF;
1772:
1773:
1774: CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write (

Line 1846: csd_gen_utility_pvt.add('after CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write l_return_status'||l_return_status);

1842: X_Msg_Count => l_msg_count,
1843: X_Msg_Data => l_msg_data );
1844:
1845: IF (g_debug > 0 ) THEN
1846: csd_gen_utility_pvt.add('after CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write l_return_status'||l_return_status);
1847: END IF;
1848:
1849: IF (g_debug > 0 ) THEN
1850: csd_gen_utility_pvt.add('Successfully completed Depot repair Shipping Update');

Line 1850: csd_gen_utility_pvt.add('Successfully completed Depot repair Shipping Update');

1846: csd_gen_utility_pvt.add('after CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write l_return_status'||l_return_status);
1847: END IF;
1848:
1849: IF (g_debug > 0 ) THEN
1850: csd_gen_utility_pvt.add('Successfully completed Depot repair Shipping Update');
1851: END IF;
1852:
1853:
1854: v_total_records := v_total_records + 1;

Line 1857: csd_gen_utility_pvt.ADD('Validate_and_write failed ');

1853:
1854: v_total_records := v_total_records + 1;
1855: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1856: IF (g_debug > 0 ) THEN
1857: csd_gen_utility_pvt.ADD('Validate_and_write failed ');
1858: END IF;
1859:
1860: RAISE FND_API.G_EXC_ERROR;
1861: END IF;

Line 1868: csd_gen_utility_pvt.add(fnd_message.get);

1864:
1865: fnd_message.set_name('CSD','CSD_DRC_SHIP_TOTAL_REC_PROC');
1866: fnd_message.set_token('TOT_REC',to_char(v_total_records));
1867: IF (g_debug > 0 ) THEN
1868: csd_gen_utility_pvt.add(fnd_message.get);
1869: END IF;
1870:
1871:
1872: x_update_count := v_total_records;