981: -- Updates schedule Resource table with Assignment id
982: -- Pre-reqs :
983: -- Parameters :
984: --
985: -- Standard IN Parameters :
986: -- p_api_version IN NUMBER Required
987: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
988: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
989: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
989: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
990: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
991: -- p_module_type IN VARCHAR2 Default NULL.
992: --
993: -- Standard OUT Parameters :
994: -- x_return_status OUT VARCHAR2 Required
995: -- x_msg_count OUT NUMBER Required
996: -- x_msg_data OUT VARCHAR2 Required
997: --
1196: l_date_time VARCHAR2(30);
1197:
1198: BEGIN
1199: --------------------Initialize ----------------------------------
1200: -- Standard Start of API savepoint
1201: SAVEPOINT Create_Resrc_Assign;
1202:
1203: -- Check if API is called in debug mode. If yes, enable debug.
1204: IF G_DEBUG='Y' THEN
1209: IF G_DEBUG='Y' THEN
1210: AHL_DEBUG_PUB.debug( 'Enter AHL_PP_RESRC_ASSIGN_PVT. Create_Resrc_Assign','+PPResrc_Assign_Pvt+');
1211: END IF;
1212:
1213: -- Standard call to check for call compatibility.
1214: IF FND_API.to_boolean(p_init_msg_list)
1215: THEN
1216: FND_MSG_PUB.initialize;
1217: END IF;
1606: );
1607:
1608: END LOOP;
1609: END IF;
1610: --Standard check to count messages
1611: l_msg_count := Fnd_Msg_Pub.count_msg;
1612:
1613: IF l_msg_count > 0 THEN
1614: X_msg_count := l_msg_count;
1811: ELSE
1812: l_Resrc_Assign_tbl(i).attribute15 := p_x_resrc_assign_tbl(i).attribute15;
1813: END IF;
1814:
1815: --Standard check to count messages
1816: l_msg_count := Fnd_Msg_Pub.count_msg;
1817:
1818: IF l_msg_count > 0 THEN
1819: X_msg_count := l_msg_count;
1880: END LOOP;
1881: END IF; -- Count > 0
1882: END IF; -- Return status from Eam Api
1883: ------------------------End of Body---------------------------------------
1884: --Standard check to count messages
1885: l_msg_count := Fnd_Msg_Pub.count_msg;
1886:
1887: IF l_msg_count > 0 THEN
1888: X_msg_count := l_msg_count;
1889: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1890: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1891: END IF;
1892:
1893: --Standard check for commit
1894: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1895: COMMIT;
1896: END IF;
1897: -- Debug info
1968: -- Updates Resource table with Assignment Id
1969: -- Pre-reqs :
1970: -- Parameters :
1971: --
1972: -- Standard IN Parameters :
1973: -- p_api_version IN NUMBER Required
1974: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1975: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1976: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1976: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1977: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
1978: -- p_module_type IN VARCHAR2 Default NULL.
1979: --
1980: -- Standard OUT Parameters :
1981: -- x_return_status OUT VARCHAR2 Required
1982: -- x_msg_count OUT NUMBER Required
1983: -- x_msg_data OUT VARCHAR2 Required
1984: --
2162: l_date_time VARCHAR2(30);
2163:
2164: BEGIN
2165: --------------------Initialize ----------------------------------
2166: -- Standard Start of API savepoint
2167: SAVEPOINT Update_Resrc_Assign;
2168:
2169: -- Check if API is called in debug mode. If yes, enable debug.
2170: IF G_DEBUG='Y' THEN
2174: IF G_DEBUG='Y' THEN
2175: AHL_DEBUG_PUB.debug( 'Enter ahl_pp_assign_pvt. Update Resource reqst','+PPResrc_Assign_Pvt+');
2176: END IF;
2177:
2178: -- Standard call to check for call compatibility.
2179: IF FND_API.to_boolean(p_init_msg_list)
2180: THEN
2181: FND_MSG_PUB.initialize;
2182: END IF;
2506:
2507: END LOOP;
2508: END IF;
2509:
2510: --Standard check to count messages
2511: l_msg_count := Fnd_Msg_Pub.count_msg;
2512:
2513: IF l_msg_count > 0 THEN
2514: X_msg_count := l_msg_count;
2767: p_x_resrc_assign_tbl(i).login_date := c_assign_rec.login_date;
2768: END IF;
2769: */
2770:
2771: --Standard check to count messages
2772: l_msg_count := Fnd_Msg_Pub.count_msg;
2773:
2774: IF l_msg_count > 0 THEN
2775: x_msg_count := l_msg_count;
2824: END IF;
2825:
2826: END IF; -- Return status from Ahl Eam Api
2827: ------------------------End of Body---------------------------------------
2828: --Standard check to count messages
2829: l_msg_count := Fnd_Msg_Pub.count_msg;
2830:
2831: IF l_msg_count > 0 THEN
2832: X_msg_count := l_msg_count;
2833: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2834: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2835: END IF;
2836:
2837: --Standard check for commit
2838: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
2839: COMMIT;
2840: END IF;
2841: -- Debug info
2954: j NUMBER;
2955: --
2956: BEGIN
2957: --------------------Initialize ----------------------------------
2958: -- Standard Start of API savepoint
2959: SAVEPOINT Remove_Resource_Assignment;
2960:
2961: -- Check if API is called in debug mode. If yes, enable debug.
2962: IF G_DEBUG='Y' THEN
2965: -- Debug info.
2966: IF G_DEBUG='Y' THEN
2967: Ahl_Debug_Pub.debug( 'enter ahl_ltp_reqst_matrl_pvt Remove Resource Assignment ','+MAATP+');
2968: END IF;
2969: -- Standard call to check for call compatibility.
2970: IF Fnd_Api.to_boolean(p_init_msg_list)
2971: THEN
2972: Fnd_Msg_Pub.initialize;
2973: END IF;
3042: -- ACL Changes
3043: END LOOP;
3044: END IF;
3045:
3046: --Standard check to count messages
3047: l_msg_count := Fnd_Msg_Pub.count_msg;
3048:
3049: IF l_msg_count > 0 THEN
3050: x_msg_count := l_msg_count;
3103: END IF;
3104:
3105: END IF;
3106: ---------------------------End of Body---------------------------------------
3107: --Standard check to count messages
3108: l_msg_count := Fnd_Msg_Pub.count_msg;
3109:
3110: IF l_msg_count > 0 THEN
3111: X_msg_count := l_msg_count;
3112: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3113: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3114: END IF;
3115:
3116: --Standard check for commit
3117: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
3118: COMMIT;
3119: END IF;
3120: -- Debug info
3185: -- Function : Process ............................based on operation flag
3186: -- Pre-reqs :
3187: -- Parameters :
3188: --
3189: -- Standard IN Parameters :
3190: -- p_api_version IN NUMBER Required
3191: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3192: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3193: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3193: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3194: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
3195: -- p_module_type IN VARCHAR2 Default NULL.
3196: --
3197: -- Standard OUT Parameters :
3198: -- x_return_status OUT VARCHAR2 Required
3199: -- x_msg_count OUT NUMBER Required
3200: -- x_msg_data OUT VARCHAR2 Required
3201: --
3229: l_resrc_Assign_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;
3230:
3231: BEGIN
3232: --------------------Initialize ----------------------------------
3233: -- Standard Start of API savepoint
3234: SAVEPOINT Process_Resrc_Assign;
3235:
3236: -- Check if API is called in debug mode. If yes, enable debug.
3237: IF G_DEBUG='Y' THEN
3240: -- Debug info.
3241: IF G_DEBUG='Y' THEN
3242: AHL_DEBUG_PUB.debug( 'Enter AHL_PP_RESRC_ASSIGN.process_resrc_assign','+PPResrc_Assign_Pvt+');
3243: END IF;
3244: -- Standard call to check for call compatibility.
3245: IF FND_API.to_boolean(p_init_msg_list)
3246: THEN
3247: FND_MSG_PUB.initialize;
3248: END IF;
3316:
3317: END IF;
3318: END IF;
3319: ------------------------End of Body---------------------------------------
3320: --Standard check to count messages
3321: l_msg_count := Fnd_Msg_Pub.count_msg;
3322:
3323: IF l_msg_count > 0 THEN
3324: x_msg_count := l_msg_count;
3325: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3326: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3327: END IF;
3328:
3329: --Standard check for commit
3330: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
3331: COMMIT;
3332: END IF;
3333: