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.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on FND_LOG

Line 9: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

5: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
6: ------------------------------------
7: -- Common constants and variables --
8: ------------------------------------
9: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
10: l_log_statement NUMBER := fnd_log.level_statement;
11: l_log_procedure NUMBER := fnd_log.level_procedure;
12: l_log_error NUMBER := fnd_log.level_error;
13: l_log_unexpected NUMBER := fnd_log.level_unexpected;

Line 10: l_log_statement NUMBER := fnd_log.level_statement;

6: ------------------------------------
7: -- Common constants and variables --
8: ------------------------------------
9: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
10: l_log_statement NUMBER := fnd_log.level_statement;
11: l_log_procedure NUMBER := fnd_log.level_procedure;
12: l_log_error NUMBER := fnd_log.level_error;
13: l_log_unexpected NUMBER := fnd_log.level_unexpected;
14:

Line 11: l_log_procedure NUMBER := fnd_log.level_procedure;

7: -- Common constants and variables --
8: ------------------------------------
9: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
10: l_log_statement NUMBER := fnd_log.level_statement;
11: l_log_procedure NUMBER := fnd_log.level_procedure;
12: l_log_error NUMBER := fnd_log.level_error;
13: l_log_unexpected NUMBER := fnd_log.level_unexpected;
14:
15: TYPE NBR_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 12: l_log_error NUMBER := fnd_log.level_error;

8: ------------------------------------
9: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
10: l_log_statement NUMBER := fnd_log.level_statement;
11: l_log_procedure NUMBER := fnd_log.level_procedure;
12: l_log_error NUMBER := fnd_log.level_error;
13: l_log_unexpected NUMBER := fnd_log.level_unexpected;
14:
15: TYPE NBR_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
16:

Line 13: l_log_unexpected NUMBER := fnd_log.level_unexpected;

9: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
10: l_log_statement NUMBER := fnd_log.level_statement;
11: l_log_procedure NUMBER := fnd_log.level_procedure;
12: l_log_error NUMBER := fnd_log.level_error;
13: l_log_unexpected NUMBER := fnd_log.level_unexpected;
14:
15: TYPE NBR_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
16:
17: TYPE INSTANCE_REC IS RECORD(

Line 141: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

137: OPEN is_unit_present(p_unit_header_id);
138: FETCH is_unit_present INTO l_count;
139: CLOSE is_unit_present;
140:
141: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
142: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
143: 'Records having unit id ' || p_unit_header_id || ': ' || l_count);
144: END IF;
145:

Line 142: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,

138: FETCH is_unit_present INTO l_count;
139: CLOSE is_unit_present;
140:
141: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
142: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
143: 'Records having unit id ' || p_unit_header_id || ': ' || l_count);
144: END IF;
145:
146: IF l_count = 0 THEN

Line 153: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

149: p_workorder_id => p_workorder_id,
150: p_bulk_process_flag => p_bulk_process_flag,
151: x_uc_details_tbl => x_uc_details_tbl);
152:
153: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
154: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
155: 'New row Count ' || x_uc_details_tbl.count);
156: END IF;
157:

Line 154: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,

150: p_bulk_process_flag => p_bulk_process_flag,
151: x_uc_details_tbl => x_uc_details_tbl);
152:
153: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
154: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
155: 'New row Count ' || x_uc_details_tbl.count);
156: END IF;
157:
158: IF x_uc_details_tbl.FIRST IS NOT NULL THEN

Line 314: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

310: END LOOP;
311:
312:
313: -- Quantity calculations for Control Positions is an exception to normal flow
314: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
315: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Invoking API Calc_Control_Position_Qty');
316: END IF;
317:
318: Calc_Control_Position_Qty

Line 315: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Invoking API Calc_Control_Position_Qty');

311:
312:
313: -- Quantity calculations for Control Positions is an exception to normal flow
314: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
315: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Invoking API Calc_Control_Position_Qty');
316: END IF;
317:
318: Calc_Control_Position_Qty
319: (

Line 326: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

322: p_root_instance_id => x_uc_details_tbl(x_uc_details_tbl.FIRST).root_instance_id,
323: p_bulk_process_flag => p_bulk_process_flag
324: );
325:
326: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
327: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'After call to API Calc_Control_Position_Qty');
328: END IF;
329:
330: END IF; -- IF x_uc_details_tbl.FIRST IS NOT NULL

Line 327: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'After call to API Calc_Control_Position_Qty');

323: p_bulk_process_flag => p_bulk_process_flag
324: );
325:
326: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
327: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'After call to API Calc_Control_Position_Qty');
328: END IF;
329:
330: END IF; -- IF x_uc_details_tbl.FIRST IS NOT NULL
331:

Line 332: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

328: END IF;
329:
330: END IF; -- IF x_uc_details_tbl.FIRST IS NOT NULL
331:
332: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
333: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
334: 'Newly Inserted Rows' || x_uc_details_tbl.count);
335: END IF;
336: END IF;

Line 333: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,

329:
330: END IF; -- IF x_uc_details_tbl.FIRST IS NOT NULL
331:
332: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
333: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
334: 'Newly Inserted Rows' || x_uc_details_tbl.count);
335: END IF;
336: END IF;
337: END IF;

Line 343: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

339: OPEN get_record_count;
340: FETCH get_record_count INTO l_count;
341: CLOSE get_record_count;
342:
343: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
344: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
345: 'Records in Table are ' || l_count);
346: END IF;
347:

Line 344: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,

340: FETCH get_record_count INTO l_count;
341: CLOSE get_record_count;
342:
343: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
344: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
345: 'Records in Table are ' || l_count);
346: END IF;
347:
348: IF(p_commit = FND_API.G_TRUE) THEN

Line 700: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

696: l_inst_uc_pos_row_indx_tbl INST_UC_POS_ROW_INDX_TBL_TYP;
697:
698: BEGIN
699:
700: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
701: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
702: l_full_name||'.begin',
703: 'Entering Procedure, p_workorder_id = '||p_workorder_id|| ' and p_unit_header_id = '||p_unit_header_id);
704: END IF;

Line 701: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

697:
698: BEGIN
699:
700: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
701: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
702: l_full_name||'.begin',
703: 'Entering Procedure, p_workorder_id = '||p_workorder_id|| ' and p_unit_header_id = '||p_unit_header_id);
704: END IF;
705:

Line 744: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

740: FETCH get_max_pk_count INTO l_curr_pk;
741: CLOSE get_max_pk_count;
742:
743:
744: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
745: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Value of current pk ' || l_curr_pk);
746: END IF;
747:
748: l_curr_row := 1;

Line 745: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Value of current pk ' || l_curr_pk);

741: CLOSE get_max_pk_count;
742:
743:
744: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
745: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Value of current pk ' || l_curr_pk);
746: END IF;
747:
748: l_curr_row := 1;
749:

Line 753: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

749:
750: IF l_uc_descendant_tbl.FIRST IS NOT NULL THEN
751: FOR i IN l_uc_descendant_tbl.FIRST..l_uc_descendant_tbl.LAST LOOP
752:
753: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
754: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Processing Position (' || l_uc_descendant_tbl(i).position_reference || ') ' ||
755: 'which has Relationship id = ' || l_uc_descendant_tbl(i).relationship_id);
756: END IF;
757:

Line 754: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Processing Position (' || l_uc_descendant_tbl(i).position_reference || ') ' ||

750: IF l_uc_descendant_tbl.FIRST IS NOT NULL THEN
751: FOR i IN l_uc_descendant_tbl.FIRST..l_uc_descendant_tbl.LAST LOOP
752:
753: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
754: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Processing Position (' || l_uc_descendant_tbl(i).position_reference || ') ' ||
755: 'which has Relationship id = ' || l_uc_descendant_tbl(i).relationship_id);
756: END IF;
757:
758: -- select_disable_flag will be set to N for generic behaviour

Line 837: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

833: l_uc_details_tbl(l_curr_row).curr_instance_obj_ver_num;
834: CLOSE get_part_info;
835: END IF;
836:
837: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
838: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
839: 'curr_item_number = '||l_uc_details_tbl(l_curr_row).curr_item_number||
840: 'curr_instance_id :='|| l_uc_descendant_tbl(i).instance_id);
841: END IF;

Line 838: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,

834: CLOSE get_part_info;
835: END IF;
836:
837: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
838: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
839: 'curr_item_number = '||l_uc_details_tbl(l_curr_row).curr_item_number||
840: 'curr_instance_id :='|| l_uc_descendant_tbl(i).instance_id);
841: END IF;
842:

Line 881: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

877: -- In case of Non-Serial Controlled Position
878: IF (l_uc_details_tbl(l_curr_row).is_position_srl_controlled = 'N') THEN
879:
880: -- Invoke API Calc_Position_Qty
881: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
882: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Invoking API Calc_Position_Qty');
883: END IF;
884:
885: Calc_Position_Qty

Line 882: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Invoking API Calc_Position_Qty');

878: IF (l_uc_details_tbl(l_curr_row).is_position_srl_controlled = 'N') THEN
879:
880: -- Invoke API Calc_Position_Qty
881: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
882: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Invoking API Calc_Position_Qty');
883: END IF;
884:
885: Calc_Position_Qty
886: (

Line 893: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

889: x_position_qty => l_uc_details_tbl(l_curr_row).qty_per_position,
890: x_uom_meaning => l_uc_details_tbl(l_curr_row).unit_of_measure
891: );
892:
893: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
894: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'After call to API Calc_Position_Qty');
895: END IF;
896:
897: /* Install Quantity (maximum installable quantity)

Line 894: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'After call to API Calc_Position_Qty');

890: x_uom_meaning => l_uc_details_tbl(l_curr_row).unit_of_measure
891: );
892:
893: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
894: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'After call to API Calc_Position_Qty');
895: END IF;
896:
897: /* Install Quantity (maximum installable quantity)
898: * If no item is defaulted, then it will be Position quantity - Currently installed quantity.

Line 905: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

901: */
902: l_uc_details_tbl(l_curr_row).install_quantity := l_uc_details_tbl(l_curr_row).qty_per_position -
903: NVL(l_uc_details_tbl(l_curr_row).curr_quantity, 0);
904:
905: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
906: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Install Quantity = ' || l_uc_details_tbl(l_curr_row).install_quantity);
907: END IF;
908:
909: -- In case of Serial Controlled Position

Line 906: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Install Quantity = ' || l_uc_details_tbl(l_curr_row).install_quantity);

902: l_uc_details_tbl(l_curr_row).install_quantity := l_uc_details_tbl(l_curr_row).qty_per_position -
903: NVL(l_uc_details_tbl(l_curr_row).curr_quantity, 0);
904:
905: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
906: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Install Quantity = ' || l_uc_details_tbl(l_curr_row).install_quantity);
907: END IF;
908:
909: -- In case of Serial Controlled Position
910: ELSE

Line 940: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

936: x_imm_disp_type_tbl => l_imm_disp_type_tbl,
937: x_sec_disp_type_tbl => l_sec_disp_type_tbl);
938:
939:
940: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
941: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
942: l_full_name,
943: 'Returned from call to AHL_PRD_DISP_UTIL_PVT.Get_Part_Change_Disposition: l_return_status ' || l_return_status);
944: END IF;

Line 941: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

937: x_sec_disp_type_tbl => l_sec_disp_type_tbl);
938:
939:
940: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
941: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
942: l_full_name,
943: 'Returned from call to AHL_PRD_DISP_UTIL_PVT.Get_Part_Change_Disposition: l_return_status ' || l_return_status);
944: END IF;
945:

Line 1042: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1038: l_uc_details_tbl(l_curr_row).disposition_count := 1;
1039: END IF;
1040: END IF;
1041: CLOSE get_Disposition_Details;
1042: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1043: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
1044: 'Total Disp for non-serial position = ' || l_uc_details_tbl(l_curr_row).disposition_count);
1045: END IF;
1046: END IF; -- serial controlled check

Line 1043: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,

1039: END IF;
1040: END IF;
1041: CLOSE get_Disposition_Details;
1042: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1043: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
1044: 'Total Disp for non-serial position = ' || l_uc_details_tbl(l_curr_row).disposition_count);
1045: END IF;
1046: END IF; -- serial controlled check
1047:

Line 1187: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1183: l_uc_details_tbl(l_curr_row).is_controlled_position = 'N') THEN
1184:
1185: -- Call API AHL_UC_INSTANCE_PVT.Get_Available_Instances to find all available instances that
1186: -- can be installed at the current position.
1187: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1188: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Invoking API AHL_UC_INSTANCE_PVT.Get_Available_Instances for parameters: ');
1189: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Parent Instance Id = ' || l_uc_details_tbl(l_curr_row).parent_instance_id);
1190: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Relationship Id = ' || l_uc_details_tbl(l_curr_row).relationship_id);
1191: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Workorder Id = ' || p_workorder_id);

Line 1188: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Invoking API AHL_UC_INSTANCE_PVT.Get_Available_Instances for parameters: ');

1184:
1185: -- Call API AHL_UC_INSTANCE_PVT.Get_Available_Instances to find all available instances that
1186: -- can be installed at the current position.
1187: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1188: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Invoking API AHL_UC_INSTANCE_PVT.Get_Available_Instances for parameters: ');
1189: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Parent Instance Id = ' || l_uc_details_tbl(l_curr_row).parent_instance_id);
1190: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Relationship Id = ' || l_uc_details_tbl(l_curr_row).relationship_id);
1191: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Workorder Id = ' || p_workorder_id);
1192: END IF;

Line 1189: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Parent Instance Id = ' || l_uc_details_tbl(l_curr_row).parent_instance_id);

1185: -- Call API AHL_UC_INSTANCE_PVT.Get_Available_Instances to find all available instances that
1186: -- can be installed at the current position.
1187: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1188: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Invoking API AHL_UC_INSTANCE_PVT.Get_Available_Instances for parameters: ');
1189: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Parent Instance Id = ' || l_uc_details_tbl(l_curr_row).parent_instance_id);
1190: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Relationship Id = ' || l_uc_details_tbl(l_curr_row).relationship_id);
1191: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Workorder Id = ' || p_workorder_id);
1192: END IF;
1193:

Line 1190: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Relationship Id = ' || l_uc_details_tbl(l_curr_row).relationship_id);

1186: -- can be installed at the current position.
1187: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1188: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Invoking API AHL_UC_INSTANCE_PVT.Get_Available_Instances for parameters: ');
1189: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Parent Instance Id = ' || l_uc_details_tbl(l_curr_row).parent_instance_id);
1190: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Relationship Id = ' || l_uc_details_tbl(l_curr_row).relationship_id);
1191: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Workorder Id = ' || p_workorder_id);
1192: END IF;
1193:
1194: AHL_UC_INSTANCE_PVT.Get_Available_Instances

Line 1191: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Workorder Id = ' || p_workorder_id);

1187: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1188: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Invoking API AHL_UC_INSTANCE_PVT.Get_Available_Instances for parameters: ');
1189: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Parent Instance Id = ' || l_uc_details_tbl(l_curr_row).parent_instance_id);
1190: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Relationship Id = ' || l_uc_details_tbl(l_curr_row).relationship_id);
1191: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Workorder Id = ' || p_workorder_id);
1192: END IF;
1193:
1194: AHL_UC_INSTANCE_PVT.Get_Available_Instances
1195: (

Line 1212: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1208: x_available_instance_tbl => l_available_instance_tbl,
1209: x_tbl_count => l_total_available_instances
1210: );
1211:
1212: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1213: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'After call to API AHL_UC_INSTANCE_PVT.Get_Available_Instances. Return Status=' || l_return_status
1214: || ' Total Available Instances=' || l_total_available_instances);
1215: END IF;
1216:

Line 1213: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'After call to API AHL_UC_INSTANCE_PVT.Get_Available_Instances. Return Status=' || l_return_status

1209: x_tbl_count => l_total_available_instances
1210: );
1211:
1212: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1213: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'After call to API AHL_UC_INSTANCE_PVT.Get_Available_Instances. Return Status=' || l_return_status
1214: || ' Total Available Instances=' || l_total_available_instances);
1215: END IF;
1216:
1217: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1298: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1294: -- nullify defaulting for all positions
1295: FOR i IN l_inst_uc_pos_row_indx_tbl(l_inst_id_index).uc_pos_row_index_tbl.FIRST..l_inst_uc_pos_row_indx_tbl(l_inst_id_index).uc_pos_row_index_tbl.LAST LOOP
1296:
1297: l_uc_pos_row_index := l_inst_uc_pos_row_indx_tbl(l_inst_id_index).uc_pos_row_index_tbl(i);
1298: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1299: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Defaulting should not happen for Position (' || l_uc_details_tbl(l_uc_pos_row_index).position || ')');
1300: END IF;
1301:
1302: l_uc_details_tbl(l_uc_pos_row_index).inst_instance_id := null;

Line 1299: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Defaulting should not happen for Position (' || l_uc_details_tbl(l_uc_pos_row_index).position || ')');

1295: FOR i IN l_inst_uc_pos_row_indx_tbl(l_inst_id_index).uc_pos_row_index_tbl.FIRST..l_inst_uc_pos_row_indx_tbl(l_inst_id_index).uc_pos_row_index_tbl.LAST LOOP
1296:
1297: l_uc_pos_row_index := l_inst_uc_pos_row_indx_tbl(l_inst_id_index).uc_pos_row_index_tbl(i);
1298: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1299: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Defaulting should not happen for Position (' || l_uc_details_tbl(l_uc_pos_row_index).position || ')');
1300: END IF;
1301:
1302: l_uc_details_tbl(l_uc_pos_row_index).inst_instance_id := null;
1303: l_uc_details_tbl(l_uc_pos_row_index).inst_item_number := null;

Line 1313: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1309:
1310: -- defaulting should happen for this UC position
1311: ELSE
1312: l_uc_pos_row_index := l_inst_uc_pos_row_indx_tbl(l_inst_id_index).uc_pos_row_index_tbl(1);
1313: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1314: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Defaulting installable item instance (' || l_uc_details_tbl(l_uc_pos_row_index).inst_instance_id
1315: || ') for Position (' || l_uc_details_tbl(l_uc_pos_row_index).position || ')');
1316: END IF;
1317:

Line 1314: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Defaulting installable item instance (' || l_uc_details_tbl(l_uc_pos_row_index).inst_instance_id

1310: -- defaulting should happen for this UC position
1311: ELSE
1312: l_uc_pos_row_index := l_inst_uc_pos_row_indx_tbl(l_inst_id_index).uc_pos_row_index_tbl(1);
1313: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1314: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Defaulting installable item instance (' || l_uc_details_tbl(l_uc_pos_row_index).inst_instance_id
1315: || ') for Position (' || l_uc_details_tbl(l_uc_pos_row_index).position || ')');
1316: END IF;
1317:
1318: -- Recalculate quantities for Non-Serial Controlled Positions

Line 1325: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1321: /* Recalculate Position Quantity for positions where Item instance is defaulted,
1322: * since it depends on MC Relationship id and Instance id.
1323: */
1324: -- Invoke API Calc_Position_Qty
1325: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1326: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Again Invoking API Calc_Position_Qty');
1327: END IF;
1328:
1329: Calc_Position_Qty

Line 1326: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Again Invoking API Calc_Position_Qty');

1322: * since it depends on MC Relationship id and Instance id.
1323: */
1324: -- Invoke API Calc_Position_Qty
1325: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1326: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Again Invoking API Calc_Position_Qty');
1327: END IF;
1328:
1329: Calc_Position_Qty
1330: (

Line 1337: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1333: x_position_qty => l_uc_details_tbl(l_uc_pos_row_index).qty_per_position,
1334: x_uom_meaning => l_uc_details_tbl(l_uc_pos_row_index).unit_of_measure
1335: );
1336:
1337: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1338: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'After call to API Calc_Position_Qty');
1339: END IF;
1340:
1341: /* Recalculate Instance Quantity for positions where Item instance is defaulted. It will be minimum

Line 1338: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'After call to API Calc_Position_Qty');

1334: x_uom_meaning => l_uc_details_tbl(l_uc_pos_row_index).unit_of_measure
1335: );
1336:
1337: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1338: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'After call to API Calc_Position_Qty');
1339: END IF;
1340:
1341: /* Recalculate Instance Quantity for positions where Item instance is defaulted. It will be minimum
1342: * of available instance qty and maximum qty that can be installed considering Current qty as well.

Line 1350: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1346:
1347: l_uc_details_tbl(l_uc_pos_row_index).install_quantity := LEAST(l_uc_details_tbl(l_uc_pos_row_index).instance_quantity,
1348: l_uc_details_tbl(l_uc_pos_row_index).install_quantity);
1349:
1350: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1351: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Install Quantity = ' || l_uc_details_tbl(l_uc_pos_row_index).install_quantity);
1352: END IF;
1353:
1354: END IF; -- IF l_uc_details_tbl(l_curr_row).is_position_srl_controlled = 'N'

Line 1351: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Install Quantity = ' || l_uc_details_tbl(l_uc_pos_row_index).install_quantity);

1347: l_uc_details_tbl(l_uc_pos_row_index).install_quantity := LEAST(l_uc_details_tbl(l_uc_pos_row_index).instance_quantity,
1348: l_uc_details_tbl(l_uc_pos_row_index).install_quantity);
1349:
1350: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1351: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Install Quantity = ' || l_uc_details_tbl(l_uc_pos_row_index).install_quantity);
1352: END IF;
1353:
1354: END IF; -- IF l_uc_details_tbl(l_curr_row).is_position_srl_controlled = 'N'
1355: END IF;

Line 1361: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1357: l_inst_id_index := l_inst_uc_pos_row_indx_tbl.NEXT(l_inst_id_index);
1358: END LOOP; -- WHILE l_inst_id_index IS NOT NULL
1359: END IF; -- IF l_uc_descendant_tbl.FIRST IS NOT NULL
1360:
1361: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1362: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Done fetching details');
1363: END IF;
1364:
1365: x_uc_details_tbl := l_uc_details_tbl;

Line 1362: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Done fetching details');

1358: END LOOP; -- WHILE l_inst_id_index IS NOT NULL
1359: END IF; -- IF l_uc_descendant_tbl.FIRST IS NOT NULL
1360:
1361: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1362: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Done fetching details');
1363: END IF;
1364:
1365: x_uc_details_tbl := l_uc_details_tbl;
1366: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1366: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1362: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Done fetching details');
1363: END IF;
1364:
1365: x_uc_details_tbl := l_uc_details_tbl;
1366: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1367: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_full_name, 'Exiting Procedure');
1368: END IF;
1369:
1370: END get_uc_details;

Line 1367: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_full_name, 'Exiting Procedure');

1363: END IF;
1364:
1365: x_uc_details_tbl := l_uc_details_tbl;
1366: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1367: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_full_name, 'Exiting Procedure');
1368: END IF;
1369:
1370: END get_uc_details;
1371: ------------------------------------------------------------------------------------

Line 1448: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1444: l_quantity NUMBER;
1445: --
1446:
1447: BEGIN
1448: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1449: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.begin', 'At the start of the API');
1450: END IF;
1451:
1452: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1449: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.begin', 'At the start of the API');

1445: --
1446:
1447: BEGIN
1448: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1449: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.begin', 'At the start of the API');
1450: END IF;
1451:
1452: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1453: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_mc_relationship_id = ' || p_mc_relationship_id);

Line 1452: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1448: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1449: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.begin', 'At the start of the API');
1450: END IF;
1451:
1452: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1453: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_mc_relationship_id = ' || p_mc_relationship_id);
1454: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_instance_id = ' || p_instance_id);
1455: END IF;
1456:

Line 1453: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_mc_relationship_id = ' || p_mc_relationship_id);

1449: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.begin', 'At the start of the API');
1450: END IF;
1451:
1452: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1453: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_mc_relationship_id = ' || p_mc_relationship_id);
1454: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_instance_id = ' || p_instance_id);
1455: END IF;
1456:
1457: IF (p_mc_relationship_id IS NOT NULL) THEN

Line 1454: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_instance_id = ' || p_instance_id);

1450: END IF;
1451:
1452: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1453: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_mc_relationship_id = ' || p_mc_relationship_id);
1454: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_instance_id = ' || p_instance_id);
1455: END IF;
1456:
1457: IF (p_mc_relationship_id IS NOT NULL) THEN
1458:

Line 1498: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1494: CLOSE get_pos_qty_details_csr;
1495:
1496: END IF; -- IF p_mc_relationship_id IS NOT NULL
1497:
1498: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1499: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Position Quantity = ' || x_position_qty);
1500: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'UOM meaning = ' || x_uom_meaning);
1501: END IF;
1502:

Line 1499: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Position Quantity = ' || x_position_qty);

1495:
1496: END IF; -- IF p_mc_relationship_id IS NOT NULL
1497:
1498: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1499: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Position Quantity = ' || x_position_qty);
1500: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'UOM meaning = ' || x_uom_meaning);
1501: END IF;
1502:
1503: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1500: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'UOM meaning = ' || x_uom_meaning);

1496: END IF; -- IF p_mc_relationship_id IS NOT NULL
1497:
1498: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1499: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Position Quantity = ' || x_position_qty);
1500: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'UOM meaning = ' || x_uom_meaning);
1501: END IF;
1502:
1503: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1504: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.end', 'At the end of the API');

Line 1503: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1499: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Position Quantity = ' || x_position_qty);
1500: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'UOM meaning = ' || x_uom_meaning);
1501: END IF;
1502:
1503: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1504: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.end', 'At the end of the API');
1505: END IF;
1506:
1507: END Calc_Position_Qty;

Line 1504: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.end', 'At the end of the API');

1500: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'UOM meaning = ' || x_uom_meaning);
1501: END IF;
1502:
1503: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1504: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.end', 'At the end of the API');
1505: END IF;
1506:
1507: END Calc_Position_Qty;
1508: ------------------------------------------------------------------------------------

Line 1624: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1620: l_select_disable_flag VARCHAR2(1);
1621: --
1622:
1623: BEGIN
1624: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1625: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.begin', 'At the start of the API');
1626: END IF;
1627:
1628: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1625: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.begin', 'At the start of the API');

1621: --
1622:
1623: BEGIN
1624: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1625: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.begin', 'At the start of the API');
1626: END IF;
1627:
1628: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1629: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_workorder_id = ' || p_workorder_id);

Line 1628: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1624: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1625: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.begin', 'At the start of the API');
1626: END IF;
1627:
1628: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1629: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_workorder_id = ' || p_workorder_id);
1630: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_unit_header_id = ' || p_unit_header_id);
1631: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_root_instance_id = ' || p_root_instance_id);
1632: END IF;

Line 1629: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_workorder_id = ' || p_workorder_id);

1625: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.begin', 'At the start of the API');
1626: END IF;
1627:
1628: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1629: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_workorder_id = ' || p_workorder_id);
1630: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_unit_header_id = ' || p_unit_header_id);
1631: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_root_instance_id = ' || p_root_instance_id);
1632: END IF;
1633:

Line 1630: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_unit_header_id = ' || p_unit_header_id);

1626: END IF;
1627:
1628: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1629: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_workorder_id = ' || p_workorder_id);
1630: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_unit_header_id = ' || p_unit_header_id);
1631: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_root_instance_id = ' || p_root_instance_id);
1632: END IF;
1633:
1634: -- Iterate through all Control Positions in the given UC

Line 1631: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_root_instance_id = ' || p_root_instance_id);

1627:
1628: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1629: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_workorder_id = ' || p_workorder_id);
1630: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_unit_header_id = ' || p_unit_header_id);
1631: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'p_root_instance_id = ' || p_root_instance_id);
1632: END IF;
1633:
1634: -- Iterate through all Control Positions in the given UC
1635: FOR control_pos_rec IN get_control_pos_details_csr LOOP

Line 1650: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1646: OPEN calc_inst_qty_for_cntrl_pos (control_pos_rec.relationship_id, control_pos_rec.curr_instance_id, control_pos_rec.parent_instance_id);
1647: FETCH calc_inst_qty_for_cntrl_pos INTO control_pos_rec.install_quantity;
1648: CLOSE calc_inst_qty_for_cntrl_pos;
1649:
1650: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1651: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For Control Position (' || control_pos_rec.position || ')' ||
1652: ' Position Qty = ' || control_pos_rec.qty_per_position ||
1653: ' Install Qty = ' || control_pos_rec.install_quantity);
1654: END IF;

Line 1651: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For Control Position (' || control_pos_rec.position || ')' ||

1647: FETCH calc_inst_qty_for_cntrl_pos INTO control_pos_rec.install_quantity;
1648: CLOSE calc_inst_qty_for_cntrl_pos;
1649:
1650: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1651: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For Control Position (' || control_pos_rec.position || ')' ||
1652: ' Position Qty = ' || control_pos_rec.qty_per_position ||
1653: ' Install Qty = ' || control_pos_rec.install_quantity);
1654: END IF;
1655:

Line 1687: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1683: child_pos_rec.install_quantity := LEAST(child_pos_rec.instance_quantity,
1684: child_pos_rec.install_quantity);
1685: END IF;
1686:
1687: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1688: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For Control Position Child (' || child_pos_rec.position || ')' ||
1689: ' Position Qty = ' || child_pos_rec.qty_per_position ||
1690: ' Install Qty = ' || child_pos_rec.install_quantity);
1691: END IF;

Line 1688: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For Control Position Child (' || child_pos_rec.position || ')' ||

1684: child_pos_rec.install_quantity);
1685: END IF;
1686:
1687: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1688: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For Control Position Child (' || child_pos_rec.position || ')' ||
1689: ' Position Qty = ' || child_pos_rec.qty_per_position ||
1690: ' Install Qty = ' || child_pos_rec.install_quantity);
1691: END IF;
1692: child_pos_rec.qty_per_position := null;

Line 1726: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1722: END LOOP; -- For all children of control positions
1723:
1724: END LOOP; -- For all control positions
1725:
1726: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1727: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.end', 'At the end of the API');
1728: END IF;
1729:
1730: END Calc_Control_Position_Qty;

Line 1727: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.end', 'At the end of the API');

1723:
1724: END LOOP; -- For all control positions
1725:
1726: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1727: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.end', 'At the end of the API');
1728: END IF;
1729:
1730: END Calc_Control_Position_Qty;
1731: ------------------------------------------------------------------------------------

Line 1818: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1814: l_control_pos_install_qty NUMBER;
1815: --
1816:
1817: BEGIN
1818: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1819: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.begin', 'At the start of the API');
1820: END IF;
1821:
1822: /* Calculation logic is relevant only for Non-Serialized Controlled Positions, for Serialized

Line 1819: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.begin', 'At the start of the API');

1815: --
1816:
1817: BEGIN
1818: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1819: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.begin', 'At the start of the API');
1820: END IF;
1821:
1822: /* Calculation logic is relevant only for Non-Serialized Controlled Positions, for Serialized
1823: * Quanitities will always be 1 and will not change on Instance selection.

Line 1827: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1823: * Quanitities will always be 1 and will not change on Instance selection.
1824: */
1825: IF (p_x_uc_details_rec.is_position_srl_controlled = 'N') THEN
1826:
1827: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1828: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Recalculating Position and Install Quantity for selected instance_id = ' || p_x_uc_details_rec.inst_instance_id);
1829: END IF;
1830:
1831: IF (p_x_uc_details_rec.relationship_id IS NOT NULL) THEN

Line 1828: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Recalculating Position and Install Quantity for selected instance_id = ' || p_x_uc_details_rec.inst_instance_id);

1824: */
1825: IF (p_x_uc_details_rec.is_position_srl_controlled = 'N') THEN
1826:
1827: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1828: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Recalculating Position and Install Quantity for selected instance_id = ' || p_x_uc_details_rec.inst_instance_id);
1829: END IF;
1830:
1831: IF (p_x_uc_details_rec.relationship_id IS NOT NULL) THEN
1832:

Line 1835: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1831: IF (p_x_uc_details_rec.relationship_id IS NOT NULL) THEN
1832:
1833: -- Calculate Position Quantity
1834: -- Invoke API Calc_Position_Qty
1835: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1836: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Invoking API Calc_Position_Qty');
1837: END IF;
1838:
1839: Calc_Position_Qty

Line 1836: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Invoking API Calc_Position_Qty');

1832:
1833: -- Calculate Position Quantity
1834: -- Invoke API Calc_Position_Qty
1835: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1836: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Invoking API Calc_Position_Qty');
1837: END IF;
1838:
1839: Calc_Position_Qty
1840: (

Line 1847: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1843: x_position_qty => p_x_uc_details_rec.qty_per_position,
1844: x_uom_meaning => p_x_uc_details_rec.unit_of_measure
1845: );
1846:
1847: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1848: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'After call to API Calc_Position_Qty');
1849: END IF;
1850:
1851:

Line 1848: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'After call to API Calc_Position_Qty');

1844: x_uom_meaning => p_x_uc_details_rec.unit_of_measure
1845: );
1846:
1847: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1848: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'After call to API Calc_Position_Qty');
1849: END IF;
1850:
1851:
1852: -- find whether the given position is child of control position

Line 1864: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1860: -- Calculate Install Quantity
1861: p_x_uc_details_rec.install_quantity := p_x_uc_details_rec.qty_per_position - NVL(p_x_uc_details_rec.curr_quantity, 0);
1862: p_x_uc_details_rec.install_quantity := LEAST(p_x_uc_details_rec.instance_quantity, p_x_uc_details_rec.install_quantity);
1863:
1864: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1865: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For normal position, Position Quantity = ' || p_x_uc_details_rec.qty_per_position);
1866: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For normal position, Install Quantity = ' || p_x_uc_details_rec.install_quantity);
1867: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For normal position, Unit of Measure = ' || p_x_uc_details_rec.unit_of_measure);
1868: END IF;

Line 1865: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For normal position, Position Quantity = ' || p_x_uc_details_rec.qty_per_position);

1861: p_x_uc_details_rec.install_quantity := p_x_uc_details_rec.qty_per_position - NVL(p_x_uc_details_rec.curr_quantity, 0);
1862: p_x_uc_details_rec.install_quantity := LEAST(p_x_uc_details_rec.instance_quantity, p_x_uc_details_rec.install_quantity);
1863:
1864: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1865: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For normal position, Position Quantity = ' || p_x_uc_details_rec.qty_per_position);
1866: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For normal position, Install Quantity = ' || p_x_uc_details_rec.install_quantity);
1867: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For normal position, Unit of Measure = ' || p_x_uc_details_rec.unit_of_measure);
1868: END IF;
1869:

Line 1866: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For normal position, Install Quantity = ' || p_x_uc_details_rec.install_quantity);

1862: p_x_uc_details_rec.install_quantity := LEAST(p_x_uc_details_rec.instance_quantity, p_x_uc_details_rec.install_quantity);
1863:
1864: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1865: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For normal position, Position Quantity = ' || p_x_uc_details_rec.qty_per_position);
1866: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For normal position, Install Quantity = ' || p_x_uc_details_rec.install_quantity);
1867: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For normal position, Unit of Measure = ' || p_x_uc_details_rec.unit_of_measure);
1868: END IF;
1869:
1870: -- for child of control positions

Line 1867: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For normal position, Unit of Measure = ' || p_x_uc_details_rec.unit_of_measure);

1863:
1864: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1865: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For normal position, Position Quantity = ' || p_x_uc_details_rec.qty_per_position);
1866: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For normal position, Install Quantity = ' || p_x_uc_details_rec.install_quantity);
1867: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For normal position, Unit of Measure = ' || p_x_uc_details_rec.unit_of_measure);
1868: END IF;
1869:
1870: -- for child of control positions
1871: ELSE

Line 1896: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1892: -- Calculate Install quantity
1893: p_x_uc_details_rec.install_quantity := p_x_uc_details_rec.qty_per_position - l_control_pos_install_qty;
1894: p_x_uc_details_rec.install_quantity := LEAST(p_x_uc_details_rec.instance_quantity, p_x_uc_details_rec.install_quantity);
1895:
1896: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1897: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For child control position, Position Quantity = ' || p_x_uc_details_rec.qty_per_position);
1898: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For child control position, Install Quantity = ' || p_x_uc_details_rec.install_quantity);
1899: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For child control position, Unit of Measure = ' || p_x_uc_details_rec.unit_of_measure);
1900: END IF;

Line 1897: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For child control position, Position Quantity = ' || p_x_uc_details_rec.qty_per_position);

1893: p_x_uc_details_rec.install_quantity := p_x_uc_details_rec.qty_per_position - l_control_pos_install_qty;
1894: p_x_uc_details_rec.install_quantity := LEAST(p_x_uc_details_rec.instance_quantity, p_x_uc_details_rec.install_quantity);
1895:
1896: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1897: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For child control position, Position Quantity = ' || p_x_uc_details_rec.qty_per_position);
1898: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For child control position, Install Quantity = ' || p_x_uc_details_rec.install_quantity);
1899: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For child control position, Unit of Measure = ' || p_x_uc_details_rec.unit_of_measure);
1900: END IF;
1901: p_x_uc_details_rec.qty_per_position := null; -- Position qty for child position is not displayed

Line 1898: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For child control position, Install Quantity = ' || p_x_uc_details_rec.install_quantity);

1894: p_x_uc_details_rec.install_quantity := LEAST(p_x_uc_details_rec.instance_quantity, p_x_uc_details_rec.install_quantity);
1895:
1896: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1897: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For child control position, Position Quantity = ' || p_x_uc_details_rec.qty_per_position);
1898: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For child control position, Install Quantity = ' || p_x_uc_details_rec.install_quantity);
1899: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For child control position, Unit of Measure = ' || p_x_uc_details_rec.unit_of_measure);
1900: END IF;
1901: p_x_uc_details_rec.qty_per_position := null; -- Position qty for child position is not displayed
1902:

Line 1899: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For child control position, Unit of Measure = ' || p_x_uc_details_rec.unit_of_measure);

1895:
1896: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1897: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For child control position, Position Quantity = ' || p_x_uc_details_rec.qty_per_position);
1898: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For child control position, Install Quantity = ' || p_x_uc_details_rec.install_quantity);
1899: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'For child control position, Unit of Measure = ' || p_x_uc_details_rec.unit_of_measure);
1900: END IF;
1901: p_x_uc_details_rec.qty_per_position := null; -- Position qty for child position is not displayed
1902:
1903: END IF; -- IF l_is_child_control_pos = 'N'

Line 1909: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1905: END IF; -- IF p_mc_relationship_id IS NOT NULL
1906:
1907: END IF; -- IF p_x_uc_details_rec.is_position_srl_controlled = 'N'
1908:
1909: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1910: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.end', 'At the end of the API');
1911: END IF;
1912:
1913: END Calc_Qty_On_Inst_Selection;

Line 1910: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.end', 'At the end of the API');

1906:
1907: END IF; -- IF p_x_uc_details_rec.is_position_srl_controlled = 'N'
1908:
1909: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1910: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_full_name || '.end', 'At the end of the API');
1911: END IF;
1912:
1913: END Calc_Qty_On_Inst_Selection;
1914: ------------------------------------------------------------------------------------

Line 1990: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1986: l_unit_header_id := -1;
1987: l_hGrid_node_path := null;
1988:
1989: FOR i IN p_filter_records_tbl.FIRST..p_filter_records_tbl.LAST LOOP
1990: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1991: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1992: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1993: 'Filter criteria ' || i || ' ' ||
1994: p_filter_records_tbl(i).param || ' '||

Line 1991: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1987: l_hGrid_node_path := null;
1988:
1989: FOR i IN p_filter_records_tbl.FIRST..p_filter_records_tbl.LAST LOOP
1990: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1991: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1992: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1993: 'Filter criteria ' || i || ' ' ||
1994: p_filter_records_tbl(i).param || ' '||
1995: p_filter_records_tbl(i).param_value);

Line 2032: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2028:
2029: END LOOP;
2030:
2031:
2032: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2033: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2034: 'criteria query' || l_sql_cri_str);
2035: END IF;
2036:

Line 2033: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

2029: END LOOP;
2030:
2031:
2032: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2033: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2034: 'criteria query' || l_sql_cri_str);
2035: END IF;
2036:
2037: OPEN get_count(l_unit_header_id);

Line 2052: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2048:
2049: FETCH l_cur BULK COLLECT INTO l_uc_node_id_tbl LIMIT l_buffer_limit;
2050: CLOSE l_cur;
2051:
2052: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2053: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2054: 'Unit header id:' || l_unit_header_id ||
2055: ' Total count:' || l_count ||
2056: ' Filtered count:' || l_uc_node_id_tbl.count);

Line 2053: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

2049: FETCH l_cur BULK COLLECT INTO l_uc_node_id_tbl LIMIT l_buffer_limit;
2050: CLOSE l_cur;
2051:
2052: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2053: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2054: 'Unit header id:' || l_unit_header_id ||
2055: ' Total count:' || l_count ||
2056: ' Filtered count:' || l_uc_node_id_tbl.count);
2057: END IF;

Line 2168: fnd_log.string(l_log_procedure, l_debug_key,

2164: BEGIN
2165: -- Standard start of API savepoint
2166: SAVEPOINT PRD_BLK_PARTS_CHNG_PVT;
2167: IF (l_log_procedure >= l_log_current_level) THEN
2168: fnd_log.string(l_log_procedure, l_debug_key,
2169: ' Entering procedure');
2170: END IF;
2171:
2172: -- Standard call to check for call compatibility

Line 2193: fnd_log.string(l_log_statement, l_debug_key,

2189: RETURN;
2190: End if;
2191:
2192: IF (l_log_statement >= l_log_current_level) THEN
2193: fnd_log.string(l_log_statement, l_debug_key,
2194: ' P_X_PARTS_REC_TBL.COUNT = ' || P_X_PARTS_REC_TBL.COUNT);
2195: FOR i IN P_X_PARTS_REC_TBL.FIRST..P_X_PARTS_REC_TBL.LAST LOOP
2196: fnd_log.string(l_log_statement, l_debug_key,
2197: ' P_X_PARTS_REC_TBL.(' || i || ').WORKORDER_ID' || ': ' || P_X_PARTS_REC_TBL(i).WORKORDER_ID);

Line 2196: fnd_log.string(l_log_statement, l_debug_key,

2192: IF (l_log_statement >= l_log_current_level) THEN
2193: fnd_log.string(l_log_statement, l_debug_key,
2194: ' P_X_PARTS_REC_TBL.COUNT = ' || P_X_PARTS_REC_TBL.COUNT);
2195: FOR i IN P_X_PARTS_REC_TBL.FIRST..P_X_PARTS_REC_TBL.LAST LOOP
2196: fnd_log.string(l_log_statement, l_debug_key,
2197: ' P_X_PARTS_REC_TBL.(' || i || ').WORKORDER_ID' || ': ' || P_X_PARTS_REC_TBL(i).WORKORDER_ID);
2198: fnd_log.string(l_log_statement, l_debug_key,
2199: ' P_X_PARTS_REC_TBL.(' || i || ').OPERATION_SEQUENCE_NUM' || ': ' || P_X_PARTS_REC_TBL(i).OPERATION_SEQUENCE_NUM);
2200: fnd_log.string(l_log_statement, l_debug_key,

Line 2198: fnd_log.string(l_log_statement, l_debug_key,

2194: ' P_X_PARTS_REC_TBL.COUNT = ' || P_X_PARTS_REC_TBL.COUNT);
2195: FOR i IN P_X_PARTS_REC_TBL.FIRST..P_X_PARTS_REC_TBL.LAST LOOP
2196: fnd_log.string(l_log_statement, l_debug_key,
2197: ' P_X_PARTS_REC_TBL.(' || i || ').WORKORDER_ID' || ': ' || P_X_PARTS_REC_TBL(i).WORKORDER_ID);
2198: fnd_log.string(l_log_statement, l_debug_key,
2199: ' P_X_PARTS_REC_TBL.(' || i || ').OPERATION_SEQUENCE_NUM' || ': ' || P_X_PARTS_REC_TBL(i).OPERATION_SEQUENCE_NUM);
2200: fnd_log.string(l_log_statement, l_debug_key,
2201: ' P_X_PARTS_REC_TBL.(' || i || ').WORKORDER_OPERATION_ID' || ': ' || P_X_PARTS_REC_TBL(i).WORKORDER_OPERATION_ID);
2202: fnd_log.string(l_log_statement, l_debug_key,

Line 2200: fnd_log.string(l_log_statement, l_debug_key,

2196: fnd_log.string(l_log_statement, l_debug_key,
2197: ' P_X_PARTS_REC_TBL.(' || i || ').WORKORDER_ID' || ': ' || P_X_PARTS_REC_TBL(i).WORKORDER_ID);
2198: fnd_log.string(l_log_statement, l_debug_key,
2199: ' P_X_PARTS_REC_TBL.(' || i || ').OPERATION_SEQUENCE_NUM' || ': ' || P_X_PARTS_REC_TBL(i).OPERATION_SEQUENCE_NUM);
2200: fnd_log.string(l_log_statement, l_debug_key,
2201: ' P_X_PARTS_REC_TBL.(' || i || ').WORKORDER_OPERATION_ID' || ': ' || P_X_PARTS_REC_TBL(i).WORKORDER_OPERATION_ID);
2202: fnd_log.string(l_log_statement, l_debug_key,
2203: ' P_X_PARTS_REC_TBL.(' || i || ').OPERATION_TYPE' || ': ' || P_X_PARTS_REC_TBL(i).OPERATION_TYPE);
2204: fnd_log.string(l_log_statement, l_debug_key,

Line 2202: fnd_log.string(l_log_statement, l_debug_key,

2198: fnd_log.string(l_log_statement, l_debug_key,
2199: ' P_X_PARTS_REC_TBL.(' || i || ').OPERATION_SEQUENCE_NUM' || ': ' || P_X_PARTS_REC_TBL(i).OPERATION_SEQUENCE_NUM);
2200: fnd_log.string(l_log_statement, l_debug_key,
2201: ' P_X_PARTS_REC_TBL.(' || i || ').WORKORDER_OPERATION_ID' || ': ' || P_X_PARTS_REC_TBL(i).WORKORDER_OPERATION_ID);
2202: fnd_log.string(l_log_statement, l_debug_key,
2203: ' P_X_PARTS_REC_TBL.(' || i || ').OPERATION_TYPE' || ': ' || P_X_PARTS_REC_TBL(i).OPERATION_TYPE);
2204: fnd_log.string(l_log_statement, l_debug_key,
2205: ' P_X_PARTS_REC_TBL.(' || i || ').UNIT_CONFIG_HEADER_ID' || ': ' || P_X_PARTS_REC_TBL(i).UNIT_CONFIG_HEADER_ID);
2206: fnd_log.string(l_log_statement, l_debug_key,

Line 2204: fnd_log.string(l_log_statement, l_debug_key,

2200: fnd_log.string(l_log_statement, l_debug_key,
2201: ' P_X_PARTS_REC_TBL.(' || i || ').WORKORDER_OPERATION_ID' || ': ' || P_X_PARTS_REC_TBL(i).WORKORDER_OPERATION_ID);
2202: fnd_log.string(l_log_statement, l_debug_key,
2203: ' P_X_PARTS_REC_TBL.(' || i || ').OPERATION_TYPE' || ': ' || P_X_PARTS_REC_TBL(i).OPERATION_TYPE);
2204: fnd_log.string(l_log_statement, l_debug_key,
2205: ' P_X_PARTS_REC_TBL.(' || i || ').UNIT_CONFIG_HEADER_ID' || ': ' || P_X_PARTS_REC_TBL(i).UNIT_CONFIG_HEADER_ID);
2206: fnd_log.string(l_log_statement, l_debug_key,
2207: ' P_X_PARTS_REC_TBL.(' || i || ').MC_RELATIONSHIP_ID' || ': ' || P_X_PARTS_REC_TBL(i).MC_RELATIONSHIP_ID);
2208: fnd_log.string(l_log_statement, l_debug_key,

Line 2206: fnd_log.string(l_log_statement, l_debug_key,

2202: fnd_log.string(l_log_statement, l_debug_key,
2203: ' P_X_PARTS_REC_TBL.(' || i || ').OPERATION_TYPE' || ': ' || P_X_PARTS_REC_TBL(i).OPERATION_TYPE);
2204: fnd_log.string(l_log_statement, l_debug_key,
2205: ' P_X_PARTS_REC_TBL.(' || i || ').UNIT_CONFIG_HEADER_ID' || ': ' || P_X_PARTS_REC_TBL(i).UNIT_CONFIG_HEADER_ID);
2206: fnd_log.string(l_log_statement, l_debug_key,
2207: ' P_X_PARTS_REC_TBL.(' || i || ').MC_RELATIONSHIP_ID' || ': ' || P_X_PARTS_REC_TBL(i).MC_RELATIONSHIP_ID);
2208: fnd_log.string(l_log_statement, l_debug_key,
2209: ' P_X_PARTS_REC_TBL.(' || i || ').CSI_II_RELATIONSHIP_ID' || ': ' || P_X_PARTS_REC_TBL(i).CSI_II_RELATIONSHIP_ID);
2210: fnd_log.string(l_log_statement, l_debug_key,

Line 2208: fnd_log.string(l_log_statement, l_debug_key,

2204: fnd_log.string(l_log_statement, l_debug_key,
2205: ' P_X_PARTS_REC_TBL.(' || i || ').UNIT_CONFIG_HEADER_ID' || ': ' || P_X_PARTS_REC_TBL(i).UNIT_CONFIG_HEADER_ID);
2206: fnd_log.string(l_log_statement, l_debug_key,
2207: ' P_X_PARTS_REC_TBL.(' || i || ').MC_RELATIONSHIP_ID' || ': ' || P_X_PARTS_REC_TBL(i).MC_RELATIONSHIP_ID);
2208: fnd_log.string(l_log_statement, l_debug_key,
2209: ' P_X_PARTS_REC_TBL.(' || i || ').CSI_II_RELATIONSHIP_ID' || ': ' || P_X_PARTS_REC_TBL(i).CSI_II_RELATIONSHIP_ID);
2210: fnd_log.string(l_log_statement, l_debug_key,
2211: ' P_X_PARTS_REC_TBL.(' || i || ').CSI_II_OBJECT_VERSION_NUM' || ': ' || P_X_PARTS_REC_TBL(i).CSI_II_OBJECT_VERSION_NUM);
2212: fnd_log.string(l_log_statement, l_debug_key,

Line 2210: fnd_log.string(l_log_statement, l_debug_key,

2206: fnd_log.string(l_log_statement, l_debug_key,
2207: ' P_X_PARTS_REC_TBL.(' || i || ').MC_RELATIONSHIP_ID' || ': ' || P_X_PARTS_REC_TBL(i).MC_RELATIONSHIP_ID);
2208: fnd_log.string(l_log_statement, l_debug_key,
2209: ' P_X_PARTS_REC_TBL.(' || i || ').CSI_II_RELATIONSHIP_ID' || ': ' || P_X_PARTS_REC_TBL(i).CSI_II_RELATIONSHIP_ID);
2210: fnd_log.string(l_log_statement, l_debug_key,
2211: ' P_X_PARTS_REC_TBL.(' || i || ').CSI_II_OBJECT_VERSION_NUM' || ': ' || P_X_PARTS_REC_TBL(i).CSI_II_OBJECT_VERSION_NUM);
2212: fnd_log.string(l_log_statement, l_debug_key,
2213: ' P_X_PARTS_REC_TBL.(' || i || ').PARENT_INSTALLED_INSTANCE_ID' || ': ' || P_X_PARTS_REC_TBL(i).PARENT_INSTALLED_INSTANCE_ID);
2214: fnd_log.string(l_log_statement, l_debug_key,

Line 2212: fnd_log.string(l_log_statement, l_debug_key,

2208: fnd_log.string(l_log_statement, l_debug_key,
2209: ' P_X_PARTS_REC_TBL.(' || i || ').CSI_II_RELATIONSHIP_ID' || ': ' || P_X_PARTS_REC_TBL(i).CSI_II_RELATIONSHIP_ID);
2210: fnd_log.string(l_log_statement, l_debug_key,
2211: ' P_X_PARTS_REC_TBL.(' || i || ').CSI_II_OBJECT_VERSION_NUM' || ': ' || P_X_PARTS_REC_TBL(i).CSI_II_OBJECT_VERSION_NUM);
2212: fnd_log.string(l_log_statement, l_debug_key,
2213: ' P_X_PARTS_REC_TBL.(' || i || ').PARENT_INSTALLED_INSTANCE_ID' || ': ' || P_X_PARTS_REC_TBL(i).PARENT_INSTALLED_INSTANCE_ID);
2214: fnd_log.string(l_log_statement, l_debug_key,
2215: ' P_X_PARTS_REC_TBL.(' || i || ').PARENT_INSTALLED_INSTANCE_NUM' || ': ' || P_X_PARTS_REC_TBL(i).PARENT_INSTALLED_INSTANCE_NUM);
2216: fnd_log.string(l_log_statement, l_debug_key,

Line 2214: fnd_log.string(l_log_statement, l_debug_key,

2210: fnd_log.string(l_log_statement, l_debug_key,
2211: ' P_X_PARTS_REC_TBL.(' || i || ').CSI_II_OBJECT_VERSION_NUM' || ': ' || P_X_PARTS_REC_TBL(i).CSI_II_OBJECT_VERSION_NUM);
2212: fnd_log.string(l_log_statement, l_debug_key,
2213: ' P_X_PARTS_REC_TBL.(' || i || ').PARENT_INSTALLED_INSTANCE_ID' || ': ' || P_X_PARTS_REC_TBL(i).PARENT_INSTALLED_INSTANCE_ID);
2214: fnd_log.string(l_log_statement, l_debug_key,
2215: ' P_X_PARTS_REC_TBL.(' || i || ').PARENT_INSTALLED_INSTANCE_NUM' || ': ' || P_X_PARTS_REC_TBL(i).PARENT_INSTALLED_INSTANCE_NUM);
2216: fnd_log.string(l_log_statement, l_debug_key,
2217: ' P_X_PARTS_REC_TBL.(' || i || ').INSTALLED_INSTANCE_ID' || ': ' || P_X_PARTS_REC_TBL(i).INSTALLED_INSTANCE_ID);
2218: fnd_log.string(l_log_statement, l_debug_key,

Line 2216: fnd_log.string(l_log_statement, l_debug_key,

2212: fnd_log.string(l_log_statement, l_debug_key,
2213: ' P_X_PARTS_REC_TBL.(' || i || ').PARENT_INSTALLED_INSTANCE_ID' || ': ' || P_X_PARTS_REC_TBL(i).PARENT_INSTALLED_INSTANCE_ID);
2214: fnd_log.string(l_log_statement, l_debug_key,
2215: ' P_X_PARTS_REC_TBL.(' || i || ').PARENT_INSTALLED_INSTANCE_NUM' || ': ' || P_X_PARTS_REC_TBL(i).PARENT_INSTALLED_INSTANCE_NUM);
2216: fnd_log.string(l_log_statement, l_debug_key,
2217: ' P_X_PARTS_REC_TBL.(' || i || ').INSTALLED_INSTANCE_ID' || ': ' || P_X_PARTS_REC_TBL(i).INSTALLED_INSTANCE_ID);
2218: fnd_log.string(l_log_statement, l_debug_key,
2219: ' P_X_PARTS_REC_TBL.(' || i || ').INSTALLED_INSTANCE_NUM' || ': ' || P_X_PARTS_REC_TBL(i).INSTALLED_INSTANCE_NUM);
2220: fnd_log.string(l_log_statement, l_debug_key,

Line 2218: fnd_log.string(l_log_statement, l_debug_key,

2214: fnd_log.string(l_log_statement, l_debug_key,
2215: ' P_X_PARTS_REC_TBL.(' || i || ').PARENT_INSTALLED_INSTANCE_NUM' || ': ' || P_X_PARTS_REC_TBL(i).PARENT_INSTALLED_INSTANCE_NUM);
2216: fnd_log.string(l_log_statement, l_debug_key,
2217: ' P_X_PARTS_REC_TBL.(' || i || ').INSTALLED_INSTANCE_ID' || ': ' || P_X_PARTS_REC_TBL(i).INSTALLED_INSTANCE_ID);
2218: fnd_log.string(l_log_statement, l_debug_key,
2219: ' P_X_PARTS_REC_TBL.(' || i || ').INSTALLED_INSTANCE_NUM' || ': ' || P_X_PARTS_REC_TBL(i).INSTALLED_INSTANCE_NUM);
2220: fnd_log.string(l_log_statement, l_debug_key,
2221: ' P_X_PARTS_REC_TBL.(' || i || ').INSTALLED_INSTANCE_OBJ_VER_NUM' || ': ' || P_X_PARTS_REC_TBL(i).INSTALLED_INSTANCE_OBJ_VER_NUM);
2222: fnd_log.string(l_log_statement, l_debug_key,

Line 2220: fnd_log.string(l_log_statement, l_debug_key,

2216: fnd_log.string(l_log_statement, l_debug_key,
2217: ' P_X_PARTS_REC_TBL.(' || i || ').INSTALLED_INSTANCE_ID' || ': ' || P_X_PARTS_REC_TBL(i).INSTALLED_INSTANCE_ID);
2218: fnd_log.string(l_log_statement, l_debug_key,
2219: ' P_X_PARTS_REC_TBL.(' || i || ').INSTALLED_INSTANCE_NUM' || ': ' || P_X_PARTS_REC_TBL(i).INSTALLED_INSTANCE_NUM);
2220: fnd_log.string(l_log_statement, l_debug_key,
2221: ' P_X_PARTS_REC_TBL.(' || i || ').INSTALLED_INSTANCE_OBJ_VER_NUM' || ': ' || P_X_PARTS_REC_TBL(i).INSTALLED_INSTANCE_OBJ_VER_NUM);
2222: fnd_log.string(l_log_statement, l_debug_key,
2223: ' P_X_PARTS_REC_TBL.(' || i || ').INSTALLED_QUANTITY' || ': ' || P_X_PARTS_REC_TBL(i).INSTALLED_QUANTITY);
2224: fnd_log.string(l_log_statement, l_debug_key,

Line 2222: fnd_log.string(l_log_statement, l_debug_key,

2218: fnd_log.string(l_log_statement, l_debug_key,
2219: ' P_X_PARTS_REC_TBL.(' || i || ').INSTALLED_INSTANCE_NUM' || ': ' || P_X_PARTS_REC_TBL(i).INSTALLED_INSTANCE_NUM);
2220: fnd_log.string(l_log_statement, l_debug_key,
2221: ' P_X_PARTS_REC_TBL.(' || i || ').INSTALLED_INSTANCE_OBJ_VER_NUM' || ': ' || P_X_PARTS_REC_TBL(i).INSTALLED_INSTANCE_OBJ_VER_NUM);
2222: fnd_log.string(l_log_statement, l_debug_key,
2223: ' P_X_PARTS_REC_TBL.(' || i || ').INSTALLED_QUANTITY' || ': ' || P_X_PARTS_REC_TBL(i).INSTALLED_QUANTITY);
2224: fnd_log.string(l_log_statement, l_debug_key,
2225: ' P_X_PARTS_REC_TBL.(' || i || ').INSTALLATION_DATE' || ': ' || P_X_PARTS_REC_TBL(i).INSTALLATION_DATE);
2226: fnd_log.string(l_log_statement, l_debug_key,

Line 2224: fnd_log.string(l_log_statement, l_debug_key,

2220: fnd_log.string(l_log_statement, l_debug_key,
2221: ' P_X_PARTS_REC_TBL.(' || i || ').INSTALLED_INSTANCE_OBJ_VER_NUM' || ': ' || P_X_PARTS_REC_TBL(i).INSTALLED_INSTANCE_OBJ_VER_NUM);
2222: fnd_log.string(l_log_statement, l_debug_key,
2223: ' P_X_PARTS_REC_TBL.(' || i || ').INSTALLED_QUANTITY' || ': ' || P_X_PARTS_REC_TBL(i).INSTALLED_QUANTITY);
2224: fnd_log.string(l_log_statement, l_debug_key,
2225: ' P_X_PARTS_REC_TBL.(' || i || ').INSTALLATION_DATE' || ': ' || P_X_PARTS_REC_TBL(i).INSTALLATION_DATE);
2226: fnd_log.string(l_log_statement, l_debug_key,
2227: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVED_INSTANCE_ID' || ': ' || P_X_PARTS_REC_TBL(i).REMOVED_INSTANCE_ID);
2228: fnd_log.string(l_log_statement, l_debug_key,

Line 2226: fnd_log.string(l_log_statement, l_debug_key,

2222: fnd_log.string(l_log_statement, l_debug_key,
2223: ' P_X_PARTS_REC_TBL.(' || i || ').INSTALLED_QUANTITY' || ': ' || P_X_PARTS_REC_TBL(i).INSTALLED_QUANTITY);
2224: fnd_log.string(l_log_statement, l_debug_key,
2225: ' P_X_PARTS_REC_TBL.(' || i || ').INSTALLATION_DATE' || ': ' || P_X_PARTS_REC_TBL(i).INSTALLATION_DATE);
2226: fnd_log.string(l_log_statement, l_debug_key,
2227: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVED_INSTANCE_ID' || ': ' || P_X_PARTS_REC_TBL(i).REMOVED_INSTANCE_ID);
2228: fnd_log.string(l_log_statement, l_debug_key,
2229: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVED_INSTANCE_NUM' || ': ' || P_X_PARTS_REC_TBL(i).REMOVED_INSTANCE_NUM);
2230: fnd_log.string(l_log_statement, l_debug_key,

Line 2228: fnd_log.string(l_log_statement, l_debug_key,

2224: fnd_log.string(l_log_statement, l_debug_key,
2225: ' P_X_PARTS_REC_TBL.(' || i || ').INSTALLATION_DATE' || ': ' || P_X_PARTS_REC_TBL(i).INSTALLATION_DATE);
2226: fnd_log.string(l_log_statement, l_debug_key,
2227: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVED_INSTANCE_ID' || ': ' || P_X_PARTS_REC_TBL(i).REMOVED_INSTANCE_ID);
2228: fnd_log.string(l_log_statement, l_debug_key,
2229: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVED_INSTANCE_NUM' || ': ' || P_X_PARTS_REC_TBL(i).REMOVED_INSTANCE_NUM);
2230: fnd_log.string(l_log_statement, l_debug_key,
2231: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVED_INSTANCE_OBJ_VER_NUM' || ': ' || P_X_PARTS_REC_TBL(i).REMOVED_INSTANCE_OBJ_VER_NUM);
2232: fnd_log.string(l_log_statement, l_debug_key,

Line 2230: fnd_log.string(l_log_statement, l_debug_key,

2226: fnd_log.string(l_log_statement, l_debug_key,
2227: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVED_INSTANCE_ID' || ': ' || P_X_PARTS_REC_TBL(i).REMOVED_INSTANCE_ID);
2228: fnd_log.string(l_log_statement, l_debug_key,
2229: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVED_INSTANCE_NUM' || ': ' || P_X_PARTS_REC_TBL(i).REMOVED_INSTANCE_NUM);
2230: fnd_log.string(l_log_statement, l_debug_key,
2231: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVED_INSTANCE_OBJ_VER_NUM' || ': ' || P_X_PARTS_REC_TBL(i).REMOVED_INSTANCE_OBJ_VER_NUM);
2232: fnd_log.string(l_log_statement, l_debug_key,
2233: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVED_QUANTITY' || ': ' || P_X_PARTS_REC_TBL(i).REMOVED_QUANTITY);
2234: fnd_log.string(l_log_statement, l_debug_key,

Line 2232: fnd_log.string(l_log_statement, l_debug_key,

2228: fnd_log.string(l_log_statement, l_debug_key,
2229: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVED_INSTANCE_NUM' || ': ' || P_X_PARTS_REC_TBL(i).REMOVED_INSTANCE_NUM);
2230: fnd_log.string(l_log_statement, l_debug_key,
2231: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVED_INSTANCE_OBJ_VER_NUM' || ': ' || P_X_PARTS_REC_TBL(i).REMOVED_INSTANCE_OBJ_VER_NUM);
2232: fnd_log.string(l_log_statement, l_debug_key,
2233: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVED_QUANTITY' || ': ' || P_X_PARTS_REC_TBL(i).REMOVED_QUANTITY);
2234: fnd_log.string(l_log_statement, l_debug_key,
2235: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVAL_CODE' || ': ' || P_X_PARTS_REC_TBL(i).REMOVAL_CODE);
2236: fnd_log.string(l_log_statement, l_debug_key,

Line 2234: fnd_log.string(l_log_statement, l_debug_key,

2230: fnd_log.string(l_log_statement, l_debug_key,
2231: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVED_INSTANCE_OBJ_VER_NUM' || ': ' || P_X_PARTS_REC_TBL(i).REMOVED_INSTANCE_OBJ_VER_NUM);
2232: fnd_log.string(l_log_statement, l_debug_key,
2233: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVED_QUANTITY' || ': ' || P_X_PARTS_REC_TBL(i).REMOVED_QUANTITY);
2234: fnd_log.string(l_log_statement, l_debug_key,
2235: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVAL_CODE' || ': ' || P_X_PARTS_REC_TBL(i).REMOVAL_CODE);
2236: fnd_log.string(l_log_statement, l_debug_key,
2237: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVAL_MEANING' || ': ' || P_X_PARTS_REC_TBL(i).REMOVAL_MEANING);
2238: fnd_log.string(l_log_statement, l_debug_key,

Line 2236: fnd_log.string(l_log_statement, l_debug_key,

2232: fnd_log.string(l_log_statement, l_debug_key,
2233: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVED_QUANTITY' || ': ' || P_X_PARTS_REC_TBL(i).REMOVED_QUANTITY);
2234: fnd_log.string(l_log_statement, l_debug_key,
2235: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVAL_CODE' || ': ' || P_X_PARTS_REC_TBL(i).REMOVAL_CODE);
2236: fnd_log.string(l_log_statement, l_debug_key,
2237: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVAL_MEANING' || ': ' || P_X_PARTS_REC_TBL(i).REMOVAL_MEANING);
2238: fnd_log.string(l_log_statement, l_debug_key,
2239: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVAL_REASON_ID' || ': ' || P_X_PARTS_REC_TBL(i).REMOVAL_REASON_ID);
2240: fnd_log.string(l_log_statement, l_debug_key,

Line 2238: fnd_log.string(l_log_statement, l_debug_key,

2234: fnd_log.string(l_log_statement, l_debug_key,
2235: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVAL_CODE' || ': ' || P_X_PARTS_REC_TBL(i).REMOVAL_CODE);
2236: fnd_log.string(l_log_statement, l_debug_key,
2237: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVAL_MEANING' || ': ' || P_X_PARTS_REC_TBL(i).REMOVAL_MEANING);
2238: fnd_log.string(l_log_statement, l_debug_key,
2239: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVAL_REASON_ID' || ': ' || P_X_PARTS_REC_TBL(i).REMOVAL_REASON_ID);
2240: fnd_log.string(l_log_statement, l_debug_key,
2241: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVAL_REASON_NAME' || ': ' || P_X_PARTS_REC_TBL(i).REMOVAL_REASON_NAME);
2242: fnd_log.string(l_log_statement, l_debug_key,

Line 2240: fnd_log.string(l_log_statement, l_debug_key,

2236: fnd_log.string(l_log_statement, l_debug_key,
2237: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVAL_MEANING' || ': ' || P_X_PARTS_REC_TBL(i).REMOVAL_MEANING);
2238: fnd_log.string(l_log_statement, l_debug_key,
2239: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVAL_REASON_ID' || ': ' || P_X_PARTS_REC_TBL(i).REMOVAL_REASON_ID);
2240: fnd_log.string(l_log_statement, l_debug_key,
2241: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVAL_REASON_NAME' || ': ' || P_X_PARTS_REC_TBL(i).REMOVAL_REASON_NAME);
2242: fnd_log.string(l_log_statement, l_debug_key,
2243: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVAL_DATE' || ': ' || P_X_PARTS_REC_TBL(i).REMOVAL_DATE);
2244: fnd_log.string(l_log_statement, l_debug_key,

Line 2242: fnd_log.string(l_log_statement, l_debug_key,

2238: fnd_log.string(l_log_statement, l_debug_key,
2239: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVAL_REASON_ID' || ': ' || P_X_PARTS_REC_TBL(i).REMOVAL_REASON_ID);
2240: fnd_log.string(l_log_statement, l_debug_key,
2241: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVAL_REASON_NAME' || ': ' || P_X_PARTS_REC_TBL(i).REMOVAL_REASON_NAME);
2242: fnd_log.string(l_log_statement, l_debug_key,
2243: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVAL_DATE' || ': ' || P_X_PARTS_REC_TBL(i).REMOVAL_DATE);
2244: fnd_log.string(l_log_statement, l_debug_key,
2245: ' P_X_PARTS_REC_TBL.(' || i || ').CONDITION_ID' || ': ' || P_X_PARTS_REC_TBL(i).CONDITION_ID);
2246: fnd_log.string(l_log_statement, l_debug_key,

Line 2244: fnd_log.string(l_log_statement, l_debug_key,

2240: fnd_log.string(l_log_statement, l_debug_key,
2241: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVAL_REASON_NAME' || ': ' || P_X_PARTS_REC_TBL(i).REMOVAL_REASON_NAME);
2242: fnd_log.string(l_log_statement, l_debug_key,
2243: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVAL_DATE' || ': ' || P_X_PARTS_REC_TBL(i).REMOVAL_DATE);
2244: fnd_log.string(l_log_statement, l_debug_key,
2245: ' P_X_PARTS_REC_TBL.(' || i || ').CONDITION_ID' || ': ' || P_X_PARTS_REC_TBL(i).CONDITION_ID);
2246: fnd_log.string(l_log_statement, l_debug_key,
2247: ' P_X_PARTS_REC_TBL.(' || i || ').CONDITION' || ': ' || P_X_PARTS_REC_TBL(i).CONDITION);
2248: fnd_log.string(l_log_statement, l_debug_key,

Line 2246: fnd_log.string(l_log_statement, l_debug_key,

2242: fnd_log.string(l_log_statement, l_debug_key,
2243: ' P_X_PARTS_REC_TBL.(' || i || ').REMOVAL_DATE' || ': ' || P_X_PARTS_REC_TBL(i).REMOVAL_DATE);
2244: fnd_log.string(l_log_statement, l_debug_key,
2245: ' P_X_PARTS_REC_TBL.(' || i || ').CONDITION_ID' || ': ' || P_X_PARTS_REC_TBL(i).CONDITION_ID);
2246: fnd_log.string(l_log_statement, l_debug_key,
2247: ' P_X_PARTS_REC_TBL.(' || i || ').CONDITION' || ': ' || P_X_PARTS_REC_TBL(i).CONDITION);
2248: fnd_log.string(l_log_statement, l_debug_key,
2249: ' P_X_PARTS_REC_TBL.(' || i || ').SEVERITY_ID' || ': ' || P_X_PARTS_REC_TBL(i).SEVERITY_ID);
2250: fnd_log.string(l_log_statement, l_debug_key,

Line 2248: fnd_log.string(l_log_statement, l_debug_key,

2244: fnd_log.string(l_log_statement, l_debug_key,
2245: ' P_X_PARTS_REC_TBL.(' || i || ').CONDITION_ID' || ': ' || P_X_PARTS_REC_TBL(i).CONDITION_ID);
2246: fnd_log.string(l_log_statement, l_debug_key,
2247: ' P_X_PARTS_REC_TBL.(' || i || ').CONDITION' || ': ' || P_X_PARTS_REC_TBL(i).CONDITION);
2248: fnd_log.string(l_log_statement, l_debug_key,
2249: ' P_X_PARTS_REC_TBL.(' || i || ').SEVERITY_ID' || ': ' || P_X_PARTS_REC_TBL(i).SEVERITY_ID);
2250: fnd_log.string(l_log_statement, l_debug_key,
2251: ' P_X_PARTS_REC_TBL.(' || i || ').SEVERITY_NAME' || ': ' || P_X_PARTS_REC_TBL(i).SEVERITY_NAME);
2252: fnd_log.string(l_log_statement, l_debug_key,

Line 2250: fnd_log.string(l_log_statement, l_debug_key,

2246: fnd_log.string(l_log_statement, l_debug_key,
2247: ' P_X_PARTS_REC_TBL.(' || i || ').CONDITION' || ': ' || P_X_PARTS_REC_TBL(i).CONDITION);
2248: fnd_log.string(l_log_statement, l_debug_key,
2249: ' P_X_PARTS_REC_TBL.(' || i || ').SEVERITY_ID' || ': ' || P_X_PARTS_REC_TBL(i).SEVERITY_ID);
2250: fnd_log.string(l_log_statement, l_debug_key,
2251: ' P_X_PARTS_REC_TBL.(' || i || ').SEVERITY_NAME' || ': ' || P_X_PARTS_REC_TBL(i).SEVERITY_NAME);
2252: fnd_log.string(l_log_statement, l_debug_key,
2253: ' P_X_PARTS_REC_TBL.(' || i || ').PROBLEM_CODE' || ': ' || P_X_PARTS_REC_TBL(i).PROBLEM_CODE);
2254: fnd_log.string(l_log_statement, l_debug_key,

Line 2252: fnd_log.string(l_log_statement, l_debug_key,

2248: fnd_log.string(l_log_statement, l_debug_key,
2249: ' P_X_PARTS_REC_TBL.(' || i || ').SEVERITY_ID' || ': ' || P_X_PARTS_REC_TBL(i).SEVERITY_ID);
2250: fnd_log.string(l_log_statement, l_debug_key,
2251: ' P_X_PARTS_REC_TBL.(' || i || ').SEVERITY_NAME' || ': ' || P_X_PARTS_REC_TBL(i).SEVERITY_NAME);
2252: fnd_log.string(l_log_statement, l_debug_key,
2253: ' P_X_PARTS_REC_TBL.(' || i || ').PROBLEM_CODE' || ': ' || P_X_PARTS_REC_TBL(i).PROBLEM_CODE);
2254: fnd_log.string(l_log_statement, l_debug_key,
2255: ' P_X_PARTS_REC_TBL.(' || i || ').PROBLEM_MEANING' || ': ' || P_X_PARTS_REC_TBL(i).PROBLEM_MEANING);
2256: fnd_log.string(l_log_statement, l_debug_key,

Line 2254: fnd_log.string(l_log_statement, l_debug_key,

2250: fnd_log.string(l_log_statement, l_debug_key,
2251: ' P_X_PARTS_REC_TBL.(' || i || ').SEVERITY_NAME' || ': ' || P_X_PARTS_REC_TBL(i).SEVERITY_NAME);
2252: fnd_log.string(l_log_statement, l_debug_key,
2253: ' P_X_PARTS_REC_TBL.(' || i || ').PROBLEM_CODE' || ': ' || P_X_PARTS_REC_TBL(i).PROBLEM_CODE);
2254: fnd_log.string(l_log_statement, l_debug_key,
2255: ' P_X_PARTS_REC_TBL.(' || i || ').PROBLEM_MEANING' || ': ' || P_X_PARTS_REC_TBL(i).PROBLEM_MEANING);
2256: fnd_log.string(l_log_statement, l_debug_key,
2257: ' P_X_PARTS_REC_TBL.(' || i || ').RESOLUTION_CODE' || ': ' || P_X_PARTS_REC_TBL(i).RESOLUTION_CODE);
2258: fnd_log.string(l_log_statement, l_debug_key,

Line 2256: fnd_log.string(l_log_statement, l_debug_key,

2252: fnd_log.string(l_log_statement, l_debug_key,
2253: ' P_X_PARTS_REC_TBL.(' || i || ').PROBLEM_CODE' || ': ' || P_X_PARTS_REC_TBL(i).PROBLEM_CODE);
2254: fnd_log.string(l_log_statement, l_debug_key,
2255: ' P_X_PARTS_REC_TBL.(' || i || ').PROBLEM_MEANING' || ': ' || P_X_PARTS_REC_TBL(i).PROBLEM_MEANING);
2256: fnd_log.string(l_log_statement, l_debug_key,
2257: ' P_X_PARTS_REC_TBL.(' || i || ').RESOLUTION_CODE' || ': ' || P_X_PARTS_REC_TBL(i).RESOLUTION_CODE);
2258: fnd_log.string(l_log_statement, l_debug_key,
2259: ' P_X_PARTS_REC_TBL.(' || i || ').RESOLUTION_MEANING' || ': ' || P_X_PARTS_REC_TBL(i).RESOLUTION_MEANING);
2260: fnd_log.string(l_log_statement, l_debug_key,

Line 2258: fnd_log.string(l_log_statement, l_debug_key,

2254: fnd_log.string(l_log_statement, l_debug_key,
2255: ' P_X_PARTS_REC_TBL.(' || i || ').PROBLEM_MEANING' || ': ' || P_X_PARTS_REC_TBL(i).PROBLEM_MEANING);
2256: fnd_log.string(l_log_statement, l_debug_key,
2257: ' P_X_PARTS_REC_TBL.(' || i || ').RESOLUTION_CODE' || ': ' || P_X_PARTS_REC_TBL(i).RESOLUTION_CODE);
2258: fnd_log.string(l_log_statement, l_debug_key,
2259: ' P_X_PARTS_REC_TBL.(' || i || ').RESOLUTION_MEANING' || ': ' || P_X_PARTS_REC_TBL(i).RESOLUTION_MEANING);
2260: fnd_log.string(l_log_statement, l_debug_key,
2261: ' P_X_PARTS_REC_TBL.(' || i || ').SUMMARY' || ': ' || P_X_PARTS_REC_TBL(i).SUMMARY);
2262: fnd_log.string(l_log_statement, l_debug_key,

Line 2260: fnd_log.string(l_log_statement, l_debug_key,

2256: fnd_log.string(l_log_statement, l_debug_key,
2257: ' P_X_PARTS_REC_TBL.(' || i || ').RESOLUTION_CODE' || ': ' || P_X_PARTS_REC_TBL(i).RESOLUTION_CODE);
2258: fnd_log.string(l_log_statement, l_debug_key,
2259: ' P_X_PARTS_REC_TBL.(' || i || ').RESOLUTION_MEANING' || ': ' || P_X_PARTS_REC_TBL(i).RESOLUTION_MEANING);
2260: fnd_log.string(l_log_statement, l_debug_key,
2261: ' P_X_PARTS_REC_TBL.(' || i || ').SUMMARY' || ': ' || P_X_PARTS_REC_TBL(i).SUMMARY);
2262: fnd_log.string(l_log_statement, l_debug_key,
2263: ' P_X_PARTS_REC_TBL.(' || i || ').ESTIMATED_DURATION' || ': ' || P_X_PARTS_REC_TBL(i).ESTIMATED_DURATION);
2264: fnd_log.string(l_log_statement, l_debug_key,

Line 2262: fnd_log.string(l_log_statement, l_debug_key,

2258: fnd_log.string(l_log_statement, l_debug_key,
2259: ' P_X_PARTS_REC_TBL.(' || i || ').RESOLUTION_MEANING' || ': ' || P_X_PARTS_REC_TBL(i).RESOLUTION_MEANING);
2260: fnd_log.string(l_log_statement, l_debug_key,
2261: ' P_X_PARTS_REC_TBL.(' || i || ').SUMMARY' || ': ' || P_X_PARTS_REC_TBL(i).SUMMARY);
2262: fnd_log.string(l_log_statement, l_debug_key,
2263: ' P_X_PARTS_REC_TBL.(' || i || ').ESTIMATED_DURATION' || ': ' || P_X_PARTS_REC_TBL(i).ESTIMATED_DURATION);
2264: fnd_log.string(l_log_statement, l_debug_key,
2265: ' P_X_PARTS_REC_TBL.(' || i || ').CREATE_WORK_ORDER_OPTION' || ': ' || P_X_PARTS_REC_TBL(i).CREATE_WORK_ORDER_OPTION);
2266: fnd_log.string(l_log_statement, l_debug_key,

Line 2264: fnd_log.string(l_log_statement, l_debug_key,

2260: fnd_log.string(l_log_statement, l_debug_key,
2261: ' P_X_PARTS_REC_TBL.(' || i || ').SUMMARY' || ': ' || P_X_PARTS_REC_TBL(i).SUMMARY);
2262: fnd_log.string(l_log_statement, l_debug_key,
2263: ' P_X_PARTS_REC_TBL.(' || i || ').ESTIMATED_DURATION' || ': ' || P_X_PARTS_REC_TBL(i).ESTIMATED_DURATION);
2264: fnd_log.string(l_log_statement, l_debug_key,
2265: ' P_X_PARTS_REC_TBL.(' || i || ').CREATE_WORK_ORDER_OPTION' || ': ' || P_X_PARTS_REC_TBL(i).CREATE_WORK_ORDER_OPTION);
2266: fnd_log.string(l_log_statement, l_debug_key,
2267: ' P_X_PARTS_REC_TBL.(' || i || ').CREATE_NR_FOR_PARENT' || ': ' || P_X_PARTS_REC_TBL(i).CREATE_NR_FOR_PARENT);
2268: fnd_log.string(l_log_statement, l_debug_key,

Line 2266: fnd_log.string(l_log_statement, l_debug_key,

2262: fnd_log.string(l_log_statement, l_debug_key,
2263: ' P_X_PARTS_REC_TBL.(' || i || ').ESTIMATED_DURATION' || ': ' || P_X_PARTS_REC_TBL(i).ESTIMATED_DURATION);
2264: fnd_log.string(l_log_statement, l_debug_key,
2265: ' P_X_PARTS_REC_TBL.(' || i || ').CREATE_WORK_ORDER_OPTION' || ': ' || P_X_PARTS_REC_TBL(i).CREATE_WORK_ORDER_OPTION);
2266: fnd_log.string(l_log_statement, l_debug_key,
2267: ' P_X_PARTS_REC_TBL.(' || i || ').CREATE_NR_FOR_PARENT' || ': ' || P_X_PARTS_REC_TBL(i).CREATE_NR_FOR_PARENT);
2268: fnd_log.string(l_log_statement, l_debug_key,
2269: ' P_X_PARTS_REC_TBL.(' || i || ').SERVICE_TYPE_CODE' || ': ' || P_X_PARTS_REC_TBL(i).SERVICE_TYPE_CODE);
2270: fnd_log.string(l_log_statement, l_debug_key,

Line 2268: fnd_log.string(l_log_statement, l_debug_key,

2264: fnd_log.string(l_log_statement, l_debug_key,
2265: ' P_X_PARTS_REC_TBL.(' || i || ').CREATE_WORK_ORDER_OPTION' || ': ' || P_X_PARTS_REC_TBL(i).CREATE_WORK_ORDER_OPTION);
2266: fnd_log.string(l_log_statement, l_debug_key,
2267: ' P_X_PARTS_REC_TBL.(' || i || ').CREATE_NR_FOR_PARENT' || ': ' || P_X_PARTS_REC_TBL(i).CREATE_NR_FOR_PARENT);
2268: fnd_log.string(l_log_statement, l_debug_key,
2269: ' P_X_PARTS_REC_TBL.(' || i || ').SERVICE_TYPE_CODE' || ': ' || P_X_PARTS_REC_TBL(i).SERVICE_TYPE_CODE);
2270: fnd_log.string(l_log_statement, l_debug_key,
2271: ' P_X_PARTS_REC_TBL.(' || i || ').SERVICE_TYPE' || ': ' || P_X_PARTS_REC_TBL(i).SERVICE_TYPE);
2272: fnd_log.string(l_log_statement, l_debug_key,

Line 2270: fnd_log.string(l_log_statement, l_debug_key,

2266: fnd_log.string(l_log_statement, l_debug_key,
2267: ' P_X_PARTS_REC_TBL.(' || i || ').CREATE_NR_FOR_PARENT' || ': ' || P_X_PARTS_REC_TBL(i).CREATE_NR_FOR_PARENT);
2268: fnd_log.string(l_log_statement, l_debug_key,
2269: ' P_X_PARTS_REC_TBL.(' || i || ').SERVICE_TYPE_CODE' || ': ' || P_X_PARTS_REC_TBL(i).SERVICE_TYPE_CODE);
2270: fnd_log.string(l_log_statement, l_debug_key,
2271: ' P_X_PARTS_REC_TBL.(' || i || ').SERVICE_TYPE' || ': ' || P_X_PARTS_REC_TBL(i).SERVICE_TYPE);
2272: fnd_log.string(l_log_statement, l_debug_key,
2273: ' P_X_PARTS_REC_TBL.(' || i || ').DISPOSITION_ID' || ': ' || P_X_PARTS_REC_TBL(i).DISPOSITION_ID);
2274: fnd_log.string(l_log_statement, l_debug_key,

Line 2272: fnd_log.string(l_log_statement, l_debug_key,

2268: fnd_log.string(l_log_statement, l_debug_key,
2269: ' P_X_PARTS_REC_TBL.(' || i || ').SERVICE_TYPE_CODE' || ': ' || P_X_PARTS_REC_TBL(i).SERVICE_TYPE_CODE);
2270: fnd_log.string(l_log_statement, l_debug_key,
2271: ' P_X_PARTS_REC_TBL.(' || i || ').SERVICE_TYPE' || ': ' || P_X_PARTS_REC_TBL(i).SERVICE_TYPE);
2272: fnd_log.string(l_log_statement, l_debug_key,
2273: ' P_X_PARTS_REC_TBL.(' || i || ').DISPOSITION_ID' || ': ' || P_X_PARTS_REC_TBL(i).DISPOSITION_ID);
2274: fnd_log.string(l_log_statement, l_debug_key,
2275: ' P_X_PARTS_REC_TBL.(' || i || ').DISP_OBJECT_VERSION_NUMBER' || ': ' || P_X_PARTS_REC_TBL(i).DISP_OBJECT_VERSION_NUMBER);
2276: fnd_log.string(l_log_statement, l_debug_key,

Line 2274: fnd_log.string(l_log_statement, l_debug_key,

2270: fnd_log.string(l_log_statement, l_debug_key,
2271: ' P_X_PARTS_REC_TBL.(' || i || ').SERVICE_TYPE' || ': ' || P_X_PARTS_REC_TBL(i).SERVICE_TYPE);
2272: fnd_log.string(l_log_statement, l_debug_key,
2273: ' P_X_PARTS_REC_TBL.(' || i || ').DISPOSITION_ID' || ': ' || P_X_PARTS_REC_TBL(i).DISPOSITION_ID);
2274: fnd_log.string(l_log_statement, l_debug_key,
2275: ' P_X_PARTS_REC_TBL.(' || i || ').DISP_OBJECT_VERSION_NUMBER' || ': ' || P_X_PARTS_REC_TBL(i).DISP_OBJECT_VERSION_NUMBER);
2276: fnd_log.string(l_log_statement, l_debug_key,
2277: ' P_X_PARTS_REC_TBL.(' || i || ').DISP_OPERATION_FLAG' || ': ' || P_X_PARTS_REC_TBL(i).DISP_OPERATION_FLAG);
2278: fnd_log.string(l_log_statement, l_debug_key,

Line 2276: fnd_log.string(l_log_statement, l_debug_key,

2272: fnd_log.string(l_log_statement, l_debug_key,
2273: ' P_X_PARTS_REC_TBL.(' || i || ').DISPOSITION_ID' || ': ' || P_X_PARTS_REC_TBL(i).DISPOSITION_ID);
2274: fnd_log.string(l_log_statement, l_debug_key,
2275: ' P_X_PARTS_REC_TBL.(' || i || ').DISP_OBJECT_VERSION_NUMBER' || ': ' || P_X_PARTS_REC_TBL(i).DISP_OBJECT_VERSION_NUMBER);
2276: fnd_log.string(l_log_statement, l_debug_key,
2277: ' P_X_PARTS_REC_TBL.(' || i || ').DISP_OPERATION_FLAG' || ': ' || P_X_PARTS_REC_TBL(i).DISP_OPERATION_FLAG);
2278: fnd_log.string(l_log_statement, l_debug_key,
2279: ' P_X_PARTS_REC_TBL.(' || i || ').IMMEDIATE_DISPOSITION_CODE' || ': ' || P_X_PARTS_REC_TBL(i).IMMEDIATE_DISPOSITION_CODE);
2280: fnd_log.string(l_log_statement, l_debug_key,

Line 2278: fnd_log.string(l_log_statement, l_debug_key,

2274: fnd_log.string(l_log_statement, l_debug_key,
2275: ' P_X_PARTS_REC_TBL.(' || i || ').DISP_OBJECT_VERSION_NUMBER' || ': ' || P_X_PARTS_REC_TBL(i).DISP_OBJECT_VERSION_NUMBER);
2276: fnd_log.string(l_log_statement, l_debug_key,
2277: ' P_X_PARTS_REC_TBL.(' || i || ').DISP_OPERATION_FLAG' || ': ' || P_X_PARTS_REC_TBL(i).DISP_OPERATION_FLAG);
2278: fnd_log.string(l_log_statement, l_debug_key,
2279: ' P_X_PARTS_REC_TBL.(' || i || ').IMMEDIATE_DISPOSITION_CODE' || ': ' || P_X_PARTS_REC_TBL(i).IMMEDIATE_DISPOSITION_CODE);
2280: fnd_log.string(l_log_statement, l_debug_key,
2281: ' P_X_PARTS_REC_TBL.(' || i || ').IMMEDIATE_DISPOSITION' || ': ' || P_X_PARTS_REC_TBL(i).IMMEDIATE_DISPOSITION);
2282: fnd_log.string(l_log_statement, l_debug_key,

Line 2280: fnd_log.string(l_log_statement, l_debug_key,

2276: fnd_log.string(l_log_statement, l_debug_key,
2277: ' P_X_PARTS_REC_TBL.(' || i || ').DISP_OPERATION_FLAG' || ': ' || P_X_PARTS_REC_TBL(i).DISP_OPERATION_FLAG);
2278: fnd_log.string(l_log_statement, l_debug_key,
2279: ' P_X_PARTS_REC_TBL.(' || i || ').IMMEDIATE_DISPOSITION_CODE' || ': ' || P_X_PARTS_REC_TBL(i).IMMEDIATE_DISPOSITION_CODE);
2280: fnd_log.string(l_log_statement, l_debug_key,
2281: ' P_X_PARTS_REC_TBL.(' || i || ').IMMEDIATE_DISPOSITION' || ': ' || P_X_PARTS_REC_TBL(i).IMMEDIATE_DISPOSITION);
2282: fnd_log.string(l_log_statement, l_debug_key,
2283: ' P_X_PARTS_REC_TBL.(' || i || ').SECONDARY_DISPOSITION_CODE' || ': ' || P_X_PARTS_REC_TBL(i).SECONDARY_DISPOSITION_CODE);
2284: fnd_log.string(l_log_statement, l_debug_key,

Line 2282: fnd_log.string(l_log_statement, l_debug_key,

2278: fnd_log.string(l_log_statement, l_debug_key,
2279: ' P_X_PARTS_REC_TBL.(' || i || ').IMMEDIATE_DISPOSITION_CODE' || ': ' || P_X_PARTS_REC_TBL(i).IMMEDIATE_DISPOSITION_CODE);
2280: fnd_log.string(l_log_statement, l_debug_key,
2281: ' P_X_PARTS_REC_TBL.(' || i || ').IMMEDIATE_DISPOSITION' || ': ' || P_X_PARTS_REC_TBL(i).IMMEDIATE_DISPOSITION);
2282: fnd_log.string(l_log_statement, l_debug_key,
2283: ' P_X_PARTS_REC_TBL.(' || i || ').SECONDARY_DISPOSITION_CODE' || ': ' || P_X_PARTS_REC_TBL(i).SECONDARY_DISPOSITION_CODE);
2284: fnd_log.string(l_log_statement, l_debug_key,
2285: ' P_X_PARTS_REC_TBL.(' || i || ').SECONDARY_DISPOSITION' || ': ' || P_X_PARTS_REC_TBL(i).SECONDARY_DISPOSITION);
2286: fnd_log.string(l_log_statement, l_debug_key,

Line 2284: fnd_log.string(l_log_statement, l_debug_key,

2280: fnd_log.string(l_log_statement, l_debug_key,
2281: ' P_X_PARTS_REC_TBL.(' || i || ').IMMEDIATE_DISPOSITION' || ': ' || P_X_PARTS_REC_TBL(i).IMMEDIATE_DISPOSITION);
2282: fnd_log.string(l_log_statement, l_debug_key,
2283: ' P_X_PARTS_REC_TBL.(' || i || ').SECONDARY_DISPOSITION_CODE' || ': ' || P_X_PARTS_REC_TBL(i).SECONDARY_DISPOSITION_CODE);
2284: fnd_log.string(l_log_statement, l_debug_key,
2285: ' P_X_PARTS_REC_TBL.(' || i || ').SECONDARY_DISPOSITION' || ': ' || P_X_PARTS_REC_TBL(i).SECONDARY_DISPOSITION);
2286: fnd_log.string(l_log_statement, l_debug_key,
2287: ' P_X_PARTS_REC_TBL.(' || i || ').DISP_COMMENTS' || ': ' || P_X_PARTS_REC_TBL(i).DISP_COMMENTS);
2288: fnd_log.string(l_log_statement, l_debug_key,

Line 2286: fnd_log.string(l_log_statement, l_debug_key,

2282: fnd_log.string(l_log_statement, l_debug_key,
2283: ' P_X_PARTS_REC_TBL.(' || i || ').SECONDARY_DISPOSITION_CODE' || ': ' || P_X_PARTS_REC_TBL(i).SECONDARY_DISPOSITION_CODE);
2284: fnd_log.string(l_log_statement, l_debug_key,
2285: ' P_X_PARTS_REC_TBL.(' || i || ').SECONDARY_DISPOSITION' || ': ' || P_X_PARTS_REC_TBL(i).SECONDARY_DISPOSITION);
2286: fnd_log.string(l_log_statement, l_debug_key,
2287: ' P_X_PARTS_REC_TBL.(' || i || ').DISP_COMMENTS' || ': ' || P_X_PARTS_REC_TBL(i).DISP_COMMENTS);
2288: fnd_log.string(l_log_statement, l_debug_key,
2289: ' P_X_PARTS_REC_TBL.(' || i || ').COLLECTION_ID' || ': ' || P_X_PARTS_REC_TBL(i).COLLECTION_ID);
2290: fnd_log.string(l_log_statement, l_debug_key,

Line 2288: fnd_log.string(l_log_statement, l_debug_key,

2284: fnd_log.string(l_log_statement, l_debug_key,
2285: ' P_X_PARTS_REC_TBL.(' || i || ').SECONDARY_DISPOSITION' || ': ' || P_X_PARTS_REC_TBL(i).SECONDARY_DISPOSITION);
2286: fnd_log.string(l_log_statement, l_debug_key,
2287: ' P_X_PARTS_REC_TBL.(' || i || ').DISP_COMMENTS' || ': ' || P_X_PARTS_REC_TBL(i).DISP_COMMENTS);
2288: fnd_log.string(l_log_statement, l_debug_key,
2289: ' P_X_PARTS_REC_TBL.(' || i || ').COLLECTION_ID' || ': ' || P_X_PARTS_REC_TBL(i).COLLECTION_ID);
2290: fnd_log.string(l_log_statement, l_debug_key,
2291: ' P_X_PARTS_REC_TBL.(' || i || ').PART_CHANGE_TXN_ID' || ': ' || P_X_PARTS_REC_TBL(i).PART_CHANGE_TXN_ID);
2292: fnd_log.string(l_log_statement, l_debug_key,

Line 2290: fnd_log.string(l_log_statement, l_debug_key,

2286: fnd_log.string(l_log_statement, l_debug_key,
2287: ' P_X_PARTS_REC_TBL.(' || i || ').DISP_COMMENTS' || ': ' || P_X_PARTS_REC_TBL(i).DISP_COMMENTS);
2288: fnd_log.string(l_log_statement, l_debug_key,
2289: ' P_X_PARTS_REC_TBL.(' || i || ').COLLECTION_ID' || ': ' || P_X_PARTS_REC_TBL(i).COLLECTION_ID);
2290: fnd_log.string(l_log_statement, l_debug_key,
2291: ' P_X_PARTS_REC_TBL.(' || i || ').PART_CHANGE_TXN_ID' || ': ' || P_X_PARTS_REC_TBL(i).PART_CHANGE_TXN_ID);
2292: fnd_log.string(l_log_statement, l_debug_key,
2293: ' P_X_PARTS_REC_TBL.(' || i || ').PATH_POSITION_ID' || ': ' || P_X_PARTS_REC_TBL(i).PATH_POSITION_ID);
2294: END LOOP;

Line 2292: fnd_log.string(l_log_statement, l_debug_key,

2288: fnd_log.string(l_log_statement, l_debug_key,
2289: ' P_X_PARTS_REC_TBL.(' || i || ').COLLECTION_ID' || ': ' || P_X_PARTS_REC_TBL(i).COLLECTION_ID);
2290: fnd_log.string(l_log_statement, l_debug_key,
2291: ' P_X_PARTS_REC_TBL.(' || i || ').PART_CHANGE_TXN_ID' || ': ' || P_X_PARTS_REC_TBL(i).PART_CHANGE_TXN_ID);
2292: fnd_log.string(l_log_statement, l_debug_key,
2293: ' P_X_PARTS_REC_TBL.(' || i || ').PATH_POSITION_ID' || ': ' || P_X_PARTS_REC_TBL(i).PATH_POSITION_ID);
2294: END LOOP;
2295: END IF;
2296:

Line 2373: fnd_log.string(l_log_statement, l_debug_key,

2369: P_PARTS_REC_TBL => P_X_PARTS_REC_TBL,
2370: X_INSTANCE_TBL => L_INSTANCE_TBL);
2371:
2372: IF (l_log_statement >= l_log_current_level) THEN
2373: fnd_log.string(l_log_statement, l_debug_key,
2374: ' L_INSTANCE_TBL.COUNT = ' || L_INSTANCE_TBL.COUNT);
2375: END IF;
2376:
2377: IF(L_INSTANCE_TBL IS NOT NULL AND L_INSTANCE_TBL.COUNT > 0)THEN

Line 2380: fnd_log.string(l_log_statement, l_debug_key,'cp 1 : ' || i);

2376:
2377: IF(L_INSTANCE_TBL IS NOT NULL AND L_INSTANCE_TBL.COUNT > 0)THEN
2378: for i IN L_INSTANCE_TBL.FIRST..L_INSTANCE_TBL.LAST LOOP
2379: IF (l_log_statement >= l_log_current_level) THEN
2380: fnd_log.string(l_log_statement, l_debug_key,'cp 1 : ' || i);
2381: END IF;
2382: for j IN P_X_PARTS_REC_TBL.FIRST..P_X_PARTS_REC_TBL.LAST LOOP
2383: IF (l_log_statement >= l_log_current_level) THEN
2384: fnd_log.string(l_log_statement, l_debug_key,'cp 2 : ' || j);

Line 2384: fnd_log.string(l_log_statement, l_debug_key,'cp 2 : ' || j);

2380: fnd_log.string(l_log_statement, l_debug_key,'cp 1 : ' || i);
2381: END IF;
2382: for j IN P_X_PARTS_REC_TBL.FIRST..P_X_PARTS_REC_TBL.LAST LOOP
2383: IF (l_log_statement >= l_log_current_level) THEN
2384: fnd_log.string(l_log_statement, l_debug_key,'cp 2 : ' || j);
2385: END IF;
2386: IF (l_log_statement >= l_log_current_level) THEN
2387: fnd_log.string(l_log_statement, l_debug_key,
2388: ' P_X_PARTS_REC_TBL.(' || j || ').OPERATION_TYPE' || ': ' || P_X_PARTS_REC_TBL(j).OPERATION_TYPE

Line 2387: fnd_log.string(l_log_statement, l_debug_key,

2383: IF (l_log_statement >= l_log_current_level) THEN
2384: fnd_log.string(l_log_statement, l_debug_key,'cp 2 : ' || j);
2385: END IF;
2386: IF (l_log_statement >= l_log_current_level) THEN
2387: fnd_log.string(l_log_statement, l_debug_key,
2388: ' P_X_PARTS_REC_TBL.(' || j || ').OPERATION_TYPE' || ': ' || P_X_PARTS_REC_TBL(j).OPERATION_TYPE
2389: || ' ** .PARENT_INSTALLED_INSTANCE_NUM : '|| NVL(P_X_PARTS_REC_TBL(j).PARENT_INSTALLED_INSTANCE_NUM,P_X_PARTS_REC_TBL(j).PARENT_INSTALLED_INSTANCE_ID)
2390: || ' ** .INSTALLED_INSTANCE_NUM : '|| P_X_PARTS_REC_TBL(j).INSTALLED_INSTANCE_NUM
2391: || ' ** .REMOVED_INSTANCE_NUM : '|| P_X_PARTS_REC_TBL(j).REMOVED_INSTANCE_NUM);

Line 2401: fnd_log.string(l_log_statement, l_debug_key,

2397: (P_X_PARTS_REC_TBL(j).OPERATION_TYPE = 'D' AND
2398: P_X_PARTS_REC_TBL(j).REMOVED_INSTANCE_NUM = L_INSTANCE_TBL(i).INSTANCE_NUMBER)
2399: )) THEN
2400: IF (l_log_statement >= l_log_current_level) THEN
2401: fnd_log.string(l_log_statement, l_debug_key,
2402: ' Invoking parts change for P_X_PARTS_REC_TBL.(' || j || ').OPERATION_TYPE' || ': ' || P_X_PARTS_REC_TBL(j).OPERATION_TYPE
2403: || ' ** .PARENT_INSTALLED_INSTANCE_NUM : '|| NVL(P_X_PARTS_REC_TBL(j).PARENT_INSTALLED_INSTANCE_NUM,P_X_PARTS_REC_TBL(j).PARENT_INSTALLED_INSTANCE_ID)
2404: || ' ** .INSTALLED_INSTANCE_NUM : '|| P_X_PARTS_REC_TBL(j).INSTALLED_INSTANCE_NUM
2405: || ' ** .REMOVED_INSTANCE_NUM : '|| P_X_PARTS_REC_TBL(j).REMOVED_INSTANCE_NUM);

Line 2416: fnd_log.string(l_log_statement, l_debug_key,

2412: X_MSG_DATA => l_MSG_DATA,
2413: X_WARNING_MSG_TBL => l_WARNING_MSG_TBL
2414: );
2415: IF (l_log_statement >= l_log_current_level) THEN
2416: fnd_log.string(l_log_statement, l_debug_key,
2417: ' parts change API Return status:' || l_RETURN_STATUS ||
2418: ': l_MSG_COUNT:' || l_MSG_COUNT || ': l_MSG_DATA:' || l_MSG_DATA);
2419: END IF;
2420: IF ( l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN

Line 2422: fnd_log.string(l_log_error, l_debug_key,

2418: ': l_MSG_COUNT:' || l_MSG_COUNT || ': l_MSG_DATA:' || l_MSG_DATA);
2419: END IF;
2420: IF ( l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN
2421: IF (l_log_error >= l_log_current_level) THEN
2422: fnd_log.string(l_log_error, l_debug_key,
2423: ' parts change API Return returned error status');
2424: END IF;
2425: X_RETURN_STATUS := l_RETURN_STATUS;
2426: X_ERROR_MSG_TBL(l_error_msg_index).MESSAGE_LEVEL := 'E' ;

Line 2480: fnd_log.string(l_log_error, l_debug_key,

2476: X_ERROR_MSG_TBL(l_error_msg_index).MESSAGE := X_ERROR_MSG_TBL(l_error_msg_index).MESSAGE || l_MSG_DATA ;
2477: END LOOP;
2478: END IF;
2479: IF (l_log_error >= l_log_current_level) THEN
2480: fnd_log.string(l_log_error, l_debug_key,
2481: 'X_ERROR_MSG_TBL(l_error_msg_index).MESSAGE : ' || X_ERROR_MSG_TBL(l_error_msg_index).MESSAGE);
2482: END IF;
2483: l_error_msg_index := l_error_msg_index + 1;
2484: END IF;

Line 2495: fnd_log.string(l_log_error, l_debug_key,

2491: IF ( X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN
2492: IF(X_ERROR_MSG_TBL IS NOT NULL AND X_ERROR_MSG_TBL.COUNT>0) THEN
2493: FOR i IN X_ERROR_MSG_TBL.FIRST..X_ERROR_MSG_TBL.LAST LOOP
2494: IF (l_log_error >= l_log_current_level) THEN
2495: fnd_log.string(l_log_error, l_debug_key,
2496: 'Error Message[' || i || ']:' || X_ERROR_MSG_TBL(i).MESSAGE );
2497: END IF;
2498: END LOOP;
2499: END IF;

Line 2519: fnd_log.string(l_log_procedure, l_debug_key,

2515: P_DATA => X_MSG_DATA,
2516: P_ENCODED => FND_API.G_FALSE);
2517:
2518: IF (l_log_procedure >= l_log_current_level) THEN
2519: fnd_log.string(l_log_procedure, l_debug_key,
2520: ' Exiting procedure');
2521: END IF;
2522: EXCEPTION
2523: WHEN FND_API.G_EXC_ERROR THEN

Line 2639: fnd_log.string(l_log_procedure, l_debug_key,

2635:
2636:
2637: BEGIN
2638: IF (l_log_procedure >= l_log_current_level) THEN
2639: fnd_log.string(l_log_procedure, l_debug_key,
2640: ' Entering procedure');
2641: END IF;
2642: L_PARTS_REC_TBL(0).WORKORDER_ID := P_X_PART_CHANGE_REC.WORKORDER_ID;
2643: L_PARTS_REC_TBL(0).OPERATION_SEQUENCE_NUM := P_X_PART_CHANGE_REC.OPERATION_SEQUENCE_NUM;

Line 2668: fnd_log.string(l_log_statement, l_debug_key,

2664: L_PARTS_REC_TBL(0).INSTALLED_INSTANCE_OBJ_VER_NUM := P_X_PART_CHANGE_REC.INSTALLED_INSTANCE_OBJ_VER_NUM;
2665: L_PARTS_REC_TBL(0).REMOVED_INSTANCE_OBJ_VER_NUM := P_X_PART_CHANGE_REC.REMOVED_INSTANCE_OBJ_VER_NUM;
2666:
2667: IF (l_log_statement >= l_log_current_level) THEN
2668: fnd_log.string(l_log_statement, l_debug_key,
2669: ' invoking AHL_PRD_PARTS_CHANGE_PVT.PROCESS_PART ');
2670: END IF;
2671: AHL_PRD_PARTS_CHANGE_PVT.PROCESS_PART (
2672: P_API_VERSION => 1.0,

Line 2686: fnd_log.string(l_log_statement, l_debug_key,

2682: X_MSG_DATA => X_MSG_DATA,
2683: X_WARNING_MSG_TBL => X_WARNING_MSG_TBL );
2684:
2685: IF (l_log_statement >= l_log_current_level) THEN
2686: fnd_log.string(l_log_statement, l_debug_key,
2687: ' AHL_PRD_PARTS_CHANGE_PVT.PROCESS_PART return status : ' || X_RETURN_STATUS);
2688: END IF;
2689:
2690: IF ( X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN

Line 2694: fnd_log.string(l_log_statement, l_debug_key,

2690: IF ( X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN
2691: RETURN;
2692: ELSE
2693: IF (l_log_statement >= l_log_current_level) THEN
2694: fnd_log.string(l_log_statement, l_debug_key,
2695: 'Initializing PART_CHANGE_TXN_ID');
2696: END IF;
2697: IF(P_X_PART_CHANGE_REC.PART_CHANGE_TXN_ID IS NULL)THEN
2698: P_X_PART_CHANGE_REC.PART_CHANGE_TXN_ID := L_PARTS_REC_TBL(0).PART_CHANGE_TXN_ID;

Line 2704: fnd_log.string(l_log_statement, l_debug_key,

2700: P_X_PART_CHANGE_REC.PATH_POSITION_ID := L_PARTS_REC_TBL(0).PATH_POSITION_ID;
2701: P_X_PART_CHANGE_REC.REMOVED_INSTANCE_ID := L_PARTS_REC_TBL(0).REMOVED_INSTANCE_ID;
2702: END IF;
2703: IF (l_log_statement >= l_log_current_level) THEN
2704: fnd_log.string(l_log_statement, l_debug_key,
2705: 'Initializing disposition record');
2706: END IF;
2707: L_DISPOSITION_REC.DISPOSITION_ID := P_X_PART_CHANGE_REC.DISPOSITION_ID;
2708: L_DISPOSITION_REC.OPERATION_FLAG := P_X_PART_CHANGE_REC.DISP_OPERATION_FLAG;

Line 2721: fnd_log.string(l_log_statement, l_debug_key,

2717: L_DISPOSITION_REC.SECONDARY_DISPOSITION := P_X_PART_CHANGE_REC.SECONDARY_DISPOSITION;
2718: L_DISPOSITION_REC.COMMENTS := P_X_PART_CHANGE_REC.DISP_COMMENTS;
2719:
2720: IF (l_log_statement >= l_log_current_level) THEN
2721: fnd_log.string(l_log_statement, l_debug_key,
2722: 'Done Part 1 of Initializing disposition record');
2723: END IF;
2724: IF(P_X_PART_CHANGE_REC.OPERATION_TYPE ='C') THEN
2725: IF(L_DISPOSITION_REC.OPERATION_FLAG = 'C')THEN

Line 2751: fnd_log.string(l_log_statement, l_debug_key,

2747: END IF;
2748: L_DISPOSITION_REC.SERVICE_TYPE := P_X_PART_CHANGE_REC.SERVICE_TYPE;
2749: L_DISPOSITION_REC.SERVICE_TYPE_CODE := P_X_PART_CHANGE_REC.SERVICE_TYPE_CODE;
2750: IF (l_log_statement >= l_log_current_level) THEN
2751: fnd_log.string(l_log_statement, l_debug_key,
2752: 'Done Part 2 of Initializing disposition record');
2753: END IF;
2754: IF(P_MR_ASSO_TBL IS NOT NULL AND P_MR_ASSO_TBL.COUNT > 0) THEN
2755: MR_TABLE_INDEX := 0;

Line 2770: fnd_log.string(l_log_statement, l_debug_key,

2766: END LOOP;
2767: END IF;
2768: END IF;
2769: IF (l_log_statement >= l_log_current_level) THEN
2770: fnd_log.string(l_log_statement, l_debug_key,
2771: ' invoking AHL_PRD_DISPOSITION_PVT.PROCESS_DISPOSITION ');
2772: END IF;
2773: AHL_PRD_DISPOSITION_PVT.PROCESS_DISPOSITION(
2774: P_API_VERSION => 1.0,

Line 2786: fnd_log.string(l_log_procedure, l_debug_key,

2782: X_MSG_COUNT => X_MSG_COUNT,
2783: X_MSG_DATA => X_MSG_DATA);
2784:
2785: IF (l_log_procedure >= l_log_current_level) THEN
2786: fnd_log.string(l_log_procedure, l_debug_key,
2787: ' Exiting procedure');
2788: END IF;
2789: END INVOKE_PART_CHANGE;
2790: ------------------------------------------------------------------------------------