DBA Data[Home] [Help]

APPS.WMS_OP_RUNTIME_PVT_APIS dependencies on FND_PROFILE

Line 47: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

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:
50: BEGIN
51:

Line 168: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

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:
171: BEGIN
172:

Line 274: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

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:
277: BEGIN
278: x_return_status:=fnd_api.g_RET_STS_SUCCESS;

Line 341: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

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:
344: BEGIN
345: x_return_status:=fnd_api.g_ret_sts_success;

Line 472: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

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:
475: BEGIN
476: x_return_status:=fnd_api.G_RET_STS_SUCCESS;

Line 544: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

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:
547: BEGIN
548:

Line 663: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

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);
664: l_module_name CONSTANT VARCHAR2(30):='Archive_Plan_Instance';
665: l_progress NUMBER;
666:
667:

Line 917: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

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';
919: l_progress NUMBER;
920:
921: BEGIN

Line 1024: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

1020: )IS
1021:
1022: PRAGMA AUTONOMOUS_TRANSACTION;
1023:
1024: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1025: l_module_name CONSTANT VARCHAR2(30):='Insert_Dispatched_tasks';
1026:
1027: BEGIN
1028: IF (l_debug=1) THEN

Line 1164: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

1160: )IS
1161:
1162: --PRAGMA AUTONOMOUS_TRANSACTION;
1163:
1164: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1165: l_module_name CONSTANT VARCHAR2(30):='Insert_Dispatched_tasks';
1166:
1167: BEGIN
1168: IF (l_debug=1) THEN

Line 1314: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

1310: , x_return_status OUT NOCOPY VARCHAR2
1311: , x_msg_count OUT NOCOPY NUMBER
1312: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
1313: )IS
1314: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1315: l_module_name CONSTANT VARCHAR2(30):='delete_dispatched_task';
1316: PRAGMA AUTONOMOUS_TRANSACTION;
1317: BEGIN
1318:

Line 1358: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

1354: , x_msg_count OUT NOCOPY NUMBER
1355: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
1356: )IS
1357:
1358: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1359: l_module_name CONSTANT VARCHAR2(30):='Update_Dispatched_Tasks';
1360:
1361: BEGIN
1362: IF (l_debug=1) THEN

Line 1471: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

1467: , p_op_plan_instance_id IN NUMBER
1468: , p_op_plan_status IN NUMBER
1469: ) IS
1470:
1471: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1472: l_module_name CONSTANT VARCHAR2(30):= 'Archive_Dispatched_tasks';
1473: l_progress NUMBER;
1474: l_last_operation_dest_sub VARCHAR2(30);
1475: l_last_operation_dest_loc_id NUMBER;