DBA Data[Home] [Help]

APPS.PA_BILLING_PUB dependencies on PA_BILLING_VALUES

Line 282: status := pa_billing_values.get_message('INVALID_COST_BUDGET_TYPE');

278: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_pub.get_budget_amount: ');
279: END IF;
280: EXCEPTION
281: WHEN invalid_cost_budget_code THEN
282: status := pa_billing_values.get_message('INVALID_COST_BUDGET_TYPE');
283: l_status := 1;
284: RAISE_APPLICATION_ERROR(-20101,status);
285: WHEN invalid_rev_budget_code THEN
286: status := pa_billing_values.get_message('INVALID_REV_BUDGET_TYPE');

Line 286: status := pa_billing_values.get_message('INVALID_REV_BUDGET_TYPE');

282: status := pa_billing_values.get_message('INVALID_COST_BUDGET_TYPE');
283: l_status := 1;
284: RAISE_APPLICATION_ERROR(-20101,status);
285: WHEN invalid_rev_budget_code THEN
286: status := pa_billing_values.get_message('INVALID_REV_BUDGET_TYPE');
287: l_status := 2;
288: RAISE_APPLICATION_ERROR(-20101,status);
289: WHEN rev_budget_not_baselined THEN
290: status := pa_billing_values.get_message('REV_BUDGET_NOT_BASELINED');

Line 290: status := pa_billing_values.get_message('REV_BUDGET_NOT_BASELINED');

286: status := pa_billing_values.get_message('INVALID_REV_BUDGET_TYPE');
287: l_status := 2;
288: RAISE_APPLICATION_ERROR(-20101,status);
289: WHEN rev_budget_not_baselined THEN
290: status := pa_billing_values.get_message('REV_BUDGET_NOT_BASELINED');
291: l_status := 3;
292: RAISE_APPLICATION_ERROR(-20101,status);
293: WHEN cost_budget_not_baselined THEN
294: status := pa_billing_values.get_message('COST_BUDGET_NOT_BASELINED');

Line 294: status := pa_billing_values.get_message('COST_BUDGET_NOT_BASELINED');

290: status := pa_billing_values.get_message('REV_BUDGET_NOT_BASELINED');
291: l_status := 3;
292: RAISE_APPLICATION_ERROR(-20101,status);
293: WHEN cost_budget_not_baselined THEN
294: status := pa_billing_values.get_message('COST_BUDGET_NOT_BASELINED');
295: l_status := 4;
296: RAISE_APPLICATION_ERROR(-20101,status);
297: WHEN OTHERS THEN
298: status := substr(SQLERRM,1,240);

Line 899: XD_organization_id := pa_billing_values.get_dflt_org(

895: END IF;
896:
897:
898: IF (X_organization_id IS NULL) THEN
899: XD_organization_id := pa_billing_values.get_dflt_org(
900: nvl(X_project_id,
901: pa_billing.GlobVars.ProjectId),
902: nvl(X_top_task_id,
903: pa_billing.GlobVars.TaskId));

Line 910: pa_billing_values.get_dflt_desc(pa_billing.GlobVars.BillingAssignmentId,

906: END IF;
907:
908: IF (X_event_description IS NULL OR
909: X_event_type IS NULL) THEN
910: pa_billing_values.get_dflt_desc(pa_billing.GlobVars.BillingAssignmentId,
911: XD_event_type, XD_event_description);
912: XD_event_description := nvl(X_event_description,
913: XD_event_description);
914: XD_event_type := nvl(X_event_type, XD_event_type);

Line 942: IF (pa_billing_values.funding_level(nvl(X_project_id,

938:
939: -- Validate funding level
940:
941: IF (nvl(X_top_task_id, pa_billing.GlobVars.TaskId) IS NULL) THEN
942: IF (pa_billing_values.funding_level(nvl(X_project_id,
943: pa_billing.GlobVars.ProjectId))
944: <> 'PROJECT') THEN
945: RAISE invalid_project_event;
946: END IF;

Line 1357: status := pa_billing_values.get_message('MANDATORY_PRM_MISSING');

1353: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_pub.insert_events: ');
1354: END IF;
1355: EXCEPTION
1356: WHEN mandatory_prm_missing THEN
1357: status := pa_billing_values.get_message('MANDATORY_PRM_MISSING');
1358: l_status := 1;
1359: RAISE;
1360: WHEN invalid_id THEN
1361: status := pa_billing_values.get_message('INVALID_ID');

Line 1361: status := pa_billing_values.get_message('INVALID_ID');

1357: status := pa_billing_values.get_message('MANDATORY_PRM_MISSING');
1358: l_status := 1;
1359: RAISE;
1360: WHEN invalid_id THEN
1361: status := pa_billing_values.get_message('INVALID_ID');
1362: l_status := 2;
1363: RAISE;
1364: WHEN invalid_project_event THEN
1365: status := pa_billing_values.get_message('INVALID_PROJECT_EVENT');

Line 1365: status := pa_billing_values.get_message('INVALID_PROJECT_EVENT');

1361: status := pa_billing_values.get_message('INVALID_ID');
1362: l_status := 2;
1363: RAISE;
1364: WHEN invalid_project_event THEN
1365: status := pa_billing_values.get_message('INVALID_PROJECT_EVENT');
1366: l_status := 3;
1367: RAISE;
1368: /*WHEN event_type_error THEN commenting this for bug 3492506
1369: status := pa_billing_values.get_message('EVENT_TYPE_ERROR');

Line 1369: status := pa_billing_values.get_message('EVENT_TYPE_ERROR');

1365: status := pa_billing_values.get_message('INVALID_PROJECT_EVENT');
1366: l_status := 3;
1367: RAISE;
1368: /*WHEN event_type_error THEN commenting this for bug 3492506
1369: status := pa_billing_values.get_message('EVENT_TYPE_ERROR');
1370: RAISE;*/
1371: WHEN null_event_type_error THEN
1372: status := pa_billing_values.get_message('NULL_EVENT_TYPE_ERROR');
1373: l_status := 4;

Line 1372: status := pa_billing_values.get_message('NULL_EVENT_TYPE_ERROR');

1368: /*WHEN event_type_error THEN commenting this for bug 3492506
1369: status := pa_billing_values.get_message('EVENT_TYPE_ERROR');
1370: RAISE;*/
1371: WHEN null_event_type_error THEN
1372: status := pa_billing_values.get_message('NULL_EVENT_TYPE_ERROR');
1373: l_status := 4;
1374: RAISE;
1375: WHEN zero_amounts THEN
1376: status := pa_billing_values.get_message('ZERO_AMOUNTS');

Line 1376: status := pa_billing_values.get_message('ZERO_AMOUNTS');

1372: status := pa_billing_values.get_message('NULL_EVENT_TYPE_ERROR');
1373: l_status := 4;
1374: RAISE;
1375: WHEN zero_amounts THEN
1376: status := pa_billing_values.get_message('ZERO_AMOUNTS');
1377: l_status := 5;
1378: RAISE;
1379: WHEN no_orig_event THEN
1380: status := pa_billing_values.get_message('NO_ORIG_EVENT');

Line 1380: status := pa_billing_values.get_message('NO_ORIG_EVENT');

1376: status := pa_billing_values.get_message('ZERO_AMOUNTS');
1377: l_status := 5;
1378: RAISE;
1379: WHEN no_orig_event THEN
1380: status := pa_billing_values.get_message('NO_ORIG_EVENT');
1381: l_status := 6;
1382: RAISE;
1383: WHEN invalid_calling_place THEN
1384: status := pa_billing_values.get_message('INVALID_CALLING_PLACE');

Line 1384: status := pa_billing_values.get_message('INVALID_CALLING_PLACE');

1380: status := pa_billing_values.get_message('NO_ORIG_EVENT');
1381: l_status := 6;
1382: RAISE;
1383: WHEN invalid_calling_place THEN
1384: status := pa_billing_values.get_message('INVALID_CALLING_PLACE');
1385: l_status := 7;
1386: RAISE;
1387: WHEN invalid_invent_id THEN
1388: status := pa_billing_values.get_message('INVALID_INVENT_ID');

Line 1388: status := pa_billing_values.get_message('INVALID_INVENT_ID');

1384: status := pa_billing_values.get_message('INVALID_CALLING_PLACE');
1385: l_status := 7;
1386: RAISE;
1387: WHEN invalid_invent_id THEN
1388: status := pa_billing_values.get_message('INVALID_INVENT_ID');
1389: l_status := 8;
1390: RAISE;
1391: WHEN l_func_exch_rate_not_passd THEN /* Added for MCB2 */
1392: status := pa_billing_values.get_message('PA_FUNC_EXCH_RATE_NOT_PASSD');

Line 1392: status := pa_billing_values.get_message('PA_FUNC_EXCH_RATE_NOT_PASSD');

1388: status := pa_billing_values.get_message('INVALID_INVENT_ID');
1389: l_status := 8;
1390: RAISE;
1391: WHEN l_func_exch_rate_not_passd THEN /* Added for MCB2 */
1392: status := pa_billing_values.get_message('PA_FUNC_EXCH_RATE_NOT_PASSD');
1393: l_status := 9;
1394: RAISE;
1395: WHEN l_proj_exch_rate_not_passd THEN /* Added for MCB2 */
1396: status := pa_billing_values.get_message('PA_PROJ_EXCH_RATE_NOT_PASSD');

Line 1396: status := pa_billing_values.get_message('PA_PROJ_EXCH_RATE_NOT_PASSD');

1392: status := pa_billing_values.get_message('PA_FUNC_EXCH_RATE_NOT_PASSD');
1393: l_status := 9;
1394: RAISE;
1395: WHEN l_proj_exch_rate_not_passd THEN /* Added for MCB2 */
1396: status := pa_billing_values.get_message('PA_PROJ_EXCH_RATE_NOT_PASSD');
1397: l_status := 10;
1398: RAISE;
1399: WHEN l_fund_exch_rate_not_passd THEN /* Added for MCB2 */
1400: status := pa_billing_values.get_message('PA_FUND_EXCH_RATE_NOT_PASSD');

Line 1400: status := pa_billing_values.get_message('PA_FUND_EXCH_RATE_NOT_PASSD');

1396: status := pa_billing_values.get_message('PA_PROJ_EXCH_RATE_NOT_PASSD');
1397: l_status := 10;
1398: RAISE;
1399: WHEN l_fund_exch_rate_not_passd THEN /* Added for MCB2 */
1400: status := pa_billing_values.get_message('PA_FUND_EXCH_RATE_NOT_PASSD');
1401: l_status := 11;
1402: RAISE;
1403: WHEN l_func_invalid_rate_type THEN /* Added for MCB2 */
1404: status := pa_billing_values.get_message('PA_FUNC_INVALID_RATE_TYPE');

Line 1404: status := pa_billing_values.get_message('PA_FUNC_INVALID_RATE_TYPE');

1400: status := pa_billing_values.get_message('PA_FUND_EXCH_RATE_NOT_PASSD');
1401: l_status := 11;
1402: RAISE;
1403: WHEN l_func_invalid_rate_type THEN /* Added for MCB2 */
1404: status := pa_billing_values.get_message('PA_FUNC_INVALID_RATE_TYPE');
1405: l_status := 12;
1406: RAISE;
1407: WHEN l_proj_invalid_rate_type THEN /* Added for MCB2 */
1408: status := pa_billing_values.get_message('PA_PROJ_INVALID_RATE_TYPE');

Line 1408: status := pa_billing_values.get_message('PA_PROJ_INVALID_RATE_TYPE');

1404: status := pa_billing_values.get_message('PA_FUNC_INVALID_RATE_TYPE');
1405: l_status := 12;
1406: RAISE;
1407: WHEN l_proj_invalid_rate_type THEN /* Added for MCB2 */
1408: status := pa_billing_values.get_message('PA_PROJ_INVALID_RATE_TYPE');
1409: l_status := 13;
1410: RAISE;
1411: WHEN l_fund_invalid_rate_type THEN /* Added for MCB2 */
1412: status := pa_billing_values.get_message('PA_FUND_INVALID_RATE_TYPE');

Line 1412: status := pa_billing_values.get_message('PA_FUND_INVALID_RATE_TYPE');

1408: status := pa_billing_values.get_message('PA_PROJ_INVALID_RATE_TYPE');
1409: l_status := 13;
1410: RAISE;
1411: WHEN l_fund_invalid_rate_type THEN /* Added for MCB2 */
1412: status := pa_billing_values.get_message('PA_FUND_INVALID_RATE_TYPE');
1413: l_status := 14;
1414: RAISE;
1415: WHEN l_invalid_currency THEN /* Added for MCB2 */
1416: status := pa_billing_values.get_message('PA_CURR_NOT_VALID_BC');

Line 1416: status := pa_billing_values.get_message('PA_CURR_NOT_VALID_BC');

1412: status := pa_billing_values.get_message('PA_FUND_INVALID_RATE_TYPE');
1413: l_status := 14;
1414: RAISE;
1415: WHEN l_invalid_currency THEN /* Added for MCB2 */
1416: status := pa_billing_values.get_message('PA_CURR_NOT_VALID_BC');
1417: l_status := 15;
1418: RAISE;
1419: WHEN event_type_error THEN /* adding this here for bug 3492506 */
1420: status := pa_billing_values.get_message('EVENT_TYPE_ERROR');

Line 1420: status := pa_billing_values.get_message('EVENT_TYPE_ERROR');

1416: status := pa_billing_values.get_message('PA_CURR_NOT_VALID_BC');
1417: l_status := 15;
1418: RAISE;
1419: WHEN event_type_error THEN /* adding this here for bug 3492506 */
1420: status := pa_billing_values.get_message('EVENT_TYPE_ERROR');
1421: l_status := 16;
1422: RAISE;
1423: WHEN OTHERS THEN
1424: status := substr(SQLERRM,1,240);

Line 1738: XD_organization_id := pa_billing_values.get_dflt_org(

1734: END IF;
1735:
1736:
1737: IF (X_organization_id IS NULL) THEN
1738: XD_organization_id := pa_billing_values.get_dflt_org(
1739: nvl(X_project_id,
1740: pa_billing.GlobVars.ProjectId),
1741: nvl(X_top_task_id,
1742: pa_billing.GlobVars.TaskId));

Line 1749: pa_billing_values.get_dflt_desc(pa_billing.GlobVars.BillingAssignmentId,

1745: END IF;
1746:
1747: IF (X_event_description IS NULL OR
1748: X_event_type IS NULL) THEN
1749: pa_billing_values.get_dflt_desc(pa_billing.GlobVars.BillingAssignmentId,
1750: XD_event_type, XD_event_description);
1751: XD_event_description := nvl(X_event_description,
1752: XD_event_description);
1753: XD_event_type := nvl(X_event_type, XD_event_type);

Line 1781: IF (pa_billing_values.funding_level(nvl(X_project_id,

1777:
1778: -- Validate funding level
1779:
1780: IF (nvl(X_top_task_id, pa_billing.GlobVars.TaskId) IS NULL) THEN
1781: IF (pa_billing_values.funding_level(nvl(X_project_id,
1782: pa_billing.GlobVars.ProjectId))
1783: <> 'PROJECT') THEN
1784: RAISE invalid_project_event;
1785: END IF;

Line 2206: status := pa_billing_values.get_message('MANDATORY_PRM_MISSING');

2202: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_pub.insert_event2: ');
2203: END IF;
2204: EXCEPTION
2205: WHEN mandatory_prm_missing THEN
2206: status := pa_billing_values.get_message('MANDATORY_PRM_MISSING');
2207: l_status := 1;
2208: RAISE;
2209: WHEN invalid_id THEN
2210: status := pa_billing_values.get_message('INVALID_ID');

Line 2210: status := pa_billing_values.get_message('INVALID_ID');

2206: status := pa_billing_values.get_message('MANDATORY_PRM_MISSING');
2207: l_status := 1;
2208: RAISE;
2209: WHEN invalid_id THEN
2210: status := pa_billing_values.get_message('INVALID_ID');
2211: l_status := 2;
2212: RAISE;
2213: WHEN invalid_project_event THEN
2214: status := pa_billing_values.get_message('INVALID_PROJECT_EVENT');

Line 2214: status := pa_billing_values.get_message('INVALID_PROJECT_EVENT');

2210: status := pa_billing_values.get_message('INVALID_ID');
2211: l_status := 2;
2212: RAISE;
2213: WHEN invalid_project_event THEN
2214: status := pa_billing_values.get_message('INVALID_PROJECT_EVENT');
2215: l_status := 3;
2216: RAISE;
2217: /*WHEN event_type_error THEN commenting this for bug 3492506
2218: status := pa_billing_values.get_message('EVENT_TYPE_ERROR');

Line 2218: status := pa_billing_values.get_message('EVENT_TYPE_ERROR');

2214: status := pa_billing_values.get_message('INVALID_PROJECT_EVENT');
2215: l_status := 3;
2216: RAISE;
2217: /*WHEN event_type_error THEN commenting this for bug 3492506
2218: status := pa_billing_values.get_message('EVENT_TYPE_ERROR');
2219: RAISE;*/
2220: WHEN null_event_type_error THEN
2221: status := pa_billing_values.get_message('NULL_EVENT_TYPE_ERROR');
2222: l_status := 4;

Line 2221: status := pa_billing_values.get_message('NULL_EVENT_TYPE_ERROR');

2217: /*WHEN event_type_error THEN commenting this for bug 3492506
2218: status := pa_billing_values.get_message('EVENT_TYPE_ERROR');
2219: RAISE;*/
2220: WHEN null_event_type_error THEN
2221: status := pa_billing_values.get_message('NULL_EVENT_TYPE_ERROR');
2222: l_status := 4;
2223: RAISE;
2224: WHEN zero_amounts THEN
2225: status := pa_billing_values.get_message('ZERO_AMOUNTS');

Line 2225: status := pa_billing_values.get_message('ZERO_AMOUNTS');

2221: status := pa_billing_values.get_message('NULL_EVENT_TYPE_ERROR');
2222: l_status := 4;
2223: RAISE;
2224: WHEN zero_amounts THEN
2225: status := pa_billing_values.get_message('ZERO_AMOUNTS');
2226: l_status := 5;
2227: RAISE;
2228: WHEN no_orig_event THEN
2229: status := pa_billing_values.get_message('NO_ORIG_EVENT');

Line 2229: status := pa_billing_values.get_message('NO_ORIG_EVENT');

2225: status := pa_billing_values.get_message('ZERO_AMOUNTS');
2226: l_status := 5;
2227: RAISE;
2228: WHEN no_orig_event THEN
2229: status := pa_billing_values.get_message('NO_ORIG_EVENT');
2230: l_status := 6;
2231: RAISE;
2232: WHEN invalid_calling_place THEN
2233: status := pa_billing_values.get_message('INVALID_CALLING_PLACE');

Line 2233: status := pa_billing_values.get_message('INVALID_CALLING_PLACE');

2229: status := pa_billing_values.get_message('NO_ORIG_EVENT');
2230: l_status := 6;
2231: RAISE;
2232: WHEN invalid_calling_place THEN
2233: status := pa_billing_values.get_message('INVALID_CALLING_PLACE');
2234: l_status := 7;
2235: RAISE;
2236: WHEN invalid_invent_id THEN
2237: status := pa_billing_values.get_message('INVALID_INVENT_ID');

Line 2237: status := pa_billing_values.get_message('INVALID_INVENT_ID');

2233: status := pa_billing_values.get_message('INVALID_CALLING_PLACE');
2234: l_status := 7;
2235: RAISE;
2236: WHEN invalid_invent_id THEN
2237: status := pa_billing_values.get_message('INVALID_INVENT_ID');
2238: l_status := 8;
2239: RAISE;
2240: WHEN l_func_exch_rate_not_passd THEN /* Added for MCB2 */
2241: status := pa_billing_values.get_message('PA_FUNC_EXCH_RATE_NOT_PASSD');

Line 2241: status := pa_billing_values.get_message('PA_FUNC_EXCH_RATE_NOT_PASSD');

2237: status := pa_billing_values.get_message('INVALID_INVENT_ID');
2238: l_status := 8;
2239: RAISE;
2240: WHEN l_func_exch_rate_not_passd THEN /* Added for MCB2 */
2241: status := pa_billing_values.get_message('PA_FUNC_EXCH_RATE_NOT_PASSD');
2242: l_status := 9;
2243: RAISE;
2244: WHEN l_proj_exch_rate_not_passd THEN /* Added for MCB2 */
2245: status := pa_billing_values.get_message('PA_PROJ_EXCH_RATE_NOT_PASSD');

Line 2245: status := pa_billing_values.get_message('PA_PROJ_EXCH_RATE_NOT_PASSD');

2241: status := pa_billing_values.get_message('PA_FUNC_EXCH_RATE_NOT_PASSD');
2242: l_status := 9;
2243: RAISE;
2244: WHEN l_proj_exch_rate_not_passd THEN /* Added for MCB2 */
2245: status := pa_billing_values.get_message('PA_PROJ_EXCH_RATE_NOT_PASSD');
2246: l_status := 10;
2247: RAISE;
2248: WHEN l_fund_exch_rate_not_passd THEN /* Added for MCB2 */
2249: status := pa_billing_values.get_message('PA_FUND_EXCH_RATE_NOT_PASSD');

Line 2249: status := pa_billing_values.get_message('PA_FUND_EXCH_RATE_NOT_PASSD');

2245: status := pa_billing_values.get_message('PA_PROJ_EXCH_RATE_NOT_PASSD');
2246: l_status := 10;
2247: RAISE;
2248: WHEN l_fund_exch_rate_not_passd THEN /* Added for MCB2 */
2249: status := pa_billing_values.get_message('PA_FUND_EXCH_RATE_NOT_PASSD');
2250: l_status := 11;
2251: RAISE;
2252: WHEN l_func_invalid_rate_type THEN /* Added for MCB2 */
2253: status := pa_billing_values.get_message('PA_FUNC_INVALID_RATE_TYPE');

Line 2253: status := pa_billing_values.get_message('PA_FUNC_INVALID_RATE_TYPE');

2249: status := pa_billing_values.get_message('PA_FUND_EXCH_RATE_NOT_PASSD');
2250: l_status := 11;
2251: RAISE;
2252: WHEN l_func_invalid_rate_type THEN /* Added for MCB2 */
2253: status := pa_billing_values.get_message('PA_FUNC_INVALID_RATE_TYPE');
2254: l_status := 12;
2255: RAISE;
2256: WHEN l_proj_invalid_rate_type THEN /* Added for MCB2 */
2257: status := pa_billing_values.get_message('PA_PROJ_INVALID_RATE_TYPE');

Line 2257: status := pa_billing_values.get_message('PA_PROJ_INVALID_RATE_TYPE');

2253: status := pa_billing_values.get_message('PA_FUNC_INVALID_RATE_TYPE');
2254: l_status := 12;
2255: RAISE;
2256: WHEN l_proj_invalid_rate_type THEN /* Added for MCB2 */
2257: status := pa_billing_values.get_message('PA_PROJ_INVALID_RATE_TYPE');
2258: l_status := 13;
2259: RAISE;
2260: WHEN l_fund_invalid_rate_type THEN /* Added for MCB2 */
2261: status := pa_billing_values.get_message('PA_FUND_INVALID_RATE_TYPE');

Line 2261: status := pa_billing_values.get_message('PA_FUND_INVALID_RATE_TYPE');

2257: status := pa_billing_values.get_message('PA_PROJ_INVALID_RATE_TYPE');
2258: l_status := 13;
2259: RAISE;
2260: WHEN l_fund_invalid_rate_type THEN /* Added for MCB2 */
2261: status := pa_billing_values.get_message('PA_FUND_INVALID_RATE_TYPE');
2262: l_status := 14;
2263: RAISE;
2264: WHEN l_invalid_currency THEN /* Added for MCB2 */
2265: status := pa_billing_values.get_message('PA_CURR_NOT_VALID_BC');

Line 2265: status := pa_billing_values.get_message('PA_CURR_NOT_VALID_BC');

2261: status := pa_billing_values.get_message('PA_FUND_INVALID_RATE_TYPE');
2262: l_status := 14;
2263: RAISE;
2264: WHEN l_invalid_currency THEN /* Added for MCB2 */
2265: status := pa_billing_values.get_message('PA_CURR_NOT_VALID_BC');
2266: l_status := 15;
2267: RAISE;
2268: WHEN event_type_error THEN /* adding this here for bug 3492506 */
2269: status := pa_billing_values.get_message('EVENT_TYPE_ERROR');

Line 2269: status := pa_billing_values.get_message('EVENT_TYPE_ERROR');

2265: status := pa_billing_values.get_message('PA_CURR_NOT_VALID_BC');
2266: l_status := 15;
2267: RAISE;
2268: WHEN event_type_error THEN /* adding this here for bug 3492506 */
2269: status := pa_billing_values.get_message('EVENT_TYPE_ERROR');
2270: l_status := 16;
2271: RAISE;
2272: WHEN OTHERS THEN
2273: status := substr(SQLERRM,1,240);