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_PROJECT_CORE1 dependencies on PA_PROJECT_CORE1

Line 1: package body PA_PROJECT_CORE1 as

1: package body PA_PROJECT_CORE1 as
2: -- $Header: PAXPCO1B.pls 120.13.12010000.5 2008/11/28 06:10:40 vgovvala ship $
3:
4: g_module_name VARCHAR2(100) := 'PA_PROJECT_CORE1';
5: Invalid_Arg_Exc EXCEPTION;

Line 4: g_module_name VARCHAR2(100) := 'PA_PROJECT_CORE1';

1: package body PA_PROJECT_CORE1 as
2: -- $Header: PAXPCO1B.pls 120.13.12010000.5 2008/11/28 06:10:40 vgovvala ship $
3:
4: g_module_name VARCHAR2(100) := 'PA_PROJECT_CORE1';
5: Invalid_Arg_Exc EXCEPTION;
6:
7: --
8: -- PROCEDURE

Line 502: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_PRJ_COR1_GET_PRJ_NUM');

498: if x_err_code <> 0 then
499: x_err_code := 765;
500: IF x_err_stage IS NULL
501: THEN
502: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_PRJ_COR1_GET_PRJ_NUM');
503: END IF;
504: x_err_stack := x_err_stack||'->pa_project_core1.get_project_number_by_numcode';
505: rollback to copy_project;
506: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

Line 504: x_err_stack := x_err_stack||'->pa_project_core1.get_project_number_by_numcode';

500: IF x_err_stage IS NULL
501: THEN
502: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_PRJ_COR1_GET_PRJ_NUM');
503: END IF;
504: x_err_stack := x_err_stack||'->pa_project_core1.get_project_number_by_numcode';
505: rollback to copy_project;
506: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
507: return;
508: end if;

Line 511: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

507: return;
508: end if;
509: EXCEPTION WHEN OTHERS THEN
510: x_err_code := 765;
511: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
512: -- IF x_err_stage IS NULL
513: -- THEN
514: x_err_stage := 'API: '||'pa_project_core1.get_project_number_by_numcode'||
515: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

Line 514: x_err_stage := 'API: '||'pa_project_core1.get_project_number_by_numcode'||

510: x_err_code := 765;
511: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
512: -- IF x_err_stage IS NULL
513: -- THEN
514: x_err_stage := 'API: '||'pa_project_core1.get_project_number_by_numcode'||
515: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
516: -- END IF;
517: rollback to copy_project;
518: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

Line 921: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_VAL_ATTR_CHANGE');

917: THEN
918: x_err_code := 740;
919: IF x_err_stage IS NULL
920: THEN
921: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_VAL_ATTR_CHANGE');
922: END IF;
923: x_err_stack := x_err_stack||'->pa_project_utils2.validate_attribute_change';
924: rollback to copy_project;
925: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

Line 931: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

927: END IF;
928:
929: EXCEPTION WHEN OTHERS THEN
930: x_err_code := 740;
931: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
932: -- IF x_err_stage IS NULL
933: -- THEN
934: x_err_stage := 'API: '||'pa_project_utils2.validate_attribute_change'||' SQL error message: '
935: ||SUBSTR( SQLERRM,1,1900);

Line 978: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CHK_LOC_EXISTS');

974: x_location_id => l_location_id);
975: IF l_return_status <> 'S'
976: THEN
977: x_err_code := 770;
978: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CHK_LOC_EXISTS');
979: x_err_stack := x_err_stack||'->pa_location_utils.check_location_exists';
980: rollback to copy_project;
981: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
982: return;

Line 986: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

982: return;
983: END IF;
984: EXCEPTION WHEN OTHERS THEN
985: x_err_code := 770;
986: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
987: -- IF x_err_stage IS NULL
988: -- THEN
989: x_err_stage := 'API: '||'pa_location_utils.check_location_exists'||
990: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

Line 1039: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_GET_ORG_LOC_DTLS');

1035: THEN
1036: x_err_code := 780;
1037: IF x_error_message_code IS NULL
1038: THEN
1039: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_GET_ORG_LOC_DTLS');
1040: ELSE
1041: x_err_stage := x_error_message_code; --bug fix 2680591
1042: END IF;
1043: x_err_stack := x_err_stack||'->pa_location_utils.Get_ORG_Location_Details';

Line 1050: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

1046: return;
1047: END IF;
1048: EXCEPTION WHEN OTHERS THEN
1049: x_err_code := 780;
1050: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
1051: -- IF x_error_message_code IS NULL
1052: -- THEN
1053: x_err_stage := 'API: '||'pa_location_utils.Get_ORG_Location_Details'||
1054: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

Line 1072: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CHK_LOC_EXISTS');

1068: x_location_id => l_location_id);
1069: IF l_return_status <> 'S'
1070: THEN
1071: x_err_code := 775;
1072: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CHK_LOC_EXISTS');
1073: x_err_stack := x_err_stack||'->pa_location_utils.check_location_exists';
1074: rollback to copy_project;
1075: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1076: return;

Line 1080: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

1076: return;
1077: END IF;
1078: EXCEPTION WHEN OTHERS THEN
1079: x_err_code := 775;
1080: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
1081: -- IF x_err_stage IS NULL
1082: -- THEN
1083: x_err_stage := 'API: '||'pa_location_utils.check_location_exists'||
1084: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

Line 1160: PA_PROJECT_CORE1.populate_default_copy_options( p_src_project_id => x_orig_project_id

1156: x_new_project_id || ' by copying original project '||
1157: x_orig_project_id;
1158:
1159: --Following code added for selective copy project changes. Tracking Bug no. 3464332
1160: PA_PROJECT_CORE1.populate_default_copy_options( p_src_project_id => x_orig_project_id
1161: ,p_src_template_flag => x_orig_template_flag
1162: ,p_dest_template_flag => x_template_flag
1163: ,x_return_status => l_return_status
1164: ,x_msg_count => l_msg_count

Line 1171: x_err_stage := 'API: '||'PA_PROJECT_CORE1.POPULATE_DEFAULT_COPY_OPTIONS'||

1167: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1168: ROLLBACK TO copy_project;
1169: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1170: x_err_code := 199;
1171: x_err_stage := 'API: '||'PA_PROJECT_CORE1.POPULATE_DEFAULT_COPY_OPTIONS'||
1172: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
1173: x_err_stack := x_err_stack||'->PA_PROJECT_CORE1.POPULATE_DEFAULT_COPY_OPTIONS';
1174: RETURN;
1175: END IF;

Line 1173: x_err_stack := x_err_stack||'->PA_PROJECT_CORE1.POPULATE_DEFAULT_COPY_OPTIONS';

1169: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1170: x_err_code := 199;
1171: x_err_stage := 'API: '||'PA_PROJECT_CORE1.POPULATE_DEFAULT_COPY_OPTIONS'||
1172: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
1173: x_err_stack := x_err_stack||'->PA_PROJECT_CORE1.POPULATE_DEFAULT_COPY_OPTIONS';
1174: RETURN;
1175: END IF;
1176: --Following code added for selective copy project changes. Tracking Bug no. 3464332
1177: OPEN cur_get_flag('PR_DFF_FLAG');

Line 1843: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_SUBTEAM');

1839: IF (l_return_status <> 'S') Then
1840: rollback to copy_project;
1841: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1842: x_err_code := 102;
1843: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_SUBTEAM');
1844: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_SUBTEAM';
1845: return;
1846: END IF;
1847: END LOOP;

Line 1852: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

1848: CLOSE get_subteams_csr; --Bug 3905797
1849:
1850: EXCEPTION WHEN OTHERS THEN
1851: x_err_code := 102;
1852: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
1853: -- IF x_err_stage IS NULL
1854: -- THEN
1855: x_err_stage := 'API: '||'PA_PROJECT_SUBTEAMS_PUB.CREATE_SUBTEAM'||
1856: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

Line 1878: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_PROJ_OPP_ATTR');

1874: ,x_msg_data => l_msg_data);
1875:
1876: if l_return_status <> 'S' then
1877: x_err_code := 128;
1878: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_PROJ_OPP_ATTR');
1879: x_err_stack := x_err_stack||'->PA_OPPORTUNITY_MGT_PVT.COPY_PROJECT_ATTRIBUTES';
1880: rollback to copy_project;
1881: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1882: return;

Line 1886: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

1882: return;
1883: end if;
1884: EXCEPTION WHEN OTHERS THEN
1885: x_err_code := 128;
1886: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
1887: -- IF x_err_stage IS NULL
1888: -- THEN
1889: x_err_stage := 'API: '||'PA_OPPORTUNITY_MGT_PVT.COPY_PROJECT_ATTRIBUTES'||
1890: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

Line 1922: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_MOD_PROJ_OPP_ATTR');

1918: ,x_msg_data => l_msg_data);
1919:
1920: if l_return_status <> 'S' then
1921: x_err_code := 130;
1922: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_MOD_PROJ_OPP_ATTR');
1923: x_err_stack := x_err_stack||'->PA_OPPORTUNITY_MGT_PVT.MODIFY_PROJECT_ATTRIBUTES';
1924: rollback to copy_project;
1925: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1926: return;

Line 1930: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

1926: return;
1927: end if;
1928: EXCEPTION WHEN OTHERS THEN
1929: x_err_code := 130;
1930: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
1931: -- IF x_err_stage IS NULL
1932: -- THEN
1933: x_err_stage := 'API: '||'PA_OPPORTUNITY_MGT_PVT.MODIFY_PROJECT_ATTRIBUTES'||
1934: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

Line 1966: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_WRKPLN_ATTR');

1962: ,x_msg_data => l_msg_data );
1963:
1964: if l_return_status <> 'S' then
1965: x_err_code := 710;
1966: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_WRKPLN_ATTR');
1967: x_err_stack := x_err_stack||'->PA_WORKPLAN_ATTR_PUB.CREATE_PROJ_WORKPLAN_ATTRS';
1968: rollback to copy_project;
1969: return;
1970: end if;

Line 1973: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

1969: return;
1970: end if;
1971: EXCEPTION WHEN OTHERS THEN
1972: x_err_code := 710;
1973: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
1974: -- IF x_err_stage IS NULL
1975: -- THEN
1976: x_err_stage := 'API: '||'PA_WORKPLAN_ATTR_PUB.CREATE_PROJ_WORKPLAN_ATTRS'||
1977: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

Line 2008: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_EXEC_APPLY_TEAM_TMP');

2004:
2005: if l_return_status <> 'S' then
2006: x_err_code := 256;
2007: -- x_err_stage := 'PA_NO_PROJ_CREATED';
2008: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_EXEC_APPLY_TEAM_TMP');
2009: x_err_stack := x_err_stack||'->PA_TEAM_TEMPLATES_PUB.EXECUTE_APPLY_TEAM_TEMPLATE';
2010: rollback to copy_project;
2011: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2012: return;

Line 2016: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

2012: return;
2013: end if;
2014: EXCEPTION WHEN OTHERS THEN
2015: x_err_code := 256;
2016: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
2017: -- IF x_err_stage IS NULL
2018: -- THEN
2019: x_err_stage := 'API: '||'PA_TEAM_TEMPLATES_PUB.EXECUTE_APPLY_TEAM_TEMPLATE'||
2020: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

Line 2198: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');

2194: rollback to copy_project;
2195: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2196: x_err_code := 125;
2197: -- x_err_stage := 'PA_NO_PROJ_CREATED'; --commented by ansari
2198: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
2199: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
2200: return;
2201: END IF;
2202: END IF; --bug 2778730

Line 2205: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

2201: END IF;
2202: END IF; --bug 2778730
2203: EXCEPTION WHEN OTHERS THEN
2204: x_err_code := 125;
2205: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
2206: -- IF x_err_stage IS NULL
2207: -- THEN
2208: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||
2209: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

Line 2357: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');

2353: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2354:
2355: x_err_code := 125;
2356: -- x_err_stage := 'PA_NO_PROJ_CREATED';
2357: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
2358: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
2359: return;
2360: END IF;
2361: END IF; -- Bug 7482391

Line 2365: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

2361: END IF; -- Bug 7482391
2362: END IF; --bug 2778730
2363: EXCEPTION WHEN OTHERS THEN
2364: x_err_code := 125;
2365: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
2366: -- IF x_err_stage IS NULL
2367: -- THEN
2368: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT _PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
2369: -- END IF;

Line 2527: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');

2523: CLOSE c_cust_created_org_csr;
2524: rollback to copy_project;
2525: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2526: x_err_code := 125;
2527: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
2528: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
2529: return;
2530: END IF;
2531: END IF;

Line 2536: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

2532:
2533: CLOSE c_cust_created_org_csr;
2534: EXCEPTION WHEN OTHERS THEN
2535: x_err_code := 125;
2536: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
2537: -- IF x_err_stage IS NULL
2538: -- THEN
2539: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||
2540: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

Line 2595: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');

2591:
2592: rollback to copy_project;
2593: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2594: x_err_code := 125;
2595: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
2596: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
2597: return;
2598: END IF;
2599: END IF;

Line 2604: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

2600:
2601: CLOSE c_cust_created_org_csr;
2602: EXCEPTION WHEN OTHERS THEN
2603: x_err_code := 125;
2604: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
2605: -- IF x_err_stage IS NULL
2606: -- THEN
2607: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT _PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
2608: -- END IF;

Line 3053: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');

3049:
3050: rollback to copy_project;
3051: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
3052: x_err_code := 167;
3053: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
3054: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
3055: return;
3056: END IF;
3057:

Line 3069: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

3065: CLOSE l_customers_csr; --Bug 3905797
3066:
3067: EXCEPTION WHEN OTHERS THEN
3068: x_err_code := 167;
3069: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
3070: -- IF x_err_stage IS NULL
3071: -- THEN
3072: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
3073: -- END IF;

Line 3773: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');

3769:
3770: rollback to copy_project;
3771: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
3772: x_err_code := 168;
3773: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
3774: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
3775: return;
3776: END IF;
3777:

Line 3790: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

3786: End if; -- -- Bug 2984536.
3787:
3788: EXCEPTION WHEN OTHERS THEN
3789: x_err_code := 168;
3790: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
3791: -- IF x_err_stage IS NULL
3792: -- THEN
3793: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
3794: -- END IF;

Line 5022: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_TASK');

5018: if ( x_err_code > 0 or x_err_code < 0 ) then
5019: x_err_code := 800;
5020: IF x_err_stage IS NULL
5021: THEN
5022: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_TASK');
5023: END IF;
5024: x_err_stack := x_err_stack||'->pa_project_core2.copy_task';
5025: rollback to copy_project;
5026: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

Line 5036: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

5032: l_is_fin_str_copied := 'Y';
5033: END IF;
5034: EXCEPTION WHEN OTHERS THEN
5035: x_err_code := 800;
5036: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5037: -- IF x_err_stage IS NULL
5038: -- THEN
5039: x_err_stage := 'API: '||'pa_project_core2.copy_task'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
5040: -- END IF;

Line 5191: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_DFLT_STRUCTURE');

5187:
5188: IF l_return_status <> 'S'
5189: THEN
5190: x_err_code := 805;
5191: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_DFLT_STRUCTURE');
5192: x_err_stack := x_err_stack||'->PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE';
5193: rollback to copy_project;
5194: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5195: return;

Line 5200: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

5196: END IF;
5197: -- end if;
5198: EXCEPTION WHEN OTHERS THEN
5199: x_err_code := 805;
5200: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5201: -- IF x_err_stage IS NULL
5202: -- THEN
5203: x_err_stage := 'API: '||'PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE'||
5204:

Line 5226: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_OBJ_PG_LAY');

5222: x_msg_data => l_msg_data );
5223: IF l_return_status <> fnd_api.g_ret_sts_success
5224: THEN
5225: x_err_code := 730;
5226: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_OBJ_PG_LAY');
5227: x_err_stack := x_err_stack||'->PA_Page_layout_Utils.copy_object_page_layouts';
5228: rollback to copy_project;
5229: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5230: return;

Line 5234: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

5230: return;
5231: END IF;
5232: EXCEPTION WHEN OTHERS THEN
5233: x_err_code := 730;
5234: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5235: -- IF x_err_stage IS NULL
5236: -- THEN
5237: x_err_stage := 'API: '||'PA_Page_layout_Utils.copy_object_page_layouts'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
5238: -- END IF;

Line 5257: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_PROJ_ACTSET');

5253: x_msg_data => l_msg_data );
5254: IF l_return_status <> fnd_api.g_ret_sts_success
5255: THEN
5256: x_err_code := 844;
5257: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_PROJ_ACTSET');
5258: x_err_stack := x_err_stack||'->PA_PROJ_STAT_ACTSET.copy_action_sets';
5259: rollback to copy_project;
5260: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5261: return;

Line 5265: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

5261: return;
5262: END IF;
5263: EXCEPTION WHEN OTHERS THEN
5264: x_err_code := 844;
5265: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5266: -- IF x_err_stage IS NULL
5267: -- THEN
5268: x_err_stage := 'API: '||'PA_PROJ_STAT_ACTSET.copy_action_sets'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
5269: -- END IF;

Line 5286: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_TASK_ACTSET');

5282: x_msg_data => l_msg_data );
5283: IF l_return_status <> fnd_api.g_ret_sts_success
5284: THEN
5285: x_err_code := 866;
5286: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_TASK_ACTSET');
5287: x_err_stack := x_err_stack||'->PA_TASK_PROG_ACTSET.copy_action_sets';
5288: rollback to copy_project;
5289: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5290: return;

Line 5294: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

5290: return;
5291: END IF;
5292: EXCEPTION WHEN OTHERS THEN
5293: x_err_code := 866;
5294: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5295: -- IF x_err_stage IS NULL
5296: -- THEN
5297: x_err_stage := 'API: '||'PA_TASK_PROG_ACTSET.copy_action_sets'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
5298: -- END IF;

Line 5321: x_err_stage := pa_project_core1.get_message_from_stack('PA_PERF_COPY_RULES_ERR');

5317: ,x_msg_data => l_msg_data );
5318:
5319: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
5320: x_err_code := 880;
5321: x_err_stage := pa_project_core1.get_message_from_stack('PA_PERF_COPY_RULES_ERR');
5322: x_err_stack := x_err_stack||'->PA_PERF_EXCP_UTILS.copy_object_rule_assoc';
5323: rollback to copy_project;
5324: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5325: return;

Line 5360: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_ITEM_ASSOCS');

5356: ,x_msg_data => l_msg_data);
5357:
5358: if l_return_status <> 'S' then
5359: x_err_code := 710;
5360: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_ITEM_ASSOCS');
5361: x_err_stack := x_err_stack||'->PA_EGO_WRAPPER_PUB.COPY_ITEM_ASSOCS';
5362: rollback to copy_project;
5363: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5364: return;

Line 5369: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

5365: end if;
5366: END IF; --for 'Y' = l_pr_item_assoc_flag
5367: EXCEPTION WHEN OTHERS THEN
5368: x_err_code := 710;
5369: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5370: -- IF x_err_stage IS NULL
5371: -- THEN
5372: x_err_stage := 'API: '||'PA_EGO_WRAPPER_PUB.COPY_ITEM_ASSOCS'||
5373: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

Line 5404: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_PROJ_EXT_ATTR');

5400: ,x_msg_data => l_msg_data);
5401:
5402: if l_return_status <> 'S' then
5403: x_err_code := 16384;
5404: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_PROJ_EXT_ATTR');
5405: x_err_stack := x_err_stack||'->PA_USER_ATTR_PUB.COPY_USER_ATTRS_DATA';
5406: rollback to copy_project;
5407: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5408: return;

Line 5438: x_err_stage := pa_project_core1.get_message_from_stack('PA_ERR_INSERT_ACCUM');

5434: );
5435: IF l_return_status <> fnd_api.g_ret_sts_success
5436: THEN
5437: x_err_code := 735;
5438: x_err_stage := pa_project_core1.get_message_from_stack('PA_ERR_INSERT_ACCUM');
5439: x_err_stack := x_err_stack||'->pa_accum_proj_list.Insert_Accum';
5440: rollback to copy_project;
5441: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5442: return;

Line 5446: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

5442: return;
5443: END IF;
5444: EXCEPTION WHEN OTHERS THEN
5445: x_err_code := 735;
5446: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5447: -- IF x_err_stage IS NULL
5448: -- THEN
5449: x_err_stage := 'API: '||'pa_accum_proj_list.Insert_Accum'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
5450: -- END IF;

Line 5505: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_AGREEMENT');

5501: if x_err_code <> 0 then
5502: x_err_code := 745;
5503: IF x_err_stage IS NULL
5504: THEN
5505: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_AGREEMENT');
5506: END IF;
5507: x_err_stack := x_err_stack||'->pa_billing_core.copy_agreement';
5508: rollback to copy_project;
5509: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

Line 5514: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

5510: return;
5511: end if;
5512: EXCEPTION WHEN OTHERS THEN
5513: x_err_code := 745;
5514: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5515: -- IF x_err_stage IS NULL
5516: -- THEN
5517: x_err_stage := 'API: '||'pa_billing_core.copy_agreement'||
5518: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

Line 5553: x_err_stage := pa_project_core1.get_message_from_stack(l_msg_data);

5549: IF l_msg_data IS NULL THEN
5550: l_msg_data := 'PA_ERR_COPY_FINPLANS';
5551: END IF ;
5552: x_err_code := 750;
5553: x_err_stage := pa_project_core1.get_message_from_stack(l_msg_data);
5554: x_err_stack := x_err_stack||'->PA_FP_COPY_FROM_PKG.copy_finplans_from_project';
5555: rollback to copy_project;
5556: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5557: return;

Line 5561: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

5557: return;
5558: END IF;
5559: EXCEPTION WHEN OTHERS THEN
5560: x_err_code := 750;
5561: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5562: -- IF x_err_stage IS NULL
5563: -- THEN
5564: x_err_stage := 'API: '||'PA_FP_COPY_FROM_PKG.copy_finplans_from_project'||' SQL error message: '||
5565: SUBSTR( SQLERRM,1,1900);

Line 5632: x_err_stage := pa_project_core1.get_message_from_stack('PA_ERR_BUDGT_BASLINE');

5628:
5629: IF x_err_code <> 0
5630: THEN
5631: x_err_code := 755;
5632: x_err_stage := pa_project_core1.get_message_from_stack('PA_ERR_BUDGT_BASLINE');
5633: x_err_stack := x_err_stack||'->PA_BASELINE_FUNDING_PKG.create_budget_baseline';
5634: rollback to copy_project;
5635: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5636: return;

Line 5665: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_PROJ_TASK_ASSN');

5661: ,x_msg_data => l_msg_data);
5662:
5663: if l_return_status <> 'S' then
5664: x_err_code := 760;
5665: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_PROJ_TASK_ASSN');
5666: x_err_stack := x_err_stack||'->PA_TASK_PUB1.COPY_TASK_ASSOCIATIONS';
5667: rollback to copy_project;
5668: return;
5669: end if;

Line 5883: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_PROCESS_WBS');

5879: ,x_msg_data => l_msg_data);
5880:
5881: if l_return_status <> 'S' then
5882: x_err_code := 1010;
5883: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_PROCESS_WBS');
5884: x_err_stack := x_err_stack||'->PA_PROJ_TASK_STRUC_PUB.CALL_PROCESS_WBS_UPDATES';
5885: rollback to copy_project;
5886: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5887: return;

Line 6108: ( p_pkg_name => 'PA_PROJECT_CORE1'

6104: ROLLBACK TO pop_copy_options;
6105: END IF;
6106:
6107: Fnd_Msg_Pub.add_exc_msg
6108: ( p_pkg_name => 'PA_PROJECT_CORE1'
6109: , p_procedure_name => 'populate_copy_options'
6110: , p_error_text => x_msg_data);
6111:
6112: IF l_debug_mode = 'Y' THEN

Line 6241: Pa_Debug.g_err_stage:= 'PA_PROJECT_CORE1 : populate_default_copy_options :

6237: ( p_src_template_flag IS NULL OR p_src_template_flag = FND_API.G_MISS_CHAR )
6238: )
6239: THEN
6240: IF l_debug_mode = 'Y' THEN
6241: Pa_Debug.g_err_stage:= 'PA_PROJECT_CORE1 : populate_default_copy_options :
6242: p_src_project_id, p_src_template_flag are NULL';
6243: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
6244: l_debug_level3);
6245: END IF;

Line 6392: x_msg_data := ' PA_PROJECT_CORE1 : populate_default_copy_options : NULL parameters passed';

6388: EXCEPTION
6389: WHEN Invalid_Arg_Exc THEN
6390: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6391: x_msg_count := 1;
6392: x_msg_data := ' PA_PROJECT_CORE1 : populate_default_copy_options : NULL parameters passed';
6393:
6394: IF p_commit = FND_API.G_TRUE THEN
6395: ROLLBACK TO def_copy_options;
6396: END IF;

Line 6399: ( p_pkg_name => 'PA_PROJECT_CORE1'

6395: ROLLBACK TO def_copy_options;
6396: END IF;
6397:
6398: Fnd_Msg_Pub.add_exc_msg
6399: ( p_pkg_name => 'PA_PROJECT_CORE1'
6400: , p_procedure_name => 'populate_default_copy_options'
6401: , p_error_text => x_msg_data);
6402:
6403: IF l_debug_mode = 'Y' THEN

Line 6421: ( p_pkg_name => 'PA_PROJECT_CORE1'

6417: ROLLBACK TO def_copy_options;
6418: END IF;
6419:
6420: Fnd_Msg_Pub.add_exc_msg
6421: ( p_pkg_name => 'PA_PROJECT_CORE1'
6422: , p_procedure_name => 'populate_default_copy_options'
6423: , p_error_text => x_msg_data);
6424:
6425: IF l_debug_mode = 'Y' THEN

Line 6435: END PA_PROJECT_CORE1 ;

6431: RAISE;
6432:
6433: END populate_default_copy_options;
6434:
6435: END PA_PROJECT_CORE1 ;