APPS.OKC_ARTICLES_IMPORT_GRP dependencies on FND_MSG_PUB

Line 164: FND_MSG_PUB.initialize;

160: and a.entity = p_entity
161: and rownum =1;
162:
163: BEGIN
164: FND_MSG_PUB.initialize;
165:
166:
167: FOR get_info_rec in get_info_csr LOOP
168: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 180: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

176: p_token4 => 'TOTAL_FAILED',
177: p_token4_value => get_info_rec.total_rows_failed);
178:
179: END LOOP;
180: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
181:
182: FND_MSG_PUB.initialize;
183: commit;
184: END new_wrap_up;

Line 182: FND_MSG_PUB.initialize;

178:
179: END LOOP;
180: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
181:
182: FND_MSG_PUB.initialize;
183: commit;
184: END new_wrap_up;
185:
186:

Line 258: FND_MSG_PUB.initialize;

254: BEGIN
255: IF p_entity = 'VARIABLE' THEN
256: FOR get_var_info_rec in get_var_info_csr LOOP
257: IF cur_inf_id < 1 THEN
258: FND_MSG_PUB.initialize;
259: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
260: p_msg_name => 'OKC_ART_IMP_HDR_VAR');
261: cur_inf_id := cur_inf_id + 1;
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

Line 262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

258: FND_MSG_PUB.initialize;
259: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
260: p_msg_name => 'OKC_ART_IMP_HDR_VAR');
261: cur_inf_id := cur_inf_id + 1;
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
263: FND_MSG_PUB.initialize;
264: END IF;
265:
266: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 263: FND_MSG_PUB.initialize;

259: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
260: p_msg_name => 'OKC_ART_IMP_HDR_VAR');
261: cur_inf_id := cur_inf_id + 1;
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
263: FND_MSG_PUB.initialize;
264: END IF;
265:
266: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
267: p_msg_name => 'OKC_ART_IMP_OUT_VAR',

Line 274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

270: p_token2 => 'VAR_NAME',
271: p_token2_value => get_var_info_rec.variable_name,
272: p_token3 => 'ERR_MSG',
273: p_token3_value => get_var_info_rec.error_description);
274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
275: FND_MSG_PUB.initialize;
276:
277: END LOOP;
278: ELSIF p_entity = 'VALUESET' THEN

Line 275: FND_MSG_PUB.initialize;

271: p_token2_value => get_var_info_rec.variable_name,
272: p_token3 => 'ERR_MSG',
273: p_token3_value => get_var_info_rec.error_description);
274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
275: FND_MSG_PUB.initialize;
276:
277: END LOOP;
278: ELSIF p_entity = 'VALUESET' THEN
279: FOR get_vs_info_rec in get_vs_info_csr LOOP

Line 281: FND_MSG_PUB.initialize;

277: END LOOP;
278: ELSIF p_entity = 'VALUESET' THEN
279: FOR get_vs_info_rec in get_vs_info_csr LOOP
280: IF cur_inf_id < 1 THEN
281: FND_MSG_PUB.initialize;
282: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
283: p_msg_name => 'OKC_ART_IMP_HDR_VS');
284: cur_inf_id := cur_inf_id + 1;
285: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

Line 285: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

281: FND_MSG_PUB.initialize;
282: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
283: p_msg_name => 'OKC_ART_IMP_HDR_VS');
284: cur_inf_id := cur_inf_id + 1;
285: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
286: FND_MSG_PUB.initialize;
287: END IF;
288:
289: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 286: FND_MSG_PUB.initialize;

282: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
283: p_msg_name => 'OKC_ART_IMP_HDR_VS');
284: cur_inf_id := cur_inf_id + 1;
285: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
286: FND_MSG_PUB.initialize;
287: END IF;
288:
289: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
290: p_msg_name => 'OKC_ART_IMP_OUT_VS',

Line 297: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

293: p_token2 => 'VS_NAME',
294: p_token2_value => get_vs_info_rec.flex_value_set_name,
295: p_token3 => 'ERR_MSG',
296: p_token3_value => get_vs_info_rec.error_description);
297: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
298: FND_MSG_PUB.initialize;
299:
300: END LOOP;
301: ELSIF p_entity = 'RELATIONSHIP' THEN

Line 298: FND_MSG_PUB.initialize;

294: p_token2_value => get_vs_info_rec.flex_value_set_name,
295: p_token3 => 'ERR_MSG',
296: p_token3_value => get_vs_info_rec.error_description);
297: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
298: FND_MSG_PUB.initialize;
299:
300: END LOOP;
301: ELSIF p_entity = 'RELATIONSHIP' THEN
302: FOR get_rel_info_rec in get_rel_info_csr LOOP

Line 304: FND_MSG_PUB.initialize;

300: END LOOP;
301: ELSIF p_entity = 'RELATIONSHIP' THEN
302: FOR get_rel_info_rec in get_rel_info_csr LOOP
303: IF cur_inf_id < 1 THEN
304: FND_MSG_PUB.initialize;
305: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
306: p_msg_name => 'OKC_ART_IMP_HDR_REL');
307: cur_inf_id := cur_inf_id + 1;
308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

Line 308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

304: FND_MSG_PUB.initialize;
305: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
306: p_msg_name => 'OKC_ART_IMP_HDR_REL');
307: cur_inf_id := cur_inf_id + 1;
308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
309: FND_MSG_PUB.initialize;
310: END IF;
311:
312: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 309: FND_MSG_PUB.initialize;

305: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
306: p_msg_name => 'OKC_ART_IMP_HDR_REL');
307: cur_inf_id := cur_inf_id + 1;
308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
309: FND_MSG_PUB.initialize;
310: END IF;
311:
312: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
313: p_msg_name => 'OKC_ART_IMP_OUT_REL',

Line 326: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

322: p_token5 => 'OPER_UNIT',
323: p_token5_value => get_rel_info_rec.org_name,
324: p_token6 => 'ERR_MSG',
325: p_token6_value => get_rel_info_rec.error_description);
326: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
327: FND_MSG_PUB.initialize;
328:
329: END LOOP;
330: ELSIF p_entity = 'VALUE' THEN

Line 327: FND_MSG_PUB.initialize;

323: p_token5_value => get_rel_info_rec.org_name,
324: p_token6 => 'ERR_MSG',
325: p_token6_value => get_rel_info_rec.error_description);
326: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
327: FND_MSG_PUB.initialize;
328:
329: END LOOP;
330: ELSIF p_entity = 'VALUE' THEN
331: FOR get_val_info_rec in get_val_info_csr LOOP

Line 333: FND_MSG_PUB.initialize;

329: END LOOP;
330: ELSIF p_entity = 'VALUE' THEN
331: FOR get_val_info_rec in get_val_info_csr LOOP
332: IF cur_inf_id < 1 THEN
333: FND_MSG_PUB.initialize;
334: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
335: p_msg_name => 'OKC_ART_IMP_HDR_VAL');
336: cur_inf_id := cur_inf_id + 1;
337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

Line 337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

333: FND_MSG_PUB.initialize;
334: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
335: p_msg_name => 'OKC_ART_IMP_HDR_VAL');
336: cur_inf_id := cur_inf_id + 1;
337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
338: FND_MSG_PUB.initialize;
339: END IF;
340:
341: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 338: FND_MSG_PUB.initialize;

334: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
335: p_msg_name => 'OKC_ART_IMP_HDR_VAL');
336: cur_inf_id := cur_inf_id + 1;
337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
338: FND_MSG_PUB.initialize;
339: END IF;
340:
341: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
342: p_msg_name => 'OKC_ART_IMP_OUT_VAL',

Line 351: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

347: p_token3 => 'VS_NAME',
348: p_token3_value => get_val_info_rec.flex_value_set_name,
349: p_token4 => 'ERR_MSG',
350: p_token4_value => get_val_info_rec.error_description);
351: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
352: FND_MSG_PUB.initialize;
353:
354: END LOOP;
355: ELSIF p_entity = 'CLAUSE' THEN

Line 352: FND_MSG_PUB.initialize;

348: p_token3_value => get_val_info_rec.flex_value_set_name,
349: p_token4 => 'ERR_MSG',
350: p_token4_value => get_val_info_rec.error_description);
351: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
352: FND_MSG_PUB.initialize;
353:
354: END LOOP;
355: ELSIF p_entity = 'CLAUSE' THEN
356:

Line 360: FND_MSG_PUB.initialize;

356:
357: FOR get_art_info_rec in get_art_info_csr LOOP
358:
359: IF cur_inf_id < 1 THEN
360: FND_MSG_PUB.initialize;
361: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
362: p_msg_name => 'OKC_ART_IMP_HDR_CLAUSE');
363: cur_inf_id := cur_inf_id + 1;
364: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

Line 364: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

360: FND_MSG_PUB.initialize;
361: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
362: p_msg_name => 'OKC_ART_IMP_HDR_CLAUSE');
363: cur_inf_id := cur_inf_id + 1;
364: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
365: FND_MSG_PUB.initialize;
366:
367: END IF;
368:

Line 365: FND_MSG_PUB.initialize;

361: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
362: p_msg_name => 'OKC_ART_IMP_HDR_CLAUSE');
363: cur_inf_id := cur_inf_id + 1;
364: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
365: FND_MSG_PUB.initialize;
366:
367: END IF;
368:
369: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

378: p_token4_value => get_art_info_rec.org_name,
379: p_token5 => 'ERR_MSG',
380: p_token5_value => get_art_info_rec.error_description);
381:
382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
383: FND_MSG_PUB.initialize;
384: END LOOP;
385: END IF;
386:

Line 383: FND_MSG_PUB.initialize;

379: p_token5 => 'ERR_MSG',
380: p_token5_value => get_art_info_rec.error_description);
381:
382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
383: FND_MSG_PUB.initialize;
384: END LOOP;
385: END IF;
386:
387: EXCEPTION

Line 463: FND_MSG_PUB.initialize;

459: and rownum =1;
460:
461:
462: BEGIN
463: FND_MSG_PUB.initialize;
464:
465: --initialize validate_meaning with p_validate_only
466: --and fetch the translated lookup meaning for this
467: /*

Line 516: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

512: );
513: END LOOP;
514:
515: END IF;
516: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
517:
518: FND_MSG_PUB.initialize;
519: commit;
520: END pre_wrap_up;

Line 518: FND_MSG_PUB.initialize;

514:
515: END IF;
516: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
517:
518: FND_MSG_PUB.initialize;
519: commit;
520: END pre_wrap_up;
521:
522: /*===================================================

Line 688: IF FND_MSG_PUB.Count_Msg > 0 Then

684: EXCEPTION
685: WHEN FND_API.G_EXC_ERROR THEN
686: retcode := 2;
687: errbuf := substr(sqlerrm,1,200);
688: IF FND_MSG_PUB.Count_Msg > 0 Then
689: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
690: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
691: END LOOP;
692: END IF;

Line 689: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

685: WHEN FND_API.G_EXC_ERROR THEN
686: retcode := 2;
687: errbuf := substr(sqlerrm,1,200);
688: IF FND_MSG_PUB.Count_Msg > 0 Then
689: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
690: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
691: END LOOP;
692: END IF;
693: FND_MSG_PUB.initialize;

Line 690: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

686: retcode := 2;
687: errbuf := substr(sqlerrm,1,200);
688: IF FND_MSG_PUB.Count_Msg > 0 Then
689: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
690: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
691: END LOOP;
692: END IF;
693: FND_MSG_PUB.initialize;
694:

Line 693: FND_MSG_PUB.initialize;

689: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
690: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
691: END LOOP;
692: END IF;
693: FND_MSG_PUB.initialize;
694:
695: IF (l_debug = 'Y') THEN
696: okc_debug.Log('3000: Leaving ',2);
697: okc_debug.Reset_Indentation;

Line 930: IF FND_MSG_PUB.Count_Msg > 0 Then

926:
927: EXCEPTION
928: WHEN OKC_API.G_EXCEPTION_ERROR THEN
929: x_return_status := G_RET_STS_ERROR;
930: IF FND_MSG_PUB.Count_Msg > 0 Then
931: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
932: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
933: END LOOP;
934: END IF;

Line 931: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

927: EXCEPTION
928: WHEN OKC_API.G_EXCEPTION_ERROR THEN
929: x_return_status := G_RET_STS_ERROR;
930: IF FND_MSG_PUB.Count_Msg > 0 Then
931: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
932: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
933: END LOOP;
934: END IF;
935: FND_MSG_PUB.initialize;

Line 932: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

928: WHEN OKC_API.G_EXCEPTION_ERROR THEN
929: x_return_status := G_RET_STS_ERROR;
930: IF FND_MSG_PUB.Count_Msg > 0 Then
931: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
932: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
933: END LOOP;
934: END IF;
935: FND_MSG_PUB.initialize;
936:

Line 935: FND_MSG_PUB.initialize;

931: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
932: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
933: END LOOP;
934: END IF;
935: FND_MSG_PUB.initialize;
936:
937: IF (l_debug = 'Y') THEN
938: okc_debug.Log('3000: Leaving conc_import_articles',2);
939: okc_debug.Reset_Indentation;

Line 943: IF FND_MSG_PUB.Count_Msg > 0 Then

939: okc_debug.Reset_Indentation;
940: END IF;
941: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
942: x_return_status := G_RET_STS_UNEXP_ERROR;
943: IF FND_MSG_PUB.Count_Msg > 0 Then
944: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
945: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
946: END LOOP;
947: END IF;

Line 944: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

940: END IF;
941: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
942: x_return_status := G_RET_STS_UNEXP_ERROR;
943: IF FND_MSG_PUB.Count_Msg > 0 Then
944: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
945: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
946: END LOOP;
947: END IF;
948: FND_MSG_PUB.initialize;

Line 945: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

941: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
942: x_return_status := G_RET_STS_UNEXP_ERROR;
943: IF FND_MSG_PUB.Count_Msg > 0 Then
944: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
945: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
946: END LOOP;
947: END IF;
948: FND_MSG_PUB.initialize;
949: IF (l_debug = 'Y') THEN

Line 948: FND_MSG_PUB.initialize;

944: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
945: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
946: END LOOP;
947: END IF;
948: FND_MSG_PUB.initialize;
949: IF (l_debug = 'Y') THEN
950: okc_debug.Log('4000: Leaving conc_import_articles',2);
951: okc_debug.Reset_Indentation;
952: END IF;

Line 956: IF FND_MSG_PUB.Count_Msg > 0 Then

952: END IF;
953:
954: WHEN OTHERS THEN
955: x_return_status := G_RET_STS_UNEXP_ERROR;
956: IF FND_MSG_PUB.Count_Msg > 0 Then
957: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
958: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
959: END LOOP;
960: END IF;

Line 957: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

953:
954: WHEN OTHERS THEN
955: x_return_status := G_RET_STS_UNEXP_ERROR;
956: IF FND_MSG_PUB.Count_Msg > 0 Then
957: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
958: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
959: END LOOP;
960: END IF;
961: FND_MSG_PUB.initialize;

Line 958: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

954: WHEN OTHERS THEN
955: x_return_status := G_RET_STS_UNEXP_ERROR;
956: IF FND_MSG_PUB.Count_Msg > 0 Then
957: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
958: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
959: END LOOP;
960: END IF;
961: FND_MSG_PUB.initialize;
962: IF (l_debug = 'Y') THEN

Line 961: FND_MSG_PUB.initialize;

957: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
958: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
959: END LOOP;
960: END IF;
961: FND_MSG_PUB.initialize;
962: IF (l_debug = 'Y') THEN
963: okc_debug.Log('5000: Leaving conc_import_articles',2);
964: okc_debug.Reset_Indentation;
965: END IF;

Line 993: IF FND_MSG_PUB.Count_Msg > 0 Then

989:
990: EXCEPTION
991: WHEN OKC_API.G_EXCEPTION_ERROR THEN
992: x_return_status := G_RET_STS_ERROR;
993: IF FND_MSG_PUB.Count_Msg > 0 Then
994: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
995: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
996: END LOOP;
997: END IF;

Line 994: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

990: EXCEPTION
991: WHEN OKC_API.G_EXCEPTION_ERROR THEN
992: x_return_status := G_RET_STS_ERROR;
993: IF FND_MSG_PUB.Count_Msg > 0 Then
994: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
995: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
996: END LOOP;
997: END IF;
998: FND_MSG_PUB.initialize;

Line 995: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

991: WHEN OKC_API.G_EXCEPTION_ERROR THEN
992: x_return_status := G_RET_STS_ERROR;
993: IF FND_MSG_PUB.Count_Msg > 0 Then
994: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
995: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
996: END LOOP;
997: END IF;
998: FND_MSG_PUB.initialize;
999:

Line 998: FND_MSG_PUB.initialize;

994: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
995: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
996: END LOOP;
997: END IF;
998: FND_MSG_PUB.initialize;
999:
1000: IF (l_debug = 'Y') THEN
1001: okc_debug.Log('3000: Leaving conc_import_articles',2);
1002: okc_debug.Reset_Indentation;

Line 1006: IF FND_MSG_PUB.Count_Msg > 0 Then

1002: okc_debug.Reset_Indentation;
1003: END IF;
1004: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1005: x_return_status := G_RET_STS_UNEXP_ERROR;
1006: IF FND_MSG_PUB.Count_Msg > 0 Then
1007: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1008: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1009: END LOOP;
1010: END IF;

Line 1007: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

1003: END IF;
1004: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1005: x_return_status := G_RET_STS_UNEXP_ERROR;
1006: IF FND_MSG_PUB.Count_Msg > 0 Then
1007: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1008: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1009: END LOOP;
1010: END IF;
1011: FND_MSG_PUB.initialize;

Line 1008: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

1004: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1005: x_return_status := G_RET_STS_UNEXP_ERROR;
1006: IF FND_MSG_PUB.Count_Msg > 0 Then
1007: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1008: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1009: END LOOP;
1010: END IF;
1011: FND_MSG_PUB.initialize;
1012: IF (l_debug = 'Y') THEN

Line 1011: FND_MSG_PUB.initialize;

1007: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1008: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1009: END LOOP;
1010: END IF;
1011: FND_MSG_PUB.initialize;
1012: IF (l_debug = 'Y') THEN
1013: okc_debug.Log('4000: Leaving conc_import_articles',2);
1014: okc_debug.Reset_Indentation;
1015: END IF;

Line 1019: IF FND_MSG_PUB.Count_Msg > 0 Then

1015: END IF;
1016:
1017: WHEN OTHERS THEN
1018: x_return_status := G_RET_STS_UNEXP_ERROR;
1019: IF FND_MSG_PUB.Count_Msg > 0 Then
1020: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1021: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1022: END LOOP;
1023: END IF;

Line 1020: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

1016:
1017: WHEN OTHERS THEN
1018: x_return_status := G_RET_STS_UNEXP_ERROR;
1019: IF FND_MSG_PUB.Count_Msg > 0 Then
1020: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1021: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1022: END LOOP;
1023: END IF;
1024: FND_MSG_PUB.initialize;

Line 1021: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

1017: WHEN OTHERS THEN
1018: x_return_status := G_RET_STS_UNEXP_ERROR;
1019: IF FND_MSG_PUB.Count_Msg > 0 Then
1020: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1021: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1022: END LOOP;
1023: END IF;
1024: FND_MSG_PUB.initialize;
1025: IF (l_debug = 'Y') THEN

Line 1024: FND_MSG_PUB.initialize;

1020: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1021: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1022: END LOOP;
1023: END IF;
1024: FND_MSG_PUB.initialize;
1025: IF (l_debug = 'Y') THEN
1026: okc_debug.Log('5000: Leaving conc_import_articles',2);
1027: okc_debug.Reset_Indentation;
1028: END IF;

Line 1056: IF FND_MSG_PUB.Count_Msg > 0 Then

1052:
1053: EXCEPTION
1054: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1055: x_return_status := G_RET_STS_ERROR;
1056: IF FND_MSG_PUB.Count_Msg > 0 Then
1057: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1058: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1059: END LOOP;
1060: END IF;

Line 1057: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

1053: EXCEPTION
1054: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1055: x_return_status := G_RET_STS_ERROR;
1056: IF FND_MSG_PUB.Count_Msg > 0 Then
1057: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1058: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1059: END LOOP;
1060: END IF;
1061: FND_MSG_PUB.initialize;

Line 1058: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

1054: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1055: x_return_status := G_RET_STS_ERROR;
1056: IF FND_MSG_PUB.Count_Msg > 0 Then
1057: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1058: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1059: END LOOP;
1060: END IF;
1061: FND_MSG_PUB.initialize;
1062:

Line 1061: FND_MSG_PUB.initialize;

1057: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1058: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1059: END LOOP;
1060: END IF;
1061: FND_MSG_PUB.initialize;
1062:
1063: IF (l_debug = 'Y') THEN
1064: okc_debug.Log('3000: Leaving conc_import_articles',2);
1065: okc_debug.Reset_Indentation;

Line 1069: IF FND_MSG_PUB.Count_Msg > 0 Then

1065: okc_debug.Reset_Indentation;
1066: END IF;
1067: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1068: x_return_status := G_RET_STS_UNEXP_ERROR;
1069: IF FND_MSG_PUB.Count_Msg > 0 Then
1070: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1071: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1072: END LOOP;
1073: END IF;

Line 1070: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

1066: END IF;
1067: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1068: x_return_status := G_RET_STS_UNEXP_ERROR;
1069: IF FND_MSG_PUB.Count_Msg > 0 Then
1070: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1071: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1072: END LOOP;
1073: END IF;
1074: FND_MSG_PUB.initialize;

Line 1071: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

1067: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1068: x_return_status := G_RET_STS_UNEXP_ERROR;
1069: IF FND_MSG_PUB.Count_Msg > 0 Then
1070: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1071: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1072: END LOOP;
1073: END IF;
1074: FND_MSG_PUB.initialize;
1075: IF (l_debug = 'Y') THEN

Line 1074: FND_MSG_PUB.initialize;

1070: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1071: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1072: END LOOP;
1073: END IF;
1074: FND_MSG_PUB.initialize;
1075: IF (l_debug = 'Y') THEN
1076: okc_debug.Log('4000: Leaving conc_import_articles',2);
1077: okc_debug.Reset_Indentation;
1078: END IF;

Line 1082: IF FND_MSG_PUB.Count_Msg > 0 Then

1078: END IF;
1079:
1080: WHEN OTHERS THEN
1081: x_return_status := G_RET_STS_UNEXP_ERROR;
1082: IF FND_MSG_PUB.Count_Msg > 0 Then
1083: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1084: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1085: END LOOP;
1086: END IF;

Line 1083: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

1079:
1080: WHEN OTHERS THEN
1081: x_return_status := G_RET_STS_UNEXP_ERROR;
1082: IF FND_MSG_PUB.Count_Msg > 0 Then
1083: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1084: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1085: END LOOP;
1086: END IF;
1087: FND_MSG_PUB.initialize;

Line 1084: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

1080: WHEN OTHERS THEN
1081: x_return_status := G_RET_STS_UNEXP_ERROR;
1082: IF FND_MSG_PUB.Count_Msg > 0 Then
1083: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1084: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1085: END LOOP;
1086: END IF;
1087: FND_MSG_PUB.initialize;
1088: IF (l_debug = 'Y') THEN

Line 1087: FND_MSG_PUB.initialize;

1083: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1084: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1085: END LOOP;
1086: END IF;
1087: FND_MSG_PUB.initialize;
1088: IF (l_debug = 'Y') THEN
1089: okc_debug.Log('5000: Leaving conc_import_articles',2);
1090: okc_debug.Reset_Indentation;
1091: END IF;

Line 1131: IF FND_MSG_PUB.Count_Msg > 0 Then

1127:
1128: EXCEPTION
1129: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1130: x_return_status := G_RET_STS_ERROR;
1131: IF FND_MSG_PUB.Count_Msg > 0 Then
1132: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1133: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1134: END LOOP;
1135: END IF;

Line 1132: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

1128: EXCEPTION
1129: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1130: x_return_status := G_RET_STS_ERROR;
1131: IF FND_MSG_PUB.Count_Msg > 0 Then
1132: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1133: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1134: END LOOP;
1135: END IF;
1136: FND_MSG_PUB.initialize;

Line 1133: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

1129: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1130: x_return_status := G_RET_STS_ERROR;
1131: IF FND_MSG_PUB.Count_Msg > 0 Then
1132: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1133: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1134: END LOOP;
1135: END IF;
1136: FND_MSG_PUB.initialize;
1137:

Line 1136: FND_MSG_PUB.initialize;

1132: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1133: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1134: END LOOP;
1135: END IF;
1136: FND_MSG_PUB.initialize;
1137:
1138: IF (l_debug = 'Y') THEN
1139: okc_debug.Log('3000: Leaving conc_import_articles',2);
1140: okc_debug.Reset_Indentation;

Line 1144: IF FND_MSG_PUB.Count_Msg > 0 Then

1140: okc_debug.Reset_Indentation;
1141: END IF;
1142: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1143: x_return_status := G_RET_STS_UNEXP_ERROR;
1144: IF FND_MSG_PUB.Count_Msg > 0 Then
1145: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1146: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1147: END LOOP;
1148: END IF;

Line 1145: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

1141: END IF;
1142: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1143: x_return_status := G_RET_STS_UNEXP_ERROR;
1144: IF FND_MSG_PUB.Count_Msg > 0 Then
1145: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1146: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1147: END LOOP;
1148: END IF;
1149: FND_MSG_PUB.initialize;

Line 1146: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

1142: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1143: x_return_status := G_RET_STS_UNEXP_ERROR;
1144: IF FND_MSG_PUB.Count_Msg > 0 Then
1145: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1146: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1147: END LOOP;
1148: END IF;
1149: FND_MSG_PUB.initialize;
1150: IF (l_debug = 'Y') THEN

Line 1149: FND_MSG_PUB.initialize;

1145: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1146: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1147: END LOOP;
1148: END IF;
1149: FND_MSG_PUB.initialize;
1150: IF (l_debug = 'Y') THEN
1151: okc_debug.Log('4000: Leaving conc_import_articles',2);
1152: okc_debug.Reset_Indentation;
1153: END IF;

Line 1157: IF FND_MSG_PUB.Count_Msg > 0 Then

1153: END IF;
1154:
1155: WHEN OTHERS THEN
1156: x_return_status := G_RET_STS_UNEXP_ERROR;
1157: IF FND_MSG_PUB.Count_Msg > 0 Then
1158: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1159: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1160: END LOOP;
1161: END IF;

Line 1158: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

1154:
1155: WHEN OTHERS THEN
1156: x_return_status := G_RET_STS_UNEXP_ERROR;
1157: IF FND_MSG_PUB.Count_Msg > 0 Then
1158: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1159: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1160: END LOOP;
1161: END IF;
1162: FND_MSG_PUB.initialize;

Line 1159: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

1155: WHEN OTHERS THEN
1156: x_return_status := G_RET_STS_UNEXP_ERROR;
1157: IF FND_MSG_PUB.Count_Msg > 0 Then
1158: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1159: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1160: END LOOP;
1161: END IF;
1162: FND_MSG_PUB.initialize;
1163: IF (l_debug = 'Y') THEN

Line 1162: FND_MSG_PUB.initialize;

1158: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1159: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1160: END LOOP;
1161: END IF;
1162: FND_MSG_PUB.initialize;
1163: IF (l_debug = 'Y') THEN
1164: okc_debug.Log('5000: Leaving conc_import_articles',2);
1165: okc_debug.Reset_Indentation;
1166: END IF;

Line 1204: IF FND_MSG_PUB.Count_Msg > 0 Then

1200:
1201: EXCEPTION
1202: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1203: x_return_status := G_RET_STS_ERROR;
1204: IF FND_MSG_PUB.Count_Msg > 0 Then
1205: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1206: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1207: END LOOP;
1208: END IF;

Line 1205: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

1201: EXCEPTION
1202: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1203: x_return_status := G_RET_STS_ERROR;
1204: IF FND_MSG_PUB.Count_Msg > 0 Then
1205: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1206: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1207: END LOOP;
1208: END IF;
1209: FND_MSG_PUB.initialize;

Line 1206: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

1202: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1203: x_return_status := G_RET_STS_ERROR;
1204: IF FND_MSG_PUB.Count_Msg > 0 Then
1205: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1206: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1207: END LOOP;
1208: END IF;
1209: FND_MSG_PUB.initialize;
1210:

Line 1209: FND_MSG_PUB.initialize;

1205: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1206: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1207: END LOOP;
1208: END IF;
1209: FND_MSG_PUB.initialize;
1210:
1211: IF (l_debug = 'Y') THEN
1212: okc_debug.Log('3000: Leaving conc_import_articles',2);
1213: okc_debug.Reset_Indentation;

Line 1217: IF FND_MSG_PUB.Count_Msg > 0 Then

1213: okc_debug.Reset_Indentation;
1214: END IF;
1215: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1216: x_return_status := G_RET_STS_UNEXP_ERROR;
1217: IF FND_MSG_PUB.Count_Msg > 0 Then
1218: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1219: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1220: END LOOP;
1221: END IF;

Line 1218: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

1214: END IF;
1215: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1216: x_return_status := G_RET_STS_UNEXP_ERROR;
1217: IF FND_MSG_PUB.Count_Msg > 0 Then
1218: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1219: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1220: END LOOP;
1221: END IF;
1222: FND_MSG_PUB.initialize;

Line 1219: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

1215: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1216: x_return_status := G_RET_STS_UNEXP_ERROR;
1217: IF FND_MSG_PUB.Count_Msg > 0 Then
1218: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1219: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1220: END LOOP;
1221: END IF;
1222: FND_MSG_PUB.initialize;
1223: IF (l_debug = 'Y') THEN

Line 1222: FND_MSG_PUB.initialize;

1218: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1219: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1220: END LOOP;
1221: END IF;
1222: FND_MSG_PUB.initialize;
1223: IF (l_debug = 'Y') THEN
1224: okc_debug.Log('4000: Leaving conc_import_articles',2);
1225: okc_debug.Reset_Indentation;
1226: END IF;

Line 1230: IF FND_MSG_PUB.Count_Msg > 0 Then

1226: END IF;
1227:
1228: WHEN OTHERS THEN
1229: x_return_status := G_RET_STS_UNEXP_ERROR;
1230: IF FND_MSG_PUB.Count_Msg > 0 Then
1231: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1232: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1233: END LOOP;
1234: END IF;

Line 1231: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

1227:
1228: WHEN OTHERS THEN
1229: x_return_status := G_RET_STS_UNEXP_ERROR;
1230: IF FND_MSG_PUB.Count_Msg > 0 Then
1231: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1232: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1233: END LOOP;
1234: END IF;
1235: FND_MSG_PUB.initialize;

Line 1232: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

1228: WHEN OTHERS THEN
1229: x_return_status := G_RET_STS_UNEXP_ERROR;
1230: IF FND_MSG_PUB.Count_Msg > 0 Then
1231: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1232: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1233: END LOOP;
1234: END IF;
1235: FND_MSG_PUB.initialize;
1236: IF (l_debug = 'Y') THEN

Line 1235: FND_MSG_PUB.initialize;

1231: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1232: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1233: END LOOP;
1234: END IF;
1235: FND_MSG_PUB.initialize;
1236: IF (l_debug = 'Y') THEN
1237: okc_debug.Log('5000: Leaving conc_import_articles',2);
1238: okc_debug.Reset_Indentation;
1239: END IF;

Line 1247: FND_MSG_PUB.initialize;

1243: IF l_wrap_up = 'Y' THEN
1244: pre_wrap_up(p_validate_only,p_batch_number,p_batch_procs_id);
1245: l_wrap_up := 'N';
1246: END IF;
1247: FND_MSG_PUB.initialize;
1248: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1249: p_msg_name => 'OKC_ART_NOT_VALID_ORG',
1250: p_token1 => 'ORG_NAME',
1251: p_token1_value => rec.org_name);

Line 1252: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

1248: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1249: p_msg_name => 'OKC_ART_NOT_VALID_ORG',
1250: p_token1 => 'ORG_NAME',
1251: p_token1_value => rec.org_name);
1252: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
1253:
1254: FND_MSG_PUB.initialize;
1255: commit;
1256:

Line 1254: FND_MSG_PUB.initialize;

1250: p_token1 => 'ORG_NAME',
1251: p_token1_value => rec.org_name);
1252: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
1253:
1254: FND_MSG_PUB.initialize;
1255: commit;
1256:
1257: END IF;
1258: END LOOP;

Line 1303: FND_MSG_PUB.initialize;

1299: new_wrap_up(p_batch_number,'Relationship',l_batch_process_id);
1300: new_wrap_up(p_batch_number,'Variable',l_batch_process_id);
1301: new_wrap_up(p_batch_number,'Valueset',l_batch_process_id);
1302: new_wrap_up(p_batch_number,'Value',l_batch_process_id);
1303: FND_MSG_PUB.initialize;
1304: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1305: p_msg_name => 'OKC_ART_IMP_ERR');
1306:
1307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

Line 1307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

1303: FND_MSG_PUB.initialize;
1304: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1305: p_msg_name => 'OKC_ART_IMP_ERR');
1306:
1307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
1308:
1309: FND_MSG_PUB.initialize;
1310: post_wrap_up(p_batch_number,'CLAUSE',l_batch_process_id);
1311: post_wrap_up(p_batch_number,'RELATIONSHIP',l_batch_process_id);

Line 1309: FND_MSG_PUB.initialize;

1305: p_msg_name => 'OKC_ART_IMP_ERR');
1306:
1307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
1308:
1309: FND_MSG_PUB.initialize;
1310: post_wrap_up(p_batch_number,'CLAUSE',l_batch_process_id);
1311: post_wrap_up(p_batch_number,'RELATIONSHIP',l_batch_process_id);
1312: post_wrap_up(p_batch_number,'VARIABLE',l_batch_process_id);
1313: post_wrap_up(p_batch_number,'VALUESET',l_batch_process_id);

Line 1316: FND_MSG_PUB.initialize;

1312: post_wrap_up(p_batch_number,'VARIABLE',l_batch_process_id);
1313: post_wrap_up(p_batch_number,'VALUESET',l_batch_process_id);
1314: post_wrap_up(p_batch_number,'VALUE',l_batch_process_id);
1315:
1316: FND_MSG_PUB.initialize;
1317: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1318: p_msg_name => 'OKC_ART_IMP_OUT_EOR');
1319:
1320: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

Line 1320: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

1316: FND_MSG_PUB.initialize;
1317: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1318: p_msg_name => 'OKC_ART_IMP_OUT_EOR');
1319:
1320: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
1321:
1322: FND_MSG_PUB.initialize;
1323: END conc_import_articles;
1324:

Line 1322: FND_MSG_PUB.initialize;

1318: p_msg_name => 'OKC_ART_IMP_OUT_EOR');
1319:
1320: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
1321:
1322: FND_MSG_PUB.initialize;
1323: END conc_import_articles;
1324:
1325: /*===================================================
1326: | Get Sequence Number for New Article or New Version

Line 1485: FND_MSG_PUB.initialize;

1481: -- End Added for XML Based Clause Import
1482:
1483: IF cur_inf_id <> err_interface_id_tbl(i_err) THEN
1484: cur_inf_id := err_interface_id_tbl(i_err);
1485: FND_MSG_PUB.initialize;
1486: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1487: p_msg_name => 'OKC_ART_IMP_LOG_HEADER',
1488: p_token1 => 'ENTITY',
1489: p_token1_value => err_entity_tbl(i_err),

Line 1494: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

1490: p_token2 => 'ARTICLE_TITLE',
1491: p_token2_value => err_article_title_tbl(i_err),
1492: p_token3 => 'INTERFACE_ID',
1493: p_token3_value => err_interface_id_tbl(i_err));
1494: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
1495: FND_MSG_PUB.initialize;
1496: END IF;
1497: FND_FILE.PUT_LINE(FND_FILE.LOG, err_error_description_tbl(i_err));
1498: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

Line 1495: FND_MSG_PUB.initialize;

1491: p_token2_value => err_article_title_tbl(i_err),
1492: p_token3 => 'INTERFACE_ID',
1493: p_token3_value => err_interface_id_tbl(i_err));
1494: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
1495: FND_MSG_PUB.initialize;
1496: END IF;
1497: FND_FILE.PUT_LINE(FND_FILE.LOG, err_error_description_tbl(i_err));
1498: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
1499:

Line 1549: IF FND_MSG_PUB.Count_Msg >= 1 Then

1545: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1546: l_msg_count NUMBER;
1547: l_msg_data VARCHAR2(1000);
1548: BEGIN
1549: IF FND_MSG_PUB.Count_Msg >= 1 Then
1550: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1551: err_batch_process_id_tbl(l_error_index) := p_batch_process_id;
1552: err_interface_id_tbl(l_error_index) := p_interface_id ;
1553: err_article_title_tbl(l_error_index) := p_article_title ;

Line 1550: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

1546: l_msg_count NUMBER;
1547: l_msg_data VARCHAR2(1000);
1548: BEGIN
1549: IF FND_MSG_PUB.Count_Msg >= 1 Then
1550: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1551: err_batch_process_id_tbl(l_error_index) := p_batch_process_id;
1552: err_interface_id_tbl(l_error_index) := p_interface_id ;
1553: err_article_title_tbl(l_error_index) := p_article_title ;
1554: err_error_number_tbl(l_error_index) := l_error_index ;

Line 1558: --err_error_description_tbl(l_error_index) := p_context ||':'|| FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE );

1554: err_error_number_tbl(l_error_index) := l_error_index ;
1555: err_object_version_number_tbl(l_error_index) := 1.0 ;
1556: err_error_type_tbl(l_error_index) := p_error_type ;
1557: err_entity_tbl(l_error_index) := p_entity ;
1558: --err_error_description_tbl(l_error_index) := p_context ||':'|| FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE );
1559: err_error_description_tbl(l_error_index) := FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE );
1560: l_error_index := l_error_index + 1;
1561: END LOOP;
1562: ELSE IF p_msg_data is not NULL Then

Line 1559: err_error_description_tbl(l_error_index) := FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE );

1555: err_object_version_number_tbl(l_error_index) := 1.0 ;
1556: err_error_type_tbl(l_error_index) := p_error_type ;
1557: err_entity_tbl(l_error_index) := p_entity ;
1558: --err_error_description_tbl(l_error_index) := p_context ||':'|| FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE );
1559: err_error_description_tbl(l_error_index) := FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE );
1560: l_error_index := l_error_index + 1;
1561: END LOOP;
1562: ELSE IF p_msg_data is not NULL Then
1563: err_batch_process_id_tbl(l_error_index) := p_batch_process_id;

Line 1581: FND_MSG_PUB.initialize;

1577: x_msg_count => l_msg_count,
1578: x_msg_data => l_msg_data
1579: );
1580:
1581: FND_MSG_PUB.initialize;
1582: END build_error_array;
1583:
1584:
1585: /*===================================================

Line 1607: FND_MSG_PUB.initialize;

1603: -- whenever there is a change in interface id, we will change header
1604: --
1605: IF cur_inf_id <> err_interface_id_tbl(i_err) THEN
1606: cur_inf_id := err_interface_id_tbl(i_err);
1607: FND_MSG_PUB.initialize;
1608: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1609: p_msg_name => 'OKC_ART_IMP_LOG_HEADER',
1610: p_token1 => 'ENTITY',
1611: p_token1_value => err_entity_tbl(i_err),

Line 1614: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

1610: p_token1 => 'ENTITY',
1611: p_token1_value => err_entity_tbl(i_err),
1612: p_token2 => 'ARTICLE_TITLE',
1613: p_token2_value => err_article_title_tbl(i_err));
1614: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
1615: END IF;
1616:
1617: FND_FILE.PUT_LINE(FND_FILE.LOG, err_error_description_tbl(i_err));
1618: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

Line 1623: IF FND_MSG_PUB.Count_Msg > 1 Then

1619:
1620: END LOOP;
1621: END IF;
1622:
1623: IF FND_MSG_PUB.Count_Msg > 1 Then
1624: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1625: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1626: END LOOP;
1627: ELSE

Line 1624: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

1620: END LOOP;
1621: END IF;
1622:
1623: IF FND_MSG_PUB.Count_Msg > 1 Then
1624: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1625: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1626: END LOOP;
1627: ELSE
1628: FND_FILE.PUT_LINE(FND_FILE.LOG,p_msg_data);

Line 1625: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

1621: END IF;
1622:
1623: IF FND_MSG_PUB.Count_Msg > 1 Then
1624: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1625: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
1626: END LOOP;
1627: ELSE
1628: FND_FILE.PUT_LINE(FND_FILE.LOG,p_msg_data);
1629: END IF;

Line 1632: FND_MSG_PUB.initialize;

1628: FND_FILE.PUT_LINE(FND_FILE.LOG,p_msg_data);
1629: END IF;
1630:
1631: --recycle it
1632: FND_MSG_PUB.initialize;
1633:
1634: END get_print_msgs_stack;
1635:
1636:

Line 1673: FND_MSG_PUB.initialize;

1669: SELECT meaning
1670: FROM fnd_lookups
1671: WHERE lookup_type = 'OKC_ARTICLE_IMPORT_ENTITY' and lookup_code = cp_ent_code;
1672: BEGIN
1673: FND_MSG_PUB.initialize;
1674:
1675: --initialize validate_meaning with p_validate_only
1676: --and fetch the translated lookup meaning for this
1677: l_entity := p_entity;

Line 1738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

1734: p_token3_value => l_tot_rows_processed-l_tot_rows_failed,
1735: p_token4 => 'TOTAL_FAILED',
1736: p_token4_value => l_tot_rows_failed);
1737:
1738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
1739:
1740: FND_MSG_PUB.initialize;
1741: commit;
1742: END wrap_up;

Line 1740: FND_MSG_PUB.initialize;

1736: p_token4_value => l_tot_rows_failed);
1737:
1738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
1739:
1740: FND_MSG_PUB.initialize;
1741: commit;
1742: END wrap_up;
1743:
1744: /*===================================================

Line 2082: FND_MSG_PUB.initialize;

2078: -- Variable Initialization
2079: -------------------------------------------------------------------------
2080:
2081: -- Standard Start of API savepoint
2082: FND_MSG_PUB.initialize;
2083: -- Initialize API return status to success
2084: x_return_status := FND_API.G_RET_STS_SUCCESS;
2085: l_return_status := G_RET_STS_SUCCESS;
2086: -- Cache user_id, login_id and org_id

Line 4212: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

4208: CLOSE validate_article_type_csr;
4209: END IF;
4210:
4211: x_return_status := G_RET_STS_UNEXP_ERROR ;
4212: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4213: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4214: END IF;
4215: get_print_msgs_stack(p_msg_data => x_msg_data);
4216:

Line 4213: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

4209: END IF;
4210:
4211: x_return_status := G_RET_STS_UNEXP_ERROR ;
4212: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4213: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4214: END IF;
4215: get_print_msgs_stack(p_msg_data => x_msg_data);
4216:
4217: WHEN l_insert_errors_exception THEN

Line 4263: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

4259: END IF;
4260:
4261:
4262: --x_return_status := G_RET_STS_UNEXP_ERROR ;
4263: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4265: END IF;
4266:
4267: get_print_msgs_stack(p_msg_data => x_msg_data);

Line 4264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

4260:
4261:
4262: --x_return_status := G_RET_STS_UNEXP_ERROR ;
4263: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4265: END IF;
4266:
4267: get_print_msgs_stack(p_msg_data => x_msg_data);
4268: commit;

Line 4313: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

4309: CLOSE validate_article_type_csr;
4310: END IF;
4311:
4312: x_return_status := G_RET_STS_UNEXP_ERROR ;
4313: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4314: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4315: END IF;
4316: get_print_msgs_stack(p_msg_data => x_msg_data);
4317:

Line 4314: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

4310: END IF;
4311:
4312: x_return_status := G_RET_STS_UNEXP_ERROR ;
4313: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4314: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4315: END IF;
4316: get_print_msgs_stack(p_msg_data => x_msg_data);
4317:
4318: END import_articles;

Line 4578: FND_MSG_PUB.initialize;

4574: -- Variable Initialization
4575: -------------------------------------------------------------------------
4576:
4577: -- Standard Start of API savepoint
4578: FND_MSG_PUB.initialize;
4579: -- Initialize API return status to success
4580: x_return_status := FND_API.G_RET_STS_SUCCESS;
4581: l_return_status := G_RET_STS_SUCCESS;
4582: -- Cache user_id, login_id and org_id

Line 5807: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

5803: CLOSE l_var_interface_csr;
5804: END IF;
5805:
5806: x_return_status := G_RET_STS_UNEXP_ERROR ;
5807: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5808: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5809: END IF;
5810: get_print_msgs_stack(p_msg_data => x_msg_data);
5811:

Line 5808: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

5804: END IF;
5805:
5806: x_return_status := G_RET_STS_UNEXP_ERROR ;
5807: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5808: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5809: END IF;
5810: get_print_msgs_stack(p_msg_data => x_msg_data);
5811:
5812: WHEN l_insert_errors_exception THEN

Line 5827: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

5823: END IF;
5824:
5825:
5826: --x_return_status := G_RET_STS_UNEXP_ERROR ;
5827: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5828: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5829: END IF;
5830: get_print_msgs_stack(p_msg_data => x_msg_data);
5831: commit;

Line 5828: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

5824:
5825:
5826: --x_return_status := G_RET_STS_UNEXP_ERROR ;
5827: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5828: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5829: END IF;
5830: get_print_msgs_stack(p_msg_data => x_msg_data);
5831: commit;
5832:

Line 5850: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

5846: CLOSE l_var_interface_csr;
5847: END IF;
5848:
5849: x_return_status := G_RET_STS_UNEXP_ERROR ;
5850: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5851: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5852: END IF;
5853: get_print_msgs_stack(p_msg_data => x_msg_data);
5854: END import_variables;

Line 5851: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

5847: END IF;
5848:
5849: x_return_status := G_RET_STS_UNEXP_ERROR ;
5850: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5851: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5852: END IF;
5853: get_print_msgs_stack(p_msg_data => x_msg_data);
5854: END import_variables;
5855:

Line 6013: FND_MSG_PUB.initialize;

6009: -------------------------------------------------------------------------
6010:
6011:
6012: -- Standard Start of API savepoint
6013: FND_MSG_PUB.initialize;
6014: -- Initialize API return status to success
6015: x_return_status := FND_API.G_RET_STS_SUCCESS;
6016: l_return_status := G_RET_STS_SUCCESS;
6017: -- Cache user_id, login_id and org_id

Line 6891: FND_MSG_PUB.initialize;

6887: -- Print statistic of this run in the log
6888: -- Commented for new XML Based Import - Moved to new_wrap_up in conc_import_articles
6889: --wrap_up(p_validate_only,p_batch_number,l_tot_rows_processed,l_tot_rows_failed,l_tot_rows_warned,l_batch_process_id,'RELATIONSHIP');
6890: /*
6891: FND_MSG_PUB.initialize;
6892: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6893: p_msg_name => 'OKC_ART_IMP_ERR');
6894:
6895: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

Line 6895: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

6891: FND_MSG_PUB.initialize;
6892: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6893: p_msg_name => 'OKC_ART_IMP_ERR');
6894:
6895: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
6896:
6897: FND_MSG_PUB.initialize;
6898: */
6899: commit; -- Final commit for status update

Line 6897: FND_MSG_PUB.initialize;

6893: p_msg_name => 'OKC_ART_IMP_ERR');
6894:
6895: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
6896:
6897: FND_MSG_PUB.initialize;
6898: */
6899: commit; -- Final commit for status update
6900:
6901: IF (l_debug = 'Y') THEN

Line 6938: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

6934: CLOSE l_rel_interface_csr;
6935: END IF;
6936:
6937: x_return_status := G_RET_STS_UNEXP_ERROR ;
6938: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6939: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6940: END IF;
6941: get_print_msgs_stack(p_msg_data => x_msg_data);
6942:

Line 6939: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

6935: END IF;
6936:
6937: x_return_status := G_RET_STS_UNEXP_ERROR ;
6938: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6939: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6940: END IF;
6941: get_print_msgs_stack(p_msg_data => x_msg_data);
6942:
6943: WHEN l_insert_errors_exception THEN

Line 6958: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

6954: END IF;
6955:
6956:
6957: --x_return_status := G_RET_STS_UNEXP_ERROR ;
6958: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6959: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6960: END IF;
6961: get_print_msgs_stack(p_msg_data => x_msg_data);
6962: commit;

Line 6959: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

6955:
6956:
6957: --x_return_status := G_RET_STS_UNEXP_ERROR ;
6958: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6959: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6960: END IF;
6961: get_print_msgs_stack(p_msg_data => x_msg_data);
6962: commit;
6963:

Line 6981: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

6977: CLOSE l_rel_interface_csr;
6978: END IF;
6979:
6980: x_return_status := G_RET_STS_UNEXP_ERROR ;
6981: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6982: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6983: END IF;
6984: get_print_msgs_stack(p_msg_data => x_msg_data);
6985: END import_relationships;

Line 6982: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

6978: END IF;
6979:
6980: x_return_status := G_RET_STS_UNEXP_ERROR ;
6981: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6982: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6983: END IF;
6984: get_print_msgs_stack(p_msg_data => x_msg_data);
6985: END import_relationships;
6986:

Line 7101: FND_MSG_PUB.initialize;

7097: -- Variable Initialization
7098: -------------------------------------------------------------------------
7099:
7100: -- Standard Start of API savepoint
7101: FND_MSG_PUB.initialize;
7102: -- Initialize API return status to success
7103: x_return_status := FND_API.G_RET_STS_SUCCESS;
7104: l_return_status := G_RET_STS_SUCCESS;
7105: -- Cache user_id, login_id and org_id

Line 7926: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

7922: CLOSE l_valset_interface_csr;
7923: END IF;
7924:
7925: x_return_status := G_RET_STS_UNEXP_ERROR ;
7926: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
7927: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
7928: END IF;
7929: get_print_msgs_stack(p_msg_data => x_msg_data);
7930:

Line 7927: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

7923: END IF;
7924:
7925: x_return_status := G_RET_STS_UNEXP_ERROR ;
7926: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
7927: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
7928: END IF;
7929: get_print_msgs_stack(p_msg_data => x_msg_data);
7930:
7931: WHEN l_insert_errors_exception THEN

Line 7946: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

7942: END IF;
7943:
7944:
7945: --x_return_status := G_RET_STS_UNEXP_ERROR ;
7946: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
7947: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
7948: END IF;
7949: get_print_msgs_stack(p_msg_data => x_msg_data);
7950: commit;

Line 7947: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

7943:
7944:
7945: --x_return_status := G_RET_STS_UNEXP_ERROR ;
7946: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
7947: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
7948: END IF;
7949: get_print_msgs_stack(p_msg_data => x_msg_data);
7950: commit;
7951:

Line 7969: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

7965: CLOSE l_valset_interface_csr;
7966: END IF;
7967:
7968: x_return_status := G_RET_STS_UNEXP_ERROR ;
7969: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
7970: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
7971: END IF;
7972: get_print_msgs_stack(p_msg_data => x_msg_data);
7973: END import_fnd_flex_value_sets;

Line 7970: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

7966: END IF;
7967:
7968: x_return_status := G_RET_STS_UNEXP_ERROR ;
7969: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
7970: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
7971: END IF;
7972: get_print_msgs_stack(p_msg_data => x_msg_data);
7973: END import_fnd_flex_value_sets;
7974:

Line 8192: FND_MSG_PUB.initialize;

8188: -- Variable Initialization
8189: -------------------------------------------------------------------------
8190:
8191: -- Standard Start of API savepoint
8192: FND_MSG_PUB.initialize;
8193: -- Initialize API return status to success
8194: x_return_status := FND_API.G_RET_STS_SUCCESS;
8195: l_return_status := G_RET_STS_SUCCESS;
8196: -- Cache user_id, login_id and org_id

Line 9072: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

9068: CLOSE l_val_interface_csr;
9069: END IF;
9070:
9071: x_return_status := G_RET_STS_UNEXP_ERROR ;
9072: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
9073: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
9074: END IF;
9075: get_print_msgs_stack(p_msg_data => x_msg_data);
9076:

Line 9073: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

9069: END IF;
9070:
9071: x_return_status := G_RET_STS_UNEXP_ERROR ;
9072: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
9073: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
9074: END IF;
9075: get_print_msgs_stack(p_msg_data => x_msg_data);
9076:
9077: WHEN l_insert_errors_exception THEN

Line 9092: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

9088: END IF;
9089:
9090:
9091: --x_return_status := G_RET_STS_UNEXP_ERROR ;
9092: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
9093: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
9094: END IF;
9095: get_print_msgs_stack(p_msg_data => x_msg_data);
9096: commit;

Line 9093: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

9089:
9090:
9091: --x_return_status := G_RET_STS_UNEXP_ERROR ;
9092: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
9093: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
9094: END IF;
9095: get_print_msgs_stack(p_msg_data => x_msg_data);
9096: commit;
9097:

Line 9115: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

9111: CLOSE l_val_interface_csr;
9112: END IF;
9113:
9114: x_return_status := G_RET_STS_UNEXP_ERROR ;
9115: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
9116: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
9117: END IF;
9118: get_print_msgs_stack(p_msg_data => x_msg_data);
9119: END import_fnd_flex_values;

Line 9116: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

9112: END IF;
9113:
9114: x_return_status := G_RET_STS_UNEXP_ERROR ;
9115: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
9116: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
9117: END IF;
9118: get_print_msgs_stack(p_msg_data => x_msg_data);
9119: END import_fnd_flex_values;
9120: