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.28.12020000.5 2013/04/09 10:45:32 krkondur 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.28.12020000.5 2013/04/09 10:45:32 krkondur ship $
3:
4: g_module_name VARCHAR2(100) := 'PA_PROJECT_CORE1';
5: Invalid_Arg_Exc EXCEPTION;
6:
7: --
8: -- PROCEDURE

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

510: if x_err_code <> 0 then
511: x_err_code := 765;
512: IF x_err_stage IS NULL
513: THEN
514: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_PRJ_COR1_GET_PRJ_NUM');
515: END IF;
516: x_err_stack := x_err_stack||'->pa_project_core1.get_project_number_by_numcode';
517: rollback to copy_project;
518: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

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

512: IF x_err_stage IS NULL
513: THEN
514: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_PRJ_COR1_GET_PRJ_NUM');
515: END IF;
516: x_err_stack := x_err_stack||'->pa_project_core1.get_project_number_by_numcode';
517: rollback to copy_project;
518: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
519: return;
520: end if;

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

519: return;
520: end if;
521: EXCEPTION WHEN OTHERS THEN
522: x_err_code := 765;
523: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
524: -- IF x_err_stage IS NULL
525: -- THEN
526: x_err_stage := 'API: '||'pa_project_core1.get_project_number_by_numcode'||
527: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

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

522: x_err_code := 765;
523: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
524: -- IF x_err_stage IS NULL
525: -- THEN
526: x_err_stage := 'API: '||'pa_project_core1.get_project_number_by_numcode'||
527: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
528: -- END IF;
529: rollback to copy_project;
530: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

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

929: THEN
930: x_err_code := 740;
931: IF x_err_stage IS NULL
932: THEN
933: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_VAL_ATTR_CHANGE');
934: END IF;
935: x_err_stack := x_err_stack||'->pa_project_utils2.validate_attribute_change';
936: rollback to copy_project;
937: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

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

939: END IF;
940:
941: EXCEPTION WHEN OTHERS THEN
942: x_err_code := 740;
943: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
944: -- IF x_err_stage IS NULL
945: -- THEN
946: x_err_stage := 'API: '||'pa_project_utils2.validate_attribute_change'||' SQL error message: '
947: ||SUBSTR( SQLERRM,1,1900);

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

986: x_location_id => l_location_id);
987: IF l_return_status <> 'S'
988: THEN
989: x_err_code := 770;
990: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CHK_LOC_EXISTS');
991: x_err_stack := x_err_stack||'->pa_location_utils.check_location_exists';
992: rollback to copy_project;
993: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
994: return;

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

994: return;
995: END IF;
996: EXCEPTION WHEN OTHERS THEN
997: x_err_code := 770;
998: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
999: -- IF x_err_stage IS NULL
1000: -- THEN
1001: x_err_stage := 'API: '||'pa_location_utils.check_location_exists'||
1002: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

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

1047: THEN
1048: x_err_code := 780;
1049: IF x_error_message_code IS NULL
1050: THEN
1051: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_GET_ORG_LOC_DTLS');
1052: ELSE
1053: x_err_stage := x_error_message_code; --bug fix 2680591
1054: END IF;
1055: x_err_stack := x_err_stack||'->pa_location_utils.Get_ORG_Location_Details';

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

1058: return;
1059: END IF;
1060: EXCEPTION WHEN OTHERS THEN
1061: x_err_code := 780;
1062: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
1063: -- IF x_error_message_code IS NULL
1064: -- THEN
1065: x_err_stage := 'API: '||'pa_location_utils.Get_ORG_Location_Details'||
1066: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

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

1080: x_location_id => l_location_id);
1081: IF l_return_status <> 'S'
1082: THEN
1083: x_err_code := 775;
1084: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CHK_LOC_EXISTS');
1085: x_err_stack := x_err_stack||'->pa_location_utils.check_location_exists';
1086: rollback to copy_project;
1087: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1088: return;

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

1088: return;
1089: END IF;
1090: EXCEPTION WHEN OTHERS THEN
1091: x_err_code := 775;
1092: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
1093: -- IF x_err_stage IS NULL
1094: -- THEN
1095: x_err_stage := 'API: '||'pa_location_utils.check_location_exists'||
1096: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

Line 1172: PA_PROJECT_CORE1.populate_default_copy_options( p_src_project_id => x_orig_project_id

1168: x_new_project_id || ' by copying original project '||
1169: x_orig_project_id;
1170:
1171: --Following code added for selective copy project changes. Tracking Bug no. 3464332
1172: PA_PROJECT_CORE1.populate_default_copy_options( p_src_project_id => x_orig_project_id
1173: ,p_src_template_flag => x_orig_template_flag
1174: ,p_dest_template_flag => x_template_flag
1175: ,x_return_status => l_return_status
1176: ,x_msg_count => l_msg_count

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

1179: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1180: ROLLBACK TO copy_project;
1181: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1182: x_err_code := 199;
1183: x_err_stage := 'API: '||'PA_PROJECT_CORE1.POPULATE_DEFAULT_COPY_OPTIONS'||
1184: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
1185: x_err_stack := x_err_stack||'->PA_PROJECT_CORE1.POPULATE_DEFAULT_COPY_OPTIONS';
1186: RETURN;
1187: END IF;

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

1181: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1182: x_err_code := 199;
1183: x_err_stage := 'API: '||'PA_PROJECT_CORE1.POPULATE_DEFAULT_COPY_OPTIONS'||
1184: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
1185: x_err_stack := x_err_stack||'->PA_PROJECT_CORE1.POPULATE_DEFAULT_COPY_OPTIONS';
1186: RETURN;
1187: END IF;
1188: --Following code added for selective copy project changes. Tracking Bug no. 3464332
1189: OPEN cur_get_flag('PR_DFF_FLAG');

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

1875: IF (l_return_status <> 'S') Then
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;

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

1884: CLOSE get_subteams_csr; --Bug 3905797
1885:
1886: EXCEPTION WHEN OTHERS THEN
1887: x_err_code := 102;
1888: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
1889: -- IF x_err_stage IS NULL
1890: -- THEN
1891: x_err_stage := 'API: '||'PA_PROJECT_SUBTEAMS_PUB.CREATE_SUBTEAM'||
1892: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

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

1910: ,x_msg_data => l_msg_data);
1911:
1912: if l_return_status <> 'S' then
1913: x_err_code := 128;
1914: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_PROJ_OPP_ATTR');
1915: x_err_stack := x_err_stack||'->PA_OPPORTUNITY_MGT_PVT.COPY_PROJECT_ATTRIBUTES';
1916: rollback to copy_project;
1917: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1918: return;

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

1918: return;
1919: end if;
1920: EXCEPTION WHEN OTHERS THEN
1921: x_err_code := 128;
1922: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
1923: -- IF x_err_stage IS NULL
1924: -- THEN
1925: x_err_stage := 'API: '||'PA_OPPORTUNITY_MGT_PVT.COPY_PROJECT_ATTRIBUTES'||
1926: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

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

1954: ,x_msg_data => l_msg_data);
1955:
1956: if l_return_status <> 'S' then
1957: x_err_code := 130;
1958: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_MOD_PROJ_OPP_ATTR');
1959: x_err_stack := x_err_stack||'->PA_OPPORTUNITY_MGT_PVT.MODIFY_PROJECT_ATTRIBUTES';
1960: rollback to copy_project;
1961: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1962: return;

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

1962: return;
1963: end if;
1964: EXCEPTION WHEN OTHERS THEN
1965: x_err_code := 130;
1966: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
1967: -- IF x_err_stage IS NULL
1968: -- THEN
1969: x_err_stage := 'API: '||'PA_OPPORTUNITY_MGT_PVT.MODIFY_PROJECT_ATTRIBUTES'||
1970: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

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

1998: ,x_msg_data => l_msg_data );
1999:
2000: if l_return_status <> 'S' then
2001: x_err_code := 710;
2002: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_WRKPLN_ATTR');
2003: x_err_stack := x_err_stack||'->PA_WORKPLAN_ATTR_PUB.CREATE_PROJ_WORKPLAN_ATTRS';
2004: rollback to copy_project;
2005: return;
2006: end if;

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

2005: return;
2006: end if;
2007: EXCEPTION WHEN OTHERS THEN
2008: x_err_code := 710;
2009: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
2010: -- IF x_err_stage IS NULL
2011: -- THEN
2012: x_err_stage := 'API: '||'PA_WORKPLAN_ATTR_PUB.CREATE_PROJ_WORKPLAN_ATTRS'||
2013: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

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

2040:
2041: if l_return_status <> 'S' then
2042: x_err_code := 256;
2043: -- x_err_stage := 'PA_NO_PROJ_CREATED';
2044: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_EXEC_APPLY_TEAM_TMP');
2045: x_err_stack := x_err_stack||'->PA_TEAM_TEMPLATES_PUB.EXECUTE_APPLY_TEAM_TEMPLATE';
2046: rollback to copy_project;
2047: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2048: return;

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

2048: return;
2049: end if;
2050: EXCEPTION WHEN OTHERS THEN
2051: x_err_code := 256;
2052: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
2053: -- IF x_err_stage IS NULL
2054: -- THEN
2055: x_err_stage := 'API: '||'PA_TEAM_TEMPLATES_PUB.EXECUTE_APPLY_TEAM_TEMPLATE'||
2056: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

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

2231: rollback to copy_project;
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

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

2238: END IF;
2239: END IF; --bug 2778730
2240: EXCEPTION WHEN OTHERS THEN
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);

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

2396: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
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

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

2404: END IF; -- Bug 7482391
2405: END IF; --bug 2778730
2406: EXCEPTION WHEN OTHERS THEN
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;

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

2566: CLOSE c_cust_created_org_csr;
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;

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

2575:
2576: CLOSE c_cust_created_org_csr;
2577: EXCEPTION WHEN OTHERS THEN
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);

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

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

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

2643:
2644: CLOSE c_cust_created_org_csr;
2645: EXCEPTION WHEN OTHERS THEN
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;

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

3092:
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:

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

3108: CLOSE l_customers_csr; --Bug 3905797
3109:
3110: EXCEPTION WHEN OTHERS THEN
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;

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

3812:
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:

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

3829: End if; -- -- Bug 2984536.
3830:
3831: EXCEPTION WHEN OTHERS THEN
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;

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

5066: if ( x_err_code > 0 or x_err_code < 0 ) then
5067: x_err_code := 800;
5068: IF x_err_stage IS NULL
5069: THEN
5070: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_TASK');
5071: END IF;
5072: x_err_stack := x_err_stack||'->pa_project_core2.copy_task';
5073: rollback to copy_project;
5074: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

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

5080: l_is_fin_str_copied := 'Y';
5081: END IF;
5082: EXCEPTION WHEN OTHERS THEN
5083: x_err_code := 800;
5084: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5085: -- IF x_err_stage IS NULL
5086: -- THEN
5087: x_err_stage := 'API: '||'pa_project_core2.copy_task'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
5088: -- END IF;

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

5255:
5256: IF l_return_status <> 'S'
5257: THEN
5258: x_err_code := 805;
5259: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_DFLT_STRUCTURE');
5260: x_err_stack := x_err_stack||'->PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE';
5261: rollback to copy_project;
5262: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5263: return;

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

5264: END IF;
5265: -- end if;
5266: EXCEPTION WHEN OTHERS THEN
5267: x_err_code := 805;
5268: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5269: -- IF x_err_stage IS NULL
5270: -- THEN
5271: x_err_stage := 'API: '||'PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE'||
5272:

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

5290: x_msg_data => l_msg_data );
5291: IF l_return_status <> fnd_api.g_ret_sts_success
5292: THEN
5293: x_err_code := 730;
5294: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_OBJ_PG_LAY');
5295: x_err_stack := x_err_stack||'->PA_Page_layout_Utils.copy_object_page_layouts';
5296: rollback to copy_project;
5297: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5298: return;

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

5298: return;
5299: END IF;
5300: EXCEPTION WHEN OTHERS THEN
5301: x_err_code := 730;
5302: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5303: -- IF x_err_stage IS NULL
5304: -- THEN
5305: x_err_stage := 'API: '||'PA_Page_layout_Utils.copy_object_page_layouts'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
5306: -- END IF;

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

5321: x_msg_data => l_msg_data );
5322: IF l_return_status <> fnd_api.g_ret_sts_success
5323: THEN
5324: x_err_code := 844;
5325: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_PROJ_ACTSET');
5326: x_err_stack := x_err_stack||'->PA_PROJ_STAT_ACTSET.copy_action_sets';
5327: rollback to copy_project;
5328: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5329: return;

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

5329: return;
5330: END IF;
5331: EXCEPTION WHEN OTHERS THEN
5332: x_err_code := 844;
5333: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5334: -- IF x_err_stage IS NULL
5335: -- THEN
5336: x_err_stage := 'API: '||'PA_PROJ_STAT_ACTSET.copy_action_sets'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
5337: -- END IF;

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

5350: x_msg_data => l_msg_data );
5351: IF l_return_status <> fnd_api.g_ret_sts_success
5352: THEN
5353: x_err_code := 866;
5354: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_TASK_ACTSET');
5355: x_err_stack := x_err_stack||'->PA_TASK_PROG_ACTSET.copy_action_sets';
5356: rollback to copy_project;
5357: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5358: return;

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

5358: return;
5359: END IF;
5360: EXCEPTION WHEN OTHERS THEN
5361: x_err_code := 866;
5362: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5363: -- IF x_err_stage IS NULL
5364: -- THEN
5365: x_err_stage := 'API: '||'PA_TASK_PROG_ACTSET.copy_action_sets'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
5366: -- END IF;

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

5385: ,x_msg_data => l_msg_data );
5386:
5387: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
5388: x_err_code := 880;
5389: x_err_stage := pa_project_core1.get_message_from_stack('PA_PERF_COPY_RULES_ERR');
5390: x_err_stack := x_err_stack||'->PA_PERF_EXCP_UTILS.copy_object_rule_assoc';
5391: rollback to copy_project;
5392: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5393: return;

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

5424: ,x_msg_data => l_msg_data);
5425:
5426: if l_return_status <> 'S' then
5427: x_err_code := 710;
5428: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_ITEM_ASSOCS');
5429: x_err_stack := x_err_stack||'->PA_EGO_WRAPPER_PUB.COPY_ITEM_ASSOCS';
5430: rollback to copy_project;
5431: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5432: return;

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

5433: end if;
5434: END IF; --for 'Y' = l_pr_item_assoc_flag
5435: EXCEPTION WHEN OTHERS THEN
5436: x_err_code := 710;
5437: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5438: -- IF x_err_stage IS NULL
5439: -- THEN
5440: x_err_stage := 'API: '||'PA_EGO_WRAPPER_PUB.COPY_ITEM_ASSOCS'||
5441: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

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

5468: ,x_msg_data => l_msg_data);
5469:
5470: if l_return_status <> 'S' then
5471: x_err_code := 16384;
5472: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_PROJ_EXT_ATTR');
5473: x_err_stack := x_err_stack||'->PA_USER_ATTR_PUB.COPY_USER_ATTRS_DATA';
5474: rollback to copy_project;
5475: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5476: return;

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

5502: );
5503: IF l_return_status <> fnd_api.g_ret_sts_success
5504: THEN
5505: x_err_code := 735;
5506: x_err_stage := pa_project_core1.get_message_from_stack('PA_ERR_INSERT_ACCUM');
5507: x_err_stack := x_err_stack||'->pa_accum_proj_list.Insert_Accum';
5508: rollback to copy_project;
5509: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5510: return;

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 := 735;
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_accum_proj_list.Insert_Accum'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
5518: -- END IF;

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

5569: if x_err_code <> 0 then
5570: x_err_code := 745;
5571: IF x_err_stage IS NULL
5572: THEN
5573: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_AGREEMENT');
5574: END IF;
5575: x_err_stack := x_err_stack||'->pa_billing_core.copy_agreement';
5576: rollback to copy_project;
5577: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

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

5578: return;
5579: end if;
5580: EXCEPTION WHEN OTHERS THEN
5581: x_err_code := 745;
5582: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5583: -- IF x_err_stage IS NULL
5584: -- THEN
5585: x_err_stage := 'API: '||'pa_billing_core.copy_agreement'||
5586: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

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

5617: IF l_msg_data IS NULL THEN
5618: l_msg_data := 'PA_ERR_COPY_FINPLANS';
5619: END IF ;
5620: x_err_code := 750;
5621: x_err_stage := pa_project_core1.get_message_from_stack(l_msg_data);
5622: x_err_stack := x_err_stack||'->PA_FP_COPY_FROM_PKG.copy_finplans_from_project';
5623: rollback to copy_project;
5624: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5625: return;

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

5625: return;
5626: END IF;
5627: EXCEPTION WHEN OTHERS THEN
5628: x_err_code := 750;
5629: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5630: -- IF x_err_stage IS NULL
5631: -- THEN
5632: x_err_stage := 'API: '||'PA_FP_COPY_FROM_PKG.copy_finplans_from_project'||' SQL error message: '||
5633: SUBSTR( SQLERRM,1,1900);

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

5696:
5697: IF x_err_code <> 0
5698: THEN
5699: x_err_code := 755;
5700: x_err_stage := pa_project_core1.get_message_from_stack('PA_ERR_BUDGT_BASLINE');
5701: x_err_stack := x_err_stack||'->PA_BASELINE_FUNDING_PKG.create_budget_baseline';
5702: rollback to copy_project;
5703: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5704: return;

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

5729: ,x_msg_data => l_msg_data);
5730:
5731: if l_return_status <> 'S' then
5732: x_err_code := 760;
5733: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_PROJ_TASK_ASSN');
5734: x_err_stack := x_err_stack||'->PA_TASK_PUB1.COPY_TASK_ASSOCIATIONS';
5735: rollback to copy_project;
5736: return;
5737: end if;

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

5947: ,x_msg_data => l_msg_data);
5948:
5949: if l_return_status <> 'S' then
5950: x_err_code := 1010;
5951: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_PROCESS_WBS');
5952: x_err_stack := x_err_stack||'->PA_PROJ_TASK_STRUC_PUB.CALL_PROCESS_WBS_UPDATES';
5953: rollback to copy_project;
5954: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5955: return;

Line 6176: ( p_pkg_name => 'PA_PROJECT_CORE1'

6172: ROLLBACK TO pop_copy_options;
6173: END IF;
6174:
6175: Fnd_Msg_Pub.add_exc_msg
6176: ( p_pkg_name => 'PA_PROJECT_CORE1'
6177: , p_procedure_name => 'populate_copy_options'
6178: , p_error_text => x_msg_data);
6179:
6180: IF l_debug_mode = 'Y' THEN

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

6305: ( p_src_template_flag IS NULL OR p_src_template_flag = FND_API.G_MISS_CHAR )
6306: )
6307: THEN
6308: IF l_debug_mode = 'Y' THEN
6309: Pa_Debug.g_err_stage:= 'PA_PROJECT_CORE1 : populate_default_copy_options :
6310: p_src_project_id, p_src_template_flag are NULL';
6311: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
6312: l_debug_level3);
6313: END IF;

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

6456: EXCEPTION
6457: WHEN Invalid_Arg_Exc THEN
6458: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6459: x_msg_count := 1;
6460: x_msg_data := ' PA_PROJECT_CORE1 : populate_default_copy_options : NULL parameters passed';
6461:
6462: IF p_commit = FND_API.G_TRUE THEN
6463: ROLLBACK TO def_copy_options;
6464: END IF;

Line 6467: ( p_pkg_name => 'PA_PROJECT_CORE1'

6463: ROLLBACK TO def_copy_options;
6464: END IF;
6465:
6466: Fnd_Msg_Pub.add_exc_msg
6467: ( p_pkg_name => 'PA_PROJECT_CORE1'
6468: , p_procedure_name => 'populate_default_copy_options'
6469: , p_error_text => x_msg_data);
6470:
6471: IF l_debug_mode = 'Y' THEN

Line 6489: ( p_pkg_name => 'PA_PROJECT_CORE1'

6485: ROLLBACK TO def_copy_options;
6486: END IF;
6487:
6488: Fnd_Msg_Pub.add_exc_msg
6489: ( p_pkg_name => 'PA_PROJECT_CORE1'
6490: , p_procedure_name => 'populate_default_copy_options'
6491: , p_error_text => x_msg_data);
6492:
6493: IF l_debug_mode = 'Y' THEN

Line 6503: END PA_PROJECT_CORE1 ;

6499: RAISE;
6500:
6501: END populate_default_copy_options;
6502:
6503: END PA_PROJECT_CORE1 ;