DBA Data[Home] [Help]

APPS.WIP_SO_RESERVATIONS dependencies on WIP_SO_RESERVATIONS

Line 1: PACKAGE BODY WIP_SO_RESERVATIONS as

1: PACKAGE BODY WIP_SO_RESERVATIONS as
2: /* $Header: wipsorvb.pls 120.7.12000000.2 2007/02/23 22:30:49 kboonyap ship $ */
3:
4:
5: -- ---------------------------------------------------------------------------

Line 706: wip_logger.entryPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',

702: if(l_logLevel <= wip_constants.trace_logging) then
703: l_params(1).paramName := 'not logging params';
704: l_params(1).paramValue := null;
705:
706: wip_logger.entryPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',
707: p_params => l_params,
708: x_returnStatus => l_return_status);
709: end if;
710: -------------------------------------

Line 1008: wip_logger.exitPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',

1004: END LOOP; -- loop through each completion form line
1005:
1006: x_return_status := fnd_api.g_ret_sts_success;
1007: if (l_logLevel <= wip_constants.trace_logging) then
1008: wip_logger.exitPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',
1009: p_procReturnStatus => x_return_status,
1010: p_msg => 'succeeded',
1011: x_returnStatus => l_return_status); --discard logging return status
1012: end if;

Line 1018: wip_logger.exitPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',

1014: WHEN g_need_to_rollback_exception THEN
1015: x_return_status := fnd_api.g_ret_sts_error;
1016: rollback to transfer_flow_lines_0;
1017: if (l_logLevel <= wip_constants.trace_logging) then
1018: wip_logger.exitPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',
1019: p_procReturnStatus => x_return_status,
1020: p_msg => 'error1',
1021: x_returnStatus => l_return_status); --discard logging return status
1022: end if;

Line 1031: wip_logger.exitPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',

1027: p_count => x_msg_count,
1028: p_data => x_msg_data);
1029: rollback to transfer_flow_lines_0;
1030: if (l_logLevel <= wip_constants.trace_logging) then
1031: wip_logger.exitPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',
1032: p_procReturnStatus => x_return_status,
1033: p_msg => 'error2',
1034: x_returnStatus => l_return_status); --discard logging return status
1035: end if;

Line 1044: wip_logger.exitPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',

1040: p_count => x_msg_count,
1041: p_data => x_msg_data);
1042: rollback to transfer_flow_lines_0;
1043: if (l_logLevel <= wip_constants.trace_logging) then
1044: wip_logger.exitPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',
1045: p_procReturnStatus => x_return_status,
1046: p_msg => 'error3',
1047: x_returnStatus => l_return_status); --discard logging return status
1048: end if;

Line 1063: wip_logger.exitPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',

1059: p_data => x_msg_data);
1060:
1061: rollback to transfer_flow_lines_0;
1062: if (l_logLevel <= wip_constants.trace_logging) then
1063: wip_logger.exitPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',
1064: p_procReturnStatus => x_return_status,
1065: p_msg => 'error4',
1066: x_returnStatus => l_return_status); --discard logging return status
1067: end if;

Line 1099: wip_logger.entryPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',

1095: l_params(3).paramValue := p_primary_quantity;
1096: l_params(4).paramName := 'p_lot_number';
1097: l_params(4).paramValue := p_lot_number;
1098:
1099: wip_logger.entryPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',
1100: p_params => l_params,
1101: x_returnStatus => l_return_status);
1102: end if;
1103:

Line 1141: wip_logger.exitPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',

1137: END IF;
1138: END IF;
1139:
1140: if (l_logLevel <= wip_constants.trace_logging) then
1141: wip_logger.exitPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',
1142: p_procReturnStatus => x_return_status,
1143: p_msg => 'succeeded',
1144: x_returnStatus => l_return_status); --discard logging return status
1145: end if;

Line 1149: wip_logger.exitPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',

1145: end if;
1146: EXCEPTION
1147: WHEN g_need_to_rollback_exception THEN
1148: if(l_logLevel <= wip_constants.trace_logging) then
1149: wip_logger.exitPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',
1150: p_procReturnStatus => x_return_status,
1151: p_msg => 'error1',
1152: x_returnStatus => l_return_status); --discard logging return status
1153: end if;

Line 1166: wip_logger.exitPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',

1162: x_msg_count := l_msg_count;
1163: end if;
1164: rollback to complete_flow_sched_to_so_1;
1165: if(l_logLevel <= wip_constants.trace_logging) then
1166: wip_logger.exitPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',
1167: p_procReturnStatus => x_return_status,
1168: p_msg => 'error2',
1169: x_returnStatus => l_return_Status); --discard logging return status
1170: end if;

Line 1178: wip_logger.exitPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',

1174: p_count => x_msg_count,
1175: p_data => x_msg_data);
1176: rollback to complete_flow_sched_to_so_1;
1177: if(l_logLevel <= wip_constants.trace_logging) then
1178: wip_logger.exitPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',
1179: p_procReturnStatus => x_return_Status,
1180: p_msg => 'error3',
1181: x_returnStatus => l_return_Status); --discard logging return status
1182: end if;

Line 1194: wip_logger.exitPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',

1190: p_count => x_msg_count,
1191: p_data => x_msg_data);
1192: rollback to complete_flow_sched_to_so_1;
1193: if(l_logLevel <= wip_constants.trace_logging) then
1194: wip_logger.exitPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',
1195: p_procReturnStatus => x_return_Status,
1196: p_msg => 'error4',
1197: x_returnStatus => l_return_Status); --discard logging return status
1198: end if;

Line 2809: END WIP_SO_RESERVATIONS;

2805: x_demand_source_line_id := l_rsv_array(1).demand_source_line_id;
2806:
2807: END lock_row;
2808:
2809: END WIP_SO_RESERVATIONS;