DBA Data[Home] [Help]

APPS.IBY_DISBURSE_UI_API_PUB_PKG dependencies on FND_LOG

Line 8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4: /*
5: * Declare global variables
6: */
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_DISBURSE_UI_API_PUB_PKG';
8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
10:
11: /*
12: * List of document statuses that are used / set in this

Line 9: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

5: * Declare global variables
6: */
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_DISBURSE_UI_API_PUB_PKG';
8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
10:
11: /*
12: * List of document statuses that are used / set in this
13: * module.

Line 4726: FND_LOG.LEVEL_UNEXPECTED

4722: || l_callout_name
4723: || ''', returned failure status - '
4724: || x_return_status
4725: || '. Raising exception.',
4726: FND_LOG.LEVEL_UNEXPECTED
4727: );
4728:
4729:
4730: l_error_code := 'IBY_INS_AWT_CERT_HOOK_FAILED';

Line 4753: FND_LOG.LEVEL_UNEXPECTED

4749:
4750: print_debuginfo(l_module_name, 'Fatal: External app callout '''
4751: || l_callout_name
4752: || ''', generated exception.',
4753: FND_LOG.LEVEL_UNEXPECTED
4754: );
4755:
4756: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4757: FND_LOG.LEVEL_UNEXPECTED);

Line 4757: FND_LOG.LEVEL_UNEXPECTED);

4753: FND_LOG.LEVEL_UNEXPECTED
4754: );
4755:
4756: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4757: FND_LOG.LEVEL_UNEXPECTED);
4758: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
4759: FND_LOG.LEVEL_UNEXPECTED);
4760:
4761:

Line 4759: FND_LOG.LEVEL_UNEXPECTED);

4755:
4756: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4757: FND_LOG.LEVEL_UNEXPECTED);
4758: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
4759: FND_LOG.LEVEL_UNEXPECTED);
4760:
4761:
4762: /*
4763: * Propogate exception to caller.

Line 6811: debug_level => FND_LOG.LEVEL_PROCEDURE,

6807:
6808: BEGIN
6809:
6810: iby_debug_pub.log(debug_msg => 'Enter withholding(printed) pkg:'||l_callout_name||': Timestamp:' || systimestamp,
6811: debug_level => FND_LOG.LEVEL_PROCEDURE,
6812: module => l_module_name);
6813:
6814: EXECUTE IMMEDIATE
6815: (l_stmt)

Line 6828: debug_level => FND_LOG.LEVEL_PROCEDURE,

6824: OUT l_msg_data
6825: ;
6826:
6827: iby_debug_pub.log(debug_msg => 'Exit withholding(printed) pkg:'||l_callout_name||': Timestamp:' || systimestamp,
6828: debug_level => FND_LOG.LEVEL_PROCEDURE,
6829: module => l_module_name);
6830:
6831: /*
6832: * If the called procedure did not return success,

Line 8174: debug_level => FND_LOG.LEVEL_PROCEDURE,

8170:
8171: BEGIN
8172:
8173: iby_debug_pub.log(debug_msg => 'Enter Record Print Status: Timestamp:' || systimestamp,
8174: debug_level => FND_LOG.LEVEL_PROCEDURE,
8175: module => l_module_name);
8176:
8177: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8178: print_debuginfo(l_module_name, 'ENTER');

Line 8564: debug_level => FND_LOG.LEVEL_PROCEDURE,

8560:
8561: BEGIN
8562:
8563: iby_debug_pub.log(debug_msg => 'Enter withholding pkg:'||l_callout_name||': Timestamp:' || systimestamp,
8564: debug_level => FND_LOG.LEVEL_PROCEDURE,
8565: module => l_module_name);
8566:
8567: EXECUTE IMMEDIATE
8568: (l_stmt)

Line 8581: debug_level => FND_LOG.LEVEL_PROCEDURE,

8577: OUT l_msg_data
8578: ;
8579:
8580: iby_debug_pub.log(debug_msg => 'Exit withholding pkg:'||l_callout_name||': Timestamp:' || systimestamp,
8581: debug_level => FND_LOG.LEVEL_PROCEDURE,
8582: module => l_module_name);
8583:
8584: /*
8585: * If the called procedure did not return success,

Line 8757: debug_level => FND_LOG.LEVEL_PROCEDURE,

8753:
8754: END IF;
8755:
8756: iby_debug_pub.log(debug_msg => 'Exit Record Print Status : Timestamp:' || systimestamp,
8757: debug_level => FND_LOG.LEVEL_PROCEDURE,
8758: module => l_module_name);
8759: EXCEPTION
8760: WHEN OTHERS THEN
8761:

Line 9069: debug_level => FND_LOG.LEVEL_PROCEDURE,

9065: END IF;
9066: FND_MSG_PUB.initialize;
9067:
9068: iby_debug_pub.log(debug_msg => 'Enter Mark Complete: Timestamp:' || systimestamp,
9069: debug_level => FND_LOG.LEVEL_PROCEDURE,
9070: module => l_module_name);
9071:
9072: /*
9073: * STEP 0 :

Line 9481: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

9477: *
9478: * Print list of payments marked complete. This is
9479: * very important for debugging AP-IBY boundry issues.
9480: */
9481: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9482: print_completed_pmts(l_completion_id);
9483: END IF;
9484:
9485: /*

Line 9514: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

9510: *
9511: * Print list of documents payable marked complete. This is
9512: * very important for debugging AP-IBY boundry issues.
9513: */
9514: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9515: print_completed_docs(l_completion_id);
9516: END IF;
9517:
9518: /*

Line 9535: || l_callout_name, FND_LOG.LEVEL_UNEXPECTED);

9531: l_callout_name := l_pkg_name || '.' || 'payments_completed';
9532:
9533: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9534: print_debuginfo(l_module_name, 'Attempting to invoke callout: '
9535: || l_callout_name, FND_LOG.LEVEL_UNEXPECTED);
9536:
9537: END IF;
9538: SELECT
9539: count(*)

Line 9562: FND_LOG.LEVEL_UNEXPECTED

9558: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9559: print_debuginfo(l_module_name, 'Params passed to callout - '
9560: || 'completed pmts group id: '
9561: || l_completion_id,
9562: FND_LOG.LEVEL_UNEXPECTED
9563: );
9564:
9565: print_debuginfo(l_module_name, 'Params not passed to callout - '
9566: || 'completed pmts count: '

Line 9584: debug_level => FND_LOG.LEVEL_PROCEDURE,

9580:
9581: BEGIN
9582:
9583: iby_debug_pub.log(debug_msg => 'Enter Callout pkg:'||l_callout_name||': Timestamp:' || systimestamp,
9584: debug_level => FND_LOG.LEVEL_PROCEDURE,
9585: module => l_module_name);
9586:
9587: EXECUTE IMMEDIATE
9588: (l_stmt)

Line 9600: debug_level => FND_LOG.LEVEL_PROCEDURE,

9596: IN l_completion_id
9597: ;
9598:
9599: iby_debug_pub.log(debug_msg => 'Exit Callout pkg:'||l_callout_name||': Timestamp:' || systimestamp,
9600: debug_level => FND_LOG.LEVEL_PROCEDURE,
9601: module => l_module_name);
9602:
9603:
9604: /*

Line 9618: FND_LOG.LEVEL_UNEXPECTED

9614: || l_callout_name
9615: || ''', returned failure status - '
9616: || x_return_status
9617: || '. Raising exception.',
9618: FND_LOG.LEVEL_UNEXPECTED
9619: );
9620:
9621:
9622: APP_EXCEPTION.RAISE_EXCEPTION;

Line 9644: FND_LOG.LEVEL_UNEXPECTED

9640: print_debuginfo(l_module_name, 'Fatal: External app '
9641: || 'callout '''
9642: || l_callout_name
9643: || ''', generated exception.',
9644: FND_LOG.LEVEL_UNEXPECTED
9645: );
9646:
9647: print_debuginfo(l_module_name, 'SQL code: '
9648: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);

Line 9648: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);

9644: FND_LOG.LEVEL_UNEXPECTED
9645: );
9646:
9647: print_debuginfo(l_module_name, 'SQL code: '
9648: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
9649: print_debuginfo(l_module_name, 'SQL err msg: '
9650: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
9651:
9652:

Line 9650: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);

9646:
9647: print_debuginfo(l_module_name, 'SQL code: '
9648: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
9649: print_debuginfo(l_module_name, 'SQL err msg: '
9650: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
9651:
9652:
9653: /*
9654: * Fix for bug 5608142:

Line 9796: debug_level => FND_LOG.LEVEL_PROCEDURE,

9792:
9793: END IF;
9794: BEGIN
9795: iby_debug_pub.log(debug_msg => 'Enter Paper Document Numbering: Timestamp:' || systimestamp,
9796: debug_level => FND_LOG.LEVEL_PROCEDURE,
9797: module => l_module_name);
9798:
9799: /* EFT Paper DOCUMENT NUMBER BEGIN*/
9800: /* Bug 9376894*/

Line 9849: debug_level => FND_LOG.LEVEL_PROCEDURE,

9845: END IF;
9846:
9847: /* EFT DOCUMENT NUMBER END*/
9848: iby_debug_pub.log(debug_msg => 'Exit Paper Document Numbering: Timestamp:' || systimestamp,
9849: debug_level => FND_LOG.LEVEL_PROCEDURE,
9850: module => l_module_name);
9851: UPDATE
9852: CE_PAYMENT_DOCUMENTS
9853: SET

Line 10442: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT

10438: *---------------------------------------------------------------------*/
10439: PROCEDURE print_debuginfo(
10440: p_module IN VARCHAR2,
10441: p_debug_text IN VARCHAR2,
10442: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
10443: )
10444: IS
10445: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;
10446: BEGIN

Line 10445: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;

10441: p_debug_text IN VARCHAR2,
10442: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
10443: )
10444: IS
10445: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;
10446: BEGIN
10447:
10448: /*
10449: * Set the debug level to the value passed in

Line 10459: --IF (l_default_debug_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

10455:
10456: /*
10457: * Write the debug message to the concurrent manager log file.
10458: */
10459: --IF (l_default_debug_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
10460:
10461: iby_debug_pub.log(debug_msg => p_module||':'||p_debug_text,debug_level => p_debug_level, module => p_module); --Bug 14335525
10462:
10463: --END IF;