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.OE_PRINT_FLEX dependencies on OE_DEBUG_PUB

Line 16: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

12:
13: g_valid_structure boolean;
14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_PRINT_FLEX';
15: G_FUNCTION_NAME CONSTANT VARCHAR2(30) := 'GET_FLEXDESC';
16: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
17:
18:
19: FUNCTION get_flexdesc(
20: p_appl_short_name IN varchar2 ,

Line 59: oe_debug_pub.add('START: '||G_PKG_NAME||':'||G_FUNCTION_NAME);

55: IF p_context_reset_flag = 'Y' THEN
56: g_valid_structure := FALSE;
57: END IF;
58: IF l_debug_level > 0 THEN
59: oe_debug_pub.add('START: '||G_PKG_NAME||':'||G_FUNCTION_NAME);
60: oe_debug_pub.add('-----------------------------------------------');
61: oe_debug_pub.add('appl_short_name = ' || p_appl_short_name);
62: oe_debug_pub.add('desc_flex_name = ' || p_desc_flex_name);
63: oe_debug_pub.add('values_or_ids = ' || p_values_or_ids);

Line 60: oe_debug_pub.add('-----------------------------------------------');

56: g_valid_structure := FALSE;
57: END IF;
58: IF l_debug_level > 0 THEN
59: oe_debug_pub.add('START: '||G_PKG_NAME||':'||G_FUNCTION_NAME);
60: oe_debug_pub.add('-----------------------------------------------');
61: oe_debug_pub.add('appl_short_name = ' || p_appl_short_name);
62: oe_debug_pub.add('desc_flex_name = ' || p_desc_flex_name);
63: oe_debug_pub.add('values_or_ids = ' || p_values_or_ids);
64: oe_debug_pub.add('validation_date = ' || p_validation_date);

Line 61: oe_debug_pub.add('appl_short_name = ' || p_appl_short_name);

57: END IF;
58: IF l_debug_level > 0 THEN
59: oe_debug_pub.add('START: '||G_PKG_NAME||':'||G_FUNCTION_NAME);
60: oe_debug_pub.add('-----------------------------------------------');
61: oe_debug_pub.add('appl_short_name = ' || p_appl_short_name);
62: oe_debug_pub.add('desc_flex_name = ' || p_desc_flex_name);
63: oe_debug_pub.add('values_or_ids = ' || p_values_or_ids);
64: oe_debug_pub.add('validation_date = ' || p_validation_date);
65: oe_debug_pub.add('p_validation_date = '||p_validation_date);

Line 62: oe_debug_pub.add('desc_flex_name = ' || p_desc_flex_name);

58: IF l_debug_level > 0 THEN
59: oe_debug_pub.add('START: '||G_PKG_NAME||':'||G_FUNCTION_NAME);
60: oe_debug_pub.add('-----------------------------------------------');
61: oe_debug_pub.add('appl_short_name = ' || p_appl_short_name);
62: oe_debug_pub.add('desc_flex_name = ' || p_desc_flex_name);
63: oe_debug_pub.add('values_or_ids = ' || p_values_or_ids);
64: oe_debug_pub.add('validation_date = ' || p_validation_date);
65: oe_debug_pub.add('p_validation_date = '||p_validation_date);
66: oe_debug_pub.add('p_context = '||p_context);

Line 63: oe_debug_pub.add('values_or_ids = ' || p_values_or_ids);

59: oe_debug_pub.add('START: '||G_PKG_NAME||':'||G_FUNCTION_NAME);
60: oe_debug_pub.add('-----------------------------------------------');
61: oe_debug_pub.add('appl_short_name = ' || p_appl_short_name);
62: oe_debug_pub.add('desc_flex_name = ' || p_desc_flex_name);
63: oe_debug_pub.add('values_or_ids = ' || p_values_or_ids);
64: oe_debug_pub.add('validation_date = ' || p_validation_date);
65: oe_debug_pub.add('p_validation_date = '||p_validation_date);
66: oe_debug_pub.add('p_context = '||p_context);
67: oe_debug_pub.add('p_attribute1 = ' ||p_attribute1);

Line 64: oe_debug_pub.add('validation_date = ' || p_validation_date);

60: oe_debug_pub.add('-----------------------------------------------');
61: oe_debug_pub.add('appl_short_name = ' || p_appl_short_name);
62: oe_debug_pub.add('desc_flex_name = ' || p_desc_flex_name);
63: oe_debug_pub.add('values_or_ids = ' || p_values_or_ids);
64: oe_debug_pub.add('validation_date = ' || p_validation_date);
65: oe_debug_pub.add('p_validation_date = '||p_validation_date);
66: oe_debug_pub.add('p_context = '||p_context);
67: oe_debug_pub.add('p_attribute1 = ' ||p_attribute1);
68: oe_debug_pub.add('p_attribute2 = ' ||p_attribute2);

Line 65: oe_debug_pub.add('p_validation_date = '||p_validation_date);

61: oe_debug_pub.add('appl_short_name = ' || p_appl_short_name);
62: oe_debug_pub.add('desc_flex_name = ' || p_desc_flex_name);
63: oe_debug_pub.add('values_or_ids = ' || p_values_or_ids);
64: oe_debug_pub.add('validation_date = ' || p_validation_date);
65: oe_debug_pub.add('p_validation_date = '||p_validation_date);
66: oe_debug_pub.add('p_context = '||p_context);
67: oe_debug_pub.add('p_attribute1 = ' ||p_attribute1);
68: oe_debug_pub.add('p_attribute2 = ' ||p_attribute2);
69: oe_debug_pub.add('p_attribute3 = ' ||p_attribute3);

Line 66: oe_debug_pub.add('p_context = '||p_context);

62: oe_debug_pub.add('desc_flex_name = ' || p_desc_flex_name);
63: oe_debug_pub.add('values_or_ids = ' || p_values_or_ids);
64: oe_debug_pub.add('validation_date = ' || p_validation_date);
65: oe_debug_pub.add('p_validation_date = '||p_validation_date);
66: oe_debug_pub.add('p_context = '||p_context);
67: oe_debug_pub.add('p_attribute1 = ' ||p_attribute1);
68: oe_debug_pub.add('p_attribute2 = ' ||p_attribute2);
69: oe_debug_pub.add('p_attribute3 = ' ||p_attribute3);
70: oe_debug_pub.add('p_attribute4 = ' ||p_attribute4);

Line 67: oe_debug_pub.add('p_attribute1 = ' ||p_attribute1);

63: oe_debug_pub.add('values_or_ids = ' || p_values_or_ids);
64: oe_debug_pub.add('validation_date = ' || p_validation_date);
65: oe_debug_pub.add('p_validation_date = '||p_validation_date);
66: oe_debug_pub.add('p_context = '||p_context);
67: oe_debug_pub.add('p_attribute1 = ' ||p_attribute1);
68: oe_debug_pub.add('p_attribute2 = ' ||p_attribute2);
69: oe_debug_pub.add('p_attribute3 = ' ||p_attribute3);
70: oe_debug_pub.add('p_attribute4 = ' ||p_attribute4);
71: oe_debug_pub.add('p_attribute5 = ' ||p_attribute5);

Line 68: oe_debug_pub.add('p_attribute2 = ' ||p_attribute2);

64: oe_debug_pub.add('validation_date = ' || p_validation_date);
65: oe_debug_pub.add('p_validation_date = '||p_validation_date);
66: oe_debug_pub.add('p_context = '||p_context);
67: oe_debug_pub.add('p_attribute1 = ' ||p_attribute1);
68: oe_debug_pub.add('p_attribute2 = ' ||p_attribute2);
69: oe_debug_pub.add('p_attribute3 = ' ||p_attribute3);
70: oe_debug_pub.add('p_attribute4 = ' ||p_attribute4);
71: oe_debug_pub.add('p_attribute5 = ' ||p_attribute5);
72: oe_debug_pub.add('p_attribute6 = ' ||p_attribute6);

Line 69: oe_debug_pub.add('p_attribute3 = ' ||p_attribute3);

65: oe_debug_pub.add('p_validation_date = '||p_validation_date);
66: oe_debug_pub.add('p_context = '||p_context);
67: oe_debug_pub.add('p_attribute1 = ' ||p_attribute1);
68: oe_debug_pub.add('p_attribute2 = ' ||p_attribute2);
69: oe_debug_pub.add('p_attribute3 = ' ||p_attribute3);
70: oe_debug_pub.add('p_attribute4 = ' ||p_attribute4);
71: oe_debug_pub.add('p_attribute5 = ' ||p_attribute5);
72: oe_debug_pub.add('p_attribute6 = ' ||p_attribute6);
73: oe_debug_pub.add('p_attribute7 = ' ||p_attribute7);

Line 70: oe_debug_pub.add('p_attribute4 = ' ||p_attribute4);

66: oe_debug_pub.add('p_context = '||p_context);
67: oe_debug_pub.add('p_attribute1 = ' ||p_attribute1);
68: oe_debug_pub.add('p_attribute2 = ' ||p_attribute2);
69: oe_debug_pub.add('p_attribute3 = ' ||p_attribute3);
70: oe_debug_pub.add('p_attribute4 = ' ||p_attribute4);
71: oe_debug_pub.add('p_attribute5 = ' ||p_attribute5);
72: oe_debug_pub.add('p_attribute6 = ' ||p_attribute6);
73: oe_debug_pub.add('p_attribute7 = ' ||p_attribute7);
74: oe_debug_pub.add('p_attribute8 = ' ||p_attribute8);

Line 71: oe_debug_pub.add('p_attribute5 = ' ||p_attribute5);

67: oe_debug_pub.add('p_attribute1 = ' ||p_attribute1);
68: oe_debug_pub.add('p_attribute2 = ' ||p_attribute2);
69: oe_debug_pub.add('p_attribute3 = ' ||p_attribute3);
70: oe_debug_pub.add('p_attribute4 = ' ||p_attribute4);
71: oe_debug_pub.add('p_attribute5 = ' ||p_attribute5);
72: oe_debug_pub.add('p_attribute6 = ' ||p_attribute6);
73: oe_debug_pub.add('p_attribute7 = ' ||p_attribute7);
74: oe_debug_pub.add('p_attribute8 = ' ||p_attribute8);
75: oe_debug_pub.add('p_attribute9 = ' ||p_attribute9);

Line 72: oe_debug_pub.add('p_attribute6 = ' ||p_attribute6);

68: oe_debug_pub.add('p_attribute2 = ' ||p_attribute2);
69: oe_debug_pub.add('p_attribute3 = ' ||p_attribute3);
70: oe_debug_pub.add('p_attribute4 = ' ||p_attribute4);
71: oe_debug_pub.add('p_attribute5 = ' ||p_attribute5);
72: oe_debug_pub.add('p_attribute6 = ' ||p_attribute6);
73: oe_debug_pub.add('p_attribute7 = ' ||p_attribute7);
74: oe_debug_pub.add('p_attribute8 = ' ||p_attribute8);
75: oe_debug_pub.add('p_attribute9 = ' ||p_attribute9);
76: oe_debug_pub.add('p_attribute10= ' ||p_attribute10);

Line 73: oe_debug_pub.add('p_attribute7 = ' ||p_attribute7);

69: oe_debug_pub.add('p_attribute3 = ' ||p_attribute3);
70: oe_debug_pub.add('p_attribute4 = ' ||p_attribute4);
71: oe_debug_pub.add('p_attribute5 = ' ||p_attribute5);
72: oe_debug_pub.add('p_attribute6 = ' ||p_attribute6);
73: oe_debug_pub.add('p_attribute7 = ' ||p_attribute7);
74: oe_debug_pub.add('p_attribute8 = ' ||p_attribute8);
75: oe_debug_pub.add('p_attribute9 = ' ||p_attribute9);
76: oe_debug_pub.add('p_attribute10= ' ||p_attribute10);
77: oe_debug_pub.add('p_attribute11= ' ||p_attribute11);

Line 74: oe_debug_pub.add('p_attribute8 = ' ||p_attribute8);

70: oe_debug_pub.add('p_attribute4 = ' ||p_attribute4);
71: oe_debug_pub.add('p_attribute5 = ' ||p_attribute5);
72: oe_debug_pub.add('p_attribute6 = ' ||p_attribute6);
73: oe_debug_pub.add('p_attribute7 = ' ||p_attribute7);
74: oe_debug_pub.add('p_attribute8 = ' ||p_attribute8);
75: oe_debug_pub.add('p_attribute9 = ' ||p_attribute9);
76: oe_debug_pub.add('p_attribute10= ' ||p_attribute10);
77: oe_debug_pub.add('p_attribute11= ' ||p_attribute11);
78: oe_debug_pub.add('p_attribute12= ' ||p_attribute12);

Line 75: oe_debug_pub.add('p_attribute9 = ' ||p_attribute9);

71: oe_debug_pub.add('p_attribute5 = ' ||p_attribute5);
72: oe_debug_pub.add('p_attribute6 = ' ||p_attribute6);
73: oe_debug_pub.add('p_attribute7 = ' ||p_attribute7);
74: oe_debug_pub.add('p_attribute8 = ' ||p_attribute8);
75: oe_debug_pub.add('p_attribute9 = ' ||p_attribute9);
76: oe_debug_pub.add('p_attribute10= ' ||p_attribute10);
77: oe_debug_pub.add('p_attribute11= ' ||p_attribute11);
78: oe_debug_pub.add('p_attribute12= ' ||p_attribute12);
79: oe_debug_pub.add('p_attribute13= ' ||p_attribute13);

Line 76: oe_debug_pub.add('p_attribute10= ' ||p_attribute10);

72: oe_debug_pub.add('p_attribute6 = ' ||p_attribute6);
73: oe_debug_pub.add('p_attribute7 = ' ||p_attribute7);
74: oe_debug_pub.add('p_attribute8 = ' ||p_attribute8);
75: oe_debug_pub.add('p_attribute9 = ' ||p_attribute9);
76: oe_debug_pub.add('p_attribute10= ' ||p_attribute10);
77: oe_debug_pub.add('p_attribute11= ' ||p_attribute11);
78: oe_debug_pub.add('p_attribute12= ' ||p_attribute12);
79: oe_debug_pub.add('p_attribute13= ' ||p_attribute13);
80: oe_debug_pub.add('p_attribute14= ' ||p_attribute14);

Line 77: oe_debug_pub.add('p_attribute11= ' ||p_attribute11);

73: oe_debug_pub.add('p_attribute7 = ' ||p_attribute7);
74: oe_debug_pub.add('p_attribute8 = ' ||p_attribute8);
75: oe_debug_pub.add('p_attribute9 = ' ||p_attribute9);
76: oe_debug_pub.add('p_attribute10= ' ||p_attribute10);
77: oe_debug_pub.add('p_attribute11= ' ||p_attribute11);
78: oe_debug_pub.add('p_attribute12= ' ||p_attribute12);
79: oe_debug_pub.add('p_attribute13= ' ||p_attribute13);
80: oe_debug_pub.add('p_attribute14= ' ||p_attribute14);
81: oe_debug_pub.add('p_attribute15= ' ||p_attribute15);

Line 78: oe_debug_pub.add('p_attribute12= ' ||p_attribute12);

74: oe_debug_pub.add('p_attribute8 = ' ||p_attribute8);
75: oe_debug_pub.add('p_attribute9 = ' ||p_attribute9);
76: oe_debug_pub.add('p_attribute10= ' ||p_attribute10);
77: oe_debug_pub.add('p_attribute11= ' ||p_attribute11);
78: oe_debug_pub.add('p_attribute12= ' ||p_attribute12);
79: oe_debug_pub.add('p_attribute13= ' ||p_attribute13);
80: oe_debug_pub.add('p_attribute14= ' ||p_attribute14);
81: oe_debug_pub.add('p_attribute15= ' ||p_attribute15);
82: oe_debug_pub.add('p_attribute16= ' ||p_attribute16);

Line 79: oe_debug_pub.add('p_attribute13= ' ||p_attribute13);

75: oe_debug_pub.add('p_attribute9 = ' ||p_attribute9);
76: oe_debug_pub.add('p_attribute10= ' ||p_attribute10);
77: oe_debug_pub.add('p_attribute11= ' ||p_attribute11);
78: oe_debug_pub.add('p_attribute12= ' ||p_attribute12);
79: oe_debug_pub.add('p_attribute13= ' ||p_attribute13);
80: oe_debug_pub.add('p_attribute14= ' ||p_attribute14);
81: oe_debug_pub.add('p_attribute15= ' ||p_attribute15);
82: oe_debug_pub.add('p_attribute16= ' ||p_attribute16);
83: oe_debug_pub.add('p_attribute17= ' ||p_attribute17);

Line 80: oe_debug_pub.add('p_attribute14= ' ||p_attribute14);

76: oe_debug_pub.add('p_attribute10= ' ||p_attribute10);
77: oe_debug_pub.add('p_attribute11= ' ||p_attribute11);
78: oe_debug_pub.add('p_attribute12= ' ||p_attribute12);
79: oe_debug_pub.add('p_attribute13= ' ||p_attribute13);
80: oe_debug_pub.add('p_attribute14= ' ||p_attribute14);
81: oe_debug_pub.add('p_attribute15= ' ||p_attribute15);
82: oe_debug_pub.add('p_attribute16= ' ||p_attribute16);
83: oe_debug_pub.add('p_attribute17= ' ||p_attribute17);
84: oe_debug_pub.add('p_attribute18= ' ||p_attribute18);

Line 81: oe_debug_pub.add('p_attribute15= ' ||p_attribute15);

77: oe_debug_pub.add('p_attribute11= ' ||p_attribute11);
78: oe_debug_pub.add('p_attribute12= ' ||p_attribute12);
79: oe_debug_pub.add('p_attribute13= ' ||p_attribute13);
80: oe_debug_pub.add('p_attribute14= ' ||p_attribute14);
81: oe_debug_pub.add('p_attribute15= ' ||p_attribute15);
82: oe_debug_pub.add('p_attribute16= ' ||p_attribute16);
83: oe_debug_pub.add('p_attribute17= ' ||p_attribute17);
84: oe_debug_pub.add('p_attribute18= ' ||p_attribute18);
85: oe_debug_pub.add('p_attribute19= ' ||p_attribute19);

Line 82: oe_debug_pub.add('p_attribute16= ' ||p_attribute16);

78: oe_debug_pub.add('p_attribute12= ' ||p_attribute12);
79: oe_debug_pub.add('p_attribute13= ' ||p_attribute13);
80: oe_debug_pub.add('p_attribute14= ' ||p_attribute14);
81: oe_debug_pub.add('p_attribute15= ' ||p_attribute15);
82: oe_debug_pub.add('p_attribute16= ' ||p_attribute16);
83: oe_debug_pub.add('p_attribute17= ' ||p_attribute17);
84: oe_debug_pub.add('p_attribute18= ' ||p_attribute18);
85: oe_debug_pub.add('p_attribute19= ' ||p_attribute19);
86: oe_debug_pub.add('p_attribute20= ' ||p_attribute20);

Line 83: oe_debug_pub.add('p_attribute17= ' ||p_attribute17);

79: oe_debug_pub.add('p_attribute13= ' ||p_attribute13);
80: oe_debug_pub.add('p_attribute14= ' ||p_attribute14);
81: oe_debug_pub.add('p_attribute15= ' ||p_attribute15);
82: oe_debug_pub.add('p_attribute16= ' ||p_attribute16);
83: oe_debug_pub.add('p_attribute17= ' ||p_attribute17);
84: oe_debug_pub.add('p_attribute18= ' ||p_attribute18);
85: oe_debug_pub.add('p_attribute19= ' ||p_attribute19);
86: oe_debug_pub.add('p_attribute20= ' ||p_attribute20);
87: oe_debug_pub.add('p_value = ' ||p_value);

Line 84: oe_debug_pub.add('p_attribute18= ' ||p_attribute18);

80: oe_debug_pub.add('p_attribute14= ' ||p_attribute14);
81: oe_debug_pub.add('p_attribute15= ' ||p_attribute15);
82: oe_debug_pub.add('p_attribute16= ' ||p_attribute16);
83: oe_debug_pub.add('p_attribute17= ' ||p_attribute17);
84: oe_debug_pub.add('p_attribute18= ' ||p_attribute18);
85: oe_debug_pub.add('p_attribute19= ' ||p_attribute19);
86: oe_debug_pub.add('p_attribute20= ' ||p_attribute20);
87: oe_debug_pub.add('p_value = ' ||p_value);
88: oe_debug_pub.add('p_segment_number = ' ||p_segment_number);

Line 85: oe_debug_pub.add('p_attribute19= ' ||p_attribute19);

81: oe_debug_pub.add('p_attribute15= ' ||p_attribute15);
82: oe_debug_pub.add('p_attribute16= ' ||p_attribute16);
83: oe_debug_pub.add('p_attribute17= ' ||p_attribute17);
84: oe_debug_pub.add('p_attribute18= ' ||p_attribute18);
85: oe_debug_pub.add('p_attribute19= ' ||p_attribute19);
86: oe_debug_pub.add('p_attribute20= ' ||p_attribute20);
87: oe_debug_pub.add('p_value = ' ||p_value);
88: oe_debug_pub.add('p_segment_number = ' ||p_segment_number);
89: oe_debug_pub.add('-----------------------------------------------');

Line 86: oe_debug_pub.add('p_attribute20= ' ||p_attribute20);

82: oe_debug_pub.add('p_attribute16= ' ||p_attribute16);
83: oe_debug_pub.add('p_attribute17= ' ||p_attribute17);
84: oe_debug_pub.add('p_attribute18= ' ||p_attribute18);
85: oe_debug_pub.add('p_attribute19= ' ||p_attribute19);
86: oe_debug_pub.add('p_attribute20= ' ||p_attribute20);
87: oe_debug_pub.add('p_value = ' ||p_value);
88: oe_debug_pub.add('p_segment_number = ' ||p_segment_number);
89: oe_debug_pub.add('-----------------------------------------------');
90: END IF;

Line 87: oe_debug_pub.add('p_value = ' ||p_value);

83: oe_debug_pub.add('p_attribute17= ' ||p_attribute17);
84: oe_debug_pub.add('p_attribute18= ' ||p_attribute18);
85: oe_debug_pub.add('p_attribute19= ' ||p_attribute19);
86: oe_debug_pub.add('p_attribute20= ' ||p_attribute20);
87: oe_debug_pub.add('p_value = ' ||p_value);
88: oe_debug_pub.add('p_segment_number = ' ||p_segment_number);
89: oe_debug_pub.add('-----------------------------------------------');
90: END IF;
91:

Line 88: oe_debug_pub.add('p_segment_number = ' ||p_segment_number);

84: oe_debug_pub.add('p_attribute18= ' ||p_attribute18);
85: oe_debug_pub.add('p_attribute19= ' ||p_attribute19);
86: oe_debug_pub.add('p_attribute20= ' ||p_attribute20);
87: oe_debug_pub.add('p_value = ' ||p_value);
88: oe_debug_pub.add('p_segment_number = ' ||p_segment_number);
89: oe_debug_pub.add('-----------------------------------------------');
90: END IF;
91:
92: IF NOT g_valid_structure THEN

Line 89: oe_debug_pub.add('-----------------------------------------------');

85: oe_debug_pub.add('p_attribute19= ' ||p_attribute19);
86: oe_debug_pub.add('p_attribute20= ' ||p_attribute20);
87: oe_debug_pub.add('p_value = ' ||p_value);
88: oe_debug_pub.add('p_segment_number = ' ||p_segment_number);
89: oe_debug_pub.add('-----------------------------------------------');
90: END IF;
91:
92: IF NOT g_valid_structure THEN
93:

Line 98: oe_debug_pub.add('About to set the context');

94: --===============================
95: -- set the context value
96: --===============================
97: IF l_debug_level > 0 THEN
98: oe_debug_pub.add('About to set the context');
99: END IF;
100: FND_FLEX_DESCVAL.set_context_value(p_context);
101: IF l_debug_level > 0 THEN
102: oe_debug_pub.add('set the context success');

Line 102: oe_debug_pub.add('set the context success');

98: oe_debug_pub.add('About to set the context');
99: END IF;
100: FND_FLEX_DESCVAL.set_context_value(p_context);
101: IF l_debug_level > 0 THEN
102: oe_debug_pub.add('set the context success');
103: END IF;
104:
105:
106: --===============================

Line 111: oe_debug_pub.add('About to set the column values');

107: -- set column values for the Attributes
108: --===============================
109:
110: IF l_debug_level > 0 THEN
111: oe_debug_pub.add('About to set the column values');
112: END IF;
113: fnd_flex_descval.set_column_value('ATTRIBUTE1',p_attribute1);
114: fnd_flex_descval.set_column_value('ATTRIBUTE2',p_attribute2);
115: fnd_flex_descval.set_column_value('ATTRIBUTE3',p_attribute3);

Line 134: oe_debug_pub.add('set the column values - success');

130: fnd_flex_descval.set_column_value('ATTRIBUTE18',p_attribute18);
131: fnd_flex_descval.set_column_value('ATTRIBUTE19',p_attribute19);
132: fnd_flex_descval.set_column_value('ATTRIBUTE20',p_attribute20);
133: IF l_debug_level > 0 THEN
134: oe_debug_pub.add('set the column values - success');
135: END IF;
136:
137: IF l_debug_level > 0 THEN
138: oe_debug_pub.add('***********************************************');

Line 138: oe_debug_pub.add('***********************************************');

134: oe_debug_pub.add('set the column values - success');
135: END IF;
136:
137: IF l_debug_level > 0 THEN
138: oe_debug_pub.add('***********************************************');
139: oe_debug_pub.add('Calling FND_FLEX_DESCVAL.validate_desccols with:');
140: oe_debug_pub.add('appl_short_name = ' || p_appl_short_name);
141: oe_debug_pub.add('desc_flex_name = ' || p_desc_flex_name);
142: oe_debug_pub.add('values_or_ids = ' || p_values_or_ids);

Line 139: oe_debug_pub.add('Calling FND_FLEX_DESCVAL.validate_desccols with:');

135: END IF;
136:
137: IF l_debug_level > 0 THEN
138: oe_debug_pub.add('***********************************************');
139: oe_debug_pub.add('Calling FND_FLEX_DESCVAL.validate_desccols with:');
140: oe_debug_pub.add('appl_short_name = ' || p_appl_short_name);
141: oe_debug_pub.add('desc_flex_name = ' || p_desc_flex_name);
142: oe_debug_pub.add('values_or_ids = ' || p_values_or_ids);
143: oe_debug_pub.add('validation_date = ' || p_validation_date);

Line 140: oe_debug_pub.add('appl_short_name = ' || p_appl_short_name);

136:
137: IF l_debug_level > 0 THEN
138: oe_debug_pub.add('***********************************************');
139: oe_debug_pub.add('Calling FND_FLEX_DESCVAL.validate_desccols with:');
140: oe_debug_pub.add('appl_short_name = ' || p_appl_short_name);
141: oe_debug_pub.add('desc_flex_name = ' || p_desc_flex_name);
142: oe_debug_pub.add('values_or_ids = ' || p_values_or_ids);
143: oe_debug_pub.add('validation_date = ' || p_validation_date);
144: oe_debug_pub.add('***********************************************');

Line 141: oe_debug_pub.add('desc_flex_name = ' || p_desc_flex_name);

137: IF l_debug_level > 0 THEN
138: oe_debug_pub.add('***********************************************');
139: oe_debug_pub.add('Calling FND_FLEX_DESCVAL.validate_desccols with:');
140: oe_debug_pub.add('appl_short_name = ' || p_appl_short_name);
141: oe_debug_pub.add('desc_flex_name = ' || p_desc_flex_name);
142: oe_debug_pub.add('values_or_ids = ' || p_values_or_ids);
143: oe_debug_pub.add('validation_date = ' || p_validation_date);
144: oe_debug_pub.add('***********************************************');
145: END IF;

Line 142: oe_debug_pub.add('values_or_ids = ' || p_values_or_ids);

138: oe_debug_pub.add('***********************************************');
139: oe_debug_pub.add('Calling FND_FLEX_DESCVAL.validate_desccols with:');
140: oe_debug_pub.add('appl_short_name = ' || p_appl_short_name);
141: oe_debug_pub.add('desc_flex_name = ' || p_desc_flex_name);
142: oe_debug_pub.add('values_or_ids = ' || p_values_or_ids);
143: oe_debug_pub.add('validation_date = ' || p_validation_date);
144: oe_debug_pub.add('***********************************************');
145: END IF;
146:

Line 143: oe_debug_pub.add('validation_date = ' || p_validation_date);

139: oe_debug_pub.add('Calling FND_FLEX_DESCVAL.validate_desccols with:');
140: oe_debug_pub.add('appl_short_name = ' || p_appl_short_name);
141: oe_debug_pub.add('desc_flex_name = ' || p_desc_flex_name);
142: oe_debug_pub.add('values_or_ids = ' || p_values_or_ids);
143: oe_debug_pub.add('validation_date = ' || p_validation_date);
144: oe_debug_pub.add('***********************************************');
145: END IF;
146:
147: g_valid_structure := FND_FLEX_DESCVAL.validate_desccols(

Line 144: oe_debug_pub.add('***********************************************');

140: oe_debug_pub.add('appl_short_name = ' || p_appl_short_name);
141: oe_debug_pub.add('desc_flex_name = ' || p_desc_flex_name);
142: oe_debug_pub.add('values_or_ids = ' || p_values_or_ids);
143: oe_debug_pub.add('validation_date = ' || p_validation_date);
144: oe_debug_pub.add('***********************************************');
145: END IF;
146:
147: g_valid_structure := FND_FLEX_DESCVAL.validate_desccols(
148: p_appl_short_name,

Line 155: oe_debug_pub.add('structure validated successfully');

151: p_validation_date);
152:
153: IF g_valid_structure THEN
154: IF l_debug_level > 0 THEN
155: oe_debug_pub.add('structure validated successfully');
156: END IF;
157: ELSE
158: IF l_debug_level > 0 THEN
159: oe_debug_pub.add('structure validation failed');

Line 159: oe_debug_pub.add('structure validation failed');

155: oe_debug_pub.add('structure validated successfully');
156: END IF;
157: ELSE
158: IF l_debug_level > 0 THEN
159: oe_debug_pub.add('structure validation failed');
160: END IF;
161: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_FLEXFIELD_STRUCT');
162: FND_MESSAGE.SET_TOKEN('FFSTRUCTURE',p_desc_flex_name);
163: OE_MSG_PUB.Add;

Line 172: oe_debug_pub.add('segment number = '||p_segment_number);

168:
169: IF (p_value = 'D' AND g_valid_structure) THEN
170:
171: IF l_debug_level > 0 THEN
172: oe_debug_pub.add('segment number = '||p_segment_number);
173: END IF;
174:
175: l_val_desc := FND_FLEX_DESCVAL.segment_description(p_segment_number);
176:

Line 178: oe_debug_pub.add('description = '||l_val_desc);

174:
175: l_val_desc := FND_FLEX_DESCVAL.segment_description(p_segment_number);
176:
177: IF l_debug_level > 0 THEN
178: oe_debug_pub.add('description = '||l_val_desc);
179: END IF;
180:
181: ELSIF (p_value = 'V' AND g_valid_structure) THEN
182:

Line 186: oe_debug_pub.add('value = '||l_val_desc);

182:
183: l_val_desc := FND_FLEX_DESCVAL.segment_value(p_segment_number);
184:
185: IF l_debug_level > 0 THEN
186: oe_debug_pub.add('value = '||l_val_desc);
187: END IF;
188:
189: END IF;
190:

Line 193: oe_debug_pub.add('returning the values');

189: END IF;
190:
191:
192: IF l_debug_level > 0 THEN
193: oe_debug_pub.add('returning the values');
194: oe_debug_pub.add('END: '||G_PKG_NAME||':'||G_FUNCTION_NAME);
195: END IF;
196:
197: Return(l_val_desc);

Line 194: oe_debug_pub.add('END: '||G_PKG_NAME||':'||G_FUNCTION_NAME);

190:
191:
192: IF l_debug_level > 0 THEN
193: oe_debug_pub.add('returning the values');
194: oe_debug_pub.add('END: '||G_PKG_NAME||':'||G_FUNCTION_NAME);
195: END IF;
196:
197: Return(l_val_desc);
198:

Line 206: oe_debug_pub.add('In the exception section');

202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203:
204: WHEN OTHERS THEN
205: IF l_debug_level > 0 THEN
206: oe_debug_pub.add('In the exception section');
207: END IF;
208: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
209: THEN
210: OE_MSG_PUB.Add_Exc_Msg