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

Line 62: fnd_file.put_line(fnd_file.log, 'At stmt '||l_stmt_num||' p_op_seq_num='||p_op_seq_num);

58: and quantity_completed > 0));
59:
60: l_stmt_num := 20;
61: IF (g_debug = 'Y') THEN
62: fnd_file.put_line(fnd_file.log, 'At stmt '||l_stmt_num||' p_op_seq_num='||p_op_seq_num);
63: END IF;
64:
65: IF (p_op_seq_num IS NULL) THEN -- Job creation : No records in WO for this p_wip_entity_id
66: -- OR

Line 84: fnd_file.put_line(fnd_file.log, 'Job is completed');

80:
81: IF (l_temp > 1) THEN -- Completed Job
82: x_err_code := -2;
83: IF (g_debug = 'Y') THEN
84: fnd_file.put_line(fnd_file.log, 'Job is completed');
85: END IF;
86: return;
87: END IF;
88: -- End : Additions to fix bug #3677276

Line 102: fnd_file.put_line(fnd_file.log, 'At stmt '||l_stmt_num||' p_op_seq_num='||p_op_seq_num);

98: AND quantity_waiting_to_move = 0
99: AND quantity_scrapped = 0;
100:
101: IF (g_debug = 'Y') THEN
102: fnd_file.put_line(fnd_file.log, 'At stmt '||l_stmt_num||' p_op_seq_num='||p_op_seq_num);
103: END IF;
104:
105: IF (p_op_seq_num IS NULL) THEN -- Job creation : No records in WO for this p_wip_entity_id
106: x_err_code := -1;

Line 109: fnd_file.put_line(fnd_file.log, x_err_buf);

105: IF (p_op_seq_num IS NULL) THEN -- Job creation : No records in WO for this p_wip_entity_id
106: x_err_code := -1;
107: x_err_buf := 'WSM_JobCopies_PVT.Get_Job_Curr_Op_Info('||l_stmt_num||'): Warning ! No operations in the job';
108: IF (g_debug = 'Y') THEN
109: fnd_file.put_line(fnd_file.log, x_err_buf);
110: END IF;
111: return;
112: END IF;
113:

Line 165: fnd_file.put_line(fnd_file.log, x_err_buf);

161: EXCEPTION
162: WHEN OTHERS THEN
163: x_err_code := SQLCODE;
164: x_err_buf := 'WSM_JobCopies_PVT.Get_Job_Curr_Op_Info('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
165: fnd_file.put_line(fnd_file.log, x_err_buf);
166:
167: END Get_Job_Curr_Op_Info;
168:
169:

Line 931: fnd_file.put_line(fnd_file.log, 'Parameters to Create_JobCopies are :');

927:
928: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');
929:
930: IF (g_debug = 'Y') THEN
931: fnd_file.put_line(fnd_file.log, 'Parameters to Create_JobCopies are :');
932: fnd_file.put_line(fnd_file.log, ' p_wip_entity_id ='||p_wip_entity_id );
933: fnd_file.put_line(fnd_file.log, ', p_org_id ='||p_org_id );
934: fnd_file.put_line(fnd_file.log, ', p_primary_item_id ='||p_primary_item_id );
935: fnd_file.put_line(fnd_file.log, ', p_routing_item_id ='||p_routing_item_id );

Line 932: fnd_file.put_line(fnd_file.log, ' p_wip_entity_id ='||p_wip_entity_id );

928: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');
929:
930: IF (g_debug = 'Y') THEN
931: fnd_file.put_line(fnd_file.log, 'Parameters to Create_JobCopies are :');
932: fnd_file.put_line(fnd_file.log, ' p_wip_entity_id ='||p_wip_entity_id );
933: fnd_file.put_line(fnd_file.log, ', p_org_id ='||p_org_id );
934: fnd_file.put_line(fnd_file.log, ', p_primary_item_id ='||p_primary_item_id );
935: fnd_file.put_line(fnd_file.log, ', p_routing_item_id ='||p_routing_item_id );
936: fnd_file.put_line(fnd_file.log, ', p_alt_rtg_desig ='||p_alt_rtg_desig );

Line 933: fnd_file.put_line(fnd_file.log, ', p_org_id ='||p_org_id );

929:
930: IF (g_debug = 'Y') THEN
931: fnd_file.put_line(fnd_file.log, 'Parameters to Create_JobCopies are :');
932: fnd_file.put_line(fnd_file.log, ' p_wip_entity_id ='||p_wip_entity_id );
933: fnd_file.put_line(fnd_file.log, ', p_org_id ='||p_org_id );
934: fnd_file.put_line(fnd_file.log, ', p_primary_item_id ='||p_primary_item_id );
935: fnd_file.put_line(fnd_file.log, ', p_routing_item_id ='||p_routing_item_id );
936: fnd_file.put_line(fnd_file.log, ', p_alt_rtg_desig ='||p_alt_rtg_desig );
937: fnd_file.put_line(fnd_file.log, ', p_rtg_seq_id ='||p_rtg_seq_id );

Line 934: fnd_file.put_line(fnd_file.log, ', p_primary_item_id ='||p_primary_item_id );

930: IF (g_debug = 'Y') THEN
931: fnd_file.put_line(fnd_file.log, 'Parameters to Create_JobCopies are :');
932: fnd_file.put_line(fnd_file.log, ' p_wip_entity_id ='||p_wip_entity_id );
933: fnd_file.put_line(fnd_file.log, ', p_org_id ='||p_org_id );
934: fnd_file.put_line(fnd_file.log, ', p_primary_item_id ='||p_primary_item_id );
935: fnd_file.put_line(fnd_file.log, ', p_routing_item_id ='||p_routing_item_id );
936: fnd_file.put_line(fnd_file.log, ', p_alt_rtg_desig ='||p_alt_rtg_desig );
937: fnd_file.put_line(fnd_file.log, ', p_rtg_seq_id ='||p_rtg_seq_id );
938: fnd_file.put_line(fnd_file.log, ', p_common_rtg_seq_id ='||p_common_rtg_seq_id );

Line 935: fnd_file.put_line(fnd_file.log, ', p_routing_item_id ='||p_routing_item_id );

931: fnd_file.put_line(fnd_file.log, 'Parameters to Create_JobCopies are :');
932: fnd_file.put_line(fnd_file.log, ' p_wip_entity_id ='||p_wip_entity_id );
933: fnd_file.put_line(fnd_file.log, ', p_org_id ='||p_org_id );
934: fnd_file.put_line(fnd_file.log, ', p_primary_item_id ='||p_primary_item_id );
935: fnd_file.put_line(fnd_file.log, ', p_routing_item_id ='||p_routing_item_id );
936: fnd_file.put_line(fnd_file.log, ', p_alt_rtg_desig ='||p_alt_rtg_desig );
937: fnd_file.put_line(fnd_file.log, ', p_rtg_seq_id ='||p_rtg_seq_id );
938: fnd_file.put_line(fnd_file.log, ', p_common_rtg_seq_id ='||p_common_rtg_seq_id );
939: fnd_file.put_line(fnd_file.log, ', p_rtg_rev_date ='||p_rtg_rev_date );

Line 936: fnd_file.put_line(fnd_file.log, ', p_alt_rtg_desig ='||p_alt_rtg_desig );

932: fnd_file.put_line(fnd_file.log, ' p_wip_entity_id ='||p_wip_entity_id );
933: fnd_file.put_line(fnd_file.log, ', p_org_id ='||p_org_id );
934: fnd_file.put_line(fnd_file.log, ', p_primary_item_id ='||p_primary_item_id );
935: fnd_file.put_line(fnd_file.log, ', p_routing_item_id ='||p_routing_item_id );
936: fnd_file.put_line(fnd_file.log, ', p_alt_rtg_desig ='||p_alt_rtg_desig );
937: fnd_file.put_line(fnd_file.log, ', p_rtg_seq_id ='||p_rtg_seq_id );
938: fnd_file.put_line(fnd_file.log, ', p_common_rtg_seq_id ='||p_common_rtg_seq_id );
939: fnd_file.put_line(fnd_file.log, ', p_rtg_rev_date ='||p_rtg_rev_date );
940: fnd_file.put_line(fnd_file.log, ', p_bill_item_id ='||p_bill_item_id );

Line 937: fnd_file.put_line(fnd_file.log, ', p_rtg_seq_id ='||p_rtg_seq_id );

933: fnd_file.put_line(fnd_file.log, ', p_org_id ='||p_org_id );
934: fnd_file.put_line(fnd_file.log, ', p_primary_item_id ='||p_primary_item_id );
935: fnd_file.put_line(fnd_file.log, ', p_routing_item_id ='||p_routing_item_id );
936: fnd_file.put_line(fnd_file.log, ', p_alt_rtg_desig ='||p_alt_rtg_desig );
937: fnd_file.put_line(fnd_file.log, ', p_rtg_seq_id ='||p_rtg_seq_id );
938: fnd_file.put_line(fnd_file.log, ', p_common_rtg_seq_id ='||p_common_rtg_seq_id );
939: fnd_file.put_line(fnd_file.log, ', p_rtg_rev_date ='||p_rtg_rev_date );
940: fnd_file.put_line(fnd_file.log, ', p_bill_item_id ='||p_bill_item_id );
941: fnd_file.put_line(fnd_file.log, ', p_alt_bom_desig ='||p_alt_bom_desig );

Line 938: fnd_file.put_line(fnd_file.log, ', p_common_rtg_seq_id ='||p_common_rtg_seq_id );

934: fnd_file.put_line(fnd_file.log, ', p_primary_item_id ='||p_primary_item_id );
935: fnd_file.put_line(fnd_file.log, ', p_routing_item_id ='||p_routing_item_id );
936: fnd_file.put_line(fnd_file.log, ', p_alt_rtg_desig ='||p_alt_rtg_desig );
937: fnd_file.put_line(fnd_file.log, ', p_rtg_seq_id ='||p_rtg_seq_id );
938: fnd_file.put_line(fnd_file.log, ', p_common_rtg_seq_id ='||p_common_rtg_seq_id );
939: fnd_file.put_line(fnd_file.log, ', p_rtg_rev_date ='||p_rtg_rev_date );
940: fnd_file.put_line(fnd_file.log, ', p_bill_item_id ='||p_bill_item_id );
941: fnd_file.put_line(fnd_file.log, ', p_alt_bom_desig ='||p_alt_bom_desig );
942: fnd_file.put_line(fnd_file.log, ', p_bill_seq_id ='||p_bill_seq_id );

Line 939: fnd_file.put_line(fnd_file.log, ', p_rtg_rev_date ='||p_rtg_rev_date );

935: fnd_file.put_line(fnd_file.log, ', p_routing_item_id ='||p_routing_item_id );
936: fnd_file.put_line(fnd_file.log, ', p_alt_rtg_desig ='||p_alt_rtg_desig );
937: fnd_file.put_line(fnd_file.log, ', p_rtg_seq_id ='||p_rtg_seq_id );
938: fnd_file.put_line(fnd_file.log, ', p_common_rtg_seq_id ='||p_common_rtg_seq_id );
939: fnd_file.put_line(fnd_file.log, ', p_rtg_rev_date ='||p_rtg_rev_date );
940: fnd_file.put_line(fnd_file.log, ', p_bill_item_id ='||p_bill_item_id );
941: fnd_file.put_line(fnd_file.log, ', p_alt_bom_desig ='||p_alt_bom_desig );
942: fnd_file.put_line(fnd_file.log, ', p_bill_seq_id ='||p_bill_seq_id );
943: fnd_file.put_line(fnd_file.log, ', p_common_bill_seq_id ='||p_common_bill_seq_id );

Line 940: fnd_file.put_line(fnd_file.log, ', p_bill_item_id ='||p_bill_item_id );

936: fnd_file.put_line(fnd_file.log, ', p_alt_rtg_desig ='||p_alt_rtg_desig );
937: fnd_file.put_line(fnd_file.log, ', p_rtg_seq_id ='||p_rtg_seq_id );
938: fnd_file.put_line(fnd_file.log, ', p_common_rtg_seq_id ='||p_common_rtg_seq_id );
939: fnd_file.put_line(fnd_file.log, ', p_rtg_rev_date ='||p_rtg_rev_date );
940: fnd_file.put_line(fnd_file.log, ', p_bill_item_id ='||p_bill_item_id );
941: fnd_file.put_line(fnd_file.log, ', p_alt_bom_desig ='||p_alt_bom_desig );
942: fnd_file.put_line(fnd_file.log, ', p_bill_seq_id ='||p_bill_seq_id );
943: fnd_file.put_line(fnd_file.log, ', p_common_bill_seq_id ='||p_common_bill_seq_id );
944: fnd_file.put_line(fnd_file.log, ', p_bom_rev_date ='||p_bom_rev_date );

Line 941: fnd_file.put_line(fnd_file.log, ', p_alt_bom_desig ='||p_alt_bom_desig );

937: fnd_file.put_line(fnd_file.log, ', p_rtg_seq_id ='||p_rtg_seq_id );
938: fnd_file.put_line(fnd_file.log, ', p_common_rtg_seq_id ='||p_common_rtg_seq_id );
939: fnd_file.put_line(fnd_file.log, ', p_rtg_rev_date ='||p_rtg_rev_date );
940: fnd_file.put_line(fnd_file.log, ', p_bill_item_id ='||p_bill_item_id );
941: fnd_file.put_line(fnd_file.log, ', p_alt_bom_desig ='||p_alt_bom_desig );
942: fnd_file.put_line(fnd_file.log, ', p_bill_seq_id ='||p_bill_seq_id );
943: fnd_file.put_line(fnd_file.log, ', p_common_bill_seq_id ='||p_common_bill_seq_id );
944: fnd_file.put_line(fnd_file.log, ', p_bom_rev_date ='||p_bom_rev_date );
945: fnd_file.put_line(fnd_file.log, ', p_wip_supply_type ='||p_wip_supply_type );

Line 942: fnd_file.put_line(fnd_file.log, ', p_bill_seq_id ='||p_bill_seq_id );

938: fnd_file.put_line(fnd_file.log, ', p_common_rtg_seq_id ='||p_common_rtg_seq_id );
939: fnd_file.put_line(fnd_file.log, ', p_rtg_rev_date ='||p_rtg_rev_date );
940: fnd_file.put_line(fnd_file.log, ', p_bill_item_id ='||p_bill_item_id );
941: fnd_file.put_line(fnd_file.log, ', p_alt_bom_desig ='||p_alt_bom_desig );
942: fnd_file.put_line(fnd_file.log, ', p_bill_seq_id ='||p_bill_seq_id );
943: fnd_file.put_line(fnd_file.log, ', p_common_bill_seq_id ='||p_common_bill_seq_id );
944: fnd_file.put_line(fnd_file.log, ', p_bom_rev_date ='||p_bom_rev_date );
945: fnd_file.put_line(fnd_file.log, ', p_wip_supply_type ='||p_wip_supply_type );
946: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );

Line 943: fnd_file.put_line(fnd_file.log, ', p_common_bill_seq_id ='||p_common_bill_seq_id );

939: fnd_file.put_line(fnd_file.log, ', p_rtg_rev_date ='||p_rtg_rev_date );
940: fnd_file.put_line(fnd_file.log, ', p_bill_item_id ='||p_bill_item_id );
941: fnd_file.put_line(fnd_file.log, ', p_alt_bom_desig ='||p_alt_bom_desig );
942: fnd_file.put_line(fnd_file.log, ', p_bill_seq_id ='||p_bill_seq_id );
943: fnd_file.put_line(fnd_file.log, ', p_common_bill_seq_id ='||p_common_bill_seq_id );
944: fnd_file.put_line(fnd_file.log, ', p_bom_rev_date ='||p_bom_rev_date );
945: fnd_file.put_line(fnd_file.log, ', p_wip_supply_type ='||p_wip_supply_type );
946: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
947: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );

Line 944: fnd_file.put_line(fnd_file.log, ', p_bom_rev_date ='||p_bom_rev_date );

940: fnd_file.put_line(fnd_file.log, ', p_bill_item_id ='||p_bill_item_id );
941: fnd_file.put_line(fnd_file.log, ', p_alt_bom_desig ='||p_alt_bom_desig );
942: fnd_file.put_line(fnd_file.log, ', p_bill_seq_id ='||p_bill_seq_id );
943: fnd_file.put_line(fnd_file.log, ', p_common_bill_seq_id ='||p_common_bill_seq_id );
944: fnd_file.put_line(fnd_file.log, ', p_bom_rev_date ='||p_bom_rev_date );
945: fnd_file.put_line(fnd_file.log, ', p_wip_supply_type ='||p_wip_supply_type );
946: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
947: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
948: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );

Line 945: fnd_file.put_line(fnd_file.log, ', p_wip_supply_type ='||p_wip_supply_type );

941: fnd_file.put_line(fnd_file.log, ', p_alt_bom_desig ='||p_alt_bom_desig );
942: fnd_file.put_line(fnd_file.log, ', p_bill_seq_id ='||p_bill_seq_id );
943: fnd_file.put_line(fnd_file.log, ', p_common_bill_seq_id ='||p_common_bill_seq_id );
944: fnd_file.put_line(fnd_file.log, ', p_bom_rev_date ='||p_bom_rev_date );
945: fnd_file.put_line(fnd_file.log, ', p_wip_supply_type ='||p_wip_supply_type );
946: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
947: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
948: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
949: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );

Line 946: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );

942: fnd_file.put_line(fnd_file.log, ', p_bill_seq_id ='||p_bill_seq_id );
943: fnd_file.put_line(fnd_file.log, ', p_common_bill_seq_id ='||p_common_bill_seq_id );
944: fnd_file.put_line(fnd_file.log, ', p_bom_rev_date ='||p_bom_rev_date );
945: fnd_file.put_line(fnd_file.log, ', p_wip_supply_type ='||p_wip_supply_type );
946: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
947: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
948: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
949: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
950: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );

Line 947: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );

943: fnd_file.put_line(fnd_file.log, ', p_common_bill_seq_id ='||p_common_bill_seq_id );
944: fnd_file.put_line(fnd_file.log, ', p_bom_rev_date ='||p_bom_rev_date );
945: fnd_file.put_line(fnd_file.log, ', p_wip_supply_type ='||p_wip_supply_type );
946: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
947: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
948: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
949: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
950: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
951: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );

Line 948: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );

944: fnd_file.put_line(fnd_file.log, ', p_bom_rev_date ='||p_bom_rev_date );
945: fnd_file.put_line(fnd_file.log, ', p_wip_supply_type ='||p_wip_supply_type );
946: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
947: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
948: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
949: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
950: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
951: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
952: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );

Line 949: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );

945: fnd_file.put_line(fnd_file.log, ', p_wip_supply_type ='||p_wip_supply_type );
946: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
947: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
948: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
949: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
950: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
951: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
952: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
953: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );

Line 950: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );

946: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
947: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
948: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
949: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
950: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
951: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
952: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
953: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
954: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );

Line 951: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );

947: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
948: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
949: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
950: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
951: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
952: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
953: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
954: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
955: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );

Line 952: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );

948: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
949: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
950: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
951: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
952: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
953: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
954: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
955: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );
956: fnd_file.put_line(fnd_file.log, ', p_inf_sch_mode ='||p_inf_sch_mode );

Line 953: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );

949: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
950: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
951: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
952: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
953: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
954: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
955: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );
956: fnd_file.put_line(fnd_file.log, ', p_inf_sch_mode ='||p_inf_sch_mode );
957: fnd_file.put_line(fnd_file.log, ', p_inf_sch_date ='||p_inf_sch_date );

Line 954: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );

950: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
951: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
952: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
953: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
954: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
955: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );
956: fnd_file.put_line(fnd_file.log, ', p_inf_sch_mode ='||p_inf_sch_mode );
957: fnd_file.put_line(fnd_file.log, ', p_inf_sch_date ='||p_inf_sch_date );
958: END IF;

Line 955: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );

951: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
952: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
953: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
954: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
955: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );
956: fnd_file.put_line(fnd_file.log, ', p_inf_sch_mode ='||p_inf_sch_mode );
957: fnd_file.put_line(fnd_file.log, ', p_inf_sch_date ='||p_inf_sch_date );
958: END IF;
959:

Line 956: fnd_file.put_line(fnd_file.log, ', p_inf_sch_mode ='||p_inf_sch_mode );

952: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
953: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
954: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
955: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );
956: fnd_file.put_line(fnd_file.log, ', p_inf_sch_mode ='||p_inf_sch_mode );
957: fnd_file.put_line(fnd_file.log, ', p_inf_sch_date ='||p_inf_sch_date );
958: END IF;
959:
960: l_stmt_num := 10;

Line 957: fnd_file.put_line(fnd_file.log, ', p_inf_sch_date ='||p_inf_sch_date );

953: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
954: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
955: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );
956: fnd_file.put_line(fnd_file.log, ', p_inf_sch_mode ='||p_inf_sch_mode );
957: fnd_file.put_line(fnd_file.log, ', p_inf_sch_date ='||p_inf_sch_date );
958: END IF;
959:
960: l_stmt_num := 10;
961:

Line 969: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);

965: THEN
966: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
967: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Primary Item ID in Job');
968: x_err_buf := fnd_message.get;
969: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
970: x_err_code := -2; -- Error
971: return;
972: END IF;
973:

Line 980: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);

976: THEN
977: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
978: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Routing Item ID in Job');
979: x_err_buf := fnd_message.get;
980: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
981: x_err_code := -2; -- Error
982: return;
983: END IF;
984:

Line 991: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);

987: THEN
988: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
989: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Common Routing Sequence ID in Job');
990: x_err_buf := fnd_message.get;
991: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
992: x_err_code := -2; -- Error
993: return;
994: END IF;
995:

Line 1001: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);

997: THEN
998: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
999: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Routing Revision Date in Job');
1000: x_err_buf := fnd_message.get;
1001: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
1002: x_err_code := -2; -- Error
1003: return;
1004: END IF;
1005:

Line 1012: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);

1008: THEN
1009: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1010: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Supply Type in Job');
1011: x_err_buf := fnd_message.get;
1012: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
1013: x_err_code := -2; -- Error
1014: return;
1015: END IF;
1016: -- End : Basic validations for the input parameters --

Line 1031: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);

1027: THEN
1028: -- Invalid Infinite Scheduling Mode
1029: fnd_message.set_name('WSM', 'WSM_INVALID_INFSCH_MODE');
1030: x_err_buf := fnd_message.get;
1031: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
1032: x_err_code := -2; -- Error
1033: return;
1034: END IF;
1035:

Line 1059: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||

1055: WHERE wip_entity_id = p_wip_entity_id
1056: AND wsm_op_seq_num IS NULL;
1057: EXCEPTION
1058: WHEN OTHERS THEN
1059: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||
1060: '): Cannot upgrade wip_operations.wsm_op_seq_num for wip_entity_id '||p_wip_entity_id);
1061: END;
1062: end if;--check on p_insert_wip
1063: l_stmt_num := 15;

Line 1237: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.process_job_op_nw('||l_stmt_num||'): '||x_err_buf);

1233: IF v_job_ops.count = 0 THEN
1234: -- No valid operations exist for the job
1235: fnd_message.set_name('WSM', 'WSM_NO_VALID_OPS');
1236: x_err_buf := fnd_message.get;
1237: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.process_job_op_nw('||l_stmt_num||'): '||x_err_buf);
1238: x_err_code := -2; -- Error
1239:
1240: return;
1241: END IF;

Line 1369: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.process_job_op_nw('||l_stmt_num||'): '||x_err_buf);

1365:
1366: -- No valid network links exist for the job
1367: fnd_message.set_name('WSM', 'WSM_NO_VALID_NWK_LINKS');
1368: x_err_buf := fnd_message.get;
1369: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.process_job_op_nw('||l_stmt_num||'): '||x_err_buf);
1370: x_err_code := -2; -- Error
1371:
1372: return; -- This should not be commented out, since later it may get overwritten.
1373: -- Fixed bug #3465125

Line 1441: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);

1437: else
1438: fnd_message.set_name('WSM', 'WSM_NET_START_NOT_EFFECTIVE');
1439: --x_err_buf := fnd_message.get;
1440: x_err_buf := 'l_count is'||to_char(l_start_op_seq_id);
1441: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
1442: x_err_code := -1; -- Warning
1443: --Bug 4264364:Added exception handling
1444: INSERT into WSM_LOT_BASED_JOBS
1445: (WIP_ENTITY_ID,

Line 1493: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.process_job_op_nw('||l_stmt_num||'): '||x_err_buf);

1489: else
1490: l_reco_path_seq_num := -1;
1491: fnd_message.set_name('WSM', 'WSM_NET_END_NOT_EFFECTIVE');
1492: x_err_buf := fnd_message.get;
1493: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.process_job_op_nw('||l_stmt_num||'): '||x_err_buf);
1494: x_err_code := -1; -- Warning
1495:
1496: --Bug 4264364:Added exception handling
1497: INSERT into WSM_LOT_BASED_JOBS

Line 1569: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.process_job_op_nw('||l_stmt_num||'): '||x_err_buf);

1565: l_stmt_num := 40.1;
1566: If l_curr_opseq_id <> l_start_op_seq_id or l_reco_path_seq_num = -1 then
1567: fnd_message.set_name('WSM', 'WSM_DISABLED_PRIMARY_PATH');
1568: x_err_buf := fnd_message.get;
1569: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.process_job_op_nw('||l_stmt_num||'): '||x_err_buf);
1570: x_err_code := -1; -- Warning
1571: l_inf_sch_flag := 'N'; -- Do not infinite schedule this job
1572: END IF;
1573:

Line 2002: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCOR (pri res) for we_id='||p_wip_entity_id);

1998: AND br.ORGANIZATION_ID = p_org_id;
1999:
2000: IF SQL%ROWCOUNT > 0 THEN --Added for 4635447
2001: IF (g_debug = 'Y') THEN
2002: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCOR (pri res) for we_id='||p_wip_entity_id);
2003: END IF;
2004:
2005: --IF SQL%ROWCOUNT > 0 THEN --Bug 4635477
2006: --Look for substitute resources only when at least one primary resource

Line 2156: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCOR (subs res) for we_id='||p_wip_entity_id);

2152: AND bsor.RESOURCE_ID = br.RESOURCE_ID
2153: AND WCO.OPERATION_SEQUENCE_ID = bsor.OPERATION_SEQUENCE_ID;
2154:
2155: IF (g_debug = 'Y') THEN
2156: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCOR (subs res) for we_id='||p_wip_entity_id);
2157: END IF;
2158: END IF;--Check on SQL%ROWCOUNT
2159:
2160: if p_phantom_exists = 2 and p_common_bill_seq_id IS NOT NULL THEN --Code review remark

Line 2416: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCR) (Primary Components) for we_id='||p_wip_entity_id);

2412: AND NOT (A.CHANGE_NOTICE IS not null AND A.IMPLEMENTATION_DATE IS NULL); --bug 13852691
2413:
2414: IF SQL%ROWCOUNT > 0 THEN
2415: IF (g_debug = 'Y') THEN
2416: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCR) (Primary Components) for we_id='||p_wip_entity_id);
2417: END IF;
2418: --IF SQL%ROWCOUNT > 0 THEN
2419: --Insert substitute components only when there are primary components.
2420: INSERT INTO WSM_COPY_REQUIREMENT_OPS

Line 2629: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): Parameters to exploder_userexit for 1st level explosion :');

2625:
2626: l_stmt_num := 160;
2627:
2628: IF (g_debug = 'Y') THEN
2629: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): Parameters to exploder_userexit for 1st level explosion :');
2630: fnd_file.put_line(fnd_file.log, 'expl_group_id ='||l_explosion_group_id||
2631: ', Bill item_id='||p_bill_item_id||
2632: ', alt_desg='||p_alt_bom_desig||
2633: ', comp_code=NULL');

Line 2630: fnd_file.put_line(fnd_file.log, 'expl_group_id ='||l_explosion_group_id||

2626: l_stmt_num := 160;
2627:
2628: IF (g_debug = 'Y') THEN
2629: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): Parameters to exploder_userexit for 1st level explosion :');
2630: fnd_file.put_line(fnd_file.log, 'expl_group_id ='||l_explosion_group_id||
2631: ', Bill item_id='||p_bill_item_id||
2632: ', alt_desg='||p_alt_bom_desig||
2633: ', comp_code=NULL');
2634: END IF;

Line 2690: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): '||

2686: INTO l_be_count
2687: FROM BOM_EXPLOSION_TEMP
2688: WHERE group_id = l_explosion_group_id;
2689:
2690: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): '||
2691: ' l_explosion_group_id ='||l_explosion_group_id||
2692: ', l_be_count ='||l_be_count||
2693: ', l_op_seq_one_exists_in_ntwk='||l_op_seq_one_exists_in_ntwk);
2694: END IF;

Line 2723: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): '||

2719:
2720:
2721: -- Moved the comments down and added l_curr_first_op_attach_opseq1
2722: IF (g_debug = 'Y') THEN
2723: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): '||
2724: ' l_curr_op_seq_num ='||l_curr_op_seq_num ||
2725: ', l_curr_op_seq_id ='||l_curr_op_seq_id ||
2726: ', l_curr_op_is_ntwk_st_end ='||l_curr_op_is_ntwk_st_end ||
2727: ', l_curr_op_start_date ='||l_curr_op_start_date ||

Line 2750: fnd_file.put_line(fnd_file.log, 'l_curr_op_total_comps at stmt('||l_stmt_num||'): '||l_curr_op_total_comps);

2746: END;
2747:
2748:
2749: IF (g_debug = 'Y') THEN
2750: fnd_file.put_line(fnd_file.log, 'l_curr_op_total_comps at stmt('||l_stmt_num||'): '||l_curr_op_total_comps);
2751: END IF;
2752:
2753: l_curr_op_first_level_comps:=l_curr_op_total_comps;
2754: l_first_level_comps_ctr:=0;

Line 2765: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): '||

2761:
2762: l_stmt_num := 180;
2763:
2764: IF (g_debug = 'Y') THEN
2765: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): '||
2766: ' Phantom found at op'||t_comp_details(l_first_level_comps_ctr).operation_seq_num);
2767: END IF;
2768:
2769: t_comp_details(l_first_level_comps_ctr).operation_seq_num :=-l_curr_op_seq_num;

Line 2818: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): '||

2814: END;
2815:
2816:
2817: IF (g_debug = 'Y') THEN
2818: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): '||
2819: 'l_phantom_reqd_qty = '||l_phantom_reqd_qty||
2820: ', l_phantom_bill_seq_id = '||l_phantom_bill_seq_id||
2821: ', l_phantom_rtg_seq_id= '||l_phantom_rtg_seq_id ||
2822: ', l_phantom_org_id = '||l_phantom_org_id);

Line 2838: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): Parameters to exploder_userexit for exploding all levels :');

2834: l_stmt_num := 210;
2835:
2836:
2837: IF (g_debug = 'Y') THEN
2838: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): Parameters to exploder_userexit for exploding all levels :');
2839: fnd_file.put_line(fnd_file.log, 'expl_group_id ='||l_phantom_expl_group_id||
2840: ', item_id='||t_comp_details(l_first_level_comps_ctr).component_item_id||
2841: ', alt_desg=NULL'||
2842: ', comp_code='||p_bill_item_id);

Line 2839: fnd_file.put_line(fnd_file.log, 'expl_group_id ='||l_phantom_expl_group_id||

2835:
2836:
2837: IF (g_debug = 'Y') THEN
2838: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): Parameters to exploder_userexit for exploding all levels :');
2839: fnd_file.put_line(fnd_file.log, 'expl_group_id ='||l_phantom_expl_group_id||
2840: ', item_id='||t_comp_details(l_first_level_comps_ctr).component_item_id||
2841: ', alt_desg=NULL'||
2842: ', comp_code='||p_bill_item_id);
2843: END IF;

Line 2881: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): '||

2877: INTO l_be_count
2878: FROM BOM_EXPLOSION_TEMP
2879: WHERE group_id = l_phantom_expl_group_id;
2880:
2881: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): '||
2882: ' l_phantom_expl_group_id ='||l_phantom_expl_group_id||
2883: ', l_be_count ='||l_be_count);
2884: END IF;
2885:

Line 2973: fnd_file.put_line(fnd_file.log, 'Before phan_comp '||

2969:
2970:
2971: IF (g_debug = 'Y') THEN
2972:
2973: fnd_file.put_line(fnd_file.log, 'Before phan_comp '||
2974: ' PRIMARY_COMPONENT_ID = '||t_comp_details(l_first_level_comps_ctr).PRIMARY_COMPONENT_ID||
2975: ', COMPONENT_ITEM_ID = '||t_comp_details(l_first_level_comps_ctr).COMPONENT_ITEM_ID||
2976: ', l_phantom_reqd_qty = '||l_phantom_reqd_qty||
2977: ', l_phantom_bill_seq_id = '||l_phantom_bill_seq_id);

Line 3266: fnd_file.put_line(fnd_file.log, 'START********');

3262: THEN
3263:
3264:
3265: IF (g_debug = 'Y') THEN
3266: fnd_file.put_line(fnd_file.log, '******START**************');
3267: fnd_file.put_line(fnd_file.log,
3268: '(l_all_level_comps_ctr).component_item_id='||t_comp_details(l_all_level_comps_ctr).component_item_id||
3269: ', (l_all_level_comps_subctr).component_item_id='||t_comp_details(l_all_level_comps_subctr).component_item_id);
3270: fnd_file.put_line(fnd_file.log,

Line 3267: fnd_file.put_line(fnd_file.log,

3263:
3264:
3265: IF (g_debug = 'Y') THEN
3266: fnd_file.put_line(fnd_file.log, '******START**************');
3267: fnd_file.put_line(fnd_file.log,
3268: '(l_all_level_comps_ctr).component_item_id='||t_comp_details(l_all_level_comps_ctr).component_item_id||
3269: ', (l_all_level_comps_subctr).component_item_id='||t_comp_details(l_all_level_comps_subctr).component_item_id);
3270: fnd_file.put_line(fnd_file.log,
3271: '(l_all_level_comps_ctr).primary_component_id='||t_comp_details(l_all_level_comps_ctr).primary_component_id||

Line 3270: fnd_file.put_line(fnd_file.log,

3266: fnd_file.put_line(fnd_file.log, '******START**************');
3267: fnd_file.put_line(fnd_file.log,
3268: '(l_all_level_comps_ctr).component_item_id='||t_comp_details(l_all_level_comps_ctr).component_item_id||
3269: ', (l_all_level_comps_subctr).component_item_id='||t_comp_details(l_all_level_comps_subctr).component_item_id);
3270: fnd_file.put_line(fnd_file.log,
3271: '(l_all_level_comps_ctr).primary_component_id='||t_comp_details(l_all_level_comps_ctr).primary_component_id||
3272: ', (l_all_level_comps_subctr).primary_component_id='||t_comp_details(l_all_level_comps_subctr).primary_component_id);
3273: fnd_file.put_line(fnd_file.log,
3274: '(l_all_level_comps_ctr).component_sequence_id='||t_comp_details(l_all_level_comps_ctr).component_sequence_id||

Line 3273: fnd_file.put_line(fnd_file.log,

3269: ', (l_all_level_comps_subctr).component_item_id='||t_comp_details(l_all_level_comps_subctr).component_item_id);
3270: fnd_file.put_line(fnd_file.log,
3271: '(l_all_level_comps_ctr).primary_component_id='||t_comp_details(l_all_level_comps_ctr).primary_component_id||
3272: ', (l_all_level_comps_subctr).primary_component_id='||t_comp_details(l_all_level_comps_subctr).primary_component_id);
3273: fnd_file.put_line(fnd_file.log,
3274: '(l_all_level_comps_ctr).component_sequence_id='||t_comp_details(l_all_level_comps_ctr).component_sequence_id||
3275: ', (l_all_level_comps_subctr).component_sequence_id='||t_comp_details(l_all_level_comps_subctr).component_sequence_id);
3276: fnd_file.put_line(fnd_file.log,
3277: '(l_all_level_comps_ctr).source_phantom_id='||t_comp_details(l_all_level_comps_ctr).source_phantom_id||

Line 3276: fnd_file.put_line(fnd_file.log,

3272: ', (l_all_level_comps_subctr).primary_component_id='||t_comp_details(l_all_level_comps_subctr).primary_component_id);
3273: fnd_file.put_line(fnd_file.log,
3274: '(l_all_level_comps_ctr).component_sequence_id='||t_comp_details(l_all_level_comps_ctr).component_sequence_id||
3275: ', (l_all_level_comps_subctr).component_sequence_id='||t_comp_details(l_all_level_comps_subctr).component_sequence_id);
3276: fnd_file.put_line(fnd_file.log,
3277: '(l_all_level_comps_ctr).source_phantom_id='||t_comp_details(l_all_level_comps_ctr).source_phantom_id||
3278: ', (l_all_level_comps_subctr).source_phantom_id='||t_comp_details(l_all_level_comps_subctr).source_phantom_id);
3279: fnd_file.put_line(fnd_file.log,
3280: '(l_all_level_comps_ctr).required_quantity='||t_comp_details(l_all_level_comps_ctr).required_quantity||

Line 3279: fnd_file.put_line(fnd_file.log,

3275: ', (l_all_level_comps_subctr).component_sequence_id='||t_comp_details(l_all_level_comps_subctr).component_sequence_id);
3276: fnd_file.put_line(fnd_file.log,
3277: '(l_all_level_comps_ctr).source_phantom_id='||t_comp_details(l_all_level_comps_ctr).source_phantom_id||
3278: ', (l_all_level_comps_subctr).source_phantom_id='||t_comp_details(l_all_level_comps_subctr).source_phantom_id);
3279: fnd_file.put_line(fnd_file.log,
3280: '(l_all_level_comps_ctr).required_quantity='||t_comp_details(l_all_level_comps_ctr).required_quantity||
3281: ', (l_all_level_comps_subctr).required_quantity='||t_comp_details(l_all_level_comps_subctr).required_quantity);
3282: fnd_file.put_line(fnd_file.log,
3283: '(l_all_level_comps_ctr).BILL_QUANTITY_PER_ASSEMBLY='||t_comp_details(l_all_level_comps_ctr).BILL_QUANTITY_PER_ASSEMBLY||

Line 3282: fnd_file.put_line(fnd_file.log,

3278: ', (l_all_level_comps_subctr).source_phantom_id='||t_comp_details(l_all_level_comps_subctr).source_phantom_id);
3279: fnd_file.put_line(fnd_file.log,
3280: '(l_all_level_comps_ctr).required_quantity='||t_comp_details(l_all_level_comps_ctr).required_quantity||
3281: ', (l_all_level_comps_subctr).required_quantity='||t_comp_details(l_all_level_comps_subctr).required_quantity);
3282: fnd_file.put_line(fnd_file.log,
3283: '(l_all_level_comps_ctr).BILL_QUANTITY_PER_ASSEMBLY='||t_comp_details(l_all_level_comps_ctr).BILL_QUANTITY_PER_ASSEMBLY||
3284: ', (l_all_level_comps_subctr).BILL_QUANTITY_PER_ASSEMBLY='||t_comp_details(l_all_level_comps_subctr).BILL_QUANTITY_PER_ASSEMBLY);
3285: fnd_file.put_line(fnd_file.log, '******END**************');
3286: END IF;

Line 3285: fnd_file.put_line(fnd_file.log, 'END********');

3281: ', (l_all_level_comps_subctr).required_quantity='||t_comp_details(l_all_level_comps_subctr).required_quantity);
3282: fnd_file.put_line(fnd_file.log,
3283: '(l_all_level_comps_ctr).BILL_QUANTITY_PER_ASSEMBLY='||t_comp_details(l_all_level_comps_ctr).BILL_QUANTITY_PER_ASSEMBLY||
3284: ', (l_all_level_comps_subctr).BILL_QUANTITY_PER_ASSEMBLY='||t_comp_details(l_all_level_comps_subctr).BILL_QUANTITY_PER_ASSEMBLY);
3285: fnd_file.put_line(fnd_file.log, '******END**************');
3286: END IF;
3287:
3288: IF (t_comp_details(l_all_level_comps_ctr).component_item_id =
3289: t_comp_details(l_all_level_comps_subctr).component_item_id)

Line 3300: fnd_file.put_line(fnd_file.log, 'MATCHING !!!!!!!!!!!!!');

3296: THEN
3297:
3298:
3299: IF (g_debug = 'Y') THEN
3300: fnd_file.put_line(fnd_file.log, 'MATCHING !!!!!!!!!!!!!');
3301: END IF;
3302:
3303: t_comp_details(l_all_level_comps_ctr).required_quantity :=
3304: t_comp_details(l_all_level_comps_ctr).required_quantity +

Line 3510: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCRO for we_id='||p_wip_entity_id);

3506: t_comp_details(l_all_level_comps_ctr).ORIGINAL_SYSTEM_REFERENCE
3507: );
3508:
3509: IF (g_debug = 'Y') THEN
3510: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCRO for we_id='||p_wip_entity_id);
3511: fnd_file.put_line(fnd_file.log, 'for component='||t_comp_details(l_all_level_comps_ctr).component_item_id||
3512: ', and qpa = '||t_comp_details(l_all_level_comps_ctr).required_quantity||
3513: ', and bill_qpa = '||t_comp_details(l_all_level_comps_ctr).BILL_QUANTITY_PER_ASSEMBLY);
3514: END IF;

Line 3511: fnd_file.put_line(fnd_file.log, 'for component='||t_comp_details(l_all_level_comps_ctr).component_item_id||

3507: );
3508:
3509: IF (g_debug = 'Y') THEN
3510: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCRO for we_id='||p_wip_entity_id);
3511: fnd_file.put_line(fnd_file.log, 'for component='||t_comp_details(l_all_level_comps_ctr).component_item_id||
3512: ', and qpa = '||t_comp_details(l_all_level_comps_ctr).required_quantity||
3513: ', and bill_qpa = '||t_comp_details(l_all_level_comps_ctr).BILL_QUANTITY_PER_ASSEMBLY);
3514: END IF;
3515:

Line 3767: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCOR (ph) for we_id='||p_wip_entity_id);

3763: cur_resc.ORIGINAL_SYSTEM_REFERENCE
3764: );
3765:
3766: IF (g_debug = 'Y') THEN
3767: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCOR (ph) for we_id='||p_wip_entity_id);
3768: END IF;
3769:
3770: END LOOP;
3771: END;

Line 3801: fnd_file.put_line(fnd_file.log, 'Get_Job_Curr_Op_Info returned : '||

3797:
3798:
3799:
3800: IF (g_debug = 'Y') THEN
3801: fnd_file.put_line(fnd_file.log, 'Get_Job_Curr_Op_Info returned : '||
3802: 'l_curr_op_seq_num ='||l_curr_op_seq_num ||
3803: ', l_curr_op_seq_id ='||l_curr_op_seq_id ||
3804: ', l_curr_op_std_op_id ='||l_curr_op_std_op_id ||
3805: ', l_curr_op_dept_id ='||l_curr_op_dept_id ||

Line 3834: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||') : l_is_curr_op_reco='||l_is_curr_op_reco);

3830: END;
3831:
3832:
3833: IF (g_debug = 'Y') THEN
3834: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||') : l_is_curr_op_reco='||l_is_curr_op_reco);
3835: END IF;
3836:
3837: ELSIF (l_err_code = -1) THEN -- No WO records
3838: -- Scenario : Job creation

Line 3851: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||') : l_is_curr_op_reco='||l_is_curr_op_reco||

3847: AND network_start_end = l_network_start; --'S'; --Fixed bug #3761385
3848:
3849:
3850: IF (g_debug = 'Y') THEN
3851: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||') : l_is_curr_op_reco='||l_is_curr_op_reco||
3852: ', and l_curr_op_seq_num='||l_curr_op_seq_num);
3853: END IF;
3854:
3855: -- Start : Additions to fix bug #3677276

Line 3932: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);

3928: IF (SQL%ROWCOUNT = 0) THEN
3929: -- No record created in WSM_LOT_BASED_JOBS
3930: fnd_message.set_name('WSM', 'WSM_NO_WLBJ_REC');
3931: x_err_buf := fnd_message.get;
3932: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
3933: x_err_code := -2; -- Error
3934:
3935: return;
3936: ELSE

Line 3943: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WLBJ for we_id='||p_wip_entity_id);

3939: END IF;
3940:
3941:
3942: IF (g_debug = 'Y') THEN
3943: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WLBJ for we_id='||p_wip_entity_id);
3944: END IF;
3945:
3946: l_stmt_num := 330;
3947:

Line 3998: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||

3994: p_charges_exist => p_charges_exist
3995: );
3996:
3997: IF (g_debug = 'Y') THEN
3998: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||
3999: '): WSM_infinite_scheduler_PVT.schedule returned '||l_inf_sch_returnStatus);
4000: END IF;
4001:
4002: -- Start : We do not need to error if Inf Sch fails, since dates will be calculated while moving --

Line 4005: fnd_file.put_line(fnd_file.log, 'Warning : Could not infinite schedule the job successfully');

4001:
4002: -- Start : We do not need to error if Inf Sch fails, since dates will be calculated while moving --
4003: IF(l_inf_sch_returnStatus <> FND_API.G_RET_STS_SUCCESS) THEN
4004:
4005: fnd_file.put_line(fnd_file.log, 'Warning : Could not infinite schedule the job successfully');
4006: fnd_file.put_line(fnd_file.log, l_err_buf);
4007: x_err_code := -1; --Warning
4008: x_err_buf := l_err_buf;
4009: END IF;

Line 4006: fnd_file.put_line(fnd_file.log, l_err_buf);

4002: -- Start : We do not need to error if Inf Sch fails, since dates will be calculated while moving --
4003: IF(l_inf_sch_returnStatus <> FND_API.G_RET_STS_SUCCESS) THEN
4004:
4005: fnd_file.put_line(fnd_file.log, 'Warning : Could not infinite schedule the job successfully');
4006: fnd_file.put_line(fnd_file.log, l_err_buf);
4007: x_err_code := -1; --Warning
4008: x_err_buf := l_err_buf;
4009: END IF;
4010: -- End : We do not need to error if Inf Sch fails,

Line 4039: fnd_file.put_line(fnd_file.log, x_err_buf);

4035:
4036: EXCEPTION
4037: WHEN be_exploder_exception THEN
4038: x_err_buf := 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||') : '||x_err_buf;
4039: fnd_file.put_line(fnd_file.log, x_err_buf);
4040:
4041: WHEN loop_in_bom_exception THEN
4042: x_err_buf := 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||') : '||x_err_buf;
4043: fnd_file.put_line(fnd_file.log, x_err_buf);

Line 4043: fnd_file.put_line(fnd_file.log, x_err_buf);

4039: fnd_file.put_line(fnd_file.log, x_err_buf);
4040:
4041: WHEN loop_in_bom_exception THEN
4042: x_err_buf := 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||') : '||x_err_buf;
4043: fnd_file.put_line(fnd_file.log, x_err_buf);
4044:
4045: WHEN e_proc_error THEN
4046: x_err_buf := 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||') : '||x_err_buf;
4047: fnd_file.put_line(fnd_file.log, x_err_buf);

Line 4047: fnd_file.put_line(fnd_file.log, x_err_buf);

4043: fnd_file.put_line(fnd_file.log, x_err_buf);
4044:
4045: WHEN e_proc_error THEN
4046: x_err_buf := 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||') : '||x_err_buf;
4047: fnd_file.put_line(fnd_file.log, x_err_buf);
4048:
4049: --Bug 4264364:Added exception handling
4050: WHEN e_noneff_op THEN
4051: x_err_buf := 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||') : '||x_err_buf;

Line 4052: fnd_file.put_line(fnd_file.log, x_err_buf);

4048:
4049: --Bug 4264364:Added exception handling
4050: WHEN e_noneff_op THEN
4051: x_err_buf := 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||') : '||x_err_buf;
4052: fnd_file.put_line(fnd_file.log, x_err_buf);
4053:
4054: WHEN others THEN
4055: x_err_code := SQLCODE;
4056: x_err_buf := 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);

Line 4057: fnd_file.put_line(fnd_file.log, x_err_buf);

4053:
4054: WHEN others THEN
4055: x_err_code := SQLCODE;
4056: x_err_buf := 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
4057: fnd_file.put_line(fnd_file.log, x_err_buf);
4058:
4059: END Create_JobCopies;
4060:
4061:

Line 4115: fnd_file.put_line(fnd_file.log, 'Parameters to Create_RepJobCopies are :\\n');

4111:
4112: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');
4113:
4114: IF (g_debug = 'Y') THEN
4115: fnd_file.put_line(fnd_file.log, 'Parameters to Create_RepJobCopies are :\\n');
4116: fnd_file.put_line(fnd_file.log, ' p_rep_wip_entity_id ='||p_rep_wip_entity_id );
4117: fnd_file.put_line(fnd_file.log, ', p_new_wip_entity_id ='||p_new_wip_entity_id );
4118: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
4119: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );

Line 4116: fnd_file.put_line(fnd_file.log, ' p_rep_wip_entity_id ='||p_rep_wip_entity_id );

4112: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');
4113:
4114: IF (g_debug = 'Y') THEN
4115: fnd_file.put_line(fnd_file.log, 'Parameters to Create_RepJobCopies are :\\n');
4116: fnd_file.put_line(fnd_file.log, ' p_rep_wip_entity_id ='||p_rep_wip_entity_id );
4117: fnd_file.put_line(fnd_file.log, ', p_new_wip_entity_id ='||p_new_wip_entity_id );
4118: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
4119: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
4120: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );

Line 4117: fnd_file.put_line(fnd_file.log, ', p_new_wip_entity_id ='||p_new_wip_entity_id );

4113:
4114: IF (g_debug = 'Y') THEN
4115: fnd_file.put_line(fnd_file.log, 'Parameters to Create_RepJobCopies are :\\n');
4116: fnd_file.put_line(fnd_file.log, ' p_rep_wip_entity_id ='||p_rep_wip_entity_id );
4117: fnd_file.put_line(fnd_file.log, ', p_new_wip_entity_id ='||p_new_wip_entity_id );
4118: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
4119: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
4120: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
4121: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );

Line 4118: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );

4114: IF (g_debug = 'Y') THEN
4115: fnd_file.put_line(fnd_file.log, 'Parameters to Create_RepJobCopies are :\\n');
4116: fnd_file.put_line(fnd_file.log, ' p_rep_wip_entity_id ='||p_rep_wip_entity_id );
4117: fnd_file.put_line(fnd_file.log, ', p_new_wip_entity_id ='||p_new_wip_entity_id );
4118: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
4119: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
4120: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
4121: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
4122: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );

Line 4119: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );

4115: fnd_file.put_line(fnd_file.log, 'Parameters to Create_RepJobCopies are :\\n');
4116: fnd_file.put_line(fnd_file.log, ' p_rep_wip_entity_id ='||p_rep_wip_entity_id );
4117: fnd_file.put_line(fnd_file.log, ', p_new_wip_entity_id ='||p_new_wip_entity_id );
4118: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
4119: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
4120: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
4121: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
4122: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
4123: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );

Line 4120: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );

4116: fnd_file.put_line(fnd_file.log, ' p_rep_wip_entity_id ='||p_rep_wip_entity_id );
4117: fnd_file.put_line(fnd_file.log, ', p_new_wip_entity_id ='||p_new_wip_entity_id );
4118: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
4119: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
4120: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
4121: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
4122: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
4123: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
4124: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );

Line 4121: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );

4117: fnd_file.put_line(fnd_file.log, ', p_new_wip_entity_id ='||p_new_wip_entity_id );
4118: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
4119: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
4120: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
4121: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
4122: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
4123: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
4124: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
4125: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );

Line 4122: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );

4118: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
4119: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
4120: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
4121: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
4122: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
4123: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
4124: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
4125: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
4126: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );

Line 4123: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );

4119: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
4120: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
4121: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
4122: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
4123: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
4124: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
4125: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
4126: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
4127: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );

Line 4124: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );

4120: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
4121: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
4122: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
4123: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
4124: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
4125: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
4126: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
4127: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );
4128: fnd_file.put_line(fnd_file.log, ', p_inf_sch_mode ='||p_inf_sch_mode );

Line 4125: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );

4121: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
4122: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
4123: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
4124: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
4125: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
4126: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
4127: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );
4128: fnd_file.put_line(fnd_file.log, ', p_inf_sch_mode ='||p_inf_sch_mode );
4129: fnd_file.put_line(fnd_file.log, ', p_inf_sch_date ='||p_inf_sch_date );

Line 4126: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );

4122: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
4123: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
4124: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
4125: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
4126: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
4127: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );
4128: fnd_file.put_line(fnd_file.log, ', p_inf_sch_mode ='||p_inf_sch_mode );
4129: fnd_file.put_line(fnd_file.log, ', p_inf_sch_date ='||p_inf_sch_date );
4130: END IF;

Line 4127: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );

4123: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
4124: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
4125: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
4126: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
4127: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );
4128: fnd_file.put_line(fnd_file.log, ', p_inf_sch_mode ='||p_inf_sch_mode );
4129: fnd_file.put_line(fnd_file.log, ', p_inf_sch_date ='||p_inf_sch_date );
4130: END IF;
4131:

Line 4128: fnd_file.put_line(fnd_file.log, ', p_inf_sch_mode ='||p_inf_sch_mode );

4124: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
4125: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
4126: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
4127: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );
4128: fnd_file.put_line(fnd_file.log, ', p_inf_sch_mode ='||p_inf_sch_mode );
4129: fnd_file.put_line(fnd_file.log, ', p_inf_sch_date ='||p_inf_sch_date );
4130: END IF;
4131:
4132:

Line 4129: fnd_file.put_line(fnd_file.log, ', p_inf_sch_date ='||p_inf_sch_date );

4125: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
4126: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
4127: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );
4128: fnd_file.put_line(fnd_file.log, ', p_inf_sch_mode ='||p_inf_sch_mode );
4129: fnd_file.put_line(fnd_file.log, ', p_inf_sch_date ='||p_inf_sch_date );
4130: END IF;
4131:
4132:
4133:

Line 4136: fnd_file.put_line(fnd_file.log, 'In Create_RepJobCopies: Rep. we_id ='||p_rep_wip_entity_id||

4132:
4133:
4134:
4135: IF (g_debug = 'Y') THEN
4136: fnd_file.put_line(fnd_file.log, 'In Create_RepJobCopies: Rep. we_id ='||p_rep_wip_entity_id||
4137: ', new we_id ='||p_new_wip_entity_id);
4138: END IF;
4139:
4140: l_stmt_num := 10;

Line 4151: fnd_file.put_line(fnd_file.log, x_err_buf);

4147: )
4148: THEN
4149: x_err_code := -1;
4150: x_err_buf := 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): Invalid Infinite Scheduling Mode';
4151: fnd_file.put_line(fnd_file.log, x_err_buf);
4152: return;
4153: END IF;
4154:
4155: -- The following deletes will be needed, in case the API is to be made public

Line 4261: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCON for we_id='||p_new_wip_entity_id);

4257:
4258:
4259:
4260: IF (g_debug = 'Y') THEN
4261: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCON for we_id='||p_new_wip_entity_id);
4262: END IF;
4263:
4264: -- ***** Make a copy of the Routing for the job ***** --
4265: l_stmt_num := 30;

Line 4429: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCO for we_id='||p_new_wip_entity_id);

4425:
4426:
4427:
4428: IF (g_debug = 'Y') THEN
4429: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCO for we_id='||p_new_wip_entity_id);
4430: END IF;
4431:
4432: -- ***** Make a copy of the primary Resources for the job ***** --
4433: l_stmt_num := 40;

Line 4601: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCOR for we_id='||p_new_wip_entity_id);

4597:
4598:
4599:
4600: IF (g_debug = 'Y') THEN
4601: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCOR for we_id='||p_new_wip_entity_id);
4602: END IF;
4603:
4604: /* ST : Detailed Scheduling */
4605:

Line 4644: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCORI for we_id='||p_new_wip_entity_id);

4640: FROM WSM_COPY_OP_RESOURCE_INSTANCES
4641: WHERE wip_entity_id = p_rep_wip_entity_id;
4642:
4643: IF (g_debug = 'Y') THEN
4644: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCORI for we_id='||p_new_wip_entity_id);
4645: END IF;
4646:
4647: /* ST : Detailed Scheduling end */
4648:

Line 4834: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCRO for we_id='||p_new_wip_entity_id);

4830:
4831:
4832:
4833: IF (g_debug = 'Y') THEN
4834: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCRO for we_id='||p_new_wip_entity_id);
4835: END IF;
4836:
4837: -- Do not need to make copies for Resource Usages and Instances,
4838: -- since these will be set with planning runs next and picks up this job.

Line 4893: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WLBJ for we_id='||p_new_wip_entity_id);

4889:
4890:
4891:
4892: IF (g_debug = 'Y') THEN
4893: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WLBJ for we_id='||p_new_wip_entity_id);
4894: END IF;
4895:
4896: IF (p_inf_sch_flag = 'Y') THEN
4897:

Line 4925: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_RepJobCopies('||l_stmt_num||'): '||

4921: IF (x_err_code = -1) -- No WO records
4922: OR (x_err_code = -2) -- Invalid job
4923: OR (x_err_code <> 0) -- Some other error
4924: THEN
4925: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_RepJobCopies('||l_stmt_num||'): '||
4926: 'Get_Job_Curr_Op_Info returned '||x_err_code);
4927: fnd_file.put_line(fnd_file.log, 'Get_Job_Curr_Op_Info returned l_curr_op_seq_num='||l_curr_op_seq_num);
4928: return;
4929: END IF;

Line 4927: fnd_file.put_line(fnd_file.log, 'Get_Job_Curr_Op_Info returned l_curr_op_seq_num='||l_curr_op_seq_num);

4923: OR (x_err_code <> 0) -- Some other error
4924: THEN
4925: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_RepJobCopies('||l_stmt_num||'): '||
4926: 'Get_Job_Curr_Op_Info returned '||x_err_code);
4927: fnd_file.put_line(fnd_file.log, 'Get_Job_Curr_Op_Info returned l_curr_op_seq_num='||l_curr_op_seq_num);
4928: return;
4929: END IF;
4930:
4931: IF (p_inf_sch_mode IS NULL) THEN

Line 4965: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_RepJobCopies('||l_stmt_num||

4961: );
4962:
4963:
4964: IF (g_debug = 'Y') THEN
4965: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_RepJobCopies('||l_stmt_num||
4966: '): WSM_infinite_scheduler_PVT.schedule returned '||l_inf_sch_returnStatus);
4967: END IF;
4968:
4969: -- Start : We do not need to error if Inf Sch fails, since dates will be calculated while moving --

Line 4971: fnd_file.put_line(fnd_file.log, 'Warning : Could not infinite schedule the job successfully');

4967: END IF;
4968:
4969: -- Start : We do not need to error if Inf Sch fails, since dates will be calculated while moving --
4970: IF(l_inf_sch_returnStatus <> FND_API.G_RET_STS_SUCCESS) THEN
4971: fnd_file.put_line(fnd_file.log, 'Warning : Could not infinite schedule the job successfully');
4972: fnd_file.put_line(fnd_file.log, x_err_buf);
4973: END IF;
4974: x_err_code := 0;
4975: -- End : We do not need to error if Inf Sch fails, since dates will be calculated while moving --

Line 4972: fnd_file.put_line(fnd_file.log, x_err_buf);

4968:
4969: -- Start : We do not need to error if Inf Sch fails, since dates will be calculated while moving --
4970: IF(l_inf_sch_returnStatus <> FND_API.G_RET_STS_SUCCESS) THEN
4971: fnd_file.put_line(fnd_file.log, 'Warning : Could not infinite schedule the job successfully');
4972: fnd_file.put_line(fnd_file.log, x_err_buf);
4973: END IF;
4974: x_err_code := 0;
4975: -- End : We do not need to error if Inf Sch fails, since dates will be calculated while moving --
4976:

Line 4986: fnd_file.put_line(fnd_file.log, x_err_buf);

4982:
4983: WHEN e_proc_error THEN
4984: -- x_err_code := SQLCODE;
4985: x_err_buf := 'WSM_JobCopies_PVT.Create_RepJobCopies('||l_stmt_num||') : '||x_err_buf;
4986: fnd_file.put_line(fnd_file.log, x_err_buf);
4987:
4988: WHEN others THEN
4989: x_err_code := SQLCODE;
4990: x_err_buf := 'WSM_JobCopies_PVT.Create_RepJobCopies('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);

Line 4991: fnd_file.put_line(fnd_file.log, x_err_buf);

4987:
4988: WHEN others THEN
4989: x_err_code := SQLCODE;
4990: x_err_buf := 'WSM_JobCopies_PVT.Create_RepJobCopies('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
4991: fnd_file.put_line(fnd_file.log, x_err_buf);
4992:
4993: END Create_RepJobCopies;
4994:
4995:

Line 5133: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||

5129:
5130: l_stmt_num := 40;
5131:
5132: IF (to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING')) = 1) THEN
5133: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
5134: '): Value of profile "WSM: Create Lot Based Jobs Copy Routing" is YES.');
5135: fnd_file.put_line(fnd_file.log, 'Oracle Shopfloor Management is already upgraded to create Lot Based Job Copy Routing. Upgrade failed.');
5136: raise e_upg_error;
5137: ELSIF (to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING')) = 2) THEN

Line 5135: fnd_file.put_line(fnd_file.log, 'Oracle Shopfloor Management is already upgraded to create Lot Based Job Copy Routing. Upgrade failed.');

5131:
5132: IF (to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING')) = 1) THEN
5133: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
5134: '): Value of profile "WSM: Create Lot Based Jobs Copy Routing" is YES.');
5135: fnd_file.put_line(fnd_file.log, 'Oracle Shopfloor Management is already upgraded to create Lot Based Job Copy Routing. Upgrade failed.');
5136: raise e_upg_error;
5137: ELSIF (to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING')) = 2) THEN
5138: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
5139: '): Value of profile "WSM: Create Lot Based Jobs Copy Routing" is NO.');

Line 5138: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||

5134: '): Value of profile "WSM: Create Lot Based Jobs Copy Routing" is YES.');
5135: fnd_file.put_line(fnd_file.log, 'Oracle Shopfloor Management is already upgraded to create Lot Based Job Copy Routing. Upgrade failed.');
5136: raise e_upg_error;
5137: ELSIF (to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING')) = 2) THEN
5138: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
5139: '): Value of profile "WSM: Create Lot Based Jobs Copy Routing" is NO.');
5140: fnd_file.put_line(fnd_file.log, 'Upgrading Lot Based Jobs to Use Copy Routings ...');
5141: ELSE
5142: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||

Line 5140: fnd_file.put_line(fnd_file.log, 'Upgrading Lot Based Jobs to Use Copy Routings ...');

5136: raise e_upg_error;
5137: ELSIF (to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING')) = 2) THEN
5138: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
5139: '): Value of profile "WSM: Create Lot Based Jobs Copy Routing" is NO.');
5140: fnd_file.put_line(fnd_file.log, 'Upgrading Lot Based Jobs to Use Copy Routings ...');
5141: ELSE
5142: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
5143: '): Not able to fetch the value of the profile "WSM: Create Lot Based Jobs Copy Routing".');
5144: raise e_profile_error;

Line 5142: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||

5138: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
5139: '): Value of profile "WSM: Create Lot Based Jobs Copy Routing" is NO.');
5140: fnd_file.put_line(fnd_file.log, 'Upgrading Lot Based Jobs to Use Copy Routings ...');
5141: ELSE
5142: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
5143: '): Not able to fetch the value of the profile "WSM: Create Lot Based Jobs Copy Routing".');
5144: raise e_profile_error;
5145: END IF;
5146:

Line 5147: fnd_file.put_line(fnd_file.log, 'Upgrade Start Time : '||to_char(sysdate,'DD-MON-YY HH24:MI:SS')||'');

5143: '): Not able to fetch the value of the profile "WSM: Create Lot Based Jobs Copy Routing".');
5144: raise e_profile_error;
5145: END IF;
5146:
5147: fnd_file.put_line(fnd_file.log, '*****Upgrade Start Time : '||to_char(sysdate,'DD-MON-YY HH24:MI:SS')||'*****');
5148:
5149: l_counter := 0;
5150:
5151: BEGIN -- {

Line 5180: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||

5176:
5177: l_curr_rows := upgrade_jobs%rowcount;
5178: CLOSE upgrade_jobs;
5179:
5180: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
5181: '): Number of rows loaded for the current batch: '||l_curr_rows);
5182: IF (l_curr_rows = 0) THEN
5183: exit;
5184: END IF;

Line 5186: fnd_file.put_line(fnd_file.log, 'After Bulk fetch : '||to_char(sysdate,'DD-MON-YY HH24:MI:SS')||'');

5182: IF (l_curr_rows = 0) THEN
5183: exit;
5184: END IF;
5185:
5186: fnd_file.put_line(fnd_file.log, '*****After Bulk fetch : '||to_char(sysdate,'DD-MON-YY HH24:MI:SS')||'*****');
5187:
5188: l_counter := v_job_wip_entity_id.first;
5189: WHILE l_counter is NOT NULL
5190: LOOP --{

Line 5240: fnd_file.put_line(fnd_file.log, l_stmt_num ||' x_err_code='||x_err_code);

5236: );
5237:
5238: l_stmt_num := 70;
5239: IF (g_debug = 'Y') THEN
5240: fnd_file.put_line(fnd_file.log, l_stmt_num ||' x_err_code='||x_err_code);
5241: END IF;
5242:
5243: IF ((x_err_code = 0) OR (x_err_code IS NULL)) THEN
5244: l_stmt_num := 71;

Line 5245: fnd_file.put_line(fnd_file.log,

5241: END IF;
5242:
5243: IF ((x_err_code = 0) OR (x_err_code IS NULL)) THEN
5244: l_stmt_num := 71;
5245: fnd_file.put_line(fnd_file.log,
5246: l_all_jobs_ctr+1||' '||
5247: 'Organization id='||v_job_organization_id(l_counter)||'; '||
5248: ' Job: '||v_job_wip_entity_name(l_counter)||
5249: ' (id='||v_job_wip_entity_id(l_counter)||') '||

Line 5255: fnd_file.put_line(fnd_file.log,

5251:
5252:
5253: ELSIF (x_err_code = -1) THEN -- Warning
5254: l_stmt_num := 72;
5255: fnd_file.put_line(fnd_file.log,
5256: l_all_jobs_ctr+1||' '||
5257: 'Organization id='||v_job_organization_id(l_counter)||'; '||
5258: ' Job: '||v_job_wip_entity_name(l_counter)||
5259: ' (id='||v_job_wip_entity_id(l_counter)||') '||

Line 5265: fnd_file.put_line(fnd_file.log,

5261: ' WARNING : '||x_err_buf);
5262:
5263: ELSE -- Error
5264: l_stmt_num := 73;
5265: fnd_file.put_line(fnd_file.log,
5266: l_all_jobs_ctr+1||' '||
5267: 'Organization id='||v_job_organization_id(l_counter)||'; '||
5268: ' Job: '||v_job_wip_entity_name(l_counter)||
5269: ' (id='||v_job_wip_entity_id(l_counter)||') '||

Line 5401: fnd_file.put_line(fnd_file.log, 'Upgrade End Time : '||to_char(sysdate,'DD-MON-YY HH24:MI:SS')||'');

5397:
5398: l_stmt_num := 130;
5399: COMMIT;
5400:
5401: fnd_file.put_line(fnd_file.log, '*****Upgrade End Time : '||to_char(sysdate,'DD-MON-YY HH24:MI:SS')||'*****');
5402: fnd_file.put_line(fnd_file.log, 'Upgraded '||l_all_jobs_ctr||' jobs in total');
5403:
5404: fnd_file.put_line(fnd_file.log, 'Upgrade failed to create Job Copies for following '||l_err_ctr||' jobs : ');
5405: l_stmt_num := 140;

Line 5402: fnd_file.put_line(fnd_file.log, 'Upgraded '||l_all_jobs_ctr||' jobs in total');

5398: l_stmt_num := 130;
5399: COMMIT;
5400:
5401: fnd_file.put_line(fnd_file.log, '*****Upgrade End Time : '||to_char(sysdate,'DD-MON-YY HH24:MI:SS')||'*****');
5402: fnd_file.put_line(fnd_file.log, 'Upgraded '||l_all_jobs_ctr||' jobs in total');
5403:
5404: fnd_file.put_line(fnd_file.log, 'Upgrade failed to create Job Copies for following '||l_err_ctr||' jobs : ');
5405: l_stmt_num := 140;
5406:

Line 5404: fnd_file.put_line(fnd_file.log, 'Upgrade failed to create Job Copies for following '||l_err_ctr||' jobs : ');

5400:
5401: fnd_file.put_line(fnd_file.log, '*****Upgrade End Time : '||to_char(sysdate,'DD-MON-YY HH24:MI:SS')||'*****');
5402: fnd_file.put_line(fnd_file.log, 'Upgraded '||l_all_jobs_ctr||' jobs in total');
5403:
5404: fnd_file.put_line(fnd_file.log, 'Upgrade failed to create Job Copies for following '||l_err_ctr||' jobs : ');
5405: l_stmt_num := 140;
5406:
5407: FOR l_jobs_counter in 0..l_err_ctr-1
5408: LOOP

Line 5412: fnd_file.put_line(fnd_file.log,

5408: LOOP
5409: l_stmt_num := 141;
5410: IF (t_err_upgrade_jobs(l_jobs_counter).upg_success = 2) THEN
5411: l_stmt_num := 142;
5412: fnd_file.put_line(fnd_file.log,
5413: l_jobs_counter+1||' '||
5414: 'Organization id='||t_err_upgrade_jobs(l_jobs_counter).organization_id||'; '||
5415: ' Job: '||t_err_upgrade_jobs(l_jobs_counter).wip_entity_name||
5416: ' (id='||t_err_upgrade_jobs(l_jobs_counter).wip_entity_id||') '||

Line 5425: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||')'||

5421:
5422: l_stmt_num := 144;
5423: t_err_upgrade_jobs.delete;
5424:
5425: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||')'||
5426: 'Please correct the problem and run Refresh Open Jobs Copies for the above '||l_err_ctr||' jobs. ');
5427:
5428: l_stmt_num := 150;
5429:

Line 5432: fnd_file.put_line(fnd_file.log, 'Set the profile "WSM: Create Lot Based Jobs Copy Routing" to YES. '||

5428: l_stmt_num := 150;
5429:
5430: l_ret_val := fnd_profile.save('WSM_CREATE_LBJ_COPY_ROUTING', '1', 'SITE');
5431:
5432: fnd_file.put_line(fnd_file.log, 'Set the profile "WSM: Create Lot Based Jobs Copy Routing" to YES. '||
5433: 'Upgrade successful. ');
5434:
5435: COMMIT;
5436:

Line 5449: fnd_file.put_line(fnd_file.log, x_err_buf);

5445:
5446: WHEN others THEN
5447: x_err_code := SQLCODE;
5448: x_err_buf := 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
5449: fnd_file.put_line(fnd_file.log, x_err_buf);
5450:
5451: END Upgrade_JobCopies;
5452:
5453: PROCEDURE process_wip_info( p_wip_entity_id IN NUMBER,

Line 6037: fnd_file.put_line(fnd_file.log, x_err_buf);

6033: exception
6034: WHEN others THEN
6035: x_err_code := SQLCODE;
6036: x_err_buf := 'WSM_JobCopies_PVT.process_wip_info('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
6037: fnd_file.put_line(fnd_file.log, x_err_buf);
6038: END process_wip_info;
6039:
6040: FUNCTION max_res_seq (p_op_seq_id NUMBER) return NUMBER
6041: IS