DBA Data[Home] [Help]

APPS.POA_EUL_UTILS dependencies on EDW_LOG

Line 36: edw_log.put_line('Procedure initBusAreas3i');

32: ' ba.ba_name '||
33: 'FROM '||g_EulOwner||'.EUL_BUSINESS_AREAS ba '||
34: 'WHERE ba.ba_name = :p_ba';
35:
36: edw_log.put_line('Procedure initBusAreas3i');
37: edw_log.put_line('Going to execute statement:');
38: edw_log.put_line(l_stmt);
39:
40: EXECUTE IMMEDIATE l_stmt INTO g_EulBA_ID, g_eulba_name using pBusAreaName;

Line 37: edw_log.put_line('Going to execute statement:');

33: 'FROM '||g_EulOwner||'.EUL_BUSINESS_AREAS ba '||
34: 'WHERE ba.ba_name = :p_ba';
35:
36: edw_log.put_line('Procedure initBusAreas3i');
37: edw_log.put_line('Going to execute statement:');
38: edw_log.put_line(l_stmt);
39:
40: EXECUTE IMMEDIATE l_stmt INTO g_EulBA_ID, g_eulba_name using pBusAreaName;
41:

Line 38: edw_log.put_line(l_stmt);

34: 'WHERE ba.ba_name = :p_ba';
35:
36: edw_log.put_line('Procedure initBusAreas3i');
37: edw_log.put_line('Going to execute statement:');
38: edw_log.put_line(l_stmt);
39:
40: EXECUTE IMMEDIATE l_stmt INTO g_EulBA_ID, g_eulba_name using pBusAreaName;
41:
42: EXCEPTION

Line 52: edw_log.put_line('*** Table: ' || g_EulOwner ||

48: WHEN OTHERS THEN
49: g_errbuf:=sqlerrm;
50: g_retcode:=sqlcode;
51: if g_retcode = '-942' then
52: edw_log.put_line('*** Table: ' || g_EulOwner ||
53: '.EUL_BUSINESS_AREAS does not exist***');
54: edw_log.put_line('Check EUL ('|| g_EulOwner ||
55: ') and EUL version (DISCO3I)');
56: raise G_EUL_OWNER_DOES_NOT_EXIST;

Line 54: edw_log.put_line('Check EUL ('|| g_EulOwner ||

50: g_retcode:=sqlcode;
51: if g_retcode = '-942' then
52: edw_log.put_line('*** Table: ' || g_EulOwner ||
53: '.EUL_BUSINESS_AREAS does not exist***');
54: edw_log.put_line('Check EUL ('|| g_EulOwner ||
55: ') and EUL version (DISCO3I)');
56: raise G_EUL_OWNER_DOES_NOT_EXIST;
57: else
58: raise;

Line 78: edw_log.put_line('Procedure initBusAreas4i');

74: ' ba.ba_name '||
75: 'FROM '||g_EulOwner||'.EUL4_BAS ba '||
76: 'WHERE ba.ba_name = :p_ba';
77:
78: edw_log.put_line('Procedure initBusAreas4i');
79: edw_log.put_line('Going to execute statement:');
80: edw_log.put_line(l_stmt);
81:
82: EXECUTE IMMEDIATE l_stmt INTO g_EulBA_ID, g_eulba_name using pBusAreaName;

Line 79: edw_log.put_line('Going to execute statement:');

75: 'FROM '||g_EulOwner||'.EUL4_BAS ba '||
76: 'WHERE ba.ba_name = :p_ba';
77:
78: edw_log.put_line('Procedure initBusAreas4i');
79: edw_log.put_line('Going to execute statement:');
80: edw_log.put_line(l_stmt);
81:
82: EXECUTE IMMEDIATE l_stmt INTO g_EulBA_ID, g_eulba_name using pBusAreaName;
83:

Line 80: edw_log.put_line(l_stmt);

76: 'WHERE ba.ba_name = :p_ba';
77:
78: edw_log.put_line('Procedure initBusAreas4i');
79: edw_log.put_line('Going to execute statement:');
80: edw_log.put_line(l_stmt);
81:
82: EXECUTE IMMEDIATE l_stmt INTO g_EulBA_ID, g_eulba_name using pBusAreaName;
83:
84: EXCEPTION

Line 94: edw_log.put_line('*** Table: ' || g_EulOwner ||

90: WHEN OTHERS THEN
91: g_errbuf:=sqlerrm;
92: g_retcode:=sqlcode;
93: if g_retcode = '-942' then
94: edw_log.put_line('*** Table: ' || g_EulOwner ||
95: '.EUL4_BAS does not exist***');
96: edw_log.put_line('Check EUL ('|| g_EulOwner ||
97: ') and EUL version (DISCO4I)');
98: raise G_EUL_OWNER_DOES_NOT_EXIST;

Line 96: edw_log.put_line('Check EUL ('|| g_EulOwner ||

92: g_retcode:=sqlcode;
93: if g_retcode = '-942' then
94: edw_log.put_line('*** Table: ' || g_EulOwner ||
95: '.EUL4_BAS does not exist***');
96: edw_log.put_line('Check EUL ('|| g_EulOwner ||
97: ') and EUL version (DISCO4I)');
98: raise G_EUL_OWNER_DOES_NOT_EXIST;
99: else
100: raise;

Line 357: edw_log.put_line('Business Area Name: ' || g_EulBA_Name || ' not found');

353:
354: EXCEPTION
355:
356: WHEN G_BUSINESS_AREA_DOES_NOT_EXIST THEN
357: edw_log.put_line('Business Area Name: ' || g_EulBA_Name || ' not found');
358: Errbuf := g_errbuf;
359: Retcode := g_retcode;
360: raise;
361:

Line 363: edw_log.put_line('End User Layer (EUL) Owner: ' || g_EulOwner || ' not found OR wrong EUL version: ' || pDiscoVersion);

359: Retcode := g_retcode;
360: raise;
361:
362: WHEN G_EUL_OWNER_DOES_NOT_EXIST THEN
363: edw_log.put_line('End User Layer (EUL) Owner: ' || g_EulOwner || ' not found OR wrong EUL version: ' || pDiscoVersion);
364: Errbuf := g_errbuf;
365: Retcode := g_retcode;
366: raise;
367:

Line 369: edw_log.put_line('pEulOwnerName: '|| g_EulOwner);

365: Retcode := g_retcode;
366: raise;
367:
368: WHEN OTHERS THEN
369: edw_log.put_line('pEulOwnerName: '|| g_EulOwner);
370: edw_log.put_line('pBusAreaName: '|| pBusAreaName);
371: edw_log.put_line('l_stmt : ' || l_stmt);
372: Errbuf := g_errbuf;
373: Retcode := g_retcode;

Line 370: edw_log.put_line('pBusAreaName: '|| pBusAreaName);

366: raise;
367:
368: WHEN OTHERS THEN
369: edw_log.put_line('pEulOwnerName: '|| g_EulOwner);
370: edw_log.put_line('pBusAreaName: '|| pBusAreaName);
371: edw_log.put_line('l_stmt : ' || l_stmt);
372: Errbuf := g_errbuf;
373: Retcode := g_retcode;
374: raise;

Line 371: edw_log.put_line('l_stmt : ' || l_stmt);

367:
368: WHEN OTHERS THEN
369: edw_log.put_line('pEulOwnerName: '|| g_EulOwner);
370: edw_log.put_line('pBusAreaName: '|| pBusAreaName);
371: edw_log.put_line('l_stmt : ' || l_stmt);
372: Errbuf := g_errbuf;
373: Retcode := g_retcode;
374: raise;
375: