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 637: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

633: END IF;
634: END IF;
635:
636:
637: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
638:
639: EXECUTE IMMEDIATE lv_sql_stmt
640: USING p_instance_code,
641: p_batch_id;

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

653: ||' AND process_flag = '||G_IN_PROCESS
654: || lv_where_str1;
655:
656:
657: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
658:
659: EXECUTE IMMEDIATE lv_sql_stmt
660: USING p_instance_code,
661: p_batch_id;

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

692: ||' AND process_flag = '||G_IN_PROCESS
693: || lv_where_str1;
694:
695:
696: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
697:
698: EXECUTE IMMEDIATE lv_sql_stmt
699: USING p_instance_code,
700: p_batch_id;

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

828: END IF;
829:
830: END IF;
831:
832: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
833: EXECUTE IMMEDIATE lv_sql_stmt
834: USING p_instance_code,
835: p_batch_id;
836:

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

846: ||' AND NVL(batch_id,'||NULL_VALUE||')= :p_batch_id'
847: ||' AND process_flag = '||G_IN_PROCESS
848: || lv_where_str1 ;
849:
850: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
851: EXECUTE IMMEDIATE lv_sql_stmt
852: USING p_instance_code,
853: p_batch_id;
854:

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

883: ||' AND NVL(batch_id,'||NULL_VALUE||')= :p_batch_id'
884: ||' AND process_flag = '||G_IN_PROCESS
885: || lv_where_str1;
886:
887: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
888: EXECUTE IMMEDIATE lv_sql_stmt
889: USING p_instance_code,
890: p_batch_id;
891: END IF;

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

1008: END IF;
1009:
1010: END IF;
1011:
1012: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1013: EXECUTE IMMEDIATE lv_sql_stmt
1014: USING p_instance_code,
1015: p_batch_id;
1016:

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

1024: ||' AND sr_instance_code = :p_instance_code'
1025: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
1026: ||' AND process_flag = '||G_IN_PROCESS;
1027:
1028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1029: EXECUTE IMMEDIATE lv_sql_stmt
1030: USING p_instance_code,
1031: p_batch_id;
1032:

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

1115: ||' AND sr_instance_code = :p_instance_code'
1116: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
1117: ||' AND process_flag = ' ||G_IN_PROCESS;
1118:
1119: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1120: EXECUTE IMMEDIATE lv_sql_stmt
1121: USING p_instance_id,
1122: p_instance_code,
1123: p_batch_id;

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

1143: ||' AND sr_instance_code = :p_instance_code'
1144: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
1145: ||' AND process_flag = ' ||G_IN_PROCESS;
1146:
1147: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1148: EXECUTE IMMEDIATE lv_sql_stmt
1149: USING p_instance_id,
1150: p_instance_code,
1151: p_batch_id;

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

1208: ||' AND sr_instance_code = :p_instance_code'
1209: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
1210: ||' AND process_flag = ' ||G_IN_PROCESS;
1211:
1212: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1213: EXECUTE IMMEDIATE lv_sql_stmt
1214: USING p_instance_id,
1215: p_instance_id,
1216: p_instance_code,

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

1238: ||' AND sr_instance_code = :p_instance_code'
1239: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
1240: ||' AND process_flag = ' ||G_IN_PROCESS;
1241:
1242: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1243: EXECUTE IMMEDIATE lv_sql_stmt
1244: USING p_instance_id,
1245: p_instance_id,
1246: p_instance_code,

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

1375: ||' AND process_flag = '||G_IN_PROCESS;
1376:
1377: END IF;
1378:
1379: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1380: EXECUTE IMMEDIATE lv_sql_stmt
1381: USING p_instance_code,
1382: p_batch_id;
1383:

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

1392: ||' AND sr_instance_code = :p_instance_code'
1393: ||' AND batch_id = :p_batch_id'
1394: ||' AND process_flag = ' ||G_IN_PROCESS;
1395:
1396: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1397: EXECUTE IMMEDIATE lv_sql_stmt
1398: USING p_instance_code,
1399: p_batch_id;
1400:

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

1425: ||' AND sr_instance_code = :p_instance_code'
1426: ||' AND batch_id = :p_batch_id'
1427: ||' AND process_flag = ' ||G_IN_PROCESS;
1428:
1429: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1430: EXECUTE IMMEDIATE lv_sql_stmt
1431: USING p_instance_code,
1432: p_batch_id;
1433:

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

1517: || p_where_str;
1518:
1519: END IF;
1520:
1521: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1522: EXECUTE IMMEDIATE lv_sql_stmt
1523: USING p_instance_code,
1524: p_batch_id;
1525:

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

1534: ||' AND sr_instance_code = :p_instance_code'
1535: ||' AND batch_id = :p_batch_id'
1536: ||' AND process_flag = ' ||G_IN_PROCESS;
1537:
1538: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1539: EXECUTE IMMEDIATE lv_sql_stmt
1540: USING p_instance_code,
1541: p_batch_id;
1542:

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

1567: ||' AND sr_instance_code = :p_instance_code'
1568: ||' AND batch_id = :p_batch_id'
1569: ||' AND process_flag = ' ||G_IN_PROCESS;
1570:
1571: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1572: EXECUTE IMMEDIATE lv_sql_stmt
1573: USING p_instance_code,
1574: p_batch_id;
1575: END IF;

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

1626: ||' WHERE process_flag = '||G_IN_PROCESS
1627: ||' AND sr_instance_code = :p_instance_code'
1628: || lv_where_str;
1629:
1630: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1631: IF p_batch_id = NULL_VALUE THEN
1632: EXECUTE IMMEDIATE lv_sql_stmt
1633: USING p_instance_id,
1634: p_instance_code;

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

1648: ||' WHERE nvl(process_flag,'||G_NEW ||') = '||G_NEW
1649: ||' AND sr_instance_code = :p_instance_code'
1650: || lv_where_str;
1651:
1652: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1653: IF p_batch_id = NULL_VALUE THEN
1654: EXECUTE IMMEDIATE lv_sql_stmt
1655: USING p_instance_id,
1656: p_instance_code;

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

1708: ||' AND NVL(t1.'||p_level_name_col||','||''''||NULL_CHAR||''''||') '
1709: ||' <> '||''''||NULL_CHAR||''''
1710: ||' AND process_flag = '||G_IN_PROCESS ;
1711:
1712: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1713:
1714: EXECUTE IMMEDIATE lv_sql_stmt
1715: USING p_instance_code,
1716: p_batch_id;

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

1727: ||' AND sr_instance_code = :p_instance_code'
1728: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
1729: ||' AND process_flag = ' ||G_IN_PROCESS;
1730:
1731: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1732: EXECUTE IMMEDIATE lv_sql_stmt
1733: USING p_instance_code,
1734: p_batch_id;
1735:

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

1747: ||' AND sr_instance_code = :p_instance_code'
1748: ||' AND NVL(batch_id,'||NULL_VALUE||')= :p_batch_id'
1749: ||' AND process_flag = ' ||G_IN_PROCESS;
1750:
1751: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1752: EXECUTE IMMEDIATE lv_sql_stmt
1753: USING p_instance_code,
1754: p_batch_id;
1755: END IF;

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

1803: ||' AND NVL(t1.'||p_level_pk_col||','||''''||NULL_CHAR||''''||') '
1804: ||' = '||''''||NULL_CHAR||''''
1805: ||' AND process_flag = '||G_IN_PROCESS ;
1806:
1807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1808:
1809: EXECUTE IMMEDIATE lv_sql_stmt
1810: USING p_instance_code,
1811: p_batch_id;

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

1881: ||' WHERE sr_instance_code = :p_instance_code'
1882: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
1883: ||' AND process_flag = '||G_IN_PROCESS ;
1884:
1885: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1886:
1887: EXECUTE IMMEDIATE lv_sql_stmt
1888: USING p_level_id,
1889: p_instance_id,

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

1907: ||' AND sr_instance_code = :p_instance_code'
1908: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
1909: ||' AND process_flag = ' ||G_IN_PROCESS;
1910:
1911: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1912: EXECUTE IMMEDIATE lv_sql_stmt
1913: USING p_instance_code,
1914: p_batch_id;
1915:

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

1927: ||' AND sr_instance_code = :p_instance_code'
1928: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
1929: ||' AND process_flag = ' ||G_IN_PROCESS;
1930:
1931: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
1932: EXECUTE IMMEDIATE lv_sql_stmt
1933: USING p_instance_code,
1934: p_batch_id;
1935:

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

2019: ||' AND NVL(t1.'||p_level_val_col||','||''''||NULL_CHAR||''''||') '
2020: ||' <> '||''''||NULL_CHAR||''''
2021: ||' AND process_flag = '||G_IN_PROCESS ;
2022:
2023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
2024:
2025: EXECUTE IMMEDIATE lv_sql_stmt
2026: USING p_instance_id,
2027: p_instance_id,

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

2042: ||' AND sr_instance_code = :p_instance_code'
2043: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
2044: ||' AND process_flag = ' ||G_IN_PROCESS;
2045:
2046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
2047: EXECUTE IMMEDIATE lv_sql_stmt
2048: USING p_instance_code,
2049: p_batch_id;
2050:

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

2062: ||' AND sr_instance_code = :p_instance_code'
2063: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
2064: ||' AND process_flag = ' ||G_IN_PROCESS;
2065:
2066: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
2067: EXECUTE IMMEDIATE lv_sql_stmt
2068: USING p_instance_code,
2069: p_batch_id;
2070:

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

2645: ||' WHERE sr_instance_code = :p_instance_code'
2646: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
2647: ||' AND process_flag = '||G_IN_PROCESS;
2648:
2649: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
2650:
2651: EXECUTE IMMEDIATE lv_sql_stmt
2652: USING p_instance_code,
2653: p_batch_id;

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

2662: ||' AND sr_instance_code = :p_instance_code'
2663: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
2664: ||' AND process_flag = ' ||G_IN_PROCESS;
2665:
2666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
2667: EXECUTE IMMEDIATE lv_sql_stmt
2668: USING p_instance_code,
2669: p_batch_id;
2670:

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

2693: ||' <> '||''''||NULL_CHAR||''''
2694: ||' AND sr_instance_code = :p_instance_code'
2695: ||' AND NVL(batch_id,'||NULL_VALUE||')= :p_batch_id'
2696: ||' AND process_flag = ' ||G_IN_PROCESS;
2697: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
2698: EXECUTE IMMEDIATE lv_sql_stmt
2699: USING p_instance_code,
2700: p_batch_id;
2701:

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

2977:
2978: exception
2979:
2980: when others then
2981: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,substr(SQLERRM,1,1000));
2982: errbuf := substr(SQLERRM,1,150);
2983: retcode := -1 ;
2984:
2985:

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

3021: ||' AND level_id = 1 '
3022: ||' AND process_flag = '||G_IN_PROCESS;
3023:
3024:
3025: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3026:
3027: EXECUTE IMMEDIATE lv_sql_stmt
3028: USING p_instance_id,
3029: p_instance_code,

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

3048: ||' AND level_id = 3 '
3049: ||' AND process_flag = '||G_IN_PROCESS ;
3050:
3051:
3052: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3053:
3054: EXECUTE IMMEDIATE lv_sql_stmt
3055: USING p_instance_id,
3056: p_instance_code,

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

3081: ||' = '||''''||NULL_CHAR||''''
3082: ||' AND level_id = 2 '
3083: ||' AND process_flag = '||G_IN_PROCESS ;
3084:
3085: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3086:
3087: EXECUTE IMMEDIATE lv_sql_stmt
3088: USING p_instance_id,
3089: p_instance_id,

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

3108: ||' = '||''''||NULL_CHAR||''''
3109: ||' AND level_id = 7 '
3110: ||' AND process_flag = '||G_IN_PROCESS ;
3111:
3112: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3113:
3114: EXECUTE IMMEDIATE lv_sql_stmt
3115: USING p_instance_id,
3116: p_instance_code,

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

3141: ||' AND level_id = 11 '
3142: ||' AND process_flag = '||G_IN_PROCESS;
3143:
3144:
3145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3146:
3147: EXECUTE IMMEDIATE lv_sql_stmt
3148: USING p_instance_id,
3149: p_instance_code,

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

3172: ||' AND process_flag = '||G_IN_PROCESS ;
3173:
3174:
3175:
3176: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3177:
3178: EXECUTE IMMEDIATE lv_sql_stmt
3179: USING p_instance_id,
3180: p_instance_code,

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

3196: ||' = '||''''||NULL_CHAR||''''
3197: ||' AND level_id = 34 '
3198: ||' AND process_flag = '||G_IN_PROCESS ;
3199:
3200: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3201:
3202: EXECUTE IMMEDIATE lv_sql_stmt
3203: USING p_instance_id,
3204: p_instance_code,

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

3221: ||' = '||''''||NULL_CHAR||''''
3222: ||' AND level_id = 42 '
3223: ||' AND process_flag = '||G_IN_PROCESS ;
3224:
3225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3226:
3227: EXECUTE IMMEDIATE lv_sql_stmt
3228: USING p_instance_id,
3229: p_instance_code,

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

3312: ||' AND msrr.batch_id = :p_batch_id'
3313: || p_where_str;
3314: END IF;
3315:
3316: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3317: EXECUTE IMMEDIATE lv_sql_stmt
3318: USING p_instance_code,
3319: p_batch_id;
3320:

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

3328: ||' AND sr_instance_code = :p_instance_code'
3329: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
3330: ||' AND process_flag = ' ||G_IN_PROCESS;
3331:
3332: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3333: EXECUTE IMMEDIATE lv_sql_stmt
3334: USING p_instance_code,
3335: p_batch_id;
3336:

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

3360: ||' AND sr_instance_code = :p_instance_code'
3361: ||' AND NVL(batch_id,'||NULL_VALUE||')= :p_batch_id'
3362: ||' AND process_flag = ' ||G_IN_PROCESS;
3363:
3364: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3365: EXECUTE IMMEDIATE lv_sql_stmt
3366: USING p_instance_code,
3367: p_batch_id;
3368:

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

3443: ||' AND msrr.process_flag ='|| G_IN_PROCESS
3444: ||' AND NVL(msrr.'||p_department_col_id||','||NULL_VALUE||') <> -1'
3445: ||' AND msrr.batch_id = :p_batch_id';
3446: END IF;
3447: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3448: EXECUTE IMMEDIATE lv_sql_stmt
3449: USING p_instance_code,
3450: p_batch_id;
3451:

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

3459: ||' AND sr_instance_code = :p_instance_code'
3460: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
3461: ||' AND process_flag = ' ||G_IN_PROCESS;
3462:
3463: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3464: EXECUTE IMMEDIATE lv_sql_stmt
3465: USING p_instance_code,
3466: p_batch_id;
3467:

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

3491: ||' AND sr_instance_code = :p_instance_code'
3492: ||' AND NVL(batch_id,'||NULL_VALUE||')= :p_batch_id'
3493: ||' AND process_flag = ' ||G_IN_PROCESS;
3494:
3495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3496: EXECUTE IMMEDIATE lv_sql_stmt
3497: USING p_instance_code,
3498: p_batch_id;
3499:

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

3586: ||' AND batch_id = :lp_batch_id';
3587:
3588: END IF;
3589:
3590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3591:
3592:
3593: EXECUTE IMMEDIATE lv_sql_stmt USING p_instance_code,p_batch_id;
3594:

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

3603: ||' AND sr_instance_code = :p_instance_code'
3604: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'
3605: ||' AND process_flag = ' ||G_IN_PROCESS;
3606:
3607: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3608: EXECUTE IMMEDIATE lv_sql_stmt
3609: USING p_instance_code,
3610: p_batch_id;
3611:

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

3635: ||' AND sr_instance_code = :p_instance_code'
3636: ||' AND NVL(batch_id,'||NULL_VALUE||')= :p_batch_id'
3637: ||' AND process_flag = ' ||G_IN_PROCESS;
3638:
3639: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
3640: EXECUTE IMMEDIATE lv_sql_stmt
3641: USING p_instance_code,
3642: p_batch_id;
3643: