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 309: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 473: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 511: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

507: 'INSERT_TABLE_RECORDS: '||x_return_status,
508: P_CALLED_MODE => p_called_mode,
509: P_MODULE_NAME => l_module_name);
510: END IF;
511: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
512: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
513: END IF;
514:
515: -- 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 845: ( p_encoded => FND_API.G_TRUE,

841:
842: l_msg_count := FND_MSG_PUB.count_msg;
843: IF l_msg_count = 1 THEN
844: PA_INTERFACE_UTILS_PUB.get_messages
845: ( p_encoded => FND_API.G_TRUE,
846: p_msg_index => 1,
847: p_msg_count => l_msg_count,
848: p_msg_data => l_msg_data,
849: p_data => l_data,

Line 859: x_return_status := FND_API.G_RET_STS_ERROR;

855: END IF;
856:
857: -- Removed ROLLBACK statement.
858:
859: x_return_status := FND_API.G_RET_STS_ERROR;
860:
861: IF P_PA_DEBUG_MODE = 'Y' THEN
862: pa_fp_gen_amount_utils.fp_debug
863: ( p_msg => 'Invalid Arguments Passed',

Line 873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

869: -- Removed RAISE statement.
870:
871: WHEN OTHERS THEN
872: -- Removed ROLLBACK statement.
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: x_msg_count := 1;
875: x_msg_data := substr(sqlerrm,1,240);
876: -- dbms_output.put_line('error msg :'||x_msg_data);
877: FND_MSG_PUB.add_exc_msg

Line 889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

885: p_module_name => l_module_name,
886: p_log_level => l_log_level);
887: PA_DEBUG.RESET_CURR_FUNCTION;
888: END IF;
889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
890:
891: END DELETE_TABLE_RECORDS;
892:
893:

Line 1074: x_return_status := FND_API.G_RET_STS_SUCCESS;

1070: P_COPY_MODE => p_copy_mode,
1071: P_VERSION_LEVEL_FLAG => p_version_level_flag,
1072: P_CALLED_MODE => p_called_mode );
1073:
1074: x_return_status := FND_API.G_RET_STS_SUCCESS;
1075: x_msg_count := 0;
1076:
1077: BEGIN
1078: SELECT nvl(wp_version_flag,'N')

Line 1310: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1306: P_CALLED_MODE => p_called_mode,
1307: P_MODULE_NAME => l_module_name,
1308: P_LOG_LEVEL => l_log_level );
1309: END IF;
1310: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1311: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1312: END IF;
1313:
1314: -- Step 4: Insert records into the PA_RESOURCE_ASGN_CURR table.

Line 1443: ( p_encoded => FND_API.G_TRUE,

1439:
1440: l_msg_count := FND_MSG_PUB.count_msg;
1441: IF l_msg_count = 1 THEN
1442: PA_INTERFACE_UTILS_PUB.get_messages
1443: ( p_encoded => FND_API.G_TRUE,
1444: p_msg_index => 1,
1445: p_msg_count => l_msg_count,
1446: p_msg_data => l_msg_data,
1447: p_data => l_data,

Line 1457: x_return_status := FND_API.G_RET_STS_ERROR;

1453: END IF;
1454:
1455: -- Removed ROLLBACK statement.
1456:
1457: x_return_status := FND_API.G_RET_STS_ERROR;
1458:
1459: IF P_PA_DEBUG_MODE = 'Y' THEN
1460: pa_fp_gen_amount_utils.fp_debug
1461: ( p_msg => 'Invalid Arguments Passed',

Line 1471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1467: -- Removed RAISE statement.
1468:
1469: WHEN OTHERS THEN
1470: -- Removed ROLLBACK statement.
1471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1472: x_msg_count := 1;
1473: x_msg_data := substr(sqlerrm,1,240);
1474: -- dbms_output.put_line('error msg :'||x_msg_data);
1475: FND_MSG_PUB.add_exc_msg

Line 1487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1483: p_module_name => l_module_name,
1484: p_log_level => l_log_level);
1485: PA_DEBUG.RESET_CURR_FUNCTION;
1486: END IF;
1487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1488:
1489: END COPY_TABLE_RECORDS;
1490:
1491:

Line 1535: x_return_status := FND_API.G_RET_STS_SUCCESS;

1531: P_CALLING_MODULE => p_calling_module,
1532: P_VERSION_LEVEL_FLAG => p_version_level_flag,
1533: P_CALLED_MODE => p_called_mode );
1534:
1535: x_return_status := FND_API.G_RET_STS_SUCCESS;
1536: x_msg_count := 0;
1537:
1538:
1539: IF p_version_level_flag = 'Y' THEN

Line 1620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1616: P_CALLED_MODE => p_called_mode,
1617: P_MODULE_NAME => l_module_name,
1618: P_LOG_LEVEL => l_log_level );
1619: END IF;
1620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1621: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1622: END IF;
1623:
1624: INSERT INTO pa_resource_asgn_curr

Line 1666: ( p_encoded => FND_API.G_TRUE,

1662:
1663: l_msg_count := FND_MSG_PUB.count_msg;
1664: IF l_msg_count = 1 THEN
1665: PA_INTERFACE_UTILS_PUB.get_messages
1666: ( p_encoded => FND_API.G_TRUE,
1667: p_msg_index => 1,
1668: p_msg_count => l_msg_count,
1669: p_msg_data => l_msg_data,
1670: p_data => l_data,

Line 1680: x_return_status := FND_API.G_RET_STS_ERROR;

1676: END IF;
1677:
1678: -- Removed ROLLBACK statement.
1679:
1680: x_return_status := FND_API.G_RET_STS_ERROR;
1681:
1682: IF P_PA_DEBUG_MODE = 'Y' THEN
1683: pa_fp_gen_amount_utils.fp_debug
1684: ( p_msg => 'Invalid Arguments Passed',

Line 1694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1690: -- Removed RAISE statement.
1691:
1692: WHEN OTHERS THEN
1693: -- Removed ROLLBACK statement.
1694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1695: x_msg_count := 1;
1696: x_msg_data := substr(sqlerrm,1,240);
1697: -- dbms_output.put_line('error msg :'||x_msg_data);
1698: FND_MSG_PUB.add_exc_msg

Line 1710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1706: p_module_name => l_module_name,
1707: p_log_level => l_log_level);
1708: PA_DEBUG.RESET_CURR_FUNCTION;
1709: END IF;
1710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1711:
1712: END INSERT_TABLE_RECORDS;
1713:
1714:

Line 2074: x_return_status := FND_API.G_RET_STS_SUCCESS;

2070: P_CALLING_MODULE => p_calling_module,
2071: P_VERSION_LEVEL_FLAG => p_version_level_flag,
2072: P_CALLED_MODE => p_called_mode );
2073:
2074: x_return_status := FND_API.G_RET_STS_SUCCESS;
2075: x_msg_count := 0;
2076:
2077: BEGIN
2078: SELECT nvl(wp_version_flag,'N')

Line 2277: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2273: P_CALLED_MODE => p_called_mode,
2274: P_MODULE_NAME => l_module_name,
2275: P_LOG_LEVEL => l_log_level );
2276: END IF;
2277: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2278: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2279: END IF;
2280:
2281: -- Step 4: Insert records into the PA_RESOURCE_ASGN_CURR table.

Line 2376: ( p_encoded => FND_API.G_TRUE,

2372:
2373: l_msg_count := FND_MSG_PUB.count_msg;
2374: IF l_msg_count = 1 THEN
2375: PA_INTERFACE_UTILS_PUB.get_messages
2376: ( p_encoded => FND_API.G_TRUE,
2377: p_msg_index => 1,
2378: p_msg_count => l_msg_count,
2379: p_msg_data => l_msg_data,
2380: p_data => l_data,

Line 2390: x_return_status := FND_API.G_RET_STS_ERROR;

2386: END IF;
2387:
2388: -- Removed ROLLBACK statement.
2389:
2390: x_return_status := FND_API.G_RET_STS_ERROR;
2391:
2392: IF P_PA_DEBUG_MODE = 'Y' THEN
2393: pa_fp_gen_amount_utils.fp_debug
2394: ( p_msg => 'Invalid Arguments Passed',

Line 2404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2400: -- Removed RAISE statement.
2401:
2402: WHEN OTHERS THEN
2403: -- Removed ROLLBACK statement.
2404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2405: x_msg_count := 1;
2406: x_msg_data := substr(sqlerrm,1,240);
2407: -- dbms_output.put_line('error msg :'||x_msg_data);
2408: FND_MSG_PUB.add_exc_msg

Line 2420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2416: p_module_name => l_module_name,
2417: p_log_level => l_log_level);
2418: PA_DEBUG.RESET_CURR_FUNCTION;
2419: END IF;
2420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2421:
2422: END ROLLUP_AMOUNTS;
2423:
2424: