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 2096: FND_MSG_PUB.initialize;

2092: -- Variable Initialization
2093: -------------------------------------------------------------------------
2094:
2095: -- Standard Start of API savepoint
2096: FND_MSG_PUB.initialize;
2097: -- Initialize API return status to success
2098: x_return_status := FND_API.G_RET_STS_SUCCESS;
2099: l_return_status := G_RET_STS_SUCCESS;
2100: -- Cache user_id, login_id and org_id

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

4274: CLOSE validate_article_type_csr;
4275: END IF;
4276:
4277: x_return_status := G_RET_STS_UNEXP_ERROR ;
4278: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4279: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4280: END IF;
4281: get_print_msgs_stack(p_msg_data => x_msg_data);
4282:

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

4275: END IF;
4276:
4277: x_return_status := G_RET_STS_UNEXP_ERROR ;
4278: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4279: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4280: END IF;
4281: get_print_msgs_stack(p_msg_data => x_msg_data);
4282:
4283: WHEN l_insert_errors_exception THEN

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

4325: END IF;
4326:
4327:
4328: --x_return_status := G_RET_STS_UNEXP_ERROR ;
4329: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4330: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4331: END IF;
4332:
4333: get_print_msgs_stack(p_msg_data => x_msg_data);

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

4326:
4327:
4328: --x_return_status := G_RET_STS_UNEXP_ERROR ;
4329: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4330: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4331: END IF;
4332:
4333: get_print_msgs_stack(p_msg_data => x_msg_data);
4334: commit;

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

4375: CLOSE validate_article_type_csr;
4376: END IF;
4377:
4378: x_return_status := G_RET_STS_UNEXP_ERROR ;
4379: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4380: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4381: END IF;
4382: get_print_msgs_stack(p_msg_data => x_msg_data);
4383:

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

4376: END IF;
4377:
4378: x_return_status := G_RET_STS_UNEXP_ERROR ;
4379: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4380: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4381: END IF;
4382: get_print_msgs_stack(p_msg_data => x_msg_data);
4383:
4384: END import_articles;

Line 4644: FND_MSG_PUB.initialize;

4640: -- Variable Initialization
4641: -------------------------------------------------------------------------
4642:
4643: -- Standard Start of API savepoint
4644: FND_MSG_PUB.initialize;
4645: -- Initialize API return status to success
4646: x_return_status := FND_API.G_RET_STS_SUCCESS;
4647: l_return_status := G_RET_STS_SUCCESS;
4648: -- Cache user_id, login_id and org_id

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

5871: CLOSE l_var_interface_csr;
5872: END IF;
5873:
5874: x_return_status := G_RET_STS_UNEXP_ERROR ;
5875: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5876: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5877: END IF;
5878: get_print_msgs_stack(p_msg_data => x_msg_data);
5879:

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

5872: END IF;
5873:
5874: x_return_status := G_RET_STS_UNEXP_ERROR ;
5875: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5876: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5877: END IF;
5878: get_print_msgs_stack(p_msg_data => x_msg_data);
5879:
5880: WHEN l_insert_errors_exception THEN

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

5891: END IF;
5892:
5893:
5894: --x_return_status := G_RET_STS_UNEXP_ERROR ;
5895: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5896: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5897: END IF;
5898: get_print_msgs_stack(p_msg_data => x_msg_data);
5899: commit;

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

5892:
5893:
5894: --x_return_status := G_RET_STS_UNEXP_ERROR ;
5895: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5896: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5897: END IF;
5898: get_print_msgs_stack(p_msg_data => x_msg_data);
5899: commit;
5900:

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

5914: CLOSE l_var_interface_csr;
5915: END IF;
5916:
5917: x_return_status := G_RET_STS_UNEXP_ERROR ;
5918: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5919: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5920: END IF;
5921: get_print_msgs_stack(p_msg_data => x_msg_data);
5922: END import_variables;

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

5915: END IF;
5916:
5917: x_return_status := G_RET_STS_UNEXP_ERROR ;
5918: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5919: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5920: END IF;
5921: get_print_msgs_stack(p_msg_data => x_msg_data);
5922: END import_variables;
5923:

Line 6081: FND_MSG_PUB.initialize;

6077: -------------------------------------------------------------------------
6078:
6079:
6080: -- Standard Start of API savepoint
6081: FND_MSG_PUB.initialize;
6082: -- Initialize API return status to success
6083: x_return_status := FND_API.G_RET_STS_SUCCESS;
6084: l_return_status := G_RET_STS_SUCCESS;
6085: -- Cache user_id, login_id and org_id

Line 6959: FND_MSG_PUB.initialize;

6955: -- Print statistic of this run in the log
6956: -- Commented for new XML Based Import - Moved to new_wrap_up in conc_import_articles
6957: --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');
6958: /*
6959: FND_MSG_PUB.initialize;
6960: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6961: p_msg_name => 'OKC_ART_IMP_ERR');
6962:
6963: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

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

6959: FND_MSG_PUB.initialize;
6960: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6961: p_msg_name => 'OKC_ART_IMP_ERR');
6962:
6963: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
6964:
6965: FND_MSG_PUB.initialize;
6966: */
6967: commit; -- Final commit for status update

Line 6965: FND_MSG_PUB.initialize;

6961: p_msg_name => 'OKC_ART_IMP_ERR');
6962:
6963: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
6964:
6965: FND_MSG_PUB.initialize;
6966: */
6967: commit; -- Final commit for status update
6968:
6969: IF (l_debug = 'Y') THEN

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

7002: CLOSE l_rel_interface_csr;
7003: END IF;
7004:
7005: x_return_status := G_RET_STS_UNEXP_ERROR ;
7006: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
7007: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
7008: END IF;
7009: get_print_msgs_stack(p_msg_data => x_msg_data);
7010:

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

7003: END IF;
7004:
7005: x_return_status := G_RET_STS_UNEXP_ERROR ;
7006: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
7007: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
7008: END IF;
7009: get_print_msgs_stack(p_msg_data => x_msg_data);
7010:
7011: WHEN l_insert_errors_exception THEN

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

7022: END IF;
7023:
7024:
7025: --x_return_status := G_RET_STS_UNEXP_ERROR ;
7026: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
7027: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
7028: END IF;
7029: get_print_msgs_stack(p_msg_data => x_msg_data);
7030: commit;

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

7023:
7024:
7025: --x_return_status := G_RET_STS_UNEXP_ERROR ;
7026: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
7027: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
7028: END IF;
7029: get_print_msgs_stack(p_msg_data => x_msg_data);
7030: commit;
7031:

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

7045: CLOSE l_rel_interface_csr;
7046: END IF;
7047:
7048: x_return_status := G_RET_STS_UNEXP_ERROR ;
7049: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
7050: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
7051: END IF;
7052: get_print_msgs_stack(p_msg_data => x_msg_data);
7053: END import_relationships;

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

7046: END IF;
7047:
7048: x_return_status := G_RET_STS_UNEXP_ERROR ;
7049: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
7050: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
7051: END IF;
7052: get_print_msgs_stack(p_msg_data => x_msg_data);
7053: END import_relationships;
7054:

Line 7169: FND_MSG_PUB.initialize;

7165: -- Variable Initialization
7166: -------------------------------------------------------------------------
7167:
7168: -- Standard Start of API savepoint
7169: FND_MSG_PUB.initialize;
7170: -- Initialize API return status to success
7171: x_return_status := FND_API.G_RET_STS_SUCCESS;
7172: l_return_status := G_RET_STS_SUCCESS;
7173: -- Cache user_id, login_id and org_id

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

7990: CLOSE l_valset_interface_csr;
7991: END IF;
7992:
7993: x_return_status := G_RET_STS_UNEXP_ERROR ;
7994: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
7995: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
7996: END IF;
7997: get_print_msgs_stack(p_msg_data => x_msg_data);
7998:

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

7991: END IF;
7992:
7993: x_return_status := G_RET_STS_UNEXP_ERROR ;
7994: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
7995: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
7996: END IF;
7997: get_print_msgs_stack(p_msg_data => x_msg_data);
7998:
7999: WHEN l_insert_errors_exception THEN

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

8010: END IF;
8011:
8012:
8013: --x_return_status := G_RET_STS_UNEXP_ERROR ;
8014: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
8015: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
8016: END IF;
8017: get_print_msgs_stack(p_msg_data => x_msg_data);
8018: commit;

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

8011:
8012:
8013: --x_return_status := G_RET_STS_UNEXP_ERROR ;
8014: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
8015: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
8016: END IF;
8017: get_print_msgs_stack(p_msg_data => x_msg_data);
8018: commit;
8019:

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

8033: CLOSE l_valset_interface_csr;
8034: END IF;
8035:
8036: x_return_status := G_RET_STS_UNEXP_ERROR ;
8037: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
8038: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
8039: END IF;
8040: get_print_msgs_stack(p_msg_data => x_msg_data);
8041: END import_fnd_flex_value_sets;

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

8034: END IF;
8035:
8036: x_return_status := G_RET_STS_UNEXP_ERROR ;
8037: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
8038: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
8039: END IF;
8040: get_print_msgs_stack(p_msg_data => x_msg_data);
8041: END import_fnd_flex_value_sets;
8042:

Line 8260: FND_MSG_PUB.initialize;

8256: -- Variable Initialization
8257: -------------------------------------------------------------------------
8258:
8259: -- Standard Start of API savepoint
8260: FND_MSG_PUB.initialize;
8261: -- Initialize API return status to success
8262: x_return_status := FND_API.G_RET_STS_SUCCESS;
8263: l_return_status := G_RET_STS_SUCCESS;
8264: -- Cache user_id, login_id and org_id

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

9136: CLOSE l_val_interface_csr;
9137: END IF;
9138:
9139: x_return_status := G_RET_STS_UNEXP_ERROR ;
9140: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
9141: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
9142: END IF;
9143: get_print_msgs_stack(p_msg_data => x_msg_data);
9144:

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

9137: END IF;
9138:
9139: x_return_status := G_RET_STS_UNEXP_ERROR ;
9140: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
9141: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
9142: END IF;
9143: get_print_msgs_stack(p_msg_data => x_msg_data);
9144:
9145: WHEN l_insert_errors_exception THEN

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

9156: END IF;
9157:
9158:
9159: --x_return_status := G_RET_STS_UNEXP_ERROR ;
9160: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
9161: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
9162: END IF;
9163: get_print_msgs_stack(p_msg_data => x_msg_data);
9164: commit;

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

9157:
9158:
9159: --x_return_status := G_RET_STS_UNEXP_ERROR ;
9160: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
9161: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
9162: END IF;
9163: get_print_msgs_stack(p_msg_data => x_msg_data);
9164: commit;
9165:

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

9179: CLOSE l_val_interface_csr;
9180: END IF;
9181:
9182: x_return_status := G_RET_STS_UNEXP_ERROR ;
9183: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
9184: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
9185: END IF;
9186: get_print_msgs_stack(p_msg_data => x_msg_data);
9187: END import_fnd_flex_values;

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

9180: END IF;
9181:
9182: x_return_status := G_RET_STS_UNEXP_ERROR ;
9183: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
9184: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
9185: END IF;
9186: get_print_msgs_stack(p_msg_data => x_msg_data);
9187: END import_fnd_flex_values;
9188: