DBA Data[Home] [Help]

APPS.JAI_INV_MMT_TRIGGER_PKG dependencies on APP_EXCEPTION

Line 1029: APP_EXCEPTION.RAISE_EXCEPTION( 'JA', -20109, 'Enough RG23 Part1 balances do not exist. Register Type,Org,Loc-'||v_reg_type||','||v_temp_organization_id||','||v_temp_loc_id);

1025:
1026: IF lv_allow_negative_rg_flag = 'N'
1027: THEN
1028: if v_closing_qty < 0 then
1029: APP_EXCEPTION.RAISE_EXCEPTION( 'JA', -20109, 'Enough RG23 Part1 balances do not exist. Register Type,Org,Loc-'||v_reg_type||','||v_temp_organization_id||','||v_temp_loc_id);
1030: end if;
1031: END IF;
1032: /*end bug 9122545*/
1033: --added rounding precision of 5 fro bug 9466919

Line 1489: APP_EXCEPTION.RAISE_EXCEPTION('JA', -20110, 'Enough RG23 Part1 balances do not exist. Register Type,Org,Loc-'||v_reg_type||','||pr_new.organization_id||','||v_loc_id);

1485:
1486: IF lv_allow_negative_rg_flag = 'N'
1487: THEN
1488: if v_closing_qty < 0 then
1489: APP_EXCEPTION.RAISE_EXCEPTION('JA', -20110, 'Enough RG23 Part1 balances do not exist. Register Type,Org,Loc-'||v_reg_type||','||pr_new.organization_id||','||v_loc_id);
1490: end if;
1491: END IF;
1492: /*End bug 9122545*/
1493: INSERT INTO JAI_CMN_RG_23AC_I_TRXS

Line 1744: APP_EXCEPTION.RAISE_EXCEPTION('JA', -20111, 'Enough RG23 Part1 balances do not exist. Register Type,Org,Loc-'||v_reg_type||','||pr_new.organization_id||','||v_loc_id);

1740:
1741: IF lv_allow_negative_rg_flag = 'N'
1742: THEN
1743: if NVL(v_opening_qty,0) -NVL(v_hit_rg23_qty,0) < 0 then
1744: APP_EXCEPTION.RAISE_EXCEPTION('JA', -20111, 'Enough RG23 Part1 balances do not exist. Register Type,Org,Loc-'||v_reg_type||','||pr_new.organization_id||','||v_loc_id);
1745: end if;
1746: END IF;
1747: /*end bug 9122545*/
1748: INSERT INTO JAI_CMN_RG_23AC_I_TRXS

Line 2070: APP_EXCEPTION.RAISE_EXCEPTION('JA', -20112, 'Enough RG23 Part1 balances do not exist. Register Type,Org,Loc-'||v_reg_type||','||pr_new.organization_id||','||v_loc_id);

2066:
2067: IF lv_allow_negative_rg_flag = 'N'
2068: THEN
2069: if v_closing_qty < 0 then
2070: APP_EXCEPTION.RAISE_EXCEPTION('JA', -20112, 'Enough RG23 Part1 balances do not exist. Register Type,Org,Loc-'||v_reg_type||','||pr_new.organization_id||','||v_loc_id);
2071: end if;
2072: END IF;
2073: /*end bug 9122545*/
2074: INSERT INTO JAI_CMN_RG_23AC_I_TRXS (

Line 2364: APP_EXCEPTION.RAISE_EXCEPTION('JA', -20113, 'Enough RG23 Part1 balances do not exist. Register Type,Org,Loc-'||v_reg_type||','||pr_new.organization_id||','||v_loc_id);

2360:
2361: IF lv_allow_negative_rg_flag = 'N'
2362: THEN
2363: if v_closing_qty < 0 then
2364: APP_EXCEPTION.RAISE_EXCEPTION('JA', -20113, 'Enough RG23 Part1 balances do not exist. Register Type,Org,Loc-'||v_reg_type||','||pr_new.organization_id||','||v_loc_id);
2365: end if;
2366: END IF;
2367: /*end bug 9122545*/
2368: INSERT INTO JAI_CMN_RG_23AC_I_TRXS (

Line 2741: APP_EXCEPTION.RAISE_EXCEPTION('JA', -20114, 'Enough RG23 Part1 balances do not exist. Register Type,Org,Loc-'||v_reg_type||','||pr_new.organization_id||','||v_loc_id);

2737:
2738: IF lv_allow_negative_rg_flag = 'N'
2739: THEN
2740: if v_closing_qty < 0 then
2741: APP_EXCEPTION.RAISE_EXCEPTION('JA', -20114, 'Enough RG23 Part1 balances do not exist. Register Type,Org,Loc-'||v_reg_type||','||pr_new.organization_id||','||v_loc_id);
2742: end if;
2743: END IF;
2744: /*end bug 9122545*/
2745: INSERT INTO JAI_CMN_RG_23AC_I_TRXS