DBA Data[Home] [Help]

APPS.JAI_JOM_LM_TRIGGER_PKG dependencies on JAI_CONSTANTS

Line 43: pv_return_code := jai_constants.successful ;

39: 4. 13/06/2007 bduvarag for the bug#6124130, File version 120.1
40: changed the condtion > to >= while matching the lc_amount
41: ----------------------------------------------------------------------------------------*/
42: BEGIN
43: pv_return_code := jai_constants.successful ;
44: lv_amount_applied := pr_new.amount; --Ramananda for File.Sql.35
45:
46: OPEN lc_check_count;
47: FETCH lc_check_count INTO lv_lc_count;

Line 63: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'There is not enough Balance available for this Matching' ; return ;

59: SET lc_balance_amount = ROUND(NVL(lc_balance_amount,0),2) - ROUND(NVL(lv_amount_applied,0),2)
60: WHERE lc_number = pr_new.lc_number;
61: ELSE
62: /* RAISE_APPLICATION_ERROR(-20102,'There is not enough Balance available for this Matching');
63: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'There is not enough Balance available for this Matching' ; return ;
64: END IF ;
65: ELSE
66: /* RAISE_APPLICATION_ERROR(-20101,'The Matched LC Does not Exist');
67: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'The Matched LC Does not Exist' ; return ;

Line 67: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'The Matched LC Does not Exist' ; return ;

63: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'There is not enough Balance available for this Matching' ; return ;
64: END IF ;
65: ELSE
66: /* RAISE_APPLICATION_ERROR(-20101,'The Matched LC Does not Exist');
67: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'The Matched LC Does not Exist' ; return ;
68: END IF ;
69: /* Added an exception block by Ramananda for bug#4570303 */
70: EXCEPTION
71: WHEN OTHERS THEN

Line 72: Pv_return_code := jai_constants.unexpected_error;

68: END IF ;
69: /* Added an exception block by Ramananda for bug#4570303 */
70: EXCEPTION
71: WHEN OTHERS THEN
72: Pv_return_code := jai_constants.unexpected_error;
73: Pv_return_message := 'Encountered an error in JAI_JOM_LM_TRIGGER_PKG.ARI_T1 ' || substr(sqlerrm,1,1900);
74:
75: END ARI_T1 ;
76: