APPS.POA_DNB_LTPRT dependencies on POA_LOG

Line 32: POA_LOG.setup('POALTPRT');

28:
29: errbuf := NULL;
30: Retcode := 0;
31:
32: POA_LOG.setup('POALTPRT');
33: POA_LOG.debug_line('In List All Trading Partners');
34:
35: FOR ltprt in c_all_tprt LOOP
36: POA_LOG.output_line('"' ||

Line 33: POA_LOG.debug_line('In List All Trading Partners');

29: errbuf := NULL;
30: Retcode := 0;
31:
32: POA_LOG.setup('POALTPRT');
33: POA_LOG.debug_line('In List All Trading Partners');
34:
35: FOR ltprt in c_all_tprt LOOP
36: POA_LOG.output_line('"' ||
37: ltprt.TPartner_Loc_PK || '","' ||

Line 36: POA_LOG.output_line('"' ||

32: POA_LOG.setup('POALTPRT');
33: POA_LOG.debug_line('In List All Trading Partners');
34:
35: FOR ltprt in c_all_tprt LOOP
36: POA_LOG.output_line('"' ||
37: ltprt.TPartner_Loc_PK || '","' ||
38: ltprt.Name || '","' ||
39: ltprt.Address_Line1 || '","' ||
40: ltprt.Address_Line2 || '","' ||

Line 52: POA_LOG.put_line('POALTPRT.out generated');

48:
49:
50: END LOOP;
51:
52: POA_LOG.put_line('POALTPRT.out generated');
53: POA_LOG.wrapup('SUCCESS');
54:
55: EXCEPTION WHEN OTHERS THEN
56: errbuf := sqlerrm;

Line 53: POA_LOG.wrapup('SUCCESS');

49:
50: END LOOP;
51:
52: POA_LOG.put_line('POALTPRT.out generated');
53: POA_LOG.wrapup('SUCCESS');
54:
55: EXCEPTION WHEN OTHERS THEN
56: errbuf := sqlerrm;
57: retcode := sqlcode;

Line 59: POA_LOG.put_line('Error while listing Trading Partners:');

55: EXCEPTION WHEN OTHERS THEN
56: errbuf := sqlerrm;
57: retcode := sqlcode;
58:
59: POA_LOG.put_line('Error while listing Trading Partners:');
60: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);
61:
62: v_buf := retcode || ':' || errbuf;
63: ROLLBACK;

Line 60: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);

56: errbuf := sqlerrm;
57: retcode := sqlcode;
58:
59: POA_LOG.put_line('Error while listing Trading Partners:');
60: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);
61:
62: v_buf := retcode || ':' || errbuf;
63: ROLLBACK;
64: POA_LOG.put_line(v_buf);

Line 64: POA_LOG.put_line(v_buf);

60: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);
61:
62: v_buf := retcode || ':' || errbuf;
63: ROLLBACK;
64: POA_LOG.put_line(v_buf);
65: POA_LOG.wrapup('ERROR');
66:
67: RETURN;
68:

Line 65: POA_LOG.wrapup('ERROR');

61:
62: v_buf := retcode || ':' || errbuf;
63: ROLLBACK;
64: POA_LOG.put_line(v_buf);
65: POA_LOG.wrapup('ERROR');
66:
67: RETURN;
68:
69: END poa_list_all_tprt;