DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on FND_FLEX_KEYVAL

Line 5050: IF (fnd_flex_keyval.validate_segs

5046: INTO l_chart_of_accounts_id
5047: FROM gl_sets_of_books
5048: WHERE set_of_books_id = p_set_of_books_id;
5049:
5050: IF (fnd_flex_keyval.validate_segs
5051: ('CREATE_COMB_NO_AT', --bugfix:3888581
5052: 'SQLGL',
5053: 'GL#',
5054: l_chart_of_accounts_id,

Line 5074: l_ccid := fnd_flex_keyval.combination_id;

5070: FALSE,
5071: NULL,
5072: NULL,
5073: NULL)) THEN
5074: l_ccid := fnd_flex_keyval.combination_id;
5075: ELSE
5076: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
5077: AP_IMPORT_UTILITIES_PKG.Print(
5078: AP_IMPORT_INVOICES_PKG.g_debug_switch,

Line 5247: IF fnd_flex_keyval.validate_ccid(

5243: l_current_invoice_status := 'N';
5244:
5245: END IF; -- Account type is other than L
5246:
5247: IF fnd_flex_keyval.validate_ccid(
5248: appl_short_name => 'SQLGL',
5249: key_flex_code => 'GL#',
5250: structure_number => l_chart_of_accounts_id,
5251: combination_id => p_invoice_rec.accts_pay_code_combination_id)

Line 5253: l_catsegs := fnd_flex_keyval.concatenated_values;

5249: key_flex_code => 'GL#',
5250: structure_number => l_chart_of_accounts_id,
5251: combination_id => p_invoice_rec.accts_pay_code_combination_id)
5252: THEN
5253: l_catsegs := fnd_flex_keyval.concatenated_values;
5254:
5255: --For BUG 3000219. CCID is to be validated with respect to
5256: --GL_DATE. Changed sysdate to p_invoice_rec.gl_date for validation
5257:

Line 5258: IF (fnd_flex_keyval.validate_segs

5254:
5255: --For BUG 3000219. CCID is to be validated with respect to
5256: --GL_DATE. Changed sysdate to p_invoice_rec.gl_date for validation
5257:
5258: IF (fnd_flex_keyval.validate_segs
5259: ('CREATE_COMB_NO_AT', --bugfix:3888581
5260: 'SQLGL',
5261: 'GL#',
5262: l_chart_of_accounts_id,

Line 17407: IF (fnd_flex_keyval.validate_segs(

17403: l_reason_unbuilt_flex := l_values(1).varchar2_3;
17404:
17405: ELSE -- IF l_key not found in cache .. cache it
17406: -- For BUG 3000219. Changed g_inv_sysdate to p_accounting_date
17407: IF (fnd_flex_keyval.validate_segs(
17408: 'CREATE_COMB_NO_AT' ,
17409: 'SQLGL',
17410: 'GL#',
17411: p_chart_of_accounts_id,

Line 17433: l_dist_code_combination_id := fnd_flex_keyval.combination_id;

17429: ELSE
17430: l_validate_res := 'TRUE';
17431: END IF;
17432:
17433: l_dist_code_combination_id := fnd_flex_keyval.combination_id;
17434: l_reason_unbuilt_flex := fnd_flex_keyval.error_message;
17435:
17436: l_valueOut.varchar2_1 := to_char(l_dist_code_combination_id);
17437: l_valueOut.varchar2_2 := l_validate_res;

Line 17434: l_reason_unbuilt_flex := fnd_flex_keyval.error_message;

17430: l_validate_res := 'TRUE';
17431: END IF;
17432:
17433: l_dist_code_combination_id := fnd_flex_keyval.combination_id;
17434: l_reason_unbuilt_flex := fnd_flex_keyval.error_message;
17435:
17436: l_valueOut.varchar2_1 := to_char(l_dist_code_combination_id);
17437: l_valueOut.varchar2_2 := l_validate_res;
17438: l_valueOut.varchar2_3 := l_reason_unbuilt_flex;

Line 17685: IF fnd_flex_keyval.validate_ccid(

17681: END IF;
17682:
17683:
17684: -- Validate distribution code combination id information
17685: IF fnd_flex_keyval.validate_ccid(
17686: appl_short_name => 'SQLGL',
17687: key_flex_code => 'GL#',
17688: structure_number => p_chart_of_accounts_id,
17689: combination_id => l_dist_code_combination_id) THEN

Line 17690: l_catsegs := fnd_flex_keyval.concatenated_values;

17686: appl_short_name => 'SQLGL',
17687: key_flex_code => 'GL#',
17688: structure_number => p_chart_of_accounts_id,
17689: combination_id => l_dist_code_combination_id) THEN
17690: l_catsegs := fnd_flex_keyval.concatenated_values;
17691:
17692: IF (fnd_flex_keyval.validate_segs(
17693: 'CHECK_COMBINATION',
17694: 'SQLGL',

Line 17692: IF (fnd_flex_keyval.validate_segs(

17688: structure_number => p_chart_of_accounts_id,
17689: combination_id => l_dist_code_combination_id) THEN
17690: l_catsegs := fnd_flex_keyval.concatenated_values;
17691:
17692: IF (fnd_flex_keyval.validate_segs(
17693: 'CHECK_COMBINATION',
17694: 'SQLGL',
17695: 'GL#',
17696: p_chart_of_accounts_id,

Line 17946: IF (fnd_flex_keyval.validate_segs

17942: -- Bug 5533471
17943: p_invoice_lines_rec.dist_code_combination_id := l_dist_code_combination_id;
17944:
17945: ELSE -- IF l_key not found in cache .. cache it
17946: IF (fnd_flex_keyval.validate_segs
17947: ('CREATE_COMB_NO_AT' , --Bug6624362
17948: 'SQLGL',
17949: 'GL#',
17950: p_chart_of_accounts_id,

Line 17969: l_dist_code_combination_id := fnd_flex_keyval.combination_id;

17965: l_validate_res := 'FALSE';
17966: ELSE --validate_segs
17967: l_validate_res := 'TRUE';
17968: END IF;
17969: l_dist_code_combination_id := fnd_flex_keyval.combination_id;
17970: p_invoice_lines_rec.dist_code_combination_id := l_dist_code_combination_id; --bug 12987030
17971: l_valueOut.varchar2_1 := to_char(l_dist_code_combination_id);
17972: l_valueOut.varchar2_2 := l_validate_res;
17973: l_values(1) := l_valueOut;

Line 17999: FND_FLEX_KEYVAL.error_message);

17995: 'Invalid dist_code_concatenated ');
17996: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
17997: '(v_check_line_account_info 2) '||
17998: 'Error create account infomation : '||
17999: FND_FLEX_KEYVAL.error_message);
18000: END IF;
18001:
18002: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections(
18003: AP_IMPORT_INVOICES_PKG.g_invoice_lines_table,

Line 18215: IF fnd_flex_keyval.validate_ccid(

18211: END IF;
18212: IF (l_overlayed_ccid IS NULL OR l_overlayed_ccid = -1) THEN
18213: l_overlayed_ccid := l_dist_code_combination_id;
18214: END IF;
18215: IF fnd_flex_keyval.validate_ccid(
18216: appl_short_name => 'SQLGL',
18217: key_flex_code => 'GL#',
18218: structure_number => p_chart_of_accounts_id,
18219: combination_id => l_overlayed_ccid) THEN

Line 18220: l_catsegs := fnd_flex_keyval.concatenated_values;

18216: appl_short_name => 'SQLGL',
18217: key_flex_code => 'GL#',
18218: structure_number => p_chart_of_accounts_id,
18219: combination_id => l_overlayed_ccid) THEN
18220: l_catsegs := fnd_flex_keyval.concatenated_values;
18221:
18222: IF (fnd_flex_keyval.validate_segs(
18223: 'CHECK_COMBINATION',
18224: 'SQLGL',

Line 18222: IF (fnd_flex_keyval.validate_segs(

18218: structure_number => p_chart_of_accounts_id,
18219: combination_id => l_overlayed_ccid) THEN
18220: l_catsegs := fnd_flex_keyval.concatenated_values;
18221:
18222: IF (fnd_flex_keyval.validate_segs(
18223: 'CHECK_COMBINATION',
18224: 'SQLGL',
18225: 'GL#',
18226: p_chart_of_accounts_id,