DBA Data[Home] [Help]

APPS.AP_GENERATE_DISTRIBUTIONS_PKG dependencies on AP_GENERATE_DISTRIBUTIONS_PKG

Line 1: PACKAGE BODY AP_GENERATE_DISTRIBUTIONS_PKG AS

1: PACKAGE BODY AP_GENERATE_DISTRIBUTIONS_PKG AS
2: /*$Header: apaidutb.pls 120.16 2008/06/09 08:33:37 mayyalas ship $ */
3:
4: --Bugfix:3859755, added the below FND_LOG related variables, in order
5: --to enable LOGGING for this package.

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_GENERATE_DISTRIBUTIONS_PKG';

2: /*$Header: apaidutb.pls 120.16 2008/06/09 08:33:37 mayyalas ship $ */
3:
4: --Bugfix:3859755, added the below FND_LOG related variables, in order
5: --to enable LOGGING for this package.
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_GENERATE_DISTRIBUTIONS_PKG';
7: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
8: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
9: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
10: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 22: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_GENERATE_DISTRIBUTIONS_PKG.';

18: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
19: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
20: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
21: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
22: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_GENERATE_DISTRIBUTIONS_PKG.';
23:
24: CURSOR G_INVOICE_LINES_CURSOR(P_Invoice_ID Number,
25: P_Invoice_Line_Number NUMBER) IS
26: SELECT INVOICE_ID,

Line 242: l_curr_calling_sequence := 'AP_GENERATE_DISTRIBUTIONS_PKG.'||

238: l_api_name CONSTANT VARCHAR2(200) := 'Generate_Dists_For_Invoice';
239:
240: BEGIN
241:
242: l_curr_calling_sequence := 'AP_GENERATE_DISTRIBUTIONS_PKG.'||
243: 'Generate_Dists_for_Invoice <- '||p_calling_sequence;
244:
245: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
246: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_GENERATE_DISTRIBUTIONS_PKG.Generate_Dists_for_Invoice(+)');

Line 246: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_GENERATE_DISTRIBUTIONS_PKG.Generate_Dists_for_Invoice(+)');

242: l_curr_calling_sequence := 'AP_GENERATE_DISTRIBUTIONS_PKG.'||
243: 'Generate_Dists_for_Invoice <- '||p_calling_sequence;
244:
245: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
246: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_GENERATE_DISTRIBUTIONS_PKG.Generate_Dists_for_Invoice(+)');
247: END IF;
248:
249: l_debug_info := 'Open G_Invoice_Lines Cursor';
250:

Line 461: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_GENERATE_DISTRIBUTIONS_PKG.Generate_Dists_for_Invoice(-)');

457: Return(FALSE);
458: END IF;
459:
460: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
461: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_GENERATE_DISTRIBUTIONS_PKG.Generate_Dists_for_Invoice(-)');
462: END IF;
463:
464: Return(TRUE);
465:

Line 513: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_GENERATE_DISTRIBUTIONS_PKG.Generate_Dists_for_Invoice(-)');

509: -- Bug 6802813 End.
510:
511: --Do nothing, just return as successful.
512: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
513: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_GENERATE_DISTRIBUTIONS_PKG.Generate_Dists_for_Invoice(-)');
514: END IF;
515:
516: Return(TRUE);
517:

Line 578: l_curr_calling_sequence := 'AP_GENERATE_DISTRIBUTIONS_PKG.'||

574: l_curr_calling_sequence VARCHAR2(2000);
575:
576: BEGIN
577:
578: l_curr_calling_sequence := 'AP_GENERATE_DISTRIBUTIONS_PKG.'||
579: 'Generate_Dists_for_Line <- '||p_calling_sequence;
580:
581: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
582: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_GENERATE_DISTRIBUTIONS_PKG.Generate_Dists_for_Line(+)');

Line 582: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_GENERATE_DISTRIBUTIONS_PKG.Generate_Dists_for_Line(+)');

578: l_curr_calling_sequence := 'AP_GENERATE_DISTRIBUTIONS_PKG.'||
579: 'Generate_Dists_for_Line <- '||p_calling_sequence;
580:
581: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
582: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_GENERATE_DISTRIBUTIONS_PKG.Generate_Dists_for_Line(+)');
583: END IF;
584:
585: /* Bug 5362316. Move the tax call before Opening Cursor */
586: l_debug_info := 'Call etax api to Calculate-Tax for just that invoice line';

Line 850: l_curr_calling_sequence := 'AP_GENERATE_DISTRIBUTIONS_PKG.'||

846: l_api_name CONSTANT VARCHAR2(200) := 'generateDistsForInvoice';
847:
848: BEGIN
849:
850: l_curr_calling_sequence := 'AP_GENERATE_DISTRIBUTIONS_PKG.'||
851: 'Generate_Dists_for_Invoice <- '||p_calling_sequence;
852:
853: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
854: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_GENERATE_DISTRIBUTIONS_PKG.Generate_Dists_for_Invoice(+)');

Line 854: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_GENERATE_DISTRIBUTIONS_PKG.Generate_Dists_for_Invoice(+)');

850: l_curr_calling_sequence := 'AP_GENERATE_DISTRIBUTIONS_PKG.'||
851: 'Generate_Dists_for_Invoice <- '||p_calling_sequence;
852:
853: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
854: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_GENERATE_DISTRIBUTIONS_PKG.Generate_Dists_for_Invoice(+)');
855: END IF;
856:
857: IF ( generate_dists_for_invoice (
858: P_Invoice_Id => p_invoice_id,

Line 893: END AP_GENERATE_DISTRIBUTIONS_PKG;

889:
890: END generateDistsForInvoice;
891:
892:
893: END AP_GENERATE_DISTRIBUTIONS_PKG;