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_SPSO_TRANS1 dependencies on ECE_SPSO_TRANS1

Line 1: PACKAGE BODY ece_spso_trans1 AS

1: PACKAGE BODY ece_spso_trans1 AS
2: -- $Header: ECSPSOB.pls 120.2.12000000.3 2007/03/09 14:40:32 cpeixoto ship $
3:
4: /*===========================================================================
5:

Line 47: ec_debug.push ( 'ECE_SPSO_Trans1.Extract_SPSO_Outbound' );

43:
44: BEGIN
45:
46: ec_debug.enable_debug(v_debug_mode);
47: ec_debug.push ( 'ECE_SPSO_Trans1.Extract_SPSO_Outbound' );
48: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
49: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
50: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
51: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );

Line 87: ece_spso_trans1.populate_supplier_sched_api1 ( p_communication_method,

83: xProgress := 'SPSO-10-1020';
84: ec_debug.pl ( 0, 'EC', 'ECE_RUN_ID', 'RUN_ID', p_run_id );
85:
86: xProgress := 'SPSO-10-1030';
87: ece_spso_trans1.populate_supplier_sched_api1 ( p_communication_method,
88: p_transaction_type,
89: p_transaction_date,
90: p_run_id,
91: p_document_type,

Line 107: ece_spso_trans1.populate_supplier_sched_api3 ( p_communication_method,

103: p_schedule_id,
104: p_batch_id);
105:
106: xProgress := 'SPSO-10-1050';
107: ece_spso_trans1.populate_supplier_sched_api3 ( p_communication_method,
108: p_transaction_type,
109: p_document_type,
110: p_run_id,
111: p_schedule_id,

Line 115: ece_spso_trans1.put_data_to_output_table ( p_communication_method,

111: p_schedule_id,
112: p_batch_id);
113:
114: xProgress := 'SPSO-10-1060';
115: ece_spso_trans1.put_data_to_output_table ( p_communication_method,
116: p_transaction_type,
117: p_output_width,
118: p_run_id,
119: p_header_interface,

Line 186: ec_debug.pop ( 'ECE_SPSO_Trans1.Extract_SPSO_Outbound' );

182: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
183: retcode := 1;
184: END IF;
185:
186: ec_debug.pop ( 'ECE_SPSO_Trans1.Extract_SPSO_Outbound' );
187: ec_debug.disable_debug;
188: COMMIT;
189:
190: EXCEPTION

Line 316: ec_debug.push ( 'ECE_SPSO_Trans1.Extract_SSSO_Outbound' );

312:
313: BEGIN
314:
315: ec_debug.enable_debug(v_debug_mode);
316: ec_debug.push ( 'ECE_SPSO_Trans1.Extract_SSSO_Outbound' );
317: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
318: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
319: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
320: ec_debug.pl ( 3, 'v_debug_mode: ',v_debug_mode );

Line 357: ece_spso_trans1.populate_supplier_sched_api1 ( p_communication_method,

353: xProgress := 'SSSO-10-1020';
354: ec_debug.pl ( 0, 'EC', 'ECE_RUN_ID', 'RUN_ID', p_run_id );
355:
356: xProgress := 'SSSO-10-1030';
357: ece_spso_trans1.populate_supplier_sched_api1 ( p_communication_method,
358: p_transaction_type,
359: p_transaction_date,
360: p_run_id,
361: p_document_type,

Line 377: ece_spso_trans1.populate_supplier_sched_api3 ( p_communication_method,

373: p_schedule_id,
374: p_batch_id );
375:
376: xProgress := 'SSSO-10-1050';
377: ece_spso_trans1.populate_supplier_sched_api3 ( p_communication_method,
378: p_transaction_type,
379: p_document_type,
380: p_run_id,
381: p_schedule_id,

Line 385: ece_spso_trans1.put_data_to_output_table ( p_communication_method,

381: p_schedule_id,
382: p_batch_id );
383:
384: xProgress := 'SSSO-10-1060';
385: ece_spso_trans1.put_data_to_output_table ( p_communication_method,
386: p_transaction_type,
387: p_output_width,
388: p_run_id,
389: p_header_interface,

Line 457: ec_debug.pop ( 'ECE_SPSO_Trans1.Extract_SSSO_Outbound' );

453: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
454: retcode := 1;
455: END IF;
456:
457: ec_debug.pop ( 'ECE_SPSO_Trans1.Extract_SSSO_Outbound' );
458: ec_debug.disable_debug;
459: COMMIT;
460:
461: EXCEPTION

Line 730: ec_debug.push ( 'ece_spso_trans1.Populate_Supplier_Sched_API1' );

726: d_dummy_date DATE;
727: g_item_id NUMBER;
728: BEGIN
729:
730: ec_debug.push ( 'ece_spso_trans1.Populate_Supplier_Sched_API1' );
731: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
732: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
733: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );
734: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );

Line 1698: ec_debug.pop ( 'ECE_SPSO_TRANS1.populate_supplier_sched_api1' );

1694:
1695: xProgress := 'SPSOB-10-1600';
1696: dbms_sql.close_cursor ( Item_sel_c );
1697:
1698: ec_debug.pop ( 'ECE_SPSO_TRANS1.populate_supplier_sched_api1' );
1699:
1700: EXCEPTION
1701: WHEN fail_convert_to_ext THEN
1702:

Line 1818: ec_debug.push ( 'ECE_SPSO_TRANS1.populate_supplier_sched_api3' );

1814: FOR UPDATE;
1815:
1816: BEGIN -- begin header block
1817:
1818: ec_debug.push ( 'ECE_SPSO_TRANS1.populate_supplier_sched_api3' );
1819: ec_debug.pl ( 3, 'p_communication_method: ', p_communication_method );
1820: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
1821: ec_debug.pl ( 3, 'p_document_type: ',p_document_type );
1822: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );

Line 2032: ece_spso_trans1.update_chv_schedule_headers ( rec_hdr.transaction_type,

2028: ** insert prior authorization detail **
2029: ***************************************/
2030:
2031: xProgress := 'SPSOB-30-1050';
2032: ece_spso_trans1.update_chv_schedule_headers ( rec_hdr.transaction_type,
2033: rec_hdr.schedule_id,
2034: rec_hdr.batch_id, --Bug 2064311
2035: rec_hdr.edi_count );
2036: Select count(*)

Line 2395: ec_debug.pop ( 'ece_spso_trans1.Populate_Supplier_Sched_API3' );

2391: END; -- item block
2392:
2393: END LOOP header; -- header for loop
2394:
2395: ec_debug.pop ( 'ece_spso_trans1.Populate_Supplier_Sched_API3' );
2396:
2397: EXCEPTION
2398: WHEN OTHERS THEN
2399:

Line 2438: ec_debug.push ( 'ECE_SPSO_TRANS1.UPDATE_CHV_SCHEDULE_HEADERS' );

2434: cOutput_path varchar2(120);
2435:
2436: BEGIN
2437:
2438: ec_debug.push ( 'ECE_SPSO_TRANS1.UPDATE_CHV_SCHEDULE_HEADERS' );
2439: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
2440: ec_debug.pl ( 3, 'p_schedule_id: ',p_schedule_id );
2441: ec_debug.pl ( 3, 'p_edi_count: ',p_edi_count );
2442:

Line 2476: ec_debug.pop ( 'ECE_SPSO_TRANS1.UPDATE_CHV_SCHEDULE_HEADERS' );

2472: AND p_transaction_type = DECODE ( schedule_type,
2473: 'SHIP_SCHEDULE', 'SSSO',
2474: 'SPSO' )
2475: AND batch_id = decode(p_batch_id,0,batch_id,p_batch_id); -- Bug 2064311
2476: ec_debug.pop ( 'ECE_SPSO_TRANS1.UPDATE_CHV_SCHEDULE_HEADERS' );
2477:
2478: EXCEPTION
2479: WHEN OTHERS THEN
2480: ec_debug.pl ( 0,

Line 2620: ec_debug.push ( 'ECE_SPSO_TRANS1.PUT_DATA_TO_OUTPUT_TABLE' );

2616: c_header_select VARCHAR2(100);
2617:
2618: BEGIN
2619:
2620: ec_debug.push ( 'ECE_SPSO_TRANS1.PUT_DATA_TO_OUTPUT_TABLE' );
2621: ec_debug.pl ( 3, 'p_communication_method: ', p_communication_method );
2622: ec_debug.pl ( 3, 'p_transaction_type: ',p_transaction_type );
2623: ec_debug.pl ( 3, 'p_output_width: ',p_output_width );
2624: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );

Line 3751: ec_debug.pop ( 'ece_spso_trans1.Put_Data_To_Output_Table' );

3747: if (p_transaction_type = 'SSSO') then
3748: dbms_sql.close_cursor ( v_ship_d_del_c1 );
3749: end if;
3750:
3751: ec_debug.pop ( 'ece_spso_trans1.Put_Data_To_Output_Table' );
3752:
3753: EXCEPTION
3754: WHEN OTHERS THEN
3755:

Line 3772: END ECE_SPSO_TRANS1;

3768: app_exception.raise_exception;
3769:
3770: END Put_Data_To_Output_Table; -- end of procedure
3771:
3772: END ECE_SPSO_TRANS1;
3773: