eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_PR_PICK_SLIP_NUMBER dependencies on FND_API

Line 304: -- x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE

300:
301: --
302: -- Output Parameters
303: -- x_pick_slip_number => Pick Slip Number
304: -- x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE
305: -- x_api_status => FND_API.G_RET_STS_SUCESSS or
306: -- FND_API.G_RET_STS_ERROR
307: -- x_error_message => Error message
308:

Line 305: -- x_api_status => FND_API.G_RET_STS_SUCESSS or

301: --
302: -- Output Parameters
303: -- x_pick_slip_number => Pick Slip Number
304: -- x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE
305: -- x_api_status => FND_API.G_RET_STS_SUCESSS or
306: -- FND_API.G_RET_STS_ERROR
307: -- x_error_message => Error message
308:
309: PROCEDURE get_pick_slip_number(

Line 306: -- FND_API.G_RET_STS_ERROR

302: -- Output Parameters
303: -- x_pick_slip_number => Pick Slip Number
304: -- x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE
305: -- x_api_status => FND_API.G_RET_STS_SUCESSS or
306: -- FND_API.G_RET_STS_ERROR
307: -- x_error_message => Error message
308:
309: PROCEDURE get_pick_slip_number(
310: p_ps_mode IN VARCHAR2

Line 390: x_api_status := fnd_api.g_ret_sts_error;

386: FETCH get_limit INTO l_limit;
387:
388: IF get_limit%NOTFOUND THEN
389: x_error_message := 'Organization ' || TO_CHAR(p_org_id) || ' does not exist. ';
390: x_api_status := fnd_api.g_ret_sts_error;
391: RETURN;
392: END IF;
393:
394: g_prev_org_id := p_org_id;

Line 400: x_ready_to_print := fnd_api.g_false;

396: END IF;
397: END IF;
398:
399: -- Set ready to print flag to FALSE initially
400: x_ready_to_print := fnd_api.g_false;
401:
402: -- Bug 2777688: Do not store the pick slip numbers generated when the l_limt value is 1
403: -- as we want to generate a new one for each line
404: -- Bug 5212435: Store the pick slip number even when limit is 1

Line 411: x_ready_to_print := FND_API.G_TRUE;

407: INTO x_pick_slip_number
408: FROM dual;
409: wsh_pr_pick_slip_number.g_print_ps_table(wsh_pr_pick_slip_number.g_print_ps_table.COUNT + 1) :=
410: x_pick_slip_number;
411: x_ready_to_print := FND_API.G_TRUE;
412: x_api_status := FND_API.G_RET_STS_SUCCESS;
413: RETURN;
414: END IF;
415:

Line 412: x_api_status := FND_API.G_RET_STS_SUCCESS;

408: FROM dual;
409: wsh_pr_pick_slip_number.g_print_ps_table(wsh_pr_pick_slip_number.g_print_ps_table.COUNT + 1) :=
410: x_pick_slip_number;
411: x_ready_to_print := FND_API.G_TRUE;
412: x_api_status := FND_API.G_RET_STS_SUCCESS;
413: RETURN;
414: END IF;
415:
416: -- l_found is used to determine whether Grouping Rule exists in Rule Table.

Line 431: x_api_status := fnd_api.g_ret_sts_success;

427: SELECT wsh_pick_slip_numbers_s.NEXTVAL
428: INTO x_pick_slip_number
429: FROM DUAL;
430:
431: x_api_status := fnd_api.g_ret_sts_success;
432: RETURN;
433: END IF;
434:
435: -- Rule is not found. Fetch the attributes concerning the Pick Slip Grouping Rule

Line 463: x_api_status := fnd_api.g_ret_sts_error;

459: , g_rule_table(l_rule_index).pick_method;
460:
461: IF ps_rule%NOTFOUND THEN
462: x_error_message := 'Pick grouping rule ' || TO_CHAR(p_pick_grouping_rule_id) || ' does not exist';
463: x_api_status := fnd_api.g_ret_sts_error;
464: RETURN;
465: END IF;
466:
467: g_rule_table(l_rule_index).grouping_rule_id := p_pick_grouping_rule_id;

Line 510: x_api_status := fnd_api.g_ret_sts_success;

506: , x_error_message => x_error_message
507: );
508: END IF;
509:
510: x_api_status := fnd_api.g_ret_sts_success;
511: RETURN;
512: END IF;
513:
514: -- Comes here only if l_found is TRUE. (Grouping Rule is already cached)

Line 549: x_ready_to_print := fnd_api.g_true;

545:
546: -- Print is immediate so check if limit has been reached
547: IF (p_ps_mode = 'I' AND l_limit <> -1) THEN
548: IF (g_pskey_table(l_hash_value).counter >= l_limit) THEN
549: x_ready_to_print := fnd_api.g_true;
550: wsh_pr_pick_slip_number.g_print_ps_table(wsh_pr_pick_slip_number.g_print_ps_table.COUNT + 1) :=
551: x_pick_slip_number;
552: g_pskey_table.DELETE(l_hash_value);
553: END IF;

Line 565: x_api_status := fnd_api.g_ret_sts_success;

561: , x_error_message => x_error_message
562: );
563: END IF;
564:
565: x_api_status := fnd_api.g_ret_sts_success;
566: EXCEPTION
567: WHEN OTHERS THEN
568: x_error_message := 'Error occurred in INV_PR_PICK_NUMBER.GET_PICK_SLIP_NUMBER';
569: IF g_trace_on = 1 THEN

Line 572: x_api_status := fnd_api.g_ret_sts_unexp_error;

568: x_error_message := 'Error occurred in INV_PR_PICK_NUMBER.GET_PICK_SLIP_NUMBER';
569: IF g_trace_on = 1 THEN
570: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.GET_PICK_SLIP_NUMBER',3);
571: END IF;
572: x_api_status := fnd_api.g_ret_sts_unexp_error;
573: END get_pick_slip_number;
574:
575: /***********************************************************************************************
576: * *

Line 777: -- x_api_status => FND_API.G_RET_STS_SUCESSS or

773: -- p_lot_number => Lot Number
774: --
775: -- Output Parameters
776: -- x_pick_slip_number => Pick Slip Number
777: -- x_api_status => FND_API.G_RET_STS_SUCESSS or
778: -- FND_API.G_RET_STS_ERROR
779: -- x_error_message => Error message
780: --
781: PROCEDURE get_pick_slip_number(

Line 778: -- FND_API.G_RET_STS_ERROR

774: --
775: -- Output Parameters
776: -- x_pick_slip_number => Pick Slip Number
777: -- x_api_status => FND_API.G_RET_STS_SUCESSS or
778: -- FND_API.G_RET_STS_ERROR
779: -- x_error_message => Error message
780: --
781: PROCEDURE get_pick_slip_number(
782: p_pick_grouping_rule_id IN NUMBER

Line 841: x_api_status := fnd_api.g_ret_sts_success;

837: SELECT wsh_pick_slip_numbers_s.NEXTVAL
838: INTO x_pick_slip_number
839: FROM DUAL;
840:
841: x_api_status := fnd_api.g_ret_sts_success;
842: RETURN;
843: END IF;
844:
845: -- Rule is not found. Fetch the attributes concerning the Pick Slip Grouping Rule

Line 866: x_api_status := fnd_api.g_ret_sts_error;

862: , g_rule_table(l_rule_index).pick_method;
863:
864: IF ps_rule%NOTFOUND THEN
865: x_error_message := 'Pick grouping rule ' || TO_CHAR(p_pick_grouping_rule_id) || ' does not exist';
866: x_api_status := fnd_api.g_ret_sts_error;
867: RETURN;
868: END IF;
869:
870: g_rule_table(l_rule_index).grouping_rule_id := p_pick_grouping_rule_id;

Line 911: x_api_status := fnd_api.g_ret_sts_success;

907: , x_error_message => x_error_message
908: );
909: END IF;
910:
911: x_api_status := fnd_api.g_ret_sts_success;
912: RETURN;
913: END IF;
914:
915: -- Comes here only if l_found is TRUE. (Grouping Rule is already cached)

Line 952: x_api_status := fnd_api.g_ret_sts_success;

948: , x_pick_slip_number => x_pick_slip_number
949: , x_error_message => x_error_message
950: );
951: END IF;
952: x_api_status := fnd_api.g_ret_sts_success;
953: EXCEPTION
954: WHEN OTHERS THEN
955: x_error_message := 'Error occurred in INV_PR_PICK_NUMBER.GET_PICK_SLIP_NUMBER';
956: IF g_trace_on = 1 THEN

Line 959: x_api_status := fnd_api.g_ret_sts_unexp_error;

955: x_error_message := 'Error occurred in INV_PR_PICK_NUMBER.GET_PICK_SLIP_NUMBER';
956: IF g_trace_on = 1 THEN
957: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.GET_PICK_SLIP_NUMBER',3);
958: END IF;
959: x_api_status := fnd_api.g_ret_sts_unexp_error;
960: END get_pick_slip_number;
961:
962: --
963: -- Name

Line 975: -- x_return_status => FND_API.G_RET_STS_SUCESSS or

971: -- p_mo_request_number => Move Order Request Number
972: --
973: -- Output Parameters
974: -- x_request_id => Concurrent Request ID
975: -- x_return_status => FND_API.G_RET_STS_SUCESSS or
976: -- FND_API.G_RET_STS_ERROR
977: -- x_msg_data => Error Messages
978: -- x_msg_count => Error Messages Count
979: FUNCTION print_pick_slip(

Line 976: -- FND_API.G_RET_STS_ERROR

972: --
973: -- Output Parameters
974: -- x_request_id => Concurrent Request ID
975: -- x_return_status => FND_API.G_RET_STS_SUCESSS or
976: -- FND_API.G_RET_STS_ERROR
977: -- x_msg_data => Error Messages
978: -- x_msg_count => Error Messages Count
979: FUNCTION print_pick_slip(
980: x_return_status OUT NOCOPY VARCHAR2

Line 1001: x_return_status := fnd_api.g_ret_sts_error;

997: , p_plan_tasks => l_plan_tasks
998: );
999:
1000: IF l_request_id = 0 THEN
1001: x_return_status := fnd_api.g_ret_sts_error;
1002: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false,p_data=>x_msg_data, p_count=>x_msg_count);
1003: ELSE
1004: x_return_status := fnd_api.g_ret_sts_success;
1005: END IF;

Line 1002: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false,p_data=>x_msg_data, p_count=>x_msg_count);

998: );
999:
1000: IF l_request_id = 0 THEN
1001: x_return_status := fnd_api.g_ret_sts_error;
1002: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false,p_data=>x_msg_data, p_count=>x_msg_count);
1003: ELSE
1004: x_return_status := fnd_api.g_ret_sts_success;
1005: END IF;
1006:

Line 1004: x_return_status := fnd_api.g_ret_sts_success;

1000: IF l_request_id = 0 THEN
1001: x_return_status := fnd_api.g_ret_sts_error;
1002: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false,p_data=>x_msg_data, p_count=>x_msg_count);
1003: ELSE
1004: x_return_status := fnd_api.g_ret_sts_success;
1005: END IF;
1006:
1007: RETURN l_request_id;
1008: END print_pick_slip;

Line 1204: x_api_status := fnd_api.g_ret_sts_success;

1200: wait_timeout_exc EXCEPTION;
1201: PRAGMA EXCEPTION_INIT (wait_timeout_exc, -30006);
1202:
1203: BEGIN
1204: x_api_status := fnd_api.g_ret_sts_success;
1205: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1206:
1207: IF (l_debug = 1) THEN
1208: inv_log_util.trace('p_hash_string = ' || p_hash_string,

Line 1359: x_api_status := fnd_api.g_ret_sts_unexp_error;

1355:
1356: EXCEPTION
1357: WHEN OTHERS THEN
1358: x_error_message := 'Error occurred in GEN_PARALLEL_PICK_SLIP_NUMBER';
1359: x_api_status := fnd_api.g_ret_sts_unexp_error;
1360: IF (l_debug = 1) THEN
1361: inv_log_util.trace('Exception: ' || SQLERRM,
1362: 'INV_PR_PICK_SLIP_NUMBER.GEN_PARALLEL_PICK_SLIP_NUMBER',3);
1363: END IF;

Line 1399: -- x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE

1395:
1396: --
1397: -- Output Parameters
1398: -- x_pick_slip_number => Pick Slip Number
1399: -- x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE
1400: -- x_api_status => FND_API.G_RET_STS_SUCESSS or
1401: -- FND_API.G_RET_STS_ERROR
1402: -- x_error_message => Error message
1403:

Line 1400: -- x_api_status => FND_API.G_RET_STS_SUCESSS or

1396: --
1397: -- Output Parameters
1398: -- x_pick_slip_number => Pick Slip Number
1399: -- x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE
1400: -- x_api_status => FND_API.G_RET_STS_SUCESSS or
1401: -- FND_API.G_RET_STS_ERROR
1402: -- x_error_message => Error message
1403:
1404: PROCEDURE get_pick_slip_number_parallel(

Line 1401: -- FND_API.G_RET_STS_ERROR

1397: -- Output Parameters
1398: -- x_pick_slip_number => Pick Slip Number
1399: -- x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE
1400: -- x_api_status => FND_API.G_RET_STS_SUCESSS or
1401: -- FND_API.G_RET_STS_ERROR
1402: -- x_error_message => Error message
1403:
1404: PROCEDURE get_pick_slip_number_parallel(
1405: p_ps_mode IN VARCHAR2

Line 1478: x_api_status := fnd_api.g_ret_sts_error;

1474: FETCH get_limit INTO l_limit;
1475:
1476: IF get_limit%NOTFOUND THEN
1477: x_error_message := 'Organization ' || TO_CHAR(p_org_id) || ' does not exist. ';
1478: x_api_status := fnd_api.g_ret_sts_error;
1479: RETURN;
1480: END IF;
1481:
1482: g_prev_org_id := p_org_id;

Line 1488: x_ready_to_print := fnd_api.g_false;

1484: END IF;
1485: END IF;
1486:
1487: -- Set ready to print flag to FALSE initially
1488: x_ready_to_print := fnd_api.g_false;
1489:
1490: IF (p_ps_mode = 'I' AND l_limit = 1) THEN
1491: SELECT wsh_pick_slip_numbers_s.NEXTVAL
1492: INTO x_pick_slip_number

Line 1496: x_ready_to_print := FND_API.G_TRUE;

1492: INTO x_pick_slip_number
1493: FROM dual;
1494: wsh_pr_pick_slip_number.g_print_ps_table(wsh_pr_pick_slip_number.g_print_ps_table.COUNT + 1) :=
1495: x_pick_slip_number;
1496: x_ready_to_print := FND_API.G_TRUE;
1497: x_api_status := FND_API.G_RET_STS_SUCCESS;
1498: RETURN;
1499: END IF;
1500:

Line 1497: x_api_status := FND_API.G_RET_STS_SUCCESS;

1493: FROM dual;
1494: wsh_pr_pick_slip_number.g_print_ps_table(wsh_pr_pick_slip_number.g_print_ps_table.COUNT + 1) :=
1495: x_pick_slip_number;
1496: x_ready_to_print := FND_API.G_TRUE;
1497: x_api_status := FND_API.G_RET_STS_SUCCESS;
1498: RETURN;
1499: END IF;
1500:
1501: l_found := FALSE;

Line 1531: x_api_status := fnd_api.g_ret_sts_error;

1527: , g_rule_table(l_rule_index).pick_method;
1528:
1529: IF ps_rule%NOTFOUND THEN
1530: x_error_message := 'Pick grouping rule ' || TO_CHAR(p_pick_grouping_rule_id) || ' does not exist';
1531: x_api_status := fnd_api.g_ret_sts_error;
1532: RETURN;
1533: END IF;
1534:
1535: g_rule_table(l_rule_index).grouping_rule_id := p_pick_grouping_rule_id;

Line 1543: x_api_status := fnd_api.g_ret_sts_success;

1539: SELECT wsh_pick_slip_numbers_s.NEXTVAL
1540: INTO x_pick_slip_number
1541: FROM DUAL;
1542:
1543: x_api_status := fnd_api.g_ret_sts_success;
1544: RETURN;
1545: END IF;
1546:
1547: create_pick_slip_string(

Line 1578: IF (x_api_status <> fnd_api.g_ret_sts_success) THEN

1574: ,x_error_message => x_error_message
1575: ,x_api_status => x_api_status
1576: ,x_pick_slip_status => l_pick_slip_status);
1577:
1578: IF (x_api_status <> fnd_api.g_ret_sts_success) THEN
1579: x_error_message := 'Error occurred in INV_PR_PICK_SLIP_NUMBER.GEN_PARALLEL_PICK_SLIP_NUMBER';
1580: RETURN;
1581: END IF;
1582:

Line 1585: x_ready_to_print := fnd_api.g_true;

1581: END IF;
1582:
1583: IF (p_ps_mode = 'I' AND l_limit <> -1) THEN
1584: IF l_pick_slip_status = 2 THEN
1585: x_ready_to_print := fnd_api.g_true;
1586: wsh_pr_pick_slip_number.g_print_ps_table(wsh_pr_pick_slip_number.g_print_ps_table.COUNT + 1) :=
1587: x_pick_slip_number;
1588: --<< check if deletion from the table is required, if so we can delete instead of update >>
1589: END IF;

Line 1592: x_api_status := fnd_api.g_ret_sts_success;

1588: --<< check if deletion from the table is required, if so we can delete instead of update >>
1589: END IF;
1590: END IF;
1591:
1592: x_api_status := fnd_api.g_ret_sts_success;
1593: EXCEPTION
1594: WHEN OTHERS THEN
1595: x_error_message := 'Error occurred in INV_PR_PICK_SLIP_NUMBER.GET_PICK_SLIP_NUMBER';
1596: IF g_trace_on = 1 THEN

Line 1599: x_api_status := fnd_api.g_ret_sts_unexp_error;

1595: x_error_message := 'Error occurred in INV_PR_PICK_SLIP_NUMBER.GET_PICK_SLIP_NUMBER';
1596: IF g_trace_on = 1 THEN
1597: inv_log_util.trace('Exception: ' || SQLERRM,'INV_PR_PICK_SLIP_NUMBER.GET_PICK_SLIP_NUMBER',3);
1598: END IF;
1599: x_api_status := fnd_api.g_ret_sts_unexp_error;
1600:
1601: END get_pick_slip_number_parallel;
1602:
1603: END inv_pr_pick_slip_number;