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.CSD_RECEIVE_UTIL dependencies on CSD_RECEIVE_UTIL

Line 1: PACKAGE BODY csd_receive_util AS

1: PACKAGE BODY csd_receive_util AS
2: /* $Header: csdvrutb.pls 120.4.12000000.2 2007/04/24 17:55:51 swai ship $ */
3:
4: -- ---------------------------------------------------------
5: -- Define global variables

Line 99: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE.BEGIN',

95: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
96: THEN
97: fnd_log.STRING
98: (fnd_log.level_procedure,
99: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE.BEGIN',
100: 'Entered IS_AUTO_RCV_AVAILABLE'
101: );
102: END IF;
103:

Line 116: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',

112:
113: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
114: THEN
115: fnd_log.STRING (fnd_log.level_statement,
116: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',
117: 'Parameter:p_inventory_item_id['
118: || p_inventory_item_id
119: || ']'
120: );

Line 122: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',

118: || p_inventory_item_id
119: || ']'
120: );
121: fnd_log.STRING (fnd_log.level_statement,
122: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',
123: 'Parameter:p_inv_org_id[' || p_inv_org_id || ']'
124: );
125: fnd_log.STRING (fnd_log.level_statement,
126: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',

Line 126: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',

122: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',
123: 'Parameter:p_inv_org_id[' || p_inv_org_id || ']'
124: );
125: fnd_log.STRING (fnd_log.level_statement,
126: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',
127: 'Parameter:p_internal_RO_flag['
128: || p_internal_ro_flag
129: || ']'
130: );

Line 132: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',

128: || p_internal_ro_flag
129: || ']'
130: );
131: fnd_log.STRING (fnd_log.level_statement,
132: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',
133: 'Parameter:p_from_inv_org_id['
134: || p_from_inv_org_id
135: || ']'
136: );

Line 142: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',

138:
139: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
140: THEN
141: fnd_log.STRING (fnd_log.level_event,
142: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',
143: 'Checking item level routing'
144: );
145: END IF;
146:

Line 184: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',

180: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
181: THEN
182: fnd_log.STRING
183: (fnd_log.level_event,
184: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',
185: 'Checking shipping network level routing'
186: );
187: END IF;
188:

Line 211: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',

207: -- Organization level
208: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
209: THEN
210: fnd_log.STRING (fnd_log.level_event,
211: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',
212: 'Checking org level routing'
213: );
214: END IF;
215:

Line 301: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE.END',

297: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
298: THEN
299: fnd_log.STRING
300: (fnd_log.level_procedure,
301: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE.END',
302: 'Leaving IS_AUTO_RCV_AVAILABLE'
303: );
304: END IF;
305:

Line 328: p_receive_rec IN csd_receive_util.rcv_rec_type

324: /*-----------------------------------------------------------------------------------------------------------*/
325: PROCEDURE validate_rcv_input (
326: p_validation_level IN NUMBER,
327: x_return_status OUT NOCOPY VARCHAR2,
328: p_receive_rec IN csd_receive_util.rcv_rec_type
329: )
330: IS
331: l_tmp_char VARCHAR2 (1);
332: l_srl_Status VARCHAR2(30);

Line 368: 'CSD.PLSQL.CSD_RECEIVE_UTIL.VALIDATE_RCV_INPUT.BEGIN',

364: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
365: THEN
366: fnd_log.STRING
367: (fnd_log.level_procedure,
368: 'CSD.PLSQL.CSD_RECEIVE_UTIL.VALIDATE_RCV_INPUT.BEGIN',
369: 'Entered VALIDATE_RCV_INPUT'
370: );
371: END IF;
372:

Line 456: 'CSD.PLSQL.CSD_RECEIVE_UTIL.VALIDATE_RCV_INPUT.END',

452:
453: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
454: THEN
455: fnd_log.STRING (fnd_log.level_procedure,
456: 'CSD.PLSQL.CSD_RECEIVE_UTIL.VALIDATE_RCV_INPUT.END',
457: 'Leaving VALIDATE_RCV_INPUT'
458: );
459: END IF;
460:

Line 468: 'CSD.PLSQL.CSD_RECEIVE_UTIL.VALIDATE_RCV_INPUT',

464: x_return_status := fnd_api.g_ret_sts_error;
465: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
466: THEN
467: fnd_log.STRING (fnd_log.level_error,
468: 'CSD.PLSQL.CSD_RECEIVE_UTIL.VALIDATE_RCV_INPUT',
469: 'EXC_ERROR in validate_rcv_input '
470: );
471: END IF;
472: WHEN OTHERS

Line 484: 'CSD.PLSQL.CSD_RECEIVE_UTIL.VALIDATE_RCV_INPUT',

480:
481: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
482: THEN
483: fnd_log.STRING (fnd_log.level_unexpected,
484: 'CSD.PLSQL.CSD_RECEIVE_UTIL.VALIDATE_RCV_INPUT',
485: 'SQL Message in validate_rcv_input[' || SQLERRM || ']'
486: );
487: END IF;
488: END validate_rcv_input;

Line 503: x_rcv_error_msg_tbl OUT NOCOPY csd_receive_util.rcv_error_msg_tbl,

499: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
500: /*-----------------------------------------------------------------------------------------------------------*/
501: PROCEDURE check_rcv_errors (
502: x_return_status OUT NOCOPY VARCHAR2,
503: x_rcv_error_msg_tbl OUT NOCOPY csd_receive_util.rcv_error_msg_tbl,
504: p_request_group_id IN NUMBER
505: )
506: IS
507: l_api_version_number CONSTANT NUMBER := 1.0;

Line 560: 'CSD.PLSQL.CSD_RECEIVE_UTIL.CHECK_RCV_ERRORS.BEGIN',

556:
557: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
558: THEN
559: fnd_log.STRING (fnd_log.level_procedure,
560: 'CSD.PLSQL.CSD_RECEIVE_UTIL.CHECK_RCV_ERRORS.BEGIN',
561: 'Entered CHECK_RCV_ERRORS'
562: );
563: END IF;
564:

Line 647: 'CSD.PLSQL.CSD_RECEIVE_UTIL.CHECK_RCV_ERRORS.END',

643:
644: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
645: THEN
646: fnd_log.STRING (fnd_log.level_procedure,
647: 'CSD.PLSQL.CSD_RECEIVE_UTIL.CHECK_RCV_ERRORS.END',
648: 'Leaving CHECK_RCV_ERRORS'
649: );
650: END IF;
651: EXCEPTION

Line 664: 'CSD.PLSQL.CSD_RECEIVE_UTIL.CHECK_RCV_ERRORS',

660:
661: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
662: THEN
663: fnd_log.STRING (fnd_log.level_unexpected,
664: 'CSD.PLSQL.CSD_RECEIVE_UTIL.CHECK_RCV_ERRORS',
665: 'SQL Error Message in check_rcv_errors[' || SQLERRM || ']'
666: );
667: END IF;
668: END check_rcv_errors;

Line 701: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_EMPLOYEE_ID.BEGIN',

697: BEGIN
698: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
699: THEN
700: fnd_log.STRING (fnd_log.level_procedure,
701: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_EMPLOYEE_ID.BEGIN',
702: 'Entered get_employee_id'
703: );
704: END IF;
705:

Line 732: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_EMPLOYEE_ID.END',

728:
729: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
730: THEN
731: fnd_log.STRING (fnd_log.level_procedure,
732: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_EMPLOYEE_ID.END',
733: 'Leaving get_employee_id'
734: );
735: END IF;
736: EXCEPTION

Line 742: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_EMPLOYEE_ID',

738: THEN
739: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
740: THEN
741: fnd_log.STRING (fnd_log.level_exception,
742: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_EMPLOYEE_ID',
743: 'EXC_UNEXPECTED_ERROR in get_employee_id'
744: );
745: END IF;
746:

Line 753: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_EMPLOYEE_ID',

749: THEN
750: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
751: THEN
752: fnd_log.STRING (fnd_log.level_unexpected,
753: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_EMPLOYEE_ID',
754: 'SQL MEssage in get_employee_id[' || SQLERRM
755: || ']'
756: );
757: END IF;

Line 774: p_receive_rec IN OUT NOCOPY csd_receive_util.rcv_rec_type

770: /* fnd_api.g_ret_sts_error (error) */
771: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
772: /*-----------------------------------------------------------------------------------------------------------*/
773: PROCEDURE get_rcv_item_params (
774: p_receive_rec IN OUT NOCOPY csd_receive_util.rcv_rec_type
775: )
776: IS
777: --Define all the cursors
778: -- Cursor to get the to organization id

Line 845: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_RCV_ITEM_PARAMS.BEGIN',

841: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
842: THEN
843: fnd_log.STRING
844: (fnd_log.level_procedure,
845: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_RCV_ITEM_PARAMS.BEGIN',
846: 'Entered get_rcv_item_params'
847: );
848: END IF;
849:

Line 943: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_RCV_ITEM_PARAMS.END',

939: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
940: THEN
941: fnd_log.STRING
942: (fnd_log.level_procedure,
943: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_RCV_ITEM_PARAMS.END',
944: 'Leaving get_rcv_item_params'
945: );
946: END IF;
947:

Line 954: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_RCV_ITEM_PARAMS',

950: THEN
951: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
952: THEN
953: fnd_log.STRING (fnd_log.level_exception,
954: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_RCV_ITEM_PARAMS',
955: 'EXC_UNEXPECTED_ERROR in get_rcv_item_params'
956: );
957: END IF;
958:

Line 965: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_RCV_ITEM_PARAMS',

961: THEN
962: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
963: THEN
964: fnd_log.STRING (fnd_log.level_unexpected,
965: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_RCV_ITEM_PARAMS',
966: 'SQL Error Message in get_rcv_item_params ['
967: || SQLERRM
968: || ']'
969: );

Line 974: END csd_receive_util;

970: END IF;
971:
972: RAISE fnd_api.g_exc_unexpected_error;
973: END get_rcv_item_params;
974: END csd_receive_util;