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_FP_WEBADI_UTILS dependencies on PA_FP_CONSTANTS_PKG

Line 330: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

326: x_rej_lines_exist := pa_fin_plan_utils.does_bv_have_rej_lines(p_budget_version_id);
327:
328: EXCEPTION
329:
330: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
331: l_msg_count := FND_MSG_PUB.count_msg;
332: IF l_msg_count = 1 THEN
333: PA_INTERFACE_UTILS_PUB.get_messages
334: (p_encoded => FND_API.G_TRUE

Line 436: IF l_time_phased_code IN(PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G) THEN

432: FROM pa_projects_all p
433: WHERE p.project_id = l_project_id;
434:
435:
436: IF l_time_phased_code IN(PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G) THEN
437:
438: IF l_period_profile_id IS NULL THEN
439: -- pa_debug.g_err_stage := 'period_profile_id is null when time phasing is PA or GL ';
440: -- pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

Line 443: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

439: -- pa_debug.g_err_stage := 'period_profile_id is null when time phasing is PA or GL ';
440: -- pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
441: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
442: p_msg_name => 'PA_FP_PERIODPROFILE_UNDEFINED');
443: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
444: END IF;
445:
446: ELSE /* if time phasing is none then */
447:

Line 448: IF l_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_N THEN

444: END IF;
445:
446: ELSE /* if time phasing is none then */
447:
448: IF l_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_N THEN
449: IF l_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
450: IF l_project_start_date IS NULL or l_project_end_date IS NULL THEN
451: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
452: p_msg_name => 'PA_BU_NO_TASK_PROJ_DATE');

Line 449: IF l_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN

445:
446: ELSE /* if time phasing is none then */
447:
448: IF l_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_N THEN
449: IF l_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
450: IF l_project_start_date IS NULL or l_project_end_date IS NULL THEN
451: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
452: p_msg_name => 'PA_BU_NO_TASK_PROJ_DATE');
453: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 453: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

449: IF l_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
450: IF l_project_start_date IS NULL or l_project_end_date IS NULL THEN
451: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
452: p_msg_name => 'PA_BU_NO_TASK_PROJ_DATE');
453: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
454: END IF;
455: ELSE
456: OPEN C1(l_budget_version_id);
457: k :=0;

Line 472: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

468:
469: IF v_task_start_date_tab(m) IS NULL or v_task_end_date_tab(m) IS NULL THEN
470: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
471: p_msg_name => 'PA_BU_NO_TASK_PROJ_DATE');
472: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
473: END IF;
474:
475: END LOOP; /* for loop*/
476:

Line 482: WHEN FND_API.G_EXC_ERROR or PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

478: END IF;
479: END IF;
480:
481: EXCEPTION
482: WHEN FND_API.G_EXC_ERROR or PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
483: x_return_status := FND_API.G_RET_STS_ERROR;
484: l_msg_count := FND_MSG_PUB.count_msg;
485: IF l_msg_count = 1 THEN
486: PA_INTERFACE_UTILS_PUB.get_messages

Line 830: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

826:
827: x_return_status := FND_API.G_RET_STS_ERROR;
828: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
829: ,p_msg_name => 'PA_FP_INV_PARAM_PASSED');
830: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
831: END IF;
832:
833:
834: IF l_debug_mode = 'Y' THEN

Line 839: IF (p_planning_level = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT) THEN

835: pa_debug.g_err_stage := 'PA_FP_WEBADI_UTILS.GET_RES_ASSIGNMENT_INFO';
836: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
837: END IF ;
838:
839: IF (p_planning_level = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT) THEN
840:
841: IF l_debug_mode = 'Y' THEN
842: pa_debug.g_err_stage := 'opening project level cursor';
843: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

Line 896: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

892:
893: pa_debug.reset_curr_function;
894:
895: EXCEPTION
896: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
897: x_return_status := FND_API.G_RET_STS_ERROR;
898: l_msg_count := FND_MSG_PUB.count_msg;
899: IF l_msg_count = 1 THEN
900: PA_INTERFACE_UTILS_PUB.get_messages

Line 978: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

974: -- Check for business rules violations
975:
976: IF l_debug_mode = 'Y' THEN
977: pa_debug.g_err_stage:= 'Validating input parameters';
978: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
979: END IF;
980:
981: IF p_change_reason_code IS NOT NULL THEN
982: -- Open cursor c_code_exists_cur

Line 991: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

987: IF c_code_exists_cur%NOTFOUND THEN
988:
989: IF l_debug_mode = 'Y' THEN
990: pa_debug.g_err_stage:= 'could not find change reason code';
991: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
992: END IF;
993:
994: x_return_status := FND_API.G_RET_STS_ERROR ;
995: END IF ;

Line 999: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

995: END IF ;
996:
997: IF l_debug_mode = 'Y' THEN
998: pa_debug.g_err_stage:= 'Exiting VALIDATE_CHANGE_REASON_CODE';
999: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1000: pa_debug.reset_err_stack;
1001: END IF;
1002: END IF;
1003:

Line 1006: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

1002: END IF;
1003:
1004: EXCEPTION
1005:
1006: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1007: x_return_status := FND_API.G_RET_STS_ERROR;
1008: l_msg_count := FND_MSG_PUB.count_msg;
1009: IF l_msg_count = 1 THEN
1010: PA_INTERFACE_UTILS_PUB.get_messages

Line 1032: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

1028: END IF;
1029: IF l_debug_mode = 'Y' THEN
1030:
1031: pa_debug.g_err_stage:= 'Exiting VALIDATE_CHANGE_REASON_CODE';
1032: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1033: pa_debug.reset_err_stack;
1034:
1035: END IF;
1036: RETURN;

Line 1096: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

1092: -- Check for business rules violations
1093:
1094: IF l_debug_mode = 'Y' THEN
1095: pa_debug.g_err_stage:= 'Validating input parameters';
1096: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1097: END IF;
1098:
1099: IF (p_txn_currency_code IS NULL) OR (p_budget_version_id is NULL )
1100: THEN

Line 1103: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

1099: IF (p_txn_currency_code IS NULL) OR (p_budget_version_id is NULL )
1100: THEN
1101: IF l_debug_mode = 'Y' THEN
1102: pa_debug.g_err_stage:= 'Invalid input parameter';
1103: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
1104: END IF;
1105: PA_UTILS.ADD_MESSAGE
1106: (p_app_short_name => 'PA',
1107: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 1108: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1104: END IF;
1105: PA_UTILS.ADD_MESSAGE
1106: (p_app_short_name => 'PA',
1107: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1108: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1109:
1110: END IF;
1111:
1112:

Line 1154: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

1150: END IF ;
1151:
1152: IF l_debug_mode = 'Y' THEN
1153: pa_debug.g_err_stage:= 'Exiting VALIDATE_TXN_CURRENCY_CODE';
1154: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1155: pa_debug.reset_err_stack;
1156: END IF;
1157:
1158: EXCEPTION

Line 1160: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

1156: END IF;
1157:
1158: EXCEPTION
1159:
1160: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1161:
1162: x_return_status := FND_API.G_RET_STS_ERROR;
1163: l_msg_count := FND_MSG_PUB.count_msg;
1164:

Line 1435: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1431: END IF;
1432: x_return_status := FND_API.G_RET_STS_ERROR;
1433: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
1434: ,p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1435: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1436: END IF;
1437:
1438: OPEN C_PERIOD_DATES_CUR ;
1439:

Line 1607: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc ;

1603: , x_number_of_pds
1604: , x_period_profile_id;
1605:
1606: IF C_PERIOD_DATES_CUR%NOTFOUND THEN
1607: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc ;
1608: END IF ;
1609:
1610:
1611: IF l_debug_mode = 'Y' THEN

Line 1618: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

1614: pa_debug.reset_err_stack;
1615: END IF ;
1616:
1617: EXCEPTION
1618: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1619:
1620: x_return_status := FND_API.G_RET_STS_ERROR;
1621: l_msg_count := FND_MSG_PUB.count_msg;
1622: -- Close the cursor

Line 1745: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1741: END IF;
1742: x_return_status := FND_API.G_RET_STS_ERROR;
1743: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
1744: ,p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1745: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1746: END IF;
1747:
1748: IF l_debug_mode = 'Y' THEN
1749: pa_debug.g_err_stage := ':Opening Cursor C_OVERLAPPING_CUR ' ;

Line 1777: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

1773: pa_debug.reset_err_stack;
1774: END IF ;
1775:
1776: EXCEPTION
1777: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1778: x_return_status := FND_API.G_RET_STS_ERROR;
1779: l_msg_count := FND_MSG_PUB.count_msg;
1780:
1781: -- Close the cursor

Line 1869: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

1865:
1866: IF l_debug_mode = 'Y' THEN
1867: pa_debug.g_err_stage:= 'Entering GET_ERROR_LOOKUP_CODE';
1868: pa_debug.write(g_module_name,pa_debug.g_err_stage,
1869: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1870:
1871: pa_debug.set_curr_function( p_function => 'GET_ERROR_LOOKUP_CODE',
1872: p_debug_mode => l_debug_mode );
1873:

Line 1877: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

1873:
1874: -- Check for business rules violations
1875: pa_debug.g_err_stage:= 'Validating input parameters';
1876: pa_debug.write(g_module_name,pa_debug.g_err_stage,
1877: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1878: END IF;
1879:
1880: IF l_debug_mode = 'Y' THEN
1881: pa_debug.g_err_stage:= 'p_mc_error_code = '|| p_mc_error_code;

Line 1883: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

1879:
1880: IF l_debug_mode = 'Y' THEN
1881: pa_debug.g_err_stage:= 'p_mc_error_code = '|| p_mc_error_code;
1882: pa_debug.write(g_module_name,pa_debug.g_err_stage,
1883: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
1884: pa_debug.g_err_stage:= 'p_attr_set_cost_rev = '|| p_attr_set_cost_rev;
1885: pa_debug.write(g_module_name,pa_debug.g_err_stage,
1886: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
1887: pa_debug.g_err_stage:= 'p_attr_set_pc_pfc = '|| p_attr_set_pc_pfc;

Line 1886: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

1882: pa_debug.write(g_module_name,pa_debug.g_err_stage,
1883: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
1884: pa_debug.g_err_stage:= 'p_attr_set_cost_rev = '|| p_attr_set_cost_rev;
1885: pa_debug.write(g_module_name,pa_debug.g_err_stage,
1886: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
1887: pa_debug.g_err_stage:= 'p_attr_set_pc_pfc = '|| p_attr_set_pc_pfc;
1888: pa_debug.write(g_module_name,pa_debug.g_err_stage,
1889: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
1890: END IF;

Line 1889: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

1885: pa_debug.write(g_module_name,pa_debug.g_err_stage,
1886: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
1887: pa_debug.g_err_stage:= 'p_attr_set_pc_pfc = '|| p_attr_set_pc_pfc;
1888: pa_debug.write(g_module_name,pa_debug.g_err_stage,
1889: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
1890: END IF;
1891:
1892:
1893: IF (p_mc_error_code IS NULL) OR

Line 1900: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1896: THEN
1897: PA_UTILS.ADD_MESSAGE
1898: (p_app_short_name => 'PA',
1899: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1900: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1901: END IF;
1902:
1903: --Determine the lookup code from the passed values
1904: IF p_mc_error_code = 'PA_FP_RATE_TYPE_REQ' OR p_mc_error_code = 'PA_FP_INVALID_RATE_TYPE' -- Rate type is null.

Line 1906: IF p_attr_set_pc_pfc = PA_FP_CONSTANTS_PKG.G_CURRENCY_TYPE_PROJFUNC

1902:
1903: --Determine the lookup code from the passed values
1904: IF p_mc_error_code = 'PA_FP_RATE_TYPE_REQ' OR p_mc_error_code = 'PA_FP_INVALID_RATE_TYPE' -- Rate type is null.
1905: THEN
1906: IF p_attr_set_pc_pfc = PA_FP_CONSTANTS_PKG.G_CURRENCY_TYPE_PROJFUNC
1907: THEN
1908: IF p_attr_set_cost_rev = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST
1909: THEN
1910: x_error_lookup_code := 'PA_FP_WEBADI_INV_PF_COST_RT';

Line 1908: IF p_attr_set_cost_rev = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST

1904: IF p_mc_error_code = 'PA_FP_RATE_TYPE_REQ' OR p_mc_error_code = 'PA_FP_INVALID_RATE_TYPE' -- Rate type is null.
1905: THEN
1906: IF p_attr_set_pc_pfc = PA_FP_CONSTANTS_PKG.G_CURRENCY_TYPE_PROJFUNC
1907: THEN
1908: IF p_attr_set_cost_rev = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST
1909: THEN
1910: x_error_lookup_code := 'PA_FP_WEBADI_INV_PF_COST_RT';
1911: ELSE
1912: x_error_lookup_code := 'PA_FP_WEBADI_INV_PF_REV_RT'; -- amount is revenue.

Line 1916: IF p_attr_set_cost_rev = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST

1912: x_error_lookup_code := 'PA_FP_WEBADI_INV_PF_REV_RT'; -- amount is revenue.
1913: END IF;
1914:
1915: ELSE
1916: IF p_attr_set_cost_rev = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST
1917: THEN
1918: x_error_lookup_code := 'PA_FP_WEBADI_INV_PR_COST_RT';
1919: ELSE
1920: x_error_lookup_code := 'PA_FP_WEBADI_INV_PR_REV_RT'; -- amount is revenue.

Line 1925: IF p_attr_set_pc_pfc = PA_FP_CONSTANTS_PKG.G_CURRENCY_TYPE_PROJFUNC

1921: END IF;
1922: END IF;
1923: ELSIF p_mc_error_code = 'PA_FP_USER_EXCH_RATE_REQ' -- Rate type is user and Rate is null.
1924: THEN
1925: IF p_attr_set_pc_pfc = PA_FP_CONSTANTS_PKG.G_CURRENCY_TYPE_PROJFUNC
1926: THEN
1927: IF p_attr_set_cost_rev = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST
1928: THEN
1929: x_error_lookup_code := 'PA_FP_WEBADI_INV_PF_COST_RATE';

Line 1927: IF p_attr_set_cost_rev = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST

1923: ELSIF p_mc_error_code = 'PA_FP_USER_EXCH_RATE_REQ' -- Rate type is user and Rate is null.
1924: THEN
1925: IF p_attr_set_pc_pfc = PA_FP_CONSTANTS_PKG.G_CURRENCY_TYPE_PROJFUNC
1926: THEN
1927: IF p_attr_set_cost_rev = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST
1928: THEN
1929: x_error_lookup_code := 'PA_FP_WEBADI_INV_PF_COST_RATE';
1930: ELSE
1931: x_error_lookup_code := 'PA_FP_WEBADI_INV_PF_REV_RATE';

Line 1934: IF p_attr_set_cost_rev = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST

1930: ELSE
1931: x_error_lookup_code := 'PA_FP_WEBADI_INV_PF_REV_RATE';
1932: END IF;
1933: ELSE
1934: IF p_attr_set_cost_rev = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST
1935: THEN
1936: x_error_lookup_code := 'PA_FP_WEBADI_INV_PR_COST_RATE';
1937: ELSE
1938: x_error_lookup_code := 'PA_FP_WEBADI_INV_PR_REV_RATE';

Line 1943: IF p_attr_set_pc_pfc = PA_FP_CONSTANTS_PKG.G_CURRENCY_TYPE_PROJFUNC

1939: END IF;
1940: END IF;
1941: ELSIF p_mc_error_code = 'PA_FP_INVALID_RATE_DATE_TYPE' -- Rate date type is null.
1942: THEN
1943: IF p_attr_set_pc_pfc = PA_FP_CONSTANTS_PKG.G_CURRENCY_TYPE_PROJFUNC
1944: THEN
1945: IF p_attr_set_cost_rev = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST
1946: THEN
1947: x_error_lookup_code := 'PA_FP_WEBADI_INV_PF_COST_RDT';

Line 1945: IF p_attr_set_cost_rev = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST

1941: ELSIF p_mc_error_code = 'PA_FP_INVALID_RATE_DATE_TYPE' -- Rate date type is null.
1942: THEN
1943: IF p_attr_set_pc_pfc = PA_FP_CONSTANTS_PKG.G_CURRENCY_TYPE_PROJFUNC
1944: THEN
1945: IF p_attr_set_cost_rev = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST
1946: THEN
1947: x_error_lookup_code := 'PA_FP_WEBADI_INV_PF_COST_RDT';
1948: ELSE
1949: x_error_lookup_code := 'PA_FP_WEBADI_INV_PF_REV_RDT';

Line 1952: IF p_attr_set_cost_rev = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST

1948: ELSE
1949: x_error_lookup_code := 'PA_FP_WEBADI_INV_PF_REV_RDT';
1950: END IF;
1951: ELSE
1952: IF p_attr_set_cost_rev = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST
1953: THEN
1954: x_error_lookup_code := 'PA_FP_WEBADI_INV_PR_COST_RDT';
1955: ELSE
1956:

Line 1962: IF p_attr_set_pc_pfc = PA_FP_CONSTANTS_PKG.G_CURRENCY_TYPE_PROJFUNC

1958: END IF;
1959: END IF;
1960: ELSIF p_mc_error_code = 'PA_FP_INVALID_RATE_DATE' -- Rate date type is fixed date and rate date is null.
1961: THEN
1962: IF p_attr_set_pc_pfc = PA_FP_CONSTANTS_PKG.G_CURRENCY_TYPE_PROJFUNC
1963: THEN
1964: IF p_attr_set_cost_rev = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST
1965: THEN
1966: x_error_lookup_code := 'PA_FP_WEBADI_INV_PF_COST_RD';

Line 1964: IF p_attr_set_cost_rev = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST

1960: ELSIF p_mc_error_code = 'PA_FP_INVALID_RATE_DATE' -- Rate date type is fixed date and rate date is null.
1961: THEN
1962: IF p_attr_set_pc_pfc = PA_FP_CONSTANTS_PKG.G_CURRENCY_TYPE_PROJFUNC
1963: THEN
1964: IF p_attr_set_cost_rev = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST
1965: THEN
1966: x_error_lookup_code := 'PA_FP_WEBADI_INV_PF_COST_RD';
1967: ELSE
1968: x_error_lookup_code := 'PA_FP_WEBADI_INV_PF_REV_RD';

Line 1971: IF p_attr_set_cost_rev = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST

1967: ELSE
1968: x_error_lookup_code := 'PA_FP_WEBADI_INV_PF_REV_RD';
1969: END IF;
1970: ELSE
1971: IF p_attr_set_cost_rev = PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST
1972: THEN
1973: x_error_lookup_code := 'PA_FP_WEBADI_INV_PF_COST_RD';
1974: ELSE
1975: x_error_lookup_code := 'PA_FP_WEBADI_INV_PF_REV_RD';

Line 1982: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

1978: ELSE -- The parameters have invalid values.
1979: IF l_debug_mode = 'Y' THEN
1980: pa_debug.g_err_stage:= 'Error in input parameters';
1981: pa_debug.write(g_module_name,pa_debug.g_err_stage,
1982: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
1983: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1984: END IF;
1985: END IF;
1986:

Line 1983: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1979: IF l_debug_mode = 'Y' THEN
1980: pa_debug.g_err_stage:= 'Error in input parameters';
1981: pa_debug.write(g_module_name,pa_debug.g_err_stage,
1982: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
1983: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1984: END IF;
1985: END IF;
1986:
1987: IF l_debug_mode = 'Y' THEN

Line 1990: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

1986:
1987: IF l_debug_mode = 'Y' THEN
1988: pa_debug.g_err_stage:= 'x_error_lookup_code = '||x_error_lookup_code;
1989: pa_debug.write(g_module_name,pa_debug.g_err_stage,
1990: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
1991: END IF;
1992:
1993: IF l_debug_mode = 'Y' THEN
1994: pa_debug.g_err_stage:= 'Exiting get_error_lookup_code';

Line 1996: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

1992:
1993: IF l_debug_mode = 'Y' THEN
1994: pa_debug.g_err_stage:= 'Exiting get_error_lookup_code';
1995: pa_debug.write(g_module_name,pa_debug.g_err_stage,
1996: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1997: pa_debug.reset_curr_function;
1998: END IF;
1999: EXCEPTION
2000:

Line 2001: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

1997: pa_debug.reset_curr_function;
1998: END IF;
1999: EXCEPTION
2000:
2001: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2002:
2003: x_return_status := FND_API.G_RET_STS_ERROR;
2004: l_msg_count := FND_MSG_PUB.count_msg;
2005:

Line 2038: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

2034:
2035: IF l_debug_mode = 'Y' THEN
2036: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
2037: pa_debug.write(g_module_name,pa_debug.g_err_stage,
2038: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2039: END IF;
2040: IF l_debug_mode = 'Y' THEN
2041: pa_debug.reset_curr_function;
2042: END IF;

Line 2117: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2113:
2114: -- Check for business rules violations
2115: pa_debug.g_err_stage:= 'No Validation of input parameters is done in this API';
2116: pa_debug.write(g_module_name,pa_debug.g_err_stage,
2117: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2118:
2119: pa_debug.g_err_stage:= 'Printing the input parameters.';
2120: pa_debug.write(g_module_name,pa_debug.g_err_stage,
2121: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 2121: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2117: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2118:
2119: pa_debug.g_err_stage:= 'Printing the input parameters.';
2120: pa_debug.write(g_module_name,pa_debug.g_err_stage,
2121: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2122:
2123: pa_debug.g_err_stage:= 'p_pc_cost_rate_type_name : '||p_pc_cost_rate_type_name||
2124: ' p_pc_cost_rate_date_type_name : '||p_pc_cost_rate_date_type_name;
2125: pa_debug.write(g_module_name,pa_debug.g_err_stage,

Line 2126: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2122:
2123: pa_debug.g_err_stage:= 'p_pc_cost_rate_type_name : '||p_pc_cost_rate_type_name||
2124: ' p_pc_cost_rate_date_type_name : '||p_pc_cost_rate_date_type_name;
2125: pa_debug.write(g_module_name,pa_debug.g_err_stage,
2126: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2127:
2128: pa_debug.g_err_stage:= 'p_pfc_cost_rate_type_name : '||p_pfc_cost_rate_type_name||
2129: ' p_pfc_cost_rate_date_type_name : '||p_pfc_cost_rate_date_type_name ;
2130: pa_debug.write(g_module_name,pa_debug.g_err_stage,

Line 2131: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2127:
2128: pa_debug.g_err_stage:= 'p_pfc_cost_rate_type_name : '||p_pfc_cost_rate_type_name||
2129: ' p_pfc_cost_rate_date_type_name : '||p_pfc_cost_rate_date_type_name ;
2130: pa_debug.write(g_module_name,pa_debug.g_err_stage,
2131: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2132:
2133: pa_debug.g_err_stage:= 'p_pc_rev_rate_type_name : '||p_pc_rev_rate_type_name||
2134: ' p_pc_rev_rate_date_type_name : '||p_pc_rev_rate_date_type_name;
2135: pa_debug.write(g_module_name,pa_debug.g_err_stage,

Line 2136: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2132:
2133: pa_debug.g_err_stage:= 'p_pc_rev_rate_type_name : '||p_pc_rev_rate_type_name||
2134: ' p_pc_rev_rate_date_type_name : '||p_pc_rev_rate_date_type_name;
2135: pa_debug.write(g_module_name,pa_debug.g_err_stage,
2136: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2137:
2138: pa_debug.g_err_stage:= 'p_pfc_rev_rate_type_name : '||p_pfc_rev_rate_type_name||
2139: ' p_pfc_rev_rate_date_type_name : '||p_pfc_rev_rate_date_type_name ;
2140: pa_debug.write(g_module_name,pa_debug.g_err_stage,

Line 2141: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2137:
2138: pa_debug.g_err_stage:= 'p_pfc_rev_rate_type_name : '||p_pfc_rev_rate_type_name||
2139: ' p_pfc_rev_rate_date_type_name : '||p_pfc_rev_rate_date_type_name ;
2140: pa_debug.write(g_module_name,pa_debug.g_err_stage,
2141: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2142: END IF;
2143:
2144: FOR rate_type_rec IN rate_type_cur LOOP
2145: IF rate_type_rec.user_conversion_type = p_pc_cost_rate_type_name THEN

Line 2206: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

2202: END IF;
2203:
2204: EXCEPTION
2205:
2206: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2207:
2208: x_return_status := FND_API.G_RET_STS_ERROR;
2209: l_msg_count := FND_MSG_PUB.count_msg;
2210:

Line 2244: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

2240:
2241: IF l_debug_mode = 'Y' THEN
2242: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
2243: pa_debug.write(g_module_name,pa_debug.g_err_stage,
2244: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2245: END IF;
2246: IF l_debug_mode = 'Y' THEN
2247: pa_debug.reset_curr_function;
2248: END IF;

Line 2326: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2322: END IF;
2323: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2324: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
2325:
2326: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2327: END IF;
2328:
2329: SELECT integrator_code
2330: INTO l_integrator_code

Line 2363: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

2359: pa_debug.reset_curr_function();
2360:
2361: EXCEPTION
2362:
2363: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2364: l_msg_count := FND_MSG_PUB.count_msg;
2365: IF l_msg_count = 1 THEN
2366: PA_INTERFACE_UTILS_PUB.get_messages
2367: (p_encoded => FND_API.G_TRUE

Line 2457: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2453: (p_app_short_name => 'PA',
2454: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
2455: p_token1 => 'PROCEDURENAME',
2456: p_value1 => l_module_name);
2457: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2458: END IF;
2459:
2460: IF l_debug_mode = 'Y' THEN
2461: pa_debug.g_err_stage:='Getting run_id and budget_version_id';

Line 2484: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2480: (p_app_short_name => 'PA',
2481: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
2482: p_token1 => 'PROCEDURENAME',
2483: p_value1 => l_module_name);
2484: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2485: END;
2486:
2487: IF l_debug_mode = 'Y' THEN
2488: pa_debug.g_err_stage:='Calling PA_FP_WEBADI_PKG.delete_xface';

Line 2503: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2499: IF l_debug_mode = 'Y' THEN
2500: pa_debug.g_err_stage := 'Call to PA_FP_WEBADI_PKG.delete_xface returned with error';
2501: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
2502: END IF;
2503: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2504: END IF;
2505:
2506: IF l_debug_mode = 'Y' THEN
2507: pa_debug.g_err_stage:='PA_FP_WEBADI_PKG.delete_xface Called';

Line 2529: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

2525: END IF;
2526: pa_debug.reset_curr_function;
2527:
2528: EXCEPTION
2529: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2530: l_msg_count := FND_MSG_PUB.count_msg;
2531: IF l_msg_count = 1 THEN
2532: PA_INTERFACE_UTILS_PUB.get_messages
2533: (p_encoded => FND_API.G_TRUE

Line 2603: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2599: (p_app_short_name => 'PA',
2600: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
2601: p_token1 => 'PROCEDURENAME',
2602: p_value1 => l_module_name);
2603: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2604: END IF;
2605:
2606: IF l_debug_mode = 'Y' THEN
2607: pa_debug.g_err_stage:='Getting run_id and budget_version_id';

Line 2630: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2626: (p_app_short_name => 'PA',
2627: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
2628: p_token1 => 'PROCEDURENAME',
2629: p_value1 => l_module_name);
2630: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2631: END;
2632:
2633: IF l_debug_mode = 'Y' THEN
2634: pa_debug.g_err_stage:='Resubmitting the concurrent request';

Line 2714: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

2710: END IF;
2711: pa_debug.reset_curr_function;
2712:
2713: EXCEPTION
2714: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2715: l_msg_count := FND_MSG_PUB.count_msg;
2716: IF l_msg_count = 1 THEN
2717: PA_INTERFACE_UTILS_PUB.get_messages
2718: (p_encoded => FND_API.G_TRUE