DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_CMN_UTILS_PKG

Line 189: If the function jai_cmn_utils_pkg.check_jai_exists returns true it means INR is the set of books currency ,

185:
186: 3. 29-nov-2004 ssumaith - bug# 4037690 - File version 115.1
187: Check whether india localization is being used was done using a INR check in every trigger.
188: This check has now been moved into a new package and calls made to this package from this trigger
189: If the function jai_cmn_utils_pkg.check_jai_exists returns true it means INR is the set of books currency ,
190: Hence if this function returns FALSE , control should return
191:
192: 4. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
193: DB Entity as required for CASE COMPLAINCE. Version 116.1

Line 235: --If jai_cmn_utils_pkg.check_jai_exists(P_CALLING_OBJECT => 'JA_IN_AR_LINES_DELETE_TRG', P_ORG_ID => pr_old.ORG_ID) = false then

231: pv_return_code := jai_constants.successful ;
232: v_customer_trx_line_id := pr_old.CUSTOMER_TRX_LINE_ID; --Ramananda for File.Sql.35
233: v_customer_trx_id := pr_old.CUSTOMER_TRX_ID; --Ramananda for File.Sql.35
234:
235: --If jai_cmn_utils_pkg.check_jai_exists(P_CALLING_OBJECT => 'JA_IN_AR_LINES_DELETE_TRG', P_ORG_ID => pr_old.ORG_ID) = false then
236: -- return;
237: --end if;
238:
239:

Line 498: v_converted_rate := jai_cmn_utils_pkg.currency_conversion (v_books_id ,c_from_currency_code ,

494: Removed the reference to cursor set_of_books_cur.
495: */
496: END IF;
497:
498: v_converted_rate := jai_cmn_utils_pkg.currency_conversion (v_books_id ,c_from_currency_code ,
499: c_conversion_date ,c_conversion_type, c_conversion_rate);
500:
501: IF v_line_type = 'LINE' THEN
502: Open Gl_Date_Cur;

Line 2768: If the function jai_cmn_utils_pkg.check_jai_exists returns true it means INR is the set of books currency ,

2764:
2765: 24. 29-nov-2004 ssumaith - bug# 4037690 - File version 115.4
2766: Check whether india localization is being used was done using a INR check in every trigger.
2767: This check has now been moved into a new package and calls made to this package from this trigger
2768: If the function jai_cmn_utils_pkg.check_jai_exists returns true it means INR is the set of books currency ,
2769: Hence if this function returns FALSE , control should return.
2770:
2771: 25. 06-JAn-2005 ssumaith - bug#4136981 File version 115.5
2772:

Line 2977: --If jai_cmn_utils_pkg.check_jai_exists(P_CALLING_OBJECT => 'JA_IN_OE_AR_LINES_INSERT_TRG', P_ORG_ID => pr_new.org_id) = false then

2973: v_gl_set_of_bks_id := pr_new.set_of_books_id;
2974:
2975: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id '|| v_gl_set_of_bks_id);
2976:
2977: --If jai_cmn_utils_pkg.check_jai_exists(P_CALLING_OBJECT => 'JA_IN_OE_AR_LINES_INSERT_TRG', P_ORG_ID => pr_new.org_id) = false then
2978: -- return;
2979: --end if;
2980:
2981: /*The following code has been commented and added the above code instead - ssumaith - bug# 4037690*/

Line 5390: Function jai_cmn_utils_pkg.check_jai_exists is being called which returns the TRUE if the currency is INR and FALSE if the currency is

5386: The trigger should not get fired when the non-INR based set of books is attached to the current operating unit
5387: where transaction is being done.
5388:
5389: Fix:-
5390: Function jai_cmn_utils_pkg.check_jai_exists is being called which returns the TRUE if the currency is INR and FALSE if the currency is
5391: NON-INR
5392: Also removed the cursors Fetch_Book_Id_Cur and Sob_cur and the variables v_gl_set_of_bks_id and v_currency_code and v_operating_id
5393:
5394: Dependency Due to this Bug:-

Line 5395: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0. introduced through the bug 4033992

5391: NON-INR
5392: Also removed the cursors Fetch_Book_Id_Cur and Sob_cur and the variables v_gl_set_of_bks_id and v_currency_code and v_operating_id
5393:
5394: Dependency Due to this Bug:-
5395: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0. introduced through the bug 4033992
5396:
5397: 10. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
5398: DB Entity as required for CASE COMPLAINCE. Version 116.1
5399:

Line 5451: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.

5447: -----------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
5448:
5449: /*
5450: || Code added by aiyer for the bug 4035566
5451: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.
5452: */
5453: --IF jai_cmn_utils_pkg.check_jai_exists ( p_calling_object => 'JA_IN_RMA_AR_LINES_INSERT_TRG' ,
5454: -- p_set_of_books_id => pr_new.set_of_books_id
5455: -- ) = FALSE

Line 5453: --IF jai_cmn_utils_pkg.check_jai_exists ( p_calling_object => 'JA_IN_RMA_AR_LINES_INSERT_TRG' ,

5449: /*
5450: || Code added by aiyer for the bug 4035566
5451: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.
5452: */
5453: --IF jai_cmn_utils_pkg.check_jai_exists ( p_calling_object => 'JA_IN_RMA_AR_LINES_INSERT_TRG' ,
5454: -- p_set_of_books_id => pr_new.set_of_books_id
5455: -- ) = FALSE
5456: -- THEN
5457: /*

Line 6453: If the function jai_cmn_utils_pkg.check_jai_exists returns true it means INR is the set of books currency ,

6449:
6450: 4. 29-nov-2004 ssumaith - bug# 4037690 - File version 115.2
6451: Check whether india localization is being used was done using a INR check in every trigger.
6452: This check has now been moved into a new package and calls made to this package from this trigger
6453: If the function jai_cmn_utils_pkg.check_jai_exists returns true it means INR is the set of books currency ,
6454: Hence if this function returns FALSE , control should return
6455:
6456: 5. 16/Mar/05 ssumaith - bug# 4245053 file version 115.3
6457:

Line 6539: --If jai_cmn_utils_pkg.check_jai_exists(P_CALLING_OBJECT => 'JA_IN_AR_LINES_INSERT_TRG', P_ORG_ID => pr_new.ORG_ID) = false then

6535: ------------------
6536: /* --Ramananda for File.Sql.35, end */
6537:
6538: /*The following code has added - ssumaith - bug# 4037690*/
6539: --If jai_cmn_utils_pkg.check_jai_exists(P_CALLING_OBJECT => 'JA_IN_AR_LINES_INSERT_TRG', P_ORG_ID => pr_new.ORG_ID) = false then
6540: -- return;
6541: --end if;
6542:
6543: OPEN transaction_type_cur;

Line 6585: jai_cmn_utils_pkg.JA_IN_SET_LOCATOR('JAINARTX',v_row_id);*//*commented by rchandan for bug#4479131*/

6581: /*ELSE
6582: OPEN ROW_ID_CUR;
6583: FETCH ROW_ID_CUR INTO v_row_id;
6584: CLOSE ROW_ID_CUR;
6585: jai_cmn_utils_pkg.JA_IN_SET_LOCATOR('JAINARTX',v_row_id);*//*commented by rchandan for bug#4479131*/
6586: END IF;
6587: IF NVL(v_organization_id,999999) = 999999 THEN -- -- made 0 to 999999 because in case of setup business group setup , inventory organization value is 0
6588: RETURN;
6589: END IF;

Line 6770: v_converted_rate := jai_cmn_utils_pkg.currency_conversion(

6766: IF c_conversion_date is NULL THEN
6767: c_conversion_date := v_trx_date;
6768: END IF;
6769:
6770: v_converted_rate := jai_cmn_utils_pkg.currency_conversion(
6771: v_books_id ,
6772: c_from_currency_code ,
6773: c_conversion_date ,
6774: c_conversion_type,

Line 7186: jai_cmn_utils_pkg.JA_IN_SET_LOCATOR(

7182: /* ELSE
7183: OPEN ROW_ID_CUR;
7184: FETCH ROW_ID_CUR INTO v_row_id;
7185: CLOSE ROW_ID_CUR;
7186: jai_cmn_utils_pkg.JA_IN_SET_LOCATOR(
7187: 'JAINARTX',
7188: v_row_id
7189: );*//*commented by rchandan for bug#4479131*/
7190: END IF;

Line 7226: v_converted_rate := jai_cmn_utils_pkg.currency_conversion (

7222: IF c_conversion_date is NULL THEN
7223: c_conversion_date := v_trx_date;
7224: END IF;
7225:
7226: v_converted_rate := jai_cmn_utils_pkg.currency_conversion (
7227: v_books_id ,
7228: c_from_currency_code ,
7229: c_conversion_date ,
7230: c_conversion_type ,

Line 7477: If the function jai_cmn_utils_pkg.check_jai_exists returns true it means INR is the set of books currency ,

7473:
7474: 4. 29-nov-2004 ssumaith - bug# 4037690 - File version 115.2
7475: Check whether india localization is being used was done using a INR check in every trigger.
7476: This check has now been moved into a new package and calls made to this package from this trigger
7477: If the function jai_cmn_utils_pkg.check_jai_exists returns true it means INR is the set of books currency ,
7478: Hence if this function returns FALSE , control should return.
7479:
7480: 5. 17/03/2005 ssumaith - bug# 4245053 - File Version 115.3
7481:

Line 7566: --If jai_cmn_utils_pkg.check_jai_exists(P_CALLING_OBJECT => 'JA_IN_AR_LINES_UPDATE_TRG', P_ORG_ID => pr_new.org_id) = false then

7562: /* --Ramananda for File.Sql.35 */
7563:
7564: /*The following code has added - ssumaith - bug# 4037690*/
7565:
7566: --If jai_cmn_utils_pkg.check_jai_exists(P_CALLING_OBJECT => 'JA_IN_AR_LINES_UPDATE_TRG', P_ORG_ID => pr_new.org_id) = false then
7567: -- return;
7568: --end if;
7569:
7570: OPEN transaction_type_cur;

Line 7616: jai_cmn_utils_pkg.JA_IN_SET_LOCATOR('JAINARTX',v_row_id);*//*commented by rchandan for bug#4479131*/

7612: /*ELSE
7613: OPEN ROW_ID_CUR;
7614: FETCH ROW_ID_CUR INTO v_row_id;
7615: CLOSE ROW_ID_CUR;
7616: jai_cmn_utils_pkg.JA_IN_SET_LOCATOR('JAINARTX',v_row_id);*//*commented by rchandan for bug#4479131*/
7617: END IF;
7618: IF NVL(v_organization_id,999999) = 999999 THEN
7619: RETURN;
7620: END IF;