39: FETCH app_amount INTO l_amount;
40: CLOSE app_amount;
41: ELSE
42: l_field := 'P_STATUS';
43: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
44: FND_MESSAGE.set_token('PROCEDURE','GET_AMOUNT');
45: FND_MESSAGE.set_token('PARAMETER', l_field);
46: APP_EXCEPTION.raise_exception;
47: END IF;
40: CLOSE app_amount;
41: ELSE
42: l_field := 'P_STATUS';
43: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
44: FND_MESSAGE.set_token('PROCEDURE','GET_AMOUNT');
45: FND_MESSAGE.set_token('PARAMETER', l_field);
46: APP_EXCEPTION.raise_exception;
47: END IF;
48:
41: ELSE
42: l_field := 'P_STATUS';
43: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
44: FND_MESSAGE.set_token('PROCEDURE','GET_AMOUNT');
45: FND_MESSAGE.set_token('PARAMETER', l_field);
46: APP_EXCEPTION.raise_exception;
47: END IF;
48:
49: RETURN l_amount;
104: FETCH app_amount INTO l_amount;
105: CLOSE app_amount;
106: ELSE
107: l_field := 'P_STATUS';
108: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
109: FND_MESSAGE.set_token('PROCEDURE','GET_ACCTD_AMOUNT');
110: FND_MESSAGE.set_token('PARAMETER', l_field);
111: APP_EXCEPTION.raise_exception;
112: END IF;
105: CLOSE app_amount;
106: ELSE
107: l_field := 'P_STATUS';
108: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
109: FND_MESSAGE.set_token('PROCEDURE','GET_ACCTD_AMOUNT');
110: FND_MESSAGE.set_token('PARAMETER', l_field);
111: APP_EXCEPTION.raise_exception;
112: END IF;
113:
106: ELSE
107: l_field := 'P_STATUS';
108: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
109: FND_MESSAGE.set_token('PROCEDURE','GET_ACCTD_AMOUNT');
110: FND_MESSAGE.set_token('PARAMETER', l_field);
111: APP_EXCEPTION.raise_exception;
112: END IF;
113:
114: RETURN l_amount;