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.6.12010000.4 2008/11/19 10:00:33 nprashar ship $ */
3:
4: /* --------------------------------------------------------------------------------------
5: Filename: jai_cmn_st_forms.plb

Line 385: FILENAME: jai_cmn_st_forms_pkg.generate_ap_forms_p.sql

381:
382: begin -- main
383:
384: /*------------------------------------------------------------------------------------------
385: FILENAME: jai_cmn_st_forms_pkg.generate_ap_forms_p.sql
386: CHANGE HISTORY:
387:
388: S.No Date Author and Details
389: 1 17-oct-03 Aparajita for bug#3193849. Version#616.1

Line 436: jai_cmn_st_forms_pkg.generate_ap_forms

432:
433: ----------------------------------------------------------------------------------------------------------------------------------------------------
434: Current Version Current Bug Dependent Files Version Author Date Remarks
435: Of File On Bug/Patchset Dependent On
436: jai_cmn_st_forms_pkg.generate_ap_forms
437: ----------------------------------------------------------------------------------------------------------------------------------------------------
438:
439: 617.1 3249375 IN60105D1 Aiyer 11/Nov/2003 Can be applied only after IN60105D1 patchset
440: has been applied.

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

444: v_debug := jai_constants.yes ; --Ramananda for File.Sql.35
445:
446: if v_debug = 'Y' then
447: Fnd_File.put_line(Fnd_File.LOG, '**** ========================================== ****');
448: Fnd_File.put_line(Fnd_File.LOG, '**** Start procedure - jai_cmn_st_forms_pkg.generate_ap_forms ****');
449: end if;
450:
451: v_uid := fnd_global.USER_ID;
452:

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

984: name1 VARCHAR2(25);
985: -- trc gen
986:
987: /* Added by Ramananda for bug#4407165 */
988: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_st_forms_pkg.generate_forms';
989: ld_from_date DATE ;
990: ld_to_date DATE ;
991:
992: /* --------------------------------------------------------------------------------------------------------------------

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

1001:
1002: 2. 19/03/2004 ssumaith - bug# 3360432. Version#619.1
1003:
1004: when st forms receipt processing concurrent program is called, calling the procedure
1005: which does the processing for ISO orders also. Call to the procedure - jai_cmn_st_forms_pkg.generate_iso_forms
1006: is made as part of this fix when the party_type parameter is 'C' in addition to the call made
1007: for ST forms receipt - jai_cmn_st_forms_pkg.generate_ar_forms.
1008:
1009: 3. 05-Jul-2006 Aiyer for the bug 5369250, Version 120.3

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

1003:
1004: when st forms receipt processing concurrent program is called, calling the procedure
1005: which does the processing for ISO orders also. Call to the procedure - jai_cmn_st_forms_pkg.generate_iso_forms
1006: is made as part of this fix when the party_type parameter is 'C' in addition to the call made
1007: for ST forms receipt - jai_cmn_st_forms_pkg.generate_ar_forms.
1008:
1009: 3. 05-Jul-2006 Aiyer for the bug 5369250, Version 120.3
1010: Issue:-
1011: The concurrent failes with the following error :-

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

1044: ld_to_date := fnd_date.canonical_to_date(p_to_date) ;
1045:
1046: audsid := userenv('SESSIONID'); --Ramananda for File.Sql.35
1047:
1048: fnd_file.put_line(FND_FILE.LOG,'Entering Procedure - jai_cmn_st_forms_pkg.generate_forms');
1049: 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 );
1050: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id : ' || p_party_id || ' p_party_site_id : ' || p_party_site_id);
1051: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date :' || p_from_date ||' p_to_date ' || p_to_date || ' Trace ' || P_Enable_Trace);
1052:

Line 1092: jai_cmn_st_forms_pkg.generate_ar_forms(

1088: */
1089:
1090: if p_party_type = 'C' or p_party_type = 'c' then
1091:
1092: jai_cmn_st_forms_pkg.generate_ar_forms(
1093: errbuf ,
1094: ret_code ,
1095: v_sp_org_id ,
1096: 'C' ,

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

1099: ld_from_date ,
1100: ld_to_date
1101: );
1102:
1103: jai_cmn_st_forms_pkg.generate_iso_forms( -- Bug#3360432
1104: errbuf ,
1105: ret_code ,
1106: v_sp_org_id ,
1107: p_party_type ,

Line 1115: jai_cmn_st_forms_pkg.generate_ap_forms(

1111: ld_to_date
1112: );
1113:
1114: elsif p_party_type = 'V' or p_party_type = 'V' then
1115: jai_cmn_st_forms_pkg.generate_ap_forms(
1116: errbuf ,
1117: ret_code ,
1118: v_sp_org_id ,
1119: p_party_id ,

Line 1360: Change history for jai_cmn_st_forms_pkg.generate_iso_forms procedure

1356:
1357: BEGIN
1358:
1359: /*-----------------------------------------------------------------------------------------------------------------
1360: Change history for jai_cmn_st_forms_pkg.generate_iso_forms procedure
1361:
1362: SlNo dd/mm/yyyy Author and Description of Changes
1363: -------------------------------------------------------------------------------------------------------------------
1364: 1. 13/10/2003 ssumaith bug # 3360432 , FileVersion: 619.1

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

1363: -------------------------------------------------------------------------------------------------------------------
1364: 1. 13/10/2003 ssumaith bug # 3360432 , FileVersion: 619.1
1365: this procedure does the actual population of ST form related data into the revised tables
1366: when processed for ISO orders post shipment.
1367: This procedure will be called from the wrapper program - jai_cmn_st_forms_pkg.generate_forms
1368: when party_type parameter = 'C'
1369:
1370: Doc_Type field in the JAI_CMN_ST_FORM_DTLS is set to 'ISO'
1371:

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

1376:
1377: v_some_errors := '0'; -- used to identify if all was successful --Ramananda for File.Sql.35
1378: v_order_flag := 'O'; --Ramananda for File.Sql.35
1379:
1380: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_iso_forms' );
1381: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );
1382: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);
1383: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);
1384:

Line 1845: Change history for jai_cmn_st_forms_pkg.generate_ar_forms procedure

1841:
1842: BEGIN
1843:
1844: /*-----------------------------------------------------------------------------------------------------------------
1845: Change history for jai_cmn_st_forms_pkg.generate_ar_forms procedure
1846:
1847: SlNo dd/mm/yyyy Author and Description of Changes
1848: -------------------------------------------------------------------------------------------------------------------
1849: 1. 13/10/2003 ssumaith bug # 3138194, FileVersion: 616.1

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

1863:
1864: v_some_errors := '0'; -- used to identify if all was successful --Ramananda for File.Sql.35
1865: v_order_flag := 'O'; --Ramananda for File.Sql.35
1866:
1867: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_ar_forms' );
1868: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );
1869: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);
1870: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);
1871:

Line 2097: END jai_cmn_st_forms_pkg ;

2093: ret_code := v_ret_code;
2094: end generate_ar_forms;
2095:
2096:
2097: END jai_cmn_st_forms_pkg ;