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.IBY_CHECKNUMBER_PUB dependencies on CE_PAYMENT_DOCUMENTS

Line 97: p_pmt_document_id IN CE_PAYMENT_DOCUMENTS.

93: *---------------------------------------------------------------------*/
94: PROCEDURE performCheckNumbering(
95: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.
96: payment_instruction_id%TYPE,
97: p_pmt_document_id IN CE_PAYMENT_DOCUMENTS.
98: payment_document_id%TYPE,
99: p_user_assgn_num IN IBY_PAYMENTS_ALL.
100: paper_document_number%TYPE,
101: x_return_status IN OUT NOCOPY VARCHAR2,

Line 469: CE_PAYMENT_DOCUMENTS ce

465: ce.payment_instruction_id
466: INTO
467: l_instruction_id
468: FROM
469: CE_PAYMENT_DOCUMENTS ce
470: WHERE
471: ce.payment_document_id = p_pmt_document_id
472: ;
473:

Line 512: || ' from CE_PAYMENT_DOCUMENTS table.',

508:
509: print_debuginfo(l_module_name, 'Exception occured when '
510: || 'getting details of payment document id '
511: || p_pmt_document_id
512: || ' from CE_PAYMENT_DOCUMENTS table.',
513: FND_LOG.LEVEL_UNEXPECTED
514: );
515:
516: print_debuginfo(l_module_name, 'SQL code: '

Line 1372: p_pmt_document_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,

1368: | NOTES:
1369: |
1370: *---------------------------------------------------------------------*/
1371: PROCEDURE processPaperPayments(
1372: p_pmt_document_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
1373: p_user_assgn_num IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
1374: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
1375: x_pmtsInPmtInstrTab IN OUT NOCOPY IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType,
1376: x_dummyPaperPmtsTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,

Line 1404: CURSOR c_paper_stock (p_pmt_doc_id IN CE_PAYMENT_DOCUMENTS.

1400: l_paper_special_docs_tab paperPmtsSpecialDocsTabType;
1401:
1402: l_pmtsInPmtInstrRec IBY_PAYINSTR_PUB.pmtsInpmtInstrRecType;
1403:
1404: CURSOR c_paper_stock (p_pmt_doc_id IN CE_PAYMENT_DOCUMENTS.
1405: payment_document_id%TYPE)
1406: IS
1407: SELECT
1408: payment_document_id,

Line 1413: CE_PAYMENT_DOCUMENTS

1409: payment_document_name,
1410: NVL(number_of_setup_documents, 0),
1411: DECODE(attached_remittance_stub_flag,'Y',number_of_lines_per_remit_stub,NULL) number_of_lines_per_remit_stub
1412: FROM
1413: CE_PAYMENT_DOCUMENTS
1414: WHERE
1415: payment_document_id = p_pmt_doc_id
1416: ;
1417:

Line 1436: || 'document from CE_PAYMENT_DOCUMENTS for payment '

1432: IF (l_paper_stocks_tab.COUNT <> 1) THEN
1433:
1434: --IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1435: print_debuginfo(l_module_name, 'Unable to get matching payment '
1436: || 'document from CE_PAYMENT_DOCUMENTS for payment '
1437: || 'document id: '
1438: || p_pmt_document_id
1439: || '. Number of payment documents retrieved: '
1440: || l_paper_stocks_tab.COUNT

Line 2257: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,

2253: |
2254: *---------------------------------------------------------------------*/
2255: PROCEDURE assignCheckNumbers(
2256: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
2257: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
2258: p_user_assgn_num IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
2259: x_paperPmtsTab IN OUT NOCOPY paperPmtsSpecialDocsTabType,
2260: x_dummyPaperPmtsTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
2261: x_instrErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

Line 2530: CE_PAYMENT_DOCUMENTS

2526: INTO
2527: l_pmt_doc_name,
2528: l_pmt_instr_id
2529: FROM
2530: CE_PAYMENT_DOCUMENTS
2531: WHERE
2532: payment_document_id = p_payment_doc_id
2533: ;
2534:

Line 2566: CE_PAYMENT_DOCUMENTS

2562: l_last_avail_check_num,
2563: l_pmt_doc_name,
2564: l_pmt_instr_id
2565: FROM
2566: CE_PAYMENT_DOCUMENTS
2567: WHERE
2568: payment_document_id = p_payment_doc_id
2569: FOR UPDATE SKIP LOCKED
2570: ;

Line 2907: * stock number in CE_PAYMENT_DOCUMENTS.

2903: /*
2904: * If sufficient paper stock is available, we will be using
2905: * up the paper stock by assigning it to the available
2906: * paper payments. Therefore, update the last used paper
2907: * stock number in CE_PAYMENT_DOCUMENTS.
2908: *
2909: * That way if another instance of the payment instruction
2910: * creation program is operating concurrently, it will
2911: * be blocked by the SELECT .. FOR UPDATE statement in

Line 3064: CE_PAYMENT_DOCUMENTS

3060: * Update the check stock to reflect the latest used
3061: * check number.
3062: */
3063: UPDATE
3064: CE_PAYMENT_DOCUMENTS
3065: SET
3066: last_issued_document_number = l_anticipated_last_check_num
3067: WHERE
3068: payment_document_id = p_payment_doc_id

Line 3086: CE_PAYMENT_DOCUMENTS

3082: * Update the check stock to reflect the latest used
3083: * check number, and lock the check stock.
3084: */
3085: UPDATE
3086: CE_PAYMENT_DOCUMENTS
3087: SET
3088: last_issued_document_number = l_anticipated_last_check_num,
3089: payment_instruction_id = x_pmtInstrRec.payment_instruction_id
3090: WHERE

Line 3099: || 'available check number in CE_PAYMENT_DOCUMENTS. '

3095: END IF;
3096:
3097: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3098: print_debuginfo(l_module_name, 'Finished updating the last '
3099: || 'available check number in CE_PAYMENT_DOCUMENTS. '
3100: || 'Current last check number: '
3101: || l_anticipated_last_check_num
3102: );
3103:

Line 4538: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,

4534: | NOTES:
4535: |
4536: *---------------------------------------------------------------------*/
4537: FUNCTION isContigPaperNumAvlbl(
4538: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
4539: p_start_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
4540: p_end_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE
4541: ) RETURN BOOLEAN
4542: IS

Line 4614: * First check against CE_PAYMENT_DOCUMENTS table whether

4610:
4611: BEGIN
4612:
4613: /*
4614: * First check against CE_PAYMENT_DOCUMENTS table whether
4615: * the start_number is greater than the last_issued_document_number
4616: * and the end_number is less than / equal to the last_available
4617: * _document_number.
4618: *

Line 4646: CE_PAYMENT_DOCUMENTS pmt_doc

4642: INTO
4643: l_last_issued_doc_num,
4644: l_last_avail_doc_num
4645: FROM
4646: CE_PAYMENT_DOCUMENTS pmt_doc
4647: WHERE
4648: pmt_doc.payment_document_id = p_payment_doc_id ;
4649:
4650:

Line 4656: || 'provided check range against CE_PAYMENT_DOCUMENTS table.');

4652: WHEN OTHERS THEN
4653:
4654: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4655: print_debuginfo(l_module_name, 'Exception occured when checking for '
4656: || 'provided check range against CE_PAYMENT_DOCUMENTS table.');
4657: print_debuginfo(l_module_name, 'SQLCODE: ' || SQLCODE);
4658: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM);
4659:
4660: END IF;

Line 4702: || 'CE_PAYMENT_DOCUMENTS table. Verifying if any document within '

4698: IF (l_test = 'TRUE') THEN
4699:
4700: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4701: print_debuginfo(l_module_name, 'Provided print range is valid in '
4702: || 'CE_PAYMENT_DOCUMENTS table. Verifying if any document within '
4703: || 'is already USED / SPOILED ..'
4704: );
4705:
4706: END IF;

Line 4789: || 'CE_PAYMENT_DOCUMENTS table. You cannot use this print range.'

4785: ELSE
4786:
4787: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4788: print_debuginfo(l_module_name, 'Provided print range is not valid in '
4789: || 'CE_PAYMENT_DOCUMENTS table. You cannot use this print range.'
4790: );
4791:
4792: END IF;
4793: l_retflag := FALSE;

Line 4856: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,

4852: | NOTES:
4853: |
4854: *---------------------------------------------------------------------*/
4855: FUNCTION isPaperNosUsedOnExistPmt(
4856: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
4857: p_start_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
4858: p_end_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE
4859: ) RETURN BOOLEAN
4860: IS

Line 5050: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,

5046: |
5047: *---------------------------------------------------------------------*/
5048: PROCEDURE assignElectronicCheckNumbers(
5049: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
5050: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
5051: p_user_assgn_num IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
5052: x_paperPmtsTab IN OUT NOCOPY paperPmtsSpecialDocsTabType,
5053: x_dummyPaperPmtsTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
5054: x_instrErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

Line 5192: CE_PAYMENT_DOCUMENTS

5188: INTO
5189: l_pmt_doc_name,
5190: l_pmt_instr_id
5191: FROM
5192: CE_PAYMENT_DOCUMENTS
5193: WHERE
5194: payment_document_id = p_payment_doc_id
5195: ;
5196:

Line 5228: CE_PAYMENT_DOCUMENTS

5224: l_last_avail_check_num,
5225: l_pmt_doc_name,
5226: l_pmt_instr_id
5227: FROM
5228: CE_PAYMENT_DOCUMENTS
5229: WHERE
5230: payment_document_id = p_payment_doc_id
5231: FOR UPDATE SKIP LOCKED
5232: ;

Line 5570: * stock number in CE_PAYMENT_DOCUMENTS.

5566: /*
5567: * If sufficient paper stock is available, we will be using
5568: * up the paper stock by assigning it to the available
5569: * paper payments. Therefore, update the last used paper
5570: * stock number in CE_PAYMENT_DOCUMENTS.
5571: *
5572: * That way if another instance of the payment instruction
5573: * creation program is operating concurrently, it will
5574: * be blocked by the SELECT .. FOR UPDATE statement in

Line 5727: CE_PAYMENT_DOCUMENTS

5723: * Update the check stock to reflect the latest used
5724: * check number.
5725: */
5726: UPDATE
5727: CE_PAYMENT_DOCUMENTS
5728: SET
5729: last_issued_document_number = l_anticipated_last_check_num
5730: WHERE
5731: payment_document_id = p_payment_doc_id

Line 5749: CE_PAYMENT_DOCUMENTS

5745: * Update the check stock to reflect the latest used
5746: * check number, and lock the check stock.
5747: */
5748: UPDATE
5749: CE_PAYMENT_DOCUMENTS
5750: SET
5751: last_issued_document_number = l_anticipated_last_check_num,
5752: payment_instruction_id = x_pmtInstrRec.payment_instruction_id
5753: WHERE

Line 5761: || 'available check number in CE_PAYMENT_DOCUMENTS. '

5757: END IF;
5758:
5759: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5760: print_debuginfo(l_module_name, 'Finished updating the last '
5761: || 'available check number in CE_PAYMENT_DOCUMENTS. '
5762: || 'Current last check number: '
5763: || l_anticipated_last_check_num
5764: );
5765: END IF;