[Home] [Help]
9: | PROCEDURE NAME: derive_rma_header() |
10: | |
11: +===========================================================================*/
12: PROCEDURE derive_rma_header(
13: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
14: ) IS
15: BEGIN
16: IF (g_asn_debug = 'Y') THEN
17: asn_debug.put_line('In derive_rma_header');
41: | PROCEDURE NAME: default_rma_header() |
42: | |
43: +===========================================================================*/
44: PROCEDURE default_rma_header(
45: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
46: ) IS
47: BEGIN
48: IF (g_asn_debug = 'Y') THEN
49: asn_debug.put_line('In default_rma_header');
76: | PROCEDURE NAME: validate_rma_header() |
77: | |
78: +===========================================================================*/
79: PROCEDURE validate_rma_header(
80: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
81: ) IS
82: BEGIN
83: IF (g_asn_debug = 'Y') THEN
84: asn_debug.put_line('In validate_rma_header');
108: END IF;
109: END validate_rma_header;
110:
111: PROCEDURE insert_rma_header(
112: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
113: ) IS
114: x_sysdate DATE := SYSDATE;
115: BEGIN
116: -- Set asn_type to null if asn_type is STD as the UI gets confused
294: END insert_rma_header;
295:
296: /* Private helper procedures */
297: PROCEDURE derive_customer_info(
298: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
299: ) IS
300: BEGIN
301: IF p_header_record.error_record.error_status IN('S', 'W')
302: AND p_header_record.header_record.customer_id IS NULL THEN
342:
343: /* We do not insert customer_site_id now from forms */
344: /* customer_site_id = from_org_id */
345: PROCEDURE derive_customer_site_info(
346: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
347: ) IS
348: BEGIN
349: NULL;
350: END derive_customer_site_info;
349: NULL;
350: END derive_customer_site_info;
351:
352: PROCEDURE default_customer_info(
353: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
354: ) IS
355: BEGIN
356: NULL;
357: -- For RMA, we can default customer_id which is actually the cust_account_id in hz_cust_accounts.
390: -- end if;
391: END default_customer_info;
392:
393: PROCEDURE default_customer_site_info(
394: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
395: ) IS
396: BEGIN
397: IF ( p_header_record.header_record.customer_site_id IS NULL
398: AND p_header_record.header_record.from_organization_id IS NOT NULL) THEN
404: END IF;
405: END default_customer_site_info;
406:
407: PROCEDURE default_trx_info(
408: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
409: ) IS
410: BEGIN
411: IF p_header_record.header_record.transaction_type IS NULL THEN
412: p_header_record.header_record.transaction_type := 'NEW';
417: END IF;
418: END default_trx_info;
419:
420: PROCEDURE default_shipment_num(
421: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
422: ) IS
423: BEGIN
424: /* SHIPMENT NUMBER FOR ASBN/ASN if shipment_num IS NULL */
425: /* First choice for ASN/ Second Choice for ASN */
432: END IF;
433: END default_shipment_num;
434:
435: PROCEDURE validate_receipt_source_code(
436: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
437: ) IS
438: BEGIN
439: -- validate that the receipt source code is CUSTOMER
440: -- and that the txn type and asn type makes sense
442: NULL;
443: END validate_receipt_source_code;
444:
445: PROCEDURE validate_customer_info(
446: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
447: ) IS
448: l_status hz_cust_accounts.status%TYPE;
449: l_validation_failed BOOLEAN; /*Bug 4344351*/
450: BEGIN
489: p_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
490: END validate_customer_info;
491:
492: PROCEDURE validate_customer_site_info(
493: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
494: ) IS
495: BEGIN
496: NULL;
497: END validate_customer_site_info;