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.3.12010000.3 2008/12/11 22:20:49 snizam 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 2619: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

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

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

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

Line 4628: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

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

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

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

Line 5029: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

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

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

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

Line 5703: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

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

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

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

Line 6126: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

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

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

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

Line 7908: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

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

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

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

Line 9613: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

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

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

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

Line 9676: l_req_rec PA_RES_MANAGEMENT_AMG_PUB.ASSIGNMENT_IN_REC_TYPE;

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

Line 10103: p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

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

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

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

Line 10798: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

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

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

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

Line 11359: p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

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

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

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

Line 11946: p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

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

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

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

Line 12450: p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

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

Line 13054: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

13050: ROLLBACK TO CREATE_CANDIDATES_SP;
13051: END IF;
13052:
13053: FND_MSG_PUB.add_exc_msg
13054: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
13055: , p_procedure_name => 'CREATE_CANDIDATES'
13056: , p_error_text => x_msg_data);
13057:
13058: x_msg_count := FND_MSG_PUB.count_msg;

Line 13542: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

13538: ROLLBACK TO UPDATE_CANDIDATES_SP;
13539: END IF;
13540:
13541: FND_MSG_PUB.add_exc_msg
13542: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
13543: , p_procedure_name => 'UPDATE_CANDIDATES'
13544: , p_error_text => x_msg_data);
13545:
13546: x_msg_count := FND_MSG_PUB.count_msg;

Line 13983: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

13979: ROLLBACK TO DELETE_CANDIDATES_SP;
13980: END IF;
13981:
13982: FND_MSG_PUB.add_exc_msg
13983: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
13984: , p_procedure_name => 'DELETE_CANDIDATES'
13985: , p_error_text => x_msg_data);
13986:
13987: x_msg_count := FND_MSG_PUB.count_msg;

Line 14455: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'

14451: ROLLBACK TO CREATE_CANDIDATE_LOG_SP;
14452: END IF;
14453:
14454: FND_MSG_PUB.add_exc_msg
14455: ( p_pkg_name => 'PA_RES_MANAGEMENT_AMG_PUB'
14456: , p_procedure_name => 'CREATE_CANDIDATE_LOG'
14457: , p_error_text => x_msg_data);
14458:
14459: x_msg_count := FND_MSG_PUB.count_msg;

Line 14468: END PA_RES_MANAGEMENT_AMG_PUB;

14464: RAISE;
14465:
14466: END CREATE_CANDIDATE_LOG;
14467:
14468: END PA_RES_MANAGEMENT_AMG_PUB;