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.M4U_GLOBAL_REGQRY dependencies on CLN_DEBUG_PUB

Line 37: cln_debug_pub.Add('M4U:----- Entering RAISE_REGQRY_EVENT ------- ',2);

33:
34: BEGIN
35:
36: IF (l_debug_Level <= 2) THEN
37: cln_debug_pub.Add('M4U:----- Entering RAISE_REGQRY_EVENT ------- ',2);
38: END IF;
39:
40:
41: -- Initialize API return status to success

Line 48: cln_debug_pub.Add('++++ PARAMETERS RECEIVED FROM CONCURRENT PROGRAM ++ ',1);

44:
45:
46: -- Parameters received
47: IF (l_Debug_Level <= 1) THEN
48: cln_debug_pub.Add('++++ PARAMETERS RECEIVED FROM CONCURRENT PROGRAM ++ ',1);
49: cln_debug_pub.Add('p_qr_ipgln - '||p_qr_ipgln ,1);
50: cln_debug_pub.Add('p_qr_gtin - '||p_qr_gtin,1);
51: cln_debug_pub.Add('p_qr_targtMarkt - '||p_qr_targtMarkt,1);
52: cln_debug_pub.Add('+++++++++++++++++++++++++++++++++++++++++++++++++++',1);

Line 49: cln_debug_pub.Add('p_qr_ipgln - '||p_qr_ipgln ,1);

45:
46: -- Parameters received
47: IF (l_Debug_Level <= 1) THEN
48: cln_debug_pub.Add('++++ PARAMETERS RECEIVED FROM CONCURRENT PROGRAM ++ ',1);
49: cln_debug_pub.Add('p_qr_ipgln - '||p_qr_ipgln ,1);
50: cln_debug_pub.Add('p_qr_gtin - '||p_qr_gtin,1);
51: cln_debug_pub.Add('p_qr_targtMarkt - '||p_qr_targtMarkt,1);
52: cln_debug_pub.Add('+++++++++++++++++++++++++++++++++++++++++++++++++++',1);
53: END IF;

Line 50: cln_debug_pub.Add('p_qr_gtin - '||p_qr_gtin,1);

46: -- Parameters received
47: IF (l_Debug_Level <= 1) THEN
48: cln_debug_pub.Add('++++ PARAMETERS RECEIVED FROM CONCURRENT PROGRAM ++ ',1);
49: cln_debug_pub.Add('p_qr_ipgln - '||p_qr_ipgln ,1);
50: cln_debug_pub.Add('p_qr_gtin - '||p_qr_gtin,1);
51: cln_debug_pub.Add('p_qr_targtMarkt - '||p_qr_targtMarkt,1);
52: cln_debug_pub.Add('+++++++++++++++++++++++++++++++++++++++++++++++++++',1);
53: END IF;
54:

Line 51: cln_debug_pub.Add('p_qr_targtMarkt - '||p_qr_targtMarkt,1);

47: IF (l_Debug_Level <= 1) THEN
48: cln_debug_pub.Add('++++ PARAMETERS RECEIVED FROM CONCURRENT PROGRAM ++ ',1);
49: cln_debug_pub.Add('p_qr_ipgln - '||p_qr_ipgln ,1);
50: cln_debug_pub.Add('p_qr_gtin - '||p_qr_gtin,1);
51: cln_debug_pub.Add('p_qr_targtMarkt - '||p_qr_targtMarkt,1);
52: cln_debug_pub.Add('+++++++++++++++++++++++++++++++++++++++++++++++++++',1);
53: END IF;
54:
55: -- Validation of the UCCnet parameters

Line 52: cln_debug_pub.Add('+++++++++++++++++++++++++++++++++++++++++++++++++++',1);

48: cln_debug_pub.Add('++++ PARAMETERS RECEIVED FROM CONCURRENT PROGRAM ++ ',1);
49: cln_debug_pub.Add('p_qr_ipgln - '||p_qr_ipgln ,1);
50: cln_debug_pub.Add('p_qr_gtin - '||p_qr_gtin,1);
51: cln_debug_pub.Add('p_qr_targtMarkt - '||p_qr_targtMarkt,1);
52: cln_debug_pub.Add('+++++++++++++++++++++++++++++++++++++++++++++++++++',1);
53: END IF;
54:
55: -- Validation of the UCCnet parameters
56:

Line 58: cln_debug_pub.Add('++++++ VALIDATION OF THE UCCNET PARAMETERS ++++++ ',1);

54:
55: -- Validation of the UCCnet parameters
56:
57: IF (l_Debug_Level <= 1) THEN
58: cln_debug_pub.Add('++++++ VALIDATION OF THE UCCNET PARAMETERS ++++++ ',1);
59: END IF;
60:
61: -- 1. Validation of the GLN
62: IF NOT m4u_ucc_utils.validate_uccnet_attr

Line 99: cln_debug_pub.Add('++++++ VALIDATION DONE WITH SUCCESS ++++++ ',1);

95:
96:
97:
98: IF (l_Debug_Level <= 1) THEN
99: cln_debug_pub.Add('++++++ VALIDATION DONE WITH SUCCESS ++++++ ',1);
100: END IF;
101:
102: -- obtain a unique event-id
103: SELECT m4u_wlqid_s.NEXTVAL

Line 119: cln_debug_pub.Add('ECX_EVENT_KEY - '||l_event_key,1);

115: p_name => 'ECX_EVENT_KEY',
116: p_value => l_event_key,
117: p_parameterlist => l_event_parameters );
118: IF (l_Debug_Level <= 1) THEN
119: cln_debug_pub.Add('ECX_EVENT_KEY - '||l_event_key,1);
120: END IF;
121:
122: wf_event.AddParameterToList(
123: p_name => 'M4U_DOC_NO',

Line 127: cln_debug_pub.Add('M4U_DOC_NO - '||l_event_key,1);

123: p_name => 'M4U_DOC_NO',
124: p_value => l_event_key,
125: p_parameterlist => l_event_parameters );
126: IF (l_Debug_Level <= 1) THEN
127: cln_debug_pub.Add('M4U_DOC_NO - '||l_event_key,1);
128: END IF;
129:
130: IF (l_Debug_Level <= 1) THEN
131: cln_debug_pub.Add('ECX_PARAMETER2 - IP GLN - '||p_qr_ipgln,1);

Line 131: cln_debug_pub.Add('ECX_PARAMETER2 - IP GLN - '||p_qr_ipgln,1);

127: cln_debug_pub.Add('M4U_DOC_NO - '||l_event_key,1);
128: END IF;
129:
130: IF (l_Debug_Level <= 1) THEN
131: cln_debug_pub.Add('ECX_PARAMETER2 - IP GLN - '||p_qr_ipgln,1);
132: END IF;
133: wf_event.AddParameterToList(
134: p_name => 'ECX_PARAMETER2',
135: p_value => p_qr_ipgln,

Line 138: cln_debug_pub.Add('ECX_PARAMETER2 - IP GLN - '||p_qr_ipgln,1);

134: p_name => 'ECX_PARAMETER2',
135: p_value => p_qr_ipgln,
136: p_parameterlist => l_event_parameters );
137: IF (l_Debug_Level <= 1) THEN
138: cln_debug_pub.Add('ECX_PARAMETER2 - IP GLN - '||p_qr_ipgln,1);
139: END IF;
140:
141:
142: wf_event.AddParameterToList(

Line 147: cln_debug_pub.Add('ECX_PARAMETER3 - GTIN -'||p_qr_gtin,1);

143: p_name => 'ECX_PARAMETER3',
144: p_value => p_qr_gtin,
145: p_parameterlist => l_event_parameters );
146: IF (l_Debug_Level <= 1) THEN
147: cln_debug_pub.Add('ECX_PARAMETER3 - GTIN -'||p_qr_gtin,1);
148: END IF;
149:
150: wf_event.AddParameterToList(
151: p_name => 'ECX_PARAMETER4',

Line 155: cln_debug_pub.Add('ECX_PARAMETER4 - Target Market -'||p_qr_targtMarkt,1);

151: p_name => 'ECX_PARAMETER4',
152: p_value => p_qr_targtMarkt,
153: p_parameterlist => l_event_parameters );
154: IF (l_Debug_Level <= 1) THEN
155: cln_debug_pub.Add('ECX_PARAMETER4 - Target Market -'||p_qr_targtMarkt,1);
156: END IF;
157:
158: wf_event.AddParameterToList(
159: p_name => 'ECX_TRANSACTION_TYPE',

Line 163: cln_debug_pub.Add('ECX_TRANSACTION_TYPE - M4U',1);

159: p_name => 'ECX_TRANSACTION_TYPE',
160: p_value => 'M4U',
161: p_parameterlist => l_event_parameters );
162: IF (l_Debug_Level <= 1) THEN
163: cln_debug_pub.Add('ECX_TRANSACTION_TYPE - M4U',1);
164: END IF;
165:
166: wf_event.AddParameterToList(
167: p_name => 'ECX_TRANSACTION_SUBTYPE',

Line 171: cln_debug_pub.Add('ECX_TRANSACTION_SUBTYPE - GBREGQRY',1);

167: p_name => 'ECX_TRANSACTION_SUBTYPE',
168: p_value => 'GBREGQRY',
169: p_parameterlist => l_event_parameters );
170: IF (l_Debug_Level <= 1) THEN
171: cln_debug_pub.Add('ECX_TRANSACTION_SUBTYPE - GBREGQRY',1);
172: END IF;
173:
174: wf_event.AddParameterToList(
175: p_name => 'ECX_DOCUMENT_ID',

Line 179: cln_debug_pub.Add('ECX_DOCUMENT_ID - '||l_event_key,1);

175: p_name => 'ECX_DOCUMENT_ID',
176: p_value => l_event_key,
177: p_parameterlist => l_event_parameters );
178: IF (l_Debug_Level <= 1) THEN
179: cln_debug_pub.Add('ECX_DOCUMENT_ID - '||l_event_key,1);
180: END IF;
181:
182:
183: wf_event.AddParameterToList(

Line 188: cln_debug_pub.Add('M4U_CLN_COLL_TYPE - M4U_REGISTRY_QUERY');

184: p_name => 'M4U_CLN_COLL_TYPE',
185: p_value => 'M4U_REGISTRY_QUERY',
186: p_parameterlist => l_event_parameters );
187: IF (l_Debug_Level <= 1) THEN
188: cln_debug_pub.Add('M4U_CLN_COLL_TYPE - M4U_REGISTRY_QUERY');
189: END IF;
190:
191: wf_event.AddParameterToList(
192: p_name => 'M4U_CLN_DOC_TYPE',

Line 196: cln_debug_pub.Add('M4U_CLN_DOC_TYPE - M4U_REGISTRY_QUERY');

192: p_name => 'M4U_CLN_DOC_TYPE',
193: p_value => 'M4U_REGISTRY_QUERY',
194: p_parameterlist => l_event_parameters );
195: IF (l_Debug_Level <= 1) THEN
196: cln_debug_pub.Add('M4U_CLN_DOC_TYPE - M4U_REGISTRY_QUERY');
197: END IF;
198:
199: wf_event.AddParameterToList(
200: p_name => 'ATTRIBUTE1',

Line 204: cln_debug_pub.Add('ATTRIBUTE1 - '||m4u_ucc_utils.g_host_gln,1);

200: p_name => 'ATTRIBUTE1',
201: p_value => m4u_ucc_utils.g_host_gln,
202: p_parameterlist => l_event_parameters );
203: IF (l_Debug_Level <= 1) THEN
204: cln_debug_pub.Add('ATTRIBUTE1 - '||m4u_ucc_utils.g_host_gln,1);
205: END IF;
206:
207: wf_event.AddParameterToList(
208: p_name => 'ATTRIBUTE5',

Line 212: cln_debug_pub.Add('ATTRIBUTE5 - '||m4u_ucc_utils.g_supp_gln,1);

208: p_name => 'ATTRIBUTE5',
209: p_value => m4u_ucc_utils.g_supp_gln,
210: p_parameterlist => l_event_parameters );
211: IF (l_Debug_Level <= 1) THEN
212: cln_debug_pub.Add('ATTRIBUTE5 - '||m4u_ucc_utils.g_supp_gln,1);
213: END IF;
214:
215:
216: wf_event.AddParameterToList(

Line 221: cln_debug_pub.Add('ATTRIBUTE12 - '||l_event_key,1);

217: p_name => 'ATTRIBUTE12',
218: p_value => l_event_key,
219: p_parameterlist => l_event_parameters );
220: IF (l_Debug_Level <= 1) THEN
221: cln_debug_pub.Add('ATTRIBUTE12 - '||l_event_key,1);
222: END IF;
223:
224:
225: -- set event parameters, end

Line 228: cln_debug_pub.Add('-- Raising Event oracle.apps.m4u.outboundwf.generate -- ',1);

224:
225: -- set event parameters, end
226:
227: IF (l_Debug_Level <= 1) THEN
228: cln_debug_pub.Add('-- Raising Event oracle.apps.m4u.outboundwf.generate -- ',1);
229: cln_debug_pub.Add('p_event_key - '||l_event_key ,1);
230: END IF;
231:
232:

Line 229: cln_debug_pub.Add('p_event_key - '||l_event_key ,1);

225: -- set event parameters, end
226:
227: IF (l_Debug_Level <= 1) THEN
228: cln_debug_pub.Add('-- Raising Event oracle.apps.m4u.outboundwf.generate -- ',1);
229: cln_debug_pub.Add('p_event_key - '||l_event_key ,1);
230: END IF;
231:
232:
233: -- raise event to trigger outbound wlq generation WF

Line 246: cln_debug_pub.Add(l_msg_data,1);

242: x_errbuf := 'Successful';
243:
244: -- check the message
245: IF (l_Debug_Level <= 1) THEN
246: cln_debug_pub.Add(l_msg_data,1);
247: END IF;
248:
249: IF (l_Debug_Level <= 2) THEN
250: cln_debug_pub.Add('------- Exiting raise_regqry_event API --------- ',2);

Line 250: cln_debug_pub.Add('------- Exiting raise_regqry_event API --------- ',2);

246: cln_debug_pub.Add(l_msg_data,1);
247: END IF;
248:
249: IF (l_Debug_Level <= 2) THEN
250: cln_debug_pub.Add('------- Exiting raise_regqry_event API --------- ',2);
251: END IF;
252:
253:
254: -- Exception Handling

Line 261: cln_debug_pub.Add(l_msg_data,4);

257: x_retcode := 2 ;
258: x_errbuf := x_msg_data;
259:
260: IF (l_Debug_Level <= 5) THEN
261: cln_debug_pub.Add(l_msg_data,4);
262: cln_debug_pub.Add('Details: '||x_msg_data,4);
263: cln_debug_pub.Add('------- Exiting raise_regqry_event API --------- ',2);
264: END IF;
265:

Line 262: cln_debug_pub.Add('Details: '||x_msg_data,4);

258: x_errbuf := x_msg_data;
259:
260: IF (l_Debug_Level <= 5) THEN
261: cln_debug_pub.Add(l_msg_data,4);
262: cln_debug_pub.Add('Details: '||x_msg_data,4);
263: cln_debug_pub.Add('------- Exiting raise_regqry_event API --------- ',2);
264: END IF;
265:
266:

Line 263: cln_debug_pub.Add('------- Exiting raise_regqry_event API --------- ',2);

259:
260: IF (l_Debug_Level <= 5) THEN
261: cln_debug_pub.Add(l_msg_data,4);
262: cln_debug_pub.Add('Details: '||x_msg_data,4);
263: cln_debug_pub.Add('------- Exiting raise_regqry_event API --------- ',2);
264: END IF;
265:
266:
267: WHEN OTHERS THEN

Line 278: cln_debug_pub.Add(x_errbuf,6);

274: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
275: x_errbuf := FND_MESSAGE.GET;
276:
277: IF (l_Debug_Level <= 5) THEN
278: cln_debug_pub.Add(x_errbuf,6);
279: cln_debug_pub.Add('------- Exiting raise_regqry_event API --------- ',2);
280: END IF;
281: END;
282:

Line 279: cln_debug_pub.Add('------- Exiting raise_regqry_event API --------- ',2);

275: x_errbuf := FND_MESSAGE.GET;
276:
277: IF (l_Debug_Level <= 5) THEN
278: cln_debug_pub.Add(x_errbuf,6);
279: cln_debug_pub.Add('------- Exiting raise_regqry_event API --------- ',2);
280: END IF;
281: END;
282:
283: -- Name

Line 351: cln_debug_pub.Add('---- m4u_global_regqry.process_gtin_resp ---- ' ,1);

347: BEGIN
348:
349: -- Parameters received
350: IF (l_Debug_Level <= 1) THEN
351: cln_debug_pub.Add('---- m4u_global_regqry.process_gtin_resp ---- ' ,1);
352: cln_debug_pub.Add('p_gtin - '|| p_gtin ,1);
353: cln_debug_pub.Add('p_data_source - '|| p_data_source ,1);
354: cln_debug_pub.Add('p_target_market - '|| p_target_market ,1);
355: cln_debug_pub.Add('p_src_data_pool - '|| p_src_data_pool ,1);

Line 352: cln_debug_pub.Add('p_gtin - '|| p_gtin ,1);

348:
349: -- Parameters received
350: IF (l_Debug_Level <= 1) THEN
351: cln_debug_pub.Add('---- m4u_global_regqry.process_gtin_resp ---- ' ,1);
352: cln_debug_pub.Add('p_gtin - '|| p_gtin ,1);
353: cln_debug_pub.Add('p_data_source - '|| p_data_source ,1);
354: cln_debug_pub.Add('p_target_market - '|| p_target_market ,1);
355: cln_debug_pub.Add('p_src_data_pool - '|| p_src_data_pool ,1);
356: cln_debug_pub.Add('p_reg_data_pool - '|| p_reg_data_pool ,1);

Line 353: cln_debug_pub.Add('p_data_source - '|| p_data_source ,1);

349: -- Parameters received
350: IF (l_Debug_Level <= 1) THEN
351: cln_debug_pub.Add('---- m4u_global_regqry.process_gtin_resp ---- ' ,1);
352: cln_debug_pub.Add('p_gtin - '|| p_gtin ,1);
353: cln_debug_pub.Add('p_data_source - '|| p_data_source ,1);
354: cln_debug_pub.Add('p_target_market - '|| p_target_market ,1);
355: cln_debug_pub.Add('p_src_data_pool - '|| p_src_data_pool ,1);
356: cln_debug_pub.Add('p_reg_data_pool - '|| p_reg_data_pool ,1);
357: cln_debug_pub.Add('p_name_of_info_provider - '|| p_name_of_info_provider,1);

Line 354: cln_debug_pub.Add('p_target_market - '|| p_target_market ,1);

350: IF (l_Debug_Level <= 1) THEN
351: cln_debug_pub.Add('---- m4u_global_regqry.process_gtin_resp ---- ' ,1);
352: cln_debug_pub.Add('p_gtin - '|| p_gtin ,1);
353: cln_debug_pub.Add('p_data_source - '|| p_data_source ,1);
354: cln_debug_pub.Add('p_target_market - '|| p_target_market ,1);
355: cln_debug_pub.Add('p_src_data_pool - '|| p_src_data_pool ,1);
356: cln_debug_pub.Add('p_reg_data_pool - '|| p_reg_data_pool ,1);
357: cln_debug_pub.Add('p_name_of_info_provider - '|| p_name_of_info_provider,1);
358: cln_debug_pub.Add('p_brand_owner_name - '|| p_brand_owner_name ,1);

Line 355: cln_debug_pub.Add('p_src_data_pool - '|| p_src_data_pool ,1);

351: cln_debug_pub.Add('---- m4u_global_regqry.process_gtin_resp ---- ' ,1);
352: cln_debug_pub.Add('p_gtin - '|| p_gtin ,1);
353: cln_debug_pub.Add('p_data_source - '|| p_data_source ,1);
354: cln_debug_pub.Add('p_target_market - '|| p_target_market ,1);
355: cln_debug_pub.Add('p_src_data_pool - '|| p_src_data_pool ,1);
356: cln_debug_pub.Add('p_reg_data_pool - '|| p_reg_data_pool ,1);
357: cln_debug_pub.Add('p_name_of_info_provider - '|| p_name_of_info_provider,1);
358: cln_debug_pub.Add('p_brand_owner_name - '|| p_brand_owner_name ,1);
359: cln_debug_pub.Add('p_brand_owner_gln - '|| p_brand_owner_gln ,1);

Line 356: cln_debug_pub.Add('p_reg_data_pool - '|| p_reg_data_pool ,1);

352: cln_debug_pub.Add('p_gtin - '|| p_gtin ,1);
353: cln_debug_pub.Add('p_data_source - '|| p_data_source ,1);
354: cln_debug_pub.Add('p_target_market - '|| p_target_market ,1);
355: cln_debug_pub.Add('p_src_data_pool - '|| p_src_data_pool ,1);
356: cln_debug_pub.Add('p_reg_data_pool - '|| p_reg_data_pool ,1);
357: cln_debug_pub.Add('p_name_of_info_provider - '|| p_name_of_info_provider,1);
358: cln_debug_pub.Add('p_brand_owner_name - '|| p_brand_owner_name ,1);
359: cln_debug_pub.Add('p_brand_owner_gln - '|| p_brand_owner_gln ,1);
360: cln_debug_pub.Add('p_brand_name - '|| p_brand_name ,1);

Line 357: cln_debug_pub.Add('p_name_of_info_provider - '|| p_name_of_info_provider,1);

353: cln_debug_pub.Add('p_data_source - '|| p_data_source ,1);
354: cln_debug_pub.Add('p_target_market - '|| p_target_market ,1);
355: cln_debug_pub.Add('p_src_data_pool - '|| p_src_data_pool ,1);
356: cln_debug_pub.Add('p_reg_data_pool - '|| p_reg_data_pool ,1);
357: cln_debug_pub.Add('p_name_of_info_provider - '|| p_name_of_info_provider,1);
358: cln_debug_pub.Add('p_brand_owner_name - '|| p_brand_owner_name ,1);
359: cln_debug_pub.Add('p_brand_owner_gln - '|| p_brand_owner_gln ,1);
360: cln_debug_pub.Add('p_brand_name - '|| p_brand_name ,1);
361: cln_debug_pub.Add('p_trade_item_unit_desc - '|| p_trade_item_unit_desc,1);

Line 358: cln_debug_pub.Add('p_brand_owner_name - '|| p_brand_owner_name ,1);

354: cln_debug_pub.Add('p_target_market - '|| p_target_market ,1);
355: cln_debug_pub.Add('p_src_data_pool - '|| p_src_data_pool ,1);
356: cln_debug_pub.Add('p_reg_data_pool - '|| p_reg_data_pool ,1);
357: cln_debug_pub.Add('p_name_of_info_provider - '|| p_name_of_info_provider,1);
358: cln_debug_pub.Add('p_brand_owner_name - '|| p_brand_owner_name ,1);
359: cln_debug_pub.Add('p_brand_owner_gln - '|| p_brand_owner_gln ,1);
360: cln_debug_pub.Add('p_brand_name - '|| p_brand_name ,1);
361: cln_debug_pub.Add('p_trade_item_unit_desc - '|| p_trade_item_unit_desc,1);
362: cln_debug_pub.Add('p_eanucc_code - '|| p_eanucc_code ,1);

Line 359: cln_debug_pub.Add('p_brand_owner_gln - '|| p_brand_owner_gln ,1);

355: cln_debug_pub.Add('p_src_data_pool - '|| p_src_data_pool ,1);
356: cln_debug_pub.Add('p_reg_data_pool - '|| p_reg_data_pool ,1);
357: cln_debug_pub.Add('p_name_of_info_provider - '|| p_name_of_info_provider,1);
358: cln_debug_pub.Add('p_brand_owner_name - '|| p_brand_owner_name ,1);
359: cln_debug_pub.Add('p_brand_owner_gln - '|| p_brand_owner_gln ,1);
360: cln_debug_pub.Add('p_brand_name - '|| p_brand_name ,1);
361: cln_debug_pub.Add('p_trade_item_unit_desc - '|| p_trade_item_unit_desc,1);
362: cln_debug_pub.Add('p_eanucc_code - '|| p_eanucc_code ,1);
363: cln_debug_pub.Add('p_eanucc_type - '|| p_eanucc_type ,1);

Line 360: cln_debug_pub.Add('p_brand_name - '|| p_brand_name ,1);

356: cln_debug_pub.Add('p_reg_data_pool - '|| p_reg_data_pool ,1);
357: cln_debug_pub.Add('p_name_of_info_provider - '|| p_name_of_info_provider,1);
358: cln_debug_pub.Add('p_brand_owner_name - '|| p_brand_owner_name ,1);
359: cln_debug_pub.Add('p_brand_owner_gln - '|| p_brand_owner_gln ,1);
360: cln_debug_pub.Add('p_brand_name - '|| p_brand_name ,1);
361: cln_debug_pub.Add('p_trade_item_unit_desc - '|| p_trade_item_unit_desc,1);
362: cln_debug_pub.Add('p_eanucc_code - '|| p_eanucc_code ,1);
363: cln_debug_pub.Add('p_eanucc_type - '|| p_eanucc_type ,1);
364: cln_debug_pub.Add('p_delivery_method - '|| p_delivery_method ,1);

Line 361: cln_debug_pub.Add('p_trade_item_unit_desc - '|| p_trade_item_unit_desc,1);

357: cln_debug_pub.Add('p_name_of_info_provider - '|| p_name_of_info_provider,1);
358: cln_debug_pub.Add('p_brand_owner_name - '|| p_brand_owner_name ,1);
359: cln_debug_pub.Add('p_brand_owner_gln - '|| p_brand_owner_gln ,1);
360: cln_debug_pub.Add('p_brand_name - '|| p_brand_name ,1);
361: cln_debug_pub.Add('p_trade_item_unit_desc - '|| p_trade_item_unit_desc,1);
362: cln_debug_pub.Add('p_eanucc_code - '|| p_eanucc_code ,1);
363: cln_debug_pub.Add('p_eanucc_type - '|| p_eanucc_type ,1);
364: cln_debug_pub.Add('p_delivery_method - '|| p_delivery_method ,1);
365: cln_debug_pub.Add('p_consumer_unit - '|| p_consumer_unit ,1);

Line 362: cln_debug_pub.Add('p_eanucc_code - '|| p_eanucc_code ,1);

358: cln_debug_pub.Add('p_brand_owner_name - '|| p_brand_owner_name ,1);
359: cln_debug_pub.Add('p_brand_owner_gln - '|| p_brand_owner_gln ,1);
360: cln_debug_pub.Add('p_brand_name - '|| p_brand_name ,1);
361: cln_debug_pub.Add('p_trade_item_unit_desc - '|| p_trade_item_unit_desc,1);
362: cln_debug_pub.Add('p_eanucc_code - '|| p_eanucc_code ,1);
363: cln_debug_pub.Add('p_eanucc_type - '|| p_eanucc_type ,1);
364: cln_debug_pub.Add('p_delivery_method - '|| p_delivery_method ,1);
365: cln_debug_pub.Add('p_consumer_unit - '|| p_consumer_unit ,1);
366: cln_debug_pub.Add('p_ord_unit - '|| p_ord_unit ,1);

Line 363: cln_debug_pub.Add('p_eanucc_type - '|| p_eanucc_type ,1);

359: cln_debug_pub.Add('p_brand_owner_gln - '|| p_brand_owner_gln ,1);
360: cln_debug_pub.Add('p_brand_name - '|| p_brand_name ,1);
361: cln_debug_pub.Add('p_trade_item_unit_desc - '|| p_trade_item_unit_desc,1);
362: cln_debug_pub.Add('p_eanucc_code - '|| p_eanucc_code ,1);
363: cln_debug_pub.Add('p_eanucc_type - '|| p_eanucc_type ,1);
364: cln_debug_pub.Add('p_delivery_method - '|| p_delivery_method ,1);
365: cln_debug_pub.Add('p_consumer_unit - '|| p_consumer_unit ,1);
366: cln_debug_pub.Add('p_ord_unit - '|| p_ord_unit ,1);
367: cln_debug_pub.Add('p_effective_date - '|| p_effective_date ,1);

Line 364: cln_debug_pub.Add('p_delivery_method - '|| p_delivery_method ,1);

360: cln_debug_pub.Add('p_brand_name - '|| p_brand_name ,1);
361: cln_debug_pub.Add('p_trade_item_unit_desc - '|| p_trade_item_unit_desc,1);
362: cln_debug_pub.Add('p_eanucc_code - '|| p_eanucc_code ,1);
363: cln_debug_pub.Add('p_eanucc_type - '|| p_eanucc_type ,1);
364: cln_debug_pub.Add('p_delivery_method - '|| p_delivery_method ,1);
365: cln_debug_pub.Add('p_consumer_unit - '|| p_consumer_unit ,1);
366: cln_debug_pub.Add('p_ord_unit - '|| p_ord_unit ,1);
367: cln_debug_pub.Add('p_effective_date - '|| p_effective_date ,1);
368: cln_debug_pub.Add('p_next_level_cnt - '|| p_next_level_cnt ,1);

Line 365: cln_debug_pub.Add('p_consumer_unit - '|| p_consumer_unit ,1);

361: cln_debug_pub.Add('p_trade_item_unit_desc - '|| p_trade_item_unit_desc,1);
362: cln_debug_pub.Add('p_eanucc_code - '|| p_eanucc_code ,1);
363: cln_debug_pub.Add('p_eanucc_type - '|| p_eanucc_type ,1);
364: cln_debug_pub.Add('p_delivery_method - '|| p_delivery_method ,1);
365: cln_debug_pub.Add('p_consumer_unit - '|| p_consumer_unit ,1);
366: cln_debug_pub.Add('p_ord_unit - '|| p_ord_unit ,1);
367: cln_debug_pub.Add('p_effective_date - '|| p_effective_date ,1);
368: cln_debug_pub.Add('p_next_level_cnt - '|| p_next_level_cnt ,1);
369: cln_debug_pub.Add('p_gross_wt - '|| p_gross_wt ,1);

Line 366: cln_debug_pub.Add('p_ord_unit - '|| p_ord_unit ,1);

362: cln_debug_pub.Add('p_eanucc_code - '|| p_eanucc_code ,1);
363: cln_debug_pub.Add('p_eanucc_type - '|| p_eanucc_type ,1);
364: cln_debug_pub.Add('p_delivery_method - '|| p_delivery_method ,1);
365: cln_debug_pub.Add('p_consumer_unit - '|| p_consumer_unit ,1);
366: cln_debug_pub.Add('p_ord_unit - '|| p_ord_unit ,1);
367: cln_debug_pub.Add('p_effective_date - '|| p_effective_date ,1);
368: cln_debug_pub.Add('p_next_level_cnt - '|| p_next_level_cnt ,1);
369: cln_debug_pub.Add('p_gross_wt - '|| p_gross_wt ,1);
370: cln_debug_pub.Add('p_gross_wt_uom - '|| p_gross_wt_uom ,1);

Line 367: cln_debug_pub.Add('p_effective_date - '|| p_effective_date ,1);

363: cln_debug_pub.Add('p_eanucc_type - '|| p_eanucc_type ,1);
364: cln_debug_pub.Add('p_delivery_method - '|| p_delivery_method ,1);
365: cln_debug_pub.Add('p_consumer_unit - '|| p_consumer_unit ,1);
366: cln_debug_pub.Add('p_ord_unit - '|| p_ord_unit ,1);
367: cln_debug_pub.Add('p_effective_date - '|| p_effective_date ,1);
368: cln_debug_pub.Add('p_next_level_cnt - '|| p_next_level_cnt ,1);
369: cln_debug_pub.Add('p_gross_wt - '|| p_gross_wt ,1);
370: cln_debug_pub.Add('p_gross_wt_uom - '|| p_gross_wt_uom ,1);
371: cln_debug_pub.Add('p_height - '|| p_height ,1);

Line 368: cln_debug_pub.Add('p_next_level_cnt - '|| p_next_level_cnt ,1);

364: cln_debug_pub.Add('p_delivery_method - '|| p_delivery_method ,1);
365: cln_debug_pub.Add('p_consumer_unit - '|| p_consumer_unit ,1);
366: cln_debug_pub.Add('p_ord_unit - '|| p_ord_unit ,1);
367: cln_debug_pub.Add('p_effective_date - '|| p_effective_date ,1);
368: cln_debug_pub.Add('p_next_level_cnt - '|| p_next_level_cnt ,1);
369: cln_debug_pub.Add('p_gross_wt - '|| p_gross_wt ,1);
370: cln_debug_pub.Add('p_gross_wt_uom - '|| p_gross_wt_uom ,1);
371: cln_debug_pub.Add('p_height - '|| p_height ,1);
372: cln_debug_pub.Add('p_height_uom - '|| p_height_uom ,1);

Line 369: cln_debug_pub.Add('p_gross_wt - '|| p_gross_wt ,1);

365: cln_debug_pub.Add('p_consumer_unit - '|| p_consumer_unit ,1);
366: cln_debug_pub.Add('p_ord_unit - '|| p_ord_unit ,1);
367: cln_debug_pub.Add('p_effective_date - '|| p_effective_date ,1);
368: cln_debug_pub.Add('p_next_level_cnt - '|| p_next_level_cnt ,1);
369: cln_debug_pub.Add('p_gross_wt - '|| p_gross_wt ,1);
370: cln_debug_pub.Add('p_gross_wt_uom - '|| p_gross_wt_uom ,1);
371: cln_debug_pub.Add('p_height - '|| p_height ,1);
372: cln_debug_pub.Add('p_height_uom - '|| p_height_uom ,1);
373: cln_debug_pub.Add('p_width - '|| p_width ,1);

Line 370: cln_debug_pub.Add('p_gross_wt_uom - '|| p_gross_wt_uom ,1);

366: cln_debug_pub.Add('p_ord_unit - '|| p_ord_unit ,1);
367: cln_debug_pub.Add('p_effective_date - '|| p_effective_date ,1);
368: cln_debug_pub.Add('p_next_level_cnt - '|| p_next_level_cnt ,1);
369: cln_debug_pub.Add('p_gross_wt - '|| p_gross_wt ,1);
370: cln_debug_pub.Add('p_gross_wt_uom - '|| p_gross_wt_uom ,1);
371: cln_debug_pub.Add('p_height - '|| p_height ,1);
372: cln_debug_pub.Add('p_height_uom - '|| p_height_uom ,1);
373: cln_debug_pub.Add('p_width - '|| p_width ,1);
374: cln_debug_pub.Add('p_width_uom - '|| p_width_uom ,1);

Line 371: cln_debug_pub.Add('p_height - '|| p_height ,1);

367: cln_debug_pub.Add('p_effective_date - '|| p_effective_date ,1);
368: cln_debug_pub.Add('p_next_level_cnt - '|| p_next_level_cnt ,1);
369: cln_debug_pub.Add('p_gross_wt - '|| p_gross_wt ,1);
370: cln_debug_pub.Add('p_gross_wt_uom - '|| p_gross_wt_uom ,1);
371: cln_debug_pub.Add('p_height - '|| p_height ,1);
372: cln_debug_pub.Add('p_height_uom - '|| p_height_uom ,1);
373: cln_debug_pub.Add('p_width - '|| p_width ,1);
374: cln_debug_pub.Add('p_width_uom - '|| p_width_uom ,1);
375: cln_debug_pub.Add('p_depth - '|| p_depth ,1);

Line 372: cln_debug_pub.Add('p_height_uom - '|| p_height_uom ,1);

368: cln_debug_pub.Add('p_next_level_cnt - '|| p_next_level_cnt ,1);
369: cln_debug_pub.Add('p_gross_wt - '|| p_gross_wt ,1);
370: cln_debug_pub.Add('p_gross_wt_uom - '|| p_gross_wt_uom ,1);
371: cln_debug_pub.Add('p_height - '|| p_height ,1);
372: cln_debug_pub.Add('p_height_uom - '|| p_height_uom ,1);
373: cln_debug_pub.Add('p_width - '|| p_width ,1);
374: cln_debug_pub.Add('p_width_uom - '|| p_width_uom ,1);
375: cln_debug_pub.Add('p_depth - '|| p_depth ,1);
376: cln_debug_pub.Add('p_depth_uom - '|| p_depth_uom ,1);

Line 373: cln_debug_pub.Add('p_width - '|| p_width ,1);

369: cln_debug_pub.Add('p_gross_wt - '|| p_gross_wt ,1);
370: cln_debug_pub.Add('p_gross_wt_uom - '|| p_gross_wt_uom ,1);
371: cln_debug_pub.Add('p_height - '|| p_height ,1);
372: cln_debug_pub.Add('p_height_uom - '|| p_height_uom ,1);
373: cln_debug_pub.Add('p_width - '|| p_width ,1);
374: cln_debug_pub.Add('p_width_uom - '|| p_width_uom ,1);
375: cln_debug_pub.Add('p_depth - '|| p_depth ,1);
376: cln_debug_pub.Add('p_depth_uom - '|| p_depth_uom ,1);
377: cln_debug_pub.Add('p_volume - '|| p_volume ,1);

Line 374: cln_debug_pub.Add('p_width_uom - '|| p_width_uom ,1);

370: cln_debug_pub.Add('p_gross_wt_uom - '|| p_gross_wt_uom ,1);
371: cln_debug_pub.Add('p_height - '|| p_height ,1);
372: cln_debug_pub.Add('p_height_uom - '|| p_height_uom ,1);
373: cln_debug_pub.Add('p_width - '|| p_width ,1);
374: cln_debug_pub.Add('p_width_uom - '|| p_width_uom ,1);
375: cln_debug_pub.Add('p_depth - '|| p_depth ,1);
376: cln_debug_pub.Add('p_depth_uom - '|| p_depth_uom ,1);
377: cln_debug_pub.Add('p_volume - '|| p_volume ,1);
378: cln_debug_pub.Add('p_volume_uom - '|| p_volume_uom ,1);

Line 375: cln_debug_pub.Add('p_depth - '|| p_depth ,1);

371: cln_debug_pub.Add('p_height - '|| p_height ,1);
372: cln_debug_pub.Add('p_height_uom - '|| p_height_uom ,1);
373: cln_debug_pub.Add('p_width - '|| p_width ,1);
374: cln_debug_pub.Add('p_width_uom - '|| p_width_uom ,1);
375: cln_debug_pub.Add('p_depth - '|| p_depth ,1);
376: cln_debug_pub.Add('p_depth_uom - '|| p_depth_uom ,1);
377: cln_debug_pub.Add('p_volume - '|| p_volume ,1);
378: cln_debug_pub.Add('p_volume_uom - '|| p_volume_uom ,1);
379: cln_debug_pub.Add('p_net_content - '|| p_net_content ,1);

Line 376: cln_debug_pub.Add('p_depth_uom - '|| p_depth_uom ,1);

372: cln_debug_pub.Add('p_height_uom - '|| p_height_uom ,1);
373: cln_debug_pub.Add('p_width - '|| p_width ,1);
374: cln_debug_pub.Add('p_width_uom - '|| p_width_uom ,1);
375: cln_debug_pub.Add('p_depth - '|| p_depth ,1);
376: cln_debug_pub.Add('p_depth_uom - '|| p_depth_uom ,1);
377: cln_debug_pub.Add('p_volume - '|| p_volume ,1);
378: cln_debug_pub.Add('p_volume_uom - '|| p_volume_uom ,1);
379: cln_debug_pub.Add('p_net_content - '|| p_net_content ,1);
380: cln_debug_pub.Add('p_net_content_uom - '|| p_net_content_uom ,1);

Line 377: cln_debug_pub.Add('p_volume - '|| p_volume ,1);

373: cln_debug_pub.Add('p_width - '|| p_width ,1);
374: cln_debug_pub.Add('p_width_uom - '|| p_width_uom ,1);
375: cln_debug_pub.Add('p_depth - '|| p_depth ,1);
376: cln_debug_pub.Add('p_depth_uom - '|| p_depth_uom ,1);
377: cln_debug_pub.Add('p_volume - '|| p_volume ,1);
378: cln_debug_pub.Add('p_volume_uom - '|| p_volume_uom ,1);
379: cln_debug_pub.Add('p_net_content - '|| p_net_content ,1);
380: cln_debug_pub.Add('p_net_content_uom - '|| p_net_content_uom ,1);
381: cln_debug_pub.Add('p_net_wt - '|| p_net_wt ,1);

Line 378: cln_debug_pub.Add('p_volume_uom - '|| p_volume_uom ,1);

374: cln_debug_pub.Add('p_width_uom - '|| p_width_uom ,1);
375: cln_debug_pub.Add('p_depth - '|| p_depth ,1);
376: cln_debug_pub.Add('p_depth_uom - '|| p_depth_uom ,1);
377: cln_debug_pub.Add('p_volume - '|| p_volume ,1);
378: cln_debug_pub.Add('p_volume_uom - '|| p_volume_uom ,1);
379: cln_debug_pub.Add('p_net_content - '|| p_net_content ,1);
380: cln_debug_pub.Add('p_net_content_uom - '|| p_net_content_uom ,1);
381: cln_debug_pub.Add('p_net_wt - '|| p_net_wt ,1);
382: cln_debug_pub.Add('p_net_wt_uom - '|| p_net_wt_uom ,1);

Line 379: cln_debug_pub.Add('p_net_content - '|| p_net_content ,1);

375: cln_debug_pub.Add('p_depth - '|| p_depth ,1);
376: cln_debug_pub.Add('p_depth_uom - '|| p_depth_uom ,1);
377: cln_debug_pub.Add('p_volume - '|| p_volume ,1);
378: cln_debug_pub.Add('p_volume_uom - '|| p_volume_uom ,1);
379: cln_debug_pub.Add('p_net_content - '|| p_net_content ,1);
380: cln_debug_pub.Add('p_net_content_uom - '|| p_net_content_uom ,1);
381: cln_debug_pub.Add('p_net_wt - '|| p_net_wt ,1);
382: cln_debug_pub.Add('p_net_wt_uom - '|| p_net_wt_uom ,1);
383: cln_debug_pub.Add('p_is_info_pvt - '|| p_is_info_pvt ,1);

Line 380: cln_debug_pub.Add('p_net_content_uom - '|| p_net_content_uom ,1);

376: cln_debug_pub.Add('p_depth_uom - '|| p_depth_uom ,1);
377: cln_debug_pub.Add('p_volume - '|| p_volume ,1);
378: cln_debug_pub.Add('p_volume_uom - '|| p_volume_uom ,1);
379: cln_debug_pub.Add('p_net_content - '|| p_net_content ,1);
380: cln_debug_pub.Add('p_net_content_uom - '|| p_net_content_uom ,1);
381: cln_debug_pub.Add('p_net_wt - '|| p_net_wt ,1);
382: cln_debug_pub.Add('p_net_wt_uom - '|| p_net_wt_uom ,1);
383: cln_debug_pub.Add('p_is_info_pvt - '|| p_is_info_pvt ,1);
384: cln_debug_pub.Add('p_success_flag - '|| p_success_flag ,1);

Line 381: cln_debug_pub.Add('p_net_wt - '|| p_net_wt ,1);

377: cln_debug_pub.Add('p_volume - '|| p_volume ,1);
378: cln_debug_pub.Add('p_volume_uom - '|| p_volume_uom ,1);
379: cln_debug_pub.Add('p_net_content - '|| p_net_content ,1);
380: cln_debug_pub.Add('p_net_content_uom - '|| p_net_content_uom ,1);
381: cln_debug_pub.Add('p_net_wt - '|| p_net_wt ,1);
382: cln_debug_pub.Add('p_net_wt_uom - '|| p_net_wt_uom ,1);
383: cln_debug_pub.Add('p_is_info_pvt - '|| p_is_info_pvt ,1);
384: cln_debug_pub.Add('p_success_flag - '|| p_success_flag ,1);
385: cln_debug_pub.Add('p_gtin_query_id - '|| p_gtin_query_id ,1);

Line 382: cln_debug_pub.Add('p_net_wt_uom - '|| p_net_wt_uom ,1);

378: cln_debug_pub.Add('p_volume_uom - '|| p_volume_uom ,1);
379: cln_debug_pub.Add('p_net_content - '|| p_net_content ,1);
380: cln_debug_pub.Add('p_net_content_uom - '|| p_net_content_uom ,1);
381: cln_debug_pub.Add('p_net_wt - '|| p_net_wt ,1);
382: cln_debug_pub.Add('p_net_wt_uom - '|| p_net_wt_uom ,1);
383: cln_debug_pub.Add('p_is_info_pvt - '|| p_is_info_pvt ,1);
384: cln_debug_pub.Add('p_success_flag - '|| p_success_flag ,1);
385: cln_debug_pub.Add('p_gtin_query_id - '|| p_gtin_query_id ,1);
386: cln_debug_pub.Add('p_ucc_doc_unique_id - '|| p_ucc_doc_unique_id ,1);

Line 383: cln_debug_pub.Add('p_is_info_pvt - '|| p_is_info_pvt ,1);

379: cln_debug_pub.Add('p_net_content - '|| p_net_content ,1);
380: cln_debug_pub.Add('p_net_content_uom - '|| p_net_content_uom ,1);
381: cln_debug_pub.Add('p_net_wt - '|| p_net_wt ,1);
382: cln_debug_pub.Add('p_net_wt_uom - '|| p_net_wt_uom ,1);
383: cln_debug_pub.Add('p_is_info_pvt - '|| p_is_info_pvt ,1);
384: cln_debug_pub.Add('p_success_flag - '|| p_success_flag ,1);
385: cln_debug_pub.Add('p_gtin_query_id - '|| p_gtin_query_id ,1);
386: cln_debug_pub.Add('p_ucc_doc_unique_id - '|| p_ucc_doc_unique_id ,1);
387: cln_debug_pub.Add('p_xmlg_internal_control_no - '|| p_xmlg_internal_control_no ,1);

Line 384: cln_debug_pub.Add('p_success_flag - '|| p_success_flag ,1);

380: cln_debug_pub.Add('p_net_content_uom - '|| p_net_content_uom ,1);
381: cln_debug_pub.Add('p_net_wt - '|| p_net_wt ,1);
382: cln_debug_pub.Add('p_net_wt_uom - '|| p_net_wt_uom ,1);
383: cln_debug_pub.Add('p_is_info_pvt - '|| p_is_info_pvt ,1);
384: cln_debug_pub.Add('p_success_flag - '|| p_success_flag ,1);
385: cln_debug_pub.Add('p_gtin_query_id - '|| p_gtin_query_id ,1);
386: cln_debug_pub.Add('p_ucc_doc_unique_id - '|| p_ucc_doc_unique_id ,1);
387: cln_debug_pub.Add('p_xmlg_internal_control_no - '|| p_xmlg_internal_control_no ,1);
388: cln_debug_pub.Add('-------------------------------------------' ,1);

Line 385: cln_debug_pub.Add('p_gtin_query_id - '|| p_gtin_query_id ,1);

381: cln_debug_pub.Add('p_net_wt - '|| p_net_wt ,1);
382: cln_debug_pub.Add('p_net_wt_uom - '|| p_net_wt_uom ,1);
383: cln_debug_pub.Add('p_is_info_pvt - '|| p_is_info_pvt ,1);
384: cln_debug_pub.Add('p_success_flag - '|| p_success_flag ,1);
385: cln_debug_pub.Add('p_gtin_query_id - '|| p_gtin_query_id ,1);
386: cln_debug_pub.Add('p_ucc_doc_unique_id - '|| p_ucc_doc_unique_id ,1);
387: cln_debug_pub.Add('p_xmlg_internal_control_no - '|| p_xmlg_internal_control_no ,1);
388: cln_debug_pub.Add('-------------------------------------------' ,1);
389: END IF;

Line 386: cln_debug_pub.Add('p_ucc_doc_unique_id - '|| p_ucc_doc_unique_id ,1);

382: cln_debug_pub.Add('p_net_wt_uom - '|| p_net_wt_uom ,1);
383: cln_debug_pub.Add('p_is_info_pvt - '|| p_is_info_pvt ,1);
384: cln_debug_pub.Add('p_success_flag - '|| p_success_flag ,1);
385: cln_debug_pub.Add('p_gtin_query_id - '|| p_gtin_query_id ,1);
386: cln_debug_pub.Add('p_ucc_doc_unique_id - '|| p_ucc_doc_unique_id ,1);
387: cln_debug_pub.Add('p_xmlg_internal_control_no - '|| p_xmlg_internal_control_no ,1);
388: cln_debug_pub.Add('-------------------------------------------' ,1);
389: END IF;
390:

Line 387: cln_debug_pub.Add('p_xmlg_internal_control_no - '|| p_xmlg_internal_control_no ,1);

383: cln_debug_pub.Add('p_is_info_pvt - '|| p_is_info_pvt ,1);
384: cln_debug_pub.Add('p_success_flag - '|| p_success_flag ,1);
385: cln_debug_pub.Add('p_gtin_query_id - '|| p_gtin_query_id ,1);
386: cln_debug_pub.Add('p_ucc_doc_unique_id - '|| p_ucc_doc_unique_id ,1);
387: cln_debug_pub.Add('p_xmlg_internal_control_no - '|| p_xmlg_internal_control_no ,1);
388: cln_debug_pub.Add('-------------------------------------------' ,1);
389: END IF;
390:
391:

Line 388: cln_debug_pub.Add('-------------------------------------------' ,1);

384: cln_debug_pub.Add('p_success_flag - '|| p_success_flag ,1);
385: cln_debug_pub.Add('p_gtin_query_id - '|| p_gtin_query_id ,1);
386: cln_debug_pub.Add('p_ucc_doc_unique_id - '|| p_ucc_doc_unique_id ,1);
387: cln_debug_pub.Add('p_xmlg_internal_control_no - '|| p_xmlg_internal_control_no ,1);
388: cln_debug_pub.Add('-------------------------------------------' ,1);
389: END IF;
390:
391:
392: -- set CLN Disposition, CLN Coll Status, CLN Doc status, CLN Message Text

Line 406: cln_debug_pub.Add('-- Update collaboration parameters set -',1);

402: l_fnd_msg := 'M4U_GTINQRY_FAILURE';
403: END IF;
404:
405: IF (l_Debug_Level <= 1) THEN
406: cln_debug_pub.Add('-- Update collaboration parameters set -',1);
407: cln_debug_pub.Add('Disposition - '|| l_disposition ,1);
408: cln_debug_pub.Add('Collaboration Status - '|| l_coll_status ,1);
409: cln_debug_pub.Add('Document Status - '|| l_doc_status ,1);
410: cln_debug_pub.Add('FND Message - '|| l_fnd_msg ,1);

Line 407: cln_debug_pub.Add('Disposition - '|| l_disposition ,1);

403: END IF;
404:
405: IF (l_Debug_Level <= 1) THEN
406: cln_debug_pub.Add('-- Update collaboration parameters set -',1);
407: cln_debug_pub.Add('Disposition - '|| l_disposition ,1);
408: cln_debug_pub.Add('Collaboration Status - '|| l_coll_status ,1);
409: cln_debug_pub.Add('Document Status - '|| l_doc_status ,1);
410: cln_debug_pub.Add('FND Message - '|| l_fnd_msg ,1);
411: cln_debug_pub.Add('---------------------------------------' ,1);

Line 408: cln_debug_pub.Add('Collaboration Status - '|| l_coll_status ,1);

404:
405: IF (l_Debug_Level <= 1) THEN
406: cln_debug_pub.Add('-- Update collaboration parameters set -',1);
407: cln_debug_pub.Add('Disposition - '|| l_disposition ,1);
408: cln_debug_pub.Add('Collaboration Status - '|| l_coll_status ,1);
409: cln_debug_pub.Add('Document Status - '|| l_doc_status ,1);
410: cln_debug_pub.Add('FND Message - '|| l_fnd_msg ,1);
411: cln_debug_pub.Add('---------------------------------------' ,1);
412: END IF;

Line 409: cln_debug_pub.Add('Document Status - '|| l_doc_status ,1);

405: IF (l_Debug_Level <= 1) THEN
406: cln_debug_pub.Add('-- Update collaboration parameters set -',1);
407: cln_debug_pub.Add('Disposition - '|| l_disposition ,1);
408: cln_debug_pub.Add('Collaboration Status - '|| l_coll_status ,1);
409: cln_debug_pub.Add('Document Status - '|| l_doc_status ,1);
410: cln_debug_pub.Add('FND Message - '|| l_fnd_msg ,1);
411: cln_debug_pub.Add('---------------------------------------' ,1);
412: END IF;
413:

Line 410: cln_debug_pub.Add('FND Message - '|| l_fnd_msg ,1);

406: cln_debug_pub.Add('-- Update collaboration parameters set -',1);
407: cln_debug_pub.Add('Disposition - '|| l_disposition ,1);
408: cln_debug_pub.Add('Collaboration Status - '|| l_coll_status ,1);
409: cln_debug_pub.Add('Document Status - '|| l_doc_status ,1);
410: cln_debug_pub.Add('FND Message - '|| l_fnd_msg ,1);
411: cln_debug_pub.Add('---------------------------------------' ,1);
412: END IF;
413:
414: cln_ch_collaboration_pkg.update_collaboration(

Line 411: cln_debug_pub.Add('---------------------------------------' ,1);

407: cln_debug_pub.Add('Disposition - '|| l_disposition ,1);
408: cln_debug_pub.Add('Collaboration Status - '|| l_coll_status ,1);
409: cln_debug_pub.Add('Document Status - '|| l_doc_status ,1);
410: cln_debug_pub.Add('FND Message - '|| l_fnd_msg ,1);
411: cln_debug_pub.Add('---------------------------------------' ,1);
412: END IF;
413:
414: cln_ch_collaboration_pkg.update_collaboration(
415: x_return_status => x_return_status,

Line 457: cln_debug_pub.Add('-- Update Collab API returns Values -' ,1);

453: END IF;
454:
455:
456: IF (l_Debug_Level <= 1) THEN
457: cln_debug_pub.Add('-- Update Collab API returns Values -' ,1);
458: cln_debug_pub.Add('Collab Detail Id - '|| l_collab_detail_id ,1);
459: cln_debug_pub.Add('CLN API Return Status - '|| x_return_status ,1);
460: cln_debug_pub.Add('CLN return msg data - '|| x_msg_data ,1);
461: END IF;

Line 458: cln_debug_pub.Add('Collab Detail Id - '|| l_collab_detail_id ,1);

454:
455:
456: IF (l_Debug_Level <= 1) THEN
457: cln_debug_pub.Add('-- Update Collab API returns Values -' ,1);
458: cln_debug_pub.Add('Collab Detail Id - '|| l_collab_detail_id ,1);
459: cln_debug_pub.Add('CLN API Return Status - '|| x_return_status ,1);
460: cln_debug_pub.Add('CLN return msg data - '|| x_msg_data ,1);
461: END IF;
462:

Line 459: cln_debug_pub.Add('CLN API Return Status - '|| x_return_status ,1);

455:
456: IF (l_Debug_Level <= 1) THEN
457: cln_debug_pub.Add('-- Update Collab API returns Values -' ,1);
458: cln_debug_pub.Add('Collab Detail Id - '|| l_collab_detail_id ,1);
459: cln_debug_pub.Add('CLN API Return Status - '|| x_return_status ,1);
460: cln_debug_pub.Add('CLN return msg data - '|| x_msg_data ,1);
461: END IF;
462:
463: -- assign the collab dtl id to out variable

Line 460: cln_debug_pub.Add('CLN return msg data - '|| x_msg_data ,1);

456: IF (l_Debug_Level <= 1) THEN
457: cln_debug_pub.Add('-- Update Collab API returns Values -' ,1);
458: cln_debug_pub.Add('Collab Detail Id - '|| l_collab_detail_id ,1);
459: cln_debug_pub.Add('CLN API Return Status - '|| x_return_status ,1);
460: cln_debug_pub.Add('CLN return msg data - '|| x_msg_data ,1);
461: END IF;
462:
463: -- assign the collab dtl id to out variable
464: x_collab_dtl_id := l_collab_detail_id;

Line 470: cln_debug_pub.Add('-- Error Status :Returning -' ,1);

466: -- check for error. If the return status is failure, move out with the
467: -- collaboration detail id
468: IF (UPPER(p_success_flag) <> 'TRUE') THEN
469: IF (l_Debug_Level <= 1) THEN
470: cln_debug_pub.Add('-- Error Status :Returning -' ,1);
471: cln_debug_pub.Add('Collaboration Detail ID - '||l_collab_detail_id ,1);
472: cln_debug_pub.Add('Exiting - m4u_global_regqry.process_gtin_resp - Response status as false',2);
473: END IF;
474: RETURN;

Line 471: cln_debug_pub.Add('Collaboration Detail ID - '||l_collab_detail_id ,1);

467: -- collaboration detail id
468: IF (UPPER(p_success_flag) <> 'TRUE') THEN
469: IF (l_Debug_Level <= 1) THEN
470: cln_debug_pub.Add('-- Error Status :Returning -' ,1);
471: cln_debug_pub.Add('Collaboration Detail ID - '||l_collab_detail_id ,1);
472: cln_debug_pub.Add('Exiting - m4u_global_regqry.process_gtin_resp - Response status as false',2);
473: END IF;
474: RETURN;
475: END IF;

Line 472: cln_debug_pub.Add('Exiting - m4u_global_regqry.process_gtin_resp - Response status as false',2);

468: IF (UPPER(p_success_flag) <> 'TRUE') THEN
469: IF (l_Debug_Level <= 1) THEN
470: cln_debug_pub.Add('-- Error Status :Returning -' ,1);
471: cln_debug_pub.Add('Collaboration Detail ID - '||l_collab_detail_id ,1);
472: cln_debug_pub.Add('Exiting - m4u_global_regqry.process_gtin_resp - Response status as false',2);
473: END IF;
474: RETURN;
475: END IF;
476:

Line 493: cln_debug_pub.Add('Measurement Values all null. Information requestor different from content owner' ,1);

489: (p_net_content_uom IS NULL) AND
490: (p_net_wt IS NULL) AND
491: (p_net_wt_uom IS NULL)) THEN
492: IF (l_Debug_Level <= 1) THEN
493: cln_debug_pub.Add('Measurement Values all null. Information requestor different from content owner' ,1);
494: cln_debug_pub.Add('Returning with success...' ,1);
495: cln_debug_pub.Add('Exiting - m4u_global_regqry.process_gtin_resp Normal',2);
496: END IF;
497:

Line 494: cln_debug_pub.Add('Returning with success...' ,1);

490: (p_net_wt IS NULL) AND
491: (p_net_wt_uom IS NULL)) THEN
492: IF (l_Debug_Level <= 1) THEN
493: cln_debug_pub.Add('Measurement Values all null. Information requestor different from content owner' ,1);
494: cln_debug_pub.Add('Returning with success...' ,1);
495: cln_debug_pub.Add('Exiting - m4u_global_regqry.process_gtin_resp Normal',2);
496: END IF;
497:
498: RETURN;

Line 495: cln_debug_pub.Add('Exiting - m4u_global_regqry.process_gtin_resp Normal',2);

491: (p_net_wt_uom IS NULL)) THEN
492: IF (l_Debug_Level <= 1) THEN
493: cln_debug_pub.Add('Measurement Values all null. Information requestor different from content owner' ,1);
494: cln_debug_pub.Add('Returning with success...' ,1);
495: cln_debug_pub.Add('Exiting - m4u_global_regqry.process_gtin_resp Normal',2);
496: END IF;
497:
498: RETURN;
499: END IF;

Line 518: cln_debug_pub.Add('---- Item Measurements ---',1);

514: ||' Net Weight - '||p_net_wt
515: ||'( '||p_net_wt_uom||' )';
516:
517: IF (l_Debug_Level <= 1) THEN
518: cln_debug_pub.Add('---- Item Measurements ---',1);
519: cln_debug_pub.Add(l_item_measurmnts,1);
520: cln_debug_pub.Add('---- ----------------- ---',1);
521: END IF;
522:

Line 519: cln_debug_pub.Add(l_item_measurmnts,1);

515: ||'( '||p_net_wt_uom||' )';
516:
517: IF (l_Debug_Level <= 1) THEN
518: cln_debug_pub.Add('---- Item Measurements ---',1);
519: cln_debug_pub.Add(l_item_measurmnts,1);
520: cln_debug_pub.Add('---- ----------------- ---',1);
521: END IF;
522:
523: IF (l_Debug_Level <= 1) THEN

Line 520: cln_debug_pub.Add('---- ----------------- ---',1);

516:
517: IF (l_Debug_Level <= 1) THEN
518: cln_debug_pub.Add('---- Item Measurements ---',1);
519: cln_debug_pub.Add(l_item_measurmnts,1);
520: cln_debug_pub.Add('---- ----------------- ---',1);
521: END IF;
522:
523: IF (l_Debug_Level <= 1) THEN
524: cln_debug_pub.Add('----- Call to Add Collaboration Messages -----',1);

Line 524: cln_debug_pub.Add('----- Call to Add Collaboration Messages -----',1);

520: cln_debug_pub.Add('---- ----------------- ---',1);
521: END IF;
522:
523: IF (l_Debug_Level <= 1) THEN
524: cln_debug_pub.Add('----- Call to Add Collaboration Messages -----',1);
525: END IF;
526:
527: CLN_CH_COLLABORATION_PKG.ADD_COLLABORATION_MESSAGES(
528: x_return_status => x_return_status,

Line 540: cln_debug_pub.Add('Exiting - m4u_global_regqry.process_gtin_resp Normal',2);

536: RAISE FND_API.G_EXC_ERROR;
537: END IF;
538:
539: IF (l_Debug_Level <= 2) THEN
540: cln_debug_pub.Add('Exiting - m4u_global_regqry.process_gtin_resp Normal',2);
541: END IF;
542:
543: EXCEPTION
544: WHEN FND_API.G_EXC_ERROR THEN

Line 547: cln_debug_pub.Add(x_msg_data,4);

543: EXCEPTION
544: WHEN FND_API.G_EXC_ERROR THEN
545: x_return_status := FND_API.G_RET_STS_ERROR ;
546: IF (l_Debug_Level <= 4) THEN
547: cln_debug_pub.Add(x_msg_data,4);
548: cln_debug_pub.Add('------- Exiting m4u_global_regqry.process_gtin_resp - exception --------- ',2);
549: END IF;
550:
551: WHEN OTHERS THEN

Line 548: cln_debug_pub.Add('------- Exiting m4u_global_regqry.process_gtin_resp - exception --------- ',2);

544: WHEN FND_API.G_EXC_ERROR THEN
545: x_return_status := FND_API.G_RET_STS_ERROR ;
546: IF (l_Debug_Level <= 4) THEN
547: cln_debug_pub.Add(x_msg_data,4);
548: cln_debug_pub.Add('------- Exiting m4u_global_regqry.process_gtin_resp - exception --------- ',2);
549: END IF;
550:
551: WHEN OTHERS THEN
552: l_error_code := SQLCODE;

Line 563: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 4);

559:
560: x_msg_data := FND_MESSAGE.GET;
561:
562: IF (l_debug_level <= 5) THEN
563: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 4);
564: END IF;
565:
566: IF (l_debug_level <= 2) THEN
567: cln_debug_pub.add('Exiting m4u_global_regqry.process_gtin_resp - exception',2);

Line 567: cln_debug_pub.add('Exiting m4u_global_regqry.process_gtin_resp - exception',2);

563: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 4);
564: END IF;
565:
566: IF (l_debug_level <= 2) THEN
567: cln_debug_pub.add('Exiting m4u_global_regqry.process_gtin_resp - exception',2);
568: cln_debug_pub.add('====================================================',2);
569: END IF;
570:
571: END;

Line 568: cln_debug_pub.add('====================================================',2);

564: END IF;
565:
566: IF (l_debug_level <= 2) THEN
567: cln_debug_pub.add('Exiting m4u_global_regqry.process_gtin_resp - exception',2);
568: cln_debug_pub.add('====================================================',2);
569: END IF;
570:
571: END;
572: