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_UTIL

Line 116: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

112: ||' AND process_flag = '||G_ERROR||'))'
113: || lv_where_str;
114:
115:
116: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
117:
118: IF p_batch_id IS NOT NULL THEN
119: EXECUTE IMMEDIATE lv_sql_stmt
120: USING p_instance_code,

Line 137: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

133: ||' AND process_flag = '||G_IN_PROCESS
134: || lv_where_str;
135:
136:
137: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
138:
139: IF p_batch_id IS NOT NULL THEN
140: EXECUTE IMMEDIATE lv_sql_stmt
141: USING p_instance_code,

Line 214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

210: ||' AND t1.sr_instance_code = :p_instance_code'
211: ||' AND NVL(t1.batch_id,'||''''||NULL_CHAR||''''||') = NVL(:p_batch_id,'||''''||NULL_VALUE||''''||')';
212:
213:
214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
215:
216:
217: EXECUTE IMMEDIATE lv_sql_stmt
218: USING lv_my_company,

Line 239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

235: ||' AND NVL(t1.batch_id ,'||''''||NULL_CHAR||''''||') = NVL(:p_batch_id,'||''''||NULL_CHAR||''''||')';
236:
237:
238:
239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
240:
241:
242: EXECUTE IMMEDIATE lv_sql_stmt
243: USING p_instance_code,

Line 263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

259: ||' AND t1.sr_instance_code = :p_instance_code'
260: ||' AND NVL(t1.batch_id ,'||''''||NULL_CHAR||''''||') = NVL(:p_batch_id,'||''''||NULL_CHAR||''''||')'
261: ||' AND t1.partner_type =3';
262:
263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
264:
265:
266: EXECUTE IMMEDIATE lv_sql_stmt
267: USING p_instance_code,

Line 283: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

279: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
280: ||' AND process_flag = ' ||G_IN_PROCESS;
281:
282:
283: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
284:
285:
286: EXECUTE IMMEDIATE lv_sql_stmt
287: USING p_instance_code,

Line 332: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'The name in GET_MY_COMPANY :'||p_my_company);

328: WHEN OTHERS THEN
329: return 'My Company';
330: END;
331:
332: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'The name in GET_MY_COMPANY :'||p_my_company);
333: return p_my_company;
334:
335: END GET_MY_COMPANY;
336:

Line 422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

418:
419: END IF;
420:
421:
422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
423:
424: EXECUTE IMMEDIATE lv_sql_stmt
425: USING p_instance_id,
426: p_instance_code,

Line 441: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

437: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
438: ||' AND process_flag = ' ||G_IN_PROCESS;
439:
440:
441: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
442:
443: EXECUTE IMMEDIATE lv_sql_stmt
444: USING p_instance_code,
445: p_batch_id;

Line 475: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

471: ||' AND NVL(batch_id,'||NULL_VALUE||')= :p_batch_id'
472: ||' AND process_flag = ' ||G_IN_PROCESS;
473:
474:
475: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
476:
477: EXECUTE IMMEDIATE lv_sql_stmt
478: USING p_instance_code,
479: p_batch_id;

Line 608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

604: END IF;
605: END IF;
606:
607:
608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
609:
610: EXECUTE IMMEDIATE lv_sql_stmt
611: USING p_instance_code,
612: p_batch_id;

Line 628: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

624: ||' AND process_flag = '||G_IN_PROCESS
625: || lv_where_str1;
626:
627:
628: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
629:
630: EXECUTE IMMEDIATE lv_sql_stmt
631: USING p_instance_code,
632: p_batch_id;

Line 667: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

663: ||' AND process_flag = '||G_IN_PROCESS
664: || lv_where_str1;
665:
666:
667: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
668:
669: EXECUTE IMMEDIATE lv_sql_stmt
670: USING p_instance_code,
671: p_batch_id;

Line 792: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

788: END IF;
789:
790: END IF;
791:
792: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
793: EXECUTE IMMEDIATE lv_sql_stmt
794: USING p_instance_code,
795: p_batch_id;
796:

Line 810: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

806: ||' AND NVL(batch_id,'||NULL_VALUE||')= :p_batch_id'
807: ||' AND process_flag = '||G_IN_PROCESS
808: || lv_where_str1 ;
809:
810: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
811: EXECUTE IMMEDIATE lv_sql_stmt
812: USING p_instance_code,
813: p_batch_id;
814:

Line 847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

843: ||' AND NVL(batch_id,'||NULL_VALUE||')= :p_batch_id'
844: ||' AND process_flag = '||G_IN_PROCESS
845: || lv_where_str1;
846:
847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
848: EXECUTE IMMEDIATE lv_sql_stmt
849: USING p_instance_code,
850: p_batch_id;
851: END IF;

Line 972: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

968: END IF;
969:
970: END IF;
971:
972: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
973: EXECUTE IMMEDIATE lv_sql_stmt
974: USING p_instance_code,
975: p_batch_id;
976:

Line 988: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

984: ||' AND sr_instance_code = :p_instance_code'
985: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
986: ||' AND process_flag = '||G_IN_PROCESS;
987:
988: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
989: EXECUTE IMMEDIATE lv_sql_stmt
990: USING p_instance_code,
991: p_batch_id;
992:

Line 1079: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

1075: ||' AND sr_instance_code = :p_instance_code'
1076: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
1077: ||' AND process_flag = ' ||G_IN_PROCESS;
1078:
1079: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1080: EXECUTE IMMEDIATE lv_sql_stmt
1081: USING p_instance_id,
1082: p_instance_code,
1083: p_batch_id;

Line 1107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

1103: ||' AND sr_instance_code = :p_instance_code'
1104: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
1105: ||' AND process_flag = ' ||G_IN_PROCESS;
1106:
1107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1108: EXECUTE IMMEDIATE lv_sql_stmt
1109: USING p_instance_id,
1110: p_instance_code,
1111: p_batch_id;

Line 1172: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

1168: ||' AND sr_instance_code = :p_instance_code'
1169: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
1170: ||' AND process_flag = ' ||G_IN_PROCESS;
1171:
1172: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1173: EXECUTE IMMEDIATE lv_sql_stmt
1174: USING p_instance_id,
1175: p_instance_id,
1176: p_instance_code,

Line 1202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

1198: ||' AND sr_instance_code = :p_instance_code'
1199: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
1200: ||' AND process_flag = ' ||G_IN_PROCESS;
1201:
1202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1203: EXECUTE IMMEDIATE lv_sql_stmt
1204: USING p_instance_id,
1205: p_instance_id,
1206: p_instance_code,

Line 1339: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

1335: ||' AND process_flag = '||G_IN_PROCESS;
1336:
1337: END IF;
1338:
1339: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1340: EXECUTE IMMEDIATE lv_sql_stmt
1341: USING p_instance_code,
1342: p_batch_id;
1343:

Line 1356: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

1352: ||' AND sr_instance_code = :p_instance_code'
1353: ||' AND batch_id = :p_batch_id'
1354: ||' AND process_flag = ' ||G_IN_PROCESS;
1355:
1356: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1357: EXECUTE IMMEDIATE lv_sql_stmt
1358: USING p_instance_code,
1359: p_batch_id;
1360:

Line 1389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

1385: ||' AND sr_instance_code = :p_instance_code'
1386: ||' AND batch_id = :p_batch_id'
1387: ||' AND process_flag = ' ||G_IN_PROCESS;
1388:
1389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1390: EXECUTE IMMEDIATE lv_sql_stmt
1391: USING p_instance_code,
1392: p_batch_id;
1393:

Line 1481: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

1477: || p_where_str;
1478:
1479: END IF;
1480:
1481: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1482: EXECUTE IMMEDIATE lv_sql_stmt
1483: USING p_instance_code,
1484: p_batch_id;
1485:

Line 1498: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

1494: ||' AND sr_instance_code = :p_instance_code'
1495: ||' AND batch_id = :p_batch_id'
1496: ||' AND process_flag = ' ||G_IN_PROCESS;
1497:
1498: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1499: EXECUTE IMMEDIATE lv_sql_stmt
1500: USING p_instance_code,
1501: p_batch_id;
1502:

Line 1531: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

1527: ||' AND sr_instance_code = :p_instance_code'
1528: ||' AND batch_id = :p_batch_id'
1529: ||' AND process_flag = ' ||G_IN_PROCESS;
1530:
1531: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1532: EXECUTE IMMEDIATE lv_sql_stmt
1533: USING p_instance_code,
1534: p_batch_id;
1535: END IF;

Line 1590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

1586: ||' WHERE process_flag = '||G_IN_PROCESS
1587: ||' AND sr_instance_code = :p_instance_code'
1588: || lv_where_str;
1589:
1590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1591: IF p_batch_id = NULL_VALUE THEN
1592: EXECUTE IMMEDIATE lv_sql_stmt
1593: USING p_instance_id,
1594: p_instance_code;

Line 1612: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

1608: ||' WHERE nvl(process_flag,'||G_NEW ||') = '||G_NEW
1609: ||' AND sr_instance_code = :p_instance_code'
1610: || lv_where_str;
1611:
1612: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1613: IF p_batch_id = NULL_VALUE THEN
1614: EXECUTE IMMEDIATE lv_sql_stmt
1615: USING p_instance_id,
1616: p_instance_code;

Line 1672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

1668: ||' AND NVL(t1.'||p_level_name_col||','||''''||NULL_CHAR||''''||') '
1669: ||' <> '||''''||NULL_CHAR||''''
1670: ||' AND process_flag = '||G_IN_PROCESS ;
1671:
1672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1673:
1674: EXECUTE IMMEDIATE lv_sql_stmt
1675: USING p_instance_code,
1676: p_batch_id;

Line 1691: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

1687: ||' AND sr_instance_code = :p_instance_code'
1688: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
1689: ||' AND process_flag = ' ||G_IN_PROCESS;
1690:
1691: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1692: EXECUTE IMMEDIATE lv_sql_stmt
1693: USING p_instance_code,
1694: p_batch_id;
1695:

Line 1711: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

1707: ||' AND sr_instance_code = :p_instance_code'
1708: ||' AND NVL(batch_id,'||NULL_VALUE||')= :p_batch_id'
1709: ||' AND process_flag = ' ||G_IN_PROCESS;
1710:
1711: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1712: EXECUTE IMMEDIATE lv_sql_stmt
1713: USING p_instance_code,
1714: p_batch_id;
1715: END IF;

Line 1767: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

1763: ||' AND NVL(t1.'||p_level_pk_col||','||''''||NULL_CHAR||''''||') '
1764: ||' = '||''''||NULL_CHAR||''''
1765: ||' AND process_flag = '||G_IN_PROCESS ;
1766:
1767: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1768:
1769: EXECUTE IMMEDIATE lv_sql_stmt
1770: USING p_instance_code,
1771: p_batch_id;

Line 1845: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

1841: ||' WHERE sr_instance_code = :p_instance_code'
1842: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
1843: ||' AND process_flag = '||G_IN_PROCESS ;
1844:
1845: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1846:
1847: EXECUTE IMMEDIATE lv_sql_stmt
1848: USING p_level_id,
1849: p_instance_id,

Line 1871: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

1867: ||' AND sr_instance_code = :p_instance_code'
1868: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
1869: ||' AND process_flag = ' ||G_IN_PROCESS;
1870:
1871: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1872: EXECUTE IMMEDIATE lv_sql_stmt
1873: USING p_instance_code,
1874: p_batch_id;
1875:

Line 1891: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

1887: ||' AND sr_instance_code = :p_instance_code'
1888: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
1889: ||' AND process_flag = ' ||G_IN_PROCESS;
1890:
1891: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1892: EXECUTE IMMEDIATE lv_sql_stmt
1893: USING p_instance_code,
1894: p_batch_id;
1895:

Line 1983: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

1979: ||' AND NVL(t1.'||p_level_val_col||','||''''||NULL_CHAR||''''||') '
1980: ||' <> '||''''||NULL_CHAR||''''
1981: ||' AND process_flag = '||G_IN_PROCESS ;
1982:
1983: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1984:
1985: EXECUTE IMMEDIATE lv_sql_stmt
1986: USING p_instance_id,
1987: p_instance_id,

Line 2006: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

2002: ||' AND sr_instance_code = :p_instance_code'
2003: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
2004: ||' AND process_flag = ' ||G_IN_PROCESS;
2005:
2006: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
2007: EXECUTE IMMEDIATE lv_sql_stmt
2008: USING p_instance_code,
2009: p_batch_id;
2010:

Line 2026: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

2022: ||' AND sr_instance_code = :p_instance_code'
2023: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
2024: ||' AND process_flag = ' ||G_IN_PROCESS;
2025:
2026: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
2027: EXECUTE IMMEDIATE lv_sql_stmt
2028: USING p_instance_code,
2029: p_batch_id;
2030:

Line 2609: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

2605: ||' WHERE sr_instance_code = :p_instance_code'
2606: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
2607: ||' AND process_flag = '||G_IN_PROCESS;
2608:
2609: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
2610:
2611: EXECUTE IMMEDIATE lv_sql_stmt
2612: USING p_instance_code,
2613: p_batch_id;

Line 2626: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

2622: ||' AND sr_instance_code = :p_instance_code'
2623: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
2624: ||' AND process_flag = ' ||G_IN_PROCESS;
2625:
2626: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
2627: EXECUTE IMMEDIATE lv_sql_stmt
2628: USING p_instance_code,
2629: p_batch_id;
2630:

Line 2657: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

2653: ||' <> '||''''||NULL_CHAR||''''
2654: ||' AND sr_instance_code = :p_instance_code'
2655: ||' AND NVL(batch_id,'||NULL_VALUE||')= :p_batch_id'
2656: ||' AND process_flag = ' ||G_IN_PROCESS;
2657: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
2658: EXECUTE IMMEDIATE lv_sql_stmt
2659: USING p_instance_code,
2660: p_batch_id;
2661:

Line 2941: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,substr(SQLERRM,1,1000));

2937:
2938: exception
2939:
2940: when others then
2941: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,substr(SQLERRM,1,1000));
2942: errbuf := substr(SQLERRM,1,150);
2943: retcode := -1 ;
2944:
2945:

Line 2985: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

2981: ||' AND level_id = 1 '
2982: ||' AND process_flag = '||G_IN_PROCESS;
2983:
2984:
2985: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
2986:
2987: EXECUTE IMMEDIATE lv_sql_stmt
2988: USING p_instance_id,
2989: p_instance_code,

Line 3012: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

3008: ||' AND level_id = 3 '
3009: ||' AND process_flag = '||G_IN_PROCESS ;
3010:
3011:
3012: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3013:
3014: EXECUTE IMMEDIATE lv_sql_stmt
3015: USING p_instance_id,
3016: p_instance_code,

Line 3045: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

3041: ||' = '||''''||NULL_CHAR||''''
3042: ||' AND level_id = 2 '
3043: ||' AND process_flag = '||G_IN_PROCESS ;
3044:
3045: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3046:
3047: EXECUTE IMMEDIATE lv_sql_stmt
3048: USING p_instance_id,
3049: p_instance_id,

Line 3072: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

3068: ||' = '||''''||NULL_CHAR||''''
3069: ||' AND level_id = 7 '
3070: ||' AND process_flag = '||G_IN_PROCESS ;
3071:
3072: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3073:
3074: EXECUTE IMMEDIATE lv_sql_stmt
3075: USING p_instance_id,
3076: p_instance_code,

Line 3105: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

3101: ||' AND level_id = 11 '
3102: ||' AND process_flag = '||G_IN_PROCESS;
3103:
3104:
3105: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3106:
3107: EXECUTE IMMEDIATE lv_sql_stmt
3108: USING p_instance_id,
3109: p_instance_code,

Line 3136: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

3132: ||' AND process_flag = '||G_IN_PROCESS ;
3133:
3134:
3135:
3136: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3137:
3138: EXECUTE IMMEDIATE lv_sql_stmt
3139: USING p_instance_id,
3140: p_instance_code,

Line 3160: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

3156: ||' = '||''''||NULL_CHAR||''''
3157: ||' AND level_id = 34 '
3158: ||' AND process_flag = '||G_IN_PROCESS ;
3159:
3160: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3161:
3162: EXECUTE IMMEDIATE lv_sql_stmt
3163: USING p_instance_id,
3164: p_instance_code,

Line 3185: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

3181: ||' = '||''''||NULL_CHAR||''''
3182: ||' AND level_id = 42 '
3183: ||' AND process_flag = '||G_IN_PROCESS ;
3184:
3185: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3186:
3187: EXECUTE IMMEDIATE lv_sql_stmt
3188: USING p_instance_id,
3189: p_instance_code,

Line 3276: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

3272: ||' AND msrr.batch_id = :p_batch_id'
3273: || p_where_str;
3274: END IF;
3275:
3276: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3277: EXECUTE IMMEDIATE lv_sql_stmt
3278: USING p_instance_code,
3279: p_batch_id;
3280:

Line 3292: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

3288: ||' AND sr_instance_code = :p_instance_code'
3289: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
3290: ||' AND process_flag = ' ||G_IN_PROCESS;
3291:
3292: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3293: EXECUTE IMMEDIATE lv_sql_stmt
3294: USING p_instance_code,
3295: p_batch_id;
3296:

Line 3324: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

3320: ||' AND sr_instance_code = :p_instance_code'
3321: ||' AND NVL(batch_id,'||NULL_VALUE||')= :p_batch_id'
3322: ||' AND process_flag = ' ||G_IN_PROCESS;
3323:
3324: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3325: EXECUTE IMMEDIATE lv_sql_stmt
3326: USING p_instance_code,
3327: p_batch_id;
3328:

Line 3407: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

3403: ||' AND msrr.process_flag ='|| G_IN_PROCESS
3404: ||' AND NVL(msrr.'||p_department_col_id||','||NULL_VALUE||') <> -1'
3405: ||' AND msrr.batch_id = :p_batch_id';
3406: END IF;
3407: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3408: EXECUTE IMMEDIATE lv_sql_stmt
3409: USING p_instance_code,
3410: p_batch_id;
3411:

Line 3423: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

3419: ||' AND sr_instance_code = :p_instance_code'
3420: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
3421: ||' AND process_flag = ' ||G_IN_PROCESS;
3422:
3423: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3424: EXECUTE IMMEDIATE lv_sql_stmt
3425: USING p_instance_code,
3426: p_batch_id;
3427:

Line 3455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

3451: ||' AND sr_instance_code = :p_instance_code'
3452: ||' AND NVL(batch_id,'||NULL_VALUE||')= :p_batch_id'
3453: ||' AND process_flag = ' ||G_IN_PROCESS;
3454:
3455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3456: EXECUTE IMMEDIATE lv_sql_stmt
3457: USING p_instance_code,
3458: p_batch_id;
3459:

Line 3550: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

3546: ||' AND batch_id = :lp_batch_id';
3547:
3548: END IF;
3549:
3550: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3551:
3552:
3553: EXECUTE IMMEDIATE lv_sql_stmt USING p_instance_code,p_batch_id;
3554:

Line 3567: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

3563: ||' AND sr_instance_code = :p_instance_code'
3564: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
3565: ||' AND process_flag = ' ||G_IN_PROCESS;
3566:
3567: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3568: EXECUTE IMMEDIATE lv_sql_stmt
3569: USING p_instance_code,
3570: p_batch_id;
3571:

Line 3599: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

3595: ||' AND sr_instance_code = :p_instance_code'
3596: ||' AND NVL(batch_id,'||NULL_VALUE||')= :p_batch_id'
3597: ||' AND process_flag = ' ||G_IN_PROCESS;
3598:
3599: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3600: EXECUTE IMMEDIATE lv_sql_stmt
3601: USING p_instance_code,
3602: p_batch_id;
3603: