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_RETENTION_UTIL dependencies on FND_MSG_PUB

Line 436: FND_MSG_PUB.add_Exc_msg(

432: WHEN others THEN
433: x_msg_count := 1;
434: x_msg_data := SUBSTR(SQLERRM, 1, 240);
435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
436: FND_MSG_PUB.add_Exc_msg(
437: p_pkg_name => 'PA_RETENTION_UTIL',
438: p_procedure_name => 'copy_retention_setup');
439:
440: RAISE ;

Line 555: FND_MSG_PUB.add_Exc_msg(

551: WHEN others THEN
552: x_msg_count := 1;
553: x_msg_data := SUBSTR(SQLERRM, 1, 240);
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: FND_MSG_PUB.add_Exc_msg(
556: p_pkg_name => 'PA_RETENTION_UTIL',
557: p_procedure_name => 'copy_retention_setup');
558:
559:

Line 613: FND_MSG_PUB.add_Exc_msg(

609: WHEN others THEN
610: x_msg_count := 1;
611: x_msg_data := SUBSTR(SQLERRM, 1, 240);
612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
613: FND_MSG_PUB.add_Exc_msg(
614: p_pkg_name => 'PA_RETENTION_UTIL',
615: p_procedure_name => 'delete_retn_rules_customer');
616:
617:

Line 682: FND_MSG_PUB.add_Exc_msg(

678: WHEN others THEN
679: x_msg_count := 1;
680: x_msg_data := SUBSTR(SQLERRM, 1, 240);
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682: FND_MSG_PUB.add_Exc_msg(
683: p_pkg_name => 'PA_RETENTION_UTIL',
684: p_procedure_name => 'delete_retention_rules');
685:
686: END delete_retention_rules;

Line 940: FND_MSG_PUB.add_Exc_msg(

936: WHEN others THEN
937: x_msg_count := 1;
938: x_msg_data := SUBSTR(SQLERRM, 1, 240);
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
940: FND_MSG_PUB.add_Exc_msg(
941: p_pkg_name => 'PA_RETENTION_UTIL',
942: p_procedure_name => 'insert_retention_rules');
943:
944: END insert_retention_rules;

Line 1032: FND_MSG_PUB.add_Exc_msg(

1028: /*
1029: x_msg_count := 1;
1030: x_msg_data := 'PA_NO_FUNDING_EXISTS';
1031: x_return_status := FND_API.G_RET_STS_ERROR;
1032: FND_MSG_PUB.add_Exc_msg(
1033: p_pkg_name => 'PA_MULTI_CURRENCY_BILLING',
1034: p_procedure_name => 'get_project_defaults');
1035:
1036: RAISE ;

Line 1057: FND_MSG_PUB.add_Exc_msg(

1053: x_invproc_currency_code := NULL; -- NOCOPY
1054: x_msg_count := 1;
1055: x_msg_data := SUBSTR(SQLERRM, 1, 240);
1056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1057: FND_MSG_PUB.add_Exc_msg(
1058: p_pkg_name => 'PA_RETENTION_UTILS',
1059: p_procedure_name => 'get_currency_code');
1060:
1061: RAISE ;

Line 1131: FND_MSG_PUB.add_Exc_msg(

1127: x_msg_count := 1;
1128: x_msg_data := SUBSTR(SQLERRM, 1, 240);
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1130:
1131: FND_MSG_PUB.add_Exc_msg(
1132: p_pkg_name => 'PA_RETENTION_UTIL',
1133: p_procedure_name => 'get_corresponding_task');
1134:
1135: RAISE ;

Line 1226: FND_MSG_PUB.add_Exc_msg(

1222: /*
1223: x_msg_count := 1;
1224: x_msg_data := 'PA_NO_FUNDING_EXISTS';
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: FND_MSG_PUB.add_Exc_msg(
1227: p_pkg_name => 'PA_MULTI_CURRENCY_BILLING',
1228: p_procedure_name => 'get_project_defaults');
1229:
1230: RAISE ;

Line 1253: FND_MSG_PUB.add_Exc_msg(

1249: x_msg_count := 1;
1250: x_msg_data := SUBSTR(SQLERRM, 1, 240);
1251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1252:
1253: FND_MSG_PUB.add_Exc_msg(
1254: p_pkg_name => 'PA_RETENTION_UTILS',
1255: p_procedure_name => 'get_project_info');
1256:
1257: RAISE ;

Line 1343: FND_MSG_PUB.add_Exc_msg(

1339: x_delta := NULL; --NOCOPY
1340: x_msg_count := 1;
1341: x_msg_data := SUBSTR(SQLERRM, 1, 240);
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1343: FND_MSG_PUB.add_Exc_msg(
1344: p_pkg_name => 'PA_RETENTION_UTIL',
1345: p_procedure_name => 'calculate_date_factor');
1346:
1347:

Line 1498: FND_MSG_PUB.add_Exc_msg(

1494: WHEN l_record_modified THEN
1495: x_msg_count := 1;
1496: x_msg_data := 'PA_XC_RECORD_CHANGED';
1497: x_return_status := FND_API.G_RET_STS_ERROR;
1498: FND_MSG_PUB.add_Exc_msg(
1499: p_pkg_name => 'PA_RETENTION_UTIL',
1500: p_procedure_name => 'set_rec_version_num');
1501:
1502: END set_rec_version_num;

Line 1554: FND_MSG_PUB.initialize;

1550: x_msg_count := 0;
1551:
1552: --Clear the global PL/SQL message table
1553: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN
1554: FND_MSG_PUB.initialize;
1555: END IF;
1556:
1557:
1558: /* -------------------------------------------------------------

Line 1756: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',

1752: WHEN l_retn_billing_cycle THEN
1753: x_return_status := FND_API.G_RET_STS_ERROR;
1754: x_msg_count := 1;
1755: x_msg_data := 'PA_RETN_BILL_CYCLE_NULL';
1756: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',
1757: p_procedure_name => 'retn_billing_method_single');
1758: WHEN l_tot_retn_amount THEN
1759: x_return_status := FND_API.G_RET_STS_ERROR;
1760: x_msg_count := 1;

Line 1762: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',

1758: WHEN l_tot_retn_amount THEN
1759: x_return_status := FND_API.G_RET_STS_ERROR;
1760: x_msg_count := 1;
1761: x_msg_data := 'PA_RETN_BILL_TOT_AMT_NULL';
1762: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',
1763: p_procedure_name => 'retn_billing_method_single');
1764:
1765: WHEN l_bill_per_either_amount THEN
1766: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1769: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',

1765: WHEN l_bill_per_either_amount THEN
1766: x_return_status := FND_API.G_RET_STS_ERROR;
1767: x_msg_count := 1;
1768: x_msg_data := 'PA_RETN_PERC_AMNT_EXIST';
1769: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',
1770: p_procedure_name => 'retn_billing_method_single');
1771:
1772: WHEN l_bill_per_either_amount_null THEN
1773: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1776: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',

1772: WHEN l_bill_per_either_amount_null THEN
1773: x_return_status := FND_API.G_RET_STS_ERROR;
1774: x_msg_count := 1;
1775: x_msg_data := 'PA_RETN_PERC_AMNT_NO_EXIST';
1776: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',
1777: p_procedure_name => 'retn_billing_method_single');
1778: WHEN l_neg_not_allowed THEN
1779: x_return_status := FND_API.G_RET_STS_ERROR;
1780: x_msg_count := 1;

Line 1782: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',

1778: WHEN l_neg_not_allowed THEN
1779: x_return_status := FND_API.G_RET_STS_ERROR;
1780: x_msg_count := 1;
1781: x_msg_data := 'PA_RETN_NEG_VAL';
1782: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',
1783: p_procedure_name => 'retn_billing_method_single');
1784:
1785: WHEN l_percentage_invalid THEN
1786: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1789: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',

1785: WHEN l_percentage_invalid THEN
1786: x_return_status := FND_API.G_RET_STS_ERROR;
1787: x_msg_count := 1;
1788: x_msg_data := 'PA_RETN_PERCENT_RANGE';
1789: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',
1790: p_procedure_name => 'retn_billing_method_single');
1791:
1792: WHEN l_used_other_method THEN
1793: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1796: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',

1792: WHEN l_used_other_method THEN
1793: x_return_status := FND_API.G_RET_STS_ERROR;
1794: x_msg_count := 1;
1795: x_msg_data := 'PA_RETN_RECORD_CHANGED';
1796: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',
1797: p_procedure_name => 'retn_billing_method_single');
1798:
1799: WHEN OTHERS THEN
1800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1803: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',

1799: WHEN OTHERS THEN
1800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1801: x_msg_count := 1;
1802: x_msg_data := SUBSTR(SQLERRM, 1, 240);
1803: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',
1804: p_procedure_name => 'retn_billing_method_single');
1805:
1806: END retn_billing_method_single;
1807:

Line 1866: FND_MSG_PUB.initialize;

1862:
1863:
1864: --Clear the global PL/SQL message table
1865: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN
1866: FND_MSG_PUB.initialize;
1867: END IF;
1868:
1869:
1870:

Line 2068: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',

2064: WHEN l_retn_per_comp_dup THEN
2065: x_return_status := FND_API.G_RET_STS_ERROR;
2066: x_msg_count := 1;
2067: x_msg_data := 'PA_RETN_BILL_PER_COMP_DUP';
2068: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',
2069: p_procedure_name => 'retn_billing_method_PerComp');
2070:
2071: WHEN l_retn_per_comp_null THEN
2072: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2075: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',

2071: WHEN l_retn_per_comp_null THEN
2072: x_return_status := FND_API.G_RET_STS_ERROR;
2073: x_msg_count := 1;
2074: x_msg_data := 'PA_RETN_BILL_PER_COMP_NULL';
2075: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',
2076: p_procedure_name => 'retn_billing_method_PerComp');
2077:
2078: WHEN l_bill_per_either_amount THEN
2079: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2082: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',

2078: WHEN l_bill_per_either_amount THEN
2079: x_return_status := FND_API.G_RET_STS_ERROR;
2080: x_msg_count := 1;
2081: x_msg_data := 'PA_RETN_PERC_AMNT_EXIST';
2082: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',
2083: p_procedure_name => 'retn_billing_method_PerComp');
2084:
2085: WHEN l_bill_per_either_amount_null THEN
2086: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2089: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',

2085: WHEN l_bill_per_either_amount_null THEN
2086: x_return_status := FND_API.G_RET_STS_ERROR;
2087: x_msg_count := 1;
2088: x_msg_data := 'PA_RETN_PERC_AMNT_NO_EXIST';
2089: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',
2090: p_procedure_name => 'retn_billing_method_PerComp');
2091:
2092: WHEN l_percentage_invalid THEN
2093: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2096: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',

2092: WHEN l_percentage_invalid THEN
2093: x_return_status := FND_API.G_RET_STS_ERROR;
2094: x_msg_count := 1;
2095: x_msg_data := 'PA_RETN_PERCENT_RANGE';
2096: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',
2097: p_procedure_name => 'retn_billing_method_PerComp');
2098: WHEN l_neg_not_allowed THEN
2099: x_return_status := FND_API.G_RET_STS_ERROR;
2100: x_msg_count := 1;

Line 2102: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',

2098: WHEN l_neg_not_allowed THEN
2099: x_return_status := FND_API.G_RET_STS_ERROR;
2100: x_msg_count := 1;
2101: x_msg_data := 'PA_RETN_NEG_VAL';
2102: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',
2103: p_procedure_name => 'retn_billing_method_PerComp');
2104: WHEN l_used_other_method THEN
2105: x_return_status := FND_API.G_RET_STS_ERROR;
2106: x_msg_count := 1;

Line 2108: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',

2104: WHEN l_used_other_method THEN
2105: x_return_status := FND_API.G_RET_STS_ERROR;
2106: x_msg_count := 1;
2107: x_msg_data := 'PA_RETN_RECORD_CHANGED';
2108: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',
2109: p_procedure_name => 'retn_billing_method_PerComp');
2110: WHEN OTHERS THEN
2111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2112: x_msg_count := 1;

Line 2115: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',

2111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2112: x_msg_count := 1;
2113: x_msg_data := SQLERRM;
2114: -- dbms_output.put_line(SQLERRM);
2115: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',
2116: p_procedure_name => 'retn_billing_method_PerComp');
2117:
2118: END retn_billing_method_PerComp ;
2119:

Line 2166: FND_MSG_PUB.initialize;

2162:
2163:
2164: --Clear the global PL/SQL message table
2165: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN
2166: FND_MSG_PUB.initialize;
2167: END IF;
2168:
2169:
2170: l_message_code := NULL;

Line 2359: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',

2355: x_task_id := NULL; --NOCOPY
2356: x_return_status := FND_API.G_RET_STS_ERROR;
2357: x_msg_count := 1;
2358: x_msg_data := 'PA_RETN_BILL_REC_EXIST';
2359: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',
2360: p_procedure_name => 'retn_billing_task_validate');
2361:
2362: WHEN OTHERS THEN
2363: x_task_id := NULL; --NOCOPY

Line 2367: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',

2363: x_task_id := NULL; --NOCOPY
2364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2365: x_msg_count := 1;
2366: x_msg_data := SQLERRM;
2367: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RETENTION_UTIL',
2368: p_procedure_name => 'retn_billing_task_validate');
2369:
2370:
2371: