DBA Data[Home] [Help]

APPS.WMS_OP_RUNTIME_PVT_APIS dependencies on FND_NEW_MESSAGES

Line 45: x_msg_data OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE) IS

41: PROCEDURE insert_plan_instance
42: (p_insert_rec IN WMS_OP_PLAN_INSTANCES%ROWTYPE,
43: x_return_status OUT NOCOPY VARCHAR2,
44: x_msg_count OUT NOCOPY NUMBER,
45: x_msg_data OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE) IS
46:
47: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
48: l_module_name CONSTANT VARCHAR2(30) := 'Insert_Plan_Instance';
49:

Line 166: x_msg_data OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE) IS

162: PROCEDURE update_plan_instance
163: (p_update_rec IN WMS_OP_PLAN_INSTANCES%ROWTYPE,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE) IS
167:
168: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
169: l_module_name CONSTANT VARCHAR2(30) := 'Update_Plan_Instance';
170:

Line 272: x_msg_data OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE)IS

268: PROCEDURE delete_plan_instance
269: (p_op_plan_instance_id IN NUMBER,
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,
272: x_msg_data OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE)IS
273:
274: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
275: l_module_name CONSTANT VARCHAR2(30):= 'Delete_Plan_Instance';
276:

Line 339: x_msg_data OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE) IS

335: PROCEDURE insert_operation_instance
336: (p_insert_rec IN WMS_OP_OPERATION_INSTANCES%ROWTYPE,
337: x_return_status OUT NOCOPY VARCHAR2,
338: x_msg_count OUT NOCOPY NUMBER,
339: x_msg_data OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE) IS
340:
341: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
342: l_module_name CONSTANT VARCHAR2(30):='Insert_Operation_Instance';
343:

Line 470: x_msg_data OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE)IS

466: PROCEDURE delete_operation_instance
467: (p_operation_instance_id IN NUMBER,
468: x_return_status OUT NOCOPY VARCHAR2,
469: x_msg_count OUT NOCOPY NUMBER,
470: x_msg_data OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE)IS
471:
472: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
473: l_module_name CONSTANT VARCHAR2(30) :='Delete_operation_instance';
474:

Line 542: x_msg_data OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE)IS

538: PROCEDURE update_operation_instance
539: (p_update_rec IN WMS_OP_OPERATION_INSTANCES%ROWTYPE,
540: x_return_status OUT NOCOPY VARCHAR2,
541: x_msg_count OUT NOCOPY NUMBER,
542: x_msg_data OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE)IS
543:
544: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
545: l_module_name CONSTANT VARCHAR2(30):='Update_operation_instance';
546:

Line 659: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE

655: PROCEDURE archive_plan_instance(
656: p_op_plan_instance_id IN NUMBER
657: , x_return_status OUT NOCOPY VARCHAR2
658: , x_msg_count OUT NOCOPY NUMBER
659: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
660: )IS
661:
662:
663: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

Line 914: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE

910: PROCEDURE complete_plan_instance(
911: p_op_plan_instance_id IN NUMBER
912: , x_return_status OUT NOCOPY VARCHAR2
913: , x_msg_count OUT NOCOPY NUMBER
914: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
915: ) IS
916:
917: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
918: l_module_name CONSTANT VARCHAR2(30):='Complete_Plan_Instance';

Line 1019: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE

1015: p_wdt_rec IN wms_dispatched_tasks%ROWTYPE
1016: , p_source_task_id IN NUMBER
1017: , x_return_status OUT NOCOPY VARCHAR2
1018: , x_msg_count OUT NOCOPY NUMBER
1019: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
1020: )IS
1021:
1022: PRAGMA AUTONOMOUS_TRANSACTION;
1023:

Line 1172: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE

1168: p_source_task_id IN NUMBER
1169: , p_wms_task_type IN NUMBER
1170: , x_return_status OUT NOCOPY VARCHAR2
1171: , x_msg_count OUT NOCOPY NUMBER
1172: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
1173: )IS
1174: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1175: l_module_name CONSTANT VARCHAR2(30):='delete_dispatched_task';
1176: PRAGMA AUTONOMOUS_TRANSACTION;

Line 1215: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE

1211: PROCEDURE update_dipatched_tasks(
1212: p_wdt_rec IN wms_dispatched_tasks%ROWTYPE
1213: , x_return_status OUT NOCOPY VARCHAR2
1214: , x_msg_count OUT NOCOPY NUMBER
1215: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
1216: )IS
1217:
1218: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1219: l_module_name CONSTANT VARCHAR2(30):='Update_Dispatched_Tasks';

Line 1323: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE

1319:
1320: PROCEDURE archive_dispatched_tasks(
1321: x_return_status OUT NOCOPY VARCHAR2
1322: , x_msg_count OUT NOCOPY NUMBER
1323: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
1324: , p_task_id IN NUMBER
1325: , p_source_task_id IN NUMBER
1326: , p_activity_type_id IN NUMBER
1327: , p_op_plan_instance_id IN NUMBER