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,
347: debug_level => FND_LOG.LEVEL_STATEMENT,
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,
351: debug_level => FND_LOG.LEVEL_STATEMENT,
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,
355: debug_level => FND_LOG.LEVEL_STATEMENT,
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:
359: IF (read_only_in=C_FETCH_READWRITE) THEN
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! ',
390: debug_level => FND_LOG.LEVEL_STATEMENT,
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;
394: