APPS.WIP_BATCH_MOVE dependencies on QA_SS_CONST

Line 1133: qa_ss_const.department||'='||p_move_tbl(i).fm_department_code||'@'||

1129:
1130: FOR i IN 1..l_total_row LOOP
1131: -- Build l_context_values to pass to quality API.
1132: l_context_values :=
1133: qa_ss_const.department||'='||p_move_tbl(i).fm_department_code||'@'||
1134: qa_ss_const.quantity||'='||p_move_tbl(i).transaction_quantity||'@'||
1135: qa_ss_const.item||'='||p_move_tbl(i).primary_item_name||'@'||
1136: -- Pass empty string to item category as Bryan suggested.
1137: qa_ss_const.item_category||'=@'||

Line 1134: qa_ss_const.quantity||'='||p_move_tbl(i).transaction_quantity||'@'||

1130: FOR i IN 1..l_total_row LOOP
1131: -- Build l_context_values to pass to quality API.
1132: l_context_values :=
1133: qa_ss_const.department||'='||p_move_tbl(i).fm_department_code||'@'||
1134: qa_ss_const.quantity||'='||p_move_tbl(i).transaction_quantity||'@'||
1135: qa_ss_const.item||'='||p_move_tbl(i).primary_item_name||'@'||
1136: -- Pass empty string to item category as Bryan suggested.
1137: qa_ss_const.item_category||'=@'||
1138: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||

Line 1135: qa_ss_const.item||'='||p_move_tbl(i).primary_item_name||'@'||

1131: -- Build l_context_values to pass to quality API.
1132: l_context_values :=
1133: qa_ss_const.department||'='||p_move_tbl(i).fm_department_code||'@'||
1134: qa_ss_const.quantity||'='||p_move_tbl(i).transaction_quantity||'@'||
1135: qa_ss_const.item||'='||p_move_tbl(i).primary_item_name||'@'||
1136: -- Pass empty string to item category as Bryan suggested.
1137: qa_ss_const.item_category||'=@'||
1138: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1139: qa_ss_const.reason_code||'=@'||

Line 1137: qa_ss_const.item_category||'=@'||

1133: qa_ss_const.department||'='||p_move_tbl(i).fm_department_code||'@'||
1134: qa_ss_const.quantity||'='||p_move_tbl(i).transaction_quantity||'@'||
1135: qa_ss_const.item||'='||p_move_tbl(i).primary_item_name||'@'||
1136: -- Pass empty string to item category as Bryan suggested.
1137: qa_ss_const.item_category||'=@'||
1138: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1139: qa_ss_const.reason_code||'=@'||
1140: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_name||'@'||
1141: qa_ss_const.production_line||'=@'||

Line 1138: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||

1134: qa_ss_const.quantity||'='||p_move_tbl(i).transaction_quantity||'@'||
1135: qa_ss_const.item||'='||p_move_tbl(i).primary_item_name||'@'||
1136: -- Pass empty string to item category as Bryan suggested.
1137: qa_ss_const.item_category||'=@'||
1138: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1139: qa_ss_const.reason_code||'=@'||
1140: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_name||'@'||
1141: qa_ss_const.production_line||'=@'||
1142: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||

Line 1139: qa_ss_const.reason_code||'=@'||

1135: qa_ss_const.item||'='||p_move_tbl(i).primary_item_name||'@'||
1136: -- Pass empty string to item category as Bryan suggested.
1137: qa_ss_const.item_category||'=@'||
1138: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1139: qa_ss_const.reason_code||'=@'||
1140: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_name||'@'||
1141: qa_ss_const.production_line||'=@'||
1142: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1143: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||

Line 1140: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_name||'@'||

1136: -- Pass empty string to item category as Bryan suggested.
1137: qa_ss_const.item_category||'=@'||
1138: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1139: qa_ss_const.reason_code||'=@'||
1140: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_name||'@'||
1141: qa_ss_const.production_line||'=@'||
1142: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1143: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1144: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||

Line 1141: qa_ss_const.production_line||'=@'||

1137: qa_ss_const.item_category||'=@'||
1138: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1139: qa_ss_const.reason_code||'=@'||
1140: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_name||'@'||
1141: qa_ss_const.production_line||'=@'||
1142: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1143: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1144: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1145: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||

Line 1142: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||

1138: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1139: qa_ss_const.reason_code||'=@'||
1140: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_name||'@'||
1141: qa_ss_const.production_line||'=@'||
1142: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1143: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1144: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1145: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1146: qa_ss_const.sales_order||'=@'||

Line 1143: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||

1139: qa_ss_const.reason_code||'=@'||
1140: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_name||'@'||
1141: qa_ss_const.production_line||'=@'||
1142: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1143: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1144: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1145: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1146: qa_ss_const.sales_order||'=@'||
1147: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||

Line 1144: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||

1140: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_name||'@'||
1141: qa_ss_const.production_line||'=@'||
1142: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1143: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1144: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1145: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1146: qa_ss_const.sales_order||'=@'||
1147: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1148: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||

Line 1145: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||

1141: qa_ss_const.production_line||'=@'||
1142: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1143: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1144: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1145: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1146: qa_ss_const.sales_order||'=@'||
1147: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1148: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1149: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_code||'@'||

Line 1146: qa_ss_const.sales_order||'=@'||

1142: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1143: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1144: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1145: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1146: qa_ss_const.sales_order||'=@'||
1147: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1148: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1149: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_code||'@'||
1150: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||

Line 1147: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||

1143: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1144: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1145: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1146: qa_ss_const.sales_order||'=@'||
1147: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1148: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1149: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_code||'@'||
1150: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1151: qa_ss_const.project_number||'='||p_move_tbl(i).project_number||'@'||

Line 1148: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||

1144: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1145: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1146: qa_ss_const.sales_order||'=@'||
1147: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1148: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1149: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_code||'@'||
1150: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1151: qa_ss_const.project_number||'='||p_move_tbl(i).project_number||'@'||
1152: qa_ss_const.task_number||'='||p_move_tbl(i).task_number||'@'||

Line 1149: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_code||'@'||

1145: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1146: qa_ss_const.sales_order||'=@'||
1147: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1148: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1149: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_code||'@'||
1150: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1151: qa_ss_const.project_number||'='||p_move_tbl(i).project_number||'@'||
1152: qa_ss_const.task_number||'='||p_move_tbl(i).task_number||'@'||
1153: qa_ss_const.bom_revision||'='||p_move_tbl(i).bom_revision;

Line 1150: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||

1146: qa_ss_const.sales_order||'=@'||
1147: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1148: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1149: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_code||'@'||
1150: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1151: qa_ss_const.project_number||'='||p_move_tbl(i).project_number||'@'||
1152: qa_ss_const.task_number||'='||p_move_tbl(i).task_number||'@'||
1153: qa_ss_const.bom_revision||'='||p_move_tbl(i).bom_revision;
1154:

Line 1151: qa_ss_const.project_number||'='||p_move_tbl(i).project_number||'@'||

1147: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1148: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1149: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_code||'@'||
1150: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1151: qa_ss_const.project_number||'='||p_move_tbl(i).project_number||'@'||
1152: qa_ss_const.task_number||'='||p_move_tbl(i).task_number||'@'||
1153: qa_ss_const.bom_revision||'='||p_move_tbl(i).bom_revision;
1154:
1155: IF (l_log_level <= wip_constants.trace_logging) THEN

Line 1152: qa_ss_const.task_number||'='||p_move_tbl(i).task_number||'@'||

1148: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1149: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_code||'@'||
1150: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1151: qa_ss_const.project_number||'='||p_move_tbl(i).project_number||'@'||
1152: qa_ss_const.task_number||'='||p_move_tbl(i).task_number||'@'||
1153: qa_ss_const.bom_revision||'='||p_move_tbl(i).bom_revision;
1154:
1155: IF (l_log_level <= wip_constants.trace_logging) THEN
1156: wip_logger.log(p_msg => 'l_context_values='||l_context_values,

Line 1153: qa_ss_const.bom_revision||'='||p_move_tbl(i).bom_revision;

1149: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_code||'@'||
1150: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1151: qa_ss_const.project_number||'='||p_move_tbl(i).project_number||'@'||
1152: qa_ss_const.task_number||'='||p_move_tbl(i).task_number||'@'||
1153: qa_ss_const.bom_revision||'='||p_move_tbl(i).bom_revision;
1154:
1155: IF (l_log_level <= wip_constants.trace_logging) THEN
1156: wip_logger.log(p_msg => 'l_context_values='||l_context_values,
1157: x_returnStatus => l_return_status);

Line 1163: p_txn_number => qa_ss_const.wip_move_txn,

1159:
1160: BEGIN
1161: -- Check whether qualtiy collection plan exist or not
1162: l_quality_plan_exist := qa_txn_grp.evaluate_triggers(
1163: p_txn_number => qa_ss_const.wip_move_txn,
1164: p_org_id => p_org_id,
1165: p_context_values => l_context_values,
1166: x_plan_txn_ids => l_plan_txn_ids);
1167: IF(l_quality_plan_exist = fnd_api.g_false)THEN

Line 1178: p_txn_number => qa_ss_const.wip_move_txn,

1174: -- Fixed bug 5335024.Call is_commit_allowed() instead of commit_allowed()
1175: -- because is_commit_allowed will also check child quality plan.
1176: -- Moreover, is_commit_allowed will also return quality plan name.
1177: l_commit_allow := qa_txn_grp.is_commit_allowed(
1178: p_txn_number => qa_ss_const.wip_move_txn,
1179: p_org_id => p_org_id,
1180: p_plan_txn_ids => l_plan_txn_ids,
1181: --Pass 0 as Bryan suggested.
1182: p_collection_id => 0,