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.HZ_IMP_ADDRESS_VAL_PKG dependencies on FND_FILE

Line 92: FND_FILE.put_line(fnd_file.log,'Others Error: Aborting Address Validation Child for this batch');

88: p_send_date => null);
89:
90: EXCEPTION
91: WHEN OTHERS THEN
92: FND_FILE.put_line(fnd_file.log,'Others Error: Aborting Address Validation Child for this batch');
93: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
94: raise;
95: END address_validation_child;
96:

Line 93: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);

89:
90: EXCEPTION
91: WHEN OTHERS THEN
92: FND_FILE.put_line(fnd_file.log,'Others Error: Aborting Address Validation Child for this batch');
93: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
94: raise;
95: END address_validation_child;
96:
97: -----------------------------------------------------------------------

Line 266: FND_FILE.put_line(fnd_file.log,'Aborting Address Validation Main for this batch as no batch found');

262: l_dummy1 varchar2(2);
263: l_adapter_found BOOLEAN := FALSE; --Bug No: 3535366
264: BEGIN
265: If p_batch_id is null then
266: FND_FILE.put_line(fnd_file.log,'Aborting Address Validation Main for this batch as no batch found');
267: return; --Nothing to process
268: end if;
269:
270: l_request_data := FND_CONC_GLOBAL.REQUEST_DATA;

Line 301: fnd_file.put_line(FND_FILE.LOG, 'Addrval : l_sub_request_ids='||l_sub_request_ids);

297: end loop; -- end of checking status of child CP
298: */
299: --------------------------
300:
301: fnd_file.put_line(FND_FILE.LOG, 'Addrval : l_sub_request_ids='||l_sub_request_ids);
302:
303: WHILE l_sub_request_ids IS NOT NULL LOOP
304: l_posi1 := INSTRB(l_sub_request_ids, ' ', 1, 1);
305: l_sub_request_id := TO_NUMBER(SUBSTRB(l_sub_request_ids, 1, l_posi1-1));

Line 306: --fnd_file.put_line(FND_FILE.LOG, 'Addrval l_sub_request_id='||l_sub_request_id);

302:
303: WHILE l_sub_request_ids IS NOT NULL LOOP
304: l_posi1 := INSTRB(l_sub_request_ids, ' ', 1, 1);
305: l_sub_request_id := TO_NUMBER(SUBSTRB(l_sub_request_ids, 1, l_posi1-1));
306: --fnd_file.put_line(FND_FILE.LOG, 'Addrval l_sub_request_id='||l_sub_request_id);
307: -- Check return status of validation request.
308: IF (FND_CONCURRENT.GET_REQUEST_STATUS(
309: request_id => l_sub_request_id,
310: phase => l_phase,

Line 315: fnd_file.put_line(FND_FILE.LOG,'Addrval : l_sub_request_id='||l_sub_request_id||',l_dev_phase='||l_dev_phase||',l_dev_status='||l_dev_status);

311: status => l_status,
312: dev_phase => l_dev_phase,
313: dev_status => l_dev_status,
314: message => l_message)) THEN
315: fnd_file.put_line(FND_FILE.LOG,'Addrval : l_sub_request_id='||l_sub_request_id||',l_dev_phase='||l_dev_phase||',l_dev_status='||l_dev_status);
316: IF l_dev_phase <> 'COMPLETE'
317: OR l_dev_status <> 'NORMAL' THEN
318: retcode := 2;
319: FND_FILE.PUT_LINE(FND_FILE.LOG,TO_CHAR( l_sub_request_id ) ||

Line 319: FND_FILE.PUT_LINE(FND_FILE.LOG,TO_CHAR( l_sub_request_id ) ||

315: fnd_file.put_line(FND_FILE.LOG,'Addrval : l_sub_request_id='||l_sub_request_id||',l_dev_phase='||l_dev_phase||',l_dev_status='||l_dev_status);
316: IF l_dev_phase <> 'COMPLETE'
317: OR l_dev_status <> 'NORMAL' THEN
318: retcode := 2;
319: FND_FILE.PUT_LINE(FND_FILE.LOG,TO_CHAR( l_sub_request_id ) ||
320: ' : ' || l_phase || ':' || l_status ||
321: ' (' || l_message || ').' );
322: update HZ_IMP_BATCH_SUMMARY set ADDR_VAL_STATUS = 'ERROR'
323: where batch_id = l_batch_id;

Line 412: FND_FILE.put_line(fnd_file.log,'adapter count:'|| l_adapter_id.count);

408: OPEN imp_adapter_cur;
409: FETCH imp_adapter_cur BULK COLLECT into
410: l_adapter_id,l_adapter_content_source,l_batch_size,l_default_replace_level;
411: CLOSE imp_adapter_cur;
412: FND_FILE.put_line(fnd_file.log,'adapter count:'|| l_adapter_id.count);
413: ELSE
414:
415: -- No Adapter defined for import in hz_imp_adapters for this batch;so get
416: -- the adapters from hz_adapters.

Line 420: FND_FILE.put_line(fnd_file.log,'l_adapter_id count:'|| l_adapter_id.count);

416: -- the adapters from hz_adapters.
417: OPEN adapter_cur;
418: FETCH adapter_cur BULK COLLECT into
419: l_adapter_id,l_adapter_content_source,l_batch_size,l_default_replace_level;
420: FND_FILE.put_line(fnd_file.log,'l_adapter_id count:'|| l_adapter_id.count);
421: IF adapter_cur%NOTFOUND THEN
422: l_adapter_last_fetch := TRUE;
423: END IF;
424: IF l_adapter_id.count = 0 AND l_adapter_last_fetch THEN

Line 425: FND_FILE.put_line(fnd_file.log,'No valid adapter found in hz_adapters for this batch.');

421: IF adapter_cur%NOTFOUND THEN
422: l_adapter_last_fetch := TRUE;
423: END IF;
424: IF l_adapter_id.count = 0 AND l_adapter_last_fetch THEN
425: FND_FILE.put_line(fnd_file.log,'No valid adapter found in hz_adapters for this batch.');
426: --RETURN; Bug no:3365035.Commented return to continue the execution.
427: END IF;
428: CLOSE adapter_cur;
429: END IF;

Line 480: fnd_file.put_line(FND_FILE.LOG, 'Error submitting address_validation_child');

476: --Error submitting request
477: update HZ_IMP_BATCH_SUMMARY set ADDR_VAL_STATUS = 'ERROR'
478: where batch_id = l_batch_id;
479: retcode :=2;
480: fnd_file.put_line(FND_FILE.LOG, 'Error submitting address_validation_child');
481: return;
482: -- l_error_count := l_error_count +1;
483: ELSE
484: --Submitted request

Line 490: fnd_file.put_line(FND_FILE.LOG, 'address_validation_main: child request submitted with request_id:'||l_request_id);

486: l_request_data := to_char(l_request_id)||' ' ;
487: else
488: l_request_data := l_request_data ||to_char(l_request_id)||' ' ;
489: end if;
490: fnd_file.put_line(FND_FILE.LOG, 'address_validation_main: child request submitted with request_id:'||l_request_id);
491: END IF;
492:
493: IF l_last_fetch = TRUE THEN
494: EXIT;

Line 513: FND_FILE.put_line(fnd_file.log,'l_adapter_id count:'|| l_adapter_id.count);

509: -- default adapter
510: OPEN default_adapter;
511: FETCH default_adapter bulk collect into
512: l_adapter_id,l_adapter_content_source,l_batch_size,l_default_replace_level;
513: FND_FILE.put_line(fnd_file.log,'l_adapter_id count:'|| l_adapter_id.count);
514: IF default_adapter%NOTFOUND THEN
515: l_adapter_last_fetch := TRUE;
516: END IF;
517: IF l_adapter_id.count = 0 AND l_adapter_last_fetch THEN

Line 518: FND_FILE.put_line(fnd_file.log,'No Valid Default Adapter found');

514: IF default_adapter%NOTFOUND THEN
515: l_adapter_last_fetch := TRUE;
516: END IF;
517: IF l_adapter_id.count = 0 AND l_adapter_last_fetch THEN
518: FND_FILE.put_line(fnd_file.log,'No Valid Default Adapter found');
519: -----Bug No: 3535366----
520: IF NOT l_adapter_found THEN
521: update HZ_IMP_BATCH_SUMMARY set ADDR_VAL_STATUS = 'ERROR'
522: where batch_id = l_batch_id

Line 525: FND_FILE.put_line(fnd_file.log,'Error: No adapters found to process the records, Aborting Address Validation Main for this batch');

521: update HZ_IMP_BATCH_SUMMARY set ADDR_VAL_STATUS = 'ERROR'
522: where batch_id = l_batch_id
523: returning ORIGINAL_SYSTEM into l_orig_system;
524: retcode := 2;
525: FND_FILE.put_line(fnd_file.log,'Error: No adapters found to process the records, Aborting Address Validation Main for this batch');
526: FND_FILE.put_line(fnd_file.log,'Please run the import program by turning Run Address validation to ''NO'' or define at least default adapter');
527: END IF;
528: -----End of Bug No: 3535366----
529: END IF;

Line 526: FND_FILE.put_line(fnd_file.log,'Please run the import program by turning Run Address validation to ''NO'' or define at least default adapter');

522: where batch_id = l_batch_id
523: returning ORIGINAL_SYSTEM into l_orig_system;
524: retcode := 2;
525: FND_FILE.put_line(fnd_file.log,'Error: No adapters found to process the records, Aborting Address Validation Main for this batch');
526: FND_FILE.put_line(fnd_file.log,'Please run the import program by turning Run Address validation to ''NO'' or define at least default adapter');
527: END IF;
528: -----End of Bug No: 3535366----
529: END IF;
530: CLOSE default_adapter;

Line 543: fnd_file.put_line(FND_FILE.LOG, 'No records are found to process for Default Adapter in address_validation_child ');

539: IF addresss_cur_default%NOTFOUND THEN
540: l_last_fetch := TRUE;
541: END IF;
542: IF l_row_id.COUNT = 0 AND l_last_fetch THEN
543: fnd_file.put_line(FND_FILE.LOG, 'No records are found to process for Default Adapter in address_validation_child ');
544: --close addresss_cur_default;
545: EXIT;
546: END IF;
547:

Line 564: fnd_file.put_line(FND_FILE.LOG, 'Error submitting address_validation_child for Default Adapter');

560: --Error submitting request
561: UPDATE HZ_IMP_BATCH_SUMMARY set ADDR_VAL_STATUS = 'ERROR'
562: WHERE batch_id = l_batch_id;
563: retcode :=2;
564: fnd_file.put_line(FND_FILE.LOG, 'Error submitting address_validation_child for Default Adapter');
565:
566: RETURN;
567: -- l_error_count := l_error_count +1;
568: ELSE

Line 575: fnd_file.put_line(FND_FILE.LOG, 'address_validation_main: child request submitted for Default Adapter with request_id:'||l_request_id);

571: l_request_data := to_char(l_request_id)||' ' ;
572: ELSE
573: l_request_data := l_request_data ||to_char(l_request_id)||' ' ;
574: END IF;
575: fnd_file.put_line(FND_FILE.LOG, 'address_validation_main: child request submitted for Default Adapter with request_id:'||l_request_id);
576: END IF;
577:
578: IF l_last_fetch = TRUE THEN
579: EXIT;

Line 600: FND_FILE.put_line(fnd_file.log,'Others Error: Aborting Address Validation Main for this batch');

596: COMMIT;
597:
598: EXCEPTION
599: WHEN OTHERS THEN
600: FND_FILE.put_line(fnd_file.log,'Others Error: Aborting Address Validation Main for this batch');
601: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
602: RAISE ;
603: END address_validation_main;
604:

Line 601: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);

597:
598: EXCEPTION
599: WHEN OTHERS THEN
600: FND_FILE.put_line(fnd_file.log,'Others Error: Aborting Address Validation Main for this batch');
601: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
602: RAISE ;
603: END address_validation_main;
604:
605: -----------------------------------------------------------------------

Line 624: FND_FILE.put_line(fnd_file.log,'compare_treshhold: Aborting processing inboundxml for this batch');

620: return 'N';
621: end if;
622: exception
623: when others THEN
624: FND_FILE.put_line(fnd_file.log,'compare_treshhold: Aborting processing inboundxml for this batch');
625: FND_FILE.put_line(fnd_file.log,'compare_treshhold: p_value1,p_value2:-'||p_value1||'-'||p_value2);
626: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
627: RAISE FND_API.G_EXC_ERROR;
628: end;

Line 625: FND_FILE.put_line(fnd_file.log,'compare_treshhold: p_value1,p_value2:-'||p_value1||'-'||p_value2);

621: end if;
622: exception
623: when others THEN
624: FND_FILE.put_line(fnd_file.log,'compare_treshhold: Aborting processing inboundxml for this batch');
625: FND_FILE.put_line(fnd_file.log,'compare_treshhold: p_value1,p_value2:-'||p_value1||'-'||p_value2);
626: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
627: RAISE FND_API.G_EXC_ERROR;
628: end;
629:

Line 626: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);

622: exception
623: when others THEN
624: FND_FILE.put_line(fnd_file.log,'compare_treshhold: Aborting processing inboundxml for this batch');
625: FND_FILE.put_line(fnd_file.log,'compare_treshhold: p_value1,p_value2:-'||p_value1||'-'||p_value2);
626: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
627: RAISE FND_API.G_EXC_ERROR;
628: end;
629:
630: -----------------------------------------------------------------------

Line 672: FND_FILE.put_line(fnd_file.log,'Can not find record for update HZ_IMP_ADDRESSES_INT: ');

668: AND BATCH_ID = p_batch_id;
669:
670: exception
671: WHEN NO_DATA_FOUND THEN
672: FND_FILE.put_line(fnd_file.log,'Can not find record for update HZ_IMP_ADDRESSES_INT: ');
673: FND_FILE.put_line(fnd_file.log,'Batch_Id,:'||p_batch_id);
674: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM,:'||P_SITE_ORIG_SYSTEM);
675: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM_REFERENCE:'||P_SITE_ORIG_SYSTEM_REFERENCE);
676: RAISE FND_API.G_EXC_ERROR;

Line 673: FND_FILE.put_line(fnd_file.log,'Batch_Id,:'||p_batch_id);

669:
670: exception
671: WHEN NO_DATA_FOUND THEN
672: FND_FILE.put_line(fnd_file.log,'Can not find record for update HZ_IMP_ADDRESSES_INT: ');
673: FND_FILE.put_line(fnd_file.log,'Batch_Id,:'||p_batch_id);
674: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM,:'||P_SITE_ORIG_SYSTEM);
675: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM_REFERENCE:'||P_SITE_ORIG_SYSTEM_REFERENCE);
676: RAISE FND_API.G_EXC_ERROR;
677: WHEN others THEN

Line 674: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM,:'||P_SITE_ORIG_SYSTEM);

670: exception
671: WHEN NO_DATA_FOUND THEN
672: FND_FILE.put_line(fnd_file.log,'Can not find record for update HZ_IMP_ADDRESSES_INT: ');
673: FND_FILE.put_line(fnd_file.log,'Batch_Id,:'||p_batch_id);
674: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM,:'||P_SITE_ORIG_SYSTEM);
675: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM_REFERENCE:'||P_SITE_ORIG_SYSTEM_REFERENCE);
676: RAISE FND_API.G_EXC_ERROR;
677: WHEN others THEN
678: FND_FILE.put_line(fnd_file.log,'update_validated_address: Aborting processing inboundxml for this batch');

Line 675: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM_REFERENCE:'||P_SITE_ORIG_SYSTEM_REFERENCE);

671: WHEN NO_DATA_FOUND THEN
672: FND_FILE.put_line(fnd_file.log,'Can not find record for update HZ_IMP_ADDRESSES_INT: ');
673: FND_FILE.put_line(fnd_file.log,'Batch_Id,:'||p_batch_id);
674: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM,:'||P_SITE_ORIG_SYSTEM);
675: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM_REFERENCE:'||P_SITE_ORIG_SYSTEM_REFERENCE);
676: RAISE FND_API.G_EXC_ERROR;
677: WHEN others THEN
678: FND_FILE.put_line(fnd_file.log,'update_validated_address: Aborting processing inboundxml for this batch');
679: FND_FILE.put_line(fnd_file.log,'Batch_Id,:'||p_batch_id);

Line 678: FND_FILE.put_line(fnd_file.log,'update_validated_address: Aborting processing inboundxml for this batch');

674: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM,:'||P_SITE_ORIG_SYSTEM);
675: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM_REFERENCE:'||P_SITE_ORIG_SYSTEM_REFERENCE);
676: RAISE FND_API.G_EXC_ERROR;
677: WHEN others THEN
678: FND_FILE.put_line(fnd_file.log,'update_validated_address: Aborting processing inboundxml for this batch');
679: FND_FILE.put_line(fnd_file.log,'Batch_Id,:'||p_batch_id);
680: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM,:'||P_SITE_ORIG_SYSTEM);
681: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM_REFERENCE:'||P_SITE_ORIG_SYSTEM_REFERENCE);
682: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);

Line 679: FND_FILE.put_line(fnd_file.log,'Batch_Id,:'||p_batch_id);

675: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM_REFERENCE:'||P_SITE_ORIG_SYSTEM_REFERENCE);
676: RAISE FND_API.G_EXC_ERROR;
677: WHEN others THEN
678: FND_FILE.put_line(fnd_file.log,'update_validated_address: Aborting processing inboundxml for this batch');
679: FND_FILE.put_line(fnd_file.log,'Batch_Id,:'||p_batch_id);
680: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM,:'||P_SITE_ORIG_SYSTEM);
681: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM_REFERENCE:'||P_SITE_ORIG_SYSTEM_REFERENCE);
682: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
683: RAISE FND_API.G_EXC_ERROR;

Line 680: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM,:'||P_SITE_ORIG_SYSTEM);

676: RAISE FND_API.G_EXC_ERROR;
677: WHEN others THEN
678: FND_FILE.put_line(fnd_file.log,'update_validated_address: Aborting processing inboundxml for this batch');
679: FND_FILE.put_line(fnd_file.log,'Batch_Id,:'||p_batch_id);
680: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM,:'||P_SITE_ORIG_SYSTEM);
681: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM_REFERENCE:'||P_SITE_ORIG_SYSTEM_REFERENCE);
682: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
683: RAISE FND_API.G_EXC_ERROR;
684: end;

Line 681: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM_REFERENCE:'||P_SITE_ORIG_SYSTEM_REFERENCE);

677: WHEN others THEN
678: FND_FILE.put_line(fnd_file.log,'update_validated_address: Aborting processing inboundxml for this batch');
679: FND_FILE.put_line(fnd_file.log,'Batch_Id,:'||p_batch_id);
680: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM,:'||P_SITE_ORIG_SYSTEM);
681: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM_REFERENCE:'||P_SITE_ORIG_SYSTEM_REFERENCE);
682: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
683: RAISE FND_API.G_EXC_ERROR;
684: end;
685:

Line 682: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);

678: FND_FILE.put_line(fnd_file.log,'update_validated_address: Aborting processing inboundxml for this batch');
679: FND_FILE.put_line(fnd_file.log,'Batch_Id,:'||p_batch_id);
680: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM,:'||P_SITE_ORIG_SYSTEM);
681: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM_REFERENCE:'||P_SITE_ORIG_SYSTEM_REFERENCE);
682: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
683: RAISE FND_API.G_EXC_ERROR;
684: end;
685:
686: -----------------------------------------------------------------------

Line 705: FND_FILE.put_line(fnd_file.log,'inboundxml_rule called');

701: l_overwrite_threshold VARCHAR2(30);
702: l_batch_sequence NUMBER;
703: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
704: BEGIN
705: FND_FILE.put_line(fnd_file.log,'inboundxml_rule called');
706: l_event_data := p_event.getEventData;
707: IF(l_event_data IS NOT NULL) THEN
708: l_ecx_map_code := p_event.getValueForParameter('ECX_MAP_CODE');
709: FND_FILE.put_line(fnd_file.log,'ECX Map Code: '||l_ecx_map_code);

Line 709: FND_FILE.put_line(fnd_file.log,'ECX Map Code: '||l_ecx_map_code);

705: FND_FILE.put_line(fnd_file.log,'inboundxml_rule called');
706: l_event_data := p_event.getEventData;
707: IF(l_event_data IS NOT NULL) THEN
708: l_ecx_map_code := p_event.getValueForParameter('ECX_MAP_CODE');
709: FND_FILE.put_line(fnd_file.log,'ECX Map Code: '||l_ecx_map_code);
710:
711: ecx_standard.processXMLCover(
712: i_map_code =>l_ecx_map_code,
713: i_inpayload =>l_event_data,

Line 720: FND_FILE.put_line(fnd_file.log,'Expected Error: Aborting processing inboundxml for this batch');

716: END IF;
717: RETURN 'SUCCESS';
718: EXCEPTION
719: WHEN FND_API.G_EXC_ERROR THEN
720: FND_FILE.put_line(fnd_file.log,'Expected Error: Aborting processing inboundxml for this batch');
721: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
722: WF_EVENT.setErrorInfo(p_event, 'ERROR');
723: --return 'ERROR';
724: RAISE FND_API.G_EXC_ERROR; --Bug No: 3778263

Line 727: FND_FILE.put_line(fnd_file.log,'Unexpected Error: Aborting processing inboundxml for this batch');

723: --return 'ERROR';
724: RAISE FND_API.G_EXC_ERROR; --Bug No: 3778263
725:
726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
727: FND_FILE.put_line(fnd_file.log,'Unexpected Error: Aborting processing inboundxml for this batch');
728: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
729: WF_EVENT.setErrorInfo(p_event, 'ERROR');
730: --return 'ERROR';
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; --Bug No: 3778263

Line 733: FND_FILE.put_line(fnd_file.log,'Others Error: Aborting processing inboundxml for this batch');

729: WF_EVENT.setErrorInfo(p_event, 'ERROR');
730: --return 'ERROR';
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; --Bug No: 3778263
732: WHEN OTHERS THEN
733: FND_FILE.put_line(fnd_file.log,'Others Error: Aborting processing inboundxml for this batch');
734: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
735: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
736: wf_event.setErrorInfo(p_event, 'ERROR');
737: --return 'ERROR';

Line 734: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);

730: --return 'ERROR';
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; --Bug No: 3778263
732: WHEN OTHERS THEN
733: FND_FILE.put_line(fnd_file.log,'Others Error: Aborting processing inboundxml for this batch');
734: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
735: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
736: wf_event.setErrorInfo(p_event, 'ERROR');
737: --return 'ERROR';
738: RAISE; --Bug No: 3778263

Line 795: FND_FILE.put_line(fnd_file.log,'calling HZ_LOCATION_SERVICES_PUB.submit_addrval_doc procedure ');

791: l_adapter_id := p_event.getValueForParameter('P_ADAPTER_ID');
792: --
793: ---Call address validation service API
794: --
795: FND_FILE.put_line(fnd_file.log,'calling HZ_LOCATION_SERVICES_PUB.submit_addrval_doc procedure ');
796: FND_FILE.put_line(fnd_file.log,'BATCH_ID: '||l_batch_id);
797: FND_FILE.put_line(fnd_file.log,'ADAPTER ID: '||l_adapter_id);
798: FND_FILE.put_line(fnd_file.log,'ORIG_SYSTEM: '||l_orig_system);
799: FND_FILE.put_line(fnd_file.log,'SUBSET ID '||l_subset_id);

Line 796: FND_FILE.put_line(fnd_file.log,'BATCH_ID: '||l_batch_id);

792: --
793: ---Call address validation service API
794: --
795: FND_FILE.put_line(fnd_file.log,'calling HZ_LOCATION_SERVICES_PUB.submit_addrval_doc procedure ');
796: FND_FILE.put_line(fnd_file.log,'BATCH_ID: '||l_batch_id);
797: FND_FILE.put_line(fnd_file.log,'ADAPTER ID: '||l_adapter_id);
798: FND_FILE.put_line(fnd_file.log,'ORIG_SYSTEM: '||l_orig_system);
799: FND_FILE.put_line(fnd_file.log,'SUBSET ID '||l_subset_id);
800: HZ_LOCATION_SERVICES_PUB.submit_addrval_doc(

Line 797: FND_FILE.put_line(fnd_file.log,'ADAPTER ID: '||l_adapter_id);

793: ---Call address validation service API
794: --
795: FND_FILE.put_line(fnd_file.log,'calling HZ_LOCATION_SERVICES_PUB.submit_addrval_doc procedure ');
796: FND_FILE.put_line(fnd_file.log,'BATCH_ID: '||l_batch_id);
797: FND_FILE.put_line(fnd_file.log,'ADAPTER ID: '||l_adapter_id);
798: FND_FILE.put_line(fnd_file.log,'ORIG_SYSTEM: '||l_orig_system);
799: FND_FILE.put_line(fnd_file.log,'SUBSET ID '||l_subset_id);
800: HZ_LOCATION_SERVICES_PUB.submit_addrval_doc(
801: p_addrval_doc => l_event_data,

Line 798: FND_FILE.put_line(fnd_file.log,'ORIG_SYSTEM: '||l_orig_system);

794: --
795: FND_FILE.put_line(fnd_file.log,'calling HZ_LOCATION_SERVICES_PUB.submit_addrval_doc procedure ');
796: FND_FILE.put_line(fnd_file.log,'BATCH_ID: '||l_batch_id);
797: FND_FILE.put_line(fnd_file.log,'ADAPTER ID: '||l_adapter_id);
798: FND_FILE.put_line(fnd_file.log,'ORIG_SYSTEM: '||l_orig_system);
799: FND_FILE.put_line(fnd_file.log,'SUBSET ID '||l_subset_id);
800: HZ_LOCATION_SERVICES_PUB.submit_addrval_doc(
801: p_addrval_doc => l_event_data,
802: p_adapter_id => l_adapter_id,

Line 799: FND_FILE.put_line(fnd_file.log,'SUBSET ID '||l_subset_id);

795: FND_FILE.put_line(fnd_file.log,'calling HZ_LOCATION_SERVICES_PUB.submit_addrval_doc procedure ');
796: FND_FILE.put_line(fnd_file.log,'BATCH_ID: '||l_batch_id);
797: FND_FILE.put_line(fnd_file.log,'ADAPTER ID: '||l_adapter_id);
798: FND_FILE.put_line(fnd_file.log,'ORIG_SYSTEM: '||l_orig_system);
799: FND_FILE.put_line(fnd_file.log,'SUBSET ID '||l_subset_id);
800: HZ_LOCATION_SERVICES_PUB.submit_addrval_doc(
801: p_addrval_doc => l_event_data,
802: p_adapter_id => l_adapter_id,
803: p_country_code => null,

Line 826: FND_FILE.put_line(fnd_file.log,'outboundxml_rule: raising inboundxml event');

822: l_event_key := 'HZ_IMP_IN'||l_batch_id||'-'||l_subset_id||'-'||to_char(sysdate,'HH:MI:SS');
823: --
824: --- Raise the event for inboundxml
825: --
826: FND_FILE.put_line(fnd_file.log,'outboundxml_rule: raising inboundxml event');
827: wf_event.raise(
828: p_event_name => 'oracle.apps.ar.hz.import.inboundxml',
829: p_event_key => l_event_key,
830: p_event_data => to_clob(l_event_data),

Line 840: FND_FILE.put_line(fnd_file.log,'Expected Error: Aborting outboundxml process for this batch');

836:
837: RETURN 'SUCCESS';
838: EXCEPTION
839: WHEN FND_API.G_EXC_ERROR THEN
840: FND_FILE.put_line(fnd_file.log,'Expected Error: Aborting outboundxml process for this batch');
841: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
842: WF_EVENT.setErrorInfo(p_event, 'ERROR');
843: --return 'ERROR';
844: RAISE FND_API.G_EXC_ERROR; --Bug No: 3778263

Line 847: FND_FILE.put_line(fnd_file.log,'Unexpected Error: Aborting outboundxml process for this batch');

843: --return 'ERROR';
844: RAISE FND_API.G_EXC_ERROR; --Bug No: 3778263
845:
846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
847: FND_FILE.put_line(fnd_file.log,'Unexpected Error: Aborting outboundxml process for this batch');
848: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
849: WF_EVENT.setErrorInfo(p_event, 'ERROR');
850: --return 'ERROR';
851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; --Bug No: 3778263

Line 853: FND_FILE.put_line(fnd_file.log,'Others Error: Aborting outboundxml process for this batch');

849: WF_EVENT.setErrorInfo(p_event, 'ERROR');
850: --return 'ERROR';
851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; --Bug No: 3778263
852: WHEN OTHERS THEN
853: FND_FILE.put_line(fnd_file.log,'Others Error: Aborting outboundxml process for this batch');
854: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
855: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
856: wf_event.setErrorInfo(p_event, 'ERROR');
857: --return 'ERROR';

Line 854: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);

850: --return 'ERROR';
851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; --Bug No: 3778263
852: WHEN OTHERS THEN
853: FND_FILE.put_line(fnd_file.log,'Others Error: Aborting outboundxml process for this batch');
854: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
855: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
856: wf_event.setErrorInfo(p_event, 'ERROR');
857: --return 'ERROR';
858: RAISE; --Bug No: 3778263