DBA Data[Home] [Help]

APPS.AP_PMT_CALLOUT_PKG dependencies on FND_SEQNUM

Line 194: l_return_code := FND_SEQNUM.GET_SEQ_VAL(

190: loop
191: fetch c_interest_invoices INTO l_invoice_id;
192: exit when c_interest_invoices%notfound;
193:
194: l_return_code := FND_SEQNUM.GET_SEQ_VAL(
195: 200,
196: 'INT INV',
197: p_set_of_books_id,
198: 'A',

Line 342: l_debug_info := 'calling fnd_seqnum.get_seq_info ';

338:
339:
340: if l_doc_category_code <> '-1' then
341:
342: l_debug_info := 'calling fnd_seqnum.get_seq_info ';
343: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
344: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
345: END IF;
346:

Line 354: l_return_code := fnd_seqnum.get_seq_info(

350: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
351: END IF;
352:
353:
354: l_return_code := fnd_seqnum.get_seq_info(
355: app_id => 200,
356: cat_code => l_doc_category_code,
357: sob_id => p_set_of_books_id,
358: met_code => 'A',

Line 393: l_debug_info := 'Return Code from fnd_seqnum.get_seq_info: '||l_return_code;

389: RETURN;
390: END IF;
391: END IF;
392:
393: l_debug_info := 'Return Code from fnd_seqnum.get_seq_info: '||l_return_code;
394: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
395: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
396: END IF;
397:

Line 425: l_debug_info := 'FND_SEQNUM.Get_Seq_Info returned succesfully';

421: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
422: END IF;
423: return;
424: else
425: l_debug_info := 'FND_SEQNUM.Get_Seq_Info returned succesfully';
426: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
427: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
428: END IF;
429:

Line 434: l_return_code := FND_SEQNUM.GET_SEQ_VAL(

430: end if;
431:
432:
433:
434: l_return_code := FND_SEQNUM.GET_SEQ_VAL(
435: 200,
436: l_doc_category_code,
437: p_set_of_books_id,
438: 'A',

Line 445: l_debug_info := 'Return Code from fnd_seqnum.get_seq_val: '||l_return_code;

441: l_dbseqid,
442: 'N',
443: 'N');
444:
445: l_debug_info := 'Return Code from fnd_seqnum.get_seq_val: '||l_return_code;
446: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
447: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
448: END IF;
449:

Line 481: l_return_code := fnd_seqnum.get_seq_info(

477:
478:
479: IF p_auto_calculate_interest_flag = 'Y' and p_interest_invoice_count > 0 then
480:
481: l_return_code := fnd_seqnum.get_seq_info(
482: app_id => 200,
483: cat_code => 'INT INV',
484: sob_id => p_set_of_books_id,
485: met_code => 'A',