[Home] [Help]
222: /* Make the pre processing call to the user hooks */
223:
224: /* Pre Call to the Customer Type User Hook */
225:
226: IF jtf_resource_utl.ok_to_execute(
227: 'JTF_RS_RESOURCE_PVT',
228: 'CREATE_RESOURCE',
229: 'B',
230: 'C')
284:
285:
286: /* Pre Call to the Vertical Type User Hook */
287:
288: IF jtf_resource_utl.ok_to_execute(
289: 'JTF_RS_RESOURCE_PVT',
290: 'CREATE_RESOURCE',
291: 'B',
292: 'V')
347:
348:
349: /* Pre Call to the Internal Type User Hook */
350:
351: IF jtf_resource_utl.ok_to_execute(
352: 'JTF_RS_RESOURCE_PVT',
353: 'CREATE_RESOURCE',
354: 'B',
355: 'I')
408:
409:
410: /* Validate the Input Dates */
411:
412: jtf_resource_utl.validate_input_dates(
413: p_start_date_active => l_start_date_active,
414: p_end_date_active => l_end_date_active,
415: x_return_status => x_return_status
416: );
581: x_attribute14 => p_attribute14,
582: x_attribute15 => p_attribute15,
583: x_attribute_category => p_attribute_category,
584: x_creation_date => SYSDATE,
585: x_created_by => jtf_resource_utl.created_by,
586: x_last_update_date => SYSDATE,
587: x_last_updated_by => jtf_resource_utl.updated_by,
588: x_last_update_login => jtf_resource_utl.login_id
589: );
583: x_attribute_category => p_attribute_category,
584: x_creation_date => SYSDATE,
585: x_created_by => jtf_resource_utl.created_by,
586: x_last_update_date => SYSDATE,
587: x_last_updated_by => jtf_resource_utl.updated_by,
588: x_last_update_login => jtf_resource_utl.login_id
589: );
590:
591: -- dbms_output.put_line('After Insert Procedure');
584: x_creation_date => SYSDATE,
585: x_created_by => jtf_resource_utl.created_by,
586: x_last_update_date => SYSDATE,
587: x_last_updated_by => jtf_resource_utl.updated_by,
588: x_last_update_login => jtf_resource_utl.login_id
589: );
590:
591: -- dbms_output.put_line('After Insert Procedure');
592: OPEN c_jtf_rs_resource_extns(l_rowid);
733:
734:
735: /* Post Call to the Internal Type User Hook */
736:
737: IF jtf_resource_utl.ok_to_execute(
738: 'JTF_RS_RESOURCE_PVT',
739: 'CREATE_RESOURCE',
740: 'A',
741: 'I')
794:
795:
796: /* Standard call for Message Generation */
797:
798: IF jtf_resource_utl.ok_to_execute(
799: 'JTF_RS_RESOURCE_PVT',
800: 'CREATE_RESOURCE',
801: 'M',
802: 'M')
878: p_data => x_msg_data);
879: WHEN OTHERS THEN
880: ROLLBACK TO create_resource_pvt;
881: -- The below lines removed as a part of fixing GSCC errors in R12 for jtfrspub.pls
882: -- IF NOT(jtf_resource_utl.check_access(l_value))
883: -- THEN
884: -- IF(l_value = 'XMLGEN')
885: -- THEN
886: -- fnd_message.set_name ('JTF', 'JTF_RS_XMLGEN_ERR');
1178: /* Make the pre processing call to the user hooks */
1179:
1180: /* Pre Call to the Customer Type User Hook */
1181:
1182: IF jtf_resource_utl.ok_to_execute(
1183: 'JTF_RS_RESOURCE_PVT',
1184: 'CREATE_RESOURCE',
1185: 'B',
1186: 'C')
1241:
1242:
1243: /* Pre Call to the Vertical Type User Hook */
1244:
1245: IF jtf_resource_utl.ok_to_execute(
1246: 'JTF_RS_RESOURCE_PVT',
1247: 'CREATE_RESOURCE',
1248: 'B',
1249: 'V')
1304:
1305:
1306: /* Pre Call to the Internal Type User Hook */
1307:
1308: IF jtf_resource_utl.ok_to_execute(
1309: 'JTF_RS_RESOURCE_PVT',
1310: 'CREATE_RESOURCE',
1311: 'B',
1312: 'I')
1366:
1367:
1368: /* Validate the Input Dates */
1369:
1370: jtf_resource_utl.validate_input_dates(
1371: p_start_date_active => l_start_date_active,
1372: p_end_date_active => l_end_date_active,
1373: x_return_status => x_return_status
1374: );
1573: x_attribute14 => p_attribute14,
1574: x_attribute15 => p_attribute15,
1575: x_attribute_category => p_attribute_category,
1576: x_creation_date => SYSDATE,
1577: x_created_by => jtf_resource_utl.created_by,
1578: x_last_update_date => SYSDATE,
1579: x_last_updated_by => jtf_resource_utl.updated_by,
1580: x_last_update_login => jtf_resource_utl.login_id,
1581: x_resource_name => l_resource_name,
1575: x_attribute_category => p_attribute_category,
1576: x_creation_date => SYSDATE,
1577: x_created_by => jtf_resource_utl.created_by,
1578: x_last_update_date => SYSDATE,
1579: x_last_updated_by => jtf_resource_utl.updated_by,
1580: x_last_update_login => jtf_resource_utl.login_id,
1581: x_resource_name => l_resource_name,
1582: x_source_name => l_source_name,
1583: x_source_number => l_source_number,
1576: x_creation_date => SYSDATE,
1577: x_created_by => jtf_resource_utl.created_by,
1578: x_last_update_date => SYSDATE,
1579: x_last_updated_by => jtf_resource_utl.updated_by,
1580: x_last_update_login => jtf_resource_utl.login_id,
1581: x_resource_name => l_resource_name,
1582: x_source_name => l_source_name,
1583: x_source_number => l_source_number,
1584: x_source_job_title => l_source_job_title,
1693: END IF;
1694:
1695: /* Post Call to the Vertical Type User Hook */
1696:
1697: IF jtf_resource_utl.ok_to_execute(
1698: 'JTF_RS_RESOURCE_PVT',
1699: 'CREATE_RESOURCE',
1700: 'A',
1701: 'V')
1757:
1758:
1759: /* Post Call to the Internal Type User Hook */
1760:
1761: IF jtf_resource_utl.ok_to_execute(
1762: 'JTF_RS_RESOURCE_PVT',
1763: 'CREATE_RESOURCE',
1764: 'A',
1765: 'I')
1818:
1819:
1820: /* Standard call for Message Generation */
1821:
1822: IF jtf_resource_utl.ok_to_execute(
1823: 'JTF_RS_RESOURCE_PVT',
1824: 'CREATE_RESOURCE',
1825: 'M',
1826: 'M')
1954: p_data => x_msg_data);
1955: WHEN OTHERS THEN
1956: ROLLBACK TO create_resource_pvt;
1957: -- The below lines removed as a part of fixing GSCC errors in R12 for jtfrspub.pls
1958: -- IF NOT(jtf_resource_utl.check_access(l_value))
1959: -- THEN
1960: -- IF(l_value = 'XMLGEN')
1961: -- THEN
1962: -- fnd_message.set_name ('JTF', 'JTF_RS_XMLGEN_ERR');
2082: P_ATTRIBUTE13 => P_ATTRIBUTE13,
2083: P_ATTRIBUTE14 => P_ATTRIBUTE14,
2084: P_ATTRIBUTE15 => P_ATTRIBUTE15,
2085: P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY,
2086: P_SOURCE_NAME => JTF_RESOURCE_UTL.G_SOURCE_NAME,
2087: P_RESOURCE_NAME => JTF_RESOURCE_UTL.G_SOURCE_NAME,
2088: X_RETURN_STATUS => X_RETURN_STATUS,
2089: X_MSG_COUNT => X_MSG_COUNT,
2090: X_MSG_DATA => X_MSG_DATA,
2083: P_ATTRIBUTE14 => P_ATTRIBUTE14,
2084: P_ATTRIBUTE15 => P_ATTRIBUTE15,
2085: P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY,
2086: P_SOURCE_NAME => JTF_RESOURCE_UTL.G_SOURCE_NAME,
2087: P_RESOURCE_NAME => JTF_RESOURCE_UTL.G_SOURCE_NAME,
2088: X_RETURN_STATUS => X_RETURN_STATUS,
2089: X_MSG_COUNT => X_MSG_COUNT,
2090: X_MSG_DATA => X_MSG_DATA,
2091: X_RESOURCE_ID => X_RESOURCE_ID,
2169: l_user_id jtf_rs_resource_extns.user_id%TYPE;
2170: --l_location mdsys.sdo_geometry := p_location;
2171: l_object_version_num jtf_rs_resource_extns.object_version_number%TYPE;
2172:
2173: -- added for NOCOPY to handle in JTF_RESOURCE_UTL
2174: l_managing_emp_id_out jtf_rs_resource_extns.managing_employee_id%TYPE ;
2175: l_server_group_id_out jtf_rs_resource_extns.server_group_id%TYPE ;
2176: l_comp_service_team_id_out jtf_rs_resource_extns.comp_service_team_id%TYPE;
2177:
2417: /* Make the pre processing call to the user hooks */
2418:
2419: /* Pre Call to the Customer Type User Hook */
2420:
2421: IF jtf_resource_utl.ok_to_execute(
2422: 'JTF_RS_RESOURCE_PVT',
2423: 'UPDATE_RESOURCE',
2424: 'B',
2425: 'C')
2477:
2478:
2479: /* Pre Call to the Vertical Type User Hook */
2480:
2481: IF jtf_resource_utl.ok_to_execute(
2482: 'JTF_RS_RESOURCE_PVT',
2483: 'UPDATE_RESOURCE',
2484: 'B',
2485: 'V')
2537:
2538:
2539: /* Pre Call to the Internal Type User Hook */
2540:
2541: IF jtf_resource_utl.ok_to_execute(
2542: 'JTF_RS_RESOURCE_PVT',
2543: 'UPDATE_RESOURCE',
2544: 'B',
2545: 'I')
2618: /* Validate the Managing Employee Id if specified */
2619:
2620: IF l_managing_emp_id <> fnd_api.g_miss_num THEN
2621:
2622: jtf_resource_utl.validate_employee_resource(
2623: p_emp_resource_id => l_managing_emp_id,
2624: p_emp_resource_number => null,
2625: x_return_status => x_return_status,
2626: x_emp_resource_id => l_managing_emp_id_out
2651: -- Changing the values being passed to "validate_input_dates" procedure,
2652: -- from l_end_date_active to resource_rec.end_date_active (same for start date)
2653: -- so that it validates the correct dates which its supposed to validate.
2654:
2655: jtf_resource_utl.validate_input_dates(
2656: p_start_date_active => resource_rec.start_date_active,
2657: p_end_date_active => resource_rec.end_date_active,
2658: x_return_status => x_return_status
2659: );
3060: IF l_time_zone <> fnd_api.g_miss_num THEN
3061:
3062: IF l_time_zone IS NOT NULL THEN
3063:
3064: jtf_resource_utl.validate_time_zone(
3065: p_time_zone_id => l_time_zone,
3066: x_return_status => x_return_status
3067: );
3068:
3088: IF l_primary_language <> fnd_api.g_miss_char THEN
3089:
3090: IF l_primary_language IS NOT NULL THEN
3091:
3092: jtf_resource_utl.validate_nls_language(
3093: p_nls_language => l_primary_language,
3094: x_return_status => x_return_status
3095: );
3096:
3116: IF l_secondary_language <> fnd_api.g_miss_char THEN
3117:
3118: IF l_secondary_language IS NOT NULL THEN
3119:
3120: jtf_resource_utl.validate_nls_language(
3121: p_nls_language => l_secondary_language,
3122: x_return_status => x_return_status
3123: );
3124:
3144: IF l_support_site_id <> fnd_api.g_miss_num THEN
3145:
3146: IF l_support_site_id IS NOT NULL THEN
3147:
3148: jtf_resource_utl.validate_support_site_id(
3149: p_support_site_id => l_support_site_id,
3150: x_return_status => x_return_status
3151: );
3152:
3170: /* Validate the Server Group. */
3171:
3172: IF l_server_group_id <> fnd_api.g_miss_num THEN
3173:
3174: jtf_resource_utl.validate_server_group(
3175: p_server_group_id => l_server_group_id,
3176: p_server_group_name => null,
3177: x_return_status => x_return_status,
3178: x_server_group_id => l_server_group_id_out
3239: IF l_comp_currency_code <> fnd_api.g_miss_char THEN
3240:
3241: IF l_comp_currency_code IS NOT NULL THEN
3242:
3243: jtf_resource_utl.validate_currency_code(
3244: p_currency_code => l_comp_currency_code,
3245: x_return_status => x_return_status
3246: );
3247:
3307: IF l_hold_reason_code <> fnd_api.g_miss_char THEN
3308:
3309: IF l_hold_reason_code IS NOT NULL THEN
3310:
3311: jtf_resource_utl.validate_hold_reason_code(
3312: p_hold_reason_code => l_hold_reason_code,
3313: x_return_status => x_return_status
3314: );
3315:
3353: /* Validate the User Id if specified */
3354:
3355: IF l_user_id IS NOT NULL THEN
3356:
3357: jtf_resource_utl.validate_user_id(
3358: p_user_id => l_user_id,
3359: p_category => resource_rec.category,
3360: p_source_id => resource_rec.source_id,
3361: x_return_status => x_return_status
3408: IF l_comp_service_team_id <> fnd_api.g_miss_num THEN
3409:
3410: IF l_comp_service_team_id IS NOT NULL THEN
3411:
3412: jtf_resource_utl.validate_resource_team(
3413: p_team_id => l_comp_service_team_id,
3414: p_team_number => null,
3415: x_return_status => x_return_status,
3416: x_team_id => l_comp_service_team_id_out
3578: x_attribute14 => resource_rec.attribute14,
3579: x_attribute15 => resource_rec.attribute15,
3580: x_attribute_category => resource_rec.attribute_category,
3581: x_last_update_date => SYSDATE,
3582: x_last_updated_by => jtf_resource_utl.updated_by,
3583: x_last_update_login => jtf_resource_utl.login_id
3584: );
3585:
3586: --dbms_output.put_line ('After Call to Update Row Table Handler ');
3579: x_attribute15 => resource_rec.attribute15,
3580: x_attribute_category => resource_rec.attribute_category,
3581: x_last_update_date => SYSDATE,
3582: x_last_updated_by => jtf_resource_utl.updated_by,
3583: x_last_update_login => jtf_resource_utl.login_id
3584: );
3585:
3586: --dbms_output.put_line ('After Call to Update Row Table Handler ');
3587:
3626: /* Make the post processing call to the user hooks */
3627:
3628: /* Post Call to the Customer Type User Hook */
3629:
3630: IF jtf_resource_utl.ok_to_execute(
3631: 'JTF_RS_RESOURCE_PVT',
3632: 'UPDATE_RESOURCE',
3633: 'A',
3634: 'C')
3685:
3686:
3687: /* Post Call to the Vertical Type User Hook */
3688:
3689: IF jtf_resource_utl.ok_to_execute(
3690: 'JTF_RS_RESOURCE_PVT',
3691: 'UPDATE_RESOURCE',
3692: 'A',
3693: 'V')
3745:
3746:
3747: /* Post Call to the Internal Type User Hook */
3748:
3749: IF jtf_resource_utl.ok_to_execute(
3750: 'JTF_RS_RESOURCE_PVT',
3751: 'UPDATE_RESOURCE',
3752: 'A',
3753: 'I')
3804:
3805:
3806: /* Standard call for Message Generation */
3807:
3808: IF jtf_resource_utl.ok_to_execute(
3809: 'JTF_RS_RESOURCE_PVT',
3810: 'UPDATE_RESOURCE',
3811: 'M',
3812: 'M')
3889: p_data => x_msg_data);
3890: WHEN OTHERS THEN
3891: ROLLBACK TO update_resource_pvt;
3892: -- The below lines removed as a part of fixing GSCC errors in R12 for jtfrspub.pls
3893: -- IF NOT(jtf_resource_utl.check_access(l_value))
3894: -- THEN
3895: -- IF(l_value = 'XMLGEN')
3896: -- THEN
3897: -- fnd_message.set_name ('JTF', 'JTF_RS_XMLGEN_ERR');
4074: l_source_category jtf_rs_resource_extns.source_category%type;
4075: l_user_name jtf_rs_resource_extns.user_name%type;
4076:
4077:
4078: --added for NOCOPY to handle in JTF_RESOURCE_UTL
4079: l_managing_emp_id_out jtf_rs_resource_extns.managing_employee_id%TYPE ;
4080: l_server_group_id_out jtf_rs_resource_extns.server_group_id%TYPE ;
4081: l_comp_service_team_id_out jtf_rs_resource_extns.comp_service_team_id%TYPE;
4082: l_fs_setup_complete jtf_rs_resource_extns.fs_setup_complete%type;
4393: /* Make the pre processing call to the user hooks */
4394:
4395: /* Pre Call to the Customer Type User Hook */
4396:
4397: IF jtf_resource_utl.ok_to_execute(
4398: 'JTF_RS_RESOURCE_PVT',
4399: 'UPDATE_RESOURCE',
4400: 'B',
4401: 'C')
4453:
4454:
4455: /* Pre Call to the Vertical Type User Hook */
4456:
4457: IF jtf_resource_utl.ok_to_execute(
4458: 'JTF_RS_RESOURCE_PVT',
4459: 'UPDATE_RESOURCE',
4460: 'B',
4461: 'V')
4512:
4513:
4514: /* Pre Call to the Internal Type User Hook */
4515:
4516: IF jtf_resource_utl.ok_to_execute(
4517: 'JTF_RS_RESOURCE_PVT',
4518: 'UPDATE_RESOURCE',
4519: 'B',
4520: 'I')
4596: /* Validate the Managing Employee Id if specified */
4597:
4598: IF l_managing_emp_id <> fnd_api.g_miss_num THEN
4599:
4600: jtf_resource_utl.validate_employee_resource(
4601: p_emp_resource_id => l_managing_emp_id,
4602: p_emp_resource_number => null,
4603: x_return_status => x_return_status,
4604: x_emp_resource_id => l_managing_emp_id_out
4632: -- Changing the values being passed to "validate_input_dates" procedure,
4633: -- from l_end_date_active to resource_rec.end_date_active (same for start date)
4634: -- so that it validates the correct dates which its supposed to validate.
4635:
4636: jtf_resource_utl.validate_input_dates(
4637: p_start_date_active => resource_rec.start_date_active,
4638: p_end_date_active => resource_rec.end_date_active,
4639: x_return_status => x_return_status
4640: );
5027: IF l_time_zone <> fnd_api.g_miss_num THEN
5028:
5029: IF l_time_zone IS NOT NULL THEN
5030:
5031: jtf_resource_utl.validate_time_zone(
5032: p_time_zone_id => l_time_zone,
5033: x_return_status => x_return_status
5034: );
5035:
5055: IF l_primary_language <> fnd_api.g_miss_char THEN
5056:
5057: IF l_primary_language IS NOT NULL THEN
5058:
5059: jtf_resource_utl.validate_nls_language(
5060: p_nls_language => l_primary_language,
5061: x_return_status => x_return_status
5062: );
5063:
5083: IF l_secondary_language <> fnd_api.g_miss_char THEN
5084:
5085: IF l_secondary_language IS NOT NULL THEN
5086:
5087: jtf_resource_utl.validate_nls_language(
5088: p_nls_language => l_secondary_language,
5089: x_return_status => x_return_status
5090: );
5091:
5111: IF l_support_site_id <> fnd_api.g_miss_num THEN
5112:
5113: IF l_support_site_id IS NOT NULL THEN
5114:
5115: jtf_resource_utl.validate_support_site_id(
5116: p_support_site_id => l_support_site_id,
5117: x_return_status => x_return_status
5118: );
5119:
5137: /* Validate the Server Group. */
5138:
5139: IF l_server_group_id <> fnd_api.g_miss_num THEN
5140:
5141: jtf_resource_utl.validate_server_group(
5142: p_server_group_id => l_server_group_id,
5143: p_server_group_name => null,
5144: x_return_status => x_return_status,
5145: x_server_group_id => l_server_group_id_out
5207: IF l_comp_currency_code <> fnd_api.g_miss_char THEN
5208:
5209: IF l_comp_currency_code IS NOT NULL THEN
5210:
5211: jtf_resource_utl.validate_currency_code(
5212: p_currency_code => l_comp_currency_code,
5213: x_return_status => x_return_status
5214: );
5215:
5275: IF l_hold_reason_code <> fnd_api.g_miss_char THEN
5276:
5277: IF l_hold_reason_code IS NOT NULL THEN
5278:
5279: jtf_resource_utl.validate_hold_reason_code(
5280: p_hold_reason_code => l_hold_reason_code,
5281: x_return_status => x_return_status
5282: );
5283:
5320: /* Validate the User Id if specified */
5321:
5322: IF l_user_id IS NOT NULL THEN
5323:
5324: jtf_resource_utl.validate_user_id(
5325: p_user_id => l_user_id,
5326: p_category => resource_rec.category,
5327: p_source_id => resource_rec.source_id,
5328: x_return_status => x_return_status
5376: IF l_comp_service_team_id <> fnd_api.g_miss_num THEN
5377:
5378: IF l_comp_service_team_id IS NOT NULL THEN
5379:
5380: jtf_resource_utl.validate_resource_team(
5381: p_team_id => l_comp_service_team_id,
5382: p_team_number => null,
5383: x_return_status => x_return_status,
5384: x_team_id => l_comp_service_team_id_out
5682: x_attribute14 => resource_rec.attribute14,
5683: x_attribute15 => resource_rec.attribute15,
5684: x_attribute_category => resource_rec.attribute_category,
5685: x_last_update_date => SYSDATE,
5686: x_last_updated_by => jtf_resource_utl.updated_by,
5687: x_last_update_login => jtf_resource_utl.login_id,
5688: x_resource_name => resource_rec.resource_name,
5689: x_source_name => resource_rec.source_name,
5690: x_source_number => resource_rec.source_number,
5683: x_attribute15 => resource_rec.attribute15,
5684: x_attribute_category => resource_rec.attribute_category,
5685: x_last_update_date => SYSDATE,
5686: x_last_updated_by => jtf_resource_utl.updated_by,
5687: x_last_update_login => jtf_resource_utl.login_id,
5688: x_resource_name => resource_rec.resource_name,
5689: x_source_name => resource_rec.source_name,
5690: x_source_number => resource_rec.source_number,
5691: x_source_job_title => resource_rec.source_job_title,
5768: /* Make the post processing call to the user hooks */
5769:
5770: /* Post Call to the Customer Type User Hook */
5771:
5772: IF jtf_resource_utl.ok_to_execute(
5773: 'JTF_RS_RESOURCE_PVT',
5774: 'UPDATE_RESOURCE',
5775: 'A',
5776: 'C')
5827:
5828:
5829: /* Post Call to the Vertical Type User Hook */
5830:
5831: IF jtf_resource_utl.ok_to_execute(
5832: 'JTF_RS_RESOURCE_PVT',
5833: 'UPDATE_RESOURCE',
5834: 'A',
5835: 'V')
5887:
5888:
5889: /* Post Call to the Internal Type User Hook */
5890:
5891: IF jtf_resource_utl.ok_to_execute(
5892: 'JTF_RS_RESOURCE_PVT',
5893: 'UPDATE_RESOURCE',
5894: 'A',
5895: 'I')
5947:
5948:
5949: /* Standard call for Message Generation */
5950:
5951: IF jtf_resource_utl.ok_to_execute(
5952: 'JTF_RS_RESOURCE_PVT',
5953: 'UPDATE_RESOURCE',
5954: 'M',
5955: 'M')
6032: p_data => x_msg_data);
6033: WHEN OTHERS THEN
6034: ROLLBACK TO update_resource_pvt;
6035: -- The below lines removed as a part of fixing GSCC errors in R12 for jtfrspub.pls
6036: -- IF NOT(jtf_resource_utl.check_access(l_value))
6037: -- THEN
6038: -- IF(l_value = 'XMLGEN')
6039: -- THEN
6040: -- fnd_message.set_name ('JTF', 'JTF_RS_XMLGEN_ERR');
6283: /* Make the pre processing call to the user hooks */
6284:
6285: /* Pre Call to the Customer Type User Hook */
6286:
6287: IF jtf_resource_utl.ok_to_execute(
6288: 'JTF_RS_RESOURCE_PVT',
6289: 'DELETE_RESOURCE',
6290: 'B',
6291: 'C')
6317:
6318:
6319: /* Pre Call to the Vertical Type User Hook */
6320:
6321: IF jtf_resource_utl.ok_to_execute(
6322: 'JTF_RS_RESOURCE_PVT',
6323: 'DELETE_RESOURCE',
6324: 'B',
6325: 'V')
6451:
6452:
6453: /* Post Call to the Vertical Type User Hook */
6454:
6455: IF jtf_resource_utl.ok_to_execute(
6456: 'JTF_RS_RESOURCE_PVT',
6457: 'DELETE_RESOURCE',
6458: 'A',
6459: 'V')
6483:
6484:
6485: /* Post Call to the Internal Type User Hook */
6486:
6487: IF jtf_resource_utl.ok_to_execute(
6488: 'JTF_RS_RESOURCE_PVT',
6489: 'DELETE_RESOURCE',
6490: 'A',
6491: 'I')
6517:
6518:
6519: /* Standard call for Message Generation */
6520:
6521: IF jtf_resource_utl.ok_to_execute(
6522: 'JTF_RS_RESOURCE_PVT',
6523: 'DELETE_RESOURCE',
6524: 'M',
6525: 'M')
6643: p_data => x_msg_data);
6644: WHEN OTHERS THEN
6645: ROLLBACK TO delete_resource_pvt;
6646: -- The below lines removed as a part of fixing GSCC errors in R12 for jtfrspub.pls
6647: -- IF NOT(jtf_resource_utl.check_access(l_value))
6648: -- THEN
6649: -- IF(l_value = 'XMLGEN')
6650: -- THEN
6651: -- fnd_message.set_name ('JTF', 'JTF_RS_XMLGEN_ERR');