[Home] [Help]
984: 'At the start of PL SQL procedure.' ||
985: ', p_task_id = ' || p_task_id);
986: END IF;
987:
988: -- Standard start of API savepoint
989: SAVEPOINT Get_Task_Details;
990:
991: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
992: Fnd_Msg_Pub.initialize;
994:
995: -- Initialize API return status to success
996: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
997:
998: -- Standard call to check for call compatibility.
999: IF NOT Fnd_Api.compatible_api_call(
1000: l_api_version,
1001: p_api_version,
1002: l_api_name,
1275:
1276: x_task_rec := l_task_rec;
1277:
1278: ------------------------End of API Body------------------------------------
1279: -- Standard call to get message count and if count is 1, get message info
1280: /* Fnd_Msg_Pub.Count_And_Get
1281: ( p_count => x_msg_count,
1282: p_data => x_msg_data,
1283: p_encoded => Fnd_Api.g_false); */
1281: ( p_count => x_msg_count,
1282: p_data => x_msg_data,
1283: p_encoded => Fnd_Api.g_false); */
1284:
1285: --Standard check to count messages
1286: l_msg_count := Fnd_Msg_Pub.count_msg;
1287:
1288: IF l_msg_count > 0 THEN
1289: x_msg_count := l_msg_count;
1401:
1402: -- Initialize API return status to success
1403: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1404:
1405: -- Standard call to check for call compatibility.
1406: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
1407: p_api_version,
1408: l_api_name,G_PKG_NAME)
1409: THEN
1758: -- Kasridha : Changes for Component Maintenance Planning Ends
1759: */
1760:
1761: --------------------End of API Body-------------------------------------
1762: --Standard check to count messages
1763: l_msg_count := Fnd_Msg_Pub.count_msg;
1764:
1765: -- AJPRASAN :: VWPE :: Bug# 12424063 - Added the check for NOT overwriting x_return_status,
1766: -- if l_return_status is 'V'
1778: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1779: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1780: END IF;
1781:
1782: --Standard check for commit
1783: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1784: COMMIT;
1785: END IF;
1786:
1909:
1910: -- Initialize API return status to success
1911: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1912:
1913: -- Standard call to check for call compatibility.
1914: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
1915: p_api_version,
1916: l_api_name,G_PKG_NAME)
1917: THEN
2491: L_DEBUG_KEY,
2492: 'After Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times, Return Status = '|| l_return_status );
2493: END IF;
2494:
2495: --Standard check to count messages
2496: l_msg_count := Fnd_Msg_Pub.count_msg;
2497:
2498: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
2499: x_msg_count := l_msg_count;
2556: END IF;
2557: END IF;
2558: */
2559: ---------------------------End of API Body---------------------------------------
2560: --Standard check to count messages
2561: l_msg_count := Fnd_Msg_Pub.count_msg;
2562:
2563: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
2564: x_msg_count := l_msg_count;
2565: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2566: RAISE Fnd_Api.G_EXC_ERROR;
2567: END IF;
2568:
2569: --Standard check for commit
2570: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
2571: COMMIT;
2572: END IF;
2573:
2687:
2688: -- Initialize API return status to success
2689: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2690:
2691: -- Standard call to check for call compatibility.
2692: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
2693: p_api_version,
2694: l_api_name,G_PKG_NAME)
2695: THEN
3210: L_DEBUG_KEY,
3211: 'After Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times, Return Status = '|| l_return_status );
3212: END IF;
3213:
3214: --Standard check to count messages
3215: l_msg_count := Fnd_Msg_Pub.count_msg;
3216:
3217: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
3218: x_msg_count := l_msg_count;
3245:
3246: END IF; -- Check for visit status code in case if closed or any other
3247:
3248: ---------------------------End of API Body---------------------------------------
3249: --Standard check to count messages
3250: l_msg_count := Fnd_Msg_Pub.count_msg;
3251:
3252: IF l_msg_count > 0 THEN
3253: x_msg_count := l_msg_count;
3254: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3255: RAISE Fnd_Api.G_EXC_ERROR;
3256: END IF;
3257:
3258: --Standard check for commit
3259: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
3260: COMMIT;
3261: END IF;
3262:
3360:
3361: -- Initialize API return status to success
3362: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3363:
3364: -- Standard call to check for call compatibility.
3365: IF NOT Fnd_Api.compatible_api_call(
3366: l_api_version,
3367: p_api_version,
3368: l_api_name,
3572: RAISE FND_API.G_EXC_ERROR;
3573: END IF;
3574:
3575: ------------------------End of API Body------------------------------------
3576: --Standard check to count messages
3577: l_msg_count := Fnd_Msg_Pub.count_msg;
3578:
3579: IF l_msg_count > 0 THEN
3580: x_msg_count := l_msg_count;
3581: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3582: RAISE Fnd_Api.G_EXC_ERROR;
3583: END IF;
3584:
3585: --Standard check for commit
3586: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
3587: COMMIT;
3588: END IF;
3589:
3812:
3813: -- Initialize API return status to success
3814: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3815:
3816: -- Standard call to check for call compatibility.
3817: IF NOT Fnd_Api.compatible_api_call(
3818: l_api_version,
3819: p_api_version,
3820: l_api_name,
4169: ---- END 11.5.10 CHANGES FOR COSTING ----
4170: --------------------------------------------------------------------------
4171:
4172: ------------------------End of API Body------------------------------------
4173: --Standard check to count messages
4174: l_msg_count := Fnd_Msg_Pub.count_msg;
4175:
4176: IF l_msg_count > 0 THEN
4177: x_msg_count := l_msg_count;
4178: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4179: RAISE Fnd_Api.G_EXC_ERROR;
4180: END IF;
4181:
4182: --Standard check for commit
4183: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
4184: COMMIT;
4185: END IF;
4186:
4342:
4343: -- Initialize API return status to success
4344: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4345:
4346: -- Standard call to check for call compatibility.
4347: IF NOT Fnd_Api.compatible_api_call(
4348: l_api_version,
4349: p_api_version,
4350: l_api_name,
4526: L_DEBUG_KEY,
4527: 'After Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times, Return Status = '|| l_return_status );
4528: END IF;
4529:
4530: --Standard check to count messages
4531: l_msg_count := Fnd_Msg_Pub.count_msg;
4532:
4533: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
4534: x_msg_count := l_msg_count;
4549: x_return_status => x_return_status);
4550: END IF;
4551: END IF;
4552:
4553: --Standard check to count messages
4554: l_msg_count := Fnd_Msg_Pub.count_msg;
4555:
4556: IF l_msg_count > 0 THEN
4557: x_msg_count := l_msg_count;
4558: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4559: RAISE Fnd_Api.G_EXC_ERROR;
4560: END IF;
4561:
4562: --Standard check for commit
4563: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
4564: COMMIT;
4565: END IF;
4566:
4663:
4664: -- Initialize API return status to success
4665: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4666:
4667: -- Standard call to check for call compatibility.
4668: IF NOT Fnd_Api.compatible_api_call(
4669: l_api_version,
4670: p_api_version,
4671: l_api_name,
4962: Fnd_Msg_Pub.ADD;
4963: RAISE Fnd_Api.G_EXC_ERROR;
4964: END IF;
4965:
4966: --Standard check to count messages
4967: l_msg_count := Fnd_Msg_Pub.count_msg;
4968:
4969: IF l_msg_count > 0 THEN
4970: x_msg_count := l_msg_count;
5134: L_DEBUG_KEY,
5135: 'After Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times, Return Status = ' || l_return_status);
5136: END IF;
5137:
5138: --Standard check to count messages
5139: l_msg_count := Fnd_Msg_Pub.count_msg;
5140:
5141: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
5142: x_msg_count := l_msg_count;
5204:
5205: -------------------- finish --------------------------
5206:
5207: ------------------------End of API Body------------------------------------
5208: --Standard check to count messages
5209: l_msg_count := Fnd_Msg_Pub.count_msg;
5210:
5211: IF l_msg_count > 0 THEN
5212: x_msg_count := l_msg_count;
5213: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5214: RAISE Fnd_Api.G_EXC_ERROR;
5215: END IF;
5216:
5217: --Standard check for commit
5218: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
5219: COMMIT;
5220: END IF;
5221:
5317:
5318: -- Initialize API return status to success
5319: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5320:
5321: -- Standard call to check for call compatibility.
5322: IF NOT Fnd_Api.compatible_api_call(
5323: l_api_version,
5324: p_api_version,
5325: l_api_name,
5609: Fnd_Msg_Pub.ADD;
5610: RAISE Fnd_Api.G_EXC_ERROR;
5611: END IF;
5612:
5613: --Standard check to count messages
5614: l_msg_count := Fnd_Msg_Pub.count_msg;
5615:
5616: IF l_msg_count > 0 THEN
5617: x_msg_count := l_msg_count;
5777: L_DEBUG_KEY,
5778: 'After Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times, Return Status = ' || l_return_status);
5779: END IF;
5780:
5781: --Standard check to count messages
5782: l_msg_count := Fnd_Msg_Pub.count_msg;
5783:
5784: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
5785: x_msg_count := l_msg_count;
5786: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5787: RAISE Fnd_Api.G_EXC_ERROR;
5788: END IF;
5789:
5790: --Standard check for commit
5791: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
5792: COMMIT;
5793: END IF;
5794:
5945:
5946: -- Initialize API return status to success
5947: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5948:
5949: -- Standard call to check for call compatibility.
5950: IF NOT Fnd_Api.compatible_api_call(
5951: l_api_version,
5952: p_api_version,
5953: l_api_name,
6326: END IF;
6327: END IF;
6328: ------------------------End of API Body------------------------------------
6329:
6330: --Standard check to count messages
6331: l_msg_count := Fnd_Msg_Pub.count_msg;
6332:
6333: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
6334: x_msg_count := l_msg_count;
6335: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6336: RAISE Fnd_Api.G_EXC_ERROR;
6337: END IF;
6338:
6339: --Standard check for commit
6340: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
6341: COMMIT;
6342: END IF;
6343:
6478:
6479: -- Initialize API return status to success
6480: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
6481:
6482: -- Standard call to check for call compatibility.
6483: IF NOT Fnd_Api.compatible_api_call(
6484: l_api_version,
6485: p_api_version,
6486: l_api_name,
6917: -- Initialize API return status to success
6918:
6919: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
6920:
6921: -- Standard call to check for call compatibility.
6922: IF NOT Fnd_Api.compatible_api_call(L_api_version,p_api_version,
6923: l_api_name, G_PKG_NAME)
6924: THEN
6925: RAISE Fnd_Api.g_exc_unexpected_error;
7441: -- Initialize API return status to success
7442:
7443: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
7444:
7445: -- Standard call to check for call compatibility.
7446: IF NOT Fnd_Api.compatible_api_call(L_api_version,p_api_version,
7447: l_api_name, G_PKG_NAME)
7448: THEN
7449: RAISE Fnd_Api.g_exc_unexpected_error;
8262:
8263: -- Initialize API return status to success
8264: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
8265:
8266: -- Standard call to check for call compatibility.
8267: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
8268: p_api_version,
8269: l_api_name,G_PKG_NAME)
8270: THEN
8335: END LOOP;
8336: END IF;
8337:
8338: ---------------------------End of Body---------------------------------------
8339: --Standard check to count messages
8340: l_msg_count := Fnd_Msg_Pub.count_msg;
8341:
8342: IF l_msg_count > 0 THEN
8343: x_msg_count := l_msg_count;
8344: x_return_status := Fnd_Api.G_RET_STS_ERROR;
8345: RAISE Fnd_Api.G_EXC_ERROR;
8346: END IF;
8347:
8348: --Standard check for commit
8349: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
8350: COMMIT;
8351: END IF;
8352:
8461: ':Check items2');
8462: END IF;
8463:
8464: -------------------- finish --------------------------
8465: -- Standard call to get message count and if count is 1, get message info
8466: Fnd_Msg_Pub.count_and_get (
8467: p_encoded => Fnd_Api.g_false,
8468: p_count => x_msg_count,
8469: p_data => x_msg_data
8897:
8898: -- Initialize API return status to success
8899: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
8900:
8901: -- Standard call to check for call compatibility.
8902: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
8903: p_api_version,
8904: l_api_name,G_PKG_NAME)
8905: THEN
9554: 'Component Maintenance changes ends' );
9555: END IF;
9556: -- Kasridha : Changes for Component Maintenance Planning Ends
9557: --------------------End of API Body-------------------------------------
9558: --Standard check to count messages
9559: l_msg_count := Fnd_Msg_Pub.count_msg;
9560:
9561: IF l_msg_count > 0 THEN
9562: x_msg_count := l_msg_count;
9563: x_return_status := Fnd_Api.G_RET_STS_ERROR;
9564: RAISE Fnd_Api.G_EXC_ERROR;
9565: END IF;
9566:
9567: --Standard check for commit
9568: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
9569: COMMIT;
9570: END IF;
9571:
9610: -- Type : Private
9611: -- Function : To create Unassociated/Summary/Non-Routine task for a visit
9612: -- Parameters :
9613: --
9614: -- Standard IN Parameters :
9615: -- p_api_version IN NUMBER Required
9616: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
9617: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
9618: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
9618: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
9619: -- p_module_type IN VARCHAR2 Default NULL.
9620: -- p_visit_rec IN AHL_VWP_VISITS_PVT.Visit_Rec_Type,
9621: --
9622: -- Standard OUT Parameters :
9623: -- x_return_status OUT VARCHAR2 Required
9624: -- x_msg_count OUT NUMBER Required
9625: -- x_msg_data OUT VARCHAR2 Required
9626: --
9696:
9697: -- Initialize API return status to success
9698: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
9699:
9700: -- Standard call to check for call compatibility.
9701: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
9702: p_api_version,
9703: l_api_name,G_PKG_NAME)
9704: THEN
9797: END IF; -- Instance ID is not null.
9798:
9799: END IF; -- Visit id and Visit type is not null.
9800: --------------------End of API Body-------------------------------------
9801: --Standard check to count messages
9802: l_msg_count := Fnd_Msg_Pub.count_msg;
9803:
9804: IF l_msg_count > 0 THEN
9805: x_msg_count := l_msg_count;
9858: PROCEDURE Get_Entl_rec_for_Delete(
9859: p_task_id IN NUMBER,
9860: x_warranty_entl_tbl OUT NOCOPY AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Tbl_Type
9861: ) IS
9862: -- Standard variables
9863: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Entl_rec_for_Delete';
9864: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
9865: -- Local variables defined for the procedure
9866: l_warranty_entl_id NUMBER := null;
10014:
10015: -- Initialize API return status to success
10016: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
10017:
10018: -- Standard call to check for call compatibility.
10019: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
10020: p_api_version,
10021: l_api_name,G_PKG_NAME)
10022: THEN
10168:
10169:
10170:
10171: --------------------End of API Body-------------------------------------
10172: --Standard check to count messages
10173: l_msg_count := Fnd_Msg_Pub.count_msg;
10174:
10175: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063 :: Automatically create draft WOs if tasks are added to a visit that is in any of the below three statuses
10176: IF visit_details_rec.status_code IN ('PLANNING', 'PARTIALLY RELEASED', 'RELEASED') THEN
10218: x_msg_count := l_msg_count;
10219: RAISE Fnd_Api.G_EXC_ERROR;
10220: END IF;
10221:
10222: --Standard check for commit
10223: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
10224: COMMIT;
10225: END IF;
10226:
10371:
10372: -- Initialize API return status to success
10373: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
10374:
10375: -- Standard call to check for call compatibility.
10376: IF NOT Fnd_Api.compatible_api_call(
10377: l_api_version,
10378: p_api_version,
10379: l_api_name,