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.OKL_QA_DATA_INTEGRITY dependencies on FND_DATE

Line 1199: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).start_date := Fnd_Date.canonical_to_date(l_payment_table(i).start_date);

1195: l_pmnt_tab_counter := l_pmnt_tab_counter + 1;
1196: l_payment_details_counter := 1;
1197: l_pmnt_tab(l_pmnt_tab_counter).kle_id := l_payment_table(i).kle_id;
1198:
1199: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).start_date := Fnd_Date.canonical_to_date(l_payment_table(i).start_date);
1200: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).number_of_periods := l_payment_table(i).number_of_periods;
1201: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).stub_days := l_payment_table(i).stub_days;
1202: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).stub_amount := l_payment_table(i).stub_amount;
1203: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).advance_or_arrears := l_payment_table(i).advance_or_arrears;

Line 1208: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).start_date := Fnd_Date.canonical_to_date(l_payment_table(i).start_date);

1204:
1205: l_prev_kle_id := l_payment_table(i).kle_id;
1206: l_payment_details_counter := l_payment_details_counter + 1;
1207: ELSE
1208: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).start_date := Fnd_Date.canonical_to_date(l_payment_table(i).start_date);
1209: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).number_of_periods := l_payment_table(i).number_of_periods;
1210: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).stub_days := l_payment_table(i).stub_days;
1211: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).stub_amount := l_payment_table(i).stub_amount;
1212: l_pmnt_tab(l_pmnt_tab_counter).l_payment_details(l_payment_details_counter).advance_or_arrears := l_payment_table(i).advance_or_arrears;

Line 1247: IF (Fnd_Date.canonical_to_date(l_start_date) <> Fnd_Date.canonical_to_date(l_pmnt_tab(i).l_payment_details(j).start_date)) OR

1243: l_stub_days := l_pmnt_tab(1).l_payment_details(j).stub_days;
1244: l_advance_or_arrears := l_pmnt_tab(1).l_payment_details(j).advance_or_arrears;
1245: FOR i IN 2..l_pmnt_tab.LAST
1246: LOOP
1247: IF (Fnd_Date.canonical_to_date(l_start_date) <> Fnd_Date.canonical_to_date(l_pmnt_tab(i).l_payment_details(j).start_date)) OR
1248: (NVL(l_number_of_periods,0) <> NVL(l_pmnt_tab(i).l_payment_details(j).number_of_periods,0)) OR
1249: (NVL(l_stub_days,0) <> NVL(l_pmnt_tab(i).l_payment_details(j).stub_days,0)) OR
1250: (NVL(l_advance_or_arrears,'N') <> NVL(l_pmnt_tab(i).l_payment_details(j).advance_or_arrears,'N')) THEN
1251:

Line 1702: l_rent_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

1698: END IF;
1699: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1700: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before assigning l_rent_start_date....');
1701: END IF;
1702: l_rent_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1703: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1704: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rent_start_date=' || l_rent_start_date);
1705: END IF;
1706: l_rent_periods := l_pmnt_lns_in_hdr_rec.rule_information3;

Line 1726: l_principal_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

1722: l_prin_payment_in_advance := TRUE;
1723: --Added by bkatraga for bug 14111538
1724: l_stream_type_name := l_pmnt_strm_hdr_rec.name;
1725: END IF;
1726: l_principal_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1727: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1728: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_principal_start_date=' || l_principal_start_date);
1729: END IF;
1730: l_principal_periods := l_pmnt_lns_in_hdr_rec.rule_information3;

Line 1735: l_loan_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

1731: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1732: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_principal_periods=' || l_principal_periods);
1733: END IF;
1734: ELSIF ( l_pmnt_strm_hdr_rec.stream_type_purpose = 'LOAN_PAYMENT' ) THEN
1735: l_loan_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1736: l_loan_periods := l_hdrrl_rec.rule_information3;
1737: ELSIF ( l_pmnt_strm_hdr_rec.stream_type_purpose = 'VARIABLE_INTEREST_SCHEDULE' ) THEN
1738: l_var_int_schedule_defined := TRUE;
1739: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1745: l_variable_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

1741: END IF;
1742:
1743: --Added IF clause by bkatraga for bug 13478101
1744: IF(l_variable_start_date IS NULL) THEN
1745: l_variable_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1746: END IF;
1747:
1748: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1749: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_variable_start_date = ' || l_variable_start_date);

Line 1760: l_pymnt_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

1756: l_stream_type_name := l_pmnt_strm_hdr_rec.name;
1757: END IF;
1758:
1759: --Added by bkatraga for bug 13478101
1760: l_pymnt_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1761: IF(l_start_day IS NULL OR
1762: (l_var_stub_days IS NOT NULL AND l_var_stub_days <> OKL_API.G_MISS_CHAR)) THEN
1763: l_start_day := TO_CHAR(l_pymnt_start_date,'DD');
1764: END IF;

Line 2074: l_payment_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

2070: l_line_ind := 0;
2071: FOR l_pmnt_lns_in_hdr_rec IN l_pmnt_lns_in_hdr(l_pmnt_strm_check_rec.id ,p_chr_id)
2072: Loop
2073: If ( l_line_ind = 0 ) Then
2074: l_payment_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2075: print('l_payment_date=' || l_payment_date);
2076: l_line_ind := 1;
2077: ELSE
2078: l_payment_date2 := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

Line 2078: l_payment_date2 := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

2074: l_payment_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2075: print('l_payment_date=' || l_payment_date);
2076: l_line_ind := 1;
2077: ELSE
2078: l_payment_date2 := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2079: print('l_payment_date2=' || l_payment_date2);
2080: IF (l_payment_date <> l_payment_date2) THEN
2081: OKL_API.set_message(
2082: p_app_name => G_APP_NAME,

Line 2127: l_global_min_start_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

2123: If ( ind = 0 ) Then
2124: ind := 1;
2125: l_pmnt_lns_in_hdr_rec_comp := l_pmnt_lns_in_hdr_rec;
2126: -- global min start date is start date for first payment line for that SLH
2127: l_global_min_start_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2128: print('l_global_min_start_date=' || l_global_min_start_date);
2129: End If;
2130: If (line_ind = 0) Then
2131: l_min_start_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

Line 2131: l_min_start_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

2127: l_global_min_start_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2128: print('l_global_min_start_date=' || l_global_min_start_date);
2129: End If;
2130: If (line_ind = 0) Then
2131: l_min_start_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2132: print('l_min_start_date=' || l_min_start_date);
2133: line_ind := 1;
2134: l_line_total_periods := l_pmnt_lns_in_hdr_rec.rule_information3;
2135: Else

Line 2243: l_payment_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

2239: /*
2240: IF (l_deal_type = 'LOAN' AND
2241: l_interest_calculation_basis = 'REAMORT') THEN
2242: If ( l_line_ind = 0 ) Then
2243: l_payment_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2244: l_line_ind := 1;
2245: ELSE
2246: l_payment_date2 := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2247: IF (l_payment_date <> l_payment_date2) THEN

Line 2246: l_payment_date2 := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

2242: If ( l_line_ind = 0 ) Then
2243: l_payment_date := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2244: l_line_ind := 1;
2245: ELSE
2246: l_payment_date2 := FND_DATE.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2247: IF (l_payment_date <> l_payment_date2) THEN
2248: OKL_API.set_message(
2249: p_app_name => G_APP_NAME,
2250: p_msg_name => 'OKL_LLA_VAR_RATE_PAYMENT_DATE',

Line 2965: l_global_min_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

2961: IF ( ind = 0 ) THEN
2962: ind := 1;
2963: l_pmnt_lns_in_hdr_rec_comp := l_pmnt_lns_in_hdr_rec;
2964: -- global min start date is start date for first payment line for that SLH
2965: l_global_min_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2966: END IF;
2967: IF (line_ind = 0) THEN
2968: l_min_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2969: line_ind := 1;

Line 2968: l_min_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);

2964: -- global min start date is start date for first payment line for that SLH
2965: l_global_min_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2966: END IF;
2967: IF (line_ind = 0) THEN
2968: l_min_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
2969: line_ind := 1;
2970: l_line_total_periods := l_pmnt_lns_in_hdr_rec.rule_information3;
2971: ELSE
2972: l_line_total_periods := l_line_total_periods + l_pmnt_lns_in_hdr_rec.rule_information3;

Line 3084: > TRUNC(Fnd_Date.canonical_to_date(l_hdrrl_rec.rule_information4)) )

3080: FETCH l_hdr_csr1 INTO l_hdr_rec1;
3081: CLOSE l_hdr_csr1;
3082:
3083: IF ( TRUNC(l_hdr_rec1.start_date)
3084: > TRUNC(Fnd_Date.canonical_to_date(l_hdrrl_rec.rule_information4)) )
3085: OR
3086: ( TRUNC(l_hdr_rec1.end_date)
3087: < TRUNC(Fnd_Date.canonical_to_date(l_hdrrl_rec.rule_information4)) ) THEN
3088: Okl_Api.set_message(

Line 3087: < TRUNC(Fnd_Date.canonical_to_date(l_hdrrl_rec.rule_information4)) ) THEN

3083: IF ( TRUNC(l_hdr_rec1.start_date)
3084: > TRUNC(Fnd_Date.canonical_to_date(l_hdrrl_rec.rule_information4)) )
3085: OR
3086: ( TRUNC(l_hdr_rec1.end_date)
3087: < TRUNC(Fnd_Date.canonical_to_date(l_hdrrl_rec.rule_information4)) ) THEN
3088: Okl_Api.set_message(
3089: p_app_name => G_APP_NAME,
3090: p_msg_name => 'OKL_QA_INT_START_DATE_EFF');
3091: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 3094: /*If ( l_hdr_rec.start_date < FND_DATE.canonical_to_date(l_hdrrl_rec.rule_information4) ) Then

3090: p_msg_name => 'OKL_QA_INT_START_DATE_EFF');
3091: x_return_status := Okl_Api.G_RET_STS_ERROR;
3092: END IF;
3093:
3094: /*If ( l_hdr_rec.start_date < FND_DATE.canonical_to_date(l_hdrrl_rec.rule_information4) ) Then
3095: OKL_API.set_message(
3096: p_app_name => G_APP_NAME,
3097: p_msg_name => 'OKL_QA_CLCDATE');
3098: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 3367: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,

3363: AND pph.cle_id = p_cle_id;
3364:
3365: --Find out the payment info for contract line
3366: CURSOR pymnt_amt_csr (p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
3367: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,
3368: DECODE(sll.rule_information7, NULL,
3369: (ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
3370: NVL(TO_NUMBER(sll.rule_information3),1) *
3371: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),

Line 3369: (ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),

3365: --Find out the payment info for contract line
3366: CURSOR pymnt_amt_csr (p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
3367: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,
3368: DECODE(sll.rule_information7, NULL,
3369: (ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
3370: NVL(TO_NUMBER(sll.rule_information3),1) *
3371: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),
3372: Fnd_Date.canonical_to_date(sll.rule_information2) +
3373: TO_NUMBER(sll.rule_information7) - 1) end_date,

Line 3372: Fnd_Date.canonical_to_date(sll.rule_information2) +

3368: DECODE(sll.rule_information7, NULL,
3369: (ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
3370: NVL(TO_NUMBER(sll.rule_information3),1) *
3371: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),
3372: Fnd_Date.canonical_to_date(sll.rule_information2) +
3373: TO_NUMBER(sll.rule_information7) - 1) end_date,
3374: TO_NUMBER(sll.rule_information6) amount
3375: FROM okc_rules_b sll,
3376: okc_rules_b slh,

Line 5175: --ORDER BY fnd_date.canonical_to_date(sll.rule_information2);

5171: --AND styt.LANGUAGE = USERENV('LANG')
5172: --AND sty.id = styt.id
5173: AND TO_CHAR(slh.id) = sll.object2_id1
5174: AND sll.rule_information_category = 'LASLL';
5175: --ORDER BY fnd_date.canonical_to_date(sll.rule_information2);
5176:
5177: /*
5178: CURSOR c_strm_sll_ext (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
5179: p_kle_id OKC_K_LINES_B.ID%TYPE) IS

Line 5337: l_strm_sll_start_date := Fnd_Date.canonical_to_date(l_strm_sll.start_date);

5333: FOR l_strm_sll IN c_strm_sll(p_chr_id,
5334: l_fin_fee.id)
5335: LOOP
5336:
5337: l_strm_sll_start_date := Fnd_Date.canonical_to_date(l_strm_sll.start_date);
5338: l_strm_sll_periods := TO_NUMBER(l_strm_sll.periods);
5339:
5340: IF(l_strm_sll_start_date IS NULL) THEN
5341:

Line 5426: l_pmnt_end_date := Fnd_Date.canonical_to_date(l_strm_sll_ext.start_date);

5422: l_strm_sll_ext_mpp := l_strm_sll_ext.mpp;
5423: l_strm_sll_ext_stub_day := TO_NUMBER(NVL(l_strm_sll_ext.stub_day,0)) + l_strm_sll_ext_stub_day;
5424: */
5425: -- 5189866
5426: l_pmnt_end_date := Fnd_Date.canonical_to_date(l_strm_sll_ext.start_date);
5427: IF l_sll_count > 1 THEN
5428: l_start_day := TO_CHAR(l_pmnt_end_date,'DD');
5429: END IF;
5430:

Line 6218: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),

6214:
6215: SELECT sll.rule_information2 start_date,
6216: SLL.rule_information3 periods,
6217: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
6218: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
6219: TO_NUMBER(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)) - 1) end_date,
6220: styt.name stream_type
6221: FROM okc_rules_b sll,
6222: okc_rules_b slh,

Line 6658: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date, -- formated for bug 5115701,

6654:
6655: CURSOR l_fn_fee_pmt_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE,
6656: feeLine IN OKL_K_LINES.ID%TYPE) IS
6657:
6658: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date, -- formated for bug 5115701,
6659: SLL.rule_information3 periods,
6660: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
6661: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
6662: TO_NUMBER(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)) - 1) end_date,

Line 6661: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),

6657:
6658: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date, -- formated for bug 5115701,
6659: SLL.rule_information3 periods,
6660: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
6661: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
6662: TO_NUMBER(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)) - 1) end_date,
6663: styt.name stream_type
6664: FROM okc_rules_b sll,
6665: okc_rules_b slh,

Line 9854: ( TRUNC(Fnd_Date.canonical_to_date(l_hdrrl_rec.RULE_INFORMATION1)) < TRUNC(l_hdr.START_DATE) )) THEN

9850: FETCH l_hdrrl_csr INTO l_hdrrl_rec;
9851:
9852: IF(( l_hdrrl_csr%FOUND ) AND
9853: (l_hdrrl_rec.RULE_INFORMATION1 IS NOT NULL) AND
9854: ( TRUNC(Fnd_Date.canonical_to_date(l_hdrrl_rec.RULE_INFORMATION1)) < TRUNC(l_hdr.START_DATE) )) THEN
9855: Okl_Api.set_message(
9856: p_app_name => G_APP_NAME,
9857: p_msg_name => 'OKL_QA_LATE_CH_DATE');
9858: -- notify caller of an error

Line 9869: (TRUNC( Fnd_Date.canonical_to_date(l_hdrrl_rec.RULE_INFORMATION1)) < TRUNC(l_hdr.START_DATE) )) THEN

9865: FETCH l_hdrrl_csr INTO l_hdrrl_rec;
9866:
9867: IF(( l_hdrrl_csr%FOUND ) AND
9868: (l_hdrrl_rec.RULE_INFORMATION1 IS NOT NULL) AND
9869: (TRUNC( Fnd_Date.canonical_to_date(l_hdrrl_rec.RULE_INFORMATION1)) < TRUNC(l_hdr.START_DATE) )) THEN
9870: Okl_Api.set_message(
9871: p_app_name => G_APP_NAME,
9872: p_msg_name => 'OKL_QA_LATE_INT_DATE');
9873: -- notify caller of an error

Line 9883: (TRUNC( Fnd_Date.canonical_to_date(l_hdrrl_rec.RULE_INFORMATION1)) < TRUNC(l_hdr.START_DATE))) THEN

9879: FETCH l_hdrrl_csr INTO l_hdrrl_rec;
9880:
9881: IF((l_hdrrl_csr%FOUND)AND
9882: (l_hdrrl_rec.RULE_INFORMATION1 IS NOT NULL) AND
9883: (TRUNC( Fnd_Date.canonical_to_date(l_hdrrl_rec.RULE_INFORMATION1)) < TRUNC(l_hdr.START_DATE))) THEN
9884: Okl_Api.set_message(
9885: p_app_name => G_APP_NAME,
9886: p_msg_name => 'OKL_QA_REBOOK_LMT_DATE');
9887: -- notify caller of an error

Line 11324: (TRUNC( Fnd_Date.canonical_to_date(l_rl_rec.rule_information2)) < TRUNC(l_lne_pmnt.start_date)))THEN

11320:
11321: FOR l_rl_rec IN l_rl_csr (l_rl_rec1.slh_id, 'LALEVL', 'LASLL', TO_NUMBER(p_chr_id), l_lne_pmnt.id )
11322: LOOP
11323: IF(( l_rl_rec.rule_information2 IS NOT NULL) AND
11324: (TRUNC( Fnd_Date.canonical_to_date(l_rl_rec.rule_information2)) < TRUNC(l_lne_pmnt.start_date)))THEN
11325:
11326: Okl_Api.set_message(
11327: p_app_name => G_APP_NAME,
11328: p_msg_name => 'OKL_QA_PMNT_LN_START_DT',

Line 11344: (TRUNC( Fnd_Date.canonical_to_date(l_rl_rec1.rule_information2)) < TRUNC(l_lne_pmnt.start_date)))THEN

11340: LOOP
11341: FOR l_rl_rec1 IN l_rl_csr1 ( 'LALEVL', 'LASLL', TO_NUMBER(p_chr_id), l_lne_pmnt.id )
11342: LOOP
11343: IF(( l_rl_rec1.rule_information2 IS NOT NULL) AND
11344: (TRUNC( Fnd_Date.canonical_to_date(l_rl_rec1.rule_information2)) < TRUNC(l_lne_pmnt.start_date)))THEN
11345: --( FND_DATE.canonical_to_date(l_rl_rec1.rule_information2) < l_hdr_rec.start_date))Then
11346:
11347: OPEN fee_strm_type_csr ( l_lne_pmnt.id, 'FEE' );
11348: FETCH fee_strm_type_csr INTO l_fee_strm_type_rec;

Line 11345: --( FND_DATE.canonical_to_date(l_rl_rec1.rule_information2) < l_hdr_rec.start_date))Then

11341: FOR l_rl_rec1 IN l_rl_csr1 ( 'LALEVL', 'LASLL', TO_NUMBER(p_chr_id), l_lne_pmnt.id )
11342: LOOP
11343: IF(( l_rl_rec1.rule_information2 IS NOT NULL) AND
11344: (TRUNC( Fnd_Date.canonical_to_date(l_rl_rec1.rule_information2)) < TRUNC(l_lne_pmnt.start_date)))THEN
11345: --( FND_DATE.canonical_to_date(l_rl_rec1.rule_information2) < l_hdr_rec.start_date))Then
11346:
11347: OPEN fee_strm_type_csr ( l_lne_pmnt.id, 'FEE' );
11348: FETCH fee_strm_type_csr INTO l_fee_strm_type_rec;
11349: CLOSE fee_strm_type_csr;

Line 11367: ( TRUNC(Fnd_Date.canonical_to_date(l_rl_rec1.rule_information2)) < TRUNC(l_lne_pmnt.start_date)))THEN

11363: LOOP
11364: FOR l_rl_rec1 IN l_rl_csr1 ( 'LALEVL', 'LASLL', TO_NUMBER(p_chr_id), l_lne_pmnt.id )
11365: LOOP
11366: IF(( l_rl_rec1.rule_information2 IS NOT NULL) AND
11367: ( TRUNC(Fnd_Date.canonical_to_date(l_rl_rec1.rule_information2)) < TRUNC(l_lne_pmnt.start_date)))THEN
11368: Okl_Api.set_message(
11369: p_app_name => G_APP_NAME,
11370: p_msg_name => 'OKL_QA_PMNT_LN_START_DT',
11371: p_token1 => 'line',

Line 11381: ( TRUNC(Fnd_Date.canonical_to_date(l_rl_rec1.rule_information2)) < TRUNC(l_hdr_rec.start_date)))THEN

11377:
11378: FOR l_rl_rec1 IN l_rl_csr1 ( 'LALEVL', 'LASLL', TO_NUMBER(p_chr_id), -1 )
11379: LOOP
11380: IF(( l_rl_rec1.rule_information2 IS NOT NULL) AND
11381: ( TRUNC(Fnd_Date.canonical_to_date(l_rl_rec1.rule_information2)) < TRUNC(l_hdr_rec.start_date)))THEN
11382: Okl_Api.set_message(
11383: p_app_name => G_APP_NAME,
11384: p_msg_name => 'OKL_QA_PMNT_START_DT');
11385: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 12272: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,

12268: AND sty.id = styt.id;
12269:
12270: CURSOR l_strm_sll_csr (p_rule_id OKC_RULES_B.ID%TYPE,
12271: p_rgp_id OKC_RULE_GROUPS_B.ID%TYPE) IS
12272: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,
12273: sll.rule_information1 seq,
12274: sll.rule_information6 amt,
12275: sll.rule_information7 stub_day,
12276: sll.rule_information13 rate

Line 12666: (TRUNC( FND_DATE.canonical_to_date(l_hdrrl_rec.RULE_INFORMATION1)) < TRUNC(l_hdr.START_DATE) )) Then

12662: FETCH l_hdrrl_csr into l_hdrrl_rec;
12663:
12664: If(( l_hdrrl_csr%FOUND ) AND
12665: (l_hdrrl_rec.RULE_INFORMATION1 IS NOT NULL) AND
12666: (TRUNC( FND_DATE.canonical_to_date(l_hdrrl_rec.RULE_INFORMATION1)) < TRUNC(l_hdr.START_DATE) )) Then
12667: OKL_API.set_message(
12668: p_app_name => G_APP_NAME,
12669: p_msg_name => 'OKL_QA_LATE_INT_DATE');
12670: -- notify caller of an error

Line 12733: ( TRUNC(FND_DATE.canonical_to_date(l_hdrrl_rec.RULE_INFORMATION1)) < TRUNC(l_hdr.START_DATE) )) Then

12729: FETCH l_hdrrl_csr into l_hdrrl_rec;
12730:
12731: If(( l_hdrrl_csr%FOUND ) AND
12732: (l_hdrrl_rec.RULE_INFORMATION1 IS NOT NULL) AND
12733: ( TRUNC(FND_DATE.canonical_to_date(l_hdrrl_rec.RULE_INFORMATION1)) < TRUNC(l_hdr.START_DATE) )) Then
12734: OKL_API.set_message(
12735: p_app_name => G_APP_NAME,
12736: p_msg_name => 'OKL_QA_LATE_CH_DATE');
12737: -- notify caller of an error