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

Line 80: fnd_file.put_line(FND_FILE.LOG, g_msg);

76:
77: -- Get the attributes of the detail record - element name, input values
78:
79: g_msg := 'Inside Method get_attribute_id' ;
80: fnd_file.put_line(FND_FILE.LOG, g_msg);
81: -- dbms_output.put_line(g_msg);
82:
83: l_att_index := NVL( p_last_att_index, p_att_table.FIRST);
84: l_bld_blk_id := p_att_table(l_att_index).bb_id;

Line 87: fnd_file.put_line(FND_FILE.LOG, g_msg);

83: l_att_index := NVL( p_last_att_index, p_att_table.FIRST);
84: l_bld_blk_id := p_att_table(l_att_index).bb_id;
85:
86: g_msg := 'Building Block Id : ' || l_bld_blk_id || ' Attribute Index : ' || l_att_index ;
87: fnd_file.put_line(FND_FILE.LOG, g_msg);
88: -- dbms_output.put_line(g_msg);
89:
90: -- sanity check to make sure we are in sync
91:

Line 116: fnd_file.put_line(FND_FILE.LOG, g_msg);

112: IF ( l_bld_blk_id <> p_att_table(att).bb_id ) THEN
113: p_last_att_index := att;
114:
115: g_msg := 'Last Attribute of Building Block Id :' || l_bld_blk_id || ' is ' || p_last_att_index ;
116: fnd_file.put_line(FND_FILE.LOG, g_msg);
117: -- dbms_output.put_line(g_msg);
118: EXIT;
119: END IF;
120:

Line 128: fnd_file.put_line(FND_FILE.LOG, g_msg);

124: l_found_workorder :=TRUE;
125: l_work_order_id:= to_number (p_att_table(att).value);
126:
127: g_msg := 'Work Order is : ' || l_work_order_id;
128: fnd_file.put_line(FND_FILE.LOG, g_msg);
129: -- dbms_output.put_line(g_msg);
130:
131: -- Check for Operation
132:

Line 138: fnd_file.put_line(FND_FILE.LOG, g_msg);

134: l_found_operation :=TRUE;
135: l_operation_id:= to_number (p_att_table(att).value);
136:
137: g_msg := 'Operation is : ' || l_operation_id;
138: fnd_file.put_line(FND_FILE.LOG, g_msg);
139: -- dbms_output.put_line(g_msg);
140:
141: -- Check for Resource
142:

Line 148: fnd_file.put_line(FND_FILE.LOG, g_msg);

144: l_found_resource :=TRUE;
145: l_resource_id:= to_number (p_att_table(att).value);
146:
147: g_msg := 'Resource is : ' || l_resource_id;
148: fnd_file.put_line(FND_FILE.LOG, g_msg);
149: -- dbms_output.put_line(g_msg);
150:
151:
152: -- Check for Charge Department

Line 159: fnd_file.put_line(FND_FILE.LOG, g_msg);

155: l_found_charge_department :=TRUE;
156: l_charge_department_id:= to_number (p_att_table(att).value);
157:
158: g_msg := 'Charge Department is : ' || l_charge_department_id;
159: fnd_file.put_line(FND_FILE.LOG, g_msg);
160: -- dbms_output.put_line(g_msg);
161:
162: -- Check for Asset Group Id
163:

Line 169: fnd_file.put_line(FND_FILE.LOG, g_msg);

165: l_found_asset_group_id :=TRUE;
166: l_asset_group_id:= to_number (p_att_table(att).value);
167:
168: g_msg := 'Asset Group Id is : ' || l_asset_group_id;
169: fnd_file.put_line(FND_FILE.LOG, g_msg);
170: -- dbms_output.put_line(g_msg);
171:
172: -- Check for Owning Department Id
173:

Line 179: fnd_file.put_line(FND_FILE.LOG, g_msg);

175: l_found_owning_department :=TRUE;
176: l_owning_department_id:= to_number (p_att_table(att).value);
177:
178: g_msg := 'Owning Department Id is : ' || l_owning_department_id;
179: fnd_file.put_line(FND_FILE.LOG, g_msg);
180: -- dbms_output.put_line(g_msg);
181:
182: -- Check for Asset Number
183:

Line 189: fnd_file.put_line(FND_FILE.LOG, g_msg);

185: l_found_asset_number :=TRUE;
186: l_asset_number_id:= p_att_table(att).value;
187:
188: g_msg := 'Asset Number is : ' || l_asset_number_id;
189: fnd_file.put_line(FND_FILE.LOG, g_msg);
190: -- dbms_output.put_line(g_msg);
191:
192: end if;
193:

Line 200: fnd_file.put_line(FND_FILE.LOG, g_msg);

196: ELSE
197: --
198: g_status := 'ERRORS';
199: g_msg := 'No Attributes Found ';
200: fnd_file.put_line(FND_FILE.LOG, g_msg);
201: -- dbms_output.put_line(g_msg);
202: g_exception_description := g_msg;
203: raise no_attributes_found;
204:

Line 236: fnd_file.put_line(FND_FILE.LOG, g_msg);

232:
233: WHEN no_workorder_found then
234:
235: g_msg := 'Work Order not found';
236: fnd_file.put_line(FND_FILE.LOG, g_msg);
237: -- dbms_output.put_line(g_msg);
238: g_exception_description := g_msg;
239:
240: WHEN no_operation_found then

Line 243: fnd_file.put_line(FND_FILE.LOG, g_msg);

239:
240: WHEN no_operation_found then
241:
242: g_msg := 'Operation not found';
243: fnd_file.put_line(FND_FILE.LOG, g_msg);
244: -- dbms_output.put_line(g_msg);
245: g_exception_description := g_msg;
246:
247: WHEN no_resource_found then

Line 250: fnd_file.put_line(FND_FILE.LOG, g_msg);

246:
247: WHEN no_resource_found then
248:
249: g_msg := 'Resource not found';
250: fnd_file.put_line(FND_FILE.LOG, g_msg);
251: -- dbms_output.put_line(g_msg);
252: g_exception_description := g_msg;
253:
254: WHEN bld_block_mismatch then

Line 257: fnd_file.put_line(FND_FILE.LOG, g_msg);

253:
254: WHEN bld_block_mismatch then
255:
256: g_msg := 'Mismatch of Building Block Id' ;
257: fnd_file.put_line(FND_FILE.LOG, g_msg);
258: -- dbms_output.put_line(g_msg);
259:
260: WHEN others then
261:

Line 263: fnd_file.put_line(FND_FILE.LOG, g_msg);

259:
260: WHEN others then
261:
262: g_msg := 'UNEXPECTED ERROR: ' || SQLERRM;
263: fnd_file.put_line(FND_FILE.LOG, g_msg);
264: -- dbms_output.put_line(g_msg);
265:
266:
267: END get_attribute_id;

Line 356: fnd_file.put_line(FND_FILE.LOG, g_msg);

352: l_measure := p_transaction_qty;
353: l_start_time := p_start_time;
354:
355: g_msg := 'Start of perform_res_txn' ;
356: fnd_file.put_line(FND_FILE.LOG, g_msg);
357: -- dbms_output.put_line(g_msg);
358:
359: g_msg := 'Work Order is : ' || l_workorder || ' and Operation is : ' || l_operation || ' and Resource is : ' || l_resource || ' and Employee is :' || p_instance_id;
360: fnd_file.put_line(FND_FILE.LOG, g_msg);

Line 360: fnd_file.put_line(FND_FILE.LOG, g_msg);

356: fnd_file.put_line(FND_FILE.LOG, g_msg);
357: -- dbms_output.put_line(g_msg);
358:
359: g_msg := 'Work Order is : ' || l_workorder || ' and Operation is : ' || l_operation || ' and Resource is : ' || l_resource || ' and Employee is :' || p_instance_id;
360: fnd_file.put_line(FND_FILE.LOG, g_msg);
361: -- dbms_output.put_line(g_msg);
362:
363:
364: -- Get Resource Sequence Number

Line 387: fnd_file.put_line(FND_FILE.LOG, g_msg);

383:
384: end;
385:
386: g_msg := 'Resource Sequence Number is : ' || l_resource_seq_num;
387: fnd_file.put_line(FND_FILE.LOG, g_msg);
388: -- dbms_output.put_line(g_msg);
389:
390:
391:

Line 419: fnd_file.put_line(FND_FILE.LOG, g_msg);

415:
416: end;
417:
418: g_msg := 'Employee Name is : ' || l_employee_name;
419: fnd_file.put_line(FND_FILE.LOG, g_msg);
420: -- dbms_output.put_line(g_msg);
421:
422: -- Get Organization Id
423:

Line 444: fnd_file.put_line(FND_FILE.LOG, g_msg);

440:
441: end;
442:
443: g_msg := 'Organization Id is : ' || l_organization_id;
444: fnd_file.put_line(FND_FILE.LOG, g_msg);
445: -- dbms_output.put_line(g_msg);
446:
447: -- Get Resource Code
448:

Line 470: fnd_file.put_line(FND_FILE.LOG, g_msg);

466:
467: end;
468:
469: g_msg := 'Resource Code is : ' || l_resource_code;
470: fnd_file.put_line(FND_FILE.LOG, g_msg);
471: -- dbms_output.put_line(g_msg);
472:
473:
474: -- Get Charge Department

Line 497: fnd_file.put_line(FND_FILE.LOG, g_msg);

493:
494: end;
495:
496: g_msg := 'Charge Department is : ' || l_charge_department_code;
497: fnd_file.put_line(FND_FILE.LOG, g_msg);
498: -- dbms_output.put_line(g_msg);
499:
500: g_msg := 'Start of Resource Validation in WIP_EAM_RESOURCE_TRANSACTION.resource_validate';
501: fnd_file.put_line(FND_FILE.LOG, g_msg);

Line 501: fnd_file.put_line(FND_FILE.LOG, g_msg);

497: fnd_file.put_line(FND_FILE.LOG, g_msg);
498: -- dbms_output.put_line(g_msg);
499:
500: g_msg := 'Start of Resource Validation in WIP_EAM_RESOURCE_TRANSACTION.resource_validate';
501: fnd_file.put_line(FND_FILE.LOG, g_msg);
502: -- dbms_output.put_line(g_msg);
503:
504: if (l_workorder is not null) then
505:

Line 646: fnd_file.put_line(FND_FILE.LOG, g_msg);

642:
643: -- set the transaction status for the block we have processed
644:
645: g_msg := 'Insert into WCTI - SUCCESS';
646: fnd_file.put_line(FND_FILE.LOG, g_msg);
647: -- dbms_output.put_line(g_msg);
648:
649: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_bb_id) := 'SUCCESS';
650: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_bb_id) := 'Resource Transaction Processed Successfully';

Line 655: fnd_file.put_line(FND_FILE.LOG, g_msg);

651:
652: else
653:
654: g_msg := 'Insert into WCTI failed';
655: fnd_file.put_line(FND_FILE.LOG, g_msg);
656: -- dbms_output.put_line(g_msg);
657:
658: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_bb_id) := 'ERRORS';
659: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_bb_id) := 'Resource Transaction Failed';

Line 666: fnd_file.put_line(FND_FILE.LOG, g_msg);

662:
663: else
664:
665: g_msg := 'Work order details no found - skip resource insertion';
666: fnd_file.put_line(FND_FILE.LOG, g_msg);
667:
668: end if;
669:
670: EXCEPTION

Line 677: fnd_file.put_line(FND_FILE.LOG, g_msg);

673:
674: fnd_message.set_name('EAM', 'EAM_WO_INVALID_RES_SELECTED');
675: g_exception_description := SUBSTR(fnd_message.get,1,2000);
676: g_msg := g_exception_description;
677: fnd_file.put_line(FND_FILE.LOG, g_msg);
678: -- dbms_output.put_line(g_msg);
679:
680:
681: WHEN invalid_uom THEN

Line 686: fnd_file.put_line(FND_FILE.LOG, g_msg);

682:
683: fnd_message.set_name('EAM', 'EAM_WO_INVALID_UOM_ENTRY');
684: g_exception_description := SUBSTR(fnd_message.get,1,2000);
685: g_msg := g_exception_description;
686: fnd_file.put_line(FND_FILE.LOG, g_msg);
687: -- dbms_output.put_line(g_msg);
688:
689: WHEN invalid_employee THEN
690:

Line 694: fnd_file.put_line(FND_FILE.LOG, g_msg);

690:
691: fnd_message.set_name('EAM', 'EAM_WO_INVALID_EMPLOYEE_ENTRY');
692: g_exception_description := SUBSTR(fnd_message.get,1,2000);
693: g_msg := g_exception_description;
694: fnd_file.put_line(FND_FILE.LOG, g_msg);
695: -- dbms_output.put_line(g_msg);
696:
697: WHEN invalid_equipment THEN
698:

Line 702: fnd_file.put_line(FND_FILE.LOG, g_msg);

698:
699: fnd_message.set_name('EAM', 'EAM_WO_INVALID_EQUIPMENT_ENTRY');
700: g_exception_description := SUBSTR(fnd_message.get,1,2000);
701: g_msg := g_exception_description;
702: fnd_file.put_line(FND_FILE.LOG, g_msg);
703: -- dbms_output.put_line(g_msg);
704:
705: WHEN invalid_charge_department THEN
706:

Line 710: fnd_file.put_line(FND_FILE.LOG, g_msg);

706:
707: fnd_message.set_name('EAM', 'EAM_WO_INVALID_CHARGE_DEPT_ENT');
708: g_exception_description := SUBSTR(fnd_message.get,1,2000);
709: g_msg := g_exception_description;
710: fnd_file.put_line(FND_FILE.LOG, g_msg);
711: -- dbms_output.put_line(g_msg);
712:
713: WHEN invalid_machine THEN
714:

Line 718: fnd_file.put_line(FND_FILE.LOG, g_msg);

714:
715: fnd_message.set_name('EAM', 'EAM_WO_RES_NOT_A_MACHINE');
716: g_exception_description := SUBSTR(fnd_message.get,1,2000);
717: g_msg := g_exception_description;
718: fnd_file.put_line(FND_FILE.LOG, g_msg);
719: -- dbms_output.put_line(g_msg);
720:
721: WHEN invalid_person THEN
722:

Line 726: fnd_file.put_line(FND_FILE.LOG, g_msg);

722:
723: fnd_message.set_name('EAM', 'EAM_WO_RES_NOT_AN_EMPLOYEE');
724: g_exception_description := SUBSTR(fnd_message.get,1,2000);
725: g_msg := g_exception_description;
726: fnd_file.put_line(FND_FILE.LOG, g_msg);
727: -- dbms_output.put_line(g_msg);
728:
729: WHEN operation_res_combination THEN
730:

Line 734: fnd_file.put_line(FND_FILE.LOG, g_msg);

730:
731: fnd_message.set_name('EAM', 'EAM_WO_INVALID_RES_SEQ_COMB');
732: g_exception_description := SUBSTR(fnd_message.get,1,2000);
733: g_msg := g_exception_description;
734: fnd_file.put_line(FND_FILE.LOG, g_msg);
735: -- dbms_output.put_line(g_msg);
736:
737: WHEN invalid_wo THEN
738: fnd_message.set_name('EAM', 'EAM_NO_CHARGES_ALLOWED');

Line 741: fnd_file.put_line(FND_FILE.LOG, g_msg);

737: WHEN invalid_wo THEN
738: fnd_message.set_name('EAM', 'EAM_NO_CHARGES_ALLOWED');
739: g_exception_description := SUBSTR(fnd_message.get,1,2000);
740: g_msg := g_exception_description;
741: fnd_file.put_line(FND_FILE.LOG, g_msg);
742:
743: WHEN others then
744:
745: g_msg := 'UNEXPECTED ERROR: ' || SQLERRM;

Line 746: fnd_file.put_line(FND_FILE.LOG, g_msg);

742:
743: WHEN others then
744:
745: g_msg := 'UNEXPECTED ERROR: ' || SQLERRM;
746: fnd_file.put_line(FND_FILE.LOG, g_msg);
747: -- dbms_output.put_line(g_msg);
748:
749: end;
750:

Line 776: fnd_file.put_line(FND_FILE.LOG, g_msg);

772: BEGIN
773:
774: l_count := 0;
775: g_msg := 'Inside Method where_clause';
776: fnd_file.put_line(FND_FILE.LOG, g_msg);
777: -- dbms_output.put_line(g_msg);
778:
779: g_msg := 'Input Parameters are : Asset Group Id : ' || p_asset_group_id || ' Asset Number : ' || p_asset_number || ' Owning Department : ' || p_owning_department || ' Charge Department : ' || p_charge_department ;
780: fnd_file.put_line(FND_FILE.LOG, g_msg);

Line 780: fnd_file.put_line(FND_FILE.LOG, g_msg);

776: fnd_file.put_line(FND_FILE.LOG, g_msg);
777: -- dbms_output.put_line(g_msg);
778:
779: g_msg := 'Input Parameters are : Asset Group Id : ' || p_asset_group_id || ' Asset Number : ' || p_asset_number || ' Owning Department : ' || p_owning_department || ' Charge Department : ' || p_charge_department ;
780: fnd_file.put_line(FND_FILE.LOG, g_msg);
781: -- dbms_output.put_line(g_msg);
782:
783: g_msg := 'Resource Id : ' || p_resource_id || ' Wip Entity Id : ' || p_wip_entity_id || ' Operation Seq Num: ' || p_operation_seq_num || ' Organization Id : ' || p_organization_id || ' Person Id :' || p_person_id ;
784: fnd_file.put_line(FND_FILE.LOG, g_msg);

Line 784: fnd_file.put_line(FND_FILE.LOG, g_msg);

780: fnd_file.put_line(FND_FILE.LOG, g_msg);
781: -- dbms_output.put_line(g_msg);
782:
783: g_msg := 'Resource Id : ' || p_resource_id || ' Wip Entity Id : ' || p_wip_entity_id || ' Operation Seq Num: ' || p_operation_seq_num || ' Organization Id : ' || p_organization_id || ' Person Id :' || p_person_id ;
784: fnd_file.put_line(FND_FILE.LOG, g_msg);
785: -- dbms_output.put_line(g_msg);
786:
787: l_where_clause := p_where_clause ;
788:

Line 800: fnd_file.put_line(FND_FILE.LOG, g_msg);

796:
797: end if;
798:
799: g_msg := 'where_clause after Inventory Item Id ' || l_where_clause ;
800: fnd_file.put_line(FND_FILE.LOG, g_msg);
801: -- dbms_output.put_line(g_msg);
802:
803: -- Append Asset Number if it is NOT NULL
804:

Line 822: fnd_file.put_line(FND_FILE.LOG, g_msg);

818:
819: end if;
820:
821: g_msg := 'where_clause after Asset Number ' || l_where_clause;
822: fnd_file.put_line(FND_FILE.LOG, g_msg);
823: -- dbms_output.put_line(g_msg);
824:
825: -- Append Owning Department if it is NOT NULL
826:

Line 844: fnd_file.put_line(FND_FILE.LOG, g_msg);

840:
841: end if;
842:
843: g_msg := 'where_clause after Owning Department ' || l_where_clause;
844: fnd_file.put_line(FND_FILE.LOG, g_msg);
845: -- dbms_output.put_line(g_msg);
846:
847: -- Append Resource Id if it is NOT NULL
848:

Line 866: fnd_file.put_line(FND_FILE.LOG, g_msg);

862:
863: end if;
864:
865: g_msg := 'where_clause after Resource Id ' || l_where_clause;
866: fnd_file.put_line(FND_FILE.LOG, g_msg);
867: -- dbms_output.put_line(g_msg);
868:
869: -- Append Wip Entity Id if it is NOT NULL
870:

Line 888: fnd_file.put_line(FND_FILE.LOG, g_msg);

884:
885: end if;
886:
887: g_msg := 'where_clause after Wip Entity Id ' || l_where_clause;
888: fnd_file.put_line(FND_FILE.LOG, g_msg);
889: -- dbms_output.put_line(g_msg);
890:
891: -- Append Operation if it is NOT NULL
892:

Line 910: fnd_file.put_line(FND_FILE.LOG, g_msg);

906:
907: end if;
908:
909: g_msg := 'where_clause after Operation ' || l_where_clause;
910: fnd_file.put_line(FND_FILE.LOG, g_msg);
911: -- dbms_output.put_line(g_msg);
912:
913: -- Append Organization Id if it is NOT NULL
914:

Line 932: fnd_file.put_line(FND_FILE.LOG, g_msg);

928:
929: end if;
930:
931: g_msg := 'where_clause after Organization Id ' || l_where_clause;
932: fnd_file.put_line(FND_FILE.LOG, g_msg);
933: -- dbms_output.put_line(g_msg);
934:
935: -- Append Charge Department if it is NOT NULL
936:

Line 954: fnd_file.put_line(FND_FILE.LOG, g_msg);

950:
951: end if;
952:
953: g_msg := 'where_clause after Charge Department ' || l_where_clause;
954: fnd_file.put_line(FND_FILE.LOG, g_msg);
955: -- dbms_output.put_line(g_msg);
956:
957: -- Append Project Id if it is NOT NULL
958:

Line 976: fnd_file.put_line(FND_FILE.LOG, g_msg);

972:
973: end if;
974:
975: g_msg := 'where_clause after Project Id ' || l_where_clause; */
976: fnd_file.put_line(FND_FILE.LOG, g_msg);
977: -- dbms_output.put_line(g_msg);
978:
979: -- Append Task Id if it is NOT NULL
980:

Line 998: fnd_file.put_line(FND_FILE.LOG, g_msg);

994:
995: end if;*/
996:
997: g_msg := 'where_clause after Task Id ' || l_where_clause;
998: fnd_file.put_line(FND_FILE.LOG, g_msg);
999: -- dbms_output.put_line(g_msg);
1000:
1001:
1002: -- Append Person Id if it is NOT NULL

Line 1021: fnd_file.put_line(FND_FILE.LOG, g_msg);

1017:
1018: end if;
1019:
1020: g_msg := 'Final where_clause ' || l_where_clause;
1021: fnd_file.put_line(FND_FILE.LOG, g_msg);
1022: -- dbms_output.put_line(g_msg);
1023:
1024: return l_where_clause;
1025: END;

Line 1133: fnd_file.put_line(FND_FILE.LOG, g_msg);

1129:
1130: begin
1131:
1132: g_msg := 'Entering retrieve_process method';
1133: fnd_file.put_line(FND_FILE.LOG, g_msg);
1134: -- dbms_output.put_line(g_msg);
1135:
1136: l_stmt_num := 10;
1137: SAVEPOINT retrieve_process_pub;

Line 1153: fnd_file.put_line(FND_FILE.LOG, g_msg);

1149: l_error_code := 9999;
1150: l_error_message := 'Unknown Exception';
1151:
1152: g_msg := '';
1153: fnd_file.put_line(FND_FILE.LOG, g_msg);
1154: -- dbms_output.put_line(g_msg);
1155:
1156: fnd_file.put_line(FND_FILE.LOG, 'Start Retrieval Process. Time now is ' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
1157:

Line 1156: fnd_file.put_line(FND_FILE.LOG, 'Start Retrieval Process. Time now is ' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));

1152: g_msg := '';
1153: fnd_file.put_line(FND_FILE.LOG, g_msg);
1154: -- dbms_output.put_line(g_msg);
1155:
1156: fnd_file.put_line(FND_FILE.LOG, 'Start Retrieval Process. Time now is ' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
1157:
1158: fnd_file.put_line(FND_FILE.LOG, g_msg);
1159:
1160: fnd_file.new_line(FND_FILE.LOG,1);

Line 1158: fnd_file.put_line(FND_FILE.LOG, g_msg);

1154: -- dbms_output.put_line(g_msg);
1155:
1156: fnd_file.put_line(FND_FILE.LOG, 'Start Retrieval Process. Time now is ' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
1157:
1158: fnd_file.put_line(FND_FILE.LOG, g_msg);
1159:
1160: fnd_file.new_line(FND_FILE.LOG,1);
1161:
1162: g_msg := 'Before Building Where Clause in Retrieve Process';

Line 1160: fnd_file.new_line(FND_FILE.LOG,1);

1156: fnd_file.put_line(FND_FILE.LOG, 'Start Retrieval Process. Time now is ' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
1157:
1158: fnd_file.put_line(FND_FILE.LOG, g_msg);
1159:
1160: fnd_file.new_line(FND_FILE.LOG,1);
1161:
1162: g_msg := 'Before Building Where Clause in Retrieve Process';
1163: fnd_file.put_line(FND_FILE.LOG, g_msg);
1164: -- dbms_output.put_line(g_msg);

Line 1163: fnd_file.put_line(FND_FILE.LOG, g_msg);

1159:
1160: fnd_file.new_line(FND_FILE.LOG,1);
1161:
1162: g_msg := 'Before Building Where Clause in Retrieve Process';
1163: fnd_file.put_line(FND_FILE.LOG, g_msg);
1164: -- dbms_output.put_line(g_msg);
1165:
1166: l_where_clause := where_clause (p_asset_group_id,p_asset_number,p_owning_department,p_charge_department,
1167: p_resource_id,p_wip_entity_id,p_operation_seq_num,p_organization_id,p_person_id,l_where_clause);

Line 1170: fnd_file.put_line(FND_FILE.LOG, g_msg);

1166: l_where_clause := where_clause (p_asset_group_id,p_asset_number,p_owning_department,p_charge_department,
1167: p_resource_id,p_wip_entity_id,p_operation_seq_num,p_organization_id,p_person_id,l_where_clause);
1168:
1169: g_msg := 'After Building Where Clause in Retrieve Process, Where Clause is : ' || l_where_clause;
1170: fnd_file.put_line(FND_FILE.LOG, g_msg);
1171:
1172: -- call generic retrieval
1173:
1174:

Line 1192: fnd_file.put_line(FND_FILE.LOG, g_msg);

1188:
1189: -- process results of generic retrieval
1190:
1191: g_msg := 'After HXC_INTEGRATION_LAYER_V1_GRP.execute_retrieval_process ';
1192: fnd_file.put_line(FND_FILE.LOG, g_msg);
1193: -- dbms_output.put_line(g_msg);
1194:
1195: g_msg := 'Start Processing of Building Blocks start now ';
1196: fnd_file.put_line(FND_FILE.LOG, g_msg);

Line 1196: fnd_file.put_line(FND_FILE.LOG, g_msg);

1192: fnd_file.put_line(FND_FILE.LOG, g_msg);
1193: -- dbms_output.put_line(g_msg);
1194:
1195: g_msg := 'Start Processing of Building Blocks start now ';
1196: fnd_file.put_line(FND_FILE.LOG, g_msg);
1197: -- dbms_output.put_line(g_msg);
1198:
1199: -- dbms_output.put_line(HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.COUNT);
1200:

Line 1213: fnd_file.put_line(FND_FILE.LOG, g_msg);

1209:
1210: LOOP
1211:
1212: g_msg := 'Processing Building Blocks : ' || l_cnt;
1213: fnd_file.put_line(FND_FILE.LOG, g_msg);
1214: -- dbms_output.put_line(g_msg);
1215:
1216: g_status := 'SUCCESS';
1217:

Line 1233: fnd_file.put_line(FND_FILE.LOG, g_msg);

1229: l_deleted := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).deleted;
1230:
1231:
1232: g_msg := 'Building Block Id : ' || l_bb_id || 'Measure : ' || l_measure || ' Resource Id : '|| l_resource_id || ' Start Time : ' || l_start_time;
1233: fnd_file.put_line(FND_FILE.LOG, g_msg);
1234: -- dbms_output.put_line(g_msg);
1235:
1236: g_msg := 'Building Block Status : Changed ' || l_changed || ' Deleted : ' || l_deleted;
1237: fnd_file.put_line(FND_FILE.LOG, g_msg);

Line 1237: fnd_file.put_line(FND_FILE.LOG, g_msg);

1233: fnd_file.put_line(FND_FILE.LOG, g_msg);
1234: -- dbms_output.put_line(g_msg);
1235:
1236: g_msg := 'Building Block Status : Changed ' || l_changed || ' Deleted : ' || l_deleted;
1237: fnd_file.put_line(FND_FILE.LOG, g_msg);
1238: -- dbms_output.put_line(g_msg);
1239:
1240:
1241: -- only need to process detail building blocks for performing resource transactions

Line 1259: fnd_file.put_line(FND_FILE.LOG, g_msg);

1255:
1256: if( l_deleted = 'N') and (l_changed = 'N') then
1257:
1258: g_msg := 'Before get_attribute_id - NEW (N,N)-> (Delete,Change)';
1259: fnd_file.put_line(FND_FILE.LOG, g_msg);
1260: -- dbms_output.put_line(g_msg);
1261:
1262:
1263: get_attribute_id (p_att_table => HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes,

Line 1275: fnd_file.put_line(FND_FILE.LOG, g_msg);

1271: x_owning_department => l_owning_department,
1272: x_asset_number => l_asset_number);
1273:
1274: g_msg := 'After get_attribute_id - NEW (N,N)-> (Delete,Change)';
1275: fnd_file.put_line(FND_FILE.LOG, g_msg);
1276: -- dbms_output.put_line(g_msg);
1277:
1278: g_msg := 'l_workorder:' || l_workorder;
1279: fnd_file.put_line(FND_FILE.LOG, g_msg);

Line 1279: fnd_file.put_line(FND_FILE.LOG, g_msg);

1275: fnd_file.put_line(FND_FILE.LOG, g_msg);
1276: -- dbms_output.put_line(g_msg);
1277:
1278: g_msg := 'l_workorder:' || l_workorder;
1279: fnd_file.put_line(FND_FILE.LOG, g_msg);
1280:
1281: perform_res_txn (p_wip_entity_id => l_workorder,
1282: p_operation_seq_num => l_operation,
1283: p_resource_id => l_resource,

Line 1291: fnd_file.put_line(FND_FILE.LOG, g_msg);

1287: p_transaction_qty => l_measure,
1288: p_start_time => l_start_time);
1289:
1290: g_msg := 'After Resource Txn - (N,N)-> (Delete,Change)';
1291: fnd_file.put_line(FND_FILE.LOG, g_msg);
1292: -- dbms_output.put_line(g_msg);
1293:
1294: end if;
1295:

Line 1315: fnd_file.put_line(FND_FILE.LOG, g_msg);

1311:
1312: -- t_temp_attr_index := l_last_att_index;
1313:
1314: g_msg := 'Before get_attribute_id - NEW (Y,Y)-> (Delete,Change)';
1315: fnd_file.put_line(FND_FILE.LOG, g_msg);
1316:
1317: g_msg := 'Update OTL Timecard. Resource Transaction reversed.';
1318: fnd_file.put_line(FND_FILE.LOG, g_msg);
1319: -- dbms_output.put_line(g_msg);

Line 1318: fnd_file.put_line(FND_FILE.LOG, g_msg);

1314: g_msg := 'Before get_attribute_id - NEW (Y,Y)-> (Delete,Change)';
1315: fnd_file.put_line(FND_FILE.LOG, g_msg);
1316:
1317: g_msg := 'Update OTL Timecard. Resource Transaction reversed.';
1318: fnd_file.put_line(FND_FILE.LOG, g_msg);
1319: -- dbms_output.put_line(g_msg);
1320:
1321: get_attribute_id (p_att_table => HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes,
1322: p_bb_id => l_bb_id,

Line 1333: fnd_file.put_line(FND_FILE.LOG, g_msg);

1329: x_owning_department => l_owning_department,
1330: x_asset_number => l_asset_number);
1331:
1332: g_msg := 'After get_attribute_id - NEW (Y,Y)-> (Delete,Change)';
1333: fnd_file.put_line(FND_FILE.LOG, g_msg);
1334: -- dbms_output.put_line(g_msg);
1335:
1336: g_msg := 'Before get_attribute_id - OLD (Y,Y)-> (Delete,Change)';
1337: fnd_file.put_line(FND_FILE.LOG, g_msg);

Line 1337: fnd_file.put_line(FND_FILE.LOG, g_msg);

1333: fnd_file.put_line(FND_FILE.LOG, g_msg);
1334: -- dbms_output.put_line(g_msg);
1335:
1336: g_msg := 'Before get_attribute_id - OLD (Y,Y)-> (Delete,Change)';
1337: fnd_file.put_line(FND_FILE.LOG, g_msg);
1338: -- dbms_output.put_line(g_msg);
1339:
1340:
1341: get_attribute_id (p_att_table => HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes,

Line 1353: fnd_file.put_line(FND_FILE.LOG, g_msg);

1349: x_owning_department => l_old_owning_department,
1350: x_asset_number => l_old_asset_number);
1351:
1352: g_msg := 'After get_attribute_id - OLD (Y,Y)-> (Delete,Change)';
1353: fnd_file.put_line(FND_FILE.LOG, g_msg);
1354: -- dbms_output.put_line(g_msg);
1355:
1356:
1357: -- t_temp_attr_index := l_last_att_index;

Line 1372: fnd_file.put_line(FND_FILE.LOG, g_msg);

1368: p_transaction_qty => -(l_old_measure),
1369: p_start_time => l_old_start_time);
1370:
1371: g_msg := 'After Reversing Resource Txn - (Y,Y)-> (Delete,Change)';
1372: fnd_file.put_line(FND_FILE.LOG, g_msg);
1373: -- dbms_output.put_line(g_msg);
1374:
1375:
1376:

Line 1391: fnd_file.put_line(FND_FILE.LOG, g_msg);

1387:
1388: if( l_deleted = 'Y') and (l_changed = 'N') then
1389:
1390: g_msg := 'Before get_attribute_id - NEW (Y,N)-> (Delete,Change)';
1391: fnd_file.put_line(FND_FILE.LOG, g_msg);
1392: -- dbms_output.put_line(g_msg);
1393:
1394: get_attribute_id (p_att_table => HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes,
1395: p_bb_id => l_bb_id,

Line 1406: fnd_file.put_line(FND_FILE.LOG, g_msg);

1402: x_owning_department => l_owning_department,
1403: x_asset_number => l_asset_number);
1404:
1405: g_msg := 'After get_attribute_id - NEW (Y,N) -> (Delete,Change)';
1406: fnd_file.put_line(FND_FILE.LOG, g_msg);
1407: -- dbms_output.put_line(g_msg);
1408:
1409: end if;
1410:

Line 1428: fnd_file.put_line(FND_FILE.LOG, g_msg);

1424:
1425: -- t_temp_attr_index := l_last_att_index;
1426:
1427: g_msg := 'Before get_attribute_id - NEW (N,Y)-> (Delete,Change)';
1428: fnd_file.put_line(FND_FILE.LOG, g_msg);
1429: -- dbms_output.put_line(g_msg);
1430:
1431: g_msg := 'Updating OTL Timecard';
1432: fnd_file.put_line(FND_FILE.LOG, g_msg);

Line 1432: fnd_file.put_line(FND_FILE.LOG, g_msg);

1428: fnd_file.put_line(FND_FILE.LOG, g_msg);
1429: -- dbms_output.put_line(g_msg);
1430:
1431: g_msg := 'Updating OTL Timecard';
1432: fnd_file.put_line(FND_FILE.LOG, g_msg);
1433:
1434: get_attribute_id (p_att_table => HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes,
1435: p_bb_id => l_bb_id,
1436: p_last_att_index => l_last_att_index,

Line 1446: fnd_file.put_line(FND_FILE.LOG, g_msg);

1442: x_owning_department => l_owning_department,
1443: x_asset_number => l_asset_number);
1444:
1445: g_msg := 'After get_attribute_id - NEW (N,Y) -> (Delete,Change)';
1446: fnd_file.put_line(FND_FILE.LOG, g_msg);
1447: -- dbms_output.put_line(g_msg);
1448:
1449: g_msg := 'Before get_attribute_id - OLD (N,Y)-> (Delete,Change)';
1450: fnd_file.put_line(FND_FILE.LOG, g_msg);

Line 1450: fnd_file.put_line(FND_FILE.LOG, g_msg);

1446: fnd_file.put_line(FND_FILE.LOG, g_msg);
1447: -- dbms_output.put_line(g_msg);
1448:
1449: g_msg := 'Before get_attribute_id - OLD (N,Y)-> (Delete,Change)';
1450: fnd_file.put_line(FND_FILE.LOG, g_msg);
1451: -- dbms_output.put_line(g_msg);
1452:
1453:
1454:

Line 1467: fnd_file.put_line(FND_FILE.LOG, g_msg);

1463: x_owning_department => l_old_owning_department,
1464: x_asset_number => l_old_asset_number);
1465:
1466: g_msg := 'After get_attribute_id - OLD (N,Y)-> (Delete,Change)';
1467: fnd_file.put_line(FND_FILE.LOG, g_msg);
1468: -- dbms_output.put_line(g_msg);
1469:
1470: -- t_temp_attr_index := l_last_att_index;
1471:

Line 1486: fnd_file.put_line(FND_FILE.LOG, g_msg);

1482: p_transaction_qty => -(l_old_measure),
1483: p_start_time => l_old_start_time);
1484:
1485: g_msg := 'After Reversing Resource Txn - (N,Y)-> (Delete,Change)';
1486: fnd_file.put_line(FND_FILE.LOG, g_msg);
1487: -- dbms_output.put_line(g_msg);
1488:
1489: perform_res_txn (p_wip_entity_id => l_workorder,
1490: p_operation_seq_num => l_operation,

Line 1499: fnd_file.put_line(FND_FILE.LOG, g_msg);

1495: p_transaction_qty => l_measure,
1496: p_start_time => l_start_time);
1497:
1498: g_msg := 'After Resource Txn - (N,Y)-> (Delete,Change)';
1499: fnd_file.put_line(FND_FILE.LOG, g_msg);
1500: -- dbms_output.put_line(g_msg);
1501:
1502: end if;
1503:

Line 1516: fnd_file.put_line(FND_FILE.LOG, g_msg);

1512: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_cnt) := 'SUCCESS';
1513: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_cnt) := 'Building Block Processed Successfully';
1514:
1515: g_msg := 'SUCCESS -- Building Block Processed Successfully';
1516: fnd_file.put_line(FND_FILE.LOG, g_msg);
1517: **/
1518:
1519: if g_status <> 'ERRORS' then
1520: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_cnt) := 'SUCCESS';

Line 1523: fnd_file.put_line(FND_FILE.LOG, g_msg);

1519: if g_status <> 'ERRORS' then
1520: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_cnt) := 'SUCCESS';
1521: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_cnt) := 'Building Block Processed Successfully';
1522: g_msg := 'SUCCESS -- Building Block Processed Successfully';
1523: fnd_file.put_line(FND_FILE.LOG, g_msg);
1524: COMMIT WORK;
1525: else
1526: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_cnt) := g_status;
1527: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_cnt) := g_exception_description;

Line 1529: fnd_file.put_line(FND_FILE.LOG, g_msg);

1525: else
1526: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_cnt) := g_status;
1527: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_cnt) := g_exception_description;
1528: g_msg := 'FAILURE -- Building Block Processing Failed';
1529: fnd_file.put_line(FND_FILE.LOG, g_msg);
1530: end if;
1531:
1532:
1533: end loop;

Line 1550: fnd_file.put_line(FND_FILE.LOG, g_msg);

1546: ,p_exception_description => 'Building Block Processed Successfully'
1547: ,p_rollback => FALSE);
1548:
1549: g_msg := 'SUCCESS -- Resource Transaction Completed Successfully';
1550: fnd_file.put_line(FND_FILE.LOG, g_msg);
1551:
1552:
1553:
1554: exception

Line 1576: fnd_file.put_line(FND_FILE.LOG, g_msg);

1572: ,p_exception_description => SUBSTR(SQLERRM,1,200)
1573: ,p_rollback => FALSE);
1574:
1575: g_msg := 'FAILURE -- Resource Transaction encountered errors; Please look into hxc_transactions table for details';
1576: fnd_file.put_line(FND_FILE.LOG, g_msg);
1577: /*Added for Bug 7559044*/
1578: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', g_msg); -- Bug 7559044
1579:
1580: