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_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 1356: status := pa_billing_values.get_message('MANDATORY_PRM_MISSING');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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