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.GME_GANTT_PKG dependencies on GME_DEBUG

Line 633: GME_DEBUG.LOG_INITIALIZE('ProdScheduler');

629: string_to_exec DBMS_SQL.VARCHAR2S;
630: dynamic_cur PLS_INTEGER := dbms_sql.open_cursor;
631: l_ret NUMBER;
632: BEGIN
633: GME_DEBUG.LOG_INITIALIZE('ProdScheduler');
634:
635: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
636: gme_debug.put_line('Inside init session ');
637: END IF;

Line 635: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

631: l_ret NUMBER;
632: BEGIN
633: GME_DEBUG.LOG_INITIALIZE('ProdScheduler');
634:
635: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
636: gme_debug.put_line('Inside init session ');
637: END IF;
638: close_cursors;
639:

Line 636: gme_debug.put_line('Inside init session ');

632: BEGIN
633: GME_DEBUG.LOG_INITIALIZE('ProdScheduler');
634:
635: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
636: gme_debug.put_line('Inside init session ');
637: END IF;
638: close_cursors;
639:
640: /*

Line 684: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

680: string_to_exec(6) := ' DECODE(GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_START_DATE), NULL, GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_START_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_START_DATE)) ACTUAL_START, ';
681: string_to_exec(7) := ' DECODE(GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE), NULL , GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_CMPLT_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE)) ACTUAL_END, ';
682: string_to_exec(8) := ' FORMULA_ID, ROUTING_ID, ENFORCE_STEP_DEPENDENCY, TERMINATED_IND, FINITE_SCHEDULED_IND, PARENTLINE_ID FROM (';
683:
684: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
685: gme_debug.put_line('Calling set_where_clause');
686: END IF;
687:
688: set_where_clause(p_batch_type => p_batch_type,

Line 685: gme_debug.put_line('Calling set_where_clause');

681: string_to_exec(7) := ' DECODE(GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE), NULL , GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_CMPLT_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE)) ACTUAL_END, ';
682: string_to_exec(8) := ' FORMULA_ID, ROUTING_ID, ENFORCE_STEP_DEPENDENCY, TERMINATED_IND, FINITE_SCHEDULED_IND, PARENTLINE_ID FROM (';
683:
684: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
685: gme_debug.put_line('Calling set_where_clause');
686: END IF;
687:
688: set_where_clause(p_batch_type => p_batch_type,
689: p_fpo_type => p_fpo_type,

Line 698: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

694: p_to_date => p_to_date,
695: p_to_batch_no => p_to_batch_no,
696: p_string_to_exec => string_to_exec);
697:
698: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
699: gme_debug.put_line('After executing set_where_clause');
700: END IF;
701:
702: string_to_exec(string_to_exec.LAST +1) := ' ) A WHERE ( (:p_resource = ''%'' AND :p_prim_rsrc_ind = 1 AND :p_aux_rsrc_ind = 2 ';

Line 699: gme_debug.put_line('After executing set_where_clause');

695: p_to_batch_no => p_to_batch_no,
696: p_string_to_exec => string_to_exec);
697:
698: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
699: gme_debug.put_line('After executing set_where_clause');
700: END IF;
701:
702: string_to_exec(string_to_exec.LAST +1) := ' ) A WHERE ( (:p_resource = ''%'' AND :p_prim_rsrc_ind = 1 AND :p_aux_rsrc_ind = 2 ';
703: string_to_exec(string_to_exec.LAST +1) := ' AND :p_sec_rsrc_ind = 0) OR (EXISTS (SELECT 1 FROM GME_BATCH_STEP_RESOURCES D2 ';

Line 707: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

703: string_to_exec(string_to_exec.LAST +1) := ' AND :p_sec_rsrc_ind = 0) OR (EXISTS (SELECT 1 FROM GME_BATCH_STEP_RESOURCES D2 ';
704: string_to_exec(string_to_exec.LAST +1) := ' WHERE D2.BATCH_ID = A.BATCH_ID AND D2.RESOURCES LIKE :p_resource AND (D2.PRIM_RSRC_IND = ';
705: string_to_exec(string_to_exec.LAST +1) := ' :p_prim_rsrc_ind OR D2.PRIM_RSRC_IND = :p_aux_rsrc_ind OR D2.PRIM_RSRC_IND = :p_sec_rsrc_ind )))))';
706:
707: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
708: gme_debug.put_line('Dynamic SQL query is ');
709: gme_debug.put_line('===============================================================');
710: for cntr in 1..string_to_exec.last loop
711: gme_debug.put_line(string_to_exec(cntr));

Line 708: gme_debug.put_line('Dynamic SQL query is ');

704: string_to_exec(string_to_exec.LAST +1) := ' WHERE D2.BATCH_ID = A.BATCH_ID AND D2.RESOURCES LIKE :p_resource AND (D2.PRIM_RSRC_IND = ';
705: string_to_exec(string_to_exec.LAST +1) := ' :p_prim_rsrc_ind OR D2.PRIM_RSRC_IND = :p_aux_rsrc_ind OR D2.PRIM_RSRC_IND = :p_sec_rsrc_ind )))))';
706:
707: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
708: gme_debug.put_line('Dynamic SQL query is ');
709: gme_debug.put_line('===============================================================');
710: for cntr in 1..string_to_exec.last loop
711: gme_debug.put_line(string_to_exec(cntr));
712: end loop;

Line 709: gme_debug.put_line('===============================================================');

705: string_to_exec(string_to_exec.LAST +1) := ' :p_prim_rsrc_ind OR D2.PRIM_RSRC_IND = :p_aux_rsrc_ind OR D2.PRIM_RSRC_IND = :p_sec_rsrc_ind )))))';
706:
707: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
708: gme_debug.put_line('Dynamic SQL query is ');
709: gme_debug.put_line('===============================================================');
710: for cntr in 1..string_to_exec.last loop
711: gme_debug.put_line(string_to_exec(cntr));
712: end loop;
713: gme_debug.put_line('===============================================================');

Line 711: gme_debug.put_line(string_to_exec(cntr));

707: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
708: gme_debug.put_line('Dynamic SQL query is ');
709: gme_debug.put_line('===============================================================');
710: for cntr in 1..string_to_exec.last loop
711: gme_debug.put_line(string_to_exec(cntr));
712: end loop;
713: gme_debug.put_line('===============================================================');
714: END IF;
715:

Line 713: gme_debug.put_line('===============================================================');

709: gme_debug.put_line('===============================================================');
710: for cntr in 1..string_to_exec.last loop
711: gme_debug.put_line(string_to_exec(cntr));
712: end loop;
713: gme_debug.put_line('===============================================================');
714: END IF;
715:
716: DBMS_SQL.PARSE(dynamic_cur, string_to_exec, string_to_exec.first, string_to_exec.last, TRUE, DBMS_SQL.NATIVE);
717:

Line 718: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

714: END IF;
715:
716: DBMS_SQL.PARSE(dynamic_cur, string_to_exec, string_to_exec.first, string_to_exec.last, TRUE, DBMS_SQL.NATIVE);
717:
718: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
719: gme_debug.put_line('After parsing dynamic SQL query');
720: END IF;
721:
722: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

Line 719: gme_debug.put_line('After parsing dynamic SQL query');

715:
716: DBMS_SQL.PARSE(dynamic_cur, string_to_exec, string_to_exec.first, string_to_exec.last, TRUE, DBMS_SQL.NATIVE);
717:
718: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
719: gme_debug.put_line('After parsing dynamic SQL query');
720: END IF;
721:
722: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
723: gme_debug.put_line('Bind variable values');

Line 722: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

718: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
719: gme_debug.put_line('After parsing dynamic SQL query');
720: END IF;
721:
722: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
723: gme_debug.put_line('Bind variable values');
724: gme_debug.put_line('-------------------------------------------');
725: gme_debug.put_line('p_organization_id = '|| p_organization_id);
726: gme_debug.put_line('p_batch_no = '|| p_batch_no);

Line 723: gme_debug.put_line('Bind variable values');

719: gme_debug.put_line('After parsing dynamic SQL query');
720: END IF;
721:
722: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
723: gme_debug.put_line('Bind variable values');
724: gme_debug.put_line('-------------------------------------------');
725: gme_debug.put_line('p_organization_id = '|| p_organization_id);
726: gme_debug.put_line('p_batch_no = '|| p_batch_no);
727: gme_debug.put_line('p_to_batch_no = '|| p_to_batch_no);

Line 724: gme_debug.put_line('-------------------------------------------');

720: END IF;
721:
722: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
723: gme_debug.put_line('Bind variable values');
724: gme_debug.put_line('-------------------------------------------');
725: gme_debug.put_line('p_organization_id = '|| p_organization_id);
726: gme_debug.put_line('p_batch_no = '|| p_batch_no);
727: gme_debug.put_line('p_to_batch_no = '|| p_to_batch_no);
728: gme_debug.put_line('p_from_date = '|| to_char(p_from_date, 'DD-MON-YYYY HH24:MI:SS'));

Line 725: gme_debug.put_line('p_organization_id = '|| p_organization_id);

721:
722: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
723: gme_debug.put_line('Bind variable values');
724: gme_debug.put_line('-------------------------------------------');
725: gme_debug.put_line('p_organization_id = '|| p_organization_id);
726: gme_debug.put_line('p_batch_no = '|| p_batch_no);
727: gme_debug.put_line('p_to_batch_no = '|| p_to_batch_no);
728: gme_debug.put_line('p_from_date = '|| to_char(p_from_date, 'DD-MON-YYYY HH24:MI:SS'));
729: gme_debug.put_line('p_resource = '|| p_resource);

Line 726: gme_debug.put_line('p_batch_no = '|| p_batch_no);

722: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
723: gme_debug.put_line('Bind variable values');
724: gme_debug.put_line('-------------------------------------------');
725: gme_debug.put_line('p_organization_id = '|| p_organization_id);
726: gme_debug.put_line('p_batch_no = '|| p_batch_no);
727: gme_debug.put_line('p_to_batch_no = '|| p_to_batch_no);
728: gme_debug.put_line('p_from_date = '|| to_char(p_from_date, 'DD-MON-YYYY HH24:MI:SS'));
729: gme_debug.put_line('p_resource = '|| p_resource);
730: gme_debug.put_line('p_prim_rsrc_ind = '|| p_prim_rsrc_ind);

Line 727: gme_debug.put_line('p_to_batch_no = '|| p_to_batch_no);

723: gme_debug.put_line('Bind variable values');
724: gme_debug.put_line('-------------------------------------------');
725: gme_debug.put_line('p_organization_id = '|| p_organization_id);
726: gme_debug.put_line('p_batch_no = '|| p_batch_no);
727: gme_debug.put_line('p_to_batch_no = '|| p_to_batch_no);
728: gme_debug.put_line('p_from_date = '|| to_char(p_from_date, 'DD-MON-YYYY HH24:MI:SS'));
729: gme_debug.put_line('p_resource = '|| p_resource);
730: gme_debug.put_line('p_prim_rsrc_ind = '|| p_prim_rsrc_ind);
731: gme_debug.put_line('p_aux_rsrc_ind = '|| p_aux_rsrc_ind);

Line 728: gme_debug.put_line('p_from_date = '|| to_char(p_from_date, 'DD-MON-YYYY HH24:MI:SS'));

724: gme_debug.put_line('-------------------------------------------');
725: gme_debug.put_line('p_organization_id = '|| p_organization_id);
726: gme_debug.put_line('p_batch_no = '|| p_batch_no);
727: gme_debug.put_line('p_to_batch_no = '|| p_to_batch_no);
728: gme_debug.put_line('p_from_date = '|| to_char(p_from_date, 'DD-MON-YYYY HH24:MI:SS'));
729: gme_debug.put_line('p_resource = '|| p_resource);
730: gme_debug.put_line('p_prim_rsrc_ind = '|| p_prim_rsrc_ind);
731: gme_debug.put_line('p_aux_rsrc_ind = '|| p_aux_rsrc_ind);
732: gme_debug.put_line('p_sec_rsrc_ind = '|| p_sec_rsrc_ind);

Line 729: gme_debug.put_line('p_resource = '|| p_resource);

725: gme_debug.put_line('p_organization_id = '|| p_organization_id);
726: gme_debug.put_line('p_batch_no = '|| p_batch_no);
727: gme_debug.put_line('p_to_batch_no = '|| p_to_batch_no);
728: gme_debug.put_line('p_from_date = '|| to_char(p_from_date, 'DD-MON-YYYY HH24:MI:SS'));
729: gme_debug.put_line('p_resource = '|| p_resource);
730: gme_debug.put_line('p_prim_rsrc_ind = '|| p_prim_rsrc_ind);
731: gme_debug.put_line('p_aux_rsrc_ind = '|| p_aux_rsrc_ind);
732: gme_debug.put_line('p_sec_rsrc_ind = '|| p_sec_rsrc_ind);
733: END IF;

Line 730: gme_debug.put_line('p_prim_rsrc_ind = '|| p_prim_rsrc_ind);

726: gme_debug.put_line('p_batch_no = '|| p_batch_no);
727: gme_debug.put_line('p_to_batch_no = '|| p_to_batch_no);
728: gme_debug.put_line('p_from_date = '|| to_char(p_from_date, 'DD-MON-YYYY HH24:MI:SS'));
729: gme_debug.put_line('p_resource = '|| p_resource);
730: gme_debug.put_line('p_prim_rsrc_ind = '|| p_prim_rsrc_ind);
731: gme_debug.put_line('p_aux_rsrc_ind = '|| p_aux_rsrc_ind);
732: gme_debug.put_line('p_sec_rsrc_ind = '|| p_sec_rsrc_ind);
733: END IF;
734:

Line 731: gme_debug.put_line('p_aux_rsrc_ind = '|| p_aux_rsrc_ind);

727: gme_debug.put_line('p_to_batch_no = '|| p_to_batch_no);
728: gme_debug.put_line('p_from_date = '|| to_char(p_from_date, 'DD-MON-YYYY HH24:MI:SS'));
729: gme_debug.put_line('p_resource = '|| p_resource);
730: gme_debug.put_line('p_prim_rsrc_ind = '|| p_prim_rsrc_ind);
731: gme_debug.put_line('p_aux_rsrc_ind = '|| p_aux_rsrc_ind);
732: gme_debug.put_line('p_sec_rsrc_ind = '|| p_sec_rsrc_ind);
733: END IF;
734:
735: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_organization_id' , p_organization_id);

Line 732: gme_debug.put_line('p_sec_rsrc_ind = '|| p_sec_rsrc_ind);

728: gme_debug.put_line('p_from_date = '|| to_char(p_from_date, 'DD-MON-YYYY HH24:MI:SS'));
729: gme_debug.put_line('p_resource = '|| p_resource);
730: gme_debug.put_line('p_prim_rsrc_ind = '|| p_prim_rsrc_ind);
731: gme_debug.put_line('p_aux_rsrc_ind = '|| p_aux_rsrc_ind);
732: gme_debug.put_line('p_sec_rsrc_ind = '|| p_sec_rsrc_ind);
733: END IF;
734:
735: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_organization_id' , p_organization_id);
736: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_batch_no' , p_batch_no);

Line 747: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

743: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_aux_rsrc_ind' , p_aux_rsrc_ind);
744: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_sec_rsrc_ind' , p_sec_rsrc_ind);
745:
746: IF p_to_date IS NOT NULL THEN
747: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
748: gme_debug.put_line('p_to_date = '|| to_char(p_to_date, 'DD-MON-YYYY HH24:MI:SS'));
749: END IF;
750:
751: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_to_date', p_to_date);

Line 748: gme_debug.put_line('p_to_date = '|| to_char(p_to_date, 'DD-MON-YYYY HH24:MI:SS'));

744: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_sec_rsrc_ind' , p_sec_rsrc_ind);
745:
746: IF p_to_date IS NOT NULL THEN
747: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
748: gme_debug.put_line('p_to_date = '|| to_char(p_to_date, 'DD-MON-YYYY HH24:MI:SS'));
749: END IF;
750:
751: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_to_date', p_to_date);
752: END IF;

Line 754: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

750:
751: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_to_date', p_to_date);
752: END IF;
753:
754: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
755: gme_debug.put_line('-------------------------------------------');
756: gme_debug.put_line('After binding variables');
757: END IF;
758:

Line 755: gme_debug.put_line('-------------------------------------------');

751: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_to_date', p_to_date);
752: END IF;
753:
754: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
755: gme_debug.put_line('-------------------------------------------');
756: gme_debug.put_line('After binding variables');
757: END IF;
758:
759: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

Line 756: gme_debug.put_line('After binding variables');

752: END IF;
753:
754: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
755: gme_debug.put_line('-------------------------------------------');
756: gme_debug.put_line('After binding variables');
757: END IF;
758:
759: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
760: gme_debug.put_line('Executing the dynamic SQL');

Line 759: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

755: gme_debug.put_line('-------------------------------------------');
756: gme_debug.put_line('After binding variables');
757: END IF;
758:
759: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
760: gme_debug.put_line('Executing the dynamic SQL');
761: END IF;
762:
763: l_ret := dbms_sql.execute(dynamic_cur);

Line 760: gme_debug.put_line('Executing the dynamic SQL');

756: gme_debug.put_line('After binding variables');
757: END IF;
758:
759: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
760: gme_debug.put_line('Executing the dynamic SQL');
761: END IF;
762:
763: l_ret := dbms_sql.execute(dynamic_cur);
764:

Line 765: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

761: END IF;
762:
763: l_ret := dbms_sql.execute(dynamic_cur);
764:
765: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
766: gme_debug.put_line('After executing dynamic SQL rows returned := '||l_ret);
767: END IF;
768:
769: IF p_to_date IS NULL THEN

Line 766: gme_debug.put_line('After executing dynamic SQL rows returned := '||l_ret);

762:
763: l_ret := dbms_sql.execute(dynamic_cur);
764:
765: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
766: gme_debug.put_line('After executing dynamic SQL rows returned := '||l_ret);
767: END IF;
768:
769: IF p_to_date IS NULL THEN
770: OPEN Get_Batches_From_Date;

Line 781: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

777: g_organization_id := p_organization_id;
778: g_org_code := p_org_code;
779: EXCEPTION
780: WHEN OTHERS THEN
781: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
782: gme_debug.put_line ('Exception occurs = ' || SQLERRM);
783: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
784: END IF;
785: END init_session;

Line 782: gme_debug.put_line ('Exception occurs = ' || SQLERRM);

778: g_org_code := p_org_code;
779: EXCEPTION
780: WHEN OTHERS THEN
781: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
782: gme_debug.put_line ('Exception occurs = ' || SQLERRM);
783: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
784: END IF;
785: END init_session;
786:

Line 1227: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

1223: END IF;
1224: END IF;
1225: EXCEPTION
1226: WHEN NO_DATA_FOUND THEN
1227: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1228: gme_debug.put_line ('no data found ');
1229: END IF;
1230: --Bug2804440
1231: WHEN OTHERS THEN

Line 1228: gme_debug.put_line ('no data found ');

1224: END IF;
1225: EXCEPTION
1226: WHEN NO_DATA_FOUND THEN
1227: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1228: gme_debug.put_line ('no data found ');
1229: END IF;
1230: --Bug2804440
1231: WHEN OTHERS THEN
1232: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);