15: --| HISTORY |
16: --| 10/21/1999 tsimmond Created |
17: --| 03/14/2000 tsimmond Updated |
18: --| 10/31/2001 vto 2040015: Modified log message levels |
19: --| substr FND_MESSAGES to prevent errors |
20: --| when the message is too long for print |
21: --| 11/28/2001 tsimmond updated, added dbrv and set verify off |
22: --+======================================================================*/
23:
26:
27: --===================
28: -- CONSTANTS
29: --===================
30: G_OBJECT_TYPE_VENDOR CONSTANT VARCHAR2(60):=SUBSTRB(FND_MESSAGE.get_string
31: ('PO','PO_EUR_REPORT_OBJECT_VENDOR'),1,60);
32: G_OBJECT_TYPE_VSITE CONSTANT VARCHAR2(60):=SUBSTRB(FND_MESSAGE.get_string
33: ('PO','PO_EUR_REPORT_OBJECT_SITE'),1,60);
34: G_OBJECT_TYPE_VBANK CONSTANT VARCHAR2(60):=SUBSTRB(FND_MESSAGE.get_string
28: -- CONSTANTS
29: --===================
30: G_OBJECT_TYPE_VENDOR CONSTANT VARCHAR2(60):=SUBSTRB(FND_MESSAGE.get_string
31: ('PO','PO_EUR_REPORT_OBJECT_VENDOR'),1,60);
32: G_OBJECT_TYPE_VSITE CONSTANT VARCHAR2(60):=SUBSTRB(FND_MESSAGE.get_string
33: ('PO','PO_EUR_REPORT_OBJECT_SITE'),1,60);
34: G_OBJECT_TYPE_VBANK CONSTANT VARCHAR2(60):=SUBSTRB(FND_MESSAGE.get_string
35: ('PO','PO_EUR_REPORT_OBJECT_BANK'),1,60);
36: G_OBJECT_TYPE_PO CONSTANT VARCHAR2(60):=SUBSTRB(FND_MESSAGE.get_string
30: G_OBJECT_TYPE_VENDOR CONSTANT VARCHAR2(60):=SUBSTRB(FND_MESSAGE.get_string
31: ('PO','PO_EUR_REPORT_OBJECT_VENDOR'),1,60);
32: G_OBJECT_TYPE_VSITE CONSTANT VARCHAR2(60):=SUBSTRB(FND_MESSAGE.get_string
33: ('PO','PO_EUR_REPORT_OBJECT_SITE'),1,60);
34: G_OBJECT_TYPE_VBANK CONSTANT VARCHAR2(60):=SUBSTRB(FND_MESSAGE.get_string
35: ('PO','PO_EUR_REPORT_OBJECT_BANK'),1,60);
36: G_OBJECT_TYPE_PO CONSTANT VARCHAR2(60):=SUBSTRB(FND_MESSAGE.get_string
37: ('PO','PO_EUR_REPORT_OBJECT_PO'),1,60);
38: --
32: G_OBJECT_TYPE_VSITE CONSTANT VARCHAR2(60):=SUBSTRB(FND_MESSAGE.get_string
33: ('PO','PO_EUR_REPORT_OBJECT_SITE'),1,60);
34: G_OBJECT_TYPE_VBANK CONSTANT VARCHAR2(60):=SUBSTRB(FND_MESSAGE.get_string
35: ('PO','PO_EUR_REPORT_OBJECT_BANK'),1,60);
36: G_OBJECT_TYPE_PO CONSTANT VARCHAR2(60):=SUBSTRB(FND_MESSAGE.get_string
37: ('PO','PO_EUR_REPORT_OBJECT_PO'),1,60);
38: --
39: G_ACTION_CONV CONSTANT VARCHAR2(15):=SUBSTRB(FND_MESSAGE.get_string
40: ('PO','PO_EUR_REPORT_ACTION_CONV'),1,15);
35: ('PO','PO_EUR_REPORT_OBJECT_BANK'),1,60);
36: G_OBJECT_TYPE_PO CONSTANT VARCHAR2(60):=SUBSTRB(FND_MESSAGE.get_string
37: ('PO','PO_EUR_REPORT_OBJECT_PO'),1,60);
38: --
39: G_ACTION_CONV CONSTANT VARCHAR2(15):=SUBSTRB(FND_MESSAGE.get_string
40: ('PO','PO_EUR_REPORT_ACTION_CONV'),1,15);
41: G_ACTION_IGNORE CONSTANT VARCHAR2(15):=SUBSTRB(FND_MESSAGE.get_string
42: ('PO','PO_EUR_REPORT_ACTION_IGNORE'),1,15);
43: G_ACTION_COPY CONSTANT VARCHAR2(15):=SUBSTRB(FND_MESSAGE.get_string
37: ('PO','PO_EUR_REPORT_OBJECT_PO'),1,60);
38: --
39: G_ACTION_CONV CONSTANT VARCHAR2(15):=SUBSTRB(FND_MESSAGE.get_string
40: ('PO','PO_EUR_REPORT_ACTION_CONV'),1,15);
41: G_ACTION_IGNORE CONSTANT VARCHAR2(15):=SUBSTRB(FND_MESSAGE.get_string
42: ('PO','PO_EUR_REPORT_ACTION_IGNORE'),1,15);
43: G_ACTION_COPY CONSTANT VARCHAR2(15):=SUBSTRB(FND_MESSAGE.get_string
44: ('PO','PO_EUR_REPORT_ACTION_COPY'),1,15);
45: --2040015
39: G_ACTION_CONV CONSTANT VARCHAR2(15):=SUBSTRB(FND_MESSAGE.get_string
40: ('PO','PO_EUR_REPORT_ACTION_CONV'),1,15);
41: G_ACTION_IGNORE CONSTANT VARCHAR2(15):=SUBSTRB(FND_MESSAGE.get_string
42: ('PO','PO_EUR_REPORT_ACTION_IGNORE'),1,15);
43: G_ACTION_COPY CONSTANT VARCHAR2(15):=SUBSTRB(FND_MESSAGE.get_string
44: ('PO','PO_EUR_REPORT_ACTION_COPY'),1,15);
45: --2040015
46: --Changed length to 40 since this is the max length for the output. NLS value might be too long to
47: --fit so truncating it.
45: --2040015
46: --Changed length to 40 since this is the max length for the output. NLS value might be too long to
47: --fit so truncating it.
48:
49: G_REASON_EURO CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
50: ('PO','PO_EUR_REPORT_REASON_EURO'),1,40);
51: G_REASON_PARTIAL CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
52: ('PO','PO_EUR_REPORT_REASON_PARTIAL'),1,40);
53: G_REASON_MANUAL CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
47: --fit so truncating it.
48:
49: G_REASON_EURO CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
50: ('PO','PO_EUR_REPORT_REASON_EURO'),1,40);
51: G_REASON_PARTIAL CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
52: ('PO','PO_EUR_REPORT_REASON_PARTIAL'),1,40);
53: G_REASON_MANUAL CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
54: ('PO','PO_EUR_REPORT_REASON_MANUAL'),1,40);
55: G_REASON_CONTRACT CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
49: G_REASON_EURO CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
50: ('PO','PO_EUR_REPORT_REASON_EURO'),1,40);
51: G_REASON_PARTIAL CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
52: ('PO','PO_EUR_REPORT_REASON_PARTIAL'),1,40);
53: G_REASON_MANUAL CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
54: ('PO','PO_EUR_REPORT_REASON_MANUAL'),1,40);
55: G_REASON_CONTRACT CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
56: ('PO','PO_EUR_REPORT_REASON_CONTR'),1,40);
57: G_REASON_IN_PLACE CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
51: G_REASON_PARTIAL CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
52: ('PO','PO_EUR_REPORT_REASON_PARTIAL'),1,40);
53: G_REASON_MANUAL CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
54: ('PO','PO_EUR_REPORT_REASON_MANUAL'),1,40);
55: G_REASON_CONTRACT CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
56: ('PO','PO_EUR_REPORT_REASON_CONTR'),1,40);
57: G_REASON_IN_PLACE CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
58: ('PO','PO_EUR_REPORT_REASON_IN_PLACE'),1,40);
59: G_REASON_SHORT CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
53: G_REASON_MANUAL CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
54: ('PO','PO_EUR_REPORT_REASON_MANUAL'),1,40);
55: G_REASON_CONTRACT CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
56: ('PO','PO_EUR_REPORT_REASON_CONTR'),1,40);
57: G_REASON_IN_PLACE CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
58: ('PO','PO_EUR_REPORT_REASON_IN_PLACE'),1,40);
59: G_REASON_SHORT CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
60: ('PO','PO_EUR_REPORT_REASON_SHORT'),1,40);
61: G_REASON_NOTHING CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
55: G_REASON_CONTRACT CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
56: ('PO','PO_EUR_REPORT_REASON_CONTR'),1,40);
57: G_REASON_IN_PLACE CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
58: ('PO','PO_EUR_REPORT_REASON_IN_PLACE'),1,40);
59: G_REASON_SHORT CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
60: ('PO','PO_EUR_REPORT_REASON_SHORT'),1,40);
61: G_REASON_NOTHING CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
62: ('PO','PO_EUR_REPORT_REASON_NOTHING'),1,40);
63: G_REASON_DIF_CUR CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
57: G_REASON_IN_PLACE CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
58: ('PO','PO_EUR_REPORT_REASON_IN_PLACE'),1,40);
59: G_REASON_SHORT CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
60: ('PO','PO_EUR_REPORT_REASON_SHORT'),1,40);
61: G_REASON_NOTHING CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
62: ('PO','PO_EUR_REPORT_REASON_NOTHING'),1,40);
63: G_REASON_DIF_CUR CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
64: ('PO','PO_EUR_REPORT_REASON_DIF_CUR'),1,40);
65: G_REASON_EMU CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
59: G_REASON_SHORT CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
60: ('PO','PO_EUR_REPORT_REASON_SHORT'),1,40);
61: G_REASON_NOTHING CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
62: ('PO','PO_EUR_REPORT_REASON_NOTHING'),1,40);
63: G_REASON_DIF_CUR CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
64: ('PO','PO_EUR_REPORT_REASON_DIF_CUR'),1,40);
65: G_REASON_EMU CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
66: ('PO','PO_EUR_REPORT_REASON_EMU'),1,40);
67: G_REASON_DR_SHIP CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
61: G_REASON_NOTHING CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
62: ('PO','PO_EUR_REPORT_REASON_NOTHING'),1,40);
63: G_REASON_DIF_CUR CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
64: ('PO','PO_EUR_REPORT_REASON_DIF_CUR'),1,40);
65: G_REASON_EMU CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
66: ('PO','PO_EUR_REPORT_REASON_EMU'),1,40);
67: G_REASON_DR_SHIP CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
68: ('PO','PO_EUR_REPORT_REASON_DR_SHIP'),1,40);
69: G_REASON_ENC_ON CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
63: G_REASON_DIF_CUR CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
64: ('PO','PO_EUR_REPORT_REASON_DIF_CUR'),1,40);
65: G_REASON_EMU CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
66: ('PO','PO_EUR_REPORT_REASON_EMU'),1,40);
67: G_REASON_DR_SHIP CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
68: ('PO','PO_EUR_REPORT_REASON_DR_SHIP'),1,40);
69: G_REASON_ENC_ON CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
70: ('PO','PO_EUR_REPORT_REASON_ENC_ON'),1,40);
71: G_REASON_PROJECT CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
65: G_REASON_EMU CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
66: ('PO','PO_EUR_REPORT_REASON_EMU'),1,40);
67: G_REASON_DR_SHIP CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
68: ('PO','PO_EUR_REPORT_REASON_DR_SHIP'),1,40);
69: G_REASON_ENC_ON CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
70: ('PO','PO_EUR_REPORT_REASON_ENC_ON'),1,40);
71: G_REASON_PROJECT CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
72: ('PO','PO_EUR_REPORT_REASON_PROJECT'),1,40);
73: G_REASON_RATE CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
67: G_REASON_DR_SHIP CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
68: ('PO','PO_EUR_REPORT_REASON_DR_SHIP'),1,40);
69: G_REASON_ENC_ON CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
70: ('PO','PO_EUR_REPORT_REASON_ENC_ON'),1,40);
71: G_REASON_PROJECT CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
72: ('PO','PO_EUR_REPORT_REASON_PROJECT'),1,40);
73: G_REASON_RATE CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
74: ('PO','PO_EUR_REPORT_REASON_RATE'),1,40);
75: G_REASON_MAN_NUM CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
69: G_REASON_ENC_ON CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
70: ('PO','PO_EUR_REPORT_REASON_ENC_ON'),1,40);
71: G_REASON_PROJECT CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
72: ('PO','PO_EUR_REPORT_REASON_PROJECT'),1,40);
73: G_REASON_RATE CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
74: ('PO','PO_EUR_REPORT_REASON_RATE'),1,40);
75: G_REASON_MAN_NUM CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
76: ('PO','PO_EUR_REPORT_REASON_MAN_NUM'),1,40);
77: --
71: G_REASON_PROJECT CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
72: ('PO','PO_EUR_REPORT_REASON_PROJECT'),1,40);
73: G_REASON_RATE CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
74: ('PO','PO_EUR_REPORT_REASON_RATE'),1,40);
75: G_REASON_MAN_NUM CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string
76: ('PO','PO_EUR_REPORT_REASON_MAN_NUM'),1,40);
77: --
78: G_RPT_PAGE_COL CONSTANT INTEGER :=130;
79: G_FORMAT_SPACE CONSTANT INTEGER :=2;