[Home] [Help]
722: Exception
723: WHEN OTHERS THEN
724: FND_FILE.PUT_LINE (FND_FILE.LOG, 'error in line history '||sqlerrm );
725: For i IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
726: insert into oks_rule_error( chr_id,
727: cle_id , attribute_name, attribute_value,
728: major_version, rule_information_category )
729: values (okchdr_id(i), okcline_id(i), 'CC_NO', c_cc_number(i),
730: oksline_major_version(i), 'R12CC');
1110: Exception
1111: WHEN OTHERS THEN
1112: FND_FILE.PUT_LINE (FND_FILE.LOG, 'error in insert lines '||sqlerrm );
1113: For i IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
1114: insert into oks_rule_error( chr_id,
1115: cle_id , attribute_name, attribute_value,
1116: major_version, rule_information_category )
1117: values (okchdr_id(i), okcline_id(i), 'CC_NO', c_cc_number(i),
1118: NULL, 'R12CC');
1506: Exception
1507: WHEN OTHERS THEN
1508: FND_FILE.PUT_LINE (FND_FILE.LOG, 'error in hdr history '||sqlerrm );
1509: For i IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
1510: insert into oks_rule_error( chr_id,
1511: cle_id , attribute_name, attribute_value,
1512: major_version, rule_information_category )
1513: values (okchdr_id(i), NULL, 'CC_NO', c_cc_number(i),
1514: oksline_major_version(i), 'R12CC');
1897: Exception
1898: WHEN OTHERS THEN
1899: FND_FILE.PUT_LINE (FND_FILE.LOG, 'error in insert hdr '||sqlerrm );
1900: For i IN 1 .. SQL%BULK_EXCEPTIONS.COUNT LOOP
1901: insert into oks_rule_error( chr_id,
1902: cle_id , attribute_name, attribute_value,
1903: major_version, rule_information_category )
1904: values (okchdr_id(i), NULL, 'CC_NO', c_cc_number(i),
1905: NULL, 'R12CC');
1972: FROM hz_parties a,
1973: hz_cust_accounts b
1974: WHERE a.party_id = b.party_id
1975: AND b.cust_account_id = cust_acct_id) party_name
1976: FROM oks_rule_error ore,
1977: oks_k_headers_b okh,
1978: okc_k_headers_all_b kh,
1979: okc_statuses_v st
1980: WHERE ore.RULE_INFORMATION_CATEGORY = 'R12CC'
1998: FROM hz_parties a,
1999: hz_cust_accounts b
2000: WHERE a.party_id = b.party_id
2001: AND b.cust_account_id = cust_acct_id) party_name
2002: FROM oks_rule_error ore,
2003: okc_k_headers_all_bh kh,
2004: okc_statuses_v st
2005: WHERE ore.RULE_INFORMATION_CATEGORY = 'R12CC'
2006: AND ore.chr_id = kh.ID
2034: AND T.LANGUAGE = userenv('LANG')
2035: AND B.INVENTORY_ITEM_ID = object1_id1
2036: AND ROWNUM < 2) service_name
2037:
2038: FROM oks_rule_error ore,
2039: okc_k_headers_all_b kh,
2040: okc_statuses_v st,
2041: oks_k_lines_b ls,
2042: okc_k_lines_b lc,
2077: AND T.LANGUAGE = userenv('LANG')
2078: AND B.INVENTORY_ITEM_ID = object1_id1
2079: AND ROWNUM < 2) service_name
2080:
2081: FROM oks_rule_error ore,
2082: okc_k_headers_all_b kh,
2083: okc_statuses_v st,
2084: okc_k_lines_bh lc,
2085: okc_k_items it
2649: AND okshdr.payment_type = 'CCR'
2650: AND okshdr.trxn_extension_id is not null)
2651: OR
2652: (okshdr.trxn_extension_id is null
2653: AND okshdr.chr_id in (select chr_id from oks_rule_error))
2654:
2655: )
2656: order by id) KHDR) WB GROUP BY Worker_Bucket) WBR;
2657:
2673: And rl.rule_information1 is not null
2674: And ((rg.chr_id = Kh.chr_id
2675: And Kh.trxn_extension_id is not null)
2676: Or
2677: (rg.chr_id in (select chr_id from oks_rule_error))
2678: )
2679: order by id) KHDR) WB GROUP BY Worker_Bucket) WBR;
2680:
2681: cursor l_line_ranges(l_bucket_size number) is
2695: AND oksline.payment_type = 'CCR'
2696: AND oksline.trxn_extension_id is not null)
2697: OR
2698: (oksline.trxn_extension_id is null
2699: AND oksline.cle_id in (select cle_id from oks_rule_error))
2700: )
2701: order by id) KLN) WB GROUP BY Worker_Bucket) WBR;
2702:
2703:
3034: And rl.rule_information1 is not null
3035: And ((rg.chr_id = Kh.chr_id
3036: And Kh.trxn_extension_id is not null)
3037: Or
3038: (rg.chr_id in (select chr_id from oks_rule_error))
3039: )
3040: And rl.id between p_id_low and p_id_high;
3041:
3042: l_hdr_id l_num_tbl;