DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_CMN_UTILS_PKG

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

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

Line 209: --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

205: pv_return_code := jai_constants.successful ;
206: v_customer_trx_line_id := pr_old.CUSTOMER_TRX_LINE_ID; --Ramananda for File.Sql.35
207: v_customer_trx_id := pr_old.CUSTOMER_TRX_ID; --Ramananda for File.Sql.35
208:
209: --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
210: -- return;
211: --end if;
212:
213:

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

468: Removed the reference to cursor set_of_books_cur.
469: */
470: END IF;
471:
472: v_converted_rate := jai_cmn_utils_pkg.currency_conversion (v_books_id ,c_from_currency_code ,
473: c_conversion_date ,c_conversion_type, c_conversion_rate);
474:
475: IF v_line_type = 'LINE' THEN
476: Open Gl_Date_Cur;

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

2554:
2555: 24. 29-nov-2004 ssumaith - bug# 4037690 - File version 115.4
2556: Check whether india localization is being used was done using a INR check in every trigger.
2557: This check has now been moved into a new package and calls made to this package from this trigger
2558: If the function jai_cmn_utils_pkg.check_jai_exists returns true it means INR is the set of books currency ,
2559: Hence if this function returns FALSE , control should return.
2560:
2561: 25. 06-JAn-2005 ssumaith - bug#4136981 File version 115.5
2562:

Line 2718: --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

2714: v_gl_set_of_bks_id := pr_new.set_of_books_id;
2715:
2716: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id '|| v_gl_set_of_bks_id);
2717:
2718: --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
2719: -- return;
2720: --end if;
2721:
2722: /*The following code has been commented and added the above code instead - ssumaith - bug# 4037690*/

Line 4436: 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

4432: The trigger should not get fired when the non-INR based set of books is attached to the current operating unit
4433: where transaction is being done.
4434:
4435: Fix:-
4436: 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
4437: NON-INR
4438: 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
4439:
4440: Dependency Due to this Bug:-

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

4437: NON-INR
4438: 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
4439:
4440: Dependency Due to this Bug:-
4441: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0. introduced through the bug 4033992
4442:
4443: 10. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
4444: DB Entity as required for CASE COMPLAINCE. Version 116.1
4445:

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

4484: -----------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
4485:
4486: /*
4487: || Code added by aiyer for the bug 4035566
4488: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.
4489: */
4490: --IF jai_cmn_utils_pkg.check_jai_exists ( p_calling_object => 'JA_IN_RMA_AR_LINES_INSERT_TRG' ,
4491: -- p_set_of_books_id => pr_new.set_of_books_id
4492: -- ) = FALSE

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

4486: /*
4487: || Code added by aiyer for the bug 4035566
4488: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.
4489: */
4490: --IF jai_cmn_utils_pkg.check_jai_exists ( p_calling_object => 'JA_IN_RMA_AR_LINES_INSERT_TRG' ,
4491: -- p_set_of_books_id => pr_new.set_of_books_id
4492: -- ) = FALSE
4493: -- THEN
4494: /*

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

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

Line 5156: --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

5152: ------------------
5153: /* --Ramananda for File.Sql.35, end */
5154:
5155: /*The following code has added - ssumaith - bug# 4037690*/
5156: --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
5157: -- return;
5158: --end if;
5159:
5160: OPEN transaction_type_cur;

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

5198: /*ELSE
5199: OPEN ROW_ID_CUR;
5200: FETCH ROW_ID_CUR INTO v_row_id;
5201: CLOSE ROW_ID_CUR;
5202: jai_cmn_utils_pkg.JA_IN_SET_LOCATOR('JAINARTX',v_row_id);*//*commented by rchandan for bug#4479131*/
5203: END IF;
5204: 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
5205: RETURN;
5206: END IF;

Line 5318: v_converted_rate := jai_cmn_utils_pkg.currency_conversion(

5314: IF c_conversion_date is NULL THEN
5315: c_conversion_date := v_trx_date;
5316: END IF;
5317:
5318: v_converted_rate := jai_cmn_utils_pkg.currency_conversion(
5319: v_books_id ,
5320: c_from_currency_code ,
5321: c_conversion_date ,
5322: c_conversion_type,

Line 5730: jai_cmn_utils_pkg.JA_IN_SET_LOCATOR(

5726: /* ELSE
5727: OPEN ROW_ID_CUR;
5728: FETCH ROW_ID_CUR INTO v_row_id;
5729: CLOSE ROW_ID_CUR;
5730: jai_cmn_utils_pkg.JA_IN_SET_LOCATOR(
5731: 'JAINARTX',
5732: v_row_id
5733: );*//*commented by rchandan for bug#4479131*/
5734: END IF;

Line 5770: v_converted_rate := jai_cmn_utils_pkg.currency_conversion (

5766: IF c_conversion_date is NULL THEN
5767: c_conversion_date := v_trx_date;
5768: END IF;
5769:
5770: v_converted_rate := jai_cmn_utils_pkg.currency_conversion (
5771: v_books_id ,
5772: c_from_currency_code ,
5773: c_conversion_date ,
5774: c_conversion_type ,

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

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

Line 6103: --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

6099: /* --Ramananda for File.Sql.35 */
6100:
6101: /*The following code has added - ssumaith - bug# 4037690*/
6102:
6103: --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
6104: -- return;
6105: --end if;
6106:
6107: OPEN transaction_type_cur;

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

6149: /*ELSE
6150: OPEN ROW_ID_CUR;
6151: FETCH ROW_ID_CUR INTO v_row_id;
6152: CLOSE ROW_ID_CUR;
6153: jai_cmn_utils_pkg.JA_IN_SET_LOCATOR('JAINARTX',v_row_id);*//*commented by rchandan for bug#4479131*/
6154: END IF;
6155: IF NVL(v_organization_id,999999) = 999999 THEN
6156: RETURN;
6157: END IF;