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_REPAIR_GROUPS_PVT dependencies on CSD_GEN_UTILITY_PVT

Line 7: g_debug NUMBER := csd_gen_utility_pvt.g_debug_level;

3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_REPAIR_GROUPS_PVT';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvrpgb.pls';
7: g_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
8:
9: ----------------------------------------------------
10: -- procedure name: create_repair_groups
11: -- description : procedure used to create

Line 75: csd_gen_utility_pvt.dump_api_info

71: --------------------
72: -- Api body starts
73: --------------------
74: if (g_debug > 0) then
75: csd_gen_utility_pvt.dump_api_info
76: ( p_pkg_name => G_PKG_NAME,
77: p_api_name => l_api_name );
78: end if;
79: ------------------------------------------

Line 84: csd_gen_utility_pvt.dump_repair_order_group_rec

80: -- Dump the in parameters in the log file
81: ------------------------------------------
82: --IF fnd_profile.value('CSD_DEBUG_LEVEL') > 5 THEN
83: if (g_debug > 5) then
84: csd_gen_utility_pvt.dump_repair_order_group_rec
85: ( p_repair_order_group_rec => x_repair_order_group_rec);
86: END IF;
87:
88: -----------------------------------

Line 93: csd_gen_utility_pvt.ADD('Check reqd parameter : Incident Id');

89: -- Check for required parameters
90: -----------------------------------
91:
92: IF (g_debug > 0 ) THEN
93: csd_gen_utility_pvt.ADD('Check reqd parameter : Incident Id');
94: END IF;
95:
96:
97: CSD_REPAIRS_UTIL.check_reqd_param

Line 104: csd_gen_utility_pvt.ADD('Check reqd parameter : Inventory Item Id');

100: p_api_name => l_api_name
101: );
102:
103: IF (g_debug > 0 ) THEN
104: csd_gen_utility_pvt.ADD('Check reqd parameter : Inventory Item Id');
105: END IF;
106:
107:
108: CSD_REPAIRS_UTIL.check_reqd_param

Line 115: csd_gen_utility_pvt.ADD('Check reqd parameter : Unit of Measure');

111: p_api_name => l_api_name
112: );
113:
114: IF (g_debug > 0 ) THEN
115: csd_gen_utility_pvt.ADD('Check reqd parameter : Unit of Measure');
116: END IF;
117:
118:
119: CSD_REPAIRS_UTIL.check_reqd_param

Line 126: csd_gen_utility_pvt.ADD('Check reqd parameter : Repair Type Id');

122: p_api_name => l_api_name
123: );
124:
125: IF (g_debug > 0 ) THEN
126: csd_gen_utility_pvt.ADD('Check reqd parameter : Repair Type Id');
127: END IF;
128:
129:
130: CSD_REPAIRS_UTIL.check_reqd_param

Line 140: csd_gen_utility_pvt.ADD('Validate Incident id');

136: ---------------------------------
137: -- Validate the incident ID
138: ---------------------------------
139: IF (g_debug > 0 ) THEN
140: csd_gen_utility_pvt.ADD('Validate Incident id');
141: END IF;
142:
143:
144: IF NOT( CSD_PROCESS_UTIL.Validate_incident_id

Line 153: csd_gen_utility_pvt.ADD('Validate repair type id');

149: ---------------------------------
150: -- Validate the repair type ID
151: ---------------------------------
152: IF (g_debug > 0 ) THEN
153: csd_gen_utility_pvt.ADD('Validate repair type id');
154: END IF;
155:
156:
157: IF NOT( CSD_PROCESS_UTIL.Validate_repair_type_id

Line 166: csd_gen_utility_pvt.ADD('Validate Inventory item id');

162: -----------------------------------
163: -- Validate the Inventory Item ID
164: -----------------------------------
165: IF (g_debug > 0 ) THEN
166: csd_gen_utility_pvt.ADD('Validate Inventory item id');
167: END IF;
168:
169:
170: IF NOT( CSD_PROCESS_UTIL.Validate_inventory_item_id

Line 180: csd_gen_utility_pvt.ADD('Unit of Measure');

176: ---------------------------------
177: -- Validate the UOM Code
178: ---------------------------------
179: IF (g_debug > 0 ) THEN
180: csd_gen_utility_pvt.ADD('Unit of Measure');
181: END IF;
182:
183:
184: IF NOT( CSD_PROCESS_UTIL.Validate_unit_of_measure

Line 196: csd_gen_utility_pvt.ADD('Wip Entity Id');

192: IF(x_repair_order_group_rec.wip_entity_id is not null and
193: x_repair_order_group_rec.wip_entity_id <> FND_API.G_MISS_NUM) then
194:
195: IF (g_debug > 0 ) THEN
196: csd_gen_utility_pvt.ADD('Wip Entity Id');
197: END IF;
198:
199:
200: IF NOT( CSD_PROCESS_UTIL.Validate_wip_entity_id

Line 218: csd_gen_utility_pvt.ADD('Validate the Group ID and Number');

214: ---------------------------------------
215: -- Validate group id and group number
216: ---------------------------------------
217: IF (g_debug > 0 ) THEN
218: csd_gen_utility_pvt.ADD('Validate the Group ID and Number');
219: END IF;
220:
221:
222: if(l_repair_group_id is null) then

Line 235: csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Insert_Row');

231:
232: x_repair_order_group_rec.object_version_number := 1;
233:
234: IF (g_debug > 0 ) THEN
235: csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Insert_Row');
236: END IF;
237:
238:
239: CSD_REPAIR_ORDER_GROUPS_PKG.Insert_Row

Line 412: csd_gen_utility_pvt.dump_api_info

408: -- Api body starts
409: --------------------
410: if (g_debug > 0) then
411:
412: csd_gen_utility_pvt.dump_api_info
413: ( p_pkg_name => G_PKG_NAME,
414: p_api_name => l_api_name );
415: end if;
416: ------------------------------------------

Line 421: csd_gen_utility_pvt.dump_repair_order_group_rec

417: -- Dump the in parameters in the log file
418: ------------------------------------------
419: --IF fnd_profile.value('CSD_DEBUG_LEVEL') > 5 THEN
420: if (g_debug > 5) then
421: csd_gen_utility_pvt.dump_repair_order_group_rec
422: ( p_repair_order_group_rec => x_repair_order_group_rec);
423: END IF;
424:
425:

Line 430: csd_gen_utility_pvt.ADD('Check reqd parameter : Repair Group Id');

426: ---------------------------------
427: -- Check the required parameter
428: ---------------------------------
429: IF (g_debug > 0 ) THEN
430: csd_gen_utility_pvt.ADD('Check reqd parameter : Repair Group Id');
431: END IF;
432:
433:
434: CSD_PROCESS_UTIL.Check_Reqd_Param

Line 443: csd_gen_utility_pvt.ADD('Repair Group Id');

439: ---------------------------------
440: -- Validate Repair Group Id
441: ---------------------------------
442: IF (g_debug > 0 ) THEN
443: csd_gen_utility_pvt.ADD('Repair Group Id');
444: END IF;
445:
446:
447: IF NOT( CSD_PROCESS_UTIL.Validate_repair_group_id

Line 456: csd_gen_utility_pvt.ADD('Fetch the Group Id for Update');

452: ---------------------------------------
453: -- Fetch the Group info
454: ---------------------------------------
455: IF (g_debug > 0 ) THEN
456: csd_gen_utility_pvt.ADD('Fetch the Group Id for Update');
457: END IF;
458:
459:
460: IF NVL(x_repair_order_group_rec.repair_group_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

Line 484: csd_gen_utility_pvt.ADD('Validate the Object Version Number');

480: --------------------------------
481: -- Validate Obj Version Number
482: --------------------------------
483: IF (g_debug > 0 ) THEN
484: csd_gen_utility_pvt.ADD('Validate the Object Version Number');
485: END IF;
486:
487:
488: IF NVL(x_repair_order_group_rec.object_version_number,FND_API.G_MISS_NUM) <>l_obj_ver_num THEN

Line 491: csd_gen_utility_pvt.ADD('object version number does not match');

487:
488: IF NVL(x_repair_order_group_rec.object_version_number,FND_API.G_MISS_NUM) <>l_obj_ver_num THEN
489:
490: IF (g_debug > 0 ) THEN
491: csd_gen_utility_pvt.ADD('object version number does not match');
492: END IF;
493:
494:
495: FND_MESSAGE.SET_NAME('CSD','CSD_GRP_OBJ_VER_MISMATCH');

Line 507: csd_gen_utility_pvt.ADD('Validate if any RO have been created');

503: -- Validate if any RO have
504: -- been created
505: -----------------------------
506: IF (g_debug > 0 ) THEN
507: csd_gen_utility_pvt.ADD('Validate if any RO have been created');
508: END IF;
509:
510:
511: l_count := 0;

Line 571: csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Update_Row');

567: -------------------
568: -- Update Call
569: -------------------
570: IF (g_debug > 0 ) THEN
571: csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Update_Row');
572: END IF;
573:
574:
575: CSD_REPAIR_ORDER_GROUPS_PKG.Update_Row(

Line 729: csd_gen_utility_pvt.ADD('Check reqd parameter: Repair Group Id ');

725: ---------------------------------
726: -- Check the required parameter
727: ---------------------------------
728: IF (g_debug > 0 ) THEN
729: csd_gen_utility_pvt.ADD('Check reqd parameter: Repair Group Id ');
730: END IF;
731:
732:
733: CSD_PROCESS_UTIL.Check_Reqd_Param

Line 742: csd_gen_utility_pvt.ADD('Repair Group Id');

738: ----------------------------------
739: -- Validate the Repair Group Id
740: ----------------------------------
741: IF (g_debug > 0 ) THEN
742: csd_gen_utility_pvt.ADD('Repair Group Id');
743: END IF;
744:
745:
746: IF NOT( CSD_PROCESS_UTIL.Validate_repair_group_id

Line 757: csd_gen_utility_pvt.ADD('Validate if any RO have been created');

753: -- check if there are any Ro
754: -- for the Group
755: --------------------------------
756: IF (g_debug > 0 ) THEN
757: csd_gen_utility_pvt.ADD('Validate if any RO have been created');
758: END IF;
759:
760:
761: l_count := 0;

Line 788: csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Delete_Row');

784: -----------------------------
785: -- Calling the Delete api
786: -----------------------------
787: IF (g_debug > 0 ) THEN
788: csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Delete_Row');
789: END IF;
790:
791:
792: CSD_REPAIR_ORDER_GROUPS_PKG.Delete_Row

Line 901: csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Lock_Row ');

897: ----------------------------
898: -- Calling Lock Row
899: ----------------------------
900: IF (g_debug > 0 ) THEN
901: csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Lock_Row ');
902: END IF;
903:
904:
905: CSD_REPAIR_ORDER_GROUPS_PKG.Lock_Row(

Line 1038: csd_gen_utility_pvt.dump_api_info

1034: -- API Starts
1035: -----------------
1036: if (g_debug > 0) then
1037:
1038: csd_gen_utility_pvt.dump_api_info
1039: ( p_pkg_name => G_PKG_NAME,
1040: p_api_name => l_api_name );
1041: end if;
1042: ------------------------------------------

Line 1046: csd_gen_utility_pvt.ADD('Repair Group Id '||to_char(p_repair_group_id));

1042: ------------------------------------------
1043: -- Dump the in parameters in the log file
1044: ------------------------------------------
1045: IF (g_debug > 5 ) THEN
1046: csd_gen_utility_pvt.ADD('Repair Group Id '||to_char(p_repair_group_id));
1047:
1048: csd_gen_utility_pvt.ADD('Promise Date '||p_promise_date);
1049:
1050: csd_gen_utility_pvt.ADD('Resource Id '||p_resource_id);

Line 1048: csd_gen_utility_pvt.ADD('Promise Date '||p_promise_date);

1044: ------------------------------------------
1045: IF (g_debug > 5 ) THEN
1046: csd_gen_utility_pvt.ADD('Repair Group Id '||to_char(p_repair_group_id));
1047:
1048: csd_gen_utility_pvt.ADD('Promise Date '||p_promise_date);
1049:
1050: csd_gen_utility_pvt.ADD('Resource Id '||p_resource_id);
1051:
1052: csd_gen_utility_pvt.ADD('Approval Required Flag '||p_approval_required_flag);

Line 1050: csd_gen_utility_pvt.ADD('Resource Id '||p_resource_id);

1046: csd_gen_utility_pvt.ADD('Repair Group Id '||to_char(p_repair_group_id));
1047:
1048: csd_gen_utility_pvt.ADD('Promise Date '||p_promise_date);
1049:
1050: csd_gen_utility_pvt.ADD('Resource Id '||p_resource_id);
1051:
1052: csd_gen_utility_pvt.ADD('Approval Required Flag '||p_approval_required_flag);
1053:
1054: END IF;

Line 1052: csd_gen_utility_pvt.ADD('Approval Required Flag '||p_approval_required_flag);

1048: csd_gen_utility_pvt.ADD('Promise Date '||p_promise_date);
1049:
1050: csd_gen_utility_pvt.ADD('Resource Id '||p_resource_id);
1051:
1052: csd_gen_utility_pvt.ADD('Approval Required Flag '||p_approval_required_flag);
1053:
1054: END IF;
1055:
1056: ---------------------------------

Line 1060: csd_gen_utility_pvt.ADD('Check reqd parameter : Repair Group Id');

1056: ---------------------------------
1057: -- Check the required parameter
1058: ---------------------------------
1059: IF (g_debug > 0 ) THEN
1060: csd_gen_utility_pvt.ADD('Check reqd parameter : Repair Group Id');
1061: END IF;
1062:
1063:
1064: CSD_PROCESS_UTIL.Check_Reqd_Param

Line 1073: csd_gen_utility_pvt.ADD('Validate Repair Group Id');

1069: ---------------------------------
1070: -- Validate Repair Group Id
1071: ---------------------------------
1072: IF (g_debug > 0 ) THEN
1073: csd_gen_utility_pvt.ADD('Validate Repair Group Id');
1074: END IF;
1075:
1076:
1077: IF NOT( CSD_PROCESS_UTIL.Validate_repair_group_id

Line 1086: csd_gen_utility_pvt.ADD('Validate Resource Id');

1082: -----------------------------
1083: -- Validate the Resource Id
1084: -----------------------------
1085: IF (g_debug > 0 ) THEN
1086: csd_gen_utility_pvt.ADD('Validate Resource Id');
1087: END IF;
1088:
1089:
1090: IF(nvl(p_resource_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM)THEN

Line 1114: csd_gen_utility_pvt.ADD('Update the Repair Orders');

1110: -------------------------------
1111: -- Update the Repair Orders
1112: -------------------------------
1113: IF (g_debug > 0 ) THEN
1114: csd_gen_utility_pvt.ADD('Update the Repair Orders');
1115: END IF;
1116:
1117:
1118: l_ro_rec.promise_date := nvl(p_promise_date,FND_API.G_MISS_DATE);

Line 1204: csd_gen_utility_pvt.ADD(' OTHERS l_tot_approved ='||l_tot_approved);

1200: AND approval_required_flag = 'Y';
1201: EXCEPTION
1202: WHEN OTHERS THEN
1203: IF (g_debug > 0 ) THEN
1204: csd_gen_utility_pvt.ADD(' OTHERS l_tot_approved ='||l_tot_approved);
1205: END IF;
1206:
1207: END;
1208:

Line 1220: csd_gen_utility_pvt.ADD(' OTHERS l_tot_rejected ='||l_tot_rejected);

1216: AND approval_required_flag = 'Y';
1217: EXCEPTION
1218: WHEN OTHERS THEN
1219: IF (g_debug > 0 ) THEN
1220: csd_gen_utility_pvt.ADD(' OTHERS l_tot_rejected ='||l_tot_rejected);
1221: END IF;
1222:
1223: END;
1224:

Line 1234: csd_gen_utility_pvt.ADD(' OTHERS l_tot_no_approval ='||l_tot_no_approval);

1230: AND approval_required_flag = 'N';
1231: EXCEPTION
1232: WHEN OTHERS THEN
1233: IF (g_debug > 0 ) THEN
1234: csd_gen_utility_pvt.ADD(' OTHERS l_tot_no_approval ='||l_tot_no_approval);
1235: END IF;
1236:
1237: END;
1238:

Line 1240: csd_gen_utility_pvt.ADD('l_tot_approved ='||l_tot_approved);

1236:
1237: END;
1238:
1239: IF (g_debug > 0 ) THEN
1240: csd_gen_utility_pvt.ADD('l_tot_approved ='||l_tot_approved);
1241: csd_gen_utility_pvt.ADD('l_tot_rejected ='||l_tot_rejected);
1242: csd_gen_utility_pvt.ADD('l_tot_no_approval ='||l_tot_no_approval);
1243: END IF;
1244:

Line 1241: csd_gen_utility_pvt.ADD('l_tot_rejected ='||l_tot_rejected);

1237: END;
1238:
1239: IF (g_debug > 0 ) THEN
1240: csd_gen_utility_pvt.ADD('l_tot_approved ='||l_tot_approved);
1241: csd_gen_utility_pvt.ADD('l_tot_rejected ='||l_tot_rejected);
1242: csd_gen_utility_pvt.ADD('l_tot_no_approval ='||l_tot_no_approval);
1243: END IF;
1244:
1245:

Line 1242: csd_gen_utility_pvt.ADD('l_tot_no_approval ='||l_tot_no_approval);

1238:
1239: IF (g_debug > 0 ) THEN
1240: csd_gen_utility_pvt.ADD('l_tot_approved ='||l_tot_approved);
1241: csd_gen_utility_pvt.ADD('l_tot_rejected ='||l_tot_rejected);
1242: csd_gen_utility_pvt.ADD('l_tot_no_approval ='||l_tot_no_approval);
1243: END IF;
1244:
1245:
1246: --------------------------------------------------------------------------------------------

Line 1257: csd_gen_utility_pvt.ADD('EST_NOT_REQD ');

1253: -- check if all group qty have been approved/rejected
1254: -----------------------------------------------------
1255: IF (NVL(l_group_quantity,0) = NVL(l_tot_no_approval,0)) THEN
1256: IF (g_debug > 0 ) THEN
1257: csd_gen_utility_pvt.ADD('EST_NOT_REQD ');
1258: END IF;
1259:
1260: l_group_ro_rec.group_approval_status := 'EST_NOT_REQD';
1261: l_group_ro_rec.approved_quantity := NVL(l_tot_no_approval,0) ;

Line 1264: csd_gen_utility_pvt.ADD('PARTIAL_APPRD ');

1260: l_group_ro_rec.group_approval_status := 'EST_NOT_REQD';
1261: l_group_ro_rec.approved_quantity := NVL(l_tot_no_approval,0) ;
1262: ELSIF (l_group_quantity > l_count and l_count <> 0 ) THEN
1263: IF (g_debug > 0 ) THEN
1264: csd_gen_utility_pvt.ADD('PARTIAL_APPRD ');
1265: END IF;
1266:
1267: l_group_ro_rec.group_approval_status := 'PARTIAL_APPRD';
1268: l_group_ro_rec.approved_quantity := NVL(l_tot_approved,0) + NVL(l_tot_no_approval,0);

Line 1271: csd_gen_utility_pvt.ADD('APPROVED ');

1267: l_group_ro_rec.group_approval_status := 'PARTIAL_APPRD';
1268: l_group_ro_rec.approved_quantity := NVL(l_tot_approved,0) + NVL(l_tot_no_approval,0);
1269: ELSIF (l_group_quantity = NVL(l_tot_approved,0)+ NVL(l_tot_no_approval,0)) THEN
1270: IF (g_debug > 0 ) THEN
1271: csd_gen_utility_pvt.ADD('APPROVED ');
1272: END IF;
1273:
1274: l_group_ro_rec.group_approval_status := 'APPROVED';
1275: l_group_ro_rec.approved_quantity := NVL(l_tot_approved,0)+ NVL(l_tot_no_approval,0);

Line 1278: csd_gen_utility_pvt.ADD('REJECTED ');

1274: l_group_ro_rec.group_approval_status := 'APPROVED';
1275: l_group_ro_rec.approved_quantity := NVL(l_tot_approved,0)+ NVL(l_tot_no_approval,0);
1276: ELSIF (l_group_quantity = NVL(l_tot_rejected,0)) THEN
1277: IF (g_debug > 0 ) THEN
1278: csd_gen_utility_pvt.ADD('REJECTED ');
1279: END IF;
1280:
1281: l_group_ro_rec.group_approval_status := 'REJECTED';
1282: l_group_ro_rec.approved_quantity := 0 ;

Line 1289: csd_gen_utility_pvt.ADD('CSD_REPAIR_ESTIMATE_PVT.UPDATE_RO_GROUP_ESTIMATE Update Group RO call');

1285: l_group_ro_rec.approved_quantity := 0 ;
1286: END IF;
1287:
1288: IF (g_debug > 0 ) THEN
1289: csd_gen_utility_pvt.ADD('CSD_REPAIR_ESTIMATE_PVT.UPDATE_RO_GROUP_ESTIMATE Update Group RO call');
1290: END IF;
1291:
1292:
1293: -----------------

Line 1308: csd_gen_utility_pvt.ADD('CSD_REPAIR_ESTIMATE_PVT.UPDATE_RO_GROUP_ESTIMATE UPDATE_REPAIR_GROUPS :'||x_return_status);

1304: x_msg_count => l_msg_count,
1305: x_msg_data => l_msg_data );
1306:
1307: IF (g_debug > 0 ) THEN
1308: csd_gen_utility_pvt.ADD('CSD_REPAIR_ESTIMATE_PVT.UPDATE_RO_GROUP_ESTIMATE UPDATE_REPAIR_GROUPS :'||x_return_status);
1309: END IF;
1310:
1311:
1312: IF l_return_status <> 'S' THEN