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_LOAD_POST_PROCESS_PKG dependencies on FND_FILE

Line 107: fnd_file.put_line(fnd_file.log, ' pp_denorm_rel+');

103: and rs.relationship_code IN ('COMPETITOR_OF','REFERENCE_FOR','PARTNER_OF');
104:
105: BEGIN
106:
107: fnd_file.put_line(fnd_file.log, ' pp_denorm_rel+');
108: OPEN c_denorm_rel ;
109: FETCH c_denorm_rel BULK COLLECT INTO
110: l_subject_id,l_comp_flag,l_ref_flag,l_par_flag;
111: CLOSE c_denorm_rel ;

Line 113: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_denorm_rel = ' || l_subject_id.COUNT);

109: FETCH c_denorm_rel BULK COLLECT INTO
110: l_subject_id,l_comp_flag,l_ref_flag,l_par_flag;
111: CLOSE c_denorm_rel ;
112:
113: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_denorm_rel = ' || l_subject_id.COUNT);
114:
115: IF l_subject_id.COUNT = 0 THEN
116: RETURN;
117: END IF;

Line 140: fnd_file.put_line(fnd_file.log,' Unexpected error occured in the post processing

136: WHERE batch_id = p_batch_id);
137: END IF;
138: EXCEPTION
139: WHEN OTHERS THEN
140: fnd_file.put_line(fnd_file.log,' Unexpected error occured in the post processing
141: relationship denormalization program ');
142: RAISE;
143: END;
144:

Line 145: fnd_file.put_line(fnd_file.log, ' pp_denorm_rel-');

141: relationship denormalization program ');
142: RAISE;
143: END;
144:
145: fnd_file.put_line(fnd_file.log, ' pp_denorm_rel-');
146: END pp_denorm_rel;
147:
148: /* *
149: *=======================================================================*

Line 218: fnd_file.put_line(fnd_file.log, ' pp_format_person_name+');

214: c_person_name RefCurType;
215:
216: BEGIN
217:
218: fnd_file.put_line(fnd_file.log, ' pp_format_person_name+');
219: IF p_postprocess_status IS NULL THEN
220: OPEN c_person_name FOR l_new_sql
221: USING p_request_id, p_batch_id, p_os, p_from_osr, p_to_osr, p_batch_mode_flag;
222: ELSIF p_postprocess_status = 'U' THEN

Line 233: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_format_person_name = ' || l_party_id.COUNT);

229: l_person_name_suffix,l_known_as,l_person_first_name_phonetic,
230: l_middle_name_phonetic,l_person_last_name_phonetic;
231: CLOSE c_person_name;
232:
233: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_format_person_name = ' || l_party_id.COUNT);
234: IF l_party_id.COUNT = 0 THEN
235: RETURN;
236: END IF;
237:

Line 275: fnd_file.put_line(fnd_file.log,' Unexpected error occured in the post processing person name format program

271: WHERE party_id = l_party_id(i);
272:
273: EXCEPTION
274: WHEN OTHERS THEN
275: fnd_file.put_line(fnd_file.log,' Unexpected error occured in the post processing person name format program
276: for Party : ' || l_party_id(i));
277: RAISE;
278: END;
279:

Line 281: fnd_file.put_line(fnd_file.log, ' pp_format_person_name-');

277: RAISE;
278: END;
279:
280: END LOOP;
281: fnd_file.put_line(fnd_file.log, ' pp_format_person_name-');
282:
283: END pp_format_person_name;
284:
285: /* *

Line 351: fnd_file.put_line(fnd_file.log, ' pp_generate_cust_key+');

347: c_gen_cust_key RefCurType;
348:
349: BEGIN
350:
351: fnd_file.put_line(fnd_file.log, ' pp_generate_cust_key+');
352:
353: IF p_postprocess_status IS NULL THEN
354: fnd_file.put_line(fnd_file.log, 'p_postprocess_status IS NULL');
355:

Line 354: fnd_file.put_line(fnd_file.log, 'p_postprocess_status IS NULL');

350:
351: fnd_file.put_line(fnd_file.log, ' pp_generate_cust_key+');
352:
353: IF p_postprocess_status IS NULL THEN
354: fnd_file.put_line(fnd_file.log, 'p_postprocess_status IS NULL');
355:
356: OPEN c_gen_cust_key FOR l_new_sql
357: USING p_request_id, p_batch_id, p_os, p_from_osr, p_to_osr, p_batch_mode_flag;
358: ELSIF p_postprocess_status = 'U' THEN

Line 359: fnd_file.put_line(fnd_file.log, 'p_postprocess_status IS -NOT- NULL');

355:
356: OPEN c_gen_cust_key FOR l_new_sql
357: USING p_request_id, p_batch_id, p_os, p_from_osr, p_to_osr, p_batch_mode_flag;
358: ELSIF p_postprocess_status = 'U' THEN
359: fnd_file.put_line(fnd_file.log, 'p_postprocess_status IS -NOT- NULL');
360: OPEN c_gen_cust_key FOR l_rerun_sql
361: USING p_batch_id, p_os, p_from_osr, p_to_osr, p_batch_mode_flag;
362: END IF;
363:

Line 369: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_generate_cust_key = ' || l_party_id.COUNT);

365: l_party_id,l_party_type,l_party_name,l_person_first_name,l_person_last_name,
366: l_record_id, l_entity, l_operation;
367: CLOSE c_gen_cust_key ;
368:
369: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_generate_cust_key = ' || l_party_id.COUNT);
370: IF l_party_id.COUNT = 0 THEN
371: RETURN;
372: END IF;
373:

Line 377: fnd_file.put_line(fnd_file.log, ' sync PARTY');

373:
374: -- Bug 4925023 : call HZ_DQM_SYNC once with new spec
375: /*
376: IF (p_enable_dqm_sync <> 'DISABLE') THEN
377: fnd_file.put_line(fnd_file.log, ' sync PARTY');
378: HZ_DQM_SYNC.sync_work_unit_imp(l_party_id, l_record_id, l_entity, l_operation, l_party_type,
379: l_return_status, l_msg_count, l_msg_data);
380: END IF;
381: */

Line 403: fnd_file.put_line(fnd_file.log,' Unexpected error occured in the post processing customer key generation program

399: SET customer_key = l_key
400: WHERE party_id = l_party_id(i);
401: EXCEPTION
402: WHEN OTHERS THEN
403: fnd_file.put_line(fnd_file.log,' Unexpected error occured in the post processing customer key generation program
404: for Party : ' || l_party_id(i));
405: RAISE;
406: END;
407: END LOOP;

Line 411: fnd_file.put_line(fnd_file.log, ' pp_generate_cust_key-');

407: END LOOP;
408:
409: END IF;
410:
411: fnd_file.put_line(fnd_file.log, ' pp_generate_cust_key-');
412:
413: END pp_generate_cust_key;
414:
415: /* *

Line 489: fnd_file.put_line(fnd_file.log, ' pp_generate_addr_key+');

485: c_gen_addr_key RefCurType;
486:
487: BEGIN
488:
489: fnd_file.put_line(fnd_file.log, ' pp_generate_addr_key+');
490: IF p_postprocess_status IS NULL THEN
491: OPEN c_gen_addr_key FOR l_new_sql
492: USING p_request_id, p_batch_id, p_batch_mode_flag, p_os, p_from_osr, p_to_osr;
493: ELSIF p_postprocess_status = 'U' THEN

Line 503: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_generate_addr_key = ' || l_location_id.COUNT);

499: l_location_id,l_address1,l_address2,l_address3,l_address4,l_postal_code,
500: l_party_id, l_record_id, l_entity, l_operation, l_party_type;
501: CLOSE c_gen_addr_key ;
502:
503: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_generate_addr_key = ' || l_location_id.COUNT);
504:
505: IF l_location_id.COUNT = 0 THEN
506: RETURN;
507: END IF;

Line 512: fnd_file.put_line(fnd_file.log, ' sync PARTY_SITES');

508:
509: -- Bug 4925023 : call HZ_DQM_SYNC once with new spec
510: /*
511: IF (p_enable_dqm_sync <> 'DISABLE') THEN
512: fnd_file.put_line(fnd_file.log, ' sync PARTY_SITES');
513: HZ_DQM_SYNC.sync_work_unit_imp(l_party_id, l_record_id, l_entity, l_operation, l_party_type,
514: l_return_status, l_msg_count, l_msg_data);
515: END IF;
516: */

Line 538: fnd_file.put_line(fnd_file.log,' Unexpected error occured in the post processing address key generation program

534: SET address_key = l_key
535: WHERE location_id = l_location_id(i);
536: EXCEPTION
537: WHEN OTHERS THEN
538: fnd_file.put_line(fnd_file.log,' Unexpected error occured in the post processing address key generation program
539: for location : ' || l_location_id(i) );
540: RAISE;
541: END;
542: END LOOP;

Line 545: fnd_file.put_line(fnd_file.log, ' pp_generate_addr_key-');

541: END;
542: END LOOP;
543: END IF;
544:
545: fnd_file.put_line(fnd_file.log, ' pp_generate_addr_key-');
546:
547: END pp_generate_addr_key;
548:
549: /* *

Line 602: fnd_file.put_line(fnd_file.log, ' pp_dnb_hierarchy+');

598: l_msg_count NUMBER;
599:
600: BEGIN
601:
602: fnd_file.put_line(fnd_file.log, ' pp_dnb_hierarchy+');
603: OPEN c_party;
604: FETCH c_party BULK COLLECT INTO
605: l_object_id,l_subject_id,l_relationship_code;
606: CLOSE c_party;

Line 608: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_dnb_hierarchy = ' || l_object_id.COUNT);

604: FETCH c_party BULK COLLECT INTO
605: l_object_id,l_subject_id,l_relationship_code;
606: CLOSE c_party;
607:
608: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_dnb_hierarchy = ' || l_object_id.COUNT);
609:
610: IF l_object_id.COUNT = 0 THEN
611: RETURN;
612: END IF;

Line 618: fnd_file.put_line(fnd_file.log, ' create dnb hierarchy for : ' || l_prev_obj_id ||

614: BEGIN
615: FOR j in 1..l_object_id.count LOOP
616:
617: IF l_prev_obj_id IS NOT NULL AND l_prev_obj_id <> l_object_id(j) THEN
618: fnd_file.put_line(fnd_file.log, ' create dnb hierarchy for : ' || l_prev_obj_id ||
619: ' parent ' || l_parent_party_id || ' type ' || l_parent_type_flg ||
620: ' dup ' || l_dup_party_id || ' gup ' || l_gup_party_id );
621:
622: HZ_DNB_HIERARCHY_PVT.conform_party_to_dnb_hierarchy( p_init_msg_list,

Line 643: fnd_file.put_line(fnd_file.log, ' obj ' || l_object_id(j) || ' HQ ' || l_parent_party_id);

639:
640: IF l_relationship_code(j) = 'HEADQUARTERS_OF' THEN
641: l_parent_party_id := l_subject_id(j);
642: l_parent_type_flg := 'H';
643: fnd_file.put_line(fnd_file.log, ' obj ' || l_object_id(j) || ' HQ ' || l_parent_party_id);
644: ELSIF l_relationship_code(j) = 'PARENT_OF' THEN
645: l_parent_party_id := l_subject_id(j);
646: l_parent_type_flg := 'P';
647: fnd_file.put_line(fnd_file.log, ' obj ' || l_object_id(j) || ' par ' || l_parent_party_id);

Line 647: fnd_file.put_line(fnd_file.log, ' obj ' || l_object_id(j) || ' par ' || l_parent_party_id);

643: fnd_file.put_line(fnd_file.log, ' obj ' || l_object_id(j) || ' HQ ' || l_parent_party_id);
644: ELSIF l_relationship_code(j) = 'PARENT_OF' THEN
645: l_parent_party_id := l_subject_id(j);
646: l_parent_type_flg := 'P';
647: fnd_file.put_line(fnd_file.log, ' obj ' || l_object_id(j) || ' par ' || l_parent_party_id);
648: ELSIF l_relationship_code(j) = 'DOMESTIC_ULTIMATE_OF' THEN
649: l_dup_party_id := l_subject_id(j);
650: fnd_file.put_line(fnd_file.log, ' obj ' || l_object_id(j) || ' dup ' || l_dup_party_id);
651: ELSIF l_relationship_code(j) = 'GLOBAL_ULTIMATE_OF' THEN

Line 650: fnd_file.put_line(fnd_file.log, ' obj ' || l_object_id(j) || ' dup ' || l_dup_party_id);

646: l_parent_type_flg := 'P';
647: fnd_file.put_line(fnd_file.log, ' obj ' || l_object_id(j) || ' par ' || l_parent_party_id);
648: ELSIF l_relationship_code(j) = 'DOMESTIC_ULTIMATE_OF' THEN
649: l_dup_party_id := l_subject_id(j);
650: fnd_file.put_line(fnd_file.log, ' obj ' || l_object_id(j) || ' dup ' || l_dup_party_id);
651: ELSIF l_relationship_code(j) = 'GLOBAL_ULTIMATE_OF' THEN
652: l_gup_party_id := l_subject_id(j);
653: fnd_file.put_line(fnd_file.log, ' obj ' || l_object_id(j) || ' gup ' || l_gup_party_id);
654: END IF;

Line 653: fnd_file.put_line(fnd_file.log, ' obj ' || l_object_id(j) || ' gup ' || l_gup_party_id);

649: l_dup_party_id := l_subject_id(j);
650: fnd_file.put_line(fnd_file.log, ' obj ' || l_object_id(j) || ' dup ' || l_dup_party_id);
651: ELSIF l_relationship_code(j) = 'GLOBAL_ULTIMATE_OF' THEN
652: l_gup_party_id := l_subject_id(j);
653: fnd_file.put_line(fnd_file.log, ' obj ' || l_object_id(j) || ' gup ' || l_gup_party_id);
654: END IF;
655:
656: l_prev_obj_id := l_object_id(j);
657:

Line 661: fnd_file.put_line(fnd_file.log, ' create dnb hierarchy for : ' || l_prev_obj_id ||

657:
658: END LOOP;
659:
660: -- Call HZ_DNB_HIERARCHY_PVT for last set of data
661: fnd_file.put_line(fnd_file.log, ' create dnb hierarchy for : ' || l_prev_obj_id ||
662: ' parent ' || l_parent_party_id || ' type ' || l_parent_type_flg ||
663: ' dup ' || l_dup_party_id || ' gup ' || l_gup_party_id );
664:
665: HZ_DNB_HIERARCHY_PVT.conform_party_to_dnb_hierarchy( p_init_msg_list,

Line 677: fnd_file.put_line(fnd_file.log,

673: l_msg_data
674: );
675: EXCEPTION
676: WHEN OTHERS THEN
677: fnd_file.put_line(fnd_file.log,
678: ' Unexpected error occured in the post processing dnb hierarchy program for party : ' || l_prev_obj_id);
679: RAISE;
680: END;
681:

Line 682: fnd_file.put_line(fnd_file.log, ' pp_dnb_hierarchy-');

678: ' Unexpected error occured in the post processing dnb hierarchy program for party : ' || l_prev_obj_id);
679: RAISE;
680: END;
681:
682: fnd_file.put_line(fnd_file.log, ' pp_dnb_hierarchy-');
683:
684: END pp_dnb_hierarchy;
685:
686: /* *

Line 731: fnd_file.put_line(fnd_file.log, ' pp_generate_loc_assignments+');

727: msg VARCHAR2(2000);
728:
729: BEGIN
730:
731: fnd_file.put_line(fnd_file.log, ' pp_generate_loc_assignments+');
732: OPEN c_loc;
733: FETCH c_loc BULK COLLECT INTO l_location_id,l_created_by_module,l_site_orig_system_reference;
734: CLOSE c_loc;
735: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_generate_loc_assignments = ' || l_location_id.COUNT);

Line 735: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_generate_loc_assignments = ' || l_location_id.COUNT);

731: fnd_file.put_line(fnd_file.log, ' pp_generate_loc_assignments+');
732: OPEN c_loc;
733: FETCH c_loc BULK COLLECT INTO l_location_id,l_created_by_module,l_site_orig_system_reference;
734: CLOSE c_loc;
735: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_generate_loc_assignments = ' || l_location_id.COUNT);
736:
737: IF l_location_id.COUNT = 0 THEN
738: RETURN;
739: END IF;

Line 760: fnd_file.put_line(' ' || fnd_file.log,msg);

756: FND_MESSAGE.SET_TOKEN('LOCATION_ID', l_location_id(i));
757: FND_MESSAGE.SET_TOKEN('SITE_OSR', l_site_orig_system_reference(i));
758: FND_MESSAGE.SET_TOKEN('ORG_ID',l_org_id );
759: msg := FND_MESSAGE.GET;
760: fnd_file.put_line(' ' || fnd_file.log,msg);
761: END IF;
762: EXCEPTION
763: WHEN OTHERS THEN
764: fnd_file.put_line(fnd_file.log,' Unexpected error occured in the post processing loc assignment generation program

Line 764: fnd_file.put_line(fnd_file.log,' Unexpected error occured in the post processing loc assignment generation program

760: fnd_file.put_line(' ' || fnd_file.log,msg);
761: END IF;
762: EXCEPTION
763: WHEN OTHERS THEN
764: fnd_file.put_line(fnd_file.log,' Unexpected error occured in the post processing loc assignment generation program
765: for Location : ' || l_location_id(i) );
766: RAISE;
767: END;
768: END LOOP;

Line 770: fnd_file.put_line(fnd_file.log, ' pp_generate_loc_assignments-');

766: RAISE;
767: END;
768: END LOOP;
769: END;
770: fnd_file.put_line(fnd_file.log, ' pp_generate_loc_assignments-');
771:
772: END pp_generate_loc_assignments;
773:
774: PROCEDURE pp_generate_loc_timezone (

Line 807: fnd_file.put_line(fnd_file.log, ' pp_generate_loc_timezone+');

803: decode(addr_int.POSTAL_CODE,p_g_miss_char,NULL,addr_int.POSTAL_CODE) IS NOT NULL);
804:
805: BEGIN
806:
807: fnd_file.put_line(fnd_file.log, ' pp_generate_loc_timezone+');
808: OPEN c_timezone_loc;
809: FETCH c_timezone_loc BULK COLLECT INTO l_location_id,l_country,l_state,l_city,l_postal_code;
810: CLOSE c_timezone_loc;
811: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_generate_loc_timezone = ' || l_location_id.COUNT);

Line 811: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_generate_loc_timezone = ' || l_location_id.COUNT);

807: fnd_file.put_line(fnd_file.log, ' pp_generate_loc_timezone+');
808: OPEN c_timezone_loc;
809: FETCH c_timezone_loc BULK COLLECT INTO l_location_id,l_country,l_state,l_city,l_postal_code;
810: CLOSE c_timezone_loc;
811: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_generate_loc_timezone = ' || l_location_id.COUNT);
812:
813: IF l_location_id.COUNT = 0 THEN
814: RETURN;
815: END IF;

Line 842: fnd_file.put_line(fnd_file.log,' Unexpected error occured in the post processing location timezone generation program

838: SET timezone_id = l_timezone_id
839: WHERE location_id = l_location_id(i);
840: EXCEPTION
841: WHEN OTHERS THEN
842: fnd_file.put_line(fnd_file.log,' Unexpected error occured in the post processing location timezone generation program
843: for Location : ' || l_location_id(i));
844: RAISE;
845: END;
846: END LOOP;

Line 848: fnd_file.put_line(fnd_file.log, ' pp_generate_loc_timezone-');

844: RAISE;
845: END;
846: END LOOP;
847: END;
848: fnd_file.put_line(fnd_file.log, ' pp_generate_loc_timezone-');
849:
850: END pp_generate_loc_timezone;
851:
852: PROCEDURE pp_generate_cp_timezone (

Line 897: fnd_file.put_line(fnd_file.log, ' pp_generate_cp_timezone+');

893: c_timezone_cp RefCurType;
894:
895: BEGIN
896:
897: fnd_file.put_line(fnd_file.log, ' pp_generate_cp_timezone+');
898: IF p_postprocess_status IS NULL THEN
899: OPEN c_timezone_cp FOR l_new_sql
900: USING p_batch_id, p_os, p_from_osr, p_to_osr, p_batch_mode_flag, p_request_id, p_g_miss_char, p_g_miss_char;
901: ELSIF p_postprocess_status = 'U' THEN

Line 908: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_generate_cp_timezone = ' || l_contact_point_id.COUNT);

904: END IF;
905:
906: FETCH c_timezone_cp BULK COLLECT INTO l_contact_point_id,l_country_code,l_phone_area_code;
907: CLOSE c_timezone_cp;
908: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_generate_cp_timezone = ' || l_contact_point_id.COUNT);
909:
910: IF l_contact_point_id.COUNT = 0 THEN
911: RETURN;
912: END IF;

Line 939: fnd_file.put_line(fnd_file.log,' Unexpected error occured in the post processing contact point timezone generation program

935: SET timezone_id = l_timezone_id
936: WHERE contact_point_id = l_contact_point_id(i);
937: EXCEPTION
938: WHEN OTHERS THEN
939: fnd_file.put_line(fnd_file.log,' Unexpected error occured in the post processing contact point timezone generation program
940: for Contact Point : ' || l_contact_point_id(i));
941: RAISE;
942: END;
943: END LOOP;

Line 945: fnd_file.put_line(fnd_file.log, ' pp_generate_cp_timezone-');

941: RAISE;
942: END;
943: END LOOP;
944: END;
945: fnd_file.put_line(fnd_file.log, ' pp_generate_cp_timezone-');
946:
947: END pp_generate_cp_timezone ;
948:
949: /* *

Line 1027: fnd_file.put_line(fnd_file.log, ' pp_phone_format+');

1023: c_phone_format RefCurType;
1024:
1025: BEGIN
1026:
1027: fnd_file.put_line(fnd_file.log, ' pp_phone_format+');
1028: IF p_postprocess_status IS NULL THEN
1029: OPEN c_phone_format FOR l_new_sql
1030: USING p_request_id, p_batch_id, p_os, p_from_osr, p_to_osr, p_batch_mode_flag;
1031: ELSIF p_postprocess_status = 'U' THEN

Line 1043: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_phone_format = ' || l_contact_point_id.COUNT);

1039: l_primary_by_purpose,l_phone_line_type,l_phone_extension,
1040: l_contact_point_type,l_party_id, l_record_id, l_entity, l_operation, l_party_type;
1041: CLOSE c_phone_format;
1042:
1043: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_phone_format = ' || l_contact_point_id.COUNT);
1044:
1045: IF l_contact_point_id.COUNT = 0 THEN
1046: RETURN;
1047: END IF;

Line 1052: fnd_file.put_line(fnd_file.log, ' sync CONTACT_POINTS');

1048:
1049: -- Bug 4925023 : call HZ_DQM_SYNC once with new spec
1050: /*
1051: IF (p_enable_dqm_sync <> 'DISABLE') THEN
1052: fnd_file.put_line(fnd_file.log, ' sync CONTACT_POINTS');
1053: HZ_DQM_SYNC.sync_work_unit_imp(l_party_id, l_record_id, l_entity, l_operation, l_party_type,
1054: l_return_status, l_msg_count, l_msg_data);
1055: END IF;
1056: */

Line 1101: fnd_file.put_line(fnd_file.log,' The phone format API failed for contact point id ' || l_contact_point_id(i));

1097: x_msg_count => l_msg_count,
1098: x_msg_data => l_msg_data);
1099:
1100: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1101: fnd_file.put_line(fnd_file.log,' The phone format API failed for contact point id ' || l_contact_point_id(i));
1102: -- l_formatted_phone_number := NULL;
1103: END IF;
1104:
1105: Update hz_contact_points SET

Line 1137: fnd_file.put_line(fnd_file.log,' Unexpected error occured in the post processing phone format program

1133:
1134: END IF; -- end IF l_contact_point_type(i) = 'PHONE'
1135: EXCEPTION
1136: WHEN OTHERS THEN
1137: fnd_file.put_line(fnd_file.log,' Unexpected error occured in the post processing phone format program
1138: for Contact Point : ' || l_contact_point_id(i));
1139: RAISE;
1140: END;
1141: END LOOP;

Line 1142: fnd_file.put_line(fnd_file.log, ' pp_phone_format-');

1138: for Contact Point : ' || l_contact_point_id(i));
1139: RAISE;
1140: END;
1141: END LOOP;
1142: fnd_file.put_line(fnd_file.log, ' pp_phone_format-');
1143:
1144: END pp_phone_format;
1145:
1146: -- Bug 4925023 : call HZ_DQM_SYNC once with new spec

Line 1193: fnd_file.put_line(fnd_file.log, ' pp_dqm_sync+');

1189: c_contacts RefCurType;
1190:
1191: BEGIN
1192:
1193: fnd_file.put_line(fnd_file.log, ' pp_dqm_sync+');
1194:
1195: -- Only contacts imported from hz_imp_org_contacts_int are sync'ed.
1196: -- Contacts loaded through relationship loading do not contain any
1197: -- meaningful attributes (only primary key, foreign keys, OSR, and

Line 1212: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_dqm_sync = ' || l_record_id.COUNT);

1208: FETCH c_contacts BULK COLLECT INTO
1209: l_party_id, l_record_id, l_entity, l_operation, l_party_type;
1210: CLOSE c_contacts;
1211:
1212: fnd_file.put_line(fnd_file.log, ' # of records to process in pp_dqm_sync = ' || l_record_id.COUNT);
1213:
1214: IF l_record_id.COUNT = 0 THEN
1215: RETURN;
1216: END IF;

Line 1218: fnd_file.put_line(fnd_file.log, ' sync CONTACTS');

1214: IF l_record_id.COUNT = 0 THEN
1215: RETURN;
1216: END IF;
1217:
1218: fnd_file.put_line(fnd_file.log, ' sync CONTACTS');
1219:
1220: HZ_DQM_SYNC.sync_work_unit_imp(l_party_id, l_record_id, l_entity, l_operation, l_party_type,
1221: l_return_status, l_msg_count, l_msg_data);
1222:

Line 1223: fnd_file.put_line(fnd_file.log, ' pp_dqm_sync-');

1219:
1220: HZ_DQM_SYNC.sync_work_unit_imp(l_party_id, l_record_id, l_entity, l_operation, l_party_type,
1221: l_return_status, l_msg_count, l_msg_data);
1222:
1223: fnd_file.put_line(fnd_file.log, ' pp_dqm_sync-');
1224:
1225: END pp_dqm_sync ;
1226: */
1227:

Line 1254: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Post-processing WORKER_PROCESS+');

1250: l_msg_data VARCHAR2(4000);
1251:
1252: BEGIN
1253:
1254: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Post-processing WORKER_PROCESS+');
1255:
1256: /* Check profile if need to format person name */
1257: l_run_format_person_name_flag := (nvl(fnd_profile.value('HZ_FMT_BKWD_COMPATIBLE'),'Y') = 'N');
1258: l_enable_dqm_sync_flag := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');

Line 1262: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Process records with current request_id');

1258: l_enable_dqm_sync_flag := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
1259: l_g_miss_char := NVL(FND_PROFILE.value('HZ_IMP_G_MISS_CHAR'), '!');
1260:
1261: /* Process records with current request_id */
1262: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Process records with current request_id');
1263: LOOP
1264: P_OS := NULL;
1265:
1266: /* Pick up work units that have NULL postprocess_status */

Line 1269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_OS = ' || P_OS);

1265:
1266: /* Pick up work units that have NULL postprocess_status */
1267: HZ_IMP_LOAD_WRAPPER.RETRIEVE_PP_WORK_UNIT(P_BATCH_ID, NULL, P_OS, P_FROM_OSR, P_TO_OSR);
1268:
1269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_OS = ' || P_OS);
1270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_FROM_OSR = ' || P_FROM_OSR);
1271: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TO_OSR = ' || P_TO_OSR);
1272:
1273: IF (P_OS IS NULL) Then

Line 1270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_FROM_OSR = ' || P_FROM_OSR);

1266: /* Pick up work units that have NULL postprocess_status */
1267: HZ_IMP_LOAD_WRAPPER.RETRIEVE_PP_WORK_UNIT(P_BATCH_ID, NULL, P_OS, P_FROM_OSR, P_TO_OSR);
1268:
1269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_OS = ' || P_OS);
1270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_FROM_OSR = ' || P_FROM_OSR);
1271: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TO_OSR = ' || P_TO_OSR);
1272:
1273: IF (P_OS IS NULL) Then
1274: EXIT;

Line 1271: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TO_OSR = ' || P_TO_OSR);

1267: HZ_IMP_LOAD_WRAPPER.RETRIEVE_PP_WORK_UNIT(P_BATCH_ID, NULL, P_OS, P_FROM_OSR, P_TO_OSR);
1268:
1269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_OS = ' || P_OS);
1270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_FROM_OSR = ' || P_FROM_OSR);
1271: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TO_OSR = ' || P_TO_OSR);
1272:
1273: IF (P_OS IS NULL) Then
1274: EXIT;
1275: END IF;

Line 1278: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_PARTIES entity ');

1274: EXIT;
1275: END IF;
1276:
1277: /* HZ_PARTIES */
1278: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_PARTIES entity ');
1279:
1280: if (l_run_format_person_name_flag) then
1281: fnd_file.put_line(fnd_file.log,' Format Person Name (+) ');
1282: pp_format_person_name(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, NULL);

Line 1281: fnd_file.put_line(fnd_file.log,' Format Person Name (+) ');

1277: /* HZ_PARTIES */
1278: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_PARTIES entity ');
1279:
1280: if (l_run_format_person_name_flag) then
1281: fnd_file.put_line(fnd_file.log,' Format Person Name (+) ');
1282: pp_format_person_name(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, NULL);
1283: fnd_file.put_line(fnd_file.log,' Format Person Name (-) ');
1284: end if;
1285:

Line 1283: fnd_file.put_line(fnd_file.log,' Format Person Name (-) ');

1279:
1280: if (l_run_format_person_name_flag) then
1281: fnd_file.put_line(fnd_file.log,' Format Person Name (+) ');
1282: pp_format_person_name(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, NULL);
1283: fnd_file.put_line(fnd_file.log,' Format Person Name (-) ');
1284: end if;
1285:
1286: IF (P_GENERATE_FUZZY_KEY = 'Y' OR l_enable_dqm_sync_flag <> 'DISABLE') THEN
1287: fnd_file.put_line(fnd_file.log,' Generate Customer Key (+) ');

Line 1287: fnd_file.put_line(fnd_file.log,' Generate Customer Key (+) ');

1283: fnd_file.put_line(fnd_file.log,' Format Person Name (-) ');
1284: end if;
1285:
1286: IF (P_GENERATE_FUZZY_KEY = 'Y' OR l_enable_dqm_sync_flag <> 'DISABLE') THEN
1287: fnd_file.put_line(fnd_file.log,' Generate Customer Key (+) ');
1288: pp_generate_cust_key(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,
1289: P_GENERATE_FUZZY_KEY,l_enable_dqm_sync_flag, NULL);
1290:
1291:

Line 1292: fnd_file.put_line(fnd_file.log,' Generate Customer Key (-) ');

1288: pp_generate_cust_key(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,
1289: P_GENERATE_FUZZY_KEY,l_enable_dqm_sync_flag, NULL);
1290:
1291:
1292: fnd_file.put_line(fnd_file.log,' Generate Customer Key (-) ');
1293: END IF;
1294:
1295: /* HZ_RELATIONSHIPS */
1296: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_RELATIONSHIPS entity ');

Line 1296: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_RELATIONSHIPS entity ');

1292: fnd_file.put_line(fnd_file.log,' Generate Customer Key (-) ');
1293: END IF;
1294:
1295: /* HZ_RELATIONSHIPS */
1296: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_RELATIONSHIPS entity ');
1297: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (+) ');
1298: pp_denorm_rel(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, NULL);
1299: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (-) ');
1300:

Line 1297: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (+) ');

1293: END IF;
1294:
1295: /* HZ_RELATIONSHIPS */
1296: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_RELATIONSHIPS entity ');
1297: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (+) ');
1298: pp_denorm_rel(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, NULL);
1299: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (-) ');
1300:
1301: IF P_OS = 'DNB' THEN

Line 1299: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (-) ');

1295: /* HZ_RELATIONSHIPS */
1296: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_RELATIONSHIPS entity ');
1297: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (+) ');
1298: pp_denorm_rel(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, NULL);
1299: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (-) ');
1300:
1301: IF P_OS = 'DNB' THEN
1302: fnd_file.put_line(fnd_file.log,' DNB Hierarchy (+) ');
1303: pp_dnb_hierarchy(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR);

Line 1302: fnd_file.put_line(fnd_file.log,' DNB Hierarchy (+) ');

1298: pp_denorm_rel(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, NULL);
1299: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (-) ');
1300:
1301: IF P_OS = 'DNB' THEN
1302: fnd_file.put_line(fnd_file.log,' DNB Hierarchy (+) ');
1303: pp_dnb_hierarchy(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR);
1304: fnd_file.put_line(fnd_file.log,' DNB Hierarchy (-) ');
1305: END IF;
1306:

Line 1304: fnd_file.put_line(fnd_file.log,' DNB Hierarchy (-) ');

1300:
1301: IF P_OS = 'DNB' THEN
1302: fnd_file.put_line(fnd_file.log,' DNB Hierarchy (+) ');
1303: pp_dnb_hierarchy(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR);
1304: fnd_file.put_line(fnd_file.log,' DNB Hierarchy (-) ');
1305: END IF;
1306:
1307: /* HZ_CONTACT_POINTS */
1308: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_CONTACT_POINTS entity ');

Line 1308: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_CONTACT_POINTS entity ');

1304: fnd_file.put_line(fnd_file.log,' DNB Hierarchy (-) ');
1305: END IF;
1306:
1307: /* HZ_CONTACT_POINTS */
1308: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_CONTACT_POINTS entity ');
1309: fnd_file.put_line(fnd_file.log,' Phone Format (+) ');
1310: pp_phone_format(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,
1311: l_enable_dqm_sync_flag, NULL);
1312: fnd_file.put_line(fnd_file.log,' Phone Format (-) ');

Line 1309: fnd_file.put_line(fnd_file.log,' Phone Format (+) ');

1305: END IF;
1306:
1307: /* HZ_CONTACT_POINTS */
1308: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_CONTACT_POINTS entity ');
1309: fnd_file.put_line(fnd_file.log,' Phone Format (+) ');
1310: pp_phone_format(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,
1311: l_enable_dqm_sync_flag, NULL);
1312: fnd_file.put_line(fnd_file.log,' Phone Format (-) ');
1313:

Line 1312: fnd_file.put_line(fnd_file.log,' Phone Format (-) ');

1308: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_CONTACT_POINTS entity ');
1309: fnd_file.put_line(fnd_file.log,' Phone Format (+) ');
1310: pp_phone_format(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,
1311: l_enable_dqm_sync_flag, NULL);
1312: fnd_file.put_line(fnd_file.log,' Phone Format (-) ');
1313:
1314: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (+) ');
1315: pp_generate_cp_timezone(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,l_g_miss_char, NULL);
1316: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (-) ');

Line 1314: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (+) ');

1310: pp_phone_format(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,
1311: l_enable_dqm_sync_flag, NULL);
1312: fnd_file.put_line(fnd_file.log,' Phone Format (-) ');
1313:
1314: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (+) ');
1315: pp_generate_cp_timezone(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,l_g_miss_char, NULL);
1316: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (-) ');
1317:
1318: /* HZ_LOCATIONS */

Line 1316: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (-) ');

1312: fnd_file.put_line(fnd_file.log,' Phone Format (-) ');
1313:
1314: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (+) ');
1315: pp_generate_cp_timezone(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,l_g_miss_char, NULL);
1316: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (-) ');
1317:
1318: /* HZ_LOCATIONS */
1319: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_LOCATIONS entity ');
1320:

Line 1319: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_LOCATIONS entity ');

1315: pp_generate_cp_timezone(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,l_g_miss_char, NULL);
1316: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (-) ');
1317:
1318: /* HZ_LOCATIONS */
1319: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_LOCATIONS entity ');
1320:
1321: IF (P_GENERATE_FUZZY_KEY = 'Y' OR l_enable_dqm_sync_flag <> 'DISABLE') THEN
1322: fnd_file.put_line(fnd_file.log,' Generate Address Key (+) ');
1323: pp_generate_addr_key(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,

Line 1322: fnd_file.put_line(fnd_file.log,' Generate Address Key (+) ');

1318: /* HZ_LOCATIONS */
1319: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_LOCATIONS entity ');
1320:
1321: IF (P_GENERATE_FUZZY_KEY = 'Y' OR l_enable_dqm_sync_flag <> 'DISABLE') THEN
1322: fnd_file.put_line(fnd_file.log,' Generate Address Key (+) ');
1323: pp_generate_addr_key(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,
1324: P_GENERATE_FUZZY_KEY,l_enable_dqm_sync_flag, NULL);
1325: fnd_file.put_line(fnd_file.log,' Generate Address Key (-) ');
1326: END IF;

Line 1325: fnd_file.put_line(fnd_file.log,' Generate Address Key (-) ');

1321: IF (P_GENERATE_FUZZY_KEY = 'Y' OR l_enable_dqm_sync_flag <> 'DISABLE') THEN
1322: fnd_file.put_line(fnd_file.log,' Generate Address Key (+) ');
1323: pp_generate_addr_key(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,
1324: P_GENERATE_FUZZY_KEY,l_enable_dqm_sync_flag, NULL);
1325: fnd_file.put_line(fnd_file.log,' Generate Address Key (-) ');
1326: END IF;
1327:
1328: fnd_file.put_line(fnd_file.log,' Generate Loc Assignment (+) ');
1329: pp_generate_loc_assignments(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR);

Line 1328: fnd_file.put_line(fnd_file.log,' Generate Loc Assignment (+) ');

1324: P_GENERATE_FUZZY_KEY,l_enable_dqm_sync_flag, NULL);
1325: fnd_file.put_line(fnd_file.log,' Generate Address Key (-) ');
1326: END IF;
1327:
1328: fnd_file.put_line(fnd_file.log,' Generate Loc Assignment (+) ');
1329: pp_generate_loc_assignments(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR);
1330: fnd_file.put_line(fnd_file.log,' Generate Loc Assignment (-) ');
1331:
1332: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (+) ');

Line 1330: fnd_file.put_line(fnd_file.log,' Generate Loc Assignment (-) ');

1326: END IF;
1327:
1328: fnd_file.put_line(fnd_file.log,' Generate Loc Assignment (+) ');
1329: pp_generate_loc_assignments(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR);
1330: fnd_file.put_line(fnd_file.log,' Generate Loc Assignment (-) ');
1331:
1332: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (+) ');
1333: pp_generate_loc_timezone(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,l_g_miss_char);
1334: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (-) ');

Line 1332: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (+) ');

1328: fnd_file.put_line(fnd_file.log,' Generate Loc Assignment (+) ');
1329: pp_generate_loc_assignments(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR);
1330: fnd_file.put_line(fnd_file.log,' Generate Loc Assignment (-) ');
1331:
1332: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (+) ');
1333: pp_generate_loc_timezone(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,l_g_miss_char);
1334: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (-) ');
1335:
1336: fnd_file.put_line(fnd_file.log,' DQM Sync (+) ');

Line 1334: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (-) ');

1330: fnd_file.put_line(fnd_file.log,' Generate Loc Assignment (-) ');
1331:
1332: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (+) ');
1333: pp_generate_loc_timezone(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,l_g_miss_char);
1334: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (-) ');
1335:
1336: fnd_file.put_line(fnd_file.log,' DQM Sync (+) ');
1337: IF (l_enable_dqm_sync_flag <> 'DISABLE') THEN
1338: fnd_file.put_line(fnd_file.log,' Calling HZ_DQM_SYNC.sync_work_unit_imp.');

Line 1336: fnd_file.put_line(fnd_file.log,' DQM Sync (+) ');

1332: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (+) ');
1333: pp_generate_loc_timezone(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,l_g_miss_char);
1334: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (-) ');
1335:
1336: fnd_file.put_line(fnd_file.log,' DQM Sync (+) ');
1337: IF (l_enable_dqm_sync_flag <> 'DISABLE') THEN
1338: fnd_file.put_line(fnd_file.log,' Calling HZ_DQM_SYNC.sync_work_unit_imp.');
1339: -- Bug 4925023 : call HZ_DQM_SYNC once with new spec
1340: -- pp_dqm_sync(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, NULL);

Line 1338: fnd_file.put_line(fnd_file.log,' Calling HZ_DQM_SYNC.sync_work_unit_imp.');

1334: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (-) ');
1335:
1336: fnd_file.put_line(fnd_file.log,' DQM Sync (+) ');
1337: IF (l_enable_dqm_sync_flag <> 'DISABLE') THEN
1338: fnd_file.put_line(fnd_file.log,' Calling HZ_DQM_SYNC.sync_work_unit_imp.');
1339: -- Bug 4925023 : call HZ_DQM_SYNC once with new spec
1340: -- pp_dqm_sync(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, NULL);
1341: HZ_DQM_SYNC.sync_work_unit_imp(
1342: p_batch_id => P_BATCH_ID,

Line 1353: fnd_file.put_line(fnd_file.log,' HZ_DQM_ENABLE_REALTIME_SYNC not enabled.');

1349: x_msg_data => l_msg_data
1350: );
1351:
1352: ELSE
1353: fnd_file.put_line(fnd_file.log,' HZ_DQM_ENABLE_REALTIME_SYNC not enabled.');
1354: END IF;
1355: fnd_file.put_line(fnd_file.log,' DQM Sync (-) ');
1356:
1357: /* Update status to Complete for the work unit that just finished */

Line 1355: fnd_file.put_line(fnd_file.log,' DQM Sync (-) ');

1351:
1352: ELSE
1353: fnd_file.put_line(fnd_file.log,' HZ_DQM_ENABLE_REALTIME_SYNC not enabled.');
1354: END IF;
1355: fnd_file.put_line(fnd_file.log,' DQM Sync (-) ');
1356:
1357: /* Update status to Complete for the work unit that just finished */
1358: UPDATE HZ_IMP_WORK_UNITS
1359: SET POSTPROCESS_STATUS = 'C'

Line 1369: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Process records with current and all previous request_id');

1365: END LOOP;
1366:
1367:
1368: /* Process work units with current and all previous request_ids */
1369: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Process records with current and all previous request_id');
1370: LOOP
1371: P_OS := NULL;
1372:
1373: /* Pick up work units that have NULL postprocess_status */

Line 1376: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_OS = ' || P_OS);

1372:
1373: /* Pick up work units that have NULL postprocess_status */
1374: HZ_IMP_LOAD_WRAPPER.RETRIEVE_PP_WORK_UNIT(P_BATCH_ID, 'U', P_OS, P_FROM_OSR, P_TO_OSR);
1375:
1376: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_OS = ' || P_OS);
1377: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_FROM_OSR = ' || P_FROM_OSR);
1378: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TO_OSR = ' || P_TO_OSR);
1379:
1380: IF (P_OS IS NULL) Then

Line 1377: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_FROM_OSR = ' || P_FROM_OSR);

1373: /* Pick up work units that have NULL postprocess_status */
1374: HZ_IMP_LOAD_WRAPPER.RETRIEVE_PP_WORK_UNIT(P_BATCH_ID, 'U', P_OS, P_FROM_OSR, P_TO_OSR);
1375:
1376: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_OS = ' || P_OS);
1377: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_FROM_OSR = ' || P_FROM_OSR);
1378: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TO_OSR = ' || P_TO_OSR);
1379:
1380: IF (P_OS IS NULL) Then
1381: EXIT;

Line 1378: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TO_OSR = ' || P_TO_OSR);

1374: HZ_IMP_LOAD_WRAPPER.RETRIEVE_PP_WORK_UNIT(P_BATCH_ID, 'U', P_OS, P_FROM_OSR, P_TO_OSR);
1375:
1376: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_OS = ' || P_OS);
1377: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_FROM_OSR = ' || P_FROM_OSR);
1378: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TO_OSR = ' || P_TO_OSR);
1379:
1380: IF (P_OS IS NULL) Then
1381: EXIT;
1382: END IF;

Line 1385: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_PARTIES entity ');

1381: EXIT;
1382: END IF;
1383:
1384: /* HZ_PARTIES */
1385: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_PARTIES entity ');
1386:
1387: if (l_run_format_person_name_flag) then
1388: fnd_file.put_line(fnd_file.log,' Format Person Name (+) ');
1389: pp_format_person_name(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, 'U');

Line 1388: fnd_file.put_line(fnd_file.log,' Format Person Name (+) ');

1384: /* HZ_PARTIES */
1385: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_PARTIES entity ');
1386:
1387: if (l_run_format_person_name_flag) then
1388: fnd_file.put_line(fnd_file.log,' Format Person Name (+) ');
1389: pp_format_person_name(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, 'U');
1390: fnd_file.put_line(fnd_file.log,' Format Person Name (-) ');
1391: end if;
1392:

Line 1390: fnd_file.put_line(fnd_file.log,' Format Person Name (-) ');

1386:
1387: if (l_run_format_person_name_flag) then
1388: fnd_file.put_line(fnd_file.log,' Format Person Name (+) ');
1389: pp_format_person_name(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, 'U');
1390: fnd_file.put_line(fnd_file.log,' Format Person Name (-) ');
1391: end if;
1392:
1393: IF (P_GENERATE_FUZZY_KEY = 'Y' OR l_enable_dqm_sync_flag <> 'DISABLE') THEN
1394: fnd_file.put_line(fnd_file.log,' Generate Customer Key (+) ');

Line 1394: fnd_file.put_line(fnd_file.log,' Generate Customer Key (+) ');

1390: fnd_file.put_line(fnd_file.log,' Format Person Name (-) ');
1391: end if;
1392:
1393: IF (P_GENERATE_FUZZY_KEY = 'Y' OR l_enable_dqm_sync_flag <> 'DISABLE') THEN
1394: fnd_file.put_line(fnd_file.log,' Generate Customer Key (+) ');
1395: pp_generate_cust_key(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,
1396: P_GENERATE_FUZZY_KEY,l_enable_dqm_sync_flag, 'U');
1397:
1398:

Line 1399: fnd_file.put_line(fnd_file.log,' Generate Customer Key (-) ');

1395: pp_generate_cust_key(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,
1396: P_GENERATE_FUZZY_KEY,l_enable_dqm_sync_flag, 'U');
1397:
1398:
1399: fnd_file.put_line(fnd_file.log,' Generate Customer Key (-) ');
1400: END IF;
1401:
1402: /* HZ_RELATIONSHIPS */
1403: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_RELATIONSHIPS entity ');

Line 1403: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_RELATIONSHIPS entity ');

1399: fnd_file.put_line(fnd_file.log,' Generate Customer Key (-) ');
1400: END IF;
1401:
1402: /* HZ_RELATIONSHIPS */
1403: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_RELATIONSHIPS entity ');
1404: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (+) ');
1405: pp_denorm_rel(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, 'U');
1406: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (-) ');
1407:

Line 1404: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (+) ');

1400: END IF;
1401:
1402: /* HZ_RELATIONSHIPS */
1403: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_RELATIONSHIPS entity ');
1404: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (+) ');
1405: pp_denorm_rel(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, 'U');
1406: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (-) ');
1407:
1408: IF P_OS = 'DNB' THEN

Line 1406: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (-) ');

1402: /* HZ_RELATIONSHIPS */
1403: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_RELATIONSHIPS entity ');
1404: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (+) ');
1405: pp_denorm_rel(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, 'U');
1406: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (-) ');
1407:
1408: IF P_OS = 'DNB' THEN
1409: fnd_file.put_line(fnd_file.log,' DNB Hierarchy (+) ');
1410: pp_dnb_hierarchy(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR);

Line 1409: fnd_file.put_line(fnd_file.log,' DNB Hierarchy (+) ');

1405: pp_denorm_rel(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, 'U');
1406: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (-) ');
1407:
1408: IF P_OS = 'DNB' THEN
1409: fnd_file.put_line(fnd_file.log,' DNB Hierarchy (+) ');
1410: pp_dnb_hierarchy(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR);
1411: fnd_file.put_line(fnd_file.log,' DNB Hierarchy (-) ');
1412: END IF;
1413:

Line 1411: fnd_file.put_line(fnd_file.log,' DNB Hierarchy (-) ');

1407:
1408: IF P_OS = 'DNB' THEN
1409: fnd_file.put_line(fnd_file.log,' DNB Hierarchy (+) ');
1410: pp_dnb_hierarchy(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR);
1411: fnd_file.put_line(fnd_file.log,' DNB Hierarchy (-) ');
1412: END IF;
1413:
1414: /* HZ_CONTACT_POINTS */
1415: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_CONTACT_POINTS entity ');

Line 1415: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_CONTACT_POINTS entity ');

1411: fnd_file.put_line(fnd_file.log,' DNB Hierarchy (-) ');
1412: END IF;
1413:
1414: /* HZ_CONTACT_POINTS */
1415: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_CONTACT_POINTS entity ');
1416: fnd_file.put_line(fnd_file.log,' Phone Format (+) ');
1417: pp_phone_format(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,
1418: l_enable_dqm_sync_flag, 'U');
1419: fnd_file.put_line(fnd_file.log,' Phone Format (-) ');

Line 1416: fnd_file.put_line(fnd_file.log,' Phone Format (+) ');

1412: END IF;
1413:
1414: /* HZ_CONTACT_POINTS */
1415: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_CONTACT_POINTS entity ');
1416: fnd_file.put_line(fnd_file.log,' Phone Format (+) ');
1417: pp_phone_format(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,
1418: l_enable_dqm_sync_flag, 'U');
1419: fnd_file.put_line(fnd_file.log,' Phone Format (-) ');
1420:

Line 1419: fnd_file.put_line(fnd_file.log,' Phone Format (-) ');

1415: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_CONTACT_POINTS entity ');
1416: fnd_file.put_line(fnd_file.log,' Phone Format (+) ');
1417: pp_phone_format(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,
1418: l_enable_dqm_sync_flag, 'U');
1419: fnd_file.put_line(fnd_file.log,' Phone Format (-) ');
1420:
1421: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (+) ');
1422: pp_generate_cp_timezone(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,l_g_miss_char, 'U');
1423: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (-) ');

Line 1421: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (+) ');

1417: pp_phone_format(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,
1418: l_enable_dqm_sync_flag, 'U');
1419: fnd_file.put_line(fnd_file.log,' Phone Format (-) ');
1420:
1421: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (+) ');
1422: pp_generate_cp_timezone(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,l_g_miss_char, 'U');
1423: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (-) ');
1424:
1425: /* HZ_LOCATIONS */

Line 1423: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (-) ');

1419: fnd_file.put_line(fnd_file.log,' Phone Format (-) ');
1420:
1421: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (+) ');
1422: pp_generate_cp_timezone(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,l_g_miss_char, 'U');
1423: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (-) ');
1424:
1425: /* HZ_LOCATIONS */
1426: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_LOCATIONS entity ');
1427:

Line 1426: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_LOCATIONS entity ');

1422: pp_generate_cp_timezone(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,l_g_miss_char, 'U');
1423: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (-) ');
1424:
1425: /* HZ_LOCATIONS */
1426: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_LOCATIONS entity ');
1427:
1428: IF (P_GENERATE_FUZZY_KEY = 'Y' OR l_enable_dqm_sync_flag <> 'DISABLE') THEN
1429: fnd_file.put_line(fnd_file.log,' Generate Address Key (+) ');
1430: pp_generate_addr_key(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,

Line 1429: fnd_file.put_line(fnd_file.log,' Generate Address Key (+) ');

1425: /* HZ_LOCATIONS */
1426: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_LOCATIONS entity ');
1427:
1428: IF (P_GENERATE_FUZZY_KEY = 'Y' OR l_enable_dqm_sync_flag <> 'DISABLE') THEN
1429: fnd_file.put_line(fnd_file.log,' Generate Address Key (+) ');
1430: pp_generate_addr_key(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,
1431: P_GENERATE_FUZZY_KEY,l_enable_dqm_sync_flag, 'U');
1432: fnd_file.put_line(fnd_file.log,' Generate Address Key (-) ');
1433: END IF;

Line 1432: fnd_file.put_line(fnd_file.log,' Generate Address Key (-) ');

1428: IF (P_GENERATE_FUZZY_KEY = 'Y' OR l_enable_dqm_sync_flag <> 'DISABLE') THEN
1429: fnd_file.put_line(fnd_file.log,' Generate Address Key (+) ');
1430: pp_generate_addr_key(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,
1431: P_GENERATE_FUZZY_KEY,l_enable_dqm_sync_flag, 'U');
1432: fnd_file.put_line(fnd_file.log,' Generate Address Key (-) ');
1433: END IF;
1434:
1435: fnd_file.put_line(fnd_file.log,' Generate Loc Assignment (+) ');
1436: pp_generate_loc_assignments(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR);

Line 1435: fnd_file.put_line(fnd_file.log,' Generate Loc Assignment (+) ');

1431: P_GENERATE_FUZZY_KEY,l_enable_dqm_sync_flag, 'U');
1432: fnd_file.put_line(fnd_file.log,' Generate Address Key (-) ');
1433: END IF;
1434:
1435: fnd_file.put_line(fnd_file.log,' Generate Loc Assignment (+) ');
1436: pp_generate_loc_assignments(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR);
1437: fnd_file.put_line(fnd_file.log,' Generate Loc Assignment (-) ');
1438:
1439: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (+) ');

Line 1437: fnd_file.put_line(fnd_file.log,' Generate Loc Assignment (-) ');

1433: END IF;
1434:
1435: fnd_file.put_line(fnd_file.log,' Generate Loc Assignment (+) ');
1436: pp_generate_loc_assignments(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR);
1437: fnd_file.put_line(fnd_file.log,' Generate Loc Assignment (-) ');
1438:
1439: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (+) ');
1440: pp_generate_loc_timezone(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,l_g_miss_char);
1441: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (-) ');

Line 1439: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (+) ');

1435: fnd_file.put_line(fnd_file.log,' Generate Loc Assignment (+) ');
1436: pp_generate_loc_assignments(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR);
1437: fnd_file.put_line(fnd_file.log,' Generate Loc Assignment (-) ');
1438:
1439: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (+) ');
1440: pp_generate_loc_timezone(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,l_g_miss_char);
1441: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (-) ');
1442:
1443: fnd_file.put_line(fnd_file.log,' DQM Sync (+) ');

Line 1441: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (-) ');

1437: fnd_file.put_line(fnd_file.log,' Generate Loc Assignment (-) ');
1438:
1439: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (+) ');
1440: pp_generate_loc_timezone(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,l_g_miss_char);
1441: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (-) ');
1442:
1443: fnd_file.put_line(fnd_file.log,' DQM Sync (+) ');
1444: IF (l_enable_dqm_sync_flag <> 'DISABLE') THEN
1445: fnd_file.put_line(fnd_file.log,' Calling pp_dqm_sync.');

Line 1443: fnd_file.put_line(fnd_file.log,' DQM Sync (+) ');

1439: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (+) ');
1440: pp_generate_loc_timezone(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,l_g_miss_char);
1441: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (-) ');
1442:
1443: fnd_file.put_line(fnd_file.log,' DQM Sync (+) ');
1444: IF (l_enable_dqm_sync_flag <> 'DISABLE') THEN
1445: fnd_file.put_line(fnd_file.log,' Calling pp_dqm_sync.');
1446: -- Bug 4925023 : call HZ_DQM_SYNC once with new spec
1447: -- pp_dqm_sync(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, 'U');

Line 1445: fnd_file.put_line(fnd_file.log,' Calling pp_dqm_sync.');

1441: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (-) ');
1442:
1443: fnd_file.put_line(fnd_file.log,' DQM Sync (+) ');
1444: IF (l_enable_dqm_sync_flag <> 'DISABLE') THEN
1445: fnd_file.put_line(fnd_file.log,' Calling pp_dqm_sync.');
1446: -- Bug 4925023 : call HZ_DQM_SYNC once with new spec
1447: -- pp_dqm_sync(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, 'U');
1448: HZ_DQM_SYNC.sync_work_unit_imp(
1449: p_batch_id => P_BATCH_ID,

Line 1460: fnd_file.put_line(fnd_file.log,' HZ_DQM_ENABLE_REALTIME_SYNC not enabled.');

1456: x_msg_data => l_msg_data
1457: );
1458:
1459: ELSE
1460: fnd_file.put_line(fnd_file.log,' HZ_DQM_ENABLE_REALTIME_SYNC not enabled.');
1461: END IF;
1462: fnd_file.put_line(fnd_file.log,' DQM Sync (-) ');
1463:
1464: /* Update status to Complete for the work unit that just finished */

Line 1462: fnd_file.put_line(fnd_file.log,' DQM Sync (-) ');

1458:
1459: ELSE
1460: fnd_file.put_line(fnd_file.log,' HZ_DQM_ENABLE_REALTIME_SYNC not enabled.');
1461: END IF;
1462: fnd_file.put_line(fnd_file.log,' DQM Sync (-) ');
1463:
1464: /* Update status to Complete for the work unit that just finished */
1465: UPDATE HZ_IMP_WORK_UNITS
1466: SET POSTPROCESS_STATUS = 'C'

Line 1474: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Post-processing WORKER_PROCESS-');

1470: COMMIT;
1471:
1472: END LOOP;
1473:
1474: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Post-processing WORKER_PROCESS-');
1475:
1476: RETURN;
1477:
1478: EXCEPTION

Line 1500: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in Post-processing worker: ' || SQLERRM);

1496: WHERE batch_id = P_BATCH_ID);
1497:
1498: COMMIT;
1499:
1500: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in Post-processing worker: ' || SQLERRM);
1501:
1502: END WORKER_PROCESS;
1503:
1504: END HZ_IMP_LOAD_POST_PROCESS_PKG;