[Home] [Help]
338: WHERE (payment_instruction_id=p_payment_instruction_id) AND (doctype=p_doctype) and rownum = 1
339: ORDER BY trxn_document_id asc;
340:
341: BEGIN
342: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
343: debug_level => FND_LOG.LEVEL_PROCEDURE,
344: module => l_Debug_Module);
345:
346: iby_debug_pub.add(debug_msg => 'input p_payment_instruction_id: ' || p_payment_instruction_id,
342: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
343: debug_level => FND_LOG.LEVEL_PROCEDURE,
344: module => l_Debug_Module);
345:
346: iby_debug_pub.add(debug_msg => 'input p_payment_instruction_id: ' || p_payment_instruction_id,
347: debug_level => FND_LOG.LEVEL_STATEMENT,
348: module => l_Debug_Module);
349:
350: iby_debug_pub.add(debug_msg => 'input p_doctype: ' || p_doctype,
346: iby_debug_pub.add(debug_msg => 'input p_payment_instruction_id: ' || p_payment_instruction_id,
347: debug_level => FND_LOG.LEVEL_STATEMENT,
348: module => l_Debug_Module);
349:
350: iby_debug_pub.add(debug_msg => 'input p_doctype: ' || p_doctype,
351: debug_level => FND_LOG.LEVEL_STATEMENT,
352: module => l_Debug_Module);
353:
354: iby_debug_pub.add(debug_msg => 'input read_only_in: ' || read_only_in,
350: iby_debug_pub.add(debug_msg => 'input p_doctype: ' || p_doctype,
351: debug_level => FND_LOG.LEVEL_STATEMENT,
352: module => l_Debug_Module);
353:
354: iby_debug_pub.add(debug_msg => 'input read_only_in: ' || read_only_in,
355: debug_level => FND_LOG.LEVEL_STATEMENT,
356: module => l_Debug_Module);
357:
358:
381: END IF;
382:
383: IF document_out IS NOT NULL THEN
384:
385: iby_debug_pub.add(debug_msg => 'After fetch, document_out is not null. ',
386: debug_level => FND_LOG.LEVEL_STATEMENT,
387: module => l_Debug_Module);
388: ELSE
389: iby_debug_pub.add(debug_msg => 'After fetch, document_out is null! ',
385: iby_debug_pub.add(debug_msg => 'After fetch, document_out is not null. ',
386: debug_level => FND_LOG.LEVEL_STATEMENT,
387: module => l_Debug_Module);
388: ELSE
389: iby_debug_pub.add(debug_msg => 'After fetch, document_out is null! ',
390: debug_level => FND_LOG.LEVEL_STATEMENT,
391: module => l_Debug_Module);
392:
393: END IF;