eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RES_ASG_CURRENCY_PUB dependencies on FND_API

Line 174: x_return_status := FND_API.G_RET_STS_SUCCESS;

170: P_ROLLUP_FLAG => p_rollup_flag,
171: P_VERSION_LEVEL_FLAG => p_version_level_flag,
172: P_CALLED_MODE => p_called_mode );
173:
174: x_return_status := FND_API.G_RET_STS_SUCCESS;
175: x_msg_count := 0;
176:
177: -- Step 0: Validate Input Parameters
178:

Line 308: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

304: 'DELETE_TABLE_RECORDS: '||x_return_status,
305: P_CALLED_MODE => p_called_mode,
306: P_MODULE_NAME => l_module_name);
307: END IF;
308: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
309: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
310: END IF;
311:
312: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 472: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

468: 'COPY_TABLE_RECORDS: '||x_return_status,
469: P_CALLED_MODE => p_called_mode,
470: P_MODULE_NAME => l_module_name);
471: END IF;
472: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
473: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
474: END IF;
475:
476: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 510: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

506: 'INSERT_TABLE_RECORDS: '||x_return_status,
507: P_CALLED_MODE => p_called_mode,
508: P_MODULE_NAME => l_module_name);
509: END IF;
510: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
511: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
512: END IF;
513:
514: -- Step 4: Handle Rollup of Amounts

Line 540: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

536: 'ROLLUP_AMOUNTS: '||x_return_status,
537: P_CALLED_MODE => p_called_mode,
538: P_MODULE_NAME => l_module_name);
539: END IF;
540: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
541: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
542: END IF;
543:
544: END IF; -- p_rollup_flag = 'Y'

Line 557: ( p_encoded => FND_API.G_TRUE,

553:
554: l_msg_count := FND_MSG_PUB.count_msg;
555: IF l_msg_count = 1 THEN
556: PA_INTERFACE_UTILS_PUB.get_messages
557: ( p_encoded => FND_API.G_TRUE,
558: p_msg_index => 1,
559: p_msg_count => l_msg_count,
560: p_msg_data => l_msg_data,
561: p_data => l_data,

Line 571: x_return_status := FND_API.G_RET_STS_ERROR;

567: END IF;
568:
569: -- Removed ROLLBACK statement.
570:
571: x_return_status := FND_API.G_RET_STS_ERROR;
572:
573: IF P_PA_DEBUG_MODE = 'Y' THEN
574: pa_fp_gen_amount_utils.fp_debug
575: ( p_msg => 'Invalid Arguments Passed',

Line 586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

582: -- Removed RAISE statement.
583:
584: WHEN OTHERS THEN
585: -- Removed ROLLBACK statement.
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
587: x_msg_count := 1;
588: x_msg_data := substr(sqlerrm,1,240);
589: -- dbms_output.put_line('error msg :'||x_msg_data);
590: FND_MSG_PUB.add_exc_msg

Line 602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

598: p_module_name => l_module_name,
599: p_log_level => l_log_level);
600: PA_DEBUG.RESET_CURR_FUNCTION;
601: END IF;
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603:
604: END MAINTAIN_DATA;
605:
606:

Line 788: x_return_status := FND_API.G_RET_STS_SUCCESS;

784: P_CALLING_MODULE => p_calling_module,
785: P_VERSION_LEVEL_FLAG => p_version_level_flag,
786: P_CALLED_MODE => p_called_mode );
787:
788: x_return_status := FND_API.G_RET_STS_SUCCESS;
789: x_msg_count := 0;
790:
791: IF p_version_level_flag = 'Y' THEN
792:

Line 854: ( p_encoded => FND_API.G_TRUE,

850:
851: l_msg_count := FND_MSG_PUB.count_msg;
852: IF l_msg_count = 1 THEN
853: PA_INTERFACE_UTILS_PUB.get_messages
854: ( p_encoded => FND_API.G_TRUE,
855: p_msg_index => 1,
856: p_msg_count => l_msg_count,
857: p_msg_data => l_msg_data,
858: p_data => l_data,

Line 868: x_return_status := FND_API.G_RET_STS_ERROR;

864: END IF;
865:
866: -- Removed ROLLBACK statement.
867:
868: x_return_status := FND_API.G_RET_STS_ERROR;
869:
870: IF P_PA_DEBUG_MODE = 'Y' THEN
871: pa_fp_gen_amount_utils.fp_debug
872: ( p_msg => 'Invalid Arguments Passed',

Line 882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

878: -- Removed RAISE statement.
879:
880: WHEN OTHERS THEN
881: -- Removed ROLLBACK statement.
882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
883: x_msg_count := 1;
884: x_msg_data := substr(sqlerrm,1,240);
885: -- dbms_output.put_line('error msg :'||x_msg_data);
886: FND_MSG_PUB.add_exc_msg

Line 898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

894: p_module_name => l_module_name,
895: p_log_level => l_log_level);
896: PA_DEBUG.RESET_CURR_FUNCTION;
897: END IF;
898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
899:
900: END DELETE_TABLE_RECORDS;
901:
902:

Line 1086: x_return_status := FND_API.G_RET_STS_SUCCESS;

1082: P_COPY_MODE => p_copy_mode,
1083: P_VERSION_LEVEL_FLAG => p_version_level_flag,
1084: P_CALLED_MODE => p_called_mode );
1085:
1086: x_return_status := FND_API.G_RET_STS_SUCCESS;
1087: x_msg_count := 0;
1088:
1089: BEGIN
1090: SELECT nvl(wp_version_flag,'N')

Line 1322: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1318: P_CALLED_MODE => p_called_mode,
1319: P_MODULE_NAME => l_module_name,
1320: P_LOG_LEVEL => l_log_level );
1321: END IF;
1322: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1323: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1324: END IF;
1325:
1326: -- Step 4: Insert records into the PA_RESOURCE_ASGN_CURR table.

Line 1455: ( p_encoded => FND_API.G_TRUE,

1451:
1452: l_msg_count := FND_MSG_PUB.count_msg;
1453: IF l_msg_count = 1 THEN
1454: PA_INTERFACE_UTILS_PUB.get_messages
1455: ( p_encoded => FND_API.G_TRUE,
1456: p_msg_index => 1,
1457: p_msg_count => l_msg_count,
1458: p_msg_data => l_msg_data,
1459: p_data => l_data,

Line 1469: x_return_status := FND_API.G_RET_STS_ERROR;

1465: END IF;
1466:
1467: -- Removed ROLLBACK statement.
1468:
1469: x_return_status := FND_API.G_RET_STS_ERROR;
1470:
1471: IF P_PA_DEBUG_MODE = 'Y' THEN
1472: pa_fp_gen_amount_utils.fp_debug
1473: ( p_msg => 'Invalid Arguments Passed',

Line 1483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1479: -- Removed RAISE statement.
1480:
1481: WHEN OTHERS THEN
1482: -- Removed ROLLBACK statement.
1483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1484: x_msg_count := 1;
1485: x_msg_data := substr(sqlerrm,1,240);
1486: -- dbms_output.put_line('error msg :'||x_msg_data);
1487: FND_MSG_PUB.add_exc_msg

Line 1499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1495: p_module_name => l_module_name,
1496: p_log_level => l_log_level);
1497: PA_DEBUG.RESET_CURR_FUNCTION;
1498: END IF;
1499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1500:
1501: END COPY_TABLE_RECORDS;
1502:
1503:

Line 1547: x_return_status := FND_API.G_RET_STS_SUCCESS;

1543: P_CALLING_MODULE => p_calling_module,
1544: P_VERSION_LEVEL_FLAG => p_version_level_flag,
1545: P_CALLED_MODE => p_called_mode );
1546:
1547: x_return_status := FND_API.G_RET_STS_SUCCESS;
1548: x_msg_count := 0;
1549:
1550:
1551: IF p_version_level_flag = 'Y' THEN

Line 1632: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1628: P_CALLED_MODE => p_called_mode,
1629: P_MODULE_NAME => l_module_name,
1630: P_LOG_LEVEL => l_log_level );
1631: END IF;
1632: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1633: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1634: END IF;
1635:
1636: INSERT INTO pa_resource_asgn_curr

Line 1680: ( p_encoded => FND_API.G_TRUE,

1676:
1677: l_msg_count := FND_MSG_PUB.count_msg;
1678: IF l_msg_count = 1 THEN
1679: PA_INTERFACE_UTILS_PUB.get_messages
1680: ( p_encoded => FND_API.G_TRUE,
1681: p_msg_index => 1,
1682: p_msg_count => l_msg_count,
1683: p_msg_data => l_msg_data,
1684: p_data => l_data,

Line 1694: x_return_status := FND_API.G_RET_STS_ERROR;

1690: END IF;
1691:
1692: -- Removed ROLLBACK statement.
1693:
1694: x_return_status := FND_API.G_RET_STS_ERROR;
1695:
1696: IF P_PA_DEBUG_MODE = 'Y' THEN
1697: pa_fp_gen_amount_utils.fp_debug
1698: ( p_msg => 'Invalid Arguments Passed',

Line 1708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1704: -- Removed RAISE statement.
1705:
1706: WHEN OTHERS THEN
1707: -- Removed ROLLBACK statement.
1708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1709: x_msg_count := 1;
1710: x_msg_data := substr(sqlerrm,1,240);
1711: -- dbms_output.put_line('error msg :'||x_msg_data);
1712: FND_MSG_PUB.add_exc_msg

Line 1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1720: p_module_name => l_module_name,
1721: p_log_level => l_log_level);
1722: PA_DEBUG.RESET_CURR_FUNCTION;
1723: END IF;
1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1725:
1726: END INSERT_TABLE_RECORDS;
1727:
1728:

Line 2099: x_return_status := FND_API.G_RET_STS_SUCCESS;

2095: P_CALLING_MODULE => p_calling_module,
2096: P_VERSION_LEVEL_FLAG => p_version_level_flag,
2097: P_CALLED_MODE => p_called_mode );
2098:
2099: x_return_status := FND_API.G_RET_STS_SUCCESS;
2100: x_msg_count := 0;
2101:
2102: BEGIN
2103: SELECT nvl(wp_version_flag,'N')

Line 2304: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2300: P_CALLED_MODE => p_called_mode,
2301: P_MODULE_NAME => l_module_name,
2302: P_LOG_LEVEL => l_log_level );
2303: END IF;
2304: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2305: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2306: END IF;
2307:
2308: -- Step 4: Insert records into the PA_RESOURCE_ASGN_CURR table.

Line 2480: ( p_encoded => FND_API.G_TRUE,

2476:
2477: l_msg_count := FND_MSG_PUB.count_msg;
2478: IF l_msg_count = 1 THEN
2479: PA_INTERFACE_UTILS_PUB.get_messages
2480: ( p_encoded => FND_API.G_TRUE,
2481: p_msg_index => 1,
2482: p_msg_count => l_msg_count,
2483: p_msg_data => l_msg_data,
2484: p_data => l_data,

Line 2494: x_return_status := FND_API.G_RET_STS_ERROR;

2490: END IF;
2491:
2492: -- Removed ROLLBACK statement.
2493:
2494: x_return_status := FND_API.G_RET_STS_ERROR;
2495:
2496: IF P_PA_DEBUG_MODE = 'Y' THEN
2497: pa_fp_gen_amount_utils.fp_debug
2498: ( p_msg => 'Invalid Arguments Passed',

Line 2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2504: -- Removed RAISE statement.
2505:
2506: WHEN OTHERS THEN
2507: -- Removed ROLLBACK statement.
2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2509: x_msg_count := 1;
2510: x_msg_data := substr(sqlerrm,1,240);
2511: -- dbms_output.put_line('error msg :'||x_msg_data);
2512: FND_MSG_PUB.add_exc_msg

Line 2524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2520: p_module_name => l_module_name,
2521: p_log_level => l_log_level);
2522: PA_DEBUG.RESET_CURR_FUNCTION;
2523: END IF;
2524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2525:
2526: END ROLLUP_AMOUNTS;
2527:
2528: