eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_RESOURCE_PVT dependencies on JTF_RESOURCE_UTL

Line 226: IF jtf_resource_utl.ok_to_execute(

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')

Line 288: IF jtf_resource_utl.ok_to_execute(

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')

Line 351: IF jtf_resource_utl.ok_to_execute(

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')

Line 412: jtf_resource_utl.validate_input_dates(

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: );

Line 585: x_created_by => jtf_resource_utl.created_by,

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: );

Line 587: x_last_updated_by => jtf_resource_utl.updated_by,

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');

Line 588: x_last_update_login => jtf_resource_utl.login_id

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);

Line 737: IF jtf_resource_utl.ok_to_execute(

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')

Line 798: IF jtf_resource_utl.ok_to_execute(

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')

Line 882: -- IF NOT(jtf_resource_utl.check_access(l_value))

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');

Line 1182: IF jtf_resource_utl.ok_to_execute(

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')

Line 1245: IF jtf_resource_utl.ok_to_execute(

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')

Line 1308: IF jtf_resource_utl.ok_to_execute(

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')

Line 1370: jtf_resource_utl.validate_input_dates(

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: );

Line 1577: x_created_by => jtf_resource_utl.created_by,

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,

Line 1579: x_last_updated_by => jtf_resource_utl.updated_by,

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,

Line 1580: x_last_update_login => jtf_resource_utl.login_id,

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,

Line 1697: IF jtf_resource_utl.ok_to_execute(

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')

Line 1761: IF jtf_resource_utl.ok_to_execute(

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')

Line 1822: IF jtf_resource_utl.ok_to_execute(

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')

Line 1958: -- IF NOT(jtf_resource_utl.check_access(l_value))

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');

Line 2086: P_SOURCE_NAME => JTF_RESOURCE_UTL.G_SOURCE_NAME,

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,

Line 2087: P_RESOURCE_NAME => JTF_RESOURCE_UTL.G_SOURCE_NAME,

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,

Line 2173: -- added for NOCOPY to handle in JTF_RESOURCE_UTL

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:

Line 2422: IF jtf_resource_utl.ok_to_execute(

2418: /* Make the pre processing call to the user hooks */
2419:
2420: /* Pre Call to the Customer Type User Hook */
2421:
2422: IF jtf_resource_utl.ok_to_execute(
2423: 'JTF_RS_RESOURCE_PVT',
2424: 'UPDATE_RESOURCE',
2425: 'B',
2426: 'C')

Line 2482: IF jtf_resource_utl.ok_to_execute(

2478:
2479:
2480: /* Pre Call to the Vertical Type User Hook */
2481:
2482: IF jtf_resource_utl.ok_to_execute(
2483: 'JTF_RS_RESOURCE_PVT',
2484: 'UPDATE_RESOURCE',
2485: 'B',
2486: 'V')

Line 2542: IF jtf_resource_utl.ok_to_execute(

2538:
2539:
2540: /* Pre Call to the Internal Type User Hook */
2541:
2542: IF jtf_resource_utl.ok_to_execute(
2543: 'JTF_RS_RESOURCE_PVT',
2544: 'UPDATE_RESOURCE',
2545: 'B',
2546: 'I')

Line 2623: jtf_resource_utl.validate_employee_resource(

2619: /* Validate the Managing Employee Id if specified */
2620:
2621: IF l_managing_emp_id <> fnd_api.g_miss_num THEN
2622:
2623: jtf_resource_utl.validate_employee_resource(
2624: p_emp_resource_id => l_managing_emp_id,
2625: p_emp_resource_number => null,
2626: x_return_status => x_return_status,
2627: x_emp_resource_id => l_managing_emp_id_out

Line 2656: jtf_resource_utl.validate_input_dates(

2652: -- Changing the values being passed to "validate_input_dates" procedure,
2653: -- from l_end_date_active to resource_rec.end_date_active (same for start date)
2654: -- so that it validates the correct dates which its supposed to validate.
2655:
2656: jtf_resource_utl.validate_input_dates(
2657: p_start_date_active => resource_rec.start_date_active,
2658: p_end_date_active => resource_rec.end_date_active,
2659: x_return_status => x_return_status
2660: );

Line 3065: jtf_resource_utl.validate_time_zone(

3061: IF l_time_zone <> fnd_api.g_miss_num THEN
3062:
3063: IF l_time_zone IS NOT NULL THEN
3064:
3065: jtf_resource_utl.validate_time_zone(
3066: p_time_zone_id => l_time_zone,
3067: x_return_status => x_return_status
3068: );
3069:

Line 3093: jtf_resource_utl.validate_nls_language(

3089: IF l_primary_language <> fnd_api.g_miss_char THEN
3090:
3091: IF l_primary_language IS NOT NULL THEN
3092:
3093: jtf_resource_utl.validate_nls_language(
3094: p_nls_language => l_primary_language,
3095: x_return_status => x_return_status
3096: );
3097:

Line 3121: jtf_resource_utl.validate_nls_language(

3117: IF l_secondary_language <> fnd_api.g_miss_char THEN
3118:
3119: IF l_secondary_language IS NOT NULL THEN
3120:
3121: jtf_resource_utl.validate_nls_language(
3122: p_nls_language => l_secondary_language,
3123: x_return_status => x_return_status
3124: );
3125:

Line 3149: jtf_resource_utl.validate_support_site_id(

3145: IF l_support_site_id <> fnd_api.g_miss_num THEN
3146:
3147: IF l_support_site_id IS NOT NULL THEN
3148:
3149: jtf_resource_utl.validate_support_site_id(
3150: p_support_site_id => l_support_site_id,
3151: x_return_status => x_return_status
3152: );
3153:

Line 3175: jtf_resource_utl.validate_server_group(

3171: /* Validate the Server Group. */
3172:
3173: IF l_server_group_id <> fnd_api.g_miss_num THEN
3174:
3175: jtf_resource_utl.validate_server_group(
3176: p_server_group_id => l_server_group_id,
3177: p_server_group_name => null,
3178: x_return_status => x_return_status,
3179: x_server_group_id => l_server_group_id_out

Line 3244: jtf_resource_utl.validate_currency_code(

3240: IF l_comp_currency_code <> fnd_api.g_miss_char THEN
3241:
3242: IF l_comp_currency_code IS NOT NULL THEN
3243:
3244: jtf_resource_utl.validate_currency_code(
3245: p_currency_code => l_comp_currency_code,
3246: x_return_status => x_return_status
3247: );
3248:

Line 3312: jtf_resource_utl.validate_hold_reason_code(

3308: IF l_hold_reason_code <> fnd_api.g_miss_char THEN
3309:
3310: IF l_hold_reason_code IS NOT NULL THEN
3311:
3312: jtf_resource_utl.validate_hold_reason_code(
3313: p_hold_reason_code => l_hold_reason_code,
3314: x_return_status => x_return_status
3315: );
3316:

Line 3358: jtf_resource_utl.validate_user_id(

3354: /* Validate the User Id if specified */
3355:
3356: IF l_user_id IS NOT NULL THEN
3357:
3358: jtf_resource_utl.validate_user_id(
3359: p_user_id => l_user_id,
3360: p_category => resource_rec.category,
3361: p_source_id => resource_rec.source_id,
3362: x_return_status => x_return_status

Line 3413: jtf_resource_utl.validate_resource_team(

3409: IF l_comp_service_team_id <> fnd_api.g_miss_num THEN
3410:
3411: IF l_comp_service_team_id IS NOT NULL THEN
3412:
3413: jtf_resource_utl.validate_resource_team(
3414: p_team_id => l_comp_service_team_id,
3415: p_team_number => null,
3416: x_return_status => x_return_status,
3417: x_team_id => l_comp_service_team_id_out

Line 3583: x_last_updated_by => jtf_resource_utl.updated_by,

3579: x_attribute14 => resource_rec.attribute14,
3580: x_attribute15 => resource_rec.attribute15,
3581: x_attribute_category => resource_rec.attribute_category,
3582: x_last_update_date => SYSDATE,
3583: x_last_updated_by => jtf_resource_utl.updated_by,
3584: x_last_update_login => jtf_resource_utl.login_id
3585: );
3586:
3587: --dbms_output.put_line ('After Call to Update Row Table Handler ');

Line 3584: x_last_update_login => jtf_resource_utl.login_id

3580: x_attribute15 => resource_rec.attribute15,
3581: x_attribute_category => resource_rec.attribute_category,
3582: x_last_update_date => SYSDATE,
3583: x_last_updated_by => jtf_resource_utl.updated_by,
3584: x_last_update_login => jtf_resource_utl.login_id
3585: );
3586:
3587: --dbms_output.put_line ('After Call to Update Row Table Handler ');
3588:

Line 3631: IF jtf_resource_utl.ok_to_execute(

3627: /* Make the post processing call to the user hooks */
3628:
3629: /* Post Call to the Customer Type User Hook */
3630:
3631: IF jtf_resource_utl.ok_to_execute(
3632: 'JTF_RS_RESOURCE_PVT',
3633: 'UPDATE_RESOURCE',
3634: 'A',
3635: 'C')

Line 3690: IF jtf_resource_utl.ok_to_execute(

3686:
3687:
3688: /* Post Call to the Vertical Type User Hook */
3689:
3690: IF jtf_resource_utl.ok_to_execute(
3691: 'JTF_RS_RESOURCE_PVT',
3692: 'UPDATE_RESOURCE',
3693: 'A',
3694: 'V')

Line 3750: IF jtf_resource_utl.ok_to_execute(

3746:
3747:
3748: /* Post Call to the Internal Type User Hook */
3749:
3750: IF jtf_resource_utl.ok_to_execute(
3751: 'JTF_RS_RESOURCE_PVT',
3752: 'UPDATE_RESOURCE',
3753: 'A',
3754: 'I')

Line 3809: IF jtf_resource_utl.ok_to_execute(

3805:
3806:
3807: /* Standard call for Message Generation */
3808:
3809: IF jtf_resource_utl.ok_to_execute(
3810: 'JTF_RS_RESOURCE_PVT',
3811: 'UPDATE_RESOURCE',
3812: 'M',
3813: 'M')

Line 3894: -- IF NOT(jtf_resource_utl.check_access(l_value))

3890: p_data => x_msg_data);
3891: WHEN OTHERS THEN
3892: ROLLBACK TO update_resource_pvt;
3893: -- The below lines removed as a part of fixing GSCC errors in R12 for jtfrspub.pls
3894: -- IF NOT(jtf_resource_utl.check_access(l_value))
3895: -- THEN
3896: -- IF(l_value = 'XMLGEN')
3897: -- THEN
3898: -- fnd_message.set_name ('JTF', 'JTF_RS_XMLGEN_ERR');

Line 4070: --added for NOCOPY to handle in JTF_RESOURCE_UTL

4066: l_source_category jtf_rs_resource_extns.source_category%type;
4067: l_user_name jtf_rs_resource_extns.user_name%type;
4068:
4069:
4070: --added for NOCOPY to handle in JTF_RESOURCE_UTL
4071: l_managing_emp_id_out jtf_rs_resource_extns.managing_employee_id%TYPE ;
4072: l_server_group_id_out jtf_rs_resource_extns.server_group_id%TYPE ;
4073: l_comp_service_team_id_out jtf_rs_resource_extns.comp_service_team_id%TYPE;
4074:

Line 4388: IF jtf_resource_utl.ok_to_execute(

4384: /* Make the pre processing call to the user hooks */
4385:
4386: /* Pre Call to the Customer Type User Hook */
4387:
4388: IF jtf_resource_utl.ok_to_execute(
4389: 'JTF_RS_RESOURCE_PVT',
4390: 'UPDATE_RESOURCE',
4391: 'B',
4392: 'C')

Line 4448: IF jtf_resource_utl.ok_to_execute(

4444:
4445:
4446: /* Pre Call to the Vertical Type User Hook */
4447:
4448: IF jtf_resource_utl.ok_to_execute(
4449: 'JTF_RS_RESOURCE_PVT',
4450: 'UPDATE_RESOURCE',
4451: 'B',
4452: 'V')

Line 4507: IF jtf_resource_utl.ok_to_execute(

4503:
4504:
4505: /* Pre Call to the Internal Type User Hook */
4506:
4507: IF jtf_resource_utl.ok_to_execute(
4508: 'JTF_RS_RESOURCE_PVT',
4509: 'UPDATE_RESOURCE',
4510: 'B',
4511: 'I')

Line 4591: jtf_resource_utl.validate_employee_resource(

4587: /* Validate the Managing Employee Id if specified */
4588:
4589: IF l_managing_emp_id <> fnd_api.g_miss_num THEN
4590:
4591: jtf_resource_utl.validate_employee_resource(
4592: p_emp_resource_id => l_managing_emp_id,
4593: p_emp_resource_number => null,
4594: x_return_status => x_return_status,
4595: x_emp_resource_id => l_managing_emp_id_out

Line 4627: jtf_resource_utl.validate_input_dates(

4623: -- Changing the values being passed to "validate_input_dates" procedure,
4624: -- from l_end_date_active to resource_rec.end_date_active (same for start date)
4625: -- so that it validates the correct dates which its supposed to validate.
4626:
4627: jtf_resource_utl.validate_input_dates(
4628: p_start_date_active => resource_rec.start_date_active,
4629: p_end_date_active => resource_rec.end_date_active,
4630: x_return_status => x_return_status
4631: );

Line 5022: jtf_resource_utl.validate_time_zone(

5018: IF l_time_zone <> fnd_api.g_miss_num THEN
5019:
5020: IF l_time_zone IS NOT NULL THEN
5021:
5022: jtf_resource_utl.validate_time_zone(
5023: p_time_zone_id => l_time_zone,
5024: x_return_status => x_return_status
5025: );
5026:

Line 5050: jtf_resource_utl.validate_nls_language(

5046: IF l_primary_language <> fnd_api.g_miss_char THEN
5047:
5048: IF l_primary_language IS NOT NULL THEN
5049:
5050: jtf_resource_utl.validate_nls_language(
5051: p_nls_language => l_primary_language,
5052: x_return_status => x_return_status
5053: );
5054:

Line 5078: jtf_resource_utl.validate_nls_language(

5074: IF l_secondary_language <> fnd_api.g_miss_char THEN
5075:
5076: IF l_secondary_language IS NOT NULL THEN
5077:
5078: jtf_resource_utl.validate_nls_language(
5079: p_nls_language => l_secondary_language,
5080: x_return_status => x_return_status
5081: );
5082:

Line 5106: jtf_resource_utl.validate_support_site_id(

5102: IF l_support_site_id <> fnd_api.g_miss_num THEN
5103:
5104: IF l_support_site_id IS NOT NULL THEN
5105:
5106: jtf_resource_utl.validate_support_site_id(
5107: p_support_site_id => l_support_site_id,
5108: x_return_status => x_return_status
5109: );
5110:

Line 5132: jtf_resource_utl.validate_server_group(

5128: /* Validate the Server Group. */
5129:
5130: IF l_server_group_id <> fnd_api.g_miss_num THEN
5131:
5132: jtf_resource_utl.validate_server_group(
5133: p_server_group_id => l_server_group_id,
5134: p_server_group_name => null,
5135: x_return_status => x_return_status,
5136: x_server_group_id => l_server_group_id_out

Line 5202: jtf_resource_utl.validate_currency_code(

5198: IF l_comp_currency_code <> fnd_api.g_miss_char THEN
5199:
5200: IF l_comp_currency_code IS NOT NULL THEN
5201:
5202: jtf_resource_utl.validate_currency_code(
5203: p_currency_code => l_comp_currency_code,
5204: x_return_status => x_return_status
5205: );
5206:

Line 5270: jtf_resource_utl.validate_hold_reason_code(

5266: IF l_hold_reason_code <> fnd_api.g_miss_char THEN
5267:
5268: IF l_hold_reason_code IS NOT NULL THEN
5269:
5270: jtf_resource_utl.validate_hold_reason_code(
5271: p_hold_reason_code => l_hold_reason_code,
5272: x_return_status => x_return_status
5273: );
5274:

Line 5315: jtf_resource_utl.validate_user_id(

5311: /* Validate the User Id if specified */
5312:
5313: IF l_user_id IS NOT NULL THEN
5314:
5315: jtf_resource_utl.validate_user_id(
5316: p_user_id => l_user_id,
5317: p_category => resource_rec.category,
5318: p_source_id => resource_rec.source_id,
5319: x_return_status => x_return_status

Line 5371: jtf_resource_utl.validate_resource_team(

5367: IF l_comp_service_team_id <> fnd_api.g_miss_num THEN
5368:
5369: IF l_comp_service_team_id IS NOT NULL THEN
5370:
5371: jtf_resource_utl.validate_resource_team(
5372: p_team_id => l_comp_service_team_id,
5373: p_team_number => null,
5374: x_return_status => x_return_status,
5375: x_team_id => l_comp_service_team_id_out

Line 5660: x_last_updated_by => jtf_resource_utl.updated_by,

5656: x_attribute14 => resource_rec.attribute14,
5657: x_attribute15 => resource_rec.attribute15,
5658: x_attribute_category => resource_rec.attribute_category,
5659: x_last_update_date => SYSDATE,
5660: x_last_updated_by => jtf_resource_utl.updated_by,
5661: x_last_update_login => jtf_resource_utl.login_id,
5662: x_resource_name => resource_rec.resource_name,
5663: x_source_name => resource_rec.source_name,
5664: x_source_number => resource_rec.source_number,

Line 5661: x_last_update_login => jtf_resource_utl.login_id,

5657: x_attribute15 => resource_rec.attribute15,
5658: x_attribute_category => resource_rec.attribute_category,
5659: x_last_update_date => SYSDATE,
5660: x_last_updated_by => jtf_resource_utl.updated_by,
5661: x_last_update_login => jtf_resource_utl.login_id,
5662: x_resource_name => resource_rec.resource_name,
5663: x_source_name => resource_rec.source_name,
5664: x_source_number => resource_rec.source_number,
5665: x_source_job_title => resource_rec.source_job_title,

Line 5745: IF jtf_resource_utl.ok_to_execute(

5741: /* Make the post processing call to the user hooks */
5742:
5743: /* Post Call to the Customer Type User Hook */
5744:
5745: IF jtf_resource_utl.ok_to_execute(
5746: 'JTF_RS_RESOURCE_PVT',
5747: 'UPDATE_RESOURCE',
5748: 'A',
5749: 'C')

Line 5804: IF jtf_resource_utl.ok_to_execute(

5800:
5801:
5802: /* Post Call to the Vertical Type User Hook */
5803:
5804: IF jtf_resource_utl.ok_to_execute(
5805: 'JTF_RS_RESOURCE_PVT',
5806: 'UPDATE_RESOURCE',
5807: 'A',
5808: 'V')

Line 5864: IF jtf_resource_utl.ok_to_execute(

5860:
5861:
5862: /* Post Call to the Internal Type User Hook */
5863:
5864: IF jtf_resource_utl.ok_to_execute(
5865: 'JTF_RS_RESOURCE_PVT',
5866: 'UPDATE_RESOURCE',
5867: 'A',
5868: 'I')

Line 5924: IF jtf_resource_utl.ok_to_execute(

5920:
5921:
5922: /* Standard call for Message Generation */
5923:
5924: IF jtf_resource_utl.ok_to_execute(
5925: 'JTF_RS_RESOURCE_PVT',
5926: 'UPDATE_RESOURCE',
5927: 'M',
5928: 'M')

Line 6009: -- IF NOT(jtf_resource_utl.check_access(l_value))

6005: p_data => x_msg_data);
6006: WHEN OTHERS THEN
6007: ROLLBACK TO update_resource_pvt;
6008: -- The below lines removed as a part of fixing GSCC errors in R12 for jtfrspub.pls
6009: -- IF NOT(jtf_resource_utl.check_access(l_value))
6010: -- THEN
6011: -- IF(l_value = 'XMLGEN')
6012: -- THEN
6013: -- fnd_message.set_name ('JTF', 'JTF_RS_XMLGEN_ERR');

Line 6091: IF jtf_resource_utl.ok_to_execute(

6087: /* Make the pre processing call to the user hooks */
6088:
6089: /* Pre Call to the Customer Type User Hook */
6090:
6091: IF jtf_resource_utl.ok_to_execute(
6092: 'JTF_RS_RESOURCE_PVT',
6093: 'DELETE_RESOURCE',
6094: 'B',
6095: 'C')

Line 6125: IF jtf_resource_utl.ok_to_execute(

6121:
6122:
6123: /* Pre Call to the Vertical Type User Hook */
6124:
6125: IF jtf_resource_utl.ok_to_execute(
6126: 'JTF_RS_RESOURCE_PVT',
6127: 'DELETE_RESOURCE',
6128: 'B',
6129: 'V')

Line 6259: IF jtf_resource_utl.ok_to_execute(

6255:
6256:
6257: /* Post Call to the Vertical Type User Hook */
6258:
6259: IF jtf_resource_utl.ok_to_execute(
6260: 'JTF_RS_RESOURCE_PVT',
6261: 'DELETE_RESOURCE',
6262: 'A',
6263: 'V')

Line 6291: IF jtf_resource_utl.ok_to_execute(

6287:
6288:
6289: /* Post Call to the Internal Type User Hook */
6290:
6291: IF jtf_resource_utl.ok_to_execute(
6292: 'JTF_RS_RESOURCE_PVT',
6293: 'DELETE_RESOURCE',
6294: 'A',
6295: 'I')

Line 6325: IF jtf_resource_utl.ok_to_execute(

6321:
6322:
6323: /* Standard call for Message Generation */
6324:
6325: IF jtf_resource_utl.ok_to_execute(
6326: 'JTF_RS_RESOURCE_PVT',
6327: 'DELETE_RESOURCE',
6328: 'M',
6329: 'M')

Line 6451: -- IF NOT(jtf_resource_utl.check_access(l_value))

6447: p_data => x_msg_data);
6448: WHEN OTHERS THEN
6449: ROLLBACK TO delete_resource_pvt;
6450: -- The below lines removed as a part of fixing GSCC errors in R12 for jtfrspub.pls
6451: -- IF NOT(jtf_resource_utl.check_access(l_value))
6452: -- THEN
6453: -- IF(l_value = 'XMLGEN')
6454: -- THEN
6455: -- fnd_message.set_name ('JTF', 'JTF_RS_XMLGEN_ERR');