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.ECE_AR_TRANSACTION dependencies on ECE_AR_TRANSACTION

Line 1: PACKAGE BODY ece_ar_transaction AS

1: PACKAGE BODY ece_ar_transaction AS
2: -- $Header: ECEINOB.pls 120.7.12000000.2 2007/03/20 18:14:02 cpeixoto ship $
3:
4: l_Organization_ID NUMBER;
5: l_Automotive_Installed BOOLEAN;

Line 67: ec_debug.push('ECE_AR_TRANSACTION.EXTRACT_INO_OUTBOUND');

63: ORDER BY line_id;
64:
65: BEGIN
66: ec_debug.enable_debug(cdebug_mode);
67: ec_debug.push('ECE_AR_TRANSACTION.EXTRACT_INO_OUTBOUND');
68: ec_debug.pl(3,'cOutputPath: ' ,cOutputPath);
69: ec_debug.pl(3,'cOutput_Filename: ' ,cOutput_Filename);
70: ec_debug.pl(3,'cCDate_From: ' ,cCDate_From);
71: ec_debug.pl(3,'cCDate_To: ' ,cCDate_To);

Line 128: ece_ar_transaction.populate_ar_trx(

124: END;
125: ec_debug.pl(3,'dTransaction_date: ',dTransaction_date);
126:
127: xProgress := 'INO-10-1040';
128: ece_ar_transaction.populate_ar_trx(
129: cCommunication_Method,
130: cTransaction_Type,
131: iOutput_width,
132: dTransaction_date,

Line 169: ece_ar_transaction.put_data_to_output_table(

165: xProgress := 'INO-10-1045';
166: ec_debug.pl(0,'EC','ECE_TRANSACTIONS_PROCESSED','NUMBER_OF_TRX',xHeaderCount);
167:
168: xProgress := 'INO-10-1050';
169: ece_ar_transaction.put_data_to_output_table(
170: cCommunication_Method,
171: cTransaction_Type,
172: iOutput_width,
173: iRun_id,

Line 265: ec_debug.pop('ECE_AR_TRANSACTION.EXTRACT_INO_OUTBOUND');

261: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
262: retcode := 1;
263: END IF;
264:
265: ec_debug.pop('ECE_AR_TRANSACTION.EXTRACT_INO_OUTBOUND');
266: ec_debug.disable_debug;
267:
268: COMMIT;
269:

Line 321: ec_debug.push ( 'ECE_AR_TRANSACTION.DEFINE_INTERFACE_COLUMN' );

317: i INTEGER := 0;
318:
319: BEGIN
320:
321: ec_debug.push ( 'ECE_AR_TRANSACTION.DEFINE_INTERFACE_COLUMN' );
322: ec_debug.pl ( 3, 'c: ', c );
323: ec_debug.pl ( 3, 'col: ',col );
324: ec_debug.pl ( 3, 'col_size: ',col_size );
325:

Line 335: ec_debug.pop('ECE_AR_TRANSACTION.DEFINE_INTERFACE_COLUMN');

331: col,
332: col_size );
333: END LOOP;
334:
335: ec_debug.pop('ECE_AR_TRANSACTION.DEFINE_INTERFACE_COLUMN');
336:
337: EXCEPTION
338: WHEN OTHERS THEN
339:

Line 371: ec_debug.push('ECE_AR_TRANSACTION.UPDATE_AR');

367: l_Print_Flag VARCHAR2(1);
368:
369: BEGIN
370:
371: ec_debug.push('ECE_AR_TRANSACTION.UPDATE_AR');
372: ec_debug.pl ( 3, 'Document_Type: ', Document_Type );
373: ec_debug.pl ( 3, 'Transaction_ID: ', Transaction_ID );
374: ec_debug.pl ( 3, 'Installment_Number: ', Installment_Number );
375: ec_debug.pl ( 3, 'Multiple_Installments_Flag: ',Multiple_Installments_Flag );

Line 481: ec_debug.pop('ECE_AR_TRANSACTION.UPDATE_AR');

477: RAISE_APPLICATION_ERROR(-20000,'Record changed by another user.');
478: END IF;
479: */
480:
481: ec_debug.pop('ECE_AR_TRANSACTION.UPDATE_AR');
482: EXCEPTION
483: WHEN OTHERS THEN
484:
485: ec_debug.pl ( 0,

Line 521: ec_debug.push('ECE_AR_TRANSACTION.GET_REMIT_ADDRESS');

517: dummy NUMBER;
518:
519: BEGIN
520:
521: ec_debug.push('ECE_AR_TRANSACTION.GET_REMIT_ADDRESS');
522: ec_debug.pl ( 3, 'customer_trx_id: ', Customer_Trx_ID );
523:
524: xProgress := '2000-30';
525: BEGIN

Line 683: ec_debug.pop('ECE_AR_TRANSACTION.GET_REMIT_ADDRESS');

679: 'TABLE_NAME',
680: 'HZ_CUST_ACCT_SITES' );
681: END;
682:
683: ec_debug.pop('ECE_AR_TRANSACTION.GET_REMIT_ADDRESS');
684:
685: EXCEPTION
686: WHEN OTHERS THEN
687:

Line 734: ec_debug.push ( 'ece_ar_transaction.Get_Payment' );

730: -- of an Invoice or Credit Memo (or any of the related documents)
731:
732: BEGIN
733:
734: ec_debug.push ( 'ece_ar_transaction.Get_Payment' );
735: ec_debug.pl ( 3, 'Customer_Trx_ID: ', Customer_Trx_ID );
736:
737: -- This select statement is used to determine whether this transaction
738: -- has a payment_schedule. If it does we can get all of the information

Line 1086: ec_debug.pop ( 'ece_ar_transaction.Get_Payment' );

1082:
1083: END IF;
1084:
1085:
1086: ec_debug.pop ( 'ece_ar_transaction.Get_Payment' );
1087:
1088: EXCEPTION
1089: WHEN OTHERS THEN
1090:

Line 1159: ec_debug.push ( 'ece_ar_transaction.Get_Term_Discount' );

1155:
1156:
1157: BEGIN
1158:
1159: ec_debug.push ( 'ece_ar_transaction.Get_Term_Discount' );
1160: ec_debug.pl ( 3, 'Document_Type: ', Document_Type );
1161: ec_debug.pl ( 3, 'Term_ID: ',Term_ID );
1162: ec_debug.pl ( 3, 'Term_Sequence_Number: ',Term_Sequence_Number );
1163:

Line 1270: ec_debug.pop ( 'ece_ar_transaction.Get_Term_Discount' );

1266: END IF;
1267:
1268: END IF;
1269:
1270: ec_debug.pop ( 'ece_ar_transaction.Get_Term_Discount' );
1271:
1272: EXCEPTION
1273: WHEN OTHERS THEN
1274:

Line 1297: ec_debug.push('ECE_AR_TRANSACTION.GET_CURRENCY_CODE');

1293: function get_currency_code
1294: return varchar2
1295: IS
1296: Begin
1297: ec_debug.push('ECE_AR_TRANSACTION.GET_CURRENCY_CODE');
1298: If base_currency_code is null Then
1299: select GLB.CURRENCY_CODE Base_Currency_Code
1300: into base_currency_code
1301: from AR_SYSTEM_PARAMETERS ASP, GL_SETS_OF_BOOKS GLB

Line 1304: ec_debug.pop('ECE_AR_TRANSACTION.GET_CURRENCY_CODE');

1300: into base_currency_code
1301: from AR_SYSTEM_PARAMETERS ASP, GL_SETS_OF_BOOKS GLB
1302: where ASP.SET_OF_BOOKS_ID = GLB.SET_OF_BOOKS_ID ;
1303: End If;
1304: ec_debug.pop('ECE_AR_TRANSACTION.GET_CURRENCY_CODE');
1305: return base_currency_code;
1306: EXCEPTION
1307: WHEN EC_UTILS.PROGRAM_EXIT then
1308: raise;

Line 1311: 'ECE_AR_TRANSACTION.GET_CURRENCY_CODE');

1307: WHEN EC_UTILS.PROGRAM_EXIT then
1308: raise;
1309: WHEN OTHERS THEN
1310: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
1311: 'ECE_AR_TRANSACTION.GET_CURRENCY_CODE');
1312: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1313: ec_debug.pop('ECE_AR_TRANSACTION.GET_CURRENCY_CODE');
1314: return base_currency_code;
1315: End;

Line 1313: ec_debug.pop('ECE_AR_TRANSACTION.GET_CURRENCY_CODE');

1309: WHEN OTHERS THEN
1310: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
1311: 'ECE_AR_TRANSACTION.GET_CURRENCY_CODE');
1312: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1313: ec_debug.pop('ECE_AR_TRANSACTION.GET_CURRENCY_CODE');
1314: return base_currency_code;
1315: End;
1316:
1317: -- PROCEDURE Put_Data_To_Output_Table

Line 1458: ec_debug.push ( 'ece_ar_transaction.Put_Data_To_Output_Table' );

1454: v_LevelProcessed VARCHAR2(40);
1455:
1456: BEGIN
1457:
1458: ec_debug.push ( 'ece_ar_transaction.Put_Data_To_Output_Table' );
1459: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
1460: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
1461: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );
1462: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );

Line 3075: ec_debug.pop('ece_ar_transaction.Put_Data_To_Output_Table');

3071:
3072: xProgress := '2921-60';
3073: dbms_sql.close_cursor ( Alw_chg_l_del_c1 );
3074:
3075: ec_debug.pop('ece_ar_transaction.Put_Data_To_Output_Table');
3076:
3077: EXCEPTION
3078: WHEN OTHERS THEN
3079:

Line 3372: ec_debug.push ( 'ece_ar_transaction.Populate_AR_Trx' );

3368: AND ROWNUM = 1;
3369:
3370: BEGIN
3371:
3372: ec_debug.push ( 'ece_ar_transaction.Populate_AR_Trx' );
3373: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
3374: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
3375: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );
3376: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );

Line 4176: ece_ar_transaction.Get_Payment ( l_header_tbl(nPos1).value,

4172: -- The following procedures get the payment and remit address
4173: -- information for this transaction
4174:
4175: xProgress := '2480-70';
4176: ece_ar_transaction.Get_Payment ( l_header_tbl(nPos1).value,
4177: l_header_tbl(nPos2).value,
4178: l_Multiple_Installments_Flag,
4179: l_Maximum_Installment_Number,
4180: l_Amount_Tax_Due,

Line 4187: ece_ar_transaction.Get_Remit_Address ( l_header_tbl(nPos1).value,

4183: l_Amount_Line_Items_Due,
4184: l_total_amount_due );
4185:
4186: xProgress := '2490-70';
4187: ece_ar_transaction.Get_Remit_Address ( l_header_tbl(nPos1).value,
4188: l_remit_to_address1,
4189: l_remit_to_address2,
4190: l_remit_to_address3,
4191: l_remit_to_address4,

Line 4246: ece_ar_transaction.Get_Term_Discount ( l_header_tbl(nPos3).value,

4242:
4243:
4244: xProgress := '2510-70';
4245: -- Bug 2389231
4246: ece_ar_transaction.Get_Term_Discount ( l_header_tbl(nPos3).value,
4247: l_header_tbl(nPos4).value,
4248: l_header_tbl(nPos2).value,
4249: to_date(l_header_tbl(nPos28).value,'YYYYMMDD HH24MISS'),
4250: l_Discount_Percent1,

Line 4336: ece_ar_transaction.Update_AR ( l_header_tbl(nPos3).value,

4332: -- to update the AR base tables.
4333:
4334: xProgress := '2550-70';
4335:
4336: ece_ar_transaction.Update_AR ( l_header_tbl(nPos3).value,
4337: l_header_tbl(nPos1).value,
4338: l_header_tbl(nPos2).value,
4339: l_Multiple_Installments_Flag,
4340: l_Maximum_Installment_Number,

Line 5525: ec_debug.pop ( 'ece_ar_transaction.Populate_AR_Trx' );

5521:
5522: xProgress := '3068-70';
5523: dbms_sql.close_cursor ( Line_t_sel_c );
5524:
5525: ec_debug.pop ( 'ece_ar_transaction.Populate_AR_Trx' );
5526:
5527: EXCEPTION
5528: WHEN OTHERS THEN
5529:

Line 5584: END ece_ar_transaction;

5580: SQLERRM );
5581:
5582: app_exception.raise_exception;
5583:
5584: END ece_ar_transaction;