eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_IH_BULK dependencies on FND_FILE

Line 196: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

192: G_SERVER_TZ := FND_PROFILE.VALUE('SERVER_TIMEZONE_ID');
193: IF (G_SERVER_TZ IS NULL) THEN
194:
195: --FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_NO_TZ');
196: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
197:
198:
199: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
200: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_NO_TZ');

Line 254: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Created row in recovery table');

250: EMPTY_CLOB(), null, G_USER_ID, sysdate, G_USER_ID, sysdate, G_LOGIN_ID,
251: G_CONC_REQUEST_ID, G_PROG_APPL_ID, sysdate);
252:
253: g_hrt_beat := -50;
254: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Created row in recovery table');
255:
256: -- dequeue options
257: -- dequeue mode shall be LOCKED for now, the data will get deleted after
258: -- saving in RECOVERY table

Line 328: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Updated row in recovery table and removed from AQ');

324: g_hrt_beat := -52;
325: COMMIT WORK;
326:
327: g_hrt_beat := -53;
328: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Updated row in recovery table and removed from AQ');
329:
330: -- process payload data
331: l_ret_status := PROCESS_BULK_RECORD(bulk_obj.bulkWriterCode,
332: bulk_obj.bulkBatchType,

Line 337: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Process_record returned - ' || l_ret_status);

333: bulk_obj.bulkBatchId,
334: bulk_obj.bulkInteractionRequest);
335:
336: g_hrt_beat := -54;
337: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Process_record returned - ' || l_ret_status);
338: ELSE
339:
340: g_hrt_beat := -51;
341:

Line 362: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

358: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_ZERO_LEN_REQ');
359: FND_MESSAGE.SET_TOKEN('WRITER_CODE', bulk_obj.bulkWriterCode);
360: FND_MESSAGE.SET_TOKEN('BATCH_TYPE', bulk_obj.bulkBatchType);
361: FND_MESSAGE.SET_TOKEN('BATCH_ID', bulk_obj.bulkBatchId);
362: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
363:
364:
365: -- logging Detail Level: Found a bulk request of zero length
366: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 422: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

418:
419: -- logging High Level: End of records in Advanced Queue
420: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_AQ_EOF');
421: FND_MESSAGE.SET_TOKEN('NUM_REC', num_rec);
422: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
423:
424: -- output this irrespective of stats flag so that there is some
425: -- indication of work done.
426:

Line 429: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

425: -- indication of work done.
426:
427: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_AQ_EOF');
428: FND_MESSAGE.SET_TOKEN('NUM_REC', num_rec);
429: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
430:
431: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_NUM_REC_PROC');
432: FND_MESSAGE.SET_TOKEN('NUM_REC', num_rec);
433: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

Line 433: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

429: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
430:
431: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_NUM_REC_PROC');
432: FND_MESSAGE.SET_TOKEN('NUM_REC', num_rec);
433: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
434:
435: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_NUM_TOTAL_INT');
436: FND_MESSAGE.SET_TOKEN('NUM_INT', G_NUM_INT_TOTAL);
437: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

Line 437: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

433: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
434:
435: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_NUM_TOTAL_INT');
436: FND_MESSAGE.SET_TOKEN('NUM_INT', G_NUM_INT_TOTAL);
437: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
438:
439: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_NUM_OK_INT');
440: FND_MESSAGE.SET_TOKEN('NUM_INT', G_NUM_INT_PROC_TOTAL);
441: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

Line 441: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

437: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
438:
439: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_NUM_OK_INT');
440: FND_MESSAGE.SET_TOKEN('NUM_INT', G_NUM_INT_PROC_TOTAL);
441: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
442:
443: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_NUM_ERR_INT');
444: FND_MESSAGE.SET_TOKEN('NUM_INT', (G_NUM_INT_TOTAL-G_NUM_INT_PROC_TOTAL));
445: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

Line 445: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

441: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
442:
443: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_NUM_ERR_INT');
444: FND_MESSAGE.SET_TOKEN('NUM_INT', (G_NUM_INT_TOTAL-G_NUM_INT_PROC_TOTAL));
445: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
446:
447: WHEN OTHERS THEN
448: RAISE;
449: END;

Line 465: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

461: -- High level logging:The number of records deleted from
462: -- the recovery table during cleanup is not 1 as expected
463: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_RECOV_DEL_WARN');
464: FND_MESSAGE.SET_TOKEN('ROW_COUNT', SQL%ROWCOUNT);
465: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
466:
467: IF( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
468: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_RECOV_DEL_WARN');
469: FND_MESSAGE.SET_TOKEN('ROW_COUNT', SQL%ROWCOUNT);

Line 475: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Deleted row from recovery table.');

471: 'jtf.plsql.JTF_IH_BULK.BULK_PROCESSOR_CONC', TRUE);
472: END IF;
473:
474: ELSE
475: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Deleted row from recovery table.');
476: COMMIT;
477: END IF;
478:
479:

Line 548: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

544: -- 1 for success with warnings, and 2 for error.
545: retcode := '0';
546: errbuf := FND_MESSAGE.GET_STRING('JTF', 'JTF_IH_BULK_OK');
547:
548: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
549:
550: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
551: l_fnd_log_msg := 'PROCESS_BULK_RECORD Out parameters :'||
552: ', errbuf = '|| errbuf ||

Line 576: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'payload ought to go into errors ,msg_id = ' || l_msg_id);

572:
573: -- error table before we bye-bye
574: /*IF (msg_id IS NOT NULL) THEN
575: NULL;
576: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'payload ought to go into errors ,msg_id = ' || l_msg_id);
577: -- stick message into errors
578: END IF;*/
579:
580: retcode := '2';

Line 587: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

583:
584:
585: FND_MESSAGE.set_token('ERR_MSG', SQLERRM);
586: errbuf := FND_MSG_PUB.GET();
587: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
588:
589: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
590: l_fnd_log_msg := errbuf;
591: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

Line 696: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Calling ParseClob');

692: dbms_xmlparser.setValidationMode(xml_p, FALSE);
693: -- Bug fix 3812373. Commenting out set error log not needed.
694: -- dbms_xmlparser.setErrorLog(xml_p, '/tmp/msistaXmlErrors.txt');
695:
696: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Calling ParseClob');
697:
698: -- parse the bulk record clob
699:
700: g_hrt_beat := 1.5;

Line 718: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error Message: ' || errm );

714: errm := SQLERRM;
715: IF (errm IS NULL) THEN
716: errm := 'No Error Message in SQLERRM for parsing errors';
717: END IF;
718: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error Message: ' || errm );
719: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
720: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
721: 'jtf.plsql.JTF_IH_BULK.PROCESS_BULK_RECORD',errm);
722: END IF;

Line 734: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Parse returned.');

730:
731:
732: --IF (g_stats_enabled) THEN
733: t1_end := DBMS_UTILITY.GET_TIME;
734: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Parse returned.');
735: l_parse_time := ((t1_end-t1_beg)*10);
736:
737: g_hrt_beat := 1.6;
738: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Time taken for Parse - ' || l_parse_time);

Line 738: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Time taken for Parse - ' || l_parse_time);

734: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Parse returned.');
735: l_parse_time := ((t1_end-t1_beg)*10);
736:
737: g_hrt_beat := 1.6;
738: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Time taken for Parse - ' || l_parse_time);
739:
740: -- globally tracked parse time
741: G_XML_PARSE_TIME_TOTAL := G_XML_PARSE_TIME_TOTAL + l_parse_time;
742: IF (l_parse_time < G_XML_PARSE_TIME_MIN) THEN

Line 791: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '# of interactions in req = ' || num_int);

787: int_nl := dbms_xmldom.getElementsByTagName(xml_doc, 'INTERACTION');
788: num_int := dbms_xmldom.getLength(int_nl);
789:
790: g_hrt_beat := 3;
791: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '# of interactions in req = ' || num_int);
792:
793: -- keep track of interactions processed for use in logging
794: l_num_int_done := 0;
795:

Line 826: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------');

822: l_error := L_BLANK;
823: l_ret_msg := '';
824:
825: --dbms_output.new_line();
826: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------');
827: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'begin INT loop iteration # - ' || i);
828:
829: g_hrt_beat := 3.5;
830:

Line 827: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'begin INT loop iteration # - ' || i);

823: l_ret_msg := '';
824:
825: --dbms_output.new_line();
826: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------');
827: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'begin INT loop iteration # - ' || i);
828:
829: g_hrt_beat := 3.5;
830:
831: int_node := dbms_xmldom.item(int_nl, i);

Line 871: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '# of media_items in int req num ' || i || ' = ' || num_med);

867: --i. get all Media nodes from this doc.
868: med_nl := dbms_xmldom.getChildrenByTagName(int_elem, 'MEDIAITEM');
869: num_med := dbms_xmldom.getLength(med_nl);
870:
871: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '# of media_items in int req num ' || i || ' = ' || num_med);
872:
873: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'BULK_INTERACTION_ID = ' || l_bulk_interaction_id);
874:
875: g_hrt_beat := 5;

Line 873: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'BULK_INTERACTION_ID = ' || l_bulk_interaction_id);

869: num_med := dbms_xmldom.getLength(med_nl);
870:
871: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '# of media_items in int req num ' || i || ' = ' || num_med);
872:
873: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'BULK_INTERACTION_ID = ' || l_bulk_interaction_id);
874:
875: g_hrt_beat := 5;
876:
877: -- delegate media node processing

Line 884: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error || ', ' || l_ret_msg);

880: p_bulk_batch_type, p_bulk_batch_id, l_user_id, med_id_tbl,
881: l_ret_status, l_ret_msg);
882: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
883: l_error := 'JTF_IH_BULK_MEDIA_FAIL';
884: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error || ', ' || l_ret_msg);
885: l_error_msgLOG := l_ret_msg;
886: RAISE processing_error;
887: -- raise exception or otherwise handle this
888: ELSE

Line 890: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'PROCESS_MEDIA_ITEM returned OK');

886: RAISE processing_error;
887: -- raise exception or otherwise handle this
888: ELSE
889: NULL;
890: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'PROCESS_MEDIA_ITEM returned OK');
891: END IF;
892: END IF;
893:
894: g_hrt_beat := 6;

Line 942: --FND_FILE.PUT_LINE(FND_FILE.LOG, l_ret_msg);

938: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
939: l_error := 'JTF_IH_BULK_ACT_FAIL';
940: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_INT_FAIL');
941: l_ret_msg := FND_MESSAGE.GET ||' '|| l_ret_msg;
942: --FND_FILE.PUT_LINE(FND_FILE.LOG, l_ret_msg);
943: l_error_msgLOG := l_ret_msg;
944: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
945: l_fnd_log_msg := l_ret_msg;
946: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 972: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Create_Interaction returned - ' || l_ret_status);

968: x_msg_data => l_msg_data,
969: p_interaction_rec => int_rec,
970: p_activities => act_tbl);
971:
972: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Create_Interaction returned - ' || l_ret_status);
973: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
974: l_error := 'JTF_IH_BULK_INT_FAIL';
975: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error || ', msg_count = ' || l_msg_count);
976:

Line 975: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error || ', msg_count = ' || l_msg_count);

971:
972: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Create_Interaction returned - ' || l_ret_status);
973: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
974: l_error := 'JTF_IH_BULK_INT_FAIL';
975: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error || ', msg_count = ' || l_msg_count);
976:
977: --Logging Detail Level
978: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
979: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_INT_FAIL2');

Line 998: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Message number - ' || i || ', is - ' || l_msg_data);

994: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
995: 'jtf.plsql.JTF_IH_BULK.PROCESS_BULK_RECORD', l_error_msgLOG);
996: END IF;
997:
998: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Message number - ' || i || ', is - ' || l_msg_data);
999: l_ret_msg := l_ret_msg ||
1000: SUBSTRB(l_msg_data, 0, (2000-LENGTHB(l_ret_msg))) || ' ';
1001: END LOOP;
1002:

Line 1104: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'LOG_BULK_ERROR call done');

1100: p_bulk_batch_type, p_bulk_batch_id,
1101: l_bulk_interaction_id,
1102: --l_err_msg, l_ret_msg);
1103: l_error_msgLOG, l_ret_msg);
1104: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'LOG_BULK_ERROR call done');
1105: g_hrt_beat := 11.7;
1106:
1107: END; -- dummy block
1108:

Line 1110: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'end INT loop iteration # - ' || i);

1106:
1107: END; -- dummy block
1108:
1109: g_hrt_beat := 11.8;
1110: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'end INT loop iteration # - ' || i);
1111:
1112: END LOOP; -- INT nodes
1113:
1114: g_hrt_beat := 12;

Line 1172: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Exception occurred in PROCESS_BULK_RECORD');

1168: NULL;
1169: /*
1170: debug message - uncomment if necessary.
1171:
1172: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Exception occurred in PROCESS_BULK_RECORD');
1173: IF (error IS NOT NULL) THEN
1174: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error code is - ' || error);
1175: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error msg - ' || errm);
1176: ELSE

Line 1174: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error code is - ' || error);

1170: debug message - uncomment if necessary.
1171:
1172: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Exception occurred in PROCESS_BULK_RECORD');
1173: IF (error IS NOT NULL) THEN
1174: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error code is - ' || error);
1175: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error msg - ' || errm);
1176: ELSE
1177: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No error code');
1178: END IF;

Line 1175: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error msg - ' || errm);

1171:
1172: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Exception occurred in PROCESS_BULK_RECORD');
1173: IF (error IS NOT NULL) THEN
1174: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error code is - ' || error);
1175: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error msg - ' || errm);
1176: ELSE
1177: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No error code');
1178: END IF;
1179:

Line 1177: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No error code');

1173: IF (error IS NOT NULL) THEN
1174: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error code is - ' || error);
1175: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error msg - ' || errm);
1176: ELSE
1177: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No error code');
1178: END IF;
1179:
1180: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Hrt beat = ' || g_hrt_beat);
1181: */

Line 1180: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Hrt beat = ' || g_hrt_beat);

1176: ELSE
1177: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No error code');
1178: END IF;
1179:
1180: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Hrt beat = ' || g_hrt_beat);
1181: */
1182:
1183:
1184: FND_FILE.PUT_LINE(FND_FILE.LOG, errm);

Line 1184: FND_FILE.PUT_LINE(FND_FILE.LOG, errm);

1180: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Hrt beat = ' || g_hrt_beat);
1181: */
1182:
1183:
1184: FND_FILE.PUT_LINE(FND_FILE.LOG, errm);
1185:
1186: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_REQ_FAIL2');
1187: FND_MESSAGE.SET_TOKEN('NUM_INT_DONE', l_num_int_done);
1188: FND_MESSAGE.SET_TOKEN('NUM_INT_COMMIT', l_commit_int_num);

Line 1190: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

1186: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_REQ_FAIL2');
1187: FND_MESSAGE.SET_TOKEN('NUM_INT_DONE', l_num_int_done);
1188: FND_MESSAGE.SET_TOKEN('NUM_INT_COMMIT', l_commit_int_num);
1189:
1190: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1191:
1192: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1193: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_REQ_FAIL2');
1194: FND_MESSAGE.SET_TOKEN('NUM_INT_DONE', l_num_int_done);

Line 1326: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' obtained from db med_id = ' || med_id);

1322: g_hrt_beat := 13.11;
1323: l_media_id_given := FALSE;
1324: --dbms_output.PUT('media_id is null for media_ident ' || med_ident);
1325: SELECT jtf_ih_media_items_s1.NEXTVAL INTO med_id FROM sys.dual;
1326: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' obtained from db med_id = ' || med_id);
1327: ELSE
1328: g_hrt_beat := 13.12;
1329: l_media_id_given := TRUE;
1330: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'media_id is NOT null for media_ident ' || med_ident || ', med_id = ' || med_id);

Line 1330: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'media_id is NOT null for media_ident ' || med_ident || ', med_id = ' || med_id);

1326: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' obtained from db med_id = ' || med_id);
1327: ELSE
1328: g_hrt_beat := 13.12;
1329: l_media_id_given := TRUE;
1330: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'media_id is NOT null for media_ident ' || med_ident || ', med_id = ' || med_id);
1331: END IF;
1332:
1333: --a. get childNodes (they would be MLCS)
1334: mlcs_nl := dbms_xmldom.getChildNodes(med_node);

Line 1371: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).start_date_time = ' || mlcs_tbl(k).start_date_time);

1367: mlcs_tbl(k).bulk_batch_id := p_bulk_batch_id;
1368: mlcs_tbl(k).bulk_interaction_id := p_bulk_interaction_id;
1369:
1370: /*Is useful in figuring out which attribute is bad, if necessary
1371: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).start_date_time = ' || mlcs_tbl(k).start_date_time);
1372: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).end_date_time = ' || mlcs_tbl(k).end_date_time);
1373: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).type_type = ' || mlcs_tbl(k).type_type);
1374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).type_id = ' || mlcs_tbl(k).type_id);
1375: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).duration = ' || mlcs_tbl(k).duration);

Line 1372: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).end_date_time = ' || mlcs_tbl(k).end_date_time);

1368: mlcs_tbl(k).bulk_interaction_id := p_bulk_interaction_id;
1369:
1370: /*Is useful in figuring out which attribute is bad, if necessary
1371: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).start_date_time = ' || mlcs_tbl(k).start_date_time);
1372: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).end_date_time = ' || mlcs_tbl(k).end_date_time);
1373: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).type_type = ' || mlcs_tbl(k).type_type);
1374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).type_id = ' || mlcs_tbl(k).type_id);
1375: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).duration = ' || mlcs_tbl(k).duration);
1376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).milcs_type_id = ' || mlcs_tbl(k).milcs_type_id);

Line 1373: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).type_type = ' || mlcs_tbl(k).type_type);

1369:
1370: /*Is useful in figuring out which attribute is bad, if necessary
1371: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).start_date_time = ' || mlcs_tbl(k).start_date_time);
1372: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).end_date_time = ' || mlcs_tbl(k).end_date_time);
1373: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).type_type = ' || mlcs_tbl(k).type_type);
1374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).type_id = ' || mlcs_tbl(k).type_id);
1375: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).duration = ' || mlcs_tbl(k).duration);
1376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).milcs_type_id = ' || mlcs_tbl(k).milcs_type_id);
1377: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).media_id = ' || med_id);

Line 1374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).type_id = ' || mlcs_tbl(k).type_id);

1370: /*Is useful in figuring out which attribute is bad, if necessary
1371: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).start_date_time = ' || mlcs_tbl(k).start_date_time);
1372: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).end_date_time = ' || mlcs_tbl(k).end_date_time);
1373: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).type_type = ' || mlcs_tbl(k).type_type);
1374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).type_id = ' || mlcs_tbl(k).type_id);
1375: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).duration = ' || mlcs_tbl(k).duration);
1376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).milcs_type_id = ' || mlcs_tbl(k).milcs_type_id);
1377: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).media_id = ' || med_id);
1378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).handler_id = ' || mlcs_tbl(k).handler_id);

Line 1375: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).duration = ' || mlcs_tbl(k).duration);

1371: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).start_date_time = ' || mlcs_tbl(k).start_date_time);
1372: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).end_date_time = ' || mlcs_tbl(k).end_date_time);
1373: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).type_type = ' || mlcs_tbl(k).type_type);
1374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).type_id = ' || mlcs_tbl(k).type_id);
1375: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).duration = ' || mlcs_tbl(k).duration);
1376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).milcs_type_id = ' || mlcs_tbl(k).milcs_type_id);
1377: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).media_id = ' || med_id);
1378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).handler_id = ' || mlcs_tbl(k).handler_id);
1379: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).resource_id = ' || mlcs_tbl(k).resource_id);

Line 1376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).milcs_type_id = ' || mlcs_tbl(k).milcs_type_id);

1372: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).end_date_time = ' || mlcs_tbl(k).end_date_time);
1373: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).type_type = ' || mlcs_tbl(k).type_type);
1374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).type_id = ' || mlcs_tbl(k).type_id);
1375: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).duration = ' || mlcs_tbl(k).duration);
1376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).milcs_type_id = ' || mlcs_tbl(k).milcs_type_id);
1377: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).media_id = ' || med_id);
1378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).handler_id = ' || mlcs_tbl(k).handler_id);
1379: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).resource_id = ' || mlcs_tbl(k).resource_id);
1380: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).milcs_code = ' || mlcs_tbl(k).milcs_code);

Line 1377: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).media_id = ' || med_id);

1373: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).type_type = ' || mlcs_tbl(k).type_type);
1374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).type_id = ' || mlcs_tbl(k).type_id);
1375: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).duration = ' || mlcs_tbl(k).duration);
1376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).milcs_type_id = ' || mlcs_tbl(k).milcs_type_id);
1377: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).media_id = ' || med_id);
1378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).handler_id = ' || mlcs_tbl(k).handler_id);
1379: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).resource_id = ' || mlcs_tbl(k).resource_id);
1380: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).milcs_code = ' || mlcs_tbl(k).milcs_code);
1381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');

Line 1378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).handler_id = ' || mlcs_tbl(k).handler_id);

1374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).type_id = ' || mlcs_tbl(k).type_id);
1375: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).duration = ' || mlcs_tbl(k).duration);
1376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).milcs_type_id = ' || mlcs_tbl(k).milcs_type_id);
1377: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).media_id = ' || med_id);
1378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).handler_id = ' || mlcs_tbl(k).handler_id);
1379: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).resource_id = ' || mlcs_tbl(k).resource_id);
1380: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).milcs_code = ' || mlcs_tbl(k).milcs_code);
1381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-- bulk attributes');

Line 1379: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).resource_id = ' || mlcs_tbl(k).resource_id);

1375: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).duration = ' || mlcs_tbl(k).duration);
1376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).milcs_type_id = ' || mlcs_tbl(k).milcs_type_id);
1377: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).media_id = ' || med_id);
1378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).handler_id = ' || mlcs_tbl(k).handler_id);
1379: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).resource_id = ' || mlcs_tbl(k).resource_id);
1380: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).milcs_code = ' || mlcs_tbl(k).milcs_code);
1381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-- bulk attributes');
1383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_writer_code = ' || mlcs_tbl(k).bulk_writer_code);

Line 1380: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).milcs_code = ' || mlcs_tbl(k).milcs_code);

1376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).milcs_type_id = ' || mlcs_tbl(k).milcs_type_id);
1377: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).media_id = ' || med_id);
1378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).handler_id = ' || mlcs_tbl(k).handler_id);
1379: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).resource_id = ' || mlcs_tbl(k).resource_id);
1380: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).milcs_code = ' || mlcs_tbl(k).milcs_code);
1381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-- bulk attributes');
1383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_writer_code = ' || mlcs_tbl(k).bulk_writer_code);
1384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_batch_type = ' || mlcs_tbl(k).bulk_batch_type);

Line 1381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');

1377: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).media_id = ' || med_id);
1378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).handler_id = ' || mlcs_tbl(k).handler_id);
1379: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).resource_id = ' || mlcs_tbl(k).resource_id);
1380: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).milcs_code = ' || mlcs_tbl(k).milcs_code);
1381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-- bulk attributes');
1383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_writer_code = ' || mlcs_tbl(k).bulk_writer_code);
1384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_batch_type = ' || mlcs_tbl(k).bulk_batch_type);
1385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_batch_id = ' || mlcs_tbl(k).bulk_batch_id);

Line 1382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-- bulk attributes');

1378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).handler_id = ' || mlcs_tbl(k).handler_id);
1379: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).resource_id = ' || mlcs_tbl(k).resource_id);
1380: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).milcs_code = ' || mlcs_tbl(k).milcs_code);
1381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-- bulk attributes');
1383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_writer_code = ' || mlcs_tbl(k).bulk_writer_code);
1384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_batch_type = ' || mlcs_tbl(k).bulk_batch_type);
1385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_batch_id = ' || mlcs_tbl(k).bulk_batch_id);
1386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_interaction_id = ' || mlcs_tbl(k).bulk_interaction_id);

Line 1383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_writer_code = ' || mlcs_tbl(k).bulk_writer_code);

1379: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).resource_id = ' || mlcs_tbl(k).resource_id);
1380: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).milcs_code = ' || mlcs_tbl(k).milcs_code);
1381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-- bulk attributes');
1383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_writer_code = ' || mlcs_tbl(k).bulk_writer_code);
1384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_batch_type = ' || mlcs_tbl(k).bulk_batch_type);
1385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_batch_id = ' || mlcs_tbl(k).bulk_batch_id);
1386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_interaction_id = ' || mlcs_tbl(k).bulk_interaction_id);
1387: */

Line 1384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_batch_type = ' || mlcs_tbl(k).bulk_batch_type);

1380: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).milcs_code = ' || mlcs_tbl(k).milcs_code);
1381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-- bulk attributes');
1383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_writer_code = ' || mlcs_tbl(k).bulk_writer_code);
1384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_batch_type = ' || mlcs_tbl(k).bulk_batch_type);
1385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_batch_id = ' || mlcs_tbl(k).bulk_batch_id);
1386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_interaction_id = ' || mlcs_tbl(k).bulk_interaction_id);
1387: */
1388:

Line 1385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_batch_id = ' || mlcs_tbl(k).bulk_batch_id);

1381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-- bulk attributes');
1383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_writer_code = ' || mlcs_tbl(k).bulk_writer_code);
1384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_batch_type = ' || mlcs_tbl(k).bulk_batch_type);
1385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_batch_id = ' || mlcs_tbl(k).bulk_batch_id);
1386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_interaction_id = ' || mlcs_tbl(k).bulk_interaction_id);
1387: */
1388:
1389: END LOOP; -- MLCS nodes

Line 1386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_interaction_id = ' || mlcs_tbl(k).bulk_interaction_id);

1382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-- bulk attributes');
1383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_writer_code = ' || mlcs_tbl(k).bulk_writer_code);
1384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_batch_type = ' || mlcs_tbl(k).bulk_batch_type);
1385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_batch_id = ' || mlcs_tbl(k).bulk_batch_id);
1386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'mlcs_tbl(k).bulk_interaction_id = ' || mlcs_tbl(k).bulk_interaction_id);
1387: */
1388:
1389: END LOOP; -- MLCS nodes
1390:

Line 1427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.start_date_time = ' || med_rec.start_date_time);

1423: med_rec.bulk_batch_id := p_bulk_batch_id;
1424: med_rec.bulk_interaction_id := p_bulk_interaction_id;
1425:
1426: /* Is useful figuring out which attribute is bad if necessary
1427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.start_date_time = ' || med_rec.start_date_time);
1428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.end_date_time = ' || med_rec.end_date_time);
1429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_id = ' || med_rec.media_id);
1430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_id = ' || med_rec.source_id);
1431: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.direction = ' || med_rec.direction);

Line 1428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.end_date_time = ' || med_rec.end_date_time);

1424: med_rec.bulk_interaction_id := p_bulk_interaction_id;
1425:
1426: /* Is useful figuring out which attribute is bad if necessary
1427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.start_date_time = ' || med_rec.start_date_time);
1428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.end_date_time = ' || med_rec.end_date_time);
1429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_id = ' || med_rec.media_id);
1430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_id = ' || med_rec.source_id);
1431: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.direction = ' || med_rec.direction);
1432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.duration = ' || med_rec.duration);

Line 1429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_id = ' || med_rec.media_id);

1425:
1426: /* Is useful figuring out which attribute is bad if necessary
1427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.start_date_time = ' || med_rec.start_date_time);
1428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.end_date_time = ' || med_rec.end_date_time);
1429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_id = ' || med_rec.media_id);
1430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_id = ' || med_rec.source_id);
1431: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.direction = ' || med_rec.direction);
1432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.duration = ' || med_rec.duration);
1433: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.interaction_performed = ' || med_rec.interaction_performed);

Line 1430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_id = ' || med_rec.source_id);

1426: /* Is useful figuring out which attribute is bad if necessary
1427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.start_date_time = ' || med_rec.start_date_time);
1428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.end_date_time = ' || med_rec.end_date_time);
1429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_id = ' || med_rec.media_id);
1430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_id = ' || med_rec.source_id);
1431: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.direction = ' || med_rec.direction);
1432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.duration = ' || med_rec.duration);
1433: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.interaction_performed = ' || med_rec.interaction_performed);
1434: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_data = ' || med_rec.media_data );

Line 1431: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.direction = ' || med_rec.direction);

1427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.start_date_time = ' || med_rec.start_date_time);
1428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.end_date_time = ' || med_rec.end_date_time);
1429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_id = ' || med_rec.media_id);
1430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_id = ' || med_rec.source_id);
1431: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.direction = ' || med_rec.direction);
1432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.duration = ' || med_rec.duration);
1433: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.interaction_performed = ' || med_rec.interaction_performed);
1434: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_data = ' || med_rec.media_data );
1435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_item_create_date_time = ' || med_rec.source_item_create_date_time);

Line 1432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.duration = ' || med_rec.duration);

1428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.end_date_time = ' || med_rec.end_date_time);
1429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_id = ' || med_rec.media_id);
1430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_id = ' || med_rec.source_id);
1431: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.direction = ' || med_rec.direction);
1432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.duration = ' || med_rec.duration);
1433: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.interaction_performed = ' || med_rec.interaction_performed);
1434: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_data = ' || med_rec.media_data );
1435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_item_create_date_time = ' || med_rec.source_item_create_date_time);
1436: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_item_id = ' || med_rec.source_item_id);

Line 1433: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.interaction_performed = ' || med_rec.interaction_performed);

1429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_id = ' || med_rec.media_id);
1430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_id = ' || med_rec.source_id);
1431: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.direction = ' || med_rec.direction);
1432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.duration = ' || med_rec.duration);
1433: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.interaction_performed = ' || med_rec.interaction_performed);
1434: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_data = ' || med_rec.media_data );
1435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_item_create_date_time = ' || med_rec.source_item_create_date_time);
1436: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_item_id = ' || med_rec.source_item_id);
1437: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_item_type = ' || med_rec.media_item_type);

Line 1434: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_data = ' || med_rec.media_data );

1430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_id = ' || med_rec.source_id);
1431: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.direction = ' || med_rec.direction);
1432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.duration = ' || med_rec.duration);
1433: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.interaction_performed = ' || med_rec.interaction_performed);
1434: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_data = ' || med_rec.media_data );
1435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_item_create_date_time = ' || med_rec.source_item_create_date_time);
1436: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_item_id = ' || med_rec.source_item_id);
1437: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_item_type = ' || med_rec.media_item_type);
1438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_item_ref = ' || med_rec.media_item_ref );

Line 1435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_item_create_date_time = ' || med_rec.source_item_create_date_time);

1431: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.direction = ' || med_rec.direction);
1432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.duration = ' || med_rec.duration);
1433: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.interaction_performed = ' || med_rec.interaction_performed);
1434: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_data = ' || med_rec.media_data );
1435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_item_create_date_time = ' || med_rec.source_item_create_date_time);
1436: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_item_id = ' || med_rec.source_item_id);
1437: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_item_type = ' || med_rec.media_item_type);
1438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_item_ref = ' || med_rec.media_item_ref );
1439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_abandon_flag = ' || med_rec.media_abandon_flag);

Line 1436: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_item_id = ' || med_rec.source_item_id);

1432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.duration = ' || med_rec.duration);
1433: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.interaction_performed = ' || med_rec.interaction_performed);
1434: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_data = ' || med_rec.media_data );
1435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_item_create_date_time = ' || med_rec.source_item_create_date_time);
1436: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_item_id = ' || med_rec.source_item_id);
1437: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_item_type = ' || med_rec.media_item_type);
1438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_item_ref = ' || med_rec.media_item_ref );
1439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_abandon_flag = ' || med_rec.media_abandon_flag);
1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_transferred_flag = ' || med_rec.media_transferred_flag);

Line 1437: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_item_type = ' || med_rec.media_item_type);

1433: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.interaction_performed = ' || med_rec.interaction_performed);
1434: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_data = ' || med_rec.media_data );
1435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_item_create_date_time = ' || med_rec.source_item_create_date_time);
1436: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_item_id = ' || med_rec.source_item_id);
1437: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_item_type = ' || med_rec.media_item_type);
1438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_item_ref = ' || med_rec.media_item_ref );
1439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_abandon_flag = ' || med_rec.media_abandon_flag);
1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_transferred_flag = ' || med_rec.media_transferred_flag);
1441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.server_group_id = ' || med_rec.server_group_id );

Line 1438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_item_ref = ' || med_rec.media_item_ref );

1434: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_data = ' || med_rec.media_data );
1435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_item_create_date_time = ' || med_rec.source_item_create_date_time);
1436: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_item_id = ' || med_rec.source_item_id);
1437: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_item_type = ' || med_rec.media_item_type);
1438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_item_ref = ' || med_rec.media_item_ref );
1439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_abandon_flag = ' || med_rec.media_abandon_flag);
1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_transferred_flag = ' || med_rec.media_transferred_flag);
1441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.server_group_id = ' || med_rec.server_group_id );
1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.dnis = ' || med_rec.dnis);

Line 1439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_abandon_flag = ' || med_rec.media_abandon_flag);

1435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_item_create_date_time = ' || med_rec.source_item_create_date_time);
1436: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_item_id = ' || med_rec.source_item_id);
1437: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_item_type = ' || med_rec.media_item_type);
1438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_item_ref = ' || med_rec.media_item_ref );
1439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_abandon_flag = ' || med_rec.media_abandon_flag);
1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_transferred_flag = ' || med_rec.media_transferred_flag);
1441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.server_group_id = ' || med_rec.server_group_id );
1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.dnis = ' || med_rec.dnis);
1443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.ani = ' || med_rec.ani);

Line 1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_transferred_flag = ' || med_rec.media_transferred_flag);

1436: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.source_item_id = ' || med_rec.source_item_id);
1437: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_item_type = ' || med_rec.media_item_type);
1438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_item_ref = ' || med_rec.media_item_ref );
1439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_abandon_flag = ' || med_rec.media_abandon_flag);
1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_transferred_flag = ' || med_rec.media_transferred_flag);
1441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.server_group_id = ' || med_rec.server_group_id );
1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.dnis = ' || med_rec.dnis);
1443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.ani = ' || med_rec.ani);
1444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.classification = ' || med_rec.classification);

Line 1441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.server_group_id = ' || med_rec.server_group_id );

1437: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_item_type = ' || med_rec.media_item_type);
1438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_item_ref = ' || med_rec.media_item_ref );
1439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_abandon_flag = ' || med_rec.media_abandon_flag);
1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_transferred_flag = ' || med_rec.media_transferred_flag);
1441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.server_group_id = ' || med_rec.server_group_id );
1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.dnis = ' || med_rec.dnis);
1443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.ani = ' || med_rec.ani);
1444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.classification = ' || med_rec.classification);
1445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.address = ' || med_rec.address);

Line 1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.dnis = ' || med_rec.dnis);

1438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_item_ref = ' || med_rec.media_item_ref );
1439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_abandon_flag = ' || med_rec.media_abandon_flag);
1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_transferred_flag = ' || med_rec.media_transferred_flag);
1441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.server_group_id = ' || med_rec.server_group_id );
1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.dnis = ' || med_rec.dnis);
1443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.ani = ' || med_rec.ani);
1444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.classification = ' || med_rec.classification);
1445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.address = ' || med_rec.address);
1446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');

Line 1443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.ani = ' || med_rec.ani);

1439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_abandon_flag = ' || med_rec.media_abandon_flag);
1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_transferred_flag = ' || med_rec.media_transferred_flag);
1441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.server_group_id = ' || med_rec.server_group_id );
1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.dnis = ' || med_rec.dnis);
1443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.ani = ' || med_rec.ani);
1444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.classification = ' || med_rec.classification);
1445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.address = ' || med_rec.address);
1446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-- bulk attributes');

Line 1444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.classification = ' || med_rec.classification);

1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.media_transferred_flag = ' || med_rec.media_transferred_flag);
1441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.server_group_id = ' || med_rec.server_group_id );
1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.dnis = ' || med_rec.dnis);
1443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.ani = ' || med_rec.ani);
1444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.classification = ' || med_rec.classification);
1445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.address = ' || med_rec.address);
1446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-- bulk attributes');
1448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_writer_code = ' || med_rec.bulk_writer_code);

Line 1445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.address = ' || med_rec.address);

1441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.server_group_id = ' || med_rec.server_group_id );
1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.dnis = ' || med_rec.dnis);
1443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.ani = ' || med_rec.ani);
1444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.classification = ' || med_rec.classification);
1445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.address = ' || med_rec.address);
1446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-- bulk attributes');
1448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_writer_code = ' || med_rec.bulk_writer_code);
1449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_batch_type = ' || med_rec.bulk_batch_type);

Line 1446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');

1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.dnis = ' || med_rec.dnis);
1443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.ani = ' || med_rec.ani);
1444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.classification = ' || med_rec.classification);
1445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.address = ' || med_rec.address);
1446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-- bulk attributes');
1448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_writer_code = ' || med_rec.bulk_writer_code);
1449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_batch_type = ' || med_rec.bulk_batch_type);
1450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_batch_id = ' || med_rec.bulk_batch_id);

Line 1447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-- bulk attributes');

1443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.ani = ' || med_rec.ani);
1444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.classification = ' || med_rec.classification);
1445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.address = ' || med_rec.address);
1446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-- bulk attributes');
1448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_writer_code = ' || med_rec.bulk_writer_code);
1449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_batch_type = ' || med_rec.bulk_batch_type);
1450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_batch_id = ' || med_rec.bulk_batch_id);
1451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_interaction_id = ' || med_rec.bulk_interaction_id);

Line 1448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_writer_code = ' || med_rec.bulk_writer_code);

1444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.classification = ' || med_rec.classification);
1445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.address = ' || med_rec.address);
1446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-- bulk attributes');
1448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_writer_code = ' || med_rec.bulk_writer_code);
1449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_batch_type = ' || med_rec.bulk_batch_type);
1450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_batch_id = ' || med_rec.bulk_batch_id);
1451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_interaction_id = ' || med_rec.bulk_interaction_id);
1452: */

Line 1449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_batch_type = ' || med_rec.bulk_batch_type);

1445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.address = ' || med_rec.address);
1446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-- bulk attributes');
1448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_writer_code = ' || med_rec.bulk_writer_code);
1449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_batch_type = ' || med_rec.bulk_batch_type);
1450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_batch_id = ' || med_rec.bulk_batch_id);
1451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_interaction_id = ' || med_rec.bulk_interaction_id);
1452: */
1453:

Line 1450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_batch_id = ' || med_rec.bulk_batch_id);

1446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-- bulk attributes');
1448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_writer_code = ' || med_rec.bulk_writer_code);
1449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_batch_type = ' || med_rec.bulk_batch_type);
1450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_batch_id = ' || med_rec.bulk_batch_id);
1451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_interaction_id = ' || med_rec.bulk_interaction_id);
1452: */
1453:
1454: g_hrt_beat := 13.4;

Line 1451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_interaction_id = ' || med_rec.bulk_interaction_id);

1447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-- bulk attributes');
1448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_writer_code = ' || med_rec.bulk_writer_code);
1449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_batch_type = ' || med_rec.bulk_batch_type);
1450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_batch_id = ' || med_rec.bulk_batch_id);
1451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'med_rec.bulk_interaction_id = ' || med_rec.bulk_interaction_id);
1452: */
1453:
1454: g_hrt_beat := 13.4;
1455:

Line 1473: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Create_MediaItem returned - ' || l_ret_status);

1469: p_mlcs => mlcs_tbl);
1470:
1471: -- The dbms_output will need to be replaced by proper logging for error
1472: -- messages.
1473: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Create_MediaItem returned - ' || l_ret_status);
1474: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
1475: l_rtn_name := 'Create_MediaItem';
1476: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Create_MediaItem failed' ||
1477: ', msg_count = ' || l_msg_count ||

Line 1476: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Create_MediaItem failed' ||

1472: -- messages.
1473: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Create_MediaItem returned - ' || l_ret_status);
1474: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
1475: l_rtn_name := 'Create_MediaItem';
1476: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Create_MediaItem failed' ||
1477: ', msg_count = ' || l_msg_count ||
1478: ', msg_data = ' || l_msg_data);*/
1479: RAISE media_exception;
1480: END IF;

Line 1498: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Add_MediaLifecycle failed' ||

1494: p_media_lc_rec => mlcs_tbl(l),
1495: x_milcs_id => l_milcs_id);
1496: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
1497: l_rtn_name := 'Add_MediaLifecycle';
1498: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Add_MediaLifecycle failed' ||
1499: ', msg_count = ' || l_msg_count ||
1500: ', msg_data = ' || l_msg_data);*/
1501: RAISE media_exception;
1502: END IF;

Line 1517: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Close_MediaItem failed' ||

1513: p_media_rec => med_rec);
1514:
1515: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
1516: l_rtn_name := 'Close_MediaItem';
1517: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Close_MediaItem failed' ||
1518: ', msg_count = ' || l_msg_count ||
1519: ', msg_data = ' || l_msg_data);*/
1520: RAISE media_exception;
1521: END IF;

Line 1563: --FND_FILE.PUT_LINE(FND_FILE.LOG, l_err_media);

1559: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_ERROR_MSG');
1560: FND_MESSAGE.SET_TOKEN('MSG_NUM', i);
1561: FND_MESSAGE.SET_TOKEN('MSG_TXT', l_msg_data);
1562: l_err_media := FND_MESSAGE.GET;
1563: --FND_FILE.PUT_LINE(FND_FILE.LOG, l_err_media);
1564:
1565: x_ret_msg := x_ret_msg || l_err_media;
1566:
1567: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1590: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

1586: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
1587: 'jtf.plsql.JTF_IH_BULK.PROCESS_MEDIA_ITEMS', TRUE);
1588: END IF;
1589:
1590: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1591: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1592: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_ERR_CODE_MSG');
1593: FND_MESSAGE.SET_TOKEN('ERR_CODE', error);
1594: FND_MESSAGE.SET_TOKEN('ERR_MSG', errm);

Line 1599: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

1595: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
1596: 'jtf.plsql.JTF_IH_BULK.PROCESS_MEDIA_ITEMS', TRUE);
1597: END IF;
1598:
1599: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1600:
1601: x_ret_msg := errm;
1602:
1603: -- an unknown exception is always unexpected

Line 1689: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'media_id and media_ident values are ' || med_id || ', ' || med_ident);

1685: med_id := med_id_tbl(med_ident);
1686: END IF;
1687:
1688:
1689: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'media_id and media_ident values are ' || med_id || ', ' || med_ident);
1690:
1691: --a.gather each activity's attributes, including media_id using the mapping from b.1.ii.e
1692: date_str := dbms_xmldom.getAttribute(act_elem, 'start_date_time');
1693: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date

Line 1771: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

1767: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
1768: 'jtf.plsql.JTF_IH_BULK.GATHER_ACT_TBL', TRUE);
1769: END IF;
1770:
1771: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1772:
1773: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1774: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_ERR_CODE_MSG');
1775: FND_MESSAGE.SET_TOKEN('ERR_CODE', error);

Line 1781: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

1777: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
1778: 'jtf.plsql.JTF_IH_BULK.GATHER_ACT_TBL', TRUE);
1779: END IF;
1780:
1781: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1782:
1783: x_ret_msg := errm;
1784: END;
1785:

Line 1967: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'In LOG_BULK_ERROR');

1963: error_msg_2 := SUBSTRB(p_error_msg, 0, 2000);
1964: error_msg_2 := error_msg_2 || SUBSTRB(' - ', 0, (2000 - LENGTHB(error_msg_2)));
1965: --error_msg_2 := error_msg_2 || SUBSTRB(p_ret_msg, 0, (2000 - LENGTHB(error_msg_2)));
1966:
1967: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'In LOG_BULK_ERROR');
1968: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'p_error_msg = ' || p_error_msg);
1969: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'p_ret_msg = ' || p_ret_msg);
1970: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'error_msg_2 = ' || error_msg_2);
1971: */

Line 1968: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'p_error_msg = ' || p_error_msg);

1964: error_msg_2 := error_msg_2 || SUBSTRB(' - ', 0, (2000 - LENGTHB(error_msg_2)));
1965: --error_msg_2 := error_msg_2 || SUBSTRB(p_ret_msg, 0, (2000 - LENGTHB(error_msg_2)));
1966:
1967: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'In LOG_BULK_ERROR');
1968: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'p_error_msg = ' || p_error_msg);
1969: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'p_ret_msg = ' || p_ret_msg);
1970: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'error_msg_2 = ' || error_msg_2);
1971: */
1972:

Line 1969: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'p_ret_msg = ' || p_ret_msg);

1965: --error_msg_2 := error_msg_2 || SUBSTRB(p_ret_msg, 0, (2000 - LENGTHB(error_msg_2)));
1966:
1967: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'In LOG_BULK_ERROR');
1968: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'p_error_msg = ' || p_error_msg);
1969: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'p_ret_msg = ' || p_ret_msg);
1970: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'error_msg_2 = ' || error_msg_2);
1971: */
1972:
1973: SELECT JTF_IH_BULK_ERRORS_S1.NEXTVAL INTO rec_id FROM sys.dual;

Line 1970: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'error_msg_2 = ' || error_msg_2);

1966:
1967: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'In LOG_BULK_ERROR');
1968: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'p_error_msg = ' || p_error_msg);
1969: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'p_ret_msg = ' || p_ret_msg);
1970: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'error_msg_2 = ' || error_msg_2);
1971: */
1972:
1973: SELECT JTF_IH_BULK_ERRORS_S1.NEXTVAL INTO rec_id FROM sys.dual;
1974:

Line 1975: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'BULK_ERROR_ID = ' || rec_id);

1971: */
1972:
1973: SELECT JTF_IH_BULK_ERRORS_S1.NEXTVAL INTO rec_id FROM sys.dual;
1974:
1975: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'BULK_ERROR_ID = ' || rec_id);
1976:
1977: -- Bug3781768 Perf issue with literal usage
1978: l_obj_version_perf := 0;
1979:

Line 2024: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

2020: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
2021: 'jtf.plsql.JTF_IH_BULK.LOG_BULK_ERROR', TRUE);
2022: END IF;
2023:
2024: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
2025:
2026: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2027: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_ERR_CODE_MSG');
2028: FND_MESSAGE.SET_TOKEN('ERR_CODE', SQLCODE);

Line 2034: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

2030: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
2031: 'jtf.plsql.JTF_IH_BULK.LOG_BULK_ERROR', TRUE);
2032: END IF;
2033:
2034: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
2035: -- because we got an error saving in the bulk errors, save the xml piece in
2036: -- the concurrent log file
2037:
2038: -- tbd.

Line 2102: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'BULK_ERROR_ID = ' || rec_id);

2098: error_msg_2 := error_msg_2 || SUBSTRB(p_ret_msg, 0, (2000 - LENGTHB(error_msg_2)));
2099:
2100: SELECT JTF_IH_BULK_ERRORS_S1.NEXTVAL INTO rec_id FROM sys.dual;
2101:
2102: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'BULK_ERROR_ID = ' || rec_id);
2103:
2104: -- Bug3781768 Perf issue with literal usage
2105: l_obj_version_perf := 0;
2106:

Line 2139: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

2135: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
2136: 'jtf.plsql.JTF_IH_BULK.LOG_BULK_ERROR', TRUE);
2137: END IF;
2138:
2139: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
2140:
2141: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2142: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_ERR_CODE_MSG');
2143: FND_MESSAGE.SET_TOKEN('ERR_CODE', SQLCODE);

Line 2149: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

2145: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
2146: 'jtf.plsql.JTF_IH_BULK.LOG_BULK_ERROR', TRUE);
2147: END IF;
2148:
2149: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
2150:
2151: -- because we got an error saving in the bulk errors, save the xml piece in
2152: -- the concurrent log file
2153:

Line 2186: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Entered find_one_crash_Recd');

2182: 'jtf.plsql.JTF_IH_BULK.FIND_ONE_CRASH_RECD.begin', l_fnd_log_msg);
2183: END IF;
2184:
2185: g_hrt_beat := -70;
2186: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Entered find_one_crash_Recd');
2187:
2188: OPEN l_rec_cv FOR SELECT * FROM JTF_IH_BULK_RECOVERY;
2189:
2190: -- look for a crash victim in the RECORD_ID for each row in this table

Line 2198: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Data in recov tbl - recovery_id, req_id, msg_id, num_int, (bulk_params)= ' ||

2194:
2195: WHILE (l_rec_cv%FOUND AND (NOT l_found_recd)) LOOP
2196:
2197: g_hrt_beat := -70.5;
2198: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Data in recov tbl - recovery_id, req_id, msg_id, num_int, (bulk_params)= ' ||
2199: l_rec_recd.recovery_id || ', ' ||
2200: l_rec_recd.request_id || ', ' ||
2201: l_rec_recd.msg_id || ', ' ||
2202: l_rec_recd.num_int_processed || ', ' ||

Line 2219: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'get_request_stat - req_id, phase, status, d_phase, d_status, msg = ' ||

2215: DEV_STATUS => l_dev_status,
2216: MESSAGE => l_message);
2217:
2218: g_hrt_beat := -70.5;
2219: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'get_request_stat - req_id, phase, status, d_phase, d_status, msg = ' ||
2220: l_rec_recd.request_id || ', ' ||
2221: l_phase || ', ' ||
2222: l_status || ', ' ||
2223: l_dev_phase || ', ' ||

Line 2241: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

2237: FND_MESSAGE.SET_TOKEN('BATCH_ID', l_rec_recd.bulk_batch_id);
2238: FND_LOG.MESSAGE(FND_LOG.LEVEL_STATEMENT,
2239: 'jtf.plsql.JTF_IH_BULK.FIND_ONE_CRASH_RECD', TRUE);
2240: END IF;
2241: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
2242:
2243: l_found_recd := TRUE;
2244: END IF;
2245:

Line 2269: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Return TRUE find_one_crash_Recd');

2265: -- this record
2266: COMMIT;
2267:
2268: g_hrt_beat := -79;
2269: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Return TRUE find_one_crash_Recd');
2270:
2271: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2272: l_fnd_log_msg := 'FUNCTION FIND_ONE_CRASH_RECD Return parameters :'||
2273: 'return boolean = TRUE';

Line 2282: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Return FALSE find_one_crash_Recd');

2278:
2279: RETURN TRUE;
2280: ELSE
2281: g_hrt_beat := -78;
2282: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Return FALSE find_one_crash_Recd');
2283:
2284: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2285: l_fnd_log_msg := 'FUNCTION FIND_ONE_CRASH_RECD Return parameters :'||
2286: 'return boolean = FALSE';

Line 2312: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Enter CLEAR_ONE_CRASH_RECD');

2308: 'jtf.plsql.JTF_IH_BULK.CLEAR_ONE_CRASH_RECD.begin', l_fnd_log_msg);
2309: END IF;
2310:
2311: g_hrt_beat := -60;
2312: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Enter CLEAR_ONE_CRASH_RECD');
2313:
2314:
2315: /* To Do -
2316: Sort of simple - just pass the bulk record from here to the regular

Line 2338: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

2334: FND_MESSAGE.SET_TOKEN('MSG_ID', l_rec_recd.msg_id);
2335: FND_LOG.MESSAGE(FND_LOG.LEVEL_STATEMENT,
2336: 'jtf.plsql.JTF_IH_BULK.CLEAR_ONE_CRASH_RECD', TRUE);
2337: END IF;
2338: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
2339: END IF;
2340:
2341: -- now that the crash victim has been taken care of, get rid of it
2342: DELETE FROM jtf_ih_bulk_recovery

Line 2348: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End CLEAR_ONE_CRASH_RECD');

2344:
2345: COMMIT;
2346:
2347: g_hrt_beat := -69;
2348: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End CLEAR_ONE_CRASH_RECD');
2349: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2350: l_fnd_log_msg := 'CLEAR_ONE_CRASH_RECD no Out Parameters';
2351: --dbms_output.put_line(l_fnd_log_msg);
2352: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 2387: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Entered crash_recovery');

2383: 3. If not found go back to regular job
2384:
2385: */
2386: g_hrt_beat := -100;
2387: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Entered crash_recovery');
2388:
2389: WHILE (find_one_crash_recd(l_rec_recd)) LOOP
2390: clear_one_crash_recd(l_rec_recd);
2391: END LOOP; -- while(l_rec_recd is not null)

Line 2394: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Normal ending crash_recovery');

2390: clear_one_crash_recd(l_rec_recd);
2391: END LOOP; -- while(l_rec_recd is not null)
2392:
2393: g_hrt_beat := -99;
2394: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Normal ending crash_recovery');
2395:
2396: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2397: l_fnd_log_msg := 'PERFORM_CRASH_RECOVERY No Out parameters';
2398: --dbms_output.put_line(l_fnd_log_msg);

Line 2414: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message: ' || errm );

2410: errm := SQLERRM;
2411: IF (errm IS NULL) THEN
2412: errm := 'No Error Message in SQLERRM for parsing errors';
2413: END IF;
2414: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message: ' || errm );
2415: g_hrt_beat := -98;
2416: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2417: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_RECOV_UNEXP');
2418: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 2425: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

2421: 'jtf.plsql.JTF_IH_BULK.PERFORM_CRASH_RECOVERY',errm);
2422: END IF;
2423: END;
2424:
2425: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
2426:
2427: LOG_EXC_OTHERS('PERFORM_CRASH_RECOVERY');
2428:
2429: END PERFORM_CRASH_RECOVERY;

Line 2469: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

2465: FND_LOG.MESSAGE(FND_LOG.LEVEL_STATEMENT,
2466: 'jtf.plsql.JTF_IH_BULK.LOG_EXC_OTHERS', TRUE);
2467: END IF;
2468:
2469: --FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
2470:
2471: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2472: l_fnd_log_msg := 'LOG_EXC_OTHERS No Out parameters';
2473: --dbms_output.put_line(l_fnd_log_msg);