[Home] [Help]
832: 'At the start of PL SQL procedure.' ||
833: ', p_task_id = ' || p_task_id);
834: END IF;
835:
836: -- Standard start of API savepoint
837: SAVEPOINT Get_Task_Details;
838:
839: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
840: Fnd_Msg_Pub.initialize;
842:
843: -- Initialize API return status to success
844: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
845:
846: -- Standard call to check for call compatibility.
847: IF NOT Fnd_Api.compatible_api_call(
848: l_api_version,
849: p_api_version,
850: l_api_name,
1061:
1062: x_task_rec := l_task_rec;
1063:
1064: ------------------------End of API Body------------------------------------
1065: -- Standard call to get message count and if count is 1, get message info
1066: /* Fnd_Msg_Pub.Count_And_Get
1067: ( p_count => x_msg_count,
1068: p_data => x_msg_data,
1069: p_encoded => Fnd_Api.g_false); */
1067: ( p_count => x_msg_count,
1068: p_data => x_msg_data,
1069: p_encoded => Fnd_Api.g_false); */
1070:
1071: --Standard check to count messages
1072: l_msg_count := Fnd_Msg_Pub.count_msg;
1073:
1074: IF l_msg_count > 0 THEN
1075: x_msg_count := l_msg_count;
1159:
1160: -- Initialize API return status to success
1161: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1162:
1163: -- Standard call to check for call compatibility.
1164: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
1165: p_api_version,
1166: l_api_name,G_PKG_NAME)
1167: THEN
1311:
1312: -- post 115.10 changes end
1313:
1314: --------------------End of API Body-------------------------------------
1315: --Standard check to count messages
1316: l_msg_count := Fnd_Msg_Pub.count_msg;
1317:
1318: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
1319: x_msg_count := l_msg_count;
1320: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1321: RAISE Fnd_Api.G_EXC_ERROR;
1322: END IF;
1323:
1324: --Standard check for commit
1325: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1326: COMMIT;
1327: END IF;
1328:
1450:
1451: -- Initialize API return status to success
1452: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1453:
1454: -- Standard call to check for call compatibility.
1455: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
1456: p_api_version,
1457: l_api_name,G_PKG_NAME)
1458: THEN
1969: L_DEBUG_KEY,
1970: 'After Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times, Return Status = '|| l_return_status );
1971: END IF;
1972:
1973: --Standard check to count messages
1974: l_msg_count := Fnd_Msg_Pub.count_msg;
1975:
1976: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
1977: x_msg_count := l_msg_count;
2029: END IF;
2030: END IF;
2031:
2032: ---------------------------End of API Body---------------------------------------
2033: --Standard check to count messages
2034: l_msg_count := Fnd_Msg_Pub.count_msg;
2035:
2036: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
2037: x_msg_count := l_msg_count;
2038: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2039: RAISE Fnd_Api.G_EXC_ERROR;
2040: END IF;
2041:
2042: --Standard check for commit
2043: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
2044: COMMIT;
2045: END IF;
2046:
2158:
2159: -- Initialize API return status to success
2160: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2161:
2162: -- Standard call to check for call compatibility.
2163: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
2164: p_api_version,
2165: l_api_name,G_PKG_NAME)
2166: THEN
2618: L_DEBUG_KEY,
2619: 'After Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times, Return Status = '|| l_return_status );
2620: END IF;
2621:
2622: --Standard check to count messages
2623: l_msg_count := Fnd_Msg_Pub.count_msg;
2624:
2625: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
2626: x_msg_count := l_msg_count;
2651:
2652: END IF; -- Check for visit status code in case if closed or any other
2653:
2654: ---------------------------End of API Body---------------------------------------
2655: --Standard check to count messages
2656: l_msg_count := Fnd_Msg_Pub.count_msg;
2657:
2658: IF l_msg_count > 0 THEN
2659: x_msg_count := l_msg_count;
2660: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2661: RAISE Fnd_Api.G_EXC_ERROR;
2662: END IF;
2663:
2664: --Standard check for commit
2665: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
2666: COMMIT;
2667: END IF;
2668:
2754:
2755: -- Initialize API return status to success
2756: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2757:
2758: -- Standard call to check for call compatibility.
2759: IF NOT Fnd_Api.compatible_api_call(
2760: l_api_version,
2761: p_api_version,
2762: l_api_name,
2833: RAISE FND_API.G_EXC_ERROR;
2834: END IF;
2835:
2836: ------------------------End of API Body------------------------------------
2837: --Standard check to count messages
2838: l_msg_count := Fnd_Msg_Pub.count_msg;
2839:
2840: IF l_msg_count > 0 THEN
2841: x_msg_count := l_msg_count;
2842: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2843: RAISE Fnd_Api.G_EXC_ERROR;
2844: END IF;
2845:
2846: --Standard check for commit
2847: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
2848: COMMIT;
2849: END IF;
2850:
3073:
3074: -- Initialize API return status to success
3075: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3076:
3077: -- Standard call to check for call compatibility.
3078: IF NOT Fnd_Api.compatible_api_call(
3079: l_api_version,
3080: p_api_version,
3081: l_api_name,
3420: ---- END 11.5.10 CHANGES FOR COSTING ----
3421: --------------------------------------------------------------------------
3422:
3423: ------------------------End of API Body------------------------------------
3424: --Standard check to count messages
3425: l_msg_count := Fnd_Msg_Pub.count_msg;
3426:
3427: IF l_msg_count > 0 THEN
3428: x_msg_count := l_msg_count;
3429: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3430: RAISE Fnd_Api.G_EXC_ERROR;
3431: END IF;
3432:
3433: --Standard check for commit
3434: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
3435: COMMIT;
3436: END IF;
3437:
3589:
3590: -- Initialize API return status to success
3591: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3592:
3593: -- Standard call to check for call compatibility.
3594: IF NOT Fnd_Api.compatible_api_call(
3595: l_api_version,
3596: p_api_version,
3597: l_api_name,
3725: L_DEBUG_KEY,
3726: 'After Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times, Return Status = '|| l_return_status );
3727: END IF;
3728:
3729: --Standard check to count messages
3730: l_msg_count := Fnd_Msg_Pub.count_msg;
3731:
3732: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
3733: x_msg_count := l_msg_count;
3748: x_return_status => x_return_status);
3749: END IF;
3750: END IF;
3751:
3752: --Standard check to count messages
3753: l_msg_count := Fnd_Msg_Pub.count_msg;
3754:
3755: IF l_msg_count > 0 THEN
3756: x_msg_count := l_msg_count;
3757: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3758: RAISE Fnd_Api.G_EXC_ERROR;
3759: END IF;
3760:
3761: --Standard check for commit
3762: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
3763: COMMIT;
3764: END IF;
3765:
3861:
3862: -- Initialize API return status to success
3863: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3864:
3865: -- Standard call to check for call compatibility.
3866: IF NOT Fnd_Api.compatible_api_call(
3867: l_api_version,
3868: p_api_version,
3869: l_api_name,
4160: Fnd_Msg_Pub.ADD;
4161: RAISE Fnd_Api.G_EXC_ERROR;
4162: END IF;
4163:
4164: --Standard check to count messages
4165: l_msg_count := Fnd_Msg_Pub.count_msg;
4166:
4167: IF l_msg_count > 0 THEN
4168: x_msg_count := l_msg_count;
4258: L_DEBUG_KEY,
4259: 'After Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times, Return Status = ' || l_return_status);
4260: END IF;
4261:
4262: --Standard check to count messages
4263: l_msg_count := Fnd_Msg_Pub.count_msg;
4264:
4265: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
4266: x_msg_count := l_msg_count;
4328:
4329: -------------------- finish --------------------------
4330:
4331: ------------------------End of API Body------------------------------------
4332: --Standard check to count messages
4333: l_msg_count := Fnd_Msg_Pub.count_msg;
4334:
4335: IF l_msg_count > 0 THEN
4336: x_msg_count := l_msg_count;
4337: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4338: RAISE Fnd_Api.G_EXC_ERROR;
4339: END IF;
4340:
4341: --Standard check for commit
4342: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
4343: COMMIT;
4344: END IF;
4345:
4440:
4441: -- Initialize API return status to success
4442: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4443:
4444: -- Standard call to check for call compatibility.
4445: IF NOT Fnd_Api.compatible_api_call(
4446: l_api_version,
4447: p_api_version,
4448: l_api_name,
4724: Fnd_Msg_Pub.ADD;
4725: RAISE Fnd_Api.G_EXC_ERROR;
4726: END IF;
4727:
4728: --Standard check to count messages
4729: l_msg_count := Fnd_Msg_Pub.count_msg;
4730:
4731: IF l_msg_count > 0 THEN
4732: x_msg_count := l_msg_count;
4823: L_DEBUG_KEY,
4824: 'After Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times, Return Status = ' || l_return_status);
4825: END IF;
4826:
4827: --Standard check to count messages
4828: l_msg_count := Fnd_Msg_Pub.count_msg;
4829:
4830: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
4831: x_msg_count := l_msg_count;
4832: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4833: RAISE Fnd_Api.G_EXC_ERROR;
4834: END IF;
4835:
4836: --Standard check for commit
4837: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
4838: COMMIT;
4839: END IF;
4840:
4972:
4973: -- Initialize API return status to success
4974: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4975:
4976: -- Standard call to check for call compatibility.
4977: IF NOT Fnd_Api.compatible_api_call(
4978: l_api_version,
4979: p_api_version,
4980: l_api_name,
5288: END IF;
5289: END IF;
5290: ------------------------End of API Body------------------------------------
5291:
5292: --Standard check to count messages
5293: l_msg_count := Fnd_Msg_Pub.count_msg;
5294:
5295: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
5296: x_msg_count := l_msg_count;
5297: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5298: RAISE Fnd_Api.G_EXC_ERROR;
5299: END IF;
5300:
5301: --Standard check for commit
5302: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
5303: COMMIT;
5304: END IF;
5305:
5439:
5440: -- Initialize API return status to success
5441: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5442:
5443: -- Standard call to check for call compatibility.
5444: IF NOT Fnd_Api.compatible_api_call(
5445: l_api_version,
5446: p_api_version,
5447: l_api_name,
5837: -- Initialize API return status to success
5838:
5839: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5840:
5841: -- Standard call to check for call compatibility.
5842: IF NOT Fnd_Api.compatible_api_call(L_api_version,p_api_version,
5843: l_api_name, G_PKG_NAME)
5844: THEN
5845: RAISE Fnd_Api.g_exc_unexpected_error;
6294: -- Initialize API return status to success
6295:
6296: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
6297:
6298: -- Standard call to check for call compatibility.
6299: IF NOT Fnd_Api.compatible_api_call(L_api_version,p_api_version,
6300: l_api_name, G_PKG_NAME)
6301: THEN
6302: RAISE Fnd_Api.g_exc_unexpected_error;
6959:
6960: -- Initialize API return status to success
6961: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
6962:
6963: -- Standard call to check for call compatibility.
6964: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
6965: p_api_version,
6966: l_api_name,G_PKG_NAME)
6967: THEN
7032: END LOOP;
7033: END IF;
7034:
7035: ---------------------------End of Body---------------------------------------
7036: --Standard check to count messages
7037: l_msg_count := Fnd_Msg_Pub.count_msg;
7038:
7039: IF l_msg_count > 0 THEN
7040: x_msg_count := l_msg_count;
7041: x_return_status := Fnd_Api.G_RET_STS_ERROR;
7042: RAISE Fnd_Api.G_EXC_ERROR;
7043: END IF;
7044:
7045: --Standard check for commit
7046: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
7047: COMMIT;
7048: END IF;
7049:
7158: ':Check items2');
7159: END IF;
7160:
7161: -------------------- finish --------------------------
7162: -- Standard call to get message count and if count is 1, get message info
7163: Fnd_Msg_Pub.count_and_get (
7164: p_encoded => Fnd_Api.g_false,
7165: p_count => x_msg_count,
7166: p_data => x_msg_data
7541:
7542: -- Initialize API return status to success
7543: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
7544:
7545: -- Standard call to check for call compatibility.
7546: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
7547: p_api_version,
7548: l_api_name,G_PKG_NAME)
7549: THEN
7731: 'Succesful updation of the status');
7732: END IF;
7733: p_x_task_tbl:=l_task_tbl; --Added by rnahata for Bug 6939329
7734: --------------------End of API Body-------------------------------------
7735: --Standard check to count messages
7736: l_msg_count := Fnd_Msg_Pub.count_msg;
7737:
7738: IF l_msg_count > 0 THEN
7739: x_msg_count := l_msg_count;
7740: x_return_status := Fnd_Api.G_RET_STS_ERROR;
7741: RAISE Fnd_Api.G_EXC_ERROR;
7742: END IF;
7743:
7744: --Standard check for commit
7745: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
7746: COMMIT;
7747: END IF;
7748:
7787: -- Type : Private
7788: -- Function : To create Unassociated/Summary/Non-Routine task for a visit
7789: -- Parameters :
7790: --
7791: -- Standard IN Parameters :
7792: -- p_api_version IN NUMBER Required
7793: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
7794: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
7795: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
7795: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
7796: -- p_module_type IN VARCHAR2 Default NULL.
7797: -- p_visit_rec IN AHL_VWP_VISITS_PVT.Visit_Rec_Type,
7798: --
7799: -- Standard OUT Parameters :
7800: -- x_return_status OUT VARCHAR2 Required
7801: -- x_msg_count OUT NUMBER Required
7802: -- x_msg_data OUT VARCHAR2 Required
7803: --
7869:
7870: -- Initialize API return status to success
7871: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
7872:
7873: -- Standard call to check for call compatibility.
7874: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
7875: p_api_version,
7876: l_api_name,G_PKG_NAME)
7877: THEN
7970: END IF; -- Instance ID is not null.
7971:
7972: END IF; -- Visit id and Visit type is not null.
7973: --------------------End of API Body-------------------------------------
7974: --Standard check to count messages
7975: l_msg_count := Fnd_Msg_Pub.count_msg;
7976:
7977: IF l_msg_count > 0 THEN
7978: x_msg_count := l_msg_count;