DBA Data[Home] [Help]

APPS.CSD_REPAIRS_GRP dependencies on CSD_GEN_UTILITY_PVT

Line 34: g_debug NUMBER := csd_gen_utility_pvt.g_debug_level;

30: -- NOTE :
31: --
32: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_REPAIRS_GRP';
33: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdgdrab.pls';
34: g_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
35: --
36: PROCEDURE Create_Repair_Order(
37: p_Init_Msg_List IN VARCHAR2 := 'F',
38: p_Commit IN VARCHAR2 := 'F',

Line 145: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Create_Repair_Order before CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type');

141: --
142: -- API body
143: --
144: if (g_debug) > 0 then
145: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Create_Repair_Order before CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type');
146: end if;
147: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
148: (p_repair_number => p_repair_number,
149: p_incident_id => p_incident_id,

Line 227: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Create_Repair_Order before CSD_REPAIRS_PVT.Create_Repair_Order');

223: p_escalation_code => p_escalation_code,
224: x_Repln_Rec => l_Repln_Rec);
225: --
226: if (g_debug > 0) then
227: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Create_Repair_Order before CSD_REPAIRS_PVT.Create_Repair_Order');
228: end if;
229: -- travi fix to create call from RO not to validate for Group_id
230: l_Repln_Rec.REPAIR_GROUP_ID := null;
231:

Line 407: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Repair_Order before CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type');

403: --
404: -- API body
405: --
406: if (g_debug > 0 ) then
407: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Repair_Order before CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type');
408: end if;
409: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
410: (p_repair_number => p_repair_number,
411: p_incident_id => p_incident_id,

Line 487: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Repair_Order before CSD_REPAIRS_PUB.Update_Repair_Order');

483: p_escalation_code => p_escalation_code,
484: x_Repln_Rec => l_Repln_Rec);
485: --
486: if (g_debug > 0) then
487: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Repair_Order before CSD_REPAIRS_PUB.Update_Repair_Order');
488: end if;
489: CSD_REPAIRS_PUB.Update_Repair_Order
490: (p_API_version_number => 1.0,
491: p_init_msg_list => p_init_msg_list,

Line 667: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Approval_Status before api CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call');

663: p_object_version_number := l_Repln_Rec.object_version_number;
664: END IF;
665: --
666: if (g_debug > 0) then
667: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Approval_Status before api CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call');
668: end if;
669:
670: -- swai 11.5.10
671: -- check for event code before:

Line 901: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status before CSD_REPAIRS_PVT.Update_Repair_Order');

897:
898: end if;
899: --
900: if (g_debug > 0) then
901: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status before CSD_REPAIRS_PVT.Update_Repair_Order');
902: end if;
903: CSD_REPAIRS_PVT.Update_Repair_Order
904: (p_API_version_number => 1.0,
905: p_init_msg_list => FND_API.G_TRUE,

Line 915: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status after CSD_REPAIRS_PVT.Update_Repair_Order status : '||x_return_status);

911: x_msg_count => x_msg_count,
912: x_msg_data => x_msg_data
913: );
914: if (g_debug > 0) then
915: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status after CSD_REPAIRS_PVT.Update_Repair_Order status : '||x_return_status);
916: end if;
917: --
918: -- Check return status from the above procedure call
919: IF not (x_return_status = FND_API.G_RET_STS_SUCCESS) then

Line 931: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write');

927: */
928: -- travi 010902 change added if cond
929: --if p_new_status <> p_old_status then
930: if (g_debug > 0) then
931: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write');
932: end if;
933:
934: CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write
935: (p_Api_Version_Number => 1.0 ,

Line 1006: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write status : '||x_return_status);

1002: X_Msg_Count => x_msg_count,
1003: X_Msg_Data => x_msg_data
1004: );
1005: if (g_debug > 0) then
1006: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write status : '||x_return_status);
1007: end if;
1008: --end if; -- only for changed status codes sangigup 3232547
1009: --
1010: -- Check return status from the above procedure call

Line 1151: csd_gen_utility_pvt.dump_api_info

1147:
1148: --------------------
1149: -- Api body starts
1150: --------------------
1151: csd_gen_utility_pvt.dump_api_info
1152: ( p_pkg_name => G_PKG_NAME,
1153: p_api_name => l_api_name );
1154:
1155: ---------------------------------

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

1155: ---------------------------------
1156: -- Check the required parameter
1157: ---------------------------------
1158: if (g_debug > 0) then
1159: csd_gen_utility_pvt.ADD('Check reqd parameter: Repair Group Id ');
1160: end if;
1161: CSD_PROCESS_UTIL.Check_Reqd_Param
1162: ( p_param_value => p_repair_group_id,
1163: p_param_name => 'REPAIR_GROUP_ID',

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

1166: ----------------------------------
1167: -- Validate the Repair Group Id
1168: ----------------------------------
1169: if (g_debug > 0) then
1170: csd_gen_utility_pvt.ADD('Repair Group Id');
1171: end if;
1172: IF NOT( CSD_PROCESS_UTIL.Validate_repair_group_id
1173: ( p_repair_group_id => p_repair_group_id )) THEN
1174: RAISE FND_API.G_EXC_ERROR;

Line 1203: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status convert repairs rec call');

1199: ----------------------------------
1200: -- API Body
1201: ----------------------------------
1202: if (g_debug > 0) then
1203: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status convert repairs rec call');
1204: end if;
1205: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
1206: (p_approval_status => l_approval_status,
1207: p_object_version_number => l_rep_ovn,

Line 1211: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update repairs call');

1207: p_object_version_number => l_rep_ovn,
1208: x_repln_rec => l_rep_ord_rec
1209: );
1210: if (g_debug > 0) then
1211: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update repairs call');
1212: end if;
1213: CSD_REPAIRS_PVT.Update_Repair_Order
1214: (p_API_version_number => 1.0,
1215: p_init_msg_list => FND_API.G_TRUE,

Line 1226: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update_Repair_Order :'||x_return_status);

1222: x_msg_data => x_msg_data
1223: );
1224:
1225: if (g_debug > 0) then
1226: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update_Repair_Order :'||x_return_status);
1227: end if;
1228: -- Check return status from the update RO call
1229: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1230: if (g_debug > 0) then

Line 1231: csd_gen_utility_pvt.ADD('CSD_REPAIRS_PVT.Update_Repair_Order failed ');

1227: end if;
1228: -- Check return status from the update RO call
1229: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1230: if (g_debug > 0) then
1231: csd_gen_utility_pvt.ADD('CSD_REPAIRS_PVT.Update_Repair_Order failed ');
1232: end if;
1233: RAISE FND_API.G_EXC_ERROR;
1234: --ROLLBACK TO UPDATE_GRP_APPV_STATUS;
1235: --return;

Line 1238: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update RO hist call');

1234: --ROLLBACK TO UPDATE_GRP_APPV_STATUS;
1235: --return;
1236: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) then
1237: if (g_debug > 0) then
1238: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update RO hist call');
1239: end if;
1240: CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write
1241: (p_Api_Version_Number => 1.0 ,
1242: p_init_msg_list => 'F',

Line 1312: csd_gen_utility_pvt.add('Update_Group_Approval_Status Validate_And_Write :'||x_return_status);

1308: X_Msg_Count => x_msg_count,
1309: X_Msg_Data => x_msg_data
1310: );
1311: if (g_debug > 0) then
1312: csd_gen_utility_pvt.add('Update_Group_Approval_Status Validate_And_Write :'||x_return_status);
1313: end if;
1314: -- Check return status from the above procedure call
1315: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1316: if (g_debug > 0) then

Line 1317: csd_gen_utility_pvt.ADD('CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write failed ');

1313: end if;
1314: -- Check return status from the above procedure call
1315: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1316: if (g_debug > 0) then
1317: csd_gen_utility_pvt.ADD('CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write failed ');
1318: end if;
1319: RAISE FND_API.G_EXC_ERROR;
1320: --ROLLBACK TO UPDATE_GRP_APPV_STATUS;
1321: --return;

Line 1329: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update RO estimate call');

1325: l_rep_est_rec.repair_line_id := l_repair_line_id;
1326: l_rep_est_rec.object_version_number := l_est_ovn;
1327: l_rep_est_rec.estimate_status := l_estimate_status;
1328: if (g_debug > 0) then
1329: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update RO estimate call');
1330: end if;
1331: csd_repair_estimate_pvt.update_repair_estimate
1332: (p_api_version => 1.0,
1333: p_commit => 'F',

Line 1341: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status update_repair_estimate :'||x_return_status);

1337: x_return_status => x_return_status,
1338: x_msg_count => l_msg_count,
1339: x_msg_data => l_msg_data);
1340: if (g_debug > 0) then
1341: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status update_repair_estimate :'||x_return_status);
1342: end if;
1343: -- Check return status from the above procedure call
1344: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1345: if (g_debug > 0) then

Line 1346: csd_gen_utility_pvt.ADD('csd_repair_estimate_pvt.update_repair_estimate failed ');

1342: end if;
1343: -- Check return status from the above procedure call
1344: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1345: if (g_debug > 0) then
1346: csd_gen_utility_pvt.ADD('csd_repair_estimate_pvt.update_repair_estimate failed ');
1347: end if;
1348: RAISE FND_API.G_EXC_ERROR;
1349: --ROLLBACK TO UPDATE_GRP_APPV_STATUS;
1350: --return;

Line 1498: csd_gen_utility_pvt.dump_api_info

1494: x_return_status := FND_API.G_RET_STS_SUCCESS;
1495: --------------------
1496: -- Api body starts
1497: --------------------
1498: csd_gen_utility_pvt.dump_api_info
1499: ( p_pkg_name => G_PKG_NAME,
1500: p_api_name => l_api_name );
1501:
1502: ---------------------------------

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

1502: ---------------------------------
1503: -- Check the required parameter
1504: ---------------------------------
1505: if (g_debug > 0) then
1506: csd_gen_utility_pvt.ADD('Check reqd parameter: Repair Group Id ');
1507: end if;
1508: CSD_PROCESS_UTIL.Check_Reqd_Param
1509: ( p_param_value => p_repair_group_id,
1510: p_param_name => 'REPAIR_GROUP_ID',

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

1513: ----------------------------------
1514: -- Validate the Repair Group Id
1515: ----------------------------------
1516: if (g_debug > 0) then
1517: csd_gen_utility_pvt.ADD('Repair Group Id');
1518: end if;
1519: IF NOT( CSD_PROCESS_UTIL.Validate_repair_group_id
1520: ( p_repair_group_id => p_repair_group_id )) THEN
1521: RAISE FND_API.G_EXC_ERROR;

Line 1551: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status convert repairs rec call');

1547: -- API Body
1548: ----------------------------------
1549:
1550: if (g_debug > 0) then
1551: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status convert repairs rec call');
1552: end if;
1553: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
1554: (p_approval_status => l_Reject_status,
1555: p_object_version_number => l_rep_ovn,

Line 1559: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update repairs call');

1555: p_object_version_number => l_rep_ovn,
1556: x_repln_rec => l_rep_ord_rec
1557: );
1558: if (g_debug > 0) then
1559: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update repairs call');
1560: end if;
1561: CSD_REPAIRS_PVT.Update_Repair_Order
1562: (p_API_version_number => 1.0,
1563: p_init_msg_list => FND_API.G_TRUE,

Line 1574: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update_Repair_Order :'||x_return_status);

1570: x_msg_data => x_msg_data
1571: );
1572:
1573: if (g_debug > 0) then
1574: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update_Repair_Order :'||x_return_status);
1575: end if;
1576: -- Check return status from the update RO call
1577: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1578: if (g_debug > 0) then

Line 1579: csd_gen_utility_pvt.ADD('CSD_REPAIRS_PVT.Update_Repair_Order failed ');

1575: end if;
1576: -- Check return status from the update RO call
1577: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1578: if (g_debug > 0) then
1579: csd_gen_utility_pvt.ADD('CSD_REPAIRS_PVT.Update_Repair_Order failed ');
1580: end if;
1581: RAISE FND_API.G_EXC_ERROR;
1582: --ROLLBACK TO UPDATE_GRP_REJT_STATUS;
1583: --return;

Line 1586: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update RO hist call');

1582: --ROLLBACK TO UPDATE_GRP_REJT_STATUS;
1583: --return;
1584: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) then
1585: if (g_debug > 0) then
1586: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update RO hist call');
1587: end if;
1588: CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write
1589: (p_Api_Version_Number => 1.0 ,
1590: p_init_msg_list => 'F',

Line 1660: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Validate_And_Write :'||x_return_status);

1656: X_Msg_Count => x_msg_count,
1657: X_Msg_Data => x_msg_data
1658: );
1659: if (g_debug > 0) then
1660: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Validate_And_Write :'||x_return_status);
1661: end if;
1662: -- Check return status from the above procedure call
1663: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1664: if (g_debug > 0) then

Line 1665: csd_gen_utility_pvt.ADD('CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write failed ');

1661: end if;
1662: -- Check return status from the above procedure call
1663: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1664: if (g_debug > 0) then
1665: csd_gen_utility_pvt.ADD('CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write failed ');
1666: end if;
1667: RAISE FND_API.G_EXC_ERROR;
1668: --ROLLBACK TO UPDATE_GRP_REJT_STATUS;
1669: --return;

Line 1677: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update RO estimate call');

1673: l_rep_est_rec.repair_line_id := l_repair_line_id;
1674: l_rep_est_rec.object_version_number := l_est_ovn;
1675: l_rep_est_rec.estimate_status := l_estimate_status;
1676: if (g_debug > 0) then
1677: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update RO estimate call');
1678: end if;
1679: csd_repair_estimate_pvt.update_repair_estimate
1680: (p_api_version => 1.0,
1681: p_commit => 'F',

Line 1689: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status update_repair_estimate :'||x_return_status);

1685: x_return_status => x_return_status,
1686: x_msg_count => l_msg_count,
1687: x_msg_data => l_msg_data);
1688: if (g_debug > 0) then
1689: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status update_repair_estimate :'||x_return_status);
1690: end if;
1691: -- Check return status from the above procedure call
1692: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1693: if (g_debug > 0) then

Line 1694: csd_gen_utility_pvt.ADD('csd_repair_estimate_pvt.update_repair_estimate failed ');

1690: end if;
1691: -- Check return status from the above procedure call
1692: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1693: if (g_debug > 0) then
1694: csd_gen_utility_pvt.ADD('csd_repair_estimate_pvt.update_repair_estimate failed ');
1695: end if;
1696: RAISE FND_API.G_EXC_ERROR;
1697: --ROLLBACK TO UPDATE_GRP_REJT_STATUS;
1698: --return;