DBA Data[Home] [Help]

APPS.IBY_AR_UTILS dependencies on IBY_DEBUG_PUB

Line 195: iby_debug_pub.add('p_trxntypeid: ' || p_trxntypeid,

191: BEGIN
192:
193: -- [lmallick] - bug# 9496405
194: -- Supported for capture and Return trxn's
195: iby_debug_pub.add('p_trxntypeid: ' || p_trxntypeid,
196: IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
197: IF (NOT p_trxntypeid IN (8,9,100,5,11)) THEN
198: RETURN null;
199: END IF;

Line 196: IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);

192:
193: -- [lmallick] - bug# 9496405
194: -- Supported for capture and Return trxn's
195: iby_debug_pub.add('p_trxntypeid: ' || p_trxntypeid,
196: IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
197: IF (NOT p_trxntypeid IN (8,9,100,5,11)) THEN
198: RETURN null;
199: END IF;
200:

Line 392: iby_debug_pub.add('p_trxntypeid: ' || p_trxntypeid,

388: FROM iby_ar_doc_header_gt headergt
389: WHERE headergt.initiator_extension_id = c_extension_id;
390:
391: BEGIN
392: iby_debug_pub.add('p_trxntypeid: ' || p_trxntypeid,
393: IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
394: -- [lmallick] - bug# 9496405
395: -- Supported for capture and Return trxn's
396: IF (NOT p_trxntypeid IN (8,9,100,5,11)) THEN

Line 393: IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);

389: WHERE headergt.initiator_extension_id = c_extension_id;
390:
391: BEGIN
392: iby_debug_pub.add('p_trxntypeid: ' || p_trxntypeid,
393: IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
394: -- [lmallick] - bug# 9496405
395: -- Supported for capture and Return trxn's
396: IF (NOT p_trxntypeid IN (8,9,100,5,11)) THEN
397: RETURN null;

Line 738: iby_debug_pub.add('SQLCODE 1:: ' || SQLCODE,

734: RETURN l_trxn_ref_number2;
735:
736: EXCEPTION
737: WHEN others THEN
738: iby_debug_pub.add('SQLCODE 1:: ' || SQLCODE,
739: IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
740: iby_debug_pub.add('SQLERRM :: ' || sqlerrm,
741: IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
742: RETURN NULL;

Line 739: IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);

735:
736: EXCEPTION
737: WHEN others THEN
738: iby_debug_pub.add('SQLCODE 1:: ' || SQLCODE,
739: IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
740: iby_debug_pub.add('SQLERRM :: ' || sqlerrm,
741: IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
742: RETURN NULL;
743:

Line 740: iby_debug_pub.add('SQLERRM :: ' || sqlerrm,

736: EXCEPTION
737: WHEN others THEN
738: iby_debug_pub.add('SQLCODE 1:: ' || SQLCODE,
739: IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
740: iby_debug_pub.add('SQLERRM :: ' || sqlerrm,
741: IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
742: RETURN NULL;
743:
744: END get_trxn_ref_number2;

Line 741: IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);

737: WHEN others THEN
738: iby_debug_pub.add('SQLCODE 1:: ' || SQLCODE,
739: IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
740: iby_debug_pub.add('SQLERRM :: ' || sqlerrm,
741: IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
742: RETURN NULL;
743:
744: END get_trxn_ref_number2;
745:

Line 778: iby_debug_pub.add('Enter: '||p_trxn_extension_id, IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);

774: )
775: ) ORDER BY op.transactionid ASC;
776:
777: BEGIN
778: iby_debug_pub.add('Enter: '||p_trxn_extension_id, IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
779: IF (c_auth_status%ISOPEN) THEN
780: CLOSE c_auth_status;
781: END IF;
782:

Line 786: iby_debug_pub.add('0 records fetched', IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);

782:
783: OPEN c_auth_status(p_trxn_extension_id);
784: FETCH c_auth_status INTO x_auth_flag;
785: IF (c_auth_status%NOTFOUND) THEN
786: iby_debug_pub.add('0 records fetched', IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
787: x_auth_flag := 'N';
788: END IF;
789: CLOSE c_auth_status;
790: iby_debug_pub.add('x_auth_flag= '||x_auth_flag, IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);

Line 790: iby_debug_pub.add('x_auth_flag= '||x_auth_flag, IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);

786: iby_debug_pub.add('0 records fetched', IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
787: x_auth_flag := 'N';
788: END IF;
789: CLOSE c_auth_status;
790: iby_debug_pub.add('x_auth_flag= '||x_auth_flag, IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
791: EXCEPTION
792: WHEN others THEN
793: iby_debug_pub.add('Exception thrown!. Error: ' || SQLERRM,
794: IBY_DEBUG_PUB.G_LEVEL_EXCEPTION,l_dbg_mod);

Line 793: iby_debug_pub.add('Exception thrown!. Error: ' || SQLERRM,

789: CLOSE c_auth_status;
790: iby_debug_pub.add('x_auth_flag= '||x_auth_flag, IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
791: EXCEPTION
792: WHEN others THEN
793: iby_debug_pub.add('Exception thrown!. Error: ' || SQLERRM,
794: IBY_DEBUG_PUB.G_LEVEL_EXCEPTION,l_dbg_mod);
795:
796: x_auth_flag:='N';
797: END;

Line 794: IBY_DEBUG_PUB.G_LEVEL_EXCEPTION,l_dbg_mod);

790: iby_debug_pub.add('x_auth_flag= '||x_auth_flag, IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
791: EXCEPTION
792: WHEN others THEN
793: iby_debug_pub.add('Exception thrown!. Error: ' || SQLERRM,
794: IBY_DEBUG_PUB.G_LEVEL_EXCEPTION,l_dbg_mod);
795:
796: x_auth_flag:='N';
797: END;
798: