DBA Data[Home] [Help]

APPS.OKC_ARTICLES_IMPORT_GRP dependencies on FND_FILE

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1497: FND_FILE.PUT_LINE(FND_FILE.LOG, err_error_description_tbl(i_err));

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:
1500: END LOOP;
1501: END IF;

Line 1498: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

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:
1500: END LOOP;
1501: END IF;
1502: --recycle it

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 1617: FND_FILE.PUT_LINE(FND_FILE.LOG, err_error_description_tbl(i_err));

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, '');
1619:
1620: END LOOP;
1621: END IF;

Line 1618: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

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, '');
1619:
1620: END LOOP;
1621: END IF;
1622:

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 1628: FND_FILE.PUT_LINE(FND_FILE.LOG,p_msg_data);

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;
1630:
1631: --recycle it
1632: FND_MSG_PUB.initialize;

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 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