DBA Data[Home] [Help]

APPS.XNB_ITEM_BATCH_PVT dependencies on FND_FILE

Line 380: fnd_file.put_line(fnd_file.log , ERRBUF);

376: WHEN UTL_FILE.INVALID_PATH THEN
377: UTL_FILE.FCLOSE(l_handle);
378: RETCODE := 2;
379: ERRBUF := 'Invalid directory path';
380: fnd_file.put_line(fnd_file.log , ERRBUF);
381:
382:
383: WHEN UTL_FILE.INVALID_MODE THEN
384: UTL_FILE.FCLOSE(l_handle);

Line 387: fnd_file.put_line(fnd_file.log , ERRBUF);

383: WHEN UTL_FILE.INVALID_MODE THEN
384: UTL_FILE.FCLOSE(l_handle);
385: RETCODE := 2;
386: ERRBUF := 'Invalid mode of opening the file';
387: fnd_file.put_line(fnd_file.log , ERRBUF);
388:
389: WHEN UTL_FILE.INVALID_OPERATION THEN
390: UTL_FILE.FCLOSE(l_handle);
391: RETCODE := 2;

Line 393: fnd_file.put_line(fnd_file.log , ERRBUF);

389: WHEN UTL_FILE.INVALID_OPERATION THEN
390: UTL_FILE.FCLOSE(l_handle);
391: RETCODE := 2;
392: ERRBUF := 'Invalid operation performed on the file';
393: fnd_file.put_line(fnd_file.log , ERRBUF);
394:
395:
396: WHEN UTL_FILE.READ_ERROR THEN
397: UTL_FILE.FCLOSE(l_handle);

Line 400: fnd_file.put_line(fnd_file.log , ERRBUF);

396: WHEN UTL_FILE.READ_ERROR THEN
397: UTL_FILE.FCLOSE(l_handle);
398: RETCODE := 2;
399: ERRBUF := 'Read error';
400: fnd_file.put_line(fnd_file.log , ERRBUF);
401:
402:
403: WHEN UTL_FILE.WRITE_ERROR THEN
404: UTL_FILE.FCLOSE(l_handle);

Line 407: fnd_file.put_line(fnd_file.log , ERRBUF);

403: WHEN UTL_FILE.WRITE_ERROR THEN
404: UTL_FILE.FCLOSE(l_handle);
405: RETCODE := 2;
406: ERRBUF := 'Write error';
407: fnd_file.put_line(fnd_file.log , ERRBUF);
408:
409:
410: WHEN UTL_FILE.INTERNAL_ERROR THEN
411: UTL_FILE.FCLOSE(l_handle);

Line 414: fnd_file.put_line(fnd_file.log , ERRBUF);

410: WHEN UTL_FILE.INTERNAL_ERROR THEN
411: UTL_FILE.FCLOSE(l_handle);
412: RETCODE := 2;
413: ERRBUF := 'Some internal UTL_FILE error';
414: fnd_file.put_line(fnd_file.log , ERRBUF);
415:
416: WHEN OTHERS THEN
417: UTL_FILE.FCLOSE(l_handle);
418: RETCODE := 2;

Line 420: fnd_file.put_line(fnd_file.log , ERRBUF);

416: WHEN OTHERS THEN
417: UTL_FILE.FCLOSE(l_handle);
418: RETCODE := 2;
419: ERRBUF := SQLERRM(SQLCODE);
420: fnd_file.put_line(fnd_file.log , ERRBUF);
421: RETURN -1;
422:
423: /* End of Function: gen_item_batch_file*/
424: END gen_item_batch_file;

Line 865: fnd_file.put_line(fnd_file.log , ERRBUF);

861: -----------------------------------------------------------------------
862: IF l_msg_type is null then
863: RETCODE := 2;
864: ERRBUF := 'XNB_MSG_TYPE Profile not set. Please set the profile n Retry';
865: fnd_file.put_line(fnd_file.log , ERRBUF);
866: RETURN;
867: END IF;
868:
869:

Line 891: fnd_file.put_line(fnd_file.log , ERRBUF);

887:
888: IF l_rec_cnt = -1 then
889: RETCODE := 2;
890: ERRBUF := 'Exception in Creating the Item Batch CSV';
891: fnd_file.put_line(fnd_file.log , ERRBUF);
892: RETURN;
893: END IF;
894:
895: IF l_rec_cnt = -2 then

Line 898: fnd_file.put_line(fnd_file.log , ERRBUF);

894:
895: IF l_rec_cnt = -2 then
896: RETCODE := 2;
897: ERRBUF := 'XNB_ITEM_FILE_LOCATION Profile not set. Please set the profile n Retry';
898: fnd_file.put_line(fnd_file.log , ERRBUF);
899: RETURN;
900: END IF;
901:
902: -----------------------------------------------------------------------------------------

Line 915: fnd_file.put_line(fnd_file.log , ERRBUF);

911:
912: IF cln_result = -1 then
913: RETCODE := 2;
914: ERRBUF := 'Excpetion in Creating Collaboration for CSV Batch ';
915: fnd_file.put_line(fnd_file.log , ERRBUF);
916: RETURN;
917: END IF;
918:
919: IF cln_result = -2 then

Line 922: fnd_file.put_line(fnd_file.log , ERRBUF);

918:
919: IF cln_result = -2 then
920: RETCODE := 2;
921: ERRBUF := 'No Trading Partner Setup in XML Gateway ';
922: fnd_file.put_line(fnd_file.log , ERRBUF);
923: RETURN;
924: END IF;
925:
926: --END of FOR LOOP

Line 953: fnd_file.put_line(fnd_file.log , ERRBUF);

949:
950: IF l_rec_cnt = -1 then
951: RETCODE := 2;
952: ERRBUF := 'Excpetion in Creating the Item Batch XML';
953: fnd_file.put_line(fnd_file.log , ERRBUF);
954: RETURN;
955: END IF;
956:
957: -----------------------------------------------------------------------------------------

Line 968: fnd_file.put_line(fnd_file.log , ERRBUF);

964:
965: IF cln_result = -1 then
966: RETCODE := 2;
967: ERRBUF := 'Exception in Creating Collaboration for CSV Batch ';
968: fnd_file.put_line(fnd_file.log , ERRBUF);
969: RETURN;
970: END IF;
971:
972: IF cln_result = -2 then

Line 975: fnd_file.put_line(fnd_file.log , ERRBUF);

971:
972: IF cln_result = -2 then
973: RETCODE := 2;
974: ERRBUF := 'No Trading Partner Setup in XML Gateway ';
975: fnd_file.put_line(fnd_file.log , ERRBUF);
976: RETURN;
977: END IF;
978:
979: --END of FOR LOOP

Line 1018: fnd_file.put_line(fnd_file.log , ERRBUF);

1014:
1015: IF xml_result = -1 then
1016: RETCODE := 2;
1017: ERRBUF := 'Exception while Raising the event for Item Publsih';
1018: fnd_file.put_line(fnd_file.log , ERRBUF);
1019: RETURN;
1020: END IF;
1021:
1022: FETCH l_ItemCur_R INTO l_item_info;

Line 1052: fnd_file.put_line(fnd_file.log , ERRBUF);

1048: WHEN NO_DATA_FOUND THEN
1049: UTL_FILE.FCLOSE(l_handle);
1050: RETCODE := result;
1051: ERRBUF := 'Collaboration for Item does not exist';
1052: fnd_file.put_line(fnd_file.log , ERRBUF);
1053:
1054: WHEN TOO_MANY_ROWS THEN
1055: UTL_FILE.FCLOSE(l_handle);
1056: RETCODE := result;

Line 1058: fnd_file.put_line(fnd_file.log , ERRBUF);

1054: WHEN TOO_MANY_ROWS THEN
1055: UTL_FILE.FCLOSE(l_handle);
1056: RETCODE := result;
1057: ERRBUF := 'More than one Collaboration Exists for the Item';
1058: fnd_file.put_line(fnd_file.log , ERRBUF);
1059:
1060:
1061:
1062:

Line 1067: fnd_file.put_line(fnd_file.log , ERRBUF);

1063: WHEN OTHERS THEN
1064: UTL_FILE.FCLOSE(l_handle);
1065: RETCODE := result;
1066: ERRBUF := SQLERRM;
1067: fnd_file.put_line(fnd_file.log , ERRBUF);
1068: -- End Function publish_item
1069: END publish_item;
1070:
1071: