DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on FND_FLEX_KEYVAL

Line 4719: IF (fnd_flex_keyval.validate_segs

4715: INTO l_chart_of_accounts_id
4716: FROM gl_sets_of_books
4717: WHERE set_of_books_id = p_set_of_books_id;
4718:
4719: IF (fnd_flex_keyval.validate_segs
4720: ('CREATE_COMB_NO_AT', --bugfix:3888581
4721: 'SQLGL',
4722: 'GL#',
4723: l_chart_of_accounts_id,

Line 4743: l_ccid := fnd_flex_keyval.combination_id;

4739: FALSE,
4740: NULL,
4741: NULL,
4742: NULL)) THEN
4743: l_ccid := fnd_flex_keyval.combination_id;
4744: ELSE
4745: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
4746: AP_IMPORT_UTILITIES_PKG.Print(
4747: AP_IMPORT_INVOICES_PKG.g_debug_switch,

Line 4916: IF fnd_flex_keyval.validate_ccid(

4912: l_current_invoice_status := 'N';
4913:
4914: END IF; -- Account type is other than L
4915:
4916: IF fnd_flex_keyval.validate_ccid(
4917: appl_short_name => 'SQLGL',
4918: key_flex_code => 'GL#',
4919: structure_number => l_chart_of_accounts_id,
4920: combination_id => p_invoice_rec.accts_pay_code_combination_id)

Line 4922: l_catsegs := fnd_flex_keyval.concatenated_values;

4918: key_flex_code => 'GL#',
4919: structure_number => l_chart_of_accounts_id,
4920: combination_id => p_invoice_rec.accts_pay_code_combination_id)
4921: THEN
4922: l_catsegs := fnd_flex_keyval.concatenated_values;
4923:
4924: --For BUG 3000219. CCID is to be validated with respect to
4925: --GL_DATE. Changed sysdate to p_invoice_rec.gl_date for validation
4926:

Line 4927: IF (fnd_flex_keyval.validate_segs

4923:
4924: --For BUG 3000219. CCID is to be validated with respect to
4925: --GL_DATE. Changed sysdate to p_invoice_rec.gl_date for validation
4926:
4927: IF (fnd_flex_keyval.validate_segs
4928: ('CREATE_COMB_NO_AT', --bugfix:3888581
4929: 'SQLGL',
4930: 'GL#',
4931: l_chart_of_accounts_id,

Line 15965: IF (fnd_flex_keyval.validate_segs(

15961: l_reason_unbuilt_flex := l_values(1).varchar2_3;
15962:
15963: ELSE -- IF l_key not found in cache .. cache it
15964: -- For BUG 3000219. Changed g_inv_sysdate to p_accounting_date
15965: IF (fnd_flex_keyval.validate_segs(
15966: 'CREATE_COMB_NO_AT' ,
15967: 'SQLGL',
15968: 'GL#',
15969: p_chart_of_accounts_id,

Line 15991: l_dist_code_combination_id := fnd_flex_keyval.combination_id;

15987: ELSE
15988: l_validate_res := 'TRUE';
15989: END IF;
15990:
15991: l_dist_code_combination_id := fnd_flex_keyval.combination_id;
15992: l_reason_unbuilt_flex := fnd_flex_keyval.error_message;
15993:
15994: l_valueOut.varchar2_1 := to_char(l_dist_code_combination_id);
15995: l_valueOut.varchar2_2 := l_validate_res;

Line 15992: l_reason_unbuilt_flex := fnd_flex_keyval.error_message;

15988: l_validate_res := 'TRUE';
15989: END IF;
15990:
15991: l_dist_code_combination_id := fnd_flex_keyval.combination_id;
15992: l_reason_unbuilt_flex := fnd_flex_keyval.error_message;
15993:
15994: l_valueOut.varchar2_1 := to_char(l_dist_code_combination_id);
15995: l_valueOut.varchar2_2 := l_validate_res;
15996: l_valueOut.varchar2_3 := l_reason_unbuilt_flex;

Line 16361: IF (fnd_flex_keyval.validate_segs

16357: -- Bug 5533471
16358: p_invoice_lines_rec.dist_code_combination_id := l_dist_code_combination_id;
16359:
16360: ELSE -- IF l_key not found in cache .. cache it
16361: IF (fnd_flex_keyval.validate_segs
16362: ('CREATE_COMB_NO_AT' , --Bug6624362
16363: 'SQLGL',
16364: 'GL#',
16365: p_chart_of_accounts_id,

Line 16384: l_dist_code_combination_id := fnd_flex_keyval.combination_id;

16380: l_validate_res := 'FALSE';
16381: ELSE --validate_segs
16382: l_validate_res := 'TRUE';
16383: END IF;
16384: l_dist_code_combination_id := fnd_flex_keyval.combination_id;
16385: l_valueOut.varchar2_1 := to_char(l_dist_code_combination_id);
16386: l_valueOut.varchar2_2 := l_validate_res;
16387: l_values(1) := l_valueOut;
16388: l_numof_values := 1;

Line 16413: FND_FLEX_KEYVAL.error_message);

16409: 'Invalid dist_code_concatenated ');
16410: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
16411: '(v_check_line_account_info 2) '||
16412: 'Error create account infomation : '||
16413: FND_FLEX_KEYVAL.error_message);
16414: END IF;
16415:
16416: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections(
16417: AP_IMPORT_INVOICES_PKG.g_invoice_lines_table,

Line 16624: IF fnd_flex_keyval.validate_ccid(

16620: END IF;
16621: IF (l_overlayed_ccid IS NULL OR l_overlayed_ccid = -1) THEN
16622: l_overlayed_ccid := l_dist_code_combination_id;
16623: END IF;
16624: IF fnd_flex_keyval.validate_ccid(
16625: appl_short_name => 'SQLGL',
16626: key_flex_code => 'GL#',
16627: structure_number => p_chart_of_accounts_id,
16628: combination_id => l_overlayed_ccid) THEN

Line 16629: l_catsegs := fnd_flex_keyval.concatenated_values;

16625: appl_short_name => 'SQLGL',
16626: key_flex_code => 'GL#',
16627: structure_number => p_chart_of_accounts_id,
16628: combination_id => l_overlayed_ccid) THEN
16629: l_catsegs := fnd_flex_keyval.concatenated_values;
16630:
16631: IF (fnd_flex_keyval.validate_segs(
16632: 'CHECK_COMBINATION',
16633: 'SQLGL',

Line 16631: IF (fnd_flex_keyval.validate_segs(

16627: structure_number => p_chart_of_accounts_id,
16628: combination_id => l_overlayed_ccid) THEN
16629: l_catsegs := fnd_flex_keyval.concatenated_values;
16630:
16631: IF (fnd_flex_keyval.validate_segs(
16632: 'CHECK_COMBINATION',
16633: 'SQLGL',
16634: 'GL#',
16635: p_chart_of_accounts_id,