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.MSC_ST_UTIL dependencies on MSC_ST_UTIL

Line 1: PACKAGE BODY MSC_ST_UTIL AS

1: PACKAGE BODY MSC_ST_UTIL AS
2: /* $Header: MSCSUTLB.pls 120.14 2012/03/07 19:12:22 pstrnad ship $ */
3:
4: v_sql_stmt PLS_INTEGER;--Holds the DML statement no used for error logging.
5: v_debug BOOLEAN;

Line 151: p_error_text := substr('MSC_ST_UTIL.LOG_ERROR'||'('||v_sql_stmt||')'

147: END IF;
148: RETURN(0);
149: EXCEPTION
150: WHEN OTHERS THEN
151: p_error_text := substr('MSC_ST_UTIL.LOG_ERROR'||'('||v_sql_stmt||')'
152: || SQLERRM, 1, 240);
153: return(SQLCODE);
154: END LOG_ERROR;
155:

Line 296: p_error_text := substr('MSC_ST_UTIL.DERIVE_COMPANY_ID'||'('

292: RETURN(lv_status);
293:
294: EXCEPTION
295: WHEN too_many_rows THEN
296: p_error_text := substr('MSC_ST_UTIL.DERIVE_COMPANY_ID'||'('
297: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
298: return(SQLCODE);
299:
300: WHEN others THEN

Line 301: p_error_text := substr('MSC_ST_UTIL.DERIVE_COMPANY_ID'||'('

297: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
298: return(SQLCODE);
299:
300: WHEN others THEN
301: p_error_text := substr('MSC_ST_UTIL.DERIVE_COMPANY_ID'||'('
302: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
303: return(SQLCODE);
304:
305: END DERIVE_COMPANY_ID;

Line 486: p_error_text := substr('MSC_ST_UTIL.DERIVE_ITEM_ID'||'('

482: RETURN(lv_status);
483:
484: EXCEPTION
485: WHEN too_many_rows THEN
486: p_error_text := substr('MSC_ST_UTIL.DERIVE_ITEM_ID'||'('
487: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
488: return(SQLCODE);
489:
490: WHEN OTHERS THEN

Line 491: p_error_text := substr('MSC_ST_UTIL.DERIVE_ITEM_ID'||'('

487: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
488: return(SQLCODE);
489:
490: WHEN OTHERS THEN
491: p_error_text := substr('MSC_ST_UTIL.DERIVE_ITEM_ID'||'('
492: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
493: return(SQLCODE);
494: END DERIVE_ITEM_ID;
495:

Line 706: p_error_text := substr('MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID'||'('

702: END IF;
703: RETURN(lv_status);
704: EXCEPTION
705: WHEN too_many_rows THEN
706: p_error_text := substr('MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID'||'('
707: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
708: return(SQLCODE);
709:
710: WHEN OTHERS THEN

Line 711: p_error_text := substr('MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID'||'('

707: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
708: return(SQLCODE);
709:
710: WHEN OTHERS THEN
711: p_error_text := substr('MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID'||'('
712: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
713: return(SQLCODE);
714:
715: END DERIVE_PARTNER_ORG_ID;

Line 896: p_error_text := substr('MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID'||'('

892: RETURN(lv_status);
893:
894: EXCEPTION
895: WHEN too_many_rows THEN
896: p_error_text := substr('MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID'||'('
897: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
898: return(SQLCODE);
899:
900: WHEN OTHERS THEN

Line 901: p_error_text := substr('MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID'||'('

897: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
898: return(SQLCODE);
899:
900: WHEN OTHERS THEN
901: p_error_text := substr('MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID'||'('
902: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
903: return(SQLCODE);
904:
905: END DERIVE_PARTNER_SITE_ID;

Line 1063: p_error_text := substr('MSC_ST_UTIL.DERIVE_PROJ_TASK_ID'||'('

1059: END IF;
1060: RETURN(lv_status);
1061: EXCEPTION
1062: WHEN too_many_rows THEN
1063: p_error_text := substr('MSC_ST_UTIL.DERIVE_PROJ_TASK_ID'||'('
1064: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1065: return(SQLCODE);
1066:
1067: WHEN OTHERS THEN

Line 1068: p_error_text := substr('MSC_ST_UTIL.DERIVE_PROJ_TASK_ID'||'('

1064: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1065: return(SQLCODE);
1066:
1067: WHEN OTHERS THEN
1068: p_error_text := substr('MSC_ST_UTIL.DERIVE_PROJ_TASK_ID'||'('
1069: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1070: return(SQLCODE);
1071:
1072: END DERIVE_PROJ_TASK_ID;

Line 1158: p_error_text := substr('MSC_ST_UTIL.VALIDATE_UOM'||'('

1154: RETURN(lv_status);
1155:
1156: EXCEPTION
1157: WHEN too_many_rows THEN
1158: p_error_text := substr('MSC_ST_UTIL.VALIDATE_UOM'||'('
1159: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1160: return(SQLCODE);
1161:
1162: WHEN OTHERS THEN

Line 1163: p_error_text := substr('MSC_ST_UTIL.VALIDATE_UOM'||'('

1159: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1160: return(SQLCODE);
1161:
1162: WHEN OTHERS THEN
1163: p_error_text := substr('MSC_ST_UTIL.VALIDATE_UOM'||'('
1164: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1165: return(SQLCODE);
1166: END VALIDATE_UOM ;
1167:

Line 1252: p_error_text := substr('MSC_ST_UTIL.VALIDATE_DMD_CLASS'||'('

1248: END IF;
1249: RETURN(lv_status);
1250: EXCEPTION
1251: WHEN OTHERS THEN
1252: p_error_text := substr('MSC_ST_UTIL.VALIDATE_DMD_CLASS'||'('
1253: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1254: return(SQLCODE);
1255: END VALIDATE_DMD_CLASS ;
1256:

Line 1307: p_error_text := substr('MSC_ST_UTIL.GET_ERROR_MESSAGE'

1303:
1304: RETURN(0);
1305: EXCEPTION
1306: WHEN OTHERS THEN
1307: p_error_text := substr('MSC_ST_UTIL.GET_ERROR_MESSAGE'
1308: || SQLERRM, 1, 240);
1309: return(SQLCODE);
1310:
1311: END GET_ERROR_MESSAGE;

Line 1439: p_error_text := substr('MSC_ST_UTIL.DERIVE_BILL_SEQUENCE_ID'||'('

1435: RETURN(lv_status);
1436:
1437: EXCEPTION
1438: WHEN too_many_rows THEN
1439: p_error_text := substr('MSC_ST_UTIL.DERIVE_BILL_SEQUENCE_ID'||'('
1440: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1441: return(SQLCODE);
1442:
1443: WHEN OTHERS THEN

Line 1444: p_error_text := substr('MSC_ST_UTIL.DERIVE_BILL_SEQUENCE_ID'||'('

1440: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1441: return(SQLCODE);
1442:
1443: WHEN OTHERS THEN
1444: p_error_text := substr('MSC_ST_UTIL.DERIVE_BILL_SEQUENCE_ID'||'('
1445: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1446: return(SQLCODE);
1447:
1448: END DERIVE_BILL_SEQUENCE_ID;

Line 1580: p_error_text := substr('MSC_ST_UTIL.DERIVE_ROUTING_SEQUENCE_ID'||'('

1576: RETURN(lv_status);
1577:
1578: EXCEPTION
1579: WHEN too_many_rows THEN
1580: p_error_text := substr('MSC_ST_UTIL.DERIVE_ROUTING_SEQUENCE_ID'||'('
1581: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1582: return(SQLCODE);
1583:
1584:

Line 1586: p_error_text := substr('MSC_ST_UTIL.DERIVE_ROUTING_SEQUENCE_ID'||'('

1582: return(SQLCODE);
1583:
1584:
1585: WHEN OTHERS THEN
1586: p_error_text := substr('MSC_ST_UTIL.DERIVE_ROUTING_SEQUENCE_ID'||'('
1587: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1588: return(SQLCODE);
1589:
1590: END DERIVE_ROUTING_SEQUENCE_ID;

Line 1669: p_error_text := substr('MSC_ST_UTIL.SET_PROCESS_FLAG'||'('||v_sql_stmt||')'

1665:
1666: RETURN(0);
1667: EXCEPTION
1668: WHEN OTHERS THEN
1669: p_error_text := substr('MSC_ST_UTIL.SET_PROCESS_FLAG'||'('||v_sql_stmt||')'
1670: || SQLERRM, 1, 240);
1671: return(SQLCODE);
1672:
1673: END SET_PROCESS_FLAG;

Line 1761: p_error_text := substr('MSC_ST_UTIL.DERIVE_LEVEL_ID'||'('

1757:
1758: EXCEPTION
1759:
1760: WHEN too_many_rows THEN
1761: p_error_text := substr('MSC_ST_UTIL.DERIVE_LEVEL_ID'||'('
1762: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1763: return(SQLCODE);
1764:
1765: WHEN OTHERS THEN

Line 1766: p_error_text := substr('MSC_ST_UTIL.DERIVE_LEVEL_ID'||'('

1762: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1763: return(SQLCODE);
1764:
1765: WHEN OTHERS THEN
1766: p_error_text := substr('MSC_ST_UTIL.DERIVE_LEVEL_ID'||'('
1767: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1768: return(SQLCODE);
1769:
1770: END DERIVE_LEVEL_ID;

Line 1816: p_error_text := substr('MSC_ST_UTIL.DERIVE_SR_LEVEL_PK'||'('

1812: RETURN(lv_status);
1813:
1814: EXCEPTION
1815: WHEN too_many_rows THEN
1816: p_error_text := substr('MSC_ST_UTIL.DERIVE_SR_LEVEL_PK'||'('
1817: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1818: return(SQLCODE);
1819:
1820: WHEN OTHERS THEN

Line 1821: p_error_text := substr('MSC_ST_UTIL.DERIVE_SR_LEVEL_PK'||'('

1817: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1818: return(SQLCODE);
1819:
1820: WHEN OTHERS THEN
1821: p_error_text := substr('MSC_ST_UTIL.DERIVE_SR_LEVEL_PK'||'('
1822: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1823: return(SQLCODE);
1824:
1825: END DERIVE_SR_LEVEL_PK;

Line 1942: p_error_text := substr('MSC_ST_UTIL.DERIVE_SR_PK'||'('

1938:
1939: EXCEPTION
1940:
1941: WHEN too_many_rows THEN
1942: p_error_text := substr('MSC_ST_UTIL.DERIVE_SR_PK'||'('
1943: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1944: return(SQLCODE);
1945:
1946: WHEN OTHERS THEN

Line 1947: p_error_text := substr('MSC_ST_UTIL.DERIVE_SR_PK'||'('

1943: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1944: return(SQLCODE);
1945:
1946: WHEN OTHERS THEN
1947: p_error_text := substr('MSC_ST_UTIL.DERIVE_SR_PK'||'('
1948: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1949: return(SQLCODE);
1950:
1951: END DERIVE_SR_PK ;

Line 2077: p_error_text := substr('MSC_ST_UTIL.DERIVE_LEVEL_PK'||'('

2073:
2074: EXCEPTION
2075:
2076: WHEN too_many_rows THEN
2077: p_error_text := substr('MSC_ST_UTIL.DERIVE_LEVEL_PK'||'('
2078: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
2079: return(SQLCODE);
2080:
2081: WHEN OTHERS THEN

Line 2082: p_error_text := substr('MSC_ST_UTIL.DERIVE_LEVEL_PK'||'('

2078: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
2079: return(SQLCODE);
2080:
2081: WHEN OTHERS THEN
2082: p_error_text := substr('MSC_ST_UTIL.DERIVE_LEVEL_PK'||'('
2083: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
2084: return(SQLCODE);
2085:
2086: END DERIVE_LEVEL_PK ;

Line 2707: p_error_text := substr('MSC_ST_UTIL.DERIVE_GROUP_ID'||'('

2703: RETURN(lv_status);
2704:
2705: EXCEPTION
2706: WHEN too_many_rows THEN
2707: p_error_text := substr('MSC_ST_UTIL.DERIVE_GROUP_ID'||'('
2708: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
2709: return(SQLCODE);
2710:
2711: WHEN OTHERS THEN

Line 2712: p_error_text := substr('MSC_ST_UTIL.DERIVE_GROUP_ID'||'('

2708: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
2709: return(SQLCODE);
2710:
2711: WHEN OTHERS THEN
2712: p_error_text := substr('MSC_ST_UTIL.DERIVE_GROUP_ID'||'('
2713: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
2714: return(SQLCODE);
2715:
2716: END DERIVE_GROUP_ID;

Line 3238: p_error_text := substr('MSC_ST_UTIL.DERIVE_SETUP_SR_LEVEL_PK'||'('

3234: RETURN(lv_status);
3235:
3236: EXCEPTION
3237: WHEN too_many_rows THEN
3238: p_error_text := substr('MSC_ST_UTIL.DERIVE_SETUP_SR_LEVEL_PK'||'('
3239: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
3240: return(SQLCODE);
3241:
3242: WHEN OTHERS THEN

Line 3243: p_error_text := substr('MSC_ST_UTIL.DERIVE_SETUP_SR_LEVEL_PK'||'('

3239: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
3240: return(SQLCODE);
3241:
3242: WHEN OTHERS THEN
3243: p_error_text := substr('MSC_ST_UTIL.DERIVE_SETUP_SR_LEVEL_PK'||'('
3244: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
3245: return(SQLCODE);
3246:
3247: END DERIVE_SETUP_SR_LEVEL_PK;

Line 3374: p_error_text := substr('MSC_ST_UTIL.DERIVE_RESOURCE_ID'||'('

3370: RETURN(lv_status);
3371:
3372: EXCEPTION
3373: WHEN too_many_rows THEN
3374: p_error_text := substr('MSC_ST_UTIL.DERIVE_RESOURCE_ID'||'('
3375: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
3376: return(SQLCODE);
3377:
3378: WHEN OTHERS THEN

Line 3379: p_error_text := substr('MSC_ST_UTIL.DERIVE_RESOURCE_ID'||'('

3375: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
3376: return(SQLCODE);
3377:
3378: WHEN OTHERS THEN
3379: p_error_text := substr('MSC_ST_UTIL.DERIVE_RESOURCE_ID'||'('
3380: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
3381: return(SQLCODE);
3382: END DERIVE_RESOURCE_ID;
3383:

Line 3505: p_error_text := substr('MSC_ST_UTIL.DERIVE_DEPARTMENT_ID'||'('

3501: RETURN(lv_status);
3502:
3503: EXCEPTION
3504: WHEN too_many_rows THEN
3505: p_error_text := substr('MSC_ST_UTIL.DERIVE_DEPARTMENT_ID'||'('
3506: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
3507: return(SQLCODE);
3508:
3509: WHEN OTHERS THEN

Line 3510: p_error_text := substr('MSC_ST_UTIL.DERIVE_DEPARTMENT_ID'||'('

3506: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
3507: return(SQLCODE);
3508:
3509: WHEN OTHERS THEN
3510: p_error_text := substr('MSC_ST_UTIL.DERIVE_DEPARTMENT_ID'||'('
3511: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
3512: return(SQLCODE);
3513: END DERIVE_DEPARTMENT_ID;
3514:

Line 3649: p_error_text := substr('MSC_ST_UTIL.DERIVE_OPERATION_SEQUENCE_ID'||'('

3645: RETURN(lv_status);
3646:
3647: EXCEPTION
3648: WHEN too_many_rows THEN
3649: p_error_text := substr('MSC_ST_UTIL.DERIVE_OPERATION_SEQUENCE_ID'||'('
3650: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
3651: return(SQLCODE);
3652:
3653: WHEN OTHERS THEN

Line 3654: p_error_text := substr('MSC_ST_UTIL.DERIVE_OPERATION_SEQUENCE_ID'||'('

3650: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
3651: return(SQLCODE);
3652:
3653: WHEN OTHERS THEN
3654: p_error_text := substr('MSC_ST_UTIL.DERIVE_OPERATION_SEQUENCE_ID'||'('
3655: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
3656: return(SQLCODE);
3657: END DERIVE_OPERATION_SEQUENCE_ID;
3658:

Line 3697: END MSC_ST_UTIL;

3693: return stream_name;
3694: end get_stream_name;
3695:
3696:
3697: END MSC_ST_UTIL;