DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on PA_PROJECT_PARTIES_PUB

Line 188: -- added the call to PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY

184: -- if x_err_code > 0, then assign
185: -- zero to x_err_code.
186: -- 17-JUL-2000 Mohnish
187: -- added code for ROLE BASED SECURITY:
188: -- added the call to PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY
189: -- 19-JUL-2000 Mohnish incorporated PA_PROJECT_PARTIES_PUB API changes
190: -- 15-AUG-2000 Sakthi Modified 'PROJECTS' TO 'PA_PROJECTS' in PA_PROJECT_PARTIES_PUB API changes
191: --
192: -- 24-Sep-02 msundare Added additional parameter x_security_level

Line 189: -- 19-JUL-2000 Mohnish incorporated PA_PROJECT_PARTIES_PUB API changes

185: -- zero to x_err_code.
186: -- 17-JUL-2000 Mohnish
187: -- added code for ROLE BASED SECURITY:
188: -- added the call to PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY
189: -- 19-JUL-2000 Mohnish incorporated PA_PROJECT_PARTIES_PUB API changes
190: -- 15-AUG-2000 Sakthi Modified 'PROJECTS' TO 'PA_PROJECTS' in PA_PROJECT_PARTIES_PUB API changes
191: --
192: -- 24-Sep-02 msundare Added additional parameter x_security_level
193: -- 18-DEC-02 gjain For bug 2588244 Added logic in copy_project to copy the

Line 190: -- 15-AUG-2000 Sakthi Modified 'PROJECTS' TO 'PA_PROJECTS' in PA_PROJECT_PARTIES_PUB API changes

186: -- 17-JUL-2000 Mohnish
187: -- added code for ROLE BASED SECURITY:
188: -- added the call to PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY
189: -- 19-JUL-2000 Mohnish incorporated PA_PROJECT_PARTIES_PUB API changes
190: -- 15-AUG-2000 Sakthi Modified 'PROJECTS' TO 'PA_PROJECTS' in PA_PROJECT_PARTIES_PUB API changes
191: --
192: -- 24-Sep-02 msundare Added additional parameter x_security_level
193: -- 18-DEC-02 gjain For bug 2588244 Added logic in copy_project to copy the
194: -- default calendar from the organization specified in quick entry

Line 1880: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_SUBTEAM';

1876: rollback to copy_project;
1877: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1878: x_err_code := 102;
1879: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_SUBTEAM');
1880: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_SUBTEAM';
1881: return;
1882: END IF;
1883: END LOOP;
1884: CLOSE get_subteams_csr; --Bug 3905797

Line 2194: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

2190: AND nvl(l_hz_parties,'N') = 'Y')
2191: )THEN -- Bug 3022296 End
2192: --bug 2778730
2193: /* Bug 3022296 : End */
2194: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2195: p_api_version => 1.0 -- p_api_version
2196: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2197: , p_commit => FND_API.G_FALSE -- p_commit
2198: , p_validate_only => FND_API.G_FALSE -- p_validate_only

Line 2236: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';

2232: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2233: x_err_code := 125;
2234: -- x_err_stage := 'PA_NO_PROJ_CREATED'; --commented by ansari
2235: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
2236: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
2237: return;
2238: END IF;
2239: END IF; --bug 2778730
2240: EXCEPTION WHEN OTHERS THEN

Line 2245: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||

2241: x_err_code := 125;
2242: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
2243: -- IF x_err_stage IS NULL
2244: -- THEN
2245: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||
2246: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
2247: -- END IF;
2248: rollback to copy_project;
2249: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

Line 2357: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

2353:
2354: -- End bug#5859329
2355: /* Bug 7482391 changes end here*/
2356: if (f_flag = 'Y') then -- Bug 7482391
2357: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2358: p_api_version => 1.0 -- p_api_version
2359: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2360: , p_commit => FND_API.G_FALSE -- p_commit
2361: , p_validate_only => FND_API.G_FALSE -- p_validate_only

Line 2401: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';

2397:
2398: x_err_code := 125;
2399: -- x_err_stage := 'PA_NO_PROJ_CREATED';
2400: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
2401: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
2402: return;
2403: END IF;
2404: END IF; -- Bug 7482391
2405: END IF; --bug 2778730

Line 2411: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT _PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);

2407: x_err_code := 125;
2408: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
2409: -- IF x_err_stage IS NULL
2410: -- THEN
2411: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT _PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
2412: -- END IF;
2413: rollback to copy_project;
2414: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2415: return;

Line 2536: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

2532:
2533: -- Don't want to copy over those project organizations that were created along with
2534: -- a customer billing account
2535: if c_cust_created_org_csr%NOTFOUND then
2536: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2537: p_api_version => 1.0
2538: , p_init_msg_list => FND_API.G_TRUE
2539: , p_commit => FND_API.G_FALSE
2540: , p_validate_only => FND_API.G_FALSE

Line 2571: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';

2567: rollback to copy_project;
2568: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2569: x_err_code := 125;
2570: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
2571: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
2572: return;
2573: END IF;
2574: END IF;
2575:

Line 2582: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||

2578: x_err_code := 125;
2579: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
2580: -- IF x_err_stage IS NULL
2581: -- THEN
2582: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||
2583: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
2584: -- END IF;
2585: rollback to copy_project;
2586: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

Line 2602: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

2598:
2599: -- Don't want to copy over those project organizations that were created along with
2600: -- a customer billing account
2601: if c_cust_created_org_csr%NOTFOUND then
2602: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2603: p_api_version => 1.0
2604: , p_init_msg_list => FND_API.G_TRUE
2605: , p_commit => FND_API.G_FALSE
2606: , p_validate_only => FND_API.G_FALSE

Line 2639: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';

2635: rollback to copy_project;
2636: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2637: x_err_code := 125;
2638: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
2639: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
2640: return;
2641: END IF;
2642: END IF;
2643:

Line 2650: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT _PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);

2646: x_err_code := 125;
2647: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
2648: -- IF x_err_stage IS NULL
2649: -- THEN
2650: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT _PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
2651: -- END IF;
2652: rollback to copy_project;
2653: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2654: return;

Line 3068: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

3064: CLOSE l_check_org_csr;
3065:
3066: if l_party_id is not null then
3067:
3068: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
3069: p_validate_only => FND_API.G_FALSE
3070: , p_object_id => x_new_project_id
3071: , p_OBJECT_TYPE => 'PA_PROJECTS'
3072: , p_project_role_id => 100

Line 3097: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';

3093: rollback to copy_project;
3094: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
3095: x_err_code := 167;
3096: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
3097: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
3098: return;
3099: END IF;
3100:
3101: -- Add the new project party ID to the customers row

Line 3115: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);

3111: x_err_code := 167;
3112: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
3113: -- IF x_err_stage IS NULL
3114: -- THEN
3115: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
3116: -- END IF;
3117: rollback to copy_project;
3118: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
3119: return;

Line 3788: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

3784: CLOSE l_check_org_csr;
3785:
3786: if l_party_id is not null then
3787:
3788: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
3789: p_validate_only => FND_API.G_FALSE
3790: , p_object_id => x_new_project_id
3791: , p_OBJECT_TYPE => 'PA_PROJECTS'
3792: , p_project_role_id => 100

Line 3817: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';

3813: rollback to copy_project;
3814: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
3815: x_err_code := 168;
3816: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
3817: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
3818: return;
3819: END IF;
3820:
3821: -- Add the new project party ID to the customers row

Line 3836: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);

3832: x_err_code := 168;
3833: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
3834: -- IF x_err_stage IS NULL
3835: -- THEN
3836: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
3837: -- END IF;
3838: rollback to copy_project;
3839: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
3840: return;