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.ASO_LINE_NUM_INT dependencies on ASO_DEBUG_PUB

Line 28: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

24:
25: PROCEDURE RESET_LINE_NUM is
26: BEGIN
27:
28: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
29:
30: IF aso_debug_pub.g_debug_flag = 'Y' THEN
31: aso_debug_pub.add('Inside RESET_LINE_NUM procedure');
32: END IF;

Line 30: IF aso_debug_pub.g_debug_flag = 'Y' THEN

26: BEGIN
27:
28: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
29:
30: IF aso_debug_pub.g_debug_flag = 'Y' THEN
31: aso_debug_pub.add('Inside RESET_LINE_NUM procedure');
32: END IF;
33:
34: l_top_group := 0;

Line 31: aso_debug_pub.add('Inside RESET_LINE_NUM procedure');

27:
28: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
29:
30: IF aso_debug_pub.g_debug_flag = 'Y' THEN
31: aso_debug_pub.add('Inside RESET_LINE_NUM procedure');
32: END IF;
33:
34: l_top_group := 0;
35: l_cmp_group := 0;

Line 63: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

59: FROM ASO_PVT_QUOTE_LINES_BALI_V
60: WHERE quote_header_id = p_quote_header_id;
61:
62: BEGIN
63: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
64:
65: IF aso_debug_pub.g_debug_flag = 'Y' THEN
66: aso_debug_pub.add('P_In_Line_Number_Tbl.count: '||P_In_Line_Number_Tbl.count);
67: aso_debug_pub.add('Internal_Line_Number_Tbl.count: '||Internal_Line_Number_Tbl.count);

Line 65: IF aso_debug_pub.g_debug_flag = 'Y' THEN

61:
62: BEGIN
63: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
64:
65: IF aso_debug_pub.g_debug_flag = 'Y' THEN
66: aso_debug_pub.add('P_In_Line_Number_Tbl.count: '||P_In_Line_Number_Tbl.count);
67: aso_debug_pub.add('Internal_Line_Number_Tbl.count: '||Internal_Line_Number_Tbl.count);
68: END IF;
69:

Line 66: aso_debug_pub.add('P_In_Line_Number_Tbl.count: '||P_In_Line_Number_Tbl.count);

62: BEGIN
63: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
64:
65: IF aso_debug_pub.g_debug_flag = 'Y' THEN
66: aso_debug_pub.add('P_In_Line_Number_Tbl.count: '||P_In_Line_Number_Tbl.count);
67: aso_debug_pub.add('Internal_Line_Number_Tbl.count: '||Internal_Line_Number_Tbl.count);
68: END IF;
69:
70: IF Internal_Line_Number_Tbl.count = 0 THEN

Line 67: aso_debug_pub.add('Internal_Line_Number_Tbl.count: '||Internal_Line_Number_Tbl.count);

63: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
64:
65: IF aso_debug_pub.g_debug_flag = 'Y' THEN
66: aso_debug_pub.add('P_In_Line_Number_Tbl.count: '||P_In_Line_Number_Tbl.count);
67: aso_debug_pub.add('Internal_Line_Number_Tbl.count: '||Internal_Line_Number_Tbl.count);
68: END IF;
69:
70: IF Internal_Line_Number_Tbl.count = 0 THEN
71:

Line 81: IF aso_debug_pub.g_debug_flag = 'Y' THEN

77:
78: Internal_Line_Number_Tbl(row.quote_line_id) := row.ui_line_number;
79: X_Out_Line_Number_Tbl(row.quote_line_id) := row.ui_line_number;
80:
81: IF aso_debug_pub.g_debug_flag = 'Y' THEN
82:
83: aso_debug_pub.add('Inside IF cond Internal_Line_Number_Tbl('||row.quote_line_id||'): '||Internal_Line_Number_Tbl(row.quote_line_id));
84: aso_debug_pub.add('Inside IF cond X_Out_Line_Number_Tbl('||row.quote_line_id||'): '||X_Out_Line_Number_Tbl(row.quote_line_id));
85:

Line 83: aso_debug_pub.add('Inside IF cond Internal_Line_Number_Tbl('||row.quote_line_id||'): '||Internal_Line_Number_Tbl(row.quote_line_id));

79: X_Out_Line_Number_Tbl(row.quote_line_id) := row.ui_line_number;
80:
81: IF aso_debug_pub.g_debug_flag = 'Y' THEN
82:
83: aso_debug_pub.add('Inside IF cond Internal_Line_Number_Tbl('||row.quote_line_id||'): '||Internal_Line_Number_Tbl(row.quote_line_id));
84: aso_debug_pub.add('Inside IF cond X_Out_Line_Number_Tbl('||row.quote_line_id||'): '||X_Out_Line_Number_Tbl(row.quote_line_id));
85:
86: END IF;
87:

Line 84: aso_debug_pub.add('Inside IF cond X_Out_Line_Number_Tbl('||row.quote_line_id||'): '||X_Out_Line_Number_Tbl(row.quote_line_id));

80:
81: IF aso_debug_pub.g_debug_flag = 'Y' THEN
82:
83: aso_debug_pub.add('Inside IF cond Internal_Line_Number_Tbl('||row.quote_line_id||'): '||Internal_Line_Number_Tbl(row.quote_line_id));
84: aso_debug_pub.add('Inside IF cond X_Out_Line_Number_Tbl('||row.quote_line_id||'): '||X_Out_Line_Number_Tbl(row.quote_line_id));
85:
86: END IF;
87:
88: END LOOP;

Line 92: IF aso_debug_pub.g_debug_flag = 'Y' THEN

88: END LOOP;
89:
90: ELSE
91:
92: IF aso_debug_pub.g_debug_flag = 'Y' THEN
93: aso_debug_pub.add('Inside ELSE cond Internal_Line_Number_Tbl.count: '||Internal_Line_Number_Tbl.count);
94: END IF;
95:
96: FOR i IN 1..P_In_Line_Number_Tbl.Count LOOP

Line 93: aso_debug_pub.add('Inside ELSE cond Internal_Line_Number_Tbl.count: '||Internal_Line_Number_Tbl.count);

89:
90: ELSE
91:
92: IF aso_debug_pub.g_debug_flag = 'Y' THEN
93: aso_debug_pub.add('Inside ELSE cond Internal_Line_Number_Tbl.count: '||Internal_Line_Number_Tbl.count);
94: END IF;
95:
96: FOR i IN 1..P_In_Line_Number_Tbl.Count LOOP
97:

Line 100: IF aso_debug_pub.g_debug_flag = 'Y' THEN

96: FOR i IN 1..P_In_Line_Number_Tbl.Count LOOP
97:
98: X_Out_Line_Number_Tbl(P_In_Line_Number_Tbl(i).quote_line_id) := Internal_Line_Number_Tbl(P_In_Line_Number_Tbl(i).quote_line_id);
99:
100: IF aso_debug_pub.g_debug_flag = 'Y' THEN
101:
102: aso_debug_pub.add('Inside ELSE cond P_In_Line_Number_Tbl('||i||').quote_line_id: '||P_In_Line_Number_Tbl(i).quote_line_id );
103: aso_debug_pub.add('Inside ELSE cond X_Out_Line_Number_Tbl('||P_In_Line_Number_Tbl(i).quote_line_id||'): '||X_Out_Line_Number_Tbl(P_In_Line_Number_Tbl(i).quote_line_id));
104:

Line 102: aso_debug_pub.add('Inside ELSE cond P_In_Line_Number_Tbl('||i||').quote_line_id: '||P_In_Line_Number_Tbl(i).quote_line_id );

98: X_Out_Line_Number_Tbl(P_In_Line_Number_Tbl(i).quote_line_id) := Internal_Line_Number_Tbl(P_In_Line_Number_Tbl(i).quote_line_id);
99:
100: IF aso_debug_pub.g_debug_flag = 'Y' THEN
101:
102: aso_debug_pub.add('Inside ELSE cond P_In_Line_Number_Tbl('||i||').quote_line_id: '||P_In_Line_Number_Tbl(i).quote_line_id );
103: aso_debug_pub.add('Inside ELSE cond X_Out_Line_Number_Tbl('||P_In_Line_Number_Tbl(i).quote_line_id||'): '||X_Out_Line_Number_Tbl(P_In_Line_Number_Tbl(i).quote_line_id));
104:
105: END IF;
106:

Line 103: aso_debug_pub.add('Inside ELSE cond X_Out_Line_Number_Tbl('||P_In_Line_Number_Tbl(i).quote_line_id||'): '||X_Out_Line_Number_Tbl(P_In_Line_Number_Tbl(i).quote_line_id));

99:
100: IF aso_debug_pub.g_debug_flag = 'Y' THEN
101:
102: aso_debug_pub.add('Inside ELSE cond P_In_Line_Number_Tbl('||i||').quote_line_id: '||P_In_Line_Number_Tbl(i).quote_line_id );
103: aso_debug_pub.add('Inside ELSE cond X_Out_Line_Number_Tbl('||P_In_Line_Number_Tbl(i).quote_line_id||'): '||X_Out_Line_Number_Tbl(P_In_Line_Number_Tbl(i).quote_line_id));
104:
105: END IF;
106:
107: END LOOP;

Line 130: aso_debug_pub.SetDebugLevel(10);

126: begin
127: /*
128: if ( p_rownum = p_quote_line_id ) then
129:
130: aso_debug_pub.SetDebugLevel(10);
131: aso_debug_pub.G_DIR :='/sqlcom/crmeco/asodev/temp';
132: dbms_output.put_line('The File is'|| aso_debug_pub.Set_Debug_Mode('FILE'));
133: aso_debug_pub.Initialize;
134: aso_debug_pub.debug_on;

Line 131: aso_debug_pub.G_DIR :='/sqlcom/crmeco/asodev/temp';

127: /*
128: if ( p_rownum = p_quote_line_id ) then
129:
130: aso_debug_pub.SetDebugLevel(10);
131: aso_debug_pub.G_DIR :='/sqlcom/crmeco/asodev/temp';
132: dbms_output.put_line('The File is'|| aso_debug_pub.Set_Debug_Mode('FILE'));
133: aso_debug_pub.Initialize;
134: aso_debug_pub.debug_on;
135:

Line 132: dbms_output.put_line('The File is'|| aso_debug_pub.Set_Debug_Mode('FILE'));

128: if ( p_rownum = p_quote_line_id ) then
129:
130: aso_debug_pub.SetDebugLevel(10);
131: aso_debug_pub.G_DIR :='/sqlcom/crmeco/asodev/temp';
132: dbms_output.put_line('The File is'|| aso_debug_pub.Set_Debug_Mode('FILE'));
133: aso_debug_pub.Initialize;
134: aso_debug_pub.debug_on;
135:
136: l_top_group := 0;

Line 133: aso_debug_pub.Initialize;

129:
130: aso_debug_pub.SetDebugLevel(10);
131: aso_debug_pub.G_DIR :='/sqlcom/crmeco/asodev/temp';
132: dbms_output.put_line('The File is'|| aso_debug_pub.Set_Debug_Mode('FILE'));
133: aso_debug_pub.Initialize;
134: aso_debug_pub.debug_on;
135:
136: l_top_group := 0;
137: l_cmp_group := 0;

Line 134: aso_debug_pub.debug_on;

130: aso_debug_pub.SetDebugLevel(10);
131: aso_debug_pub.G_DIR :='/sqlcom/crmeco/asodev/temp';
132: dbms_output.put_line('The File is'|| aso_debug_pub.Set_Debug_Mode('FILE'));
133: aso_debug_pub.Initialize;
134: aso_debug_pub.debug_on;
135:
136: l_top_group := 0;
137: l_cmp_group := 0;
138: l_svc_group := 0;

Line 142: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

138: l_svc_group := 0;
139: end if;
140: */
141:
142: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
143:
144: IF aso_debug_pub.g_debug_flag = 'Y' THEN
145:
146: aso_debug_pub.add('p_item_type_code = ' || p_item_type_code,1,'Y');

Line 144: IF aso_debug_pub.g_debug_flag = 'Y' THEN

140: */
141:
142: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
143:
144: IF aso_debug_pub.g_debug_flag = 'Y' THEN
145:
146: aso_debug_pub.add('p_item_type_code = ' || p_item_type_code,1,'Y');
147: aso_debug_pub.add('p_serviceable_product_flag = ' || p_serviceable_product_flag,1,'Y');
148: aso_debug_pub.add('p_service_item_flag = ' || p_service_item_flag,1,'Y');

Line 146: aso_debug_pub.add('p_item_type_code = ' || p_item_type_code,1,'Y');

142: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
143:
144: IF aso_debug_pub.g_debug_flag = 'Y' THEN
145:
146: aso_debug_pub.add('p_item_type_code = ' || p_item_type_code,1,'Y');
147: aso_debug_pub.add('p_serviceable_product_flag = ' || p_serviceable_product_flag,1,'Y');
148: aso_debug_pub.add('p_service_item_flag = ' || p_service_item_flag,1,'Y');
149: aso_debug_pub.add('p_config_header_id = ' || p_config_header_id,1,'Y');
150: aso_debug_pub.add('p_config_revision_num = ' ||p_config_revision_num ,1,'Y');

Line 147: aso_debug_pub.add('p_serviceable_product_flag = ' || p_serviceable_product_flag,1,'Y');

143:
144: IF aso_debug_pub.g_debug_flag = 'Y' THEN
145:
146: aso_debug_pub.add('p_item_type_code = ' || p_item_type_code,1,'Y');
147: aso_debug_pub.add('p_serviceable_product_flag = ' || p_serviceable_product_flag,1,'Y');
148: aso_debug_pub.add('p_service_item_flag = ' || p_service_item_flag,1,'Y');
149: aso_debug_pub.add('p_config_header_id = ' || p_config_header_id,1,'Y');
150: aso_debug_pub.add('p_config_revision_num = ' ||p_config_revision_num ,1,'Y');
151: aso_debug_pub.add('p_quote_line_id = ' || p_quote_line_id,1,'Y');

Line 148: aso_debug_pub.add('p_service_item_flag = ' || p_service_item_flag,1,'Y');

144: IF aso_debug_pub.g_debug_flag = 'Y' THEN
145:
146: aso_debug_pub.add('p_item_type_code = ' || p_item_type_code,1,'Y');
147: aso_debug_pub.add('p_serviceable_product_flag = ' || p_serviceable_product_flag,1,'Y');
148: aso_debug_pub.add('p_service_item_flag = ' || p_service_item_flag,1,'Y');
149: aso_debug_pub.add('p_config_header_id = ' || p_config_header_id,1,'Y');
150: aso_debug_pub.add('p_config_revision_num = ' ||p_config_revision_num ,1,'Y');
151: aso_debug_pub.add('p_quote_line_id = ' || p_quote_line_id,1,'Y');
152:

Line 149: aso_debug_pub.add('p_config_header_id = ' || p_config_header_id,1,'Y');

145:
146: aso_debug_pub.add('p_item_type_code = ' || p_item_type_code,1,'Y');
147: aso_debug_pub.add('p_serviceable_product_flag = ' || p_serviceable_product_flag,1,'Y');
148: aso_debug_pub.add('p_service_item_flag = ' || p_service_item_flag,1,'Y');
149: aso_debug_pub.add('p_config_header_id = ' || p_config_header_id,1,'Y');
150: aso_debug_pub.add('p_config_revision_num = ' ||p_config_revision_num ,1,'Y');
151: aso_debug_pub.add('p_quote_line_id = ' || p_quote_line_id,1,'Y');
152:
153: END IF;

Line 150: aso_debug_pub.add('p_config_revision_num = ' ||p_config_revision_num ,1,'Y');

146: aso_debug_pub.add('p_item_type_code = ' || p_item_type_code,1,'Y');
147: aso_debug_pub.add('p_serviceable_product_flag = ' || p_serviceable_product_flag,1,'Y');
148: aso_debug_pub.add('p_service_item_flag = ' || p_service_item_flag,1,'Y');
149: aso_debug_pub.add('p_config_header_id = ' || p_config_header_id,1,'Y');
150: aso_debug_pub.add('p_config_revision_num = ' ||p_config_revision_num ,1,'Y');
151: aso_debug_pub.add('p_quote_line_id = ' || p_quote_line_id,1,'Y');
152:
153: END IF;
154:

Line 151: aso_debug_pub.add('p_quote_line_id = ' || p_quote_line_id,1,'Y');

147: aso_debug_pub.add('p_serviceable_product_flag = ' || p_serviceable_product_flag,1,'Y');
148: aso_debug_pub.add('p_service_item_flag = ' || p_service_item_flag,1,'Y');
149: aso_debug_pub.add('p_config_header_id = ' || p_config_header_id,1,'Y');
150: aso_debug_pub.add('p_config_revision_num = ' ||p_config_revision_num ,1,'Y');
151: aso_debug_pub.add('p_quote_line_id = ' || p_quote_line_id,1,'Y');
152:
153: END IF;
154:
155: if ( p_item_type_code = 'STD' ) then

Line 160: IF aso_debug_pub.g_debug_flag = 'Y' THEN

156: l_top_group := l_top_group+1;
157: l_cmp_group := 0;
158: l_svc_group := 0;
159:
160: IF aso_debug_pub.g_debug_flag = 'Y' THEN
161: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');
162: END IF;
163:
164: return(to_char(l_top_group)||'.'||to_char(l_cmp_group));

Line 161: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');

157: l_cmp_group := 0;
158: l_svc_group := 0;
159:
160: IF aso_debug_pub.g_debug_flag = 'Y' THEN
161: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');
162: END IF;
163:
164: return(to_char(l_top_group)||'.'||to_char(l_cmp_group));
165:

Line 172: IF aso_debug_pub.g_debug_flag = 'Y' THEN

168: l_top_group := l_top_group+1;
169: l_cmp_group := 0;
170: l_svc_group := 0;
171:
172: IF aso_debug_pub.g_debug_flag = 'Y' THEN
173: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');
174: END IF;
175:
176: return(to_char(l_top_group)||'.'||to_char(l_cmp_group));

Line 173: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');

169: l_cmp_group := 0;
170: l_svc_group := 0;
171:
172: IF aso_debug_pub.g_debug_flag = 'Y' THEN
173: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');
174: END IF;
175:
176: return(to_char(l_top_group)||'.'||to_char(l_cmp_group));
177: elsif ( p_item_type_code = 'MDL' and p_config_header_id IS NULL AND p_config_revision_num IS NULL ) then

Line 182: IF aso_debug_pub.g_debug_flag = 'Y' THEN

178: l_top_group := l_top_group+1;
179: l_cmp_group := 0;
180: l_svc_group := 0;
181:
182: IF aso_debug_pub.g_debug_flag = 'Y' THEN
183: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');
184: END IF;
185:
186: return(to_char(l_top_group)||'.'||to_char(l_cmp_group));

Line 183: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');

179: l_cmp_group := 0;
180: l_svc_group := 0;
181:
182: IF aso_debug_pub.g_debug_flag = 'Y' THEN
183: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');
184: END IF;
185:
186: return(to_char(l_top_group)||'.'||to_char(l_cmp_group));
187: elsif ( p_item_type_code = 'MDL' and p_config_header_id IS NOT NULL AND p_config_revision_num IS NOT NULL ) then

Line 192: IF aso_debug_pub.g_debug_flag = 'Y' THEN

188: l_top_group := l_top_group+1;
189: l_cmp_group := 0;
190: l_svc_group := 0;
191:
192: IF aso_debug_pub.g_debug_flag = 'Y' THEN
193: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');
194: END IF;
195:
196: return(to_char(l_top_group)||'.'||to_char(l_cmp_group));

Line 193: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');

189: l_cmp_group := 0;
190: l_svc_group := 0;
191:
192: IF aso_debug_pub.g_debug_flag = 'Y' THEN
193: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');
194: END IF;
195:
196: return(to_char(l_top_group)||'.'||to_char(l_cmp_group));
197: elsif ( NVL(p_service_item_flag,'N') = 'Y' and NVL(p_service_ref_type_code,'NULL') <> 'QUOTE' ) then

Line 202: IF aso_debug_pub.g_debug_flag = 'Y' THEN

198: l_top_group := l_top_group+1;
199: l_cmp_group := 0;
200: l_svc_group := 0;
201:
202: IF aso_debug_pub.g_debug_flag = 'Y' THEN
203: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');
204: END IF;
205:
206: return(to_char(l_top_group)||'.'||to_char(l_cmp_group));

Line 203: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');

199: l_cmp_group := 0;
200: l_svc_group := 0;
201:
202: IF aso_debug_pub.g_debug_flag = 'Y' THEN
203: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');
204: END IF;
205:
206: return(to_char(l_top_group)||'.'||to_char(l_cmp_group));
207: elsif ( NVL(p_service_item_flag,'N') = 'Y' and NVL(p_service_ref_type_code,'NULL') = 'QUOTE' ) then

Line 210: IF aso_debug_pub.g_debug_flag = 'Y' THEN

206: return(to_char(l_top_group)||'.'||to_char(l_cmp_group));
207: elsif ( NVL(p_service_item_flag,'N') = 'Y' and NVL(p_service_ref_type_code,'NULL') = 'QUOTE' ) then
208: l_svc_group := l_svc_group + 1;
209:
210: IF aso_debug_pub.g_debug_flag = 'Y' THEN
211: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group)||'.'||to_char(l_svc_group));
212: END IF;
213:
214: return(to_char(l_top_group)||'.'||to_char(l_cmp_group)||'.'||to_char(l_svc_group));

Line 211: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group)||'.'||to_char(l_svc_group));

207: elsif ( NVL(p_service_item_flag,'N') = 'Y' and NVL(p_service_ref_type_code,'NULL') = 'QUOTE' ) then
208: l_svc_group := l_svc_group + 1;
209:
210: IF aso_debug_pub.g_debug_flag = 'Y' THEN
211: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group)||'.'||to_char(l_svc_group));
212: END IF;
213:
214: return(to_char(l_top_group)||'.'||to_char(l_cmp_group)||'.'||to_char(l_svc_group));
215: elsif ( p_item_type_code = 'CFG' ) then

Line 219: IF aso_debug_pub.g_debug_flag = 'Y' THEN

215: elsif ( p_item_type_code = 'CFG' ) then
216: l_cmp_group := l_cmp_group + 1;
217: l_svc_group := 0;
218:
219: IF aso_debug_pub.g_debug_flag = 'Y' THEN
220: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');
221: END IF;
222:
223: return(to_char(l_top_group)||'.'||to_char(l_cmp_group));

Line 220: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');

216: l_cmp_group := l_cmp_group + 1;
217: l_svc_group := 0;
218:
219: IF aso_debug_pub.g_debug_flag = 'Y' THEN
220: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');
221: END IF;
222:
223: return(to_char(l_top_group)||'.'||to_char(l_cmp_group));
224: elsif ( p_item_type_code = 'OPT' ) then

Line 229: IF aso_debug_pub.g_debug_flag = 'Y' THEN

225: l_top_group := l_top_group+1;
226: l_cmp_group := 0;
227: l_svc_group := 0;
228:
229: IF aso_debug_pub.g_debug_flag = 'Y' THEN
230: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');
231: END IF;
232:
233: return(to_char(l_top_group)||'.'||to_char(l_cmp_group));

Line 230: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');

226: l_cmp_group := 0;
227: l_svc_group := 0;
228:
229: IF aso_debug_pub.g_debug_flag = 'Y' THEN
230: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');
231: END IF;
232:
233: return(to_char(l_top_group)||'.'||to_char(l_cmp_group));
234: elsif ( p_item_type_code = 'PLN' ) then

Line 239: IF aso_debug_pub.g_debug_flag = 'Y' THEN

235: l_top_group := l_top_group+1;
236: l_cmp_group := 0;
237: l_svc_group := 0;
238:
239: IF aso_debug_pub.g_debug_flag = 'Y' THEN
240: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');
241: END IF;
242:
243: return(to_char(l_top_group)||'.'||to_char(l_cmp_group));

Line 240: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');

236: l_cmp_group := 0;
237: l_svc_group := 0;
238:
239: IF aso_debug_pub.g_debug_flag = 'Y' THEN
240: aso_debug_pub.add(to_char(l_top_group)||'.'||to_char(l_cmp_group),1,'Y');
241: END IF;
242:
243: return(to_char(l_top_group)||'.'||to_char(l_cmp_group));
244: end if;