DBA Data[Home] [Help]

APPS.WIP_DEFAULT_SHOPFLOORMOVE dependencies on FND_MSG_PUB

Line 40: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_we_attr');

36: END IF;
37:
38: EXCEPTION
39: WHEN OTHERS THEN
40: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_we_attr');
41: END get_we_attr;
42:
43: PROCEDURE validate_default_sub_loc (p_wip_entity_id IN NUMBER,
44: p_org_id IN NUMBER,

Line 72: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','validate_default_sub_loc');

68: and WRI.COMPLETION_SUBINVENTORY IS NOT NULL));
69:
70: exception
71: when others then
72: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','validate_default_sub_loc');
73:
74: END validate_default_sub_loc;
75:
76: PROCEDURE validate_lot_control (p_wip_entity_id IN NUMBER,

Line 103: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','validate_lot_control');

99: or (we.entity_type = WIP_CONSTANTS.REPETITIVE) );
100:
101: exception
102: when others then
103: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','validate_lot_control');
104: END validate_lot_control;
105:
106: PROCEDURE validate_serial_control(p_wip_entity_id IN NUMBER,
107: p_org_id IN NUMBER,

Line 121: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','validate_serial_control');

117: and msi.serial_number_control_code in (2,5);
118:
119: exception
120: when others then
121: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','validate_serial_control');
122: END validate_serial_control;
123:
124: PROCEDURE validate_shop_floor_status (p_wip_entity_id IN NUMBER,
125: p_org_id IN NUMBER,

Line 151: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','validate_shop_floor_status');

147: and nvl(wsfsc.disable_date, sysdate + 1) > sysdate;
148:
149: exception
150: when others then
151: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','validate_shop_floor_status');
152: END validate_shop_floor_status;
153:
154: PROCEDURE validate_item_revision (p_wip_entity_id IN NUMBER,
155: p_org_id IN NUMBER,

Line 206: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','validate_item_revision');

202: )) );
203:
204: exception
205: when others then
206: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','validate_item_revision');
207: END validate_item_revision;
208:
209: PROCEDURE validate_last_op (p_wip_entity_id IN NUMBER,
210: p_org_id IN NUMBER,

Line 299: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_actual_move_ops: select from MSI,WE');

295: and msi.organization_id = we.organization_id
296: and INVENTORY_ITEM_ID = we.primary_item_id;
297: exception
298: when others then
299: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_actual_move_ops: select from MSI,WE');
300: end;
301:
302:
303:

Line 347: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_actual_move_ops');

343: end if;
344:
345: exception
346: when others then
347: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_actual_move_ops');
348: END get_actual_move_ops;
349:
350: PROCEDURE get_osp_move_details
351: IS

Line 489: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_osp_move_details');

485: nvl(nwop.repetitive_schedule_id(+), -1);
486:
487: exception
488: when others then
489: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_osp_move_details');
490: end ;
491:
492: get_actual_move_ops(
493: p_correction_type =>l_correction_type,

Line 568: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_osp_move_details');

564:
565:
566: EXCEPTION
567: WHEN OTHERS THEN
568: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_osp_move_details');
569: END get_osp_move_details;
570:
571:
572: FUNCTION Get_Acct_Period

Line 1171: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from WOR');

1167: and wor.organization_id = g_ShopFloorMove_rec.organization_id
1168: and wor.resource_seq_num = g_osp_rec.Resource_Seq_Num;
1169: exception
1170: when others then
1171: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from WOR');
1172: end;
1173:
1174: /* Modified sql for performance bug 9552415 (FP 9398894) */
1175: begin

Line 1201: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from UOM');

1197: )
1198: );
1199: exception
1200: when others then
1201: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from UOM');
1202: end;
1203:
1204:
1205:

Line 1213: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from RT');

1209: FROM rcv_transactions
1210: WHERE transaction_id = g_osp_rec.rcv_transaction_id;
1211: exception
1212: when others then
1213: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from RT');
1214: end;
1215:
1216: IF (l_interface_txn_id IS NULL) THEN
1217: RAISE fnd_api.g_exc_error;

Line 1227: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from RTI');

1223: FROM rcv_transactions_interface
1224: WHERE interface_transaction_id = l_interface_txn_id;
1225: exception
1226: when others then
1227: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from RTI');
1228: end;
1229:
1230: begin
1231: select decode (msi.outside_operation_uom_type,

Line 1251: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from MSI');

1247: where msi.inventory_item_id = l_osp_item_id
1248: and msi.organization_id = g_ShopFloorMove_rec.organization_id;
1249: exception
1250: when others then
1251: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from MSI');
1252: end;
1253:
1254: IF (l_logLevel <= wip_constants.full_logging) THEN
1255: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_pri_qty_delivered: '||l_total_pri_qty_delivered,l_returnStatus);

Line 1325: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from WO');

1321: end if;
1322:
1323: exception
1324: when others then
1325: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from WO');
1326: end;
1327:
1328:
1329: l_curr_qty_delivered := nvl(g_ShopFloorMove_rec.primary_quantity,0);

Line 2119: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2115: -- Check number of iterations.
2116:
2117: IF nvl(p_iteration,1) > WIP_GLOBALS.G_MAX_DEF_ITERATIONS THEN
2118:
2119: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2120: THEN
2121:
2122: FND_MESSAGE.SET_NAME('WIP','WIP_DEF_MAX_ITERATION');
2123: FND_MSG_PUB.Add;

Line 2123: FND_MSG_PUB.Add;

2119: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2120: THEN
2121:
2122: FND_MESSAGE.SET_NAME('WIP','WIP_DEF_MAX_ITERATION');
2123: FND_MSG_PUB.Add;
2124:
2125: END IF;
2126:
2127: RAISE FND_API.G_EXC_ERROR;