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 418: fnd_file.put_line(FND_FILE.LOG, g_msg);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

770: BEGIN
771:
772: l_count := 0;
773: g_msg := 'Inside Method where_clause';
774: fnd_file.put_line(FND_FILE.LOG, g_msg);
775: -- dbms_output.put_line(g_msg);
776:
777: 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 ;
778: fnd_file.put_line(FND_FILE.LOG, g_msg);

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

774: fnd_file.put_line(FND_FILE.LOG, g_msg);
775: -- dbms_output.put_line(g_msg);
776:
777: 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 ;
778: fnd_file.put_line(FND_FILE.LOG, g_msg);
779: -- dbms_output.put_line(g_msg);
780:
781: 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 ;
782: fnd_file.put_line(FND_FILE.LOG, g_msg);

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

778: fnd_file.put_line(FND_FILE.LOG, g_msg);
779: -- dbms_output.put_line(g_msg);
780:
781: 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 ;
782: fnd_file.put_line(FND_FILE.LOG, g_msg);
783: -- dbms_output.put_line(g_msg);
784:
785: l_where_clause := p_where_clause ;
786:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1569: ,p_exception_description => SUBSTR(SQLERRM,1,200)
1570: ,p_rollback => FALSE);
1571:
1572: g_msg := 'FAILURE -- Resource Transaction encountered errors; Please look into hxc_transactions table for details';
1573: fnd_file.put_line(FND_FILE.LOG, g_msg);
1574:
1575:
1576: END retrieve_process;
1577: