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.

[Home] [Help]

APPS.GML_RECV_TRANS_PKG dependencies on GML_RECV_ADJUST_ERRORS

Line 513: | GML_RECV_ADJUST_ERRORS table to indicate that an |

509: /*========================================================================+
510: | PROCEDURE gml_insert_adjust_error |
511: | |
512: | DESCRIPTION The procedure inserts a row into the |
513: | GML_RECV_ADJUST_ERRORS table to indicate that an |
514: | adjustment/return was made in OPM to a receipt that does |
515: | not have a corresponding transaction in Oracle Receiving |
516: | |
517: | MODIFICATION HISTORY |

Line 521: | the added columns in gml_recv_adjust_errors table. |

517: | MODIFICATION HISTORY |
518: | 18-MAY-99 Tony Ricci Created. |
519: | 12-OCT-00 NC Pay on receipt enhancements.Bug#1518114 Added new |
520: | parameters and columns in insert statement to reflect |
521: | the added columns in gml_recv_adjust_errors table. |
522: | 20-AUG-01 P. Arvind Dath BUG#1938430 |
523: | Modified code to retrieve the max sequence number for a |
524: | given recv_id and line_id combination, to avoid primary |
525: | key voilation errors on the 'gml_recv_adjust_errors' table|

Line 525: | key voilation errors on the 'gml_recv_adjust_errors' table|

521: | the added columns in gml_recv_adjust_errors table. |
522: | 20-AUG-01 P. Arvind Dath BUG#1938430 |
523: | Modified code to retrieve the max sequence number for a |
524: | given recv_id and line_id combination, to avoid primary |
525: | key voilation errors on the 'gml_recv_adjust_errors' table|
526: +========================================================================*/
527:
528: PROCEDURE gml_insert_adjust_error(p_recv_id IN NUMBER, p_line_id IN NUMBER,
529: p_recv_qty1 IN NUMBER,

Line 537: X_seq_no gml_recv_adjust_errors.seq_no%TYPE DEFAULT 0;

533: p_recv_status IN NUMBER,
534: p_rtrn_void_ind IN NUMBER) AS
535:
536: X_progress VARCHAR2(4);
537: X_seq_no gml_recv_adjust_errors.seq_no%TYPE DEFAULT 0;
538:
539: v_created_by gml_recv_adjust_errors.created_by%TYPE;
540: v_last_updated_by gml_recv_adjust_errors.last_updated_by%TYPE;
541:

Line 539: v_created_by gml_recv_adjust_errors.created_by%TYPE;

535:
536: X_progress VARCHAR2(4);
537: X_seq_no gml_recv_adjust_errors.seq_no%TYPE DEFAULT 0;
538:
539: v_created_by gml_recv_adjust_errors.created_by%TYPE;
540: v_last_updated_by gml_recv_adjust_errors.last_updated_by%TYPE;
541:
542: -- BEGIN BUG#1938430 P. Arvind Dath
543:

Line 540: v_last_updated_by gml_recv_adjust_errors.last_updated_by%TYPE;

536: X_progress VARCHAR2(4);
537: X_seq_no gml_recv_adjust_errors.seq_no%TYPE DEFAULT 0;
538:
539: v_created_by gml_recv_adjust_errors.created_by%TYPE;
540: v_last_updated_by gml_recv_adjust_errors.last_updated_by%TYPE;
541:
542: -- BEGIN BUG#1938430 P. Arvind Dath
543:
544: CURSOR get_seq_no_cur(vc_recv_id NUMBER, vc_line_id NUMBER) IS

Line 546: FROM gml_recv_adjust_errors

542: -- BEGIN BUG#1938430 P. Arvind Dath
543:
544: CURSOR get_seq_no_cur(vc_recv_id NUMBER, vc_line_id NUMBER) IS
545: SELECT nvl(max(seq_no),0)
546: FROM gml_recv_adjust_errors
547: WHERE recv_id = vc_recv_id AND
548: line_id = vc_line_id;
549:
550: -- END BUG#1938430

Line 574: INSERT INTO gml_recv_adjust_errors

570: v_last_updated_by := FND_PROFILE.VALUE ('USER_ID');
571:
572: X_seq_no := X_seq_no + 1;
573:
574: INSERT INTO gml_recv_adjust_errors
575: (recv_id, line_id, seq_no,recv_qty1, old_recv_qty1, recv_um1,
576: return_ind,recv_status,void_return_ind,
577: creation_date,created_by,last_update_date,last_updated_by,
578: last_update_login,processed_ind)

Line 597: | GML_RECV_ADJUST_ERRORS table to indicate that an |

593: /*========================================================================+
594: | PROCEDURE gml_process_adjust_errors |
595: | |
596: | DESCRIPTION The procedure attempts to process rows in the |
597: | GML_RECV_ADJUST_ERRORS table to indicate that an |
598: | adjustment/return was made in OPM to a receipt that does |
599: | not have a corresponding transaction in Oracle Receiving |
600: | |
601: | MODIFICATION HISTORY |

Line 605: | to reflect the new columns added to gml_recv_adjust_errors

601: | MODIFICATION HISTORY |
602: | 27-MAY-99 Tony Ricci Created. |
603: | 12-OCT-00 NC Pay on receipt enhancements Bug#1518114. Added new |
604: | variables and modified the cursors and procedure call |
605: | to reflect the new columns added to gml_recv_adjust_errors
606: | |
607: | 19-OCT-01 Uday Phadtare Bug# 2065300 If get_trans_id_cur fails by any chance
608: | no more records after that are getting processed because adjust_err_ind
609: | is not getting reset. setting back adjust_err_ind to zero.

Line 615: X_seq_no gml_recv_adjust_errors.seq_no%TYPE DEFAULT 0;

611:
612: PROCEDURE gml_process_adjust_errors(retcode OUT NOCOPY NUMBER) AS
613:
614: X_progress VARCHAR2(4);
615: X_seq_no gml_recv_adjust_errors.seq_no%TYPE DEFAULT 0;
616:
617: adjust_err_ind NUMBER;
618:
619: X_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;

Line 637: from GML_RECV_ADJUST_ERRORS

633: recv_um1,
634: return_ind,
635: recv_status,
636: void_return_ind
637: from GML_RECV_ADJUST_ERRORS
638: where processed_ind = 'N'
639: /*PB 22-JUN-2000 order by added*/
640: order by seq_no;
641:

Line 701: update gml_recv_adjust_errors

697: error_rec.void_return_ind);
698:
699: G_adjust_mode := 'NORMAL';
700:
701: update gml_recv_adjust_errors
702: set processed_ind = 'Y',
703: last_update_date = SYSDATE
704: where recv_id = error_rec.recv_id
705: and line_id = error_rec.line_id