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.RCV_ROI_TRANSACTION dependencies on RCV_ROI_HEADER

Line 1347: AND (rcv_roi_header.g_txn_against_asn = 'Y')) THEN --{ /* Bug4523892 */

1343: ** holds that information and is being used here
1344: */
1345: IF ( NVL(x_header_record.header_record.asn_type, 'STD') = 'STD'
1346: AND x_cascaded_table(n).transaction_type = 'RECEIVE'
1347: AND (rcv_roi_header.g_txn_against_asn = 'Y')) THEN --{ /* Bug4523892 */
1348:
1349: x_cascaded_table(n).shipment_header_id := x_header_record.header_record.receipt_header_id;
1350:
1351: IF (g_asn_debug = 'Y') THEN

Line 3150: IF (rcv_roi_header.g_txn_against_asn = 'Y') THEN --{ Bug#4523892

3146: /* IF (x_is_asn = TRUE) THEN --{ */
3147: /* Forward port for Bug 4523892 , the use of x_is_asn is commented to make it consistent
3148: with the previous code line
3149: */
3150: IF (rcv_roi_header.g_txn_against_asn = 'Y') THEN --{ Bug#4523892
3151: IF (g_asn_debug = 'Y') THEN
3152: asn_debug.put_line('Open ASN Shipment records');
3153: asn_debug.put_line('shipment_header_id ' || temp_cascaded_table(current_n).shipment_header_id);
3154: asn_debug.put_line('shipment_line_id ' || temp_cascaded_table(current_n).shipment_line_id);

Line 3254: IF (rcv_roi_header.g_txn_against_asn = 'Y') THEN --{ Bug#4523892

3250: asn_debug.put_line('Proceed to open cursor');
3251: END IF;
3252:
3253: /* IF (x_is_asn = TRUE) THEN --{ This call is replaced by forward port of 4523892 */
3254: IF (rcv_roi_header.g_txn_against_asn = 'Y') THEN --{ Bug#4523892
3255: IF (g_asn_debug = 'Y') THEN
3256: asn_debug.put_line('Open ASN Distribution records');
3257: asn_debug.put_line('shipment_header_id ' || temp_cascaded_table(current_n).shipment_header_id);
3258: asn_debug.put_line('shipment_line_id ' || temp_cascaded_table(current_n).shipment_line_id);

Line 3385: IF (rcv_roi_header.g_txn_against_asn = 'Y') THEN --{ Bug#4523892

3381: */
3382: IF ( x_cascaded_table(n).transaction_type <> 'DELIVER'
3383: AND NVL(x_cascaded_table(n).auto_transact_code, 'RECEIVE') <> 'DELIVER') THEN --{
3384: /* IF (x_is_asn = TRUE) THEN --{ This is replaced by forward port for bug 4523892 */
3385: IF (rcv_roi_header.g_txn_against_asn = 'Y') THEN --{ Bug#4523892
3386: IF (g_asn_debug = 'Y') THEN
3387: asn_debug.put_line('Count of asn shipments');
3388: END IF;
3389:

Line 3400: IF (rcv_roi_header.g_txn_against_asn = 'Y') THEN --{ Bug#4523892

3396: FETCH count_shipments INTO x_record_count;
3397: END IF; --}
3398: ELSE --}{
3399: /* IF (x_is_asn = TRUE) THEN --{ This is replaced by forward port for Bug 4523892 */
3400: IF (rcv_roi_header.g_txn_against_asn = 'Y') THEN --{ Bug#4523892
3401: IF (g_asn_debug = 'Y') THEN
3402: asn_debug.put_line('Count of asn distributions');
3403: END IF;
3404:

Line 4055: IF (rcv_roi_header.g_txn_against_asn = 'Y') THEN --{ Bug#4523892

4051: asn_debug.put_line('Should have give us the exact error ');
4052: END IF;
4053:
4054: /* IF (x_is_asn = TRUE) THEN --{ This is replaced by forward port for Bug 4523892 */
4055: IF (rcv_roi_header.g_txn_against_asn = 'Y') THEN --{ Bug#4523892
4056: /* Error messages specific to asns. */
4057: IF (g_asn_debug = 'Y') THEN
4058: asn_debug.put_line('Error messages specific to asn');
4059: END IF;

Line 4188: AND (rcv_roi_header.g_txn_against_asn = 'N')) THEN --{ Bug#4523892

4184: * will be for the case of a receipt against a PO shipment.
4185: */
4186: IF ( (x_cascaded_table(n).transaction_type = 'RECEIVE')
4187: AND l_asn_exists_code IN('WARNING', 'REJECT')
4188: AND (rcv_roi_header.g_txn_against_asn = 'N')) THEN --{ Bug#4523892
4189: /* AND (x_is_asn = FALSE)) THEN --{ This is replaced by forward port for 4523892 */
4190: IF (g_asn_debug = 'Y') THEN
4191: asn_debug.put_line('ASN CODE IN Warning or Reject ');
4192: END IF;

Line 4353: IF (rcv_roi_header.g_txn_against_asn = 'N') THEN --{ Bug#4523892

4349: NULL;
4350:
4351: /*Bug# 1548597 */
4352: /* IF (x_is_asn = FALSE) THEN --{ Replaced by forward port 4523892 */
4353: IF (rcv_roi_header.g_txn_against_asn = 'N') THEN --{ Bug#4523892
4354: IF (g_asn_debug = 'Y') THEN
4355: asn_debug.put_line('Receiving against a Po');
4356: END IF;
4357:

Line 4408: IF (rcv_roi_header.g_txn_against_asn = 'N') THEN --{ Bug#4523892

4404: END IF;
4405: ELSE --} { for txn != deliver
4406: /* Bug# 1548597*/
4407: /* IF (x_is_asn = FALSE) THEN --{ Replaced by forward port 4523892 */
4408: IF (rcv_roi_header.g_txn_against_asn = 'N') THEN --{ Bug#4523892
4409: IF (g_asn_debug = 'Y') THEN
4410: asn_debug.put_line('Direct delivery against a Po');
4411: END IF;
4412:

Line 6877: asn_debug.put_line('g_txn_against_asn : '|| rcv_roi_header.g_txn_against_asn);

6873:
6874: /* Bug 5182693 : Skip validate item for ASN transactions with substitute item */
6875:
6876: asn_debug.put_line('substitute_item_id: '|| x_cascaded_table(n).substitute_item_id);
6877: asn_debug.put_line('g_txn_against_asn : '|| rcv_roi_header.g_txn_against_asn);
6878: /** Bug: 5598511
6879: * For ASN, substitution item id will be populated only during ASN creation and
6880: * not during the receipt of ASN. In order to bypass item validation for ASN added the
6881: * condition ' AND rcv_roi_header.g_txn_against_asn = 'N' '

Line 6881: * condition ' AND rcv_roi_header.g_txn_against_asn = 'N' '

6877: asn_debug.put_line('g_txn_against_asn : '|| rcv_roi_header.g_txn_against_asn);
6878: /** Bug: 5598511
6879: * For ASN, substitution item id will be populated only during ASN creation and
6880: * not during the receipt of ASN. In order to bypass item validation for ASN added the
6881: * condition ' AND rcv_roi_header.g_txn_against_asn = 'N' '
6882: */
6883: IF rcv_roi_header.g_txn_against_asn = 'Y' THEN
6884: l_pol_item_id := nvl(rcv_table_functions.get_pol_row_from_id(x_cascaded_table(n).po_line_id).item_id,-999);
6885: IF x_cascaded_table(n).item_id <> l_pol_item_id THEN

Line 6883: IF rcv_roi_header.g_txn_against_asn = 'Y' THEN

6879: * For ASN, substitution item id will be populated only during ASN creation and
6880: * not during the receipt of ASN. In order to bypass item validation for ASN added the
6881: * condition ' AND rcv_roi_header.g_txn_against_asn = 'N' '
6882: */
6883: IF rcv_roi_header.g_txn_against_asn = 'Y' THEN
6884: l_pol_item_id := nvl(rcv_table_functions.get_pol_row_from_id(x_cascaded_table(n).po_line_id).item_id,-999);
6885: IF x_cascaded_table(n).item_id <> l_pol_item_id THEN
6886: l_asn_sub_item_txn := 'Y';
6887: ELSE

Line 6893: IF (x_cascaded_table(n).substitute_item_id IS NULL AND rcv_roi_header.g_txn_against_asn = 'N')

6889: END IF;
6890: ELSE
6891: l_asn_sub_item_txn := 'N';
6892: END IF;
6893: IF (x_cascaded_table(n).substitute_item_id IS NULL AND rcv_roi_header.g_txn_against_asn = 'N')
6894: OR (l_asn_sub_item_txn = 'N' AND rcv_roi_header.g_txn_against_asn = 'Y') --Bug: 5598511
6895: OR rcv_roi_header.g_txn_against_asn = 'N' THEN --{
6896: rcv_roi_header_common.validate_item(x_cascaded_table, n); -- bug 608353
6897: END IF; --}

Line 6894: OR (l_asn_sub_item_txn = 'N' AND rcv_roi_header.g_txn_against_asn = 'Y') --Bug: 5598511

6890: ELSE
6891: l_asn_sub_item_txn := 'N';
6892: END IF;
6893: IF (x_cascaded_table(n).substitute_item_id IS NULL AND rcv_roi_header.g_txn_against_asn = 'N')
6894: OR (l_asn_sub_item_txn = 'N' AND rcv_roi_header.g_txn_against_asn = 'Y') --Bug: 5598511
6895: OR rcv_roi_header.g_txn_against_asn = 'N' THEN --{
6896: rcv_roi_header_common.validate_item(x_cascaded_table, n); -- bug 608353
6897: END IF; --}
6898: END IF; --}

Line 6895: OR rcv_roi_header.g_txn_against_asn = 'N' THEN --{

6891: l_asn_sub_item_txn := 'N';
6892: END IF;
6893: IF (x_cascaded_table(n).substitute_item_id IS NULL AND rcv_roi_header.g_txn_against_asn = 'N')
6894: OR (l_asn_sub_item_txn = 'N' AND rcv_roi_header.g_txn_against_asn = 'Y') --Bug: 5598511
6895: OR rcv_roi_header.g_txn_against_asn = 'N' THEN --{
6896: rcv_roi_header_common.validate_item(x_cascaded_table, n); -- bug 608353
6897: END IF; --}
6898: END IF; --}
6899:

Line 6896: rcv_roi_header_common.validate_item(x_cascaded_table, n); -- bug 608353

6892: END IF;
6893: IF (x_cascaded_table(n).substitute_item_id IS NULL AND rcv_roi_header.g_txn_against_asn = 'N')
6894: OR (l_asn_sub_item_txn = 'N' AND rcv_roi_header.g_txn_against_asn = 'Y') --Bug: 5598511
6895: OR rcv_roi_header.g_txn_against_asn = 'N' THEN --{
6896: rcv_roi_header_common.validate_item(x_cascaded_table, n); -- bug 608353
6897: END IF; --}
6898: END IF; --}
6899:
6900: asn_debug.put_line('after doing validate item the error status is ' || x_cascaded_table(n).error_status);

Line 6925: rcv_roi_header_common.validate_substitute_item(x_cascaded_table, n);

6921: IF (g_asn_debug = 'Y') THEN
6922: asn_debug.put_line('Validating Substitute Item');
6923: END IF;
6924:
6925: rcv_roi_header_common.validate_substitute_item(x_cascaded_table, n);
6926: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'SUBSTITUTE_ITEM_NUM');
6927: END IF;
6928:
6929: IF (x_cascaded_table(n).item_revision IS NOT NULL) THEN --{

Line 6930: rcv_roi_header_common.validate_item_revision(x_cascaded_table, n);

6926: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'SUBSTITUTE_ITEM_NUM');
6927: END IF;
6928:
6929: IF (x_cascaded_table(n).item_revision IS NOT NULL) THEN --{
6930: rcv_roi_header_common.validate_item_revision(x_cascaded_table, n);
6931: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'ITEM_REVISION');
6932: END IF;
6933: EXCEPTION
6934: WHEN rcv_error_pkg.e_fatal_error THEN

Line 11456: p_trx_record rcv_roi_header_common.common_default_record_type;

11452: PROCEDURE default_vendor_trans_del(
11453: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
11454: n IN BINARY_INTEGER
11455: ) IS
11456: p_trx_record rcv_roi_header_common.common_default_record_type;
11457:
11458: CURSOR po_transfer(
11459: v_parent_trx_id NUMBER
11460: ) IS

Line 11558: rcv_roi_header_common.commondefaultcode(p_trx_record);

11554: p_trx_record.processing_mode_code := x_cascaded_table(n).processing_mode_code;
11555: p_trx_record.processing_status_code := x_cascaded_table(n).processing_status_code;
11556: p_trx_record.transaction_status_code := x_cascaded_table(n).transaction_status_code;
11557: p_trx_record.auto_transact_code := x_cascaded_table(n).auto_transact_code;
11558: rcv_roi_header_common.commondefaultcode(p_trx_record);
11559: x_cascaded_table(n).destination_type_code := p_trx_record.destination_type_code;
11560: x_cascaded_table(n).transaction_type := p_trx_record.transaction_type;
11561: x_cascaded_table(n).processing_mode_code := p_trx_record.processing_mode_code;
11562: x_cascaded_table(n).processing_status_code := p_trx_record.processing_status_code;

Line 14145: p_trx_record rcv_roi_header_common.common_default_record_type;

14141: PROCEDURE default_vendor_correct(
14142: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
14143: n IN BINARY_INTEGER
14144: ) IS
14145: p_trx_record rcv_roi_header_common.common_default_record_type;
14146:
14147: CURSOR po_correct(
14148: v_parent_trx_id NUMBER
14149: ) IS

Line 14283: rcv_roi_header_common.commondefaultcode(p_trx_record);

14279: p_trx_record.processing_mode_code := x_cascaded_table(n).processing_mode_code;
14280: p_trx_record.processing_status_code := x_cascaded_table(n).processing_status_code;
14281: p_trx_record.transaction_status_code := x_cascaded_table(n).transaction_status_code;
14282: p_trx_record.auto_transact_code := x_cascaded_table(n).auto_transact_code;
14283: rcv_roi_header_common.commondefaultcode(p_trx_record);
14284: x_cascaded_table(n).destination_type_code := p_trx_record.destination_type_code;
14285: x_cascaded_table(n).transaction_type := p_trx_record.transaction_type;
14286: x_cascaded_table(n).processing_mode_code := p_trx_record.processing_mode_code;
14287: x_cascaded_table(n).processing_status_code := p_trx_record.processing_status_code;