eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_INTEREST_LINES_PKG dependencies on FND_API

Line 48: x_return_status := fnd_api.g_ret_sts_success;

44: FOR UPDATE of Interest_Line_Id NOWAIT;
45: Recinfo C%ROWTYPE;
46: BEGIN
47: arp_util.debug('AR_INTEREST_BATCHES_PKG.Lock_line+');
48: x_return_status := fnd_api.g_ret_sts_success;
49:
50: OPEN C;
51: FETCH C INTO Recinfo;
52: IF (C%NOTFOUND) THEN

Line 54: x_return_status := fnd_api.g_ret_sts_error;

50: OPEN C;
51: FETCH C INTO Recinfo;
52: IF (C%NOTFOUND) THEN
53: CLOSE C;
54: x_return_status := fnd_api.g_ret_sts_error;
55: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
56: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
57: p_count => x_msg_count,
58: p_data => x_msg_data);

Line 56: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

52: IF (C%NOTFOUND) THEN
53: CLOSE C;
54: x_return_status := fnd_api.g_ret_sts_error;
55: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
56: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
57: p_count => x_msg_count,
58: p_data => x_msg_data);
59: END IF;
60: CLOSE C;

Line 67: AND (NVL(Recinfo.daily_interest_charge,fnd_api.g_miss_num) = NVL(P_DAILY_INTEREST_CHARGE,fnd_api.g_miss_num))

63: AND (Recinfo.INTEREST_HEADER_ID = p_interest_header_id)
64: AND (Recinfo.PAYMENT_SCHEDULE_ID = P_PAYMENT_SCHEDULE_ID)
65: AND (NVL(Recinfo.TYPE,'X') = NVL(P_TYPE,'X'))
66: AND (NVL(Recinfo.original_trx_class,'X') = NVL(P_ORIGINAL_TRX_CLASS,'X'))
67: AND (NVL(Recinfo.daily_interest_charge,fnd_api.g_miss_num) = NVL(P_DAILY_INTEREST_CHARGE,fnd_api.g_miss_num))
68: AND (NVL(Recinfo.outstanding_amount,fnd_api.g_miss_num) = NVL(P_OUTSTANDING_AMOUNT,fnd_api.g_miss_num))
69: AND (NVL(Recinfo.days_overdue_late,fnd_api.g_miss_num) = NVL(P_DAYS_OVERDUE_LATE,fnd_api.g_miss_num))
70: AND (NVL(Recinfo.days_of_interest,fnd_api.g_miss_num) = NVL(P_DAYS_OF_INTEREST,fnd_api.g_miss_num))
71: AND (NVL(Recinfo.interest_charged,fnd_api.g_miss_num) = NVL(P_INTEREST_CHARGED,fnd_api.g_miss_num))

Line 68: AND (NVL(Recinfo.outstanding_amount,fnd_api.g_miss_num) = NVL(P_OUTSTANDING_AMOUNT,fnd_api.g_miss_num))

64: AND (Recinfo.PAYMENT_SCHEDULE_ID = P_PAYMENT_SCHEDULE_ID)
65: AND (NVL(Recinfo.TYPE,'X') = NVL(P_TYPE,'X'))
66: AND (NVL(Recinfo.original_trx_class,'X') = NVL(P_ORIGINAL_TRX_CLASS,'X'))
67: AND (NVL(Recinfo.daily_interest_charge,fnd_api.g_miss_num) = NVL(P_DAILY_INTEREST_CHARGE,fnd_api.g_miss_num))
68: AND (NVL(Recinfo.outstanding_amount,fnd_api.g_miss_num) = NVL(P_OUTSTANDING_AMOUNT,fnd_api.g_miss_num))
69: AND (NVL(Recinfo.days_overdue_late,fnd_api.g_miss_num) = NVL(P_DAYS_OVERDUE_LATE,fnd_api.g_miss_num))
70: AND (NVL(Recinfo.days_of_interest,fnd_api.g_miss_num) = NVL(P_DAYS_OF_INTEREST,fnd_api.g_miss_num))
71: AND (NVL(Recinfo.interest_charged,fnd_api.g_miss_num) = NVL(P_INTEREST_CHARGED,fnd_api.g_miss_num))
72: AND (NVL(Recinfo.payment_date,fnd_api.g_miss_date) = NVL(P_PAYMENT_DATE,fnd_api.g_miss_Date))

Line 69: AND (NVL(Recinfo.days_overdue_late,fnd_api.g_miss_num) = NVL(P_DAYS_OVERDUE_LATE,fnd_api.g_miss_num))

65: AND (NVL(Recinfo.TYPE,'X') = NVL(P_TYPE,'X'))
66: AND (NVL(Recinfo.original_trx_class,'X') = NVL(P_ORIGINAL_TRX_CLASS,'X'))
67: AND (NVL(Recinfo.daily_interest_charge,fnd_api.g_miss_num) = NVL(P_DAILY_INTEREST_CHARGE,fnd_api.g_miss_num))
68: AND (NVL(Recinfo.outstanding_amount,fnd_api.g_miss_num) = NVL(P_OUTSTANDING_AMOUNT,fnd_api.g_miss_num))
69: AND (NVL(Recinfo.days_overdue_late,fnd_api.g_miss_num) = NVL(P_DAYS_OVERDUE_LATE,fnd_api.g_miss_num))
70: AND (NVL(Recinfo.days_of_interest,fnd_api.g_miss_num) = NVL(P_DAYS_OF_INTEREST,fnd_api.g_miss_num))
71: AND (NVL(Recinfo.interest_charged,fnd_api.g_miss_num) = NVL(P_INTEREST_CHARGED,fnd_api.g_miss_num))
72: AND (NVL(Recinfo.payment_date,fnd_api.g_miss_date) = NVL(P_PAYMENT_DATE,fnd_api.g_miss_Date))
73: AND (NVL(Recinfo.finance_charge_charged,fnd_api.g_miss_num) = NVL(P_FINANCE_CHARGE_CHARGED,fnd_api.g_miss_num))

Line 70: AND (NVL(Recinfo.days_of_interest,fnd_api.g_miss_num) = NVL(P_DAYS_OF_INTEREST,fnd_api.g_miss_num))

66: AND (NVL(Recinfo.original_trx_class,'X') = NVL(P_ORIGINAL_TRX_CLASS,'X'))
67: AND (NVL(Recinfo.daily_interest_charge,fnd_api.g_miss_num) = NVL(P_DAILY_INTEREST_CHARGE,fnd_api.g_miss_num))
68: AND (NVL(Recinfo.outstanding_amount,fnd_api.g_miss_num) = NVL(P_OUTSTANDING_AMOUNT,fnd_api.g_miss_num))
69: AND (NVL(Recinfo.days_overdue_late,fnd_api.g_miss_num) = NVL(P_DAYS_OVERDUE_LATE,fnd_api.g_miss_num))
70: AND (NVL(Recinfo.days_of_interest,fnd_api.g_miss_num) = NVL(P_DAYS_OF_INTEREST,fnd_api.g_miss_num))
71: AND (NVL(Recinfo.interest_charged,fnd_api.g_miss_num) = NVL(P_INTEREST_CHARGED,fnd_api.g_miss_num))
72: AND (NVL(Recinfo.payment_date,fnd_api.g_miss_date) = NVL(P_PAYMENT_DATE,fnd_api.g_miss_Date))
73: AND (NVL(Recinfo.finance_charge_charged,fnd_api.g_miss_num) = NVL(P_FINANCE_CHARGE_CHARGED,fnd_api.g_miss_num))
74: AND (NVL(Recinfo.amount_due_original,fnd_api.g_miss_num) = NVL(P_AMOUNT_DUE_ORIGINAL,fnd_api.g_miss_num))

Line 71: AND (NVL(Recinfo.interest_charged,fnd_api.g_miss_num) = NVL(P_INTEREST_CHARGED,fnd_api.g_miss_num))

67: AND (NVL(Recinfo.daily_interest_charge,fnd_api.g_miss_num) = NVL(P_DAILY_INTEREST_CHARGE,fnd_api.g_miss_num))
68: AND (NVL(Recinfo.outstanding_amount,fnd_api.g_miss_num) = NVL(P_OUTSTANDING_AMOUNT,fnd_api.g_miss_num))
69: AND (NVL(Recinfo.days_overdue_late,fnd_api.g_miss_num) = NVL(P_DAYS_OVERDUE_LATE,fnd_api.g_miss_num))
70: AND (NVL(Recinfo.days_of_interest,fnd_api.g_miss_num) = NVL(P_DAYS_OF_INTEREST,fnd_api.g_miss_num))
71: AND (NVL(Recinfo.interest_charged,fnd_api.g_miss_num) = NVL(P_INTEREST_CHARGED,fnd_api.g_miss_num))
72: AND (NVL(Recinfo.payment_date,fnd_api.g_miss_date) = NVL(P_PAYMENT_DATE,fnd_api.g_miss_Date))
73: AND (NVL(Recinfo.finance_charge_charged,fnd_api.g_miss_num) = NVL(P_FINANCE_CHARGE_CHARGED,fnd_api.g_miss_num))
74: AND (NVL(Recinfo.amount_due_original,fnd_api.g_miss_num) = NVL(P_AMOUNT_DUE_ORIGINAL,fnd_api.g_miss_num))
75: AND (NVL(Recinfo.amount_due_remaining,fnd_api.g_miss_num) = NVL(P_AMOUNT_DUE_REMAINING,fnd_api.g_miss_num))

Line 72: AND (NVL(Recinfo.payment_date,fnd_api.g_miss_date) = NVL(P_PAYMENT_DATE,fnd_api.g_miss_Date))

68: AND (NVL(Recinfo.outstanding_amount,fnd_api.g_miss_num) = NVL(P_OUTSTANDING_AMOUNT,fnd_api.g_miss_num))
69: AND (NVL(Recinfo.days_overdue_late,fnd_api.g_miss_num) = NVL(P_DAYS_OVERDUE_LATE,fnd_api.g_miss_num))
70: AND (NVL(Recinfo.days_of_interest,fnd_api.g_miss_num) = NVL(P_DAYS_OF_INTEREST,fnd_api.g_miss_num))
71: AND (NVL(Recinfo.interest_charged,fnd_api.g_miss_num) = NVL(P_INTEREST_CHARGED,fnd_api.g_miss_num))
72: AND (NVL(Recinfo.payment_date,fnd_api.g_miss_date) = NVL(P_PAYMENT_DATE,fnd_api.g_miss_Date))
73: AND (NVL(Recinfo.finance_charge_charged,fnd_api.g_miss_num) = NVL(P_FINANCE_CHARGE_CHARGED,fnd_api.g_miss_num))
74: AND (NVL(Recinfo.amount_due_original,fnd_api.g_miss_num) = NVL(P_AMOUNT_DUE_ORIGINAL,fnd_api.g_miss_num))
75: AND (NVL(Recinfo.amount_due_remaining,fnd_api.g_miss_num) = NVL(P_AMOUNT_DUE_REMAINING,fnd_api.g_miss_num))
76: AND (NVL(Recinfo.original_trx_id,fnd_api.g_miss_num) = NVL(P_ORIGINAL_TRX_ID,fnd_api.g_miss_num))

Line 73: AND (NVL(Recinfo.finance_charge_charged,fnd_api.g_miss_num) = NVL(P_FINANCE_CHARGE_CHARGED,fnd_api.g_miss_num))

69: AND (NVL(Recinfo.days_overdue_late,fnd_api.g_miss_num) = NVL(P_DAYS_OVERDUE_LATE,fnd_api.g_miss_num))
70: AND (NVL(Recinfo.days_of_interest,fnd_api.g_miss_num) = NVL(P_DAYS_OF_INTEREST,fnd_api.g_miss_num))
71: AND (NVL(Recinfo.interest_charged,fnd_api.g_miss_num) = NVL(P_INTEREST_CHARGED,fnd_api.g_miss_num))
72: AND (NVL(Recinfo.payment_date,fnd_api.g_miss_date) = NVL(P_PAYMENT_DATE,fnd_api.g_miss_Date))
73: AND (NVL(Recinfo.finance_charge_charged,fnd_api.g_miss_num) = NVL(P_FINANCE_CHARGE_CHARGED,fnd_api.g_miss_num))
74: AND (NVL(Recinfo.amount_due_original,fnd_api.g_miss_num) = NVL(P_AMOUNT_DUE_ORIGINAL,fnd_api.g_miss_num))
75: AND (NVL(Recinfo.amount_due_remaining,fnd_api.g_miss_num) = NVL(P_AMOUNT_DUE_REMAINING,fnd_api.g_miss_num))
76: AND (NVL(Recinfo.original_trx_id,fnd_api.g_miss_num) = NVL(P_ORIGINAL_TRX_ID,fnd_api.g_miss_num))
77: AND (NVL(Recinfo.receivables_trx_id,fnd_api.g_miss_num) = NVL(P_RECEIVABLES_TRX_ID,fnd_api.g_miss_num))

Line 74: AND (NVL(Recinfo.amount_due_original,fnd_api.g_miss_num) = NVL(P_AMOUNT_DUE_ORIGINAL,fnd_api.g_miss_num))

70: AND (NVL(Recinfo.days_of_interest,fnd_api.g_miss_num) = NVL(P_DAYS_OF_INTEREST,fnd_api.g_miss_num))
71: AND (NVL(Recinfo.interest_charged,fnd_api.g_miss_num) = NVL(P_INTEREST_CHARGED,fnd_api.g_miss_num))
72: AND (NVL(Recinfo.payment_date,fnd_api.g_miss_date) = NVL(P_PAYMENT_DATE,fnd_api.g_miss_Date))
73: AND (NVL(Recinfo.finance_charge_charged,fnd_api.g_miss_num) = NVL(P_FINANCE_CHARGE_CHARGED,fnd_api.g_miss_num))
74: AND (NVL(Recinfo.amount_due_original,fnd_api.g_miss_num) = NVL(P_AMOUNT_DUE_ORIGINAL,fnd_api.g_miss_num))
75: AND (NVL(Recinfo.amount_due_remaining,fnd_api.g_miss_num) = NVL(P_AMOUNT_DUE_REMAINING,fnd_api.g_miss_num))
76: AND (NVL(Recinfo.original_trx_id,fnd_api.g_miss_num) = NVL(P_ORIGINAL_TRX_ID,fnd_api.g_miss_num))
77: AND (NVL(Recinfo.receivables_trx_id,fnd_api.g_miss_num) = NVL(P_RECEIVABLES_TRX_ID,fnd_api.g_miss_num))
78: AND (NVL(Recinfo.last_charge_date,fnd_api.g_miss_date) = NVL(P_LAST_CHARGE_DATE,fnd_api.g_miss_date))

Line 75: AND (NVL(Recinfo.amount_due_remaining,fnd_api.g_miss_num) = NVL(P_AMOUNT_DUE_REMAINING,fnd_api.g_miss_num))

71: AND (NVL(Recinfo.interest_charged,fnd_api.g_miss_num) = NVL(P_INTEREST_CHARGED,fnd_api.g_miss_num))
72: AND (NVL(Recinfo.payment_date,fnd_api.g_miss_date) = NVL(P_PAYMENT_DATE,fnd_api.g_miss_Date))
73: AND (NVL(Recinfo.finance_charge_charged,fnd_api.g_miss_num) = NVL(P_FINANCE_CHARGE_CHARGED,fnd_api.g_miss_num))
74: AND (NVL(Recinfo.amount_due_original,fnd_api.g_miss_num) = NVL(P_AMOUNT_DUE_ORIGINAL,fnd_api.g_miss_num))
75: AND (NVL(Recinfo.amount_due_remaining,fnd_api.g_miss_num) = NVL(P_AMOUNT_DUE_REMAINING,fnd_api.g_miss_num))
76: AND (NVL(Recinfo.original_trx_id,fnd_api.g_miss_num) = NVL(P_ORIGINAL_TRX_ID,fnd_api.g_miss_num))
77: AND (NVL(Recinfo.receivables_trx_id,fnd_api.g_miss_num) = NVL(P_RECEIVABLES_TRX_ID,fnd_api.g_miss_num))
78: AND (NVL(Recinfo.last_charge_date,fnd_api.g_miss_date) = NVL(P_LAST_CHARGE_DATE,fnd_api.g_miss_date))
79: AND (NVL(Recinfo.due_date,fnd_api.g_miss_date) = NVL(P_DUE_DATE,fnd_api.g_miss_date))

Line 76: AND (NVL(Recinfo.original_trx_id,fnd_api.g_miss_num) = NVL(P_ORIGINAL_TRX_ID,fnd_api.g_miss_num))

72: AND (NVL(Recinfo.payment_date,fnd_api.g_miss_date) = NVL(P_PAYMENT_DATE,fnd_api.g_miss_Date))
73: AND (NVL(Recinfo.finance_charge_charged,fnd_api.g_miss_num) = NVL(P_FINANCE_CHARGE_CHARGED,fnd_api.g_miss_num))
74: AND (NVL(Recinfo.amount_due_original,fnd_api.g_miss_num) = NVL(P_AMOUNT_DUE_ORIGINAL,fnd_api.g_miss_num))
75: AND (NVL(Recinfo.amount_due_remaining,fnd_api.g_miss_num) = NVL(P_AMOUNT_DUE_REMAINING,fnd_api.g_miss_num))
76: AND (NVL(Recinfo.original_trx_id,fnd_api.g_miss_num) = NVL(P_ORIGINAL_TRX_ID,fnd_api.g_miss_num))
77: AND (NVL(Recinfo.receivables_trx_id,fnd_api.g_miss_num) = NVL(P_RECEIVABLES_TRX_ID,fnd_api.g_miss_num))
78: AND (NVL(Recinfo.last_charge_date,fnd_api.g_miss_date) = NVL(P_LAST_CHARGE_DATE,fnd_api.g_miss_date))
79: AND (NVL(Recinfo.due_date,fnd_api.g_miss_date) = NVL(P_DUE_DATE,fnd_api.g_miss_date))
80: AND (NVL(Recinfo.actual_date_closed,fnd_api.g_miss_date) = NVL(P_ACTUAL_DATE_CLOSED,fnd_api.g_miss_date))

Line 77: AND (NVL(Recinfo.receivables_trx_id,fnd_api.g_miss_num) = NVL(P_RECEIVABLES_TRX_ID,fnd_api.g_miss_num))

73: AND (NVL(Recinfo.finance_charge_charged,fnd_api.g_miss_num) = NVL(P_FINANCE_CHARGE_CHARGED,fnd_api.g_miss_num))
74: AND (NVL(Recinfo.amount_due_original,fnd_api.g_miss_num) = NVL(P_AMOUNT_DUE_ORIGINAL,fnd_api.g_miss_num))
75: AND (NVL(Recinfo.amount_due_remaining,fnd_api.g_miss_num) = NVL(P_AMOUNT_DUE_REMAINING,fnd_api.g_miss_num))
76: AND (NVL(Recinfo.original_trx_id,fnd_api.g_miss_num) = NVL(P_ORIGINAL_TRX_ID,fnd_api.g_miss_num))
77: AND (NVL(Recinfo.receivables_trx_id,fnd_api.g_miss_num) = NVL(P_RECEIVABLES_TRX_ID,fnd_api.g_miss_num))
78: AND (NVL(Recinfo.last_charge_date,fnd_api.g_miss_date) = NVL(P_LAST_CHARGE_DATE,fnd_api.g_miss_date))
79: AND (NVL(Recinfo.due_date,fnd_api.g_miss_date) = NVL(P_DUE_DATE,fnd_api.g_miss_date))
80: AND (NVL(Recinfo.actual_date_closed,fnd_api.g_miss_date) = NVL(P_ACTUAL_DATE_CLOSED,fnd_api.g_miss_date))
81: AND (NVL(Recinfo.interest_rate,fnd_api.g_miss_num) = NVL(P_INTEREST_RATE,fnd_api.g_miss_num))

Line 78: AND (NVL(Recinfo.last_charge_date,fnd_api.g_miss_date) = NVL(P_LAST_CHARGE_DATE,fnd_api.g_miss_date))

74: AND (NVL(Recinfo.amount_due_original,fnd_api.g_miss_num) = NVL(P_AMOUNT_DUE_ORIGINAL,fnd_api.g_miss_num))
75: AND (NVL(Recinfo.amount_due_remaining,fnd_api.g_miss_num) = NVL(P_AMOUNT_DUE_REMAINING,fnd_api.g_miss_num))
76: AND (NVL(Recinfo.original_trx_id,fnd_api.g_miss_num) = NVL(P_ORIGINAL_TRX_ID,fnd_api.g_miss_num))
77: AND (NVL(Recinfo.receivables_trx_id,fnd_api.g_miss_num) = NVL(P_RECEIVABLES_TRX_ID,fnd_api.g_miss_num))
78: AND (NVL(Recinfo.last_charge_date,fnd_api.g_miss_date) = NVL(P_LAST_CHARGE_DATE,fnd_api.g_miss_date))
79: AND (NVL(Recinfo.due_date,fnd_api.g_miss_date) = NVL(P_DUE_DATE,fnd_api.g_miss_date))
80: AND (NVL(Recinfo.actual_date_closed,fnd_api.g_miss_date) = NVL(P_ACTUAL_DATE_CLOSED,fnd_api.g_miss_date))
81: AND (NVL(Recinfo.interest_rate,fnd_api.g_miss_num) = NVL(P_INTEREST_RATE,fnd_api.g_miss_num))
82: AND (NVL(Recinfo.rate_start_date,fnd_api.g_miss_date) = NVL(P_RATE_START_DATE,fnd_api.g_miss_date))

Line 79: AND (NVL(Recinfo.due_date,fnd_api.g_miss_date) = NVL(P_DUE_DATE,fnd_api.g_miss_date))

75: AND (NVL(Recinfo.amount_due_remaining,fnd_api.g_miss_num) = NVL(P_AMOUNT_DUE_REMAINING,fnd_api.g_miss_num))
76: AND (NVL(Recinfo.original_trx_id,fnd_api.g_miss_num) = NVL(P_ORIGINAL_TRX_ID,fnd_api.g_miss_num))
77: AND (NVL(Recinfo.receivables_trx_id,fnd_api.g_miss_num) = NVL(P_RECEIVABLES_TRX_ID,fnd_api.g_miss_num))
78: AND (NVL(Recinfo.last_charge_date,fnd_api.g_miss_date) = NVL(P_LAST_CHARGE_DATE,fnd_api.g_miss_date))
79: AND (NVL(Recinfo.due_date,fnd_api.g_miss_date) = NVL(P_DUE_DATE,fnd_api.g_miss_date))
80: AND (NVL(Recinfo.actual_date_closed,fnd_api.g_miss_date) = NVL(P_ACTUAL_DATE_CLOSED,fnd_api.g_miss_date))
81: AND (NVL(Recinfo.interest_rate,fnd_api.g_miss_num) = NVL(P_INTEREST_RATE,fnd_api.g_miss_num))
82: AND (NVL(Recinfo.rate_start_date,fnd_api.g_miss_date) = NVL(P_RATE_START_DATE,fnd_api.g_miss_date))
83: AND (NVL(Recinfo.rate_end_date,fnd_api.g_miss_date) = NVL(P_RATE_END_DATE,fnd_api.g_miss_date))

Line 80: AND (NVL(Recinfo.actual_date_closed,fnd_api.g_miss_date) = NVL(P_ACTUAL_DATE_CLOSED,fnd_api.g_miss_date))

76: AND (NVL(Recinfo.original_trx_id,fnd_api.g_miss_num) = NVL(P_ORIGINAL_TRX_ID,fnd_api.g_miss_num))
77: AND (NVL(Recinfo.receivables_trx_id,fnd_api.g_miss_num) = NVL(P_RECEIVABLES_TRX_ID,fnd_api.g_miss_num))
78: AND (NVL(Recinfo.last_charge_date,fnd_api.g_miss_date) = NVL(P_LAST_CHARGE_DATE,fnd_api.g_miss_date))
79: AND (NVL(Recinfo.due_date,fnd_api.g_miss_date) = NVL(P_DUE_DATE,fnd_api.g_miss_date))
80: AND (NVL(Recinfo.actual_date_closed,fnd_api.g_miss_date) = NVL(P_ACTUAL_DATE_CLOSED,fnd_api.g_miss_date))
81: AND (NVL(Recinfo.interest_rate,fnd_api.g_miss_num) = NVL(P_INTEREST_RATE,fnd_api.g_miss_num))
82: AND (NVL(Recinfo.rate_start_date,fnd_api.g_miss_date) = NVL(P_RATE_START_DATE,fnd_api.g_miss_date))
83: AND (NVL(Recinfo.rate_end_date,fnd_api.g_miss_date) = NVL(P_RATE_END_DATE,fnd_api.g_miss_date))
84: AND (NVL(Recinfo.schedule_days_from,fnd_api.g_miss_num) = NVL(P_SCHEDULE_DAYS_FROM,fnd_api.g_miss_num))

Line 81: AND (NVL(Recinfo.interest_rate,fnd_api.g_miss_num) = NVL(P_INTEREST_RATE,fnd_api.g_miss_num))

77: AND (NVL(Recinfo.receivables_trx_id,fnd_api.g_miss_num) = NVL(P_RECEIVABLES_TRX_ID,fnd_api.g_miss_num))
78: AND (NVL(Recinfo.last_charge_date,fnd_api.g_miss_date) = NVL(P_LAST_CHARGE_DATE,fnd_api.g_miss_date))
79: AND (NVL(Recinfo.due_date,fnd_api.g_miss_date) = NVL(P_DUE_DATE,fnd_api.g_miss_date))
80: AND (NVL(Recinfo.actual_date_closed,fnd_api.g_miss_date) = NVL(P_ACTUAL_DATE_CLOSED,fnd_api.g_miss_date))
81: AND (NVL(Recinfo.interest_rate,fnd_api.g_miss_num) = NVL(P_INTEREST_RATE,fnd_api.g_miss_num))
82: AND (NVL(Recinfo.rate_start_date,fnd_api.g_miss_date) = NVL(P_RATE_START_DATE,fnd_api.g_miss_date))
83: AND (NVL(Recinfo.rate_end_date,fnd_api.g_miss_date) = NVL(P_RATE_END_DATE,fnd_api.g_miss_date))
84: AND (NVL(Recinfo.schedule_days_from,fnd_api.g_miss_num) = NVL(P_SCHEDULE_DAYS_FROM,fnd_api.g_miss_num))
85: AND (NVL(Recinfo.schedule_days_to,fnd_api.g_miss_num) = NVL(P_SCHEDULE_DAYS_TO,fnd_api.g_miss_num))

Line 82: AND (NVL(Recinfo.rate_start_date,fnd_api.g_miss_date) = NVL(P_RATE_START_DATE,fnd_api.g_miss_date))

78: AND (NVL(Recinfo.last_charge_date,fnd_api.g_miss_date) = NVL(P_LAST_CHARGE_DATE,fnd_api.g_miss_date))
79: AND (NVL(Recinfo.due_date,fnd_api.g_miss_date) = NVL(P_DUE_DATE,fnd_api.g_miss_date))
80: AND (NVL(Recinfo.actual_date_closed,fnd_api.g_miss_date) = NVL(P_ACTUAL_DATE_CLOSED,fnd_api.g_miss_date))
81: AND (NVL(Recinfo.interest_rate,fnd_api.g_miss_num) = NVL(P_INTEREST_RATE,fnd_api.g_miss_num))
82: AND (NVL(Recinfo.rate_start_date,fnd_api.g_miss_date) = NVL(P_RATE_START_DATE,fnd_api.g_miss_date))
83: AND (NVL(Recinfo.rate_end_date,fnd_api.g_miss_date) = NVL(P_RATE_END_DATE,fnd_api.g_miss_date))
84: AND (NVL(Recinfo.schedule_days_from,fnd_api.g_miss_num) = NVL(P_SCHEDULE_DAYS_FROM,fnd_api.g_miss_num))
85: AND (NVL(Recinfo.schedule_days_to,fnd_api.g_miss_num) = NVL(P_SCHEDULE_DAYS_TO,fnd_api.g_miss_num))
86: AND (NVL(Recinfo.last_update_date,fnd_api.g_miss_date) = NVL(P_LAST_UPDATE_DATE,fnd_api.g_miss_date))

Line 83: AND (NVL(Recinfo.rate_end_date,fnd_api.g_miss_date) = NVL(P_RATE_END_DATE,fnd_api.g_miss_date))

79: AND (NVL(Recinfo.due_date,fnd_api.g_miss_date) = NVL(P_DUE_DATE,fnd_api.g_miss_date))
80: AND (NVL(Recinfo.actual_date_closed,fnd_api.g_miss_date) = NVL(P_ACTUAL_DATE_CLOSED,fnd_api.g_miss_date))
81: AND (NVL(Recinfo.interest_rate,fnd_api.g_miss_num) = NVL(P_INTEREST_RATE,fnd_api.g_miss_num))
82: AND (NVL(Recinfo.rate_start_date,fnd_api.g_miss_date) = NVL(P_RATE_START_DATE,fnd_api.g_miss_date))
83: AND (NVL(Recinfo.rate_end_date,fnd_api.g_miss_date) = NVL(P_RATE_END_DATE,fnd_api.g_miss_date))
84: AND (NVL(Recinfo.schedule_days_from,fnd_api.g_miss_num) = NVL(P_SCHEDULE_DAYS_FROM,fnd_api.g_miss_num))
85: AND (NVL(Recinfo.schedule_days_to,fnd_api.g_miss_num) = NVL(P_SCHEDULE_DAYS_TO,fnd_api.g_miss_num))
86: AND (NVL(Recinfo.last_update_date,fnd_api.g_miss_date) = NVL(P_LAST_UPDATE_DATE,fnd_api.g_miss_date))
87: AND (NVL(Recinfo.last_updated_by,fnd_api.g_miss_num) = NVL(P_LAST_UPDATED_BY,fnd_api.g_miss_num))

Line 84: AND (NVL(Recinfo.schedule_days_from,fnd_api.g_miss_num) = NVL(P_SCHEDULE_DAYS_FROM,fnd_api.g_miss_num))

80: AND (NVL(Recinfo.actual_date_closed,fnd_api.g_miss_date) = NVL(P_ACTUAL_DATE_CLOSED,fnd_api.g_miss_date))
81: AND (NVL(Recinfo.interest_rate,fnd_api.g_miss_num) = NVL(P_INTEREST_RATE,fnd_api.g_miss_num))
82: AND (NVL(Recinfo.rate_start_date,fnd_api.g_miss_date) = NVL(P_RATE_START_DATE,fnd_api.g_miss_date))
83: AND (NVL(Recinfo.rate_end_date,fnd_api.g_miss_date) = NVL(P_RATE_END_DATE,fnd_api.g_miss_date))
84: AND (NVL(Recinfo.schedule_days_from,fnd_api.g_miss_num) = NVL(P_SCHEDULE_DAYS_FROM,fnd_api.g_miss_num))
85: AND (NVL(Recinfo.schedule_days_to,fnd_api.g_miss_num) = NVL(P_SCHEDULE_DAYS_TO,fnd_api.g_miss_num))
86: AND (NVL(Recinfo.last_update_date,fnd_api.g_miss_date) = NVL(P_LAST_UPDATE_DATE,fnd_api.g_miss_date))
87: AND (NVL(Recinfo.last_updated_by,fnd_api.g_miss_num) = NVL(P_LAST_UPDATED_BY,fnd_api.g_miss_num))
88: AND (NVL(Recinfo.last_update_login,fnd_api.g_miss_num) = NVL(P_LAST_UPDATE_LOGIN,fnd_api.g_miss_num))

Line 85: AND (NVL(Recinfo.schedule_days_to,fnd_api.g_miss_num) = NVL(P_SCHEDULE_DAYS_TO,fnd_api.g_miss_num))

81: AND (NVL(Recinfo.interest_rate,fnd_api.g_miss_num) = NVL(P_INTEREST_RATE,fnd_api.g_miss_num))
82: AND (NVL(Recinfo.rate_start_date,fnd_api.g_miss_date) = NVL(P_RATE_START_DATE,fnd_api.g_miss_date))
83: AND (NVL(Recinfo.rate_end_date,fnd_api.g_miss_date) = NVL(P_RATE_END_DATE,fnd_api.g_miss_date))
84: AND (NVL(Recinfo.schedule_days_from,fnd_api.g_miss_num) = NVL(P_SCHEDULE_DAYS_FROM,fnd_api.g_miss_num))
85: AND (NVL(Recinfo.schedule_days_to,fnd_api.g_miss_num) = NVL(P_SCHEDULE_DAYS_TO,fnd_api.g_miss_num))
86: AND (NVL(Recinfo.last_update_date,fnd_api.g_miss_date) = NVL(P_LAST_UPDATE_DATE,fnd_api.g_miss_date))
87: AND (NVL(Recinfo.last_updated_by,fnd_api.g_miss_num) = NVL(P_LAST_UPDATED_BY,fnd_api.g_miss_num))
88: AND (NVL(Recinfo.last_update_login,fnd_api.g_miss_num) = NVL(P_LAST_UPDATE_LOGIN,fnd_api.g_miss_num))
89: AND (NVL(Recinfo.process_status,'X') = NVL(P_PROCESS_STATUS,'X'))

Line 86: AND (NVL(Recinfo.last_update_date,fnd_api.g_miss_date) = NVL(P_LAST_UPDATE_DATE,fnd_api.g_miss_date))

82: AND (NVL(Recinfo.rate_start_date,fnd_api.g_miss_date) = NVL(P_RATE_START_DATE,fnd_api.g_miss_date))
83: AND (NVL(Recinfo.rate_end_date,fnd_api.g_miss_date) = NVL(P_RATE_END_DATE,fnd_api.g_miss_date))
84: AND (NVL(Recinfo.schedule_days_from,fnd_api.g_miss_num) = NVL(P_SCHEDULE_DAYS_FROM,fnd_api.g_miss_num))
85: AND (NVL(Recinfo.schedule_days_to,fnd_api.g_miss_num) = NVL(P_SCHEDULE_DAYS_TO,fnd_api.g_miss_num))
86: AND (NVL(Recinfo.last_update_date,fnd_api.g_miss_date) = NVL(P_LAST_UPDATE_DATE,fnd_api.g_miss_date))
87: AND (NVL(Recinfo.last_updated_by,fnd_api.g_miss_num) = NVL(P_LAST_UPDATED_BY,fnd_api.g_miss_num))
88: AND (NVL(Recinfo.last_update_login,fnd_api.g_miss_num) = NVL(P_LAST_UPDATE_LOGIN,fnd_api.g_miss_num))
89: AND (NVL(Recinfo.process_status,'X') = NVL(P_PROCESS_STATUS,'X'))
90: AND (NVL(Recinfo.process_message,'X') = NVL(P_PROCESS_MESSAGE,'X'))

Line 87: AND (NVL(Recinfo.last_updated_by,fnd_api.g_miss_num) = NVL(P_LAST_UPDATED_BY,fnd_api.g_miss_num))

83: AND (NVL(Recinfo.rate_end_date,fnd_api.g_miss_date) = NVL(P_RATE_END_DATE,fnd_api.g_miss_date))
84: AND (NVL(Recinfo.schedule_days_from,fnd_api.g_miss_num) = NVL(P_SCHEDULE_DAYS_FROM,fnd_api.g_miss_num))
85: AND (NVL(Recinfo.schedule_days_to,fnd_api.g_miss_num) = NVL(P_SCHEDULE_DAYS_TO,fnd_api.g_miss_num))
86: AND (NVL(Recinfo.last_update_date,fnd_api.g_miss_date) = NVL(P_LAST_UPDATE_DATE,fnd_api.g_miss_date))
87: AND (NVL(Recinfo.last_updated_by,fnd_api.g_miss_num) = NVL(P_LAST_UPDATED_BY,fnd_api.g_miss_num))
88: AND (NVL(Recinfo.last_update_login,fnd_api.g_miss_num) = NVL(P_LAST_UPDATE_LOGIN,fnd_api.g_miss_num))
89: AND (NVL(Recinfo.process_status,'X') = NVL(P_PROCESS_STATUS,'X'))
90: AND (NVL(Recinfo.process_message,'X') = NVL(P_PROCESS_MESSAGE,'X'))
91: AND (NVL(Recinfo.org_id,fnd_api.g_miss_num) = NVL(P_ORG_ID,fnd_api.g_miss_num))

Line 88: AND (NVL(Recinfo.last_update_login,fnd_api.g_miss_num) = NVL(P_LAST_UPDATE_LOGIN,fnd_api.g_miss_num))

84: AND (NVL(Recinfo.schedule_days_from,fnd_api.g_miss_num) = NVL(P_SCHEDULE_DAYS_FROM,fnd_api.g_miss_num))
85: AND (NVL(Recinfo.schedule_days_to,fnd_api.g_miss_num) = NVL(P_SCHEDULE_DAYS_TO,fnd_api.g_miss_num))
86: AND (NVL(Recinfo.last_update_date,fnd_api.g_miss_date) = NVL(P_LAST_UPDATE_DATE,fnd_api.g_miss_date))
87: AND (NVL(Recinfo.last_updated_by,fnd_api.g_miss_num) = NVL(P_LAST_UPDATED_BY,fnd_api.g_miss_num))
88: AND (NVL(Recinfo.last_update_login,fnd_api.g_miss_num) = NVL(P_LAST_UPDATE_LOGIN,fnd_api.g_miss_num))
89: AND (NVL(Recinfo.process_status,'X') = NVL(P_PROCESS_STATUS,'X'))
90: AND (NVL(Recinfo.process_message,'X') = NVL(P_PROCESS_MESSAGE,'X'))
91: AND (NVL(Recinfo.org_id,fnd_api.g_miss_num) = NVL(P_ORG_ID,fnd_api.g_miss_num))
92: AND (NVL(Recinfo.object_version_number,1) = NVL(P_object_version_number,1))

Line 91: AND (NVL(Recinfo.org_id,fnd_api.g_miss_num) = NVL(P_ORG_ID,fnd_api.g_miss_num))

87: AND (NVL(Recinfo.last_updated_by,fnd_api.g_miss_num) = NVL(P_LAST_UPDATED_BY,fnd_api.g_miss_num))
88: AND (NVL(Recinfo.last_update_login,fnd_api.g_miss_num) = NVL(P_LAST_UPDATE_LOGIN,fnd_api.g_miss_num))
89: AND (NVL(Recinfo.process_status,'X') = NVL(P_PROCESS_STATUS,'X'))
90: AND (NVL(Recinfo.process_message,'X') = NVL(P_PROCESS_MESSAGE,'X'))
91: AND (NVL(Recinfo.org_id,fnd_api.g_miss_num) = NVL(P_ORG_ID,fnd_api.g_miss_num))
92: AND (NVL(Recinfo.object_version_number,1) = NVL(P_object_version_number,1))
93: THEN
94: RETURN;
95: ELSE

Line 97: x_return_status := fnd_api.g_ret_sts_error;

93: THEN
94: RETURN;
95: ELSE
96: arp_util.debug(' Line Record Changed');
97: x_return_status := fnd_api.g_ret_sts_error;
98: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
99: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
100: p_count => x_msg_count,
101: p_data => x_msg_data);

Line 99: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

95: ELSE
96: arp_util.debug(' Line Record Changed');
97: x_return_status := fnd_api.g_ret_sts_error;
98: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
99: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
100: p_count => x_msg_count,
101: p_data => x_msg_data);
102: END IF;
103: arp_util.debug('AR_INTEREST_BATCHES_PKG.Lock_line-');

Line 128: x_return_status := FND_API.G_RET_STS_ERROR;

124: FND_MESSAGE.SET_TOKEN( 'FK', 'interest_header_id' );
125: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_old_rec.interest_header_id);
126: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_headers' );
127: FND_MSG_PUB.ADD;
128: x_return_status := FND_API.G_RET_STS_ERROR;
129: END IF;
130: CLOSE c;
131:
132: IF p_action = 'UPDATE' THEN

Line 139: x_return_status := FND_API.G_RET_STS_ERROR;

135: arp_util.debug('Column process_status not updatable');
136: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
137: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_status');
138: FND_MSG_PUB.ADD;
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: END IF;
141: END IF;
142: END IF;
143:

Line 152: x_return_status := FND_API.G_RET_STS_ERROR;

148: arp_util.debug('Column process_status not updatable');
149: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
150: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_status');
151: FND_MSG_PUB.ADD;
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: END IF;
154: END IF;
155: END IF;
156: arp_util.debug('validate_line -');

Line 161: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

157: END;
158:
159:
160: PROCEDURE Update_line
161: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
162: P_INTEREST_LINE_ID IN NUMBER,
163: P_PROCESS_STATUS IN VARCHAR2,
164: P_PROCESS_MESSAGE IN VARCHAR2,
165: x_object_version_number IN OUT NOCOPY NUMBER,

Line 181: x_return_status := fnd_api.g_ret_sts_success;

177: BEGIN
178: arp_util.debug('AR_INTEREST_BATCHES_PKG.update_line +');
179: arp_util.debug(' p_interest_line_id :' ||P_INTEREST_LINE_ID);
180: SAVEPOINT Update_line;
181: x_return_status := fnd_api.g_ret_sts_success;
182:
183: IF fnd_api.to_boolean(p_init_msg_list) THEN
184: fnd_msg_pub.initialize;
185: END IF;

Line 183: IF fnd_api.to_boolean(p_init_msg_list) THEN

179: arp_util.debug(' p_interest_line_id :' ||P_INTEREST_LINE_ID);
180: SAVEPOINT Update_line;
181: x_return_status := fnd_api.g_ret_sts_success;
182:
183: IF fnd_api.to_boolean(p_init_msg_list) THEN
184: fnd_msg_pub.initialize;
185: END IF;
186:
187: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 187: x_return_status := fnd_api.G_RET_STS_SUCCESS;

183: IF fnd_api.to_boolean(p_init_msg_list) THEN
184: fnd_msg_pub.initialize;
185: END IF;
186:
187: x_return_status := fnd_api.G_RET_STS_SUCCESS;
188:
189: OPEN c;
190: FETCH c INTO l_rec;
191: CLOSE c;

Line 199: RAISE fnd_api.g_exc_error;

195: fnd_message.set_token('RECORD', 'ar_interest_lines');
196: fnd_message.set_token('VALUE',
197: NVL(TO_CHAR(P_INTEREST_line_ID), 'null'));
198: fnd_msg_pub.add;
199: RAISE fnd_api.g_exc_error;
200: END IF;
201:
202: IF NOT ((x_object_version_number IS NULL AND
203: l_rec.OBJECT_VERSION_NUMBER IS NULL) OR

Line 211: RAISE fnd_api.g_exc_error;

207: THEN
208: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
209: fnd_message.set_token('TABLE', 'ar_interest_lines');
210: fnd_msg_pub.add;
211: RAISE fnd_api.g_exc_error;
212: END IF;
213:
214: l_new_rec.process_status := p_process_status;
215: l_new_rec.process_message := p_process_message;

Line 223: IF x_return_status <> fnd_api.g_ret_sts_success THEN

219: p_old_rec => l_rec,
220: p_new_rec => l_new_rec,
221: x_return_status => x_return_status);
222:
223: IF x_return_status <> fnd_api.g_ret_sts_success THEN
224: RAISE fnd_api.g_exc_error;
225: END IF;
226:
227: x_object_version_number := NVL(x_object_version_number,1) + 1;

Line 224: RAISE fnd_api.g_exc_error;

220: p_new_rec => l_new_rec,
221: x_return_status => x_return_status);
222:
223: IF x_return_status <> fnd_api.g_ret_sts_success THEN
224: RAISE fnd_api.g_exc_error;
225: END IF;
226:
227: x_object_version_number := NVL(x_object_version_number,1) + 1;
228:

Line 242: WHEN fnd_api.g_exc_error THEN

238: WHERE interest_line_id = P_INTEREST_LINE_ID;
239:
240: arp_util.debug('AR_INTEREST_BATCHES_PKG.update_line -');
241: EXCEPTION
242: WHEN fnd_api.g_exc_error THEN
243: ROLLBACK TO SAVEPOINT Update_line;
244: x_return_status := fnd_api.g_ret_sts_error;
245: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
246: p_count => x_msg_count,

Line 244: x_return_status := fnd_api.g_ret_sts_error;

240: arp_util.debug('AR_INTEREST_BATCHES_PKG.update_line -');
241: EXCEPTION
242: WHEN fnd_api.g_exc_error THEN
243: ROLLBACK TO SAVEPOINT Update_line;
244: x_return_status := fnd_api.g_ret_sts_error;
245: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
246: p_count => x_msg_count,
247: p_data => x_msg_data);
248: arp_util.debug('EXCEPTION AR_INTEREST_BATCHES_PKG.update_line :'||x_msg_data);

Line 245: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

241: EXCEPTION
242: WHEN fnd_api.g_exc_error THEN
243: ROLLBACK TO SAVEPOINT Update_line;
244: x_return_status := fnd_api.g_ret_sts_error;
245: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
246: p_count => x_msg_count,
247: p_data => x_msg_data);
248: arp_util.debug('EXCEPTION AR_INTEREST_BATCHES_PKG.update_line :'||x_msg_data);
249: WHEN OTHERS THEN

Line 251: x_return_status := fnd_api.g_ret_sts_unexp_error;

247: p_data => x_msg_data);
248: arp_util.debug('EXCEPTION AR_INTEREST_BATCHES_PKG.update_line :'||x_msg_data);
249: WHEN OTHERS THEN
250: ROLLBACK TO SAVEPOINT Update_line;
251: x_return_status := fnd_api.g_ret_sts_unexp_error;
252: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
253: fnd_message.set_token('ERROR' ,SQLERRM);
254: fnd_msg_pub.add;
255: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 255: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

251: x_return_status := fnd_api.g_ret_sts_unexp_error;
252: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
253: fnd_message.set_token('ERROR' ,SQLERRM);
254: fnd_msg_pub.add;
255: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
256: p_count => x_msg_count,
257: p_data => x_msg_data);
258: arp_util.debug('EXCEPTION OTHERS AR_INTEREST_BATCHES_PKG.update_line :'||SQLERRM);
259: END Update_Line;

Line 264: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

260:
261:
262:
263: PROCEDURE Delete_line
264: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
265: p_interest_line_id IN NUMBER,
266: x_object_version_number IN NUMBER,
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,

Line 281: x_return_status := fnd_api.g_ret_sts_success;

277: l_new_rec ar_interest_lines%ROWTYPE;
278: BEGIN
279: arp_util.debug('AR_INTEREST_BATCHES_PKG.delete_line +');
280: SAVEPOINT Delete_line;
281: x_return_status := fnd_api.g_ret_sts_success;
282:
283: IF fnd_api.to_boolean(p_init_msg_list) THEN
284: fnd_msg_pub.initialize;
285: END IF;

Line 283: IF fnd_api.to_boolean(p_init_msg_list) THEN

279: arp_util.debug('AR_INTEREST_BATCHES_PKG.delete_line +');
280: SAVEPOINT Delete_line;
281: x_return_status := fnd_api.g_ret_sts_success;
282:
283: IF fnd_api.to_boolean(p_init_msg_list) THEN
284: fnd_msg_pub.initialize;
285: END IF;
286:
287: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 287: x_return_status := fnd_api.G_RET_STS_SUCCESS;

283: IF fnd_api.to_boolean(p_init_msg_list) THEN
284: fnd_msg_pub.initialize;
285: END IF;
286:
287: x_return_status := fnd_api.G_RET_STS_SUCCESS;
288:
289: OPEN c;
290: FETCH c INTO l_rec;
291: CLOSE c;

Line 299: RAISE fnd_api.g_exc_error;

295: fnd_message.set_token('RECORD', 'ar_interest_lines');
296: fnd_message.set_token('VALUE',
297: NVL(TO_CHAR(P_INTEREST_line_ID), 'null'));
298: fnd_msg_pub.add;
299: RAISE fnd_api.g_exc_error;
300: END IF;
301:
302: IF NOT ((x_object_version_number IS NULL AND
303: l_rec.OBJECT_VERSION_NUMBER IS NULL) OR

Line 311: RAISE fnd_api.g_exc_error;

307: THEN
308: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
309: fnd_message.set_token('TABLE', 'ar_interest_lines');
310: fnd_msg_pub.add;
311: RAISE fnd_api.g_exc_error;
312: END IF;
313:
314: validate_line
315: (p_action => 'DELETE',

Line 320: IF x_return_status <> fnd_api.g_ret_sts_success THEN

316: p_old_rec => l_rec,
317: p_new_rec => l_new_rec,
318: x_return_status => x_return_status);
319:
320: IF x_return_status <> fnd_api.g_ret_sts_success THEN
321: RAISE fnd_api.g_exc_error;
322: END IF;
323:
324: DELETE FROM AR_INTEREST_LINES

Line 321: RAISE fnd_api.g_exc_error;

317: p_new_rec => l_new_rec,
318: x_return_status => x_return_status);
319:
320: IF x_return_status <> fnd_api.g_ret_sts_success THEN
321: RAISE fnd_api.g_exc_error;
322: END IF;
323:
324: DELETE FROM AR_INTEREST_LINES
325: WHERE interest_line_id = p_interest_line_id;

Line 329: WHEN fnd_api.g_exc_error THEN

325: WHERE interest_line_id = p_interest_line_id;
326:
327: arp_util.debug('AR_INTEREST_BATCHES_PKG.delete_line -');
328: EXCEPTION
329: WHEN fnd_api.g_exc_error THEN
330: ROLLBACK TO SAVEPOINT Delete_line;
331: x_return_status := fnd_api.g_ret_sts_error;
332: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
333: p_count => x_msg_count,

Line 331: x_return_status := fnd_api.g_ret_sts_error;

327: arp_util.debug('AR_INTEREST_BATCHES_PKG.delete_line -');
328: EXCEPTION
329: WHEN fnd_api.g_exc_error THEN
330: ROLLBACK TO SAVEPOINT Delete_line;
331: x_return_status := fnd_api.g_ret_sts_error;
332: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
333: p_count => x_msg_count,
334: p_data => x_msg_data);
335: arp_util.debug('EXCEPTION AR_INTEREST_BATCHES_PKG.delete_line :'||x_msg_data);

Line 332: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

328: EXCEPTION
329: WHEN fnd_api.g_exc_error THEN
330: ROLLBACK TO SAVEPOINT Delete_line;
331: x_return_status := fnd_api.g_ret_sts_error;
332: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
333: p_count => x_msg_count,
334: p_data => x_msg_data);
335: arp_util.debug('EXCEPTION AR_INTEREST_BATCHES_PKG.delete_line :'||x_msg_data);
336: WHEN OTHERS THEN

Line 338: x_return_status := fnd_api.g_ret_sts_unexp_error;

334: p_data => x_msg_data);
335: arp_util.debug('EXCEPTION AR_INTEREST_BATCHES_PKG.delete_line :'||x_msg_data);
336: WHEN OTHERS THEN
337: ROLLBACK TO SAVEPOINT Delete_line;
338: x_return_status := fnd_api.g_ret_sts_unexp_error;
339: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
340: fnd_message.set_token('ERROR' ,SQLERRM);
341: fnd_msg_pub.add;
342: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 342: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

338: x_return_status := fnd_api.g_ret_sts_unexp_error;
339: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
340: fnd_message.set_token('ERROR' ,SQLERRM);
341: fnd_msg_pub.add;
342: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
343: p_count => x_msg_count,
344: p_data => x_msg_data);
345: arp_util.debug('EXCEPTION OTHERS AR_INTEREST_BATCHES_PKG.delete_line :'||SQLERRM);
346: