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 930: fnd_file.put_line(fnd_file.log, 'Parameters to Create_JobCopies are :');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1768: AND br.ORGANIZATION_ID = p_org_id;
1769:
1770: IF SQL%ROWCOUNT > 0 THEN --Added for 4635447
1771: IF (g_debug = 'Y') THEN
1772: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCOR (pri res) for we_id='||p_wip_entity_id);
1773: END IF;
1774:
1775: --IF SQL%ROWCOUNT > 0 THEN --Bug 4635477
1776: --Look for substitute resources only when at least one primary resource

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

1922: AND bsor.RESOURCE_ID = br.RESOURCE_ID
1923: AND WCO.OPERATION_SEQUENCE_ID = bsor.OPERATION_SEQUENCE_ID;
1924:
1925: IF (g_debug = 'Y') THEN
1926: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCOR (subs res) for we_id='||p_wip_entity_id);
1927: END IF;
1928: END IF;--Check on SQL%ROWCOUNT
1929:
1930: if p_phantom_exists = 2 and p_common_bill_seq_id IS NOT NULL THEN --Code review remark

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

2181: AND p_bom_rev_date between a.effectivity_date and nvl(a.disable_date, p_bom_rev_date+1);
2182:
2183: IF SQL%ROWCOUNT > 0 THEN
2184: IF (g_debug = 'Y') THEN
2185: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCR) (Primary Components) for we_id='||p_wip_entity_id);
2186: END IF;
2187: --IF SQL%ROWCOUNT > 0 THEN
2188: --Insert substitute components only when there are primary components.
2189: INSERT INTO WSM_COPY_REQUIREMENT_OPS

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

2393:
2394: l_stmt_num := 160;
2395:
2396: IF (g_debug = 'Y') THEN
2397: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): Parameters to exploder_userexit for 1st level explosion :');
2398: fnd_file.put_line(fnd_file.log, 'expl_group_id ='||l_explosion_group_id||
2399: ', Bill item_id='||p_bill_item_id||
2400: ', alt_desg='||p_alt_bom_desig||
2401: ', comp_code=NULL');

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

2394: l_stmt_num := 160;
2395:
2396: IF (g_debug = 'Y') THEN
2397: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): Parameters to exploder_userexit for 1st level explosion :');
2398: fnd_file.put_line(fnd_file.log, 'expl_group_id ='||l_explosion_group_id||
2399: ', Bill item_id='||p_bill_item_id||
2400: ', alt_desg='||p_alt_bom_desig||
2401: ', comp_code=NULL');
2402: END IF;

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

2454: INTO l_be_count
2455: FROM BOM_EXPLOSION_TEMP
2456: WHERE group_id = l_explosion_group_id;
2457:
2458: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): '||
2459: ' l_explosion_group_id ='||l_explosion_group_id||
2460: ', l_be_count ='||l_be_count||
2461: ', l_op_seq_one_exists_in_ntwk='||l_op_seq_one_exists_in_ntwk);
2462: END IF;

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

2487:
2488:
2489: -- Moved the comments down and added l_curr_first_op_attach_opseq1
2490: IF (g_debug = 'Y') THEN
2491: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): '||
2492: ' l_curr_op_seq_num ='||l_curr_op_seq_num ||
2493: ', l_curr_op_seq_id ='||l_curr_op_seq_id ||
2494: ', l_curr_op_is_ntwk_st_end ='||l_curr_op_is_ntwk_st_end ||
2495: ', l_curr_op_start_date ='||l_curr_op_start_date ||

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

2514: END;
2515:
2516:
2517: IF (g_debug = 'Y') THEN
2518: fnd_file.put_line(fnd_file.log, 'l_curr_op_total_comps at stmt('||l_stmt_num||'): '||l_curr_op_total_comps);
2519: END IF;
2520:
2521: l_curr_op_first_level_comps:=l_curr_op_total_comps;
2522: l_first_level_comps_ctr:=0;

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

2529:
2530: l_stmt_num := 180;
2531:
2532: IF (g_debug = 'Y') THEN
2533: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): '||
2534: ' Phantom found at op'||t_comp_details(l_first_level_comps_ctr).operation_seq_num);
2535: END IF;
2536:
2537: t_comp_details(l_first_level_comps_ctr).operation_seq_num :=-l_curr_op_seq_num;

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

2583: END;
2584:
2585:
2586: IF (g_debug = 'Y') THEN
2587: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): '||
2588: 'l_phantom_reqd_qty = '||l_phantom_reqd_qty||
2589: ', l_phantom_bill_seq_id = '||l_phantom_bill_seq_id||
2590: ', l_phantom_rtg_seq_id= '||l_phantom_rtg_seq_id ||
2591: ', l_phantom_org_id = '||l_phantom_org_id);

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

2603: l_stmt_num := 210;
2604:
2605:
2606: IF (g_debug = 'Y') THEN
2607: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): Parameters to exploder_userexit for exploding all levels :');
2608: fnd_file.put_line(fnd_file.log, 'expl_group_id ='||l_phantom_expl_group_id||
2609: ', item_id='||t_comp_details(l_first_level_comps_ctr).component_item_id||
2610: ', alt_desg=NULL'||
2611: ', comp_code='||p_bill_item_id);

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

2604:
2605:
2606: IF (g_debug = 'Y') THEN
2607: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): Parameters to exploder_userexit for exploding all levels :');
2608: fnd_file.put_line(fnd_file.log, 'expl_group_id ='||l_phantom_expl_group_id||
2609: ', item_id='||t_comp_details(l_first_level_comps_ctr).component_item_id||
2610: ', alt_desg=NULL'||
2611: ', comp_code='||p_bill_item_id);
2612: END IF;

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

2646: INTO l_be_count
2647: FROM BOM_EXPLOSION_TEMP
2648: WHERE group_id = l_phantom_expl_group_id;
2649:
2650: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): '||
2651: ' l_phantom_expl_group_id ='||l_phantom_expl_group_id||
2652: ', l_be_count ='||l_be_count);
2653: END IF;
2654:

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

2738:
2739:
2740: IF (g_debug = 'Y') THEN
2741:
2742: fnd_file.put_line(fnd_file.log, 'Before phan_comp '||
2743: ' PRIMARY_COMPONENT_ID = '||t_comp_details(l_first_level_comps_ctr).PRIMARY_COMPONENT_ID||
2744: ', COMPONENT_ITEM_ID = '||t_comp_details(l_first_level_comps_ctr).COMPONENT_ITEM_ID||
2745: ', l_phantom_reqd_qty = '||l_phantom_reqd_qty||
2746: ', l_phantom_bill_seq_id = '||l_phantom_bill_seq_id);

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

3031: THEN
3032:
3033:
3034: IF (g_debug = 'Y') THEN
3035: fnd_file.put_line(fnd_file.log, '******START**************');
3036: fnd_file.put_line(fnd_file.log,
3037: '(l_all_level_comps_ctr).component_item_id='||t_comp_details(l_all_level_comps_ctr).component_item_id||
3038: ', (l_all_level_comps_subctr).component_item_id='||t_comp_details(l_all_level_comps_subctr).component_item_id);
3039: fnd_file.put_line(fnd_file.log,

Line 3036: fnd_file.put_line(fnd_file.log,

3032:
3033:
3034: IF (g_debug = 'Y') THEN
3035: fnd_file.put_line(fnd_file.log, '******START**************');
3036: fnd_file.put_line(fnd_file.log,
3037: '(l_all_level_comps_ctr).component_item_id='||t_comp_details(l_all_level_comps_ctr).component_item_id||
3038: ', (l_all_level_comps_subctr).component_item_id='||t_comp_details(l_all_level_comps_subctr).component_item_id);
3039: fnd_file.put_line(fnd_file.log,
3040: '(l_all_level_comps_ctr).primary_component_id='||t_comp_details(l_all_level_comps_ctr).primary_component_id||

Line 3039: fnd_file.put_line(fnd_file.log,

3035: fnd_file.put_line(fnd_file.log, '******START**************');
3036: fnd_file.put_line(fnd_file.log,
3037: '(l_all_level_comps_ctr).component_item_id='||t_comp_details(l_all_level_comps_ctr).component_item_id||
3038: ', (l_all_level_comps_subctr).component_item_id='||t_comp_details(l_all_level_comps_subctr).component_item_id);
3039: fnd_file.put_line(fnd_file.log,
3040: '(l_all_level_comps_ctr).primary_component_id='||t_comp_details(l_all_level_comps_ctr).primary_component_id||
3041: ', (l_all_level_comps_subctr).primary_component_id='||t_comp_details(l_all_level_comps_subctr).primary_component_id);
3042: fnd_file.put_line(fnd_file.log,
3043: '(l_all_level_comps_ctr).component_sequence_id='||t_comp_details(l_all_level_comps_ctr).component_sequence_id||

Line 3042: fnd_file.put_line(fnd_file.log,

3038: ', (l_all_level_comps_subctr).component_item_id='||t_comp_details(l_all_level_comps_subctr).component_item_id);
3039: fnd_file.put_line(fnd_file.log,
3040: '(l_all_level_comps_ctr).primary_component_id='||t_comp_details(l_all_level_comps_ctr).primary_component_id||
3041: ', (l_all_level_comps_subctr).primary_component_id='||t_comp_details(l_all_level_comps_subctr).primary_component_id);
3042: fnd_file.put_line(fnd_file.log,
3043: '(l_all_level_comps_ctr).component_sequence_id='||t_comp_details(l_all_level_comps_ctr).component_sequence_id||
3044: ', (l_all_level_comps_subctr).component_sequence_id='||t_comp_details(l_all_level_comps_subctr).component_sequence_id);
3045: fnd_file.put_line(fnd_file.log,
3046: '(l_all_level_comps_ctr).source_phantom_id='||t_comp_details(l_all_level_comps_ctr).source_phantom_id||

Line 3045: fnd_file.put_line(fnd_file.log,

3041: ', (l_all_level_comps_subctr).primary_component_id='||t_comp_details(l_all_level_comps_subctr).primary_component_id);
3042: fnd_file.put_line(fnd_file.log,
3043: '(l_all_level_comps_ctr).component_sequence_id='||t_comp_details(l_all_level_comps_ctr).component_sequence_id||
3044: ', (l_all_level_comps_subctr).component_sequence_id='||t_comp_details(l_all_level_comps_subctr).component_sequence_id);
3045: fnd_file.put_line(fnd_file.log,
3046: '(l_all_level_comps_ctr).source_phantom_id='||t_comp_details(l_all_level_comps_ctr).source_phantom_id||
3047: ', (l_all_level_comps_subctr).source_phantom_id='||t_comp_details(l_all_level_comps_subctr).source_phantom_id);
3048: fnd_file.put_line(fnd_file.log,
3049: '(l_all_level_comps_ctr).required_quantity='||t_comp_details(l_all_level_comps_ctr).required_quantity||

Line 3048: fnd_file.put_line(fnd_file.log,

3044: ', (l_all_level_comps_subctr).component_sequence_id='||t_comp_details(l_all_level_comps_subctr).component_sequence_id);
3045: fnd_file.put_line(fnd_file.log,
3046: '(l_all_level_comps_ctr).source_phantom_id='||t_comp_details(l_all_level_comps_ctr).source_phantom_id||
3047: ', (l_all_level_comps_subctr).source_phantom_id='||t_comp_details(l_all_level_comps_subctr).source_phantom_id);
3048: fnd_file.put_line(fnd_file.log,
3049: '(l_all_level_comps_ctr).required_quantity='||t_comp_details(l_all_level_comps_ctr).required_quantity||
3050: ', (l_all_level_comps_subctr).required_quantity='||t_comp_details(l_all_level_comps_subctr).required_quantity);
3051: fnd_file.put_line(fnd_file.log,
3052: '(l_all_level_comps_ctr).BILL_QUANTITY_PER_ASSEMBLY='||t_comp_details(l_all_level_comps_ctr).BILL_QUANTITY_PER_ASSEMBLY||

Line 3051: fnd_file.put_line(fnd_file.log,

3047: ', (l_all_level_comps_subctr).source_phantom_id='||t_comp_details(l_all_level_comps_subctr).source_phantom_id);
3048: fnd_file.put_line(fnd_file.log,
3049: '(l_all_level_comps_ctr).required_quantity='||t_comp_details(l_all_level_comps_ctr).required_quantity||
3050: ', (l_all_level_comps_subctr).required_quantity='||t_comp_details(l_all_level_comps_subctr).required_quantity);
3051: fnd_file.put_line(fnd_file.log,
3052: '(l_all_level_comps_ctr).BILL_QUANTITY_PER_ASSEMBLY='||t_comp_details(l_all_level_comps_ctr).BILL_QUANTITY_PER_ASSEMBLY||
3053: ', (l_all_level_comps_subctr).BILL_QUANTITY_PER_ASSEMBLY='||t_comp_details(l_all_level_comps_subctr).BILL_QUANTITY_PER_ASSEMBLY);
3054: fnd_file.put_line(fnd_file.log, '******END**************');
3055: END IF;

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

3050: ', (l_all_level_comps_subctr).required_quantity='||t_comp_details(l_all_level_comps_subctr).required_quantity);
3051: fnd_file.put_line(fnd_file.log,
3052: '(l_all_level_comps_ctr).BILL_QUANTITY_PER_ASSEMBLY='||t_comp_details(l_all_level_comps_ctr).BILL_QUANTITY_PER_ASSEMBLY||
3053: ', (l_all_level_comps_subctr).BILL_QUANTITY_PER_ASSEMBLY='||t_comp_details(l_all_level_comps_subctr).BILL_QUANTITY_PER_ASSEMBLY);
3054: fnd_file.put_line(fnd_file.log, '******END**************');
3055: END IF;
3056:
3057: IF (t_comp_details(l_all_level_comps_ctr).component_item_id =
3058: t_comp_details(l_all_level_comps_subctr).component_item_id)

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

3065: THEN
3066:
3067:
3068: IF (g_debug = 'Y') THEN
3069: fnd_file.put_line(fnd_file.log, 'MATCHING !!!!!!!!!!!!!');
3070: END IF;
3071:
3072: t_comp_details(l_all_level_comps_ctr).required_quantity :=
3073: t_comp_details(l_all_level_comps_ctr).required_quantity +

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

3275: t_comp_details(l_all_level_comps_ctr).ORIGINAL_SYSTEM_REFERENCE
3276: );
3277:
3278: IF (g_debug = 'Y') THEN
3279: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCRO for we_id='||p_wip_entity_id);
3280: fnd_file.put_line(fnd_file.log, 'for component='||t_comp_details(l_all_level_comps_ctr).component_item_id||
3281: ', and qpa = '||t_comp_details(l_all_level_comps_ctr).required_quantity||
3282: ', and bill_qpa = '||t_comp_details(l_all_level_comps_ctr).BILL_QUANTITY_PER_ASSEMBLY);
3283: END IF;

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

3276: );
3277:
3278: IF (g_debug = 'Y') THEN
3279: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCRO for we_id='||p_wip_entity_id);
3280: fnd_file.put_line(fnd_file.log, 'for component='||t_comp_details(l_all_level_comps_ctr).component_item_id||
3281: ', and qpa = '||t_comp_details(l_all_level_comps_ctr).required_quantity||
3282: ', and bill_qpa = '||t_comp_details(l_all_level_comps_ctr).BILL_QUANTITY_PER_ASSEMBLY);
3283: END IF;
3284:

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

3532: cur_resc.ORIGINAL_SYSTEM_REFERENCE
3533: );
3534:
3535: IF (g_debug = 'Y') THEN
3536: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCOR (ph) for we_id='||p_wip_entity_id);
3537: END IF;
3538:
3539: END LOOP;
3540: END;

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

3566:
3567:
3568:
3569: IF (g_debug = 'Y') THEN
3570: fnd_file.put_line(fnd_file.log, 'Get_Job_Curr_Op_Info returned : '||
3571: 'l_curr_op_seq_num ='||l_curr_op_seq_num ||
3572: ', l_curr_op_seq_id ='||l_curr_op_seq_id ||
3573: ', l_curr_op_std_op_id ='||l_curr_op_std_op_id ||
3574: ', l_curr_op_dept_id ='||l_curr_op_dept_id ||

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

3599: END;
3600:
3601:
3602: IF (g_debug = 'Y') THEN
3603: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||') : l_is_curr_op_reco='||l_is_curr_op_reco);
3604: END IF;
3605:
3606: ELSIF (l_err_code = -1) THEN -- No WO records
3607: -- Scenario : Job creation

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

3616: AND network_start_end = l_network_start; --'S'; --Fixed bug #3761385
3617:
3618:
3619: IF (g_debug = 'Y') THEN
3620: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||') : l_is_curr_op_reco='||l_is_curr_op_reco||
3621: ', and l_curr_op_seq_num='||l_curr_op_seq_num);
3622: END IF;
3623:
3624: -- Start : Additions to fix bug #3677276

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

3697: IF (SQL%ROWCOUNT = 0) THEN
3698: -- No record created in WSM_LOT_BASED_JOBS
3699: fnd_message.set_name('WSM', 'WSM_NO_WLBJ_REC');
3700: x_err_buf := fnd_message.get;
3701: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
3702: x_err_code := -2; -- Error
3703:
3704: return;
3705: ELSE

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

3708: END IF;
3709:
3710:
3711: IF (g_debug = 'Y') THEN
3712: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WLBJ for we_id='||p_wip_entity_id);
3713: END IF;
3714:
3715: l_stmt_num := 330;
3716:

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

3763: p_charges_exist => p_charges_exist
3764: );
3765:
3766: IF (g_debug = 'Y') THEN
3767: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||
3768: '): WSM_infinite_scheduler_PVT.schedule returned '||l_inf_sch_returnStatus);
3769: END IF;
3770:
3771: -- Start : We do not need to error if Inf Sch fails, since dates will be calculated while moving --

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

3770:
3771: -- Start : We do not need to error if Inf Sch fails, since dates will be calculated while moving --
3772: IF(l_inf_sch_returnStatus <> FND_API.G_RET_STS_SUCCESS) THEN
3773:
3774: fnd_file.put_line(fnd_file.log, 'Warning : Could not infinite schedule the job successfully');
3775: fnd_file.put_line(fnd_file.log, l_err_buf);
3776: x_err_code := -1; --Warning
3777: x_err_buf := l_err_buf;
3778: END IF;

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

3771: -- Start : We do not need to error if Inf Sch fails, since dates will be calculated while moving --
3772: IF(l_inf_sch_returnStatus <> FND_API.G_RET_STS_SUCCESS) THEN
3773:
3774: fnd_file.put_line(fnd_file.log, 'Warning : Could not infinite schedule the job successfully');
3775: fnd_file.put_line(fnd_file.log, l_err_buf);
3776: x_err_code := -1; --Warning
3777: x_err_buf := l_err_buf;
3778: END IF;
3779: -- End : We do not need to error if Inf Sch fails,

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

3804:
3805: EXCEPTION
3806: WHEN be_exploder_exception THEN
3807: x_err_buf := 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||') : '||x_err_buf;
3808: fnd_file.put_line(fnd_file.log, x_err_buf);
3809:
3810: WHEN loop_in_bom_exception THEN
3811: x_err_buf := 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||') : '||x_err_buf;
3812: fnd_file.put_line(fnd_file.log, x_err_buf);

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

3808: fnd_file.put_line(fnd_file.log, x_err_buf);
3809:
3810: WHEN loop_in_bom_exception THEN
3811: x_err_buf := 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||') : '||x_err_buf;
3812: fnd_file.put_line(fnd_file.log, x_err_buf);
3813:
3814: WHEN e_proc_error THEN
3815: x_err_buf := 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||') : '||x_err_buf;
3816: fnd_file.put_line(fnd_file.log, x_err_buf);

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

3812: fnd_file.put_line(fnd_file.log, x_err_buf);
3813:
3814: WHEN e_proc_error THEN
3815: x_err_buf := 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||') : '||x_err_buf;
3816: fnd_file.put_line(fnd_file.log, x_err_buf);
3817:
3818: --Bug 4264364:Added exception handling
3819: WHEN e_noneff_op THEN
3820: x_err_buf := 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||') : '||x_err_buf;

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

3817:
3818: --Bug 4264364:Added exception handling
3819: WHEN e_noneff_op THEN
3820: x_err_buf := 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||') : '||x_err_buf;
3821: fnd_file.put_line(fnd_file.log, x_err_buf);
3822:
3823: WHEN others THEN
3824: x_err_code := SQLCODE;
3825: x_err_buf := 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);

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

3822:
3823: WHEN others THEN
3824: x_err_code := SQLCODE;
3825: x_err_buf := 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
3826: fnd_file.put_line(fnd_file.log, x_err_buf);
3827:
3828: END Create_JobCopies;
3829:
3830:

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

3880:
3881: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');
3882:
3883: IF (g_debug = 'Y') THEN
3884: fnd_file.put_line(fnd_file.log, 'Parameters to Create_RepJobCopies are :\\n');
3885: fnd_file.put_line(fnd_file.log, ' p_rep_wip_entity_id ='||p_rep_wip_entity_id );
3886: fnd_file.put_line(fnd_file.log, ', p_new_wip_entity_id ='||p_new_wip_entity_id );
3887: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
3888: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );

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

3881: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');
3882:
3883: IF (g_debug = 'Y') THEN
3884: fnd_file.put_line(fnd_file.log, 'Parameters to Create_RepJobCopies are :\\n');
3885: fnd_file.put_line(fnd_file.log, ' p_rep_wip_entity_id ='||p_rep_wip_entity_id );
3886: fnd_file.put_line(fnd_file.log, ', p_new_wip_entity_id ='||p_new_wip_entity_id );
3887: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
3888: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
3889: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );

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

3882:
3883: IF (g_debug = 'Y') THEN
3884: fnd_file.put_line(fnd_file.log, 'Parameters to Create_RepJobCopies are :\\n');
3885: fnd_file.put_line(fnd_file.log, ' p_rep_wip_entity_id ='||p_rep_wip_entity_id );
3886: fnd_file.put_line(fnd_file.log, ', p_new_wip_entity_id ='||p_new_wip_entity_id );
3887: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
3888: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
3889: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
3890: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );

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

3883: IF (g_debug = 'Y') THEN
3884: fnd_file.put_line(fnd_file.log, 'Parameters to Create_RepJobCopies are :\\n');
3885: fnd_file.put_line(fnd_file.log, ' p_rep_wip_entity_id ='||p_rep_wip_entity_id );
3886: fnd_file.put_line(fnd_file.log, ', p_new_wip_entity_id ='||p_new_wip_entity_id );
3887: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
3888: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
3889: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
3890: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
3891: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );

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

3884: fnd_file.put_line(fnd_file.log, 'Parameters to Create_RepJobCopies are :\\n');
3885: fnd_file.put_line(fnd_file.log, ' p_rep_wip_entity_id ='||p_rep_wip_entity_id );
3886: fnd_file.put_line(fnd_file.log, ', p_new_wip_entity_id ='||p_new_wip_entity_id );
3887: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
3888: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
3889: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
3890: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
3891: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
3892: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );

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

3885: fnd_file.put_line(fnd_file.log, ' p_rep_wip_entity_id ='||p_rep_wip_entity_id );
3886: fnd_file.put_line(fnd_file.log, ', p_new_wip_entity_id ='||p_new_wip_entity_id );
3887: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
3888: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
3889: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
3890: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
3891: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
3892: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
3893: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );

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

3886: fnd_file.put_line(fnd_file.log, ', p_new_wip_entity_id ='||p_new_wip_entity_id );
3887: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
3888: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
3889: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
3890: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
3891: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
3892: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
3893: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
3894: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );

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

3887: fnd_file.put_line(fnd_file.log, ', p_last_update_date ='||p_last_update_date );
3888: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
3889: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
3890: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
3891: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
3892: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
3893: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
3894: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
3895: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );

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

3888: fnd_file.put_line(fnd_file.log, ', p_last_updated_by ='||p_last_updated_by );
3889: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
3890: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
3891: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
3892: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
3893: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
3894: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
3895: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
3896: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );

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

3889: fnd_file.put_line(fnd_file.log, ', p_last_update_login ='||p_last_update_login );
3890: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
3891: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
3892: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
3893: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
3894: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
3895: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
3896: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );
3897: fnd_file.put_line(fnd_file.log, ', p_inf_sch_mode ='||p_inf_sch_mode );

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

3890: fnd_file.put_line(fnd_file.log, ', p_creation_date ='||p_creation_date );
3891: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
3892: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
3893: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
3894: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
3895: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
3896: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );
3897: fnd_file.put_line(fnd_file.log, ', p_inf_sch_mode ='||p_inf_sch_mode );
3898: fnd_file.put_line(fnd_file.log, ', p_inf_sch_date ='||p_inf_sch_date );

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

3891: fnd_file.put_line(fnd_file.log, ', p_created_by ='||p_created_by );
3892: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
3893: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
3894: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
3895: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
3896: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );
3897: fnd_file.put_line(fnd_file.log, ', p_inf_sch_mode ='||p_inf_sch_mode );
3898: fnd_file.put_line(fnd_file.log, ', p_inf_sch_date ='||p_inf_sch_date );
3899: END IF;

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

3892: fnd_file.put_line(fnd_file.log, ', p_request_id ='||p_request_id );
3893: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
3894: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
3895: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
3896: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );
3897: fnd_file.put_line(fnd_file.log, ', p_inf_sch_mode ='||p_inf_sch_mode );
3898: fnd_file.put_line(fnd_file.log, ', p_inf_sch_date ='||p_inf_sch_date );
3899: END IF;
3900:

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

3893: fnd_file.put_line(fnd_file.log, ', p_program_app_id ='||p_program_app_id );
3894: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
3895: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
3896: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );
3897: fnd_file.put_line(fnd_file.log, ', p_inf_sch_mode ='||p_inf_sch_mode );
3898: fnd_file.put_line(fnd_file.log, ', p_inf_sch_date ='||p_inf_sch_date );
3899: END IF;
3900:
3901:

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

3894: fnd_file.put_line(fnd_file.log, ', p_program_id ='||p_program_id );
3895: fnd_file.put_line(fnd_file.log, ', p_program_update_date ='||p_program_update_date );
3896: fnd_file.put_line(fnd_file.log, ', p_inf_sch_flag ='||p_inf_sch_flag );
3897: fnd_file.put_line(fnd_file.log, ', p_inf_sch_mode ='||p_inf_sch_mode );
3898: fnd_file.put_line(fnd_file.log, ', p_inf_sch_date ='||p_inf_sch_date );
3899: END IF;
3900:
3901:
3902:

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

3901:
3902:
3903:
3904: IF (g_debug = 'Y') THEN
3905: fnd_file.put_line(fnd_file.log, 'In Create_RepJobCopies: Rep. we_id ='||p_rep_wip_entity_id||
3906: ', new we_id ='||p_new_wip_entity_id);
3907: END IF;
3908:
3909: l_stmt_num := 10;

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

3916: )
3917: THEN
3918: x_err_code := -1;
3919: x_err_buf := 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): Invalid Infinite Scheduling Mode';
3920: fnd_file.put_line(fnd_file.log, x_err_buf);
3921: return;
3922: END IF;
3923:
3924: -- The following deletes will be needed, in case the API is to be made public

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

4026:
4027:
4028:
4029: IF (g_debug = 'Y') THEN
4030: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCON for we_id='||p_new_wip_entity_id);
4031: END IF;
4032:
4033: -- ***** Make a copy of the Routing for the job ***** --
4034: l_stmt_num := 30;

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

4194:
4195:
4196:
4197: IF (g_debug = 'Y') THEN
4198: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCO for we_id='||p_new_wip_entity_id);
4199: END IF;
4200:
4201: -- ***** Make a copy of the primary Resources for the job ***** --
4202: l_stmt_num := 40;

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

4366:
4367:
4368:
4369: IF (g_debug = 'Y') THEN
4370: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCOR for we_id='||p_new_wip_entity_id);
4371: END IF;
4372:
4373: /* ST : Detailed Scheduling */
4374:

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

4409: FROM WSM_COPY_OP_RESOURCE_INSTANCES
4410: WHERE wip_entity_id = p_rep_wip_entity_id;
4411:
4412: IF (g_debug = 'Y') THEN
4413: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCORI for we_id='||p_new_wip_entity_id);
4414: END IF;
4415:
4416: /* ST : Detailed Scheduling end */
4417:

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

4599:
4600:
4601:
4602: IF (g_debug = 'Y') THEN
4603: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCRO for we_id='||p_new_wip_entity_id);
4604: END IF;
4605:
4606: -- Do not need to make copies for Resource Usages and Instances,
4607: -- since these will be set with planning runs next and picks up this job.

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

4658:
4659:
4660:
4661: IF (g_debug = 'Y') THEN
4662: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WLBJ for we_id='||p_new_wip_entity_id);
4663: END IF;
4664:
4665: IF (p_inf_sch_flag = 'Y') THEN
4666:

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

4690: IF (x_err_code = -1) -- No WO records
4691: OR (x_err_code = -2) -- Invalid job
4692: OR (x_err_code <> 0) -- Some other error
4693: THEN
4694: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_RepJobCopies('||l_stmt_num||'): '||
4695: 'Get_Job_Curr_Op_Info returned '||x_err_code);
4696: fnd_file.put_line(fnd_file.log, 'Get_Job_Curr_Op_Info returned l_curr_op_seq_num='||l_curr_op_seq_num);
4697: return;
4698: END IF;

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

4692: OR (x_err_code <> 0) -- Some other error
4693: THEN
4694: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_RepJobCopies('||l_stmt_num||'): '||
4695: 'Get_Job_Curr_Op_Info returned '||x_err_code);
4696: fnd_file.put_line(fnd_file.log, 'Get_Job_Curr_Op_Info returned l_curr_op_seq_num='||l_curr_op_seq_num);
4697: return;
4698: END IF;
4699:
4700: IF (p_inf_sch_mode IS NULL) THEN

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

4730: );
4731:
4732:
4733: IF (g_debug = 'Y') THEN
4734: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_RepJobCopies('||l_stmt_num||
4735: '): WSM_infinite_scheduler_PVT.schedule returned '||l_inf_sch_returnStatus);
4736: END IF;
4737:
4738: -- Start : We do not need to error if Inf Sch fails, since dates will be calculated while moving --

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

4736: END IF;
4737:
4738: -- Start : We do not need to error if Inf Sch fails, since dates will be calculated while moving --
4739: IF(l_inf_sch_returnStatus <> FND_API.G_RET_STS_SUCCESS) THEN
4740: fnd_file.put_line(fnd_file.log, 'Warning : Could not infinite schedule the job successfully');
4741: fnd_file.put_line(fnd_file.log, x_err_buf);
4742: END IF;
4743: x_err_code := 0;
4744: -- End : We do not need to error if Inf Sch fails, since dates will be calculated while moving --

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

4737:
4738: -- Start : We do not need to error if Inf Sch fails, since dates will be calculated while moving --
4739: IF(l_inf_sch_returnStatus <> FND_API.G_RET_STS_SUCCESS) THEN
4740: fnd_file.put_line(fnd_file.log, 'Warning : Could not infinite schedule the job successfully');
4741: fnd_file.put_line(fnd_file.log, x_err_buf);
4742: END IF;
4743: x_err_code := 0;
4744: -- End : We do not need to error if Inf Sch fails, since dates will be calculated while moving --
4745:

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

4751:
4752: WHEN e_proc_error THEN
4753: -- x_err_code := SQLCODE;
4754: x_err_buf := 'WSM_JobCopies_PVT.Create_RepJobCopies('||l_stmt_num||') : '||x_err_buf;
4755: fnd_file.put_line(fnd_file.log, x_err_buf);
4756:
4757: WHEN others THEN
4758: x_err_code := SQLCODE;
4759: x_err_buf := 'WSM_JobCopies_PVT.Create_RepJobCopies('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);

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

4756:
4757: WHEN others THEN
4758: x_err_code := SQLCODE;
4759: x_err_buf := 'WSM_JobCopies_PVT.Create_RepJobCopies('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
4760: fnd_file.put_line(fnd_file.log, x_err_buf);
4761:
4762: END Create_RepJobCopies;
4763:
4764:

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

4898:
4899: l_stmt_num := 40;
4900:
4901: IF (to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING')) = 1) THEN
4902: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
4903: '): Value of profile "WSM: Create Lot Based Jobs Copy Routing" is YES.');
4904: fnd_file.put_line(fnd_file.log, 'Oracle Shopfloor Management is already upgraded to create Lot Based Job Copy Routing. Upgrade failed.');
4905: raise e_upg_error;
4906: ELSIF (to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING')) = 2) THEN

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

4900:
4901: IF (to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING')) = 1) THEN
4902: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
4903: '): Value of profile "WSM: Create Lot Based Jobs Copy Routing" is YES.');
4904: fnd_file.put_line(fnd_file.log, 'Oracle Shopfloor Management is already upgraded to create Lot Based Job Copy Routing. Upgrade failed.');
4905: raise e_upg_error;
4906: ELSIF (to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING')) = 2) THEN
4907: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
4908: '): Value of profile "WSM: Create Lot Based Jobs Copy Routing" is NO.');

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

4903: '): Value of profile "WSM: Create Lot Based Jobs Copy Routing" is YES.');
4904: fnd_file.put_line(fnd_file.log, 'Oracle Shopfloor Management is already upgraded to create Lot Based Job Copy Routing. Upgrade failed.');
4905: raise e_upg_error;
4906: ELSIF (to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING')) = 2) THEN
4907: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
4908: '): Value of profile "WSM: Create Lot Based Jobs Copy Routing" is NO.');
4909: fnd_file.put_line(fnd_file.log, 'Upgrading Lot Based Jobs to Use Copy Routings ...');
4910: ELSE
4911: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||

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

4905: raise e_upg_error;
4906: ELSIF (to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING')) = 2) THEN
4907: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
4908: '): Value of profile "WSM: Create Lot Based Jobs Copy Routing" is NO.');
4909: fnd_file.put_line(fnd_file.log, 'Upgrading Lot Based Jobs to Use Copy Routings ...');
4910: ELSE
4911: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
4912: '): Not able to fetch the value of the profile "WSM: Create Lot Based Jobs Copy Routing".');
4913: raise e_profile_error;

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

4907: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
4908: '): Value of profile "WSM: Create Lot Based Jobs Copy Routing" is NO.');
4909: fnd_file.put_line(fnd_file.log, 'Upgrading Lot Based Jobs to Use Copy Routings ...');
4910: ELSE
4911: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
4912: '): Not able to fetch the value of the profile "WSM: Create Lot Based Jobs Copy Routing".');
4913: raise e_profile_error;
4914: END IF;
4915:

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

4912: '): Not able to fetch the value of the profile "WSM: Create Lot Based Jobs Copy Routing".');
4913: raise e_profile_error;
4914: END IF;
4915:
4916: fnd_file.put_line(fnd_file.log, '*****Upgrade Start Time : '||to_char(sysdate,'DD-MON-YY HH24:MI:SS')||'*****');
4917:
4918: l_counter := 0;
4919:
4920: BEGIN -- {

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

4945:
4946: l_curr_rows := upgrade_jobs%rowcount;
4947: CLOSE upgrade_jobs;
4948:
4949: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
4950: '): Number of rows loaded for the current batch: '||l_curr_rows);
4951: IF (l_curr_rows = 0) THEN
4952: exit;
4953: END IF;

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

4951: IF (l_curr_rows = 0) THEN
4952: exit;
4953: END IF;
4954:
4955: fnd_file.put_line(fnd_file.log, '*****After Bulk fetch : '||to_char(sysdate,'DD-MON-YY HH24:MI:SS')||'*****');
4956:
4957: l_counter := v_job_wip_entity_id.first;
4958: WHILE l_counter is NOT NULL
4959: LOOP --{

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

5005: );
5006:
5007: l_stmt_num := 70;
5008: IF (g_debug = 'Y') THEN
5009: fnd_file.put_line(fnd_file.log, l_stmt_num ||' x_err_code='||x_err_code);
5010: END IF;
5011:
5012: IF ((x_err_code = 0) OR (x_err_code IS NULL)) THEN
5013: l_stmt_num := 71;

Line 5014: fnd_file.put_line(fnd_file.log,

5010: END IF;
5011:
5012: IF ((x_err_code = 0) OR (x_err_code IS NULL)) THEN
5013: l_stmt_num := 71;
5014: fnd_file.put_line(fnd_file.log,
5015: l_all_jobs_ctr+1||' '||
5016: 'Organization id='||v_job_organization_id(l_counter)||'; '||
5017: ' Job: '||v_job_wip_entity_name(l_counter)||
5018: ' (id='||v_job_wip_entity_id(l_counter)||') '||

Line 5024: fnd_file.put_line(fnd_file.log,

5020:
5021:
5022: ELSIF (x_err_code = -1) THEN -- Warning
5023: l_stmt_num := 72;
5024: fnd_file.put_line(fnd_file.log,
5025: l_all_jobs_ctr+1||' '||
5026: 'Organization id='||v_job_organization_id(l_counter)||'; '||
5027: ' Job: '||v_job_wip_entity_name(l_counter)||
5028: ' (id='||v_job_wip_entity_id(l_counter)||') '||

Line 5034: fnd_file.put_line(fnd_file.log,

5030: ' WARNING : '||x_err_buf);
5031:
5032: ELSE -- Error
5033: l_stmt_num := 73;
5034: fnd_file.put_line(fnd_file.log,
5035: l_all_jobs_ctr+1||' '||
5036: 'Organization id='||v_job_organization_id(l_counter)||'; '||
5037: ' Job: '||v_job_wip_entity_name(l_counter)||
5038: ' (id='||v_job_wip_entity_id(l_counter)||') '||

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

5166:
5167: l_stmt_num := 130;
5168: COMMIT;
5169:
5170: fnd_file.put_line(fnd_file.log, '*****Upgrade End Time : '||to_char(sysdate,'DD-MON-YY HH24:MI:SS')||'*****');
5171: fnd_file.put_line(fnd_file.log, 'Upgraded '||l_all_jobs_ctr||' jobs in total');
5172:
5173: fnd_file.put_line(fnd_file.log, 'Upgrade failed to create Job Copies for following '||l_err_ctr||' jobs : ');
5174: l_stmt_num := 140;

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

5167: l_stmt_num := 130;
5168: COMMIT;
5169:
5170: fnd_file.put_line(fnd_file.log, '*****Upgrade End Time : '||to_char(sysdate,'DD-MON-YY HH24:MI:SS')||'*****');
5171: fnd_file.put_line(fnd_file.log, 'Upgraded '||l_all_jobs_ctr||' jobs in total');
5172:
5173: fnd_file.put_line(fnd_file.log, 'Upgrade failed to create Job Copies for following '||l_err_ctr||' jobs : ');
5174: l_stmt_num := 140;
5175:

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

5169:
5170: fnd_file.put_line(fnd_file.log, '*****Upgrade End Time : '||to_char(sysdate,'DD-MON-YY HH24:MI:SS')||'*****');
5171: fnd_file.put_line(fnd_file.log, 'Upgraded '||l_all_jobs_ctr||' jobs in total');
5172:
5173: fnd_file.put_line(fnd_file.log, 'Upgrade failed to create Job Copies for following '||l_err_ctr||' jobs : ');
5174: l_stmt_num := 140;
5175:
5176: FOR l_jobs_counter in 0..l_err_ctr-1
5177: LOOP

Line 5181: fnd_file.put_line(fnd_file.log,

5177: LOOP
5178: l_stmt_num := 141;
5179: IF (t_err_upgrade_jobs(l_jobs_counter).upg_success = 2) THEN
5180: l_stmt_num := 142;
5181: fnd_file.put_line(fnd_file.log,
5182: l_jobs_counter+1||' '||
5183: 'Organization id='||t_err_upgrade_jobs(l_jobs_counter).organization_id||'; '||
5184: ' Job: '||t_err_upgrade_jobs(l_jobs_counter).wip_entity_name||
5185: ' (id='||t_err_upgrade_jobs(l_jobs_counter).wip_entity_id||') '||

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

5190:
5191: l_stmt_num := 144;
5192: t_err_upgrade_jobs.delete;
5193:
5194: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||')'||
5195: 'Please correct the problem and run Refresh Open Jobs Copies for the above '||l_err_ctr||' jobs. ');
5196:
5197: l_stmt_num := 150;
5198:

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

5197: l_stmt_num := 150;
5198:
5199: l_ret_val := fnd_profile.save('WSM_CREATE_LBJ_COPY_ROUTING', '1', 'SITE');
5200:
5201: fnd_file.put_line(fnd_file.log, 'Set the profile "WSM: Create Lot Based Jobs Copy Routing" to YES. '||
5202: 'Upgrade successful. ');
5203:
5204: COMMIT;
5205:

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

5214:
5215: WHEN others THEN
5216: x_err_code := SQLCODE;
5217: x_err_buf := 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
5218: fnd_file.put_line(fnd_file.log, x_err_buf);
5219:
5220: END Upgrade_JobCopies;
5221:
5222: PROCEDURE process_wip_info( p_wip_entity_id IN NUMBER,

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

5802: exception
5803: WHEN others THEN
5804: x_err_code := SQLCODE;
5805: x_err_buf := 'WSM_JobCopies_PVT.process_wip_info('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
5806: fnd_file.put_line(fnd_file.log, x_err_buf);
5807: END process_wip_info;
5808:
5809: FUNCTION max_res_seq (p_op_seq_id NUMBER) return NUMBER
5810: IS