DBA Data[Home] [Help]

APPS.JAI_CMN_ST_FORMS_PKG dependencies on JAI_CMN_ST_FORMS_PKG

Line 1: PACKAGE BODY jai_cmn_st_forms_pkg AS

1: PACKAGE BODY jai_cmn_st_forms_pkg AS
2: /* $Header: jai_cmn_st_forms.plb 120.15.12020000.5 2013/03/27 04:46:16 mmurtuza ship $ */
3:
4: /* --------------------------------------------------------------------------------------
5: Filename: jai_cmn_st_forms.plb

Line 490: FILENAME: jai_cmn_st_forms_pkg.generate_ap_forms_p.sql

486:
487: begin -- main
488:
489: /*------------------------------------------------------------------------------------------
490: FILENAME: jai_cmn_st_forms_pkg.generate_ap_forms_p.sql
491: CHANGE HISTORY:
492:
493: S.No Date Author and Details
494: 1 17-oct-03 Aparajita for bug#3193849. Version#616.1

Line 546: jai_cmn_st_forms_pkg.generate_ap_forms

542:
543: ----------------------------------------------------------------------------------------------------------------------------------------------------
544: Current Version Current Bug Dependent Files Version Author Date Remarks
545: Of File On Bug/Patchset Dependent On
546: jai_cmn_st_forms_pkg.generate_ap_forms
547: ----------------------------------------------------------------------------------------------------------------------------------------------------
548:
549: 617.1 3249375 IN60105D1 Aiyer 11/Nov/2003 Can be applied only after IN60105D1 patchset
550: has been applied.

Line 558: Fnd_File.put_line(Fnd_File.LOG, '**** Start procedure - jai_cmn_st_forms_pkg.generate_ap_forms ****');

554: v_debug := jai_constants.yes ; --Ramananda for File.Sql.35
555:
556: if v_debug = 'Y' then
557: Fnd_File.put_line(Fnd_File.LOG, '**** ========================================== ****');
558: Fnd_File.put_line(Fnd_File.LOG, '**** Start procedure - jai_cmn_st_forms_pkg.generate_ap_forms ****');
559: end if;
560:
561: v_uid := fnd_global.USER_ID;
562:

Line 1128: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_st_forms_pkg.generate_forms';

1124: name1 VARCHAR2(25);
1125: -- trc gen
1126:
1127: /* Added by Ramananda for bug#4407165 */
1128: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_st_forms_pkg.generate_forms';
1129: ld_from_date DATE ;
1130: ld_to_date DATE ;
1131:
1132: /* --------------------------------------------------------------------------------------------------------------------

Line 1145: which does the processing for ISO orders also. Call to the procedure - jai_cmn_st_forms_pkg.generate_iso_forms

1141:
1142: 2. 19/03/2004 ssumaith - bug# 3360432. Version#619.1
1143:
1144: when st forms receipt processing concurrent program is called, calling the procedure
1145: which does the processing for ISO orders also. Call to the procedure - jai_cmn_st_forms_pkg.generate_iso_forms
1146: is made as part of this fix when the party_type parameter is 'C' in addition to the call made
1147: for ST forms receipt - jai_cmn_st_forms_pkg.generate_ar_forms.
1148:
1149: 3. 05-Jul-2006 Aiyer for the bug 5369250, Version 120.3

Line 1147: for ST forms receipt - jai_cmn_st_forms_pkg.generate_ar_forms.

1143:
1144: when st forms receipt processing concurrent program is called, calling the procedure
1145: which does the processing for ISO orders also. Call to the procedure - jai_cmn_st_forms_pkg.generate_iso_forms
1146: is made as part of this fix when the party_type parameter is 'C' in addition to the call made
1147: for ST forms receipt - jai_cmn_st_forms_pkg.generate_ar_forms.
1148:
1149: 3. 05-Jul-2006 Aiyer for the bug 5369250, Version 120.3
1150: Issue:-
1151: The concurrent failes with the following error :-

Line 1188: fnd_file.put_line(FND_FILE.LOG,'Entering Procedure - jai_cmn_st_forms_pkg.generate_forms');

1184: ld_to_date := fnd_date.canonical_to_date(p_to_date) ;
1185:
1186: audsid := userenv('SESSIONID'); --Ramananda for File.Sql.35
1187:
1188: fnd_file.put_line(FND_FILE.LOG,'Entering Procedure - jai_cmn_st_forms_pkg.generate_forms');
1189: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id : '|| p_org_id ||' Process All orgs ' || p_all_orgs || ' p_party_type :' || p_party_type );
1190: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id : ' || p_party_id || ' p_party_site_id : ' || p_party_site_id);
1191: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date :' || p_from_date ||' p_to_date ' || p_to_date || ' Trace ' || P_Enable_Trace);
1192:

Line 1232: jai_cmn_st_forms_pkg.generate_ar_forms(

1228: */
1229:
1230: if p_party_type = 'C' or p_party_type = 'c' then
1231:
1232: jai_cmn_st_forms_pkg.generate_ar_forms(
1233: errbuf ,
1234: ret_code ,
1235: v_sp_org_id ,
1236: 'C' ,

Line 1243: jai_cmn_st_forms_pkg.generate_iso_forms( -- Bug#3360432

1239: ld_from_date ,
1240: ld_to_date
1241: );
1242:
1243: jai_cmn_st_forms_pkg.generate_iso_forms( -- Bug#3360432
1244: errbuf ,
1245: ret_code ,
1246: v_sp_org_id ,
1247: p_party_type ,

Line 1255: jai_cmn_st_forms_pkg.generate_ap_forms(

1251: ld_to_date
1252: );
1253:
1254: elsif p_party_type = 'V' or p_party_type = 'V' then
1255: jai_cmn_st_forms_pkg.generate_ap_forms(
1256: errbuf ,
1257: ret_code ,
1258: v_sp_org_id ,
1259: p_party_id ,

Line 1501: Change history for jai_cmn_st_forms_pkg.generate_iso_forms procedure

1497:
1498: BEGIN
1499:
1500: /*-----------------------------------------------------------------------------------------------------------------
1501: Change history for jai_cmn_st_forms_pkg.generate_iso_forms procedure
1502:
1503: SlNo dd/mm/yyyy Author and Description of Changes
1504: -------------------------------------------------------------------------------------------------------------------
1505: 1. 13/10/2003 ssumaith bug # 3360432 , FileVersion: 619.1

Line 1508: This procedure will be called from the wrapper program - jai_cmn_st_forms_pkg.generate_forms

1504: -------------------------------------------------------------------------------------------------------------------
1505: 1. 13/10/2003 ssumaith bug # 3360432 , FileVersion: 619.1
1506: this procedure does the actual population of ST form related data into the revised tables
1507: when processed for ISO orders post shipment.
1508: This procedure will be called from the wrapper program - jai_cmn_st_forms_pkg.generate_forms
1509: when party_type parameter = 'C'
1510:
1511: Doc_Type field in the JAI_CMN_ST_FORM_DTLS is set to 'ISO'
1512:

Line 1525: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_iso_forms' );

1521:
1522: v_some_errors := '0'; -- used to identify if all was successful --Ramananda for File.Sql.35
1523: v_order_flag := 'O'; --Ramananda for File.Sql.35
1524:
1525: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_iso_forms' );
1526: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );
1527: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);
1528: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);
1529:

Line 1992: Change history for jai_cmn_st_forms_pkg.generate_ar_forms procedure

1988:
1989: BEGIN
1990:
1991: /*-----------------------------------------------------------------------------------------------------------------
1992: Change history for jai_cmn_st_forms_pkg.generate_ar_forms procedure
1993:
1994: SlNo dd/mm/yyyy Author and Description of Changes
1995: -------------------------------------------------------------------------------------------------------------------
1996: 1. 13/10/2003 ssumaith bug # 3138194, FileVersion: 616.1

Line 2014: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_ar_forms' );

2010:
2011: v_some_errors := '0'; -- used to identify if all was successful --Ramananda for File.Sql.35
2012: v_order_flag := 'O'; --Ramananda for File.Sql.35
2013:
2014: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_ar_forms' );
2015: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );
2016: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);
2017: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);
2018:

Line 2244: END jai_cmn_st_forms_pkg ;

2240: ret_code := v_ret_code;
2241: end generate_ar_forms;
2242:
2243:
2244: END jai_cmn_st_forms_pkg ;