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 146: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Create_Repair_Order before CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type');

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

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

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

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

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

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

487: p_ro_warranty_status_code => p_ro_warranty_status_code,
488: x_Repln_Rec => l_Repln_Rec);
489: --
490: if (g_debug > 0) then
491: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Repair_Order before CSD_REPAIRS_PUB.Update_Repair_Order');
492: end if;
493: CSD_REPAIRS_PUB.Update_Repair_Order
494: (p_API_version_number => 1.0,
495: p_init_msg_list => p_init_msg_list,

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

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

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

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

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

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

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

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

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

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

Line 1155: csd_gen_utility_pvt.dump_api_info

1151:
1152: --------------------
1153: -- Api body starts
1154: --------------------
1155: csd_gen_utility_pvt.dump_api_info
1156: ( p_pkg_name => G_PKG_NAME,
1157: p_api_name => l_api_name );
1158:
1159: ---------------------------------

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1502: csd_gen_utility_pvt.dump_api_info

1498: x_return_status := FND_API.G_RET_STS_SUCCESS;
1499: --------------------
1500: -- Api body starts
1501: --------------------
1502: csd_gen_utility_pvt.dump_api_info
1503: ( p_pkg_name => G_PKG_NAME,
1504: p_api_name => l_api_name );
1505:
1506: ---------------------------------

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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