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 PA_RETENTION_UTIL

Line 1: PACKAGE BODY pa_retention_util as

1: PACKAGE BODY pa_retention_util as
2: /* $Header: PAXIRUTB.pls 120.2 2005/08/19 17:14:48 mwasowic noship $ */
3:
4: /*----------------------------------------------------------------------------------------+
5: | Function : IsBillingCycleQualified |

Line 36: pa_retention_util.write_log('Entering IsBillingCycleQualified Function ');

32:
33:
34: -- Finding the last bill thru date
35: IF g1_debug_mode = 'Y' THEN
36: pa_retention_util.write_log('Entering IsBillingCycleQualified Function ');
37: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'Billing Cycle Id : ' || p_billing_cycle_id );
38: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'Bill Thru Date : ' || to_char(p_bill_thru_date));
39: END IF;
40:

Line 37: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'Billing Cycle Id : ' || p_billing_cycle_id );

33:
34: -- Finding the last bill thru date
35: IF g1_debug_mode = 'Y' THEN
36: pa_retention_util.write_log('Entering IsBillingCycleQualified Function ');
37: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'Billing Cycle Id : ' || p_billing_cycle_id );
38: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'Bill Thru Date : ' || to_char(p_bill_thru_date));
39: END IF;
40:
41: BEGIN

Line 38: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'Bill Thru Date : ' || to_char(p_bill_thru_date));

34: -- Finding the last bill thru date
35: IF g1_debug_mode = 'Y' THEN
36: pa_retention_util.write_log('Entering IsBillingCycleQualified Function ');
37: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'Billing Cycle Id : ' || p_billing_cycle_id );
38: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'Bill Thru Date : ' || to_char(p_bill_thru_date));
39: END IF;
40:
41: BEGIN
42:

Line 54: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'Project Level Last Bill Thru Date : '

50: WHERE project_id = p_project_id
51: AND retention_invoice_flag = 'Y';
52:
53: IF g1_debug_mode = 'Y' THEN
54: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'Project Level Last Bill Thru Date : '
55: || to_char(last_bill_thru_date));
56: END IF;
57: ELSE
58: SELECT MAX(di.bill_through_date)

Line 69: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'Task Level Last Bill Thru Date : '

65: WHERE dii.draft_invoice_num = di.draft_invoice_num
66: AND dii.project_id = di.project_id
67: AND dii.task_id = p_task_id);
68: IF g1_debug_mode = 'Y' THEN
69: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'Task Level Last Bill Thru Date : '
70: || to_char(last_bill_thru_date));
71: END IF;
72: END IF;
73:

Line 81: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'Last Bill Thru Date : ' || to_char(last_bill_thru_date));

77:
78: END;
79:
80: IF g1_debug_mode = 'Y' THEN
81: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'Last Bill Thru Date : ' || to_char(last_bill_thru_date));
82: END IF;
83:
84: IF last_bill_thru_date IS NULL THEN
85:

Line 87: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'Last Bill Thru Date IS NULL ');

83:
84: IF last_bill_thru_date IS NULL THEN
85:
86: IF g1_debug_mode = 'Y' THEN
87: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'Last Bill Thru Date IS NULL ');
88: END IF;
89:
90: BEGIN
91:

Line 105: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'II Project Level Last Bill Thru Date : '

101: AND di.project_id = p_project_id
102: AND dii.invoice_line_type = 'RETENTION');
103:
104: IF g1_debug_mode = 'Y' THEN
105: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'II Project Level Last Bill Thru Date : '
106: || to_char(last_bill_thru_date));
107: END IF;
108:
109: ELSE

Line 121: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'II Task Level Last Bill Thru Date : '

117: AND dii.task_id = p_task_id
118: AND dii.invoice_line_type = 'RETENTION');
119:
120: IF g1_debug_mode = 'Y' THEN
121: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'II Task Level Last Bill Thru Date : '
122: || to_char(last_bill_thru_date));
123: END IF;
124: END IF;
125:

Line 130: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'No Data Found ');

126: EXCEPTION
127: WHEN NO_DATA_FOUND THEN
128:
129: IF g1_debug_mode = 'Y' THEN
130: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'No Data Found ');
131: END IF;
132: QualifiedFlag := 'N';
133:
134: END;

Line 139: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'Calling PA_Billing_Cycles_Pkg.Get_Billing_Date');

135:
136: END IF;
137:
138: IF g1_debug_mode = 'Y' THEN
139: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'Calling PA_Billing_Cycles_Pkg.Get_Billing_Date');
140: END IF;
141:
142: TmpBillingDate := PA_Billing_Cycles_Pkg.Get_Billing_Date (
143: X_Project_ID =>p_project_id,

Line 150: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'TmpBillDate : ' || to_char(tmpBillingDate));

146: X_Bill_Thru_Date =>P_Bill_thru_date,
147: X_Last_Bill_Thru_Date =>last_bill_thru_date);
148:
149: IF g1_debug_mode = 'Y' THEN
150: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'TmpBillDate : ' || to_char(tmpBillingDate));
151: END IF;
152:
153: IF TmpBillingDate <= P_Bill_thru_date THEN
154: IF g1_debug_mode = 'Y' THEN

Line 155: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'Qualified ');

151: END IF;
152:
153: IF TmpBillingDate <= P_Bill_thru_date THEN
154: IF g1_debug_mode = 'Y' THEN
155: pa_retention_util.write_log('IsBillingCycleQualified: ' || 'Qualified ');
156: END IF;
157: QualifiedFlag := 'Y';
158: ELSE
159: IF g1_debug_mode = 'Y' THEN

Line 160: pa_retention_util.write_log('IsBillingCycleQualified: ' || ' not Qualified ');

156: END IF;
157: QualifiedFlag := 'Y';
158: ELSE
159: IF g1_debug_mode = 'Y' THEN
160: pa_retention_util.write_log('IsBillingCycleQualified: ' || ' not Qualified ');
161: END IF;
162: QualifiedFlag := 'N';
163:
164: END IF;

Line 437: p_pkg_name => 'PA_RETENTION_UTIL',

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

Line 556: p_pkg_name => 'PA_RETENTION_UTIL',

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:
560: END copy_retention_setup;

Line 614: p_pkg_name => 'PA_RETENTION_UTIL',

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:
618: END delete_retn_rules_customer;

Line 683: p_pkg_name => 'PA_RETENTION_UTIL',

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

Line 941: p_pkg_name => 'PA_RETENTION_UTIL',

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

Line 1058: p_pkg_name => 'PA_RETENTION_UTILS',

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

Line 1132: p_pkg_name => 'PA_RETENTION_UTIL',

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

Line 1254: p_pkg_name => 'PA_RETENTION_UTILS',

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

Line 1344: p_pkg_name => 'PA_RETENTION_UTIL',

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:
1348: END calculate_date_factor;

Line 1499: p_pkg_name => 'PA_RETENTION_UTIL',

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

Line 1651: pa_retention_util.set_rec_version_num ( p_project_id,

1647: What ever version number use in the program, If both are equal then return staus will be successful,
1648: If both are differnt then Other User is already updated the project Record so raising the error */
1649:
1650:
1651: pa_retention_util.set_rec_version_num ( p_project_id,
1652: p_customer_id,
1653: p_version_num,
1654: l_x_return_status,
1655: l_x_msg_count,

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 1966: pa_retention_util.set_rec_version_num ( p_project_id,

1962: If both are differnt then Other User is already updated the project Record so raising the error
1963: --------------------------------------------------------------------------------------------------- */
1964:
1965:
1966: pa_retention_util.set_rec_version_num ( p_project_id,
1967: p_customer_id,
1968: p_version_num,
1969: l_x_return_status,
1970: l_x_msg_count,

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

Line 2885: PA_Retention_Util.Validate_Expenditure_Category (

2881: END IF;
2882:
2883: IF P_Retention_Level_Code IN ('EXPENDITURE_CATEGORY', 'EXPENDITURE_TYPE', 'NON_LABOR')
2884: THEN
2885: PA_Retention_Util.Validate_Expenditure_Category (
2886: P_Expenditure_Category => P_Expenditure_Category,
2887: P_Expenditure_Type => P_Expenditure_Type,
2888: P_NON_Labor_Resource => P_Non_Labor_Resource,
2889: X_Return_Status_Code => X_Return_Status_code,

Line 2911: PA_Retention_Util.Validate_Revenue_Category (

2907: END IF;
2908:
2909: IF P_Retention_Level_Code IN ('REVENUE_CATEGORY', 'EVENT_TYPE')
2910: THEN
2911: PA_Retention_Util.Validate_Revenue_Category (
2912: P_Revenue_Category_Code => X_Revenue_Category_Code,
2913: P_Revenue_Category => P_Revenue_Category,
2914: P_Event_Type => P_Event_Type,
2915: X_Return_Status_Code => X_Return_Status_code,

Line 2937: PA_Retention_Util.Check_For_Overlap_Dates (

2933: RETURN;
2934: END IF;
2935:
2936: --- Performing Validations
2937: PA_Retention_Util.Check_For_Overlap_Dates (
2938: P_RowID => P_RowID,
2939: P_PROJECT_ID => P_Project_ID,
2940: P_Task_ID => X_Task_ID,
2941: P_CUSTOMER_ID => P_Customer_ID,

Line 3085: END pa_retention_util;

3081: RETURN(l_retn_invfmt_error);
3082: END CheckRetnInvFormat;
3083:
3084:
3085: END pa_retention_util;