APPS.JA_ZZ_VALIDATE_INVOICE_GDF dependencies on FND_PROFILE

Line 4: -- pg_debug VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');

1: PACKAGE BODY ja_zz_validate_invoice_gdf AS
2: /* $Header: jazzrivb.pls 120.4 2006/01/06 20:19:19 ykonishi ship $ */
3:
4: -- pg_debug VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
5:
6: -----------------------------------------------------------------------------
7: -- Taiwan Validation --
8: -----------------------------------------------------------------------------

Line 88: l_org_id := fnd_profile.value('ORG_ID');

84: BEGIN
85:
86: l_batch_source_id := TO_CHAR(p_batch_source_id);
87:
88: l_org_id := fnd_profile.value('ORG_ID');
89:
90: l_seq_name := 'RA_TRX_NUMBER_'
91: || l_batch_source_id
92: || '_'

Line 398: pg_debug := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');

394: l_invalid_value VARCHAR2(240);
395: pg_debug VARCHAR2(1);
396: BEGIN
397:
398: pg_debug := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
399:
400: /*
401: ** R12 Changes : 4460720
402: **

Line 473: pg_debug := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');

469: pg_debug VARCHAR2(1);
470:
471: BEGIN
472:
473: pg_debug := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
474:
475: l_trx_header_id := p_trx_header_id;
476: l_trx_line_id := p_trx_line_id;
477: l_batch_source_id := p_batch_source_id;

Line 560: pg_debug := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');

556: pg_debug VARCHAR2(1);
557:
558: BEGIN
559:
560: pg_debug := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
561:
562: l_trx_header_id := p_trx_header_id;
563: l_trx_line_id := p_trx_line_id;
564: l_batch_source_id := p_batch_source_id;

Line 693: pg_debug := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');

689: tl.customer_trx_id = x_customer_trx_id
690: AND tl.line_type = 'TAX'; -- Bug 2753541
691: BEGIN
692:
693: pg_debug := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
694:
695: l_trx_header_id := p_trx_header_id;
696: l_trx_line_id := p_trx_line_id;
697: l_customer_trx_id := p_customer_trx_id;

Line 811: pg_debug := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');

807: pg_debug VARCHAR2(1);
808:
809: BEGIN
810:
811: pg_debug := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
812: /*
813: ** R12 Changes : 4460720
814: **
815: ** Stub out logic as Source/Type relationship feature

Line 869: pg_debug := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');

865: pg_debug VARCHAR2(1);
866:
867: BEGIN
868:
869: pg_debug := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
870:
871: FOR l IN interface_line
872: LOOP
873: IF NOT jg_zz_invoice_create.put_error_message(

Line 922: pg_debug := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');

918: pg_debug VARCHAR2(1);
919:
920: BEGIN
921:
922: pg_debug := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
923:
924: IF p_last_issued_date is NULL THEN
925: return(1);
926: ELSIF p_trx_date BETWEEN p_last_issued_date AND

Line 980: pg_debug := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');

976: pg_debug VARCHAR2(1);
977:
978: BEGIN
979:
980: pg_debug := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
981:
982: IF p_created_from = 'ARXTWMAI' THEN
983: SELECT count(l.customer_trx_line_id)
984: INTO n

Line 1076: pg_debug := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');

1072: BEGIN
1073:
1074: BEGIN
1075:
1076: pg_debug := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
1077:
1078: OPEN last_issued_date;
1079:
1080: FETCH last_issued_date INTO dummy;