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.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_RES_MANAGEMENT_AMG_PUB

Line 1: PACKAGE BODY PA_RES_MANAGEMENT_AMG_PUB AS

1: PACKAGE BODY PA_RES_MANAGEMENT_AMG_PUB AS
2: /* $Header: PAPMRSPB.pls 120.14.12020000.2 2012/07/19 09:56:24 admarath ship $ */
3:
4: G_PA_MISS_NUM CONSTANT NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
5: G_PA_MISS_DATE CONSTANT DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;

Line 312: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309: x_msg_data := SQLERRM;
310:
311: FND_MSG_PUB.add_exc_msg
312: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
313: , p_procedure_name => 'VALIDATE_FLEX_FIELD'
314: , p_error_text => x_msg_data);
315:
316: x_msg_count := FND_MSG_PUB.count_msg;

Line 370: l_module VARCHAR2(100) := 'PA_RES_MANAGEMENT_AMG_PUB.CREATE_REQUIREMENTS';

366: l_check_id_flag VARCHAR2(1) := 'Y';
367: l_check_role_security_flag VARCHAR2(1) := 'Y';
368: l_check_resource_security_flag VARCHAR2(1) := 'Y';
369: l_log_level NUMBER := 3;
370: l_module VARCHAR2(100) := 'PA_RES_MANAGEMENT_AMG_PUB.CREATE_REQUIREMENTS';
371: l_commit VARCHAR2(1) := FND_API.G_FALSE;
372: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
373: l_validate_only VARCHAR2(1) := FND_API.G_FALSE;
374: l_msg_count NUMBER;

Line 2620: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

2616: ROLLBACK TO CREATE_REQUIREMENTS_SP;
2617: END IF;
2618:
2619: FND_MSG_PUB.add_exc_msg
2620: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
2621: , p_procedure_name => 'CREATE_REQUIREMENTS'
2622: , p_error_text => x_msg_data);
2623:
2624: x_msg_count := FND_MSG_PUB.count_msg;

Line 2677: l_module VARCHAR2(100) := 'PA_RES_MANAGEMENT_AMG_PUB.UPDATE_REQUIREMENTS';

2673: l_check_id_flag VARCHAR2(1) := 'Y';
2674: l_check_role_security_flag VARCHAR2(1) := 'Y';
2675: l_check_resource_security_flag VARCHAR2(1) := 'Y';
2676: l_log_level NUMBER := 3;
2677: l_module VARCHAR2(100) := 'PA_RES_MANAGEMENT_AMG_PUB.UPDATE_REQUIREMENTS';
2678: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2679: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
2680: l_validate_only VARCHAR2(1) := FND_API.G_FALSE;
2681: l_msg_count NUMBER;

Line 4629: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

4625: ROLLBACK TO UPDATE_REQUIREMENTS_SP;
4626: END IF;
4627:
4628: FND_MSG_PUB.add_exc_msg
4629: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
4630: , p_procedure_name => 'UPDATE_REQUIREMENTS'
4631: , p_error_text => x_msg_data);
4632:
4633: x_msg_count := FND_MSG_PUB.count_msg;

Line 4687: l_module VARCHAR2(100) := 'PA_RES_MANAGEMENT_AMG_PUB.DELETE_REQUIREMENTS';

4683: l_check_role_security_flag VARCHAR2(1) := 'Y';
4684: l_check_resource_security_flag VARCHAR2(1) := 'Y';
4685:
4686: l_log_level NUMBER := 3;
4687: l_module VARCHAR2(100) := 'PA_RES_MANAGEMENT_AMG_PUB.DELETE_REQUIREMENTS';
4688: l_commit VARCHAR2(1) := FND_API.G_FALSE;
4689: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
4690: l_validate_only VARCHAR2(1) := FND_API.G_FALSE;
4691:

Line 5030: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

5026: CLOSE c_get_system_status ;
5027: END IF;
5028:
5029: FND_MSG_PUB.add_exc_msg
5030: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
5031: , p_procedure_name => 'DELETE_REQUIREMENTS'
5032: , p_error_text => x_msg_data);
5033:
5034: x_msg_count := FND_MSG_PUB.count_msg;

Line 5091: l_module VARCHAR2(100) := 'PA_RES_MANAGEMENT_AMG_PUB.STAFF_REQUIREMENTS';

5087: l_check_role_security_flag VARCHAR2(1) := 'Y';
5088: l_check_resource_security_flag VARCHAR2(1) := 'Y';
5089:
5090: l_log_level NUMBER := 3;
5091: l_module VARCHAR2(100) := 'PA_RES_MANAGEMENT_AMG_PUB.STAFF_REQUIREMENTS';
5092: l_commit VARCHAR2(1) := FND_API.G_FALSE;
5093: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
5094: l_validate_only VARCHAR2(1) := FND_API.G_FALSE;
5095:

Line 5704: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

5700: CLOSE c_valid_unfilled_status_name ;
5701: END IF;
5702:
5703: FND_MSG_PUB.add_exc_msg
5704: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
5705: , p_procedure_name => 'STAFF_REQUIREMENTS'
5706: , p_error_text => x_msg_data);
5707:
5708: x_msg_count := FND_MSG_PUB.count_msg;

Line 5767: l_module VARCHAR2(100) := 'PA_RES_MANAGEMENT_AMG_PUB.COPY_TEAM_ROLES';

5763: l_check_role_security_flag VARCHAR2(1) := 'Y';
5764: l_check_resource_security_flag VARCHAR2(1) := 'Y';
5765:
5766: l_log_level NUMBER := 3;
5767: l_module VARCHAR2(100) := 'PA_RES_MANAGEMENT_AMG_PUB.COPY_TEAM_ROLES';
5768: l_commit VARCHAR2(1) := FND_API.G_FALSE;
5769: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
5770:
5771: l_msg_count NUMBER;

Line 6127: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

6123: CLOSE c_get_system_status ;
6124: END IF;
6125:
6126: FND_MSG_PUB.add_exc_msg
6127: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
6128: , p_procedure_name => 'COPY_TEAM_ROLES'
6129: , p_error_text => x_msg_data);
6130:
6131: x_msg_count := FND_MSG_PUB.count_msg;

Line 6190: l_module VARCHAR2(100) := 'PA_RES_MANAGEMENT_AMG_PUB.CREATE_ASSIGNMENTS';

6186: l_check_id_flag VARCHAR2(1) := 'Y';
6187: l_check_role_security_flag VARCHAR2(1) := 'Y';
6188: l_check_resource_security_flag VARCHAR2(1) := 'Y';
6189: l_log_level NUMBER := 3;
6190: l_module VARCHAR2(100) := 'PA_RES_MANAGEMENT_AMG_PUB.CREATE_ASSIGNMENTS';
6191: l_commit VARCHAR2(1) := FND_API.G_FALSE;
6192: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
6193: l_validate_only VARCHAR2(1) := FND_API.G_FALSE;
6194: l_msg_count NUMBER;

Line 7910: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

7906: ROLLBACK TO CREATE_ASSIGNMENTS_SP;
7907: END IF;
7908:
7909: FND_MSG_PUB.add_exc_msg
7910: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
7911: , p_procedure_name => 'CREATE_ASSIGNMENTS'
7912: , p_error_text => x_msg_data);
7913:
7914: x_msg_count := FND_MSG_PUB.count_msg;

Line 7971: l_module VARCHAR2(100) := 'PA_RES_MANAGEMENT_AMG_PUB.UPDATE_ASSIGNMENTS';

7967: l_check_role_security_flag VARCHAR2(1) := 'Y';
7968: l_check_resource_security_flag VARCHAR2(1) := 'Y';
7969:
7970: l_log_level NUMBER := 3;
7971: l_module VARCHAR2(100) := 'PA_RES_MANAGEMENT_AMG_PUB.UPDATE_ASSIGNMENTS';
7972: l_commit VARCHAR2(1) := FND_API.G_FALSE;
7973: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
7974: l_validate_only VARCHAR2(1) := FND_API.G_FALSE;
7975: l_asgn_update_mode VARCHAR2(10) := 'FULL'; -- This is just a dummy value

Line 9615: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

9611: ROLLBACK TO UPDATE_ASSIGNMENTS_SP;
9612: END IF;
9613:
9614: FND_MSG_PUB.add_exc_msg
9615: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
9616: , p_procedure_name => 'UPDATE_ASSIGNMENTS'
9617: , p_error_text => x_msg_data);
9618:
9619: x_msg_count := FND_MSG_PUB.count_msg;

Line 9668: l_module VARCHAR2(255) := 'PA_RES_MANAGEMENT_AMG_PUB.DELETE_ASSIGNMENTS';

9664: ) IS
9665: -- Debug Params
9666: l_debug_level NUMBER :=3;
9667: l_debug_mode VARCHAR2(1) :='N';
9668: l_module VARCHAR2(255) := 'PA_RES_MANAGEMENT_AMG_PUB.DELETE_ASSIGNMENTS';
9669: --Looping Params
9670: i NUMBER;
9671: -- pa_initialize calling params
9672: l_calling_application VARCHAR2(10) := 'PLSQL';

Line 9678: l_req_rec PA_RES_MANAGEMENT_AMG_PUB.ASSIGNMENT_IN_REC_TYPE;

9674: l_check_id_flag VARCHAR2(1) := 'Y';
9675: l_check_role_security_flag VARCHAR2(1) := 'Y';
9676: l_check_resource_security_flag VARCHAR2(1) := 'Y';
9677: --Loop Params
9678: l_req_rec PA_RES_MANAGEMENT_AMG_PUB.ASSIGNMENT_IN_REC_TYPE;
9679: l_loop_msg_count NUMBER :=0;
9680: l_start_msg_count NUMBER :=0;
9681: l_end_msg_count NUMBER :=0;
9682: l_missing_params VARCHAR2(1000);

Line 10105: p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

10101: CLOSE cur_get_system_status ;
10102: END IF;
10103:
10104: FND_MSG_PUB.add_exc_msg (
10105: p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
10106: , p_procedure_name => 'DELETE_REQUIREMENTS'
10107: , p_error_text => x_msg_data);
10108:
10109: x_msg_count := FND_MSG_PUB.count_msg;

Line 10168: l_module VARCHAR2(100) := 'PA_RES_MANAGEMENT_AMG_PUB.SUBMIT_ASSIGNMENTS';

10164: l_check_role_security_flag VARCHAR2(1) := 'Y';
10165: l_check_resource_security_flag VARCHAR2(1) := 'Y';
10166:
10167: l_log_level NUMBER := 3;
10168: l_module VARCHAR2(100) := 'PA_RES_MANAGEMENT_AMG_PUB.SUBMIT_ASSIGNMENTS';
10169: l_commit VARCHAR2(1) := FND_API.G_FALSE;
10170: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
10171:
10172: l_msg_count NUMBER;

Line 10800: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

10796: ROLLBACK TO SUBMIT_ASSIGNMENTS_SP;
10797: END IF;
10798:
10799: FND_MSG_PUB.add_exc_msg
10800: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
10801: , p_procedure_name => 'SUBMIT_ASSIGNMENTS'
10802: , p_error_text => x_msg_data);
10803:
10804: x_msg_count := FND_MSG_PUB.count_msg;

Line 10859: l_module VARCHAR2(255) := 'PA_RES_MANAGEMENT_AMG_PUB.CREATE_REQUIREMENT_COMPETENCE';

10855: )
10856: IS
10857: -- Debug level setting Params
10858: l_debug_mode VARCHAR2(1);
10859: l_module VARCHAR2(255) := 'PA_RES_MANAGEMENT_AMG_PUB.CREATE_REQUIREMENT_COMPETENCE';
10860: l_debug_level NUMBER :=3;
10861: -- Params for pa_startup.initialize call
10862: l_calling_application VARCHAR2(10) :='PLSQL';
10863: l_check_id_flag VARCHAR2(1) := 'Y';

Line 11361: p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

11357: ROLLBACK TO CREATE_REQU_COMPETENCE_SP;
11358: END IF;
11359:
11360: FND_MSG_PUB.add_exc_msg (
11361: p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
11362: , p_procedure_name => 'CREATE_REQUIREMENT_COMPETENCE'
11363: , p_error_text => x_msg_data);
11364:
11365: x_msg_count := FND_MSG_PUB.count_msg;

Line 11413: l_module VARCHAR2(255) := 'PA_RES_MANAGEMENT_AMG_PUB.UPDATE_REQUIREMENT_COMPETENCE';

11409: , x_msg_count OUT NOCOPY NUMBER
11410: , x_msg_data OUT NOCOPY VARCHAR2
11411: ) IS
11412: -- Debug Level
11413: l_module VARCHAR2(255) := 'PA_RES_MANAGEMENT_AMG_PUB.UPDATE_REQUIREMENT_COMPETENCE';
11414: l_debug_mode VARCHAR2(1);
11415: l_debug_level NUMBER :=3;
11416: -- Params for pa_startup.initialize call
11417: l_calling_application VARCHAR2(10) :='PLSQL';

Line 11948: p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

11944: ROLLBACK TO UPDATE_REQU_COMPETENCE_SP;
11945: END IF;
11946:
11947: FND_MSG_PUB.ADD_EXC_MSG(
11948: p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
11949: , p_procedure_name => 'CREATE_REQUIREMENT_COMPETENCE'
11950: , p_error_text => x_msg_data);
11951:
11952: x_msg_count := FND_MSG_PUB.count_msg;

Line 12000: l_module VARCHAR2(255) := 'PA_RES_MANAGEMENT_AMG_PUB.DELETE_REQUIREMENT_COMPETENCE';

11996: , x_msg_data OUT NOCOPY VARCHAR2
11997: ) IS
11998:
11999: -- Debug Level
12000: l_module VARCHAR2(255) := 'PA_RES_MANAGEMENT_AMG_PUB.DELETE_REQUIREMENT_COMPETENCE';
12001: l_debug_mode VARCHAR2(1);
12002: l_debug_level NUMBER :=3;
12003: -- Params for pa_startup.initialize call
12004: l_calling_application VARCHAR2(10) :='PLSQL';

Line 12452: p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

12448: ROLLBACK TO DELETE_REQU_COMPETENCE_SP;
12449: END IF;
12450:
12451: FND_MSG_PUB.ADD_EXC_MSG(
12452: p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
12453: , p_procedure_name => 'CREATE_REQUIREMENT_COMPETENCE'
12454: , p_error_text => x_msg_data);
12455:
12456: x_msg_count := FND_MSG_PUB.count_msg;

Line 13075: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

13071: ROLLBACK TO CREATE_CANDIDATES_SP;
13072: END IF;
13073:
13074: FND_MSG_PUB.add_exc_msg
13075: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
13076: , p_procedure_name => 'CREATE_CANDIDATES'
13077: , p_error_text => x_msg_data);
13078:
13079: x_msg_count := FND_MSG_PUB.count_msg;

Line 13580: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

13576: ROLLBACK TO UPDATE_CANDIDATES_SP;
13577: END IF;
13578:
13579: FND_MSG_PUB.add_exc_msg
13580: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
13581: , p_procedure_name => 'UPDATE_CANDIDATES'
13582: , p_error_text => x_msg_data);
13583:
13584: x_msg_count := FND_MSG_PUB.count_msg;

Line 14021: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

14017: ROLLBACK TO DELETE_CANDIDATES_SP;
14018: END IF;
14019:
14020: FND_MSG_PUB.add_exc_msg
14021: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
14022: , p_procedure_name => 'DELETE_CANDIDATES'
14023: , p_error_text => x_msg_data);
14024:
14025: x_msg_count := FND_MSG_PUB.count_msg;

Line 14510: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

14506: ROLLBACK TO CREATE_CANDIDATE_LOG_SP;
14507: END IF;
14508:
14509: FND_MSG_PUB.add_exc_msg
14510: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
14511: , p_procedure_name => 'CREATE_CANDIDATE_LOG'
14512: , p_error_text => x_msg_data);
14513:
14514: x_msg_count := FND_MSG_PUB.count_msg;

Line 14523: END PA_RES_MANAGEMENT_AMG_PUB;

14519: RAISE;
14520:
14521: END CREATE_CANDIDATE_LOG;
14522:
14523: END PA_RES_MANAGEMENT_AMG_PUB;