DBA Data[Home] [Help]

APPS.PO_MGD_EURO_REPORT_GEN dependencies on FND_MESSAGE

Line 19: --| substr FND_MESSAGES to prevent errors |

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:

Line 30: G_OBJECT_TYPE_VENDOR CONSTANT VARCHAR2(60):=SUBSTRB(FND_MESSAGE.get_string

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

Line 32: G_OBJECT_TYPE_VSITE 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

Line 34: G_OBJECT_TYPE_VBANK 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: --

Line 36: G_OBJECT_TYPE_PO CONSTANT VARCHAR2(60):=SUBSTRB(FND_MESSAGE.get_string

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);

Line 39: G_ACTION_CONV CONSTANT VARCHAR2(15):=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);
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

Line 41: G_ACTION_IGNORE 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

Line 43: G_ACTION_COPY CONSTANT VARCHAR2(15):=SUBSTRB(FND_MESSAGE.get_string

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.

Line 49: G_REASON_EURO CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string

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

Line 51: G_REASON_PARTIAL 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

Line 53: G_REASON_MANUAL 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

Line 55: G_REASON_CONTRACT 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

Line 57: G_REASON_IN_PLACE 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

Line 59: G_REASON_SHORT 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

Line 61: G_REASON_NOTHING 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

Line 63: G_REASON_DIF_CUR 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

Line 65: G_REASON_EMU 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

Line 67: G_REASON_DR_SHIP 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

Line 69: G_REASON_ENC_ON 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

Line 71: G_REASON_PROJECT 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

Line 73: G_REASON_RATE 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: --

Line 75: G_REASON_MAN_NUM CONSTANT VARCHAR2(40):=SUBSTRB(FND_MESSAGE.get_string

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;