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 183: x_return_status := fnd_api.g_ret_sts_success;

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

Line 185: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

Line 189: x_return_status := fnd_api.G_RET_STS_SUCCESS;

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

Line 201: RAISE fnd_api.g_exc_error;

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

Line 213: RAISE fnd_api.g_exc_error;

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

Line 225: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 226: RAISE fnd_api.g_exc_error;

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

Line 246: WHEN fnd_api.g_exc_error THEN

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

Line 248: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 255: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

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

264:
265:
266:
267: PROCEDURE Delete_line
268: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
269: p_interest_line_id IN NUMBER,
270: x_object_version_number IN NUMBER,
271: x_return_status OUT NOCOPY VARCHAR2,
272: x_msg_count OUT NOCOPY NUMBER,

Line 285: x_return_status := fnd_api.g_ret_sts_success;

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

Line 287: IF fnd_api.to_boolean(p_init_msg_list) THEN

283: arp_util.debug('AR_INTEREST_BATCHES_PKG.delete_line +');
284: SAVEPOINT Delete_line;
285: x_return_status := fnd_api.g_ret_sts_success;
286:
287: IF fnd_api.to_boolean(p_init_msg_list) THEN
288: fnd_msg_pub.initialize;
289: END IF;
290:
291: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 291: x_return_status := fnd_api.G_RET_STS_SUCCESS;

287: IF fnd_api.to_boolean(p_init_msg_list) THEN
288: fnd_msg_pub.initialize;
289: END IF;
290:
291: x_return_status := fnd_api.G_RET_STS_SUCCESS;
292:
293: OPEN c;
294: FETCH c INTO l_rec;
295: CLOSE c;

Line 303: RAISE fnd_api.g_exc_error;

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

Line 315: RAISE fnd_api.g_exc_error;

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

Line 324: IF x_return_status <> fnd_api.g_ret_sts_success THEN

320: p_old_rec => l_rec,
321: p_new_rec => l_new_rec,
322: x_return_status => x_return_status);
323:
324: IF x_return_status <> fnd_api.g_ret_sts_success THEN
325: RAISE fnd_api.g_exc_error;
326: END IF;
327:
328: DELETE FROM AR_INTEREST_LINES

Line 325: RAISE fnd_api.g_exc_error;

321: p_new_rec => l_new_rec,
322: x_return_status => x_return_status);
323:
324: IF x_return_status <> fnd_api.g_ret_sts_success THEN
325: RAISE fnd_api.g_exc_error;
326: END IF;
327:
328: DELETE FROM AR_INTEREST_LINES
329: WHERE interest_line_id = p_interest_line_id;

Line 333: WHEN fnd_api.g_exc_error THEN

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

Line 335: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 342: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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