eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_PERENDACCRUALS_PVT dependencies on FND_LOG

Line 75: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

71: -- 11. Create accrual entries in CST_PER_END_ACCRUALS_TEMP
72: -------------------------------------------------------------------------------
73:
74: G_PKG_NAME CONSTANT VARCHAR2(30):='CST_PerEndAccruals_PVT';
75: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
76:
77:
78:
79: -----------------------------------------------------------------------------

Line 126: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

122: /* 2- PROCEDURE */
123: /* 1- STATEMENT */
124:
125: /* In general, we should use the following:
126: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
127: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
128: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
129: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
130: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

Line 127: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

123: /* 1- STATEMENT */
124:
125: /* In general, we should use the following:
126: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
127: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
128: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
129: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
130: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
131: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 128: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

124:
125: /* In general, we should use the following:
126: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
127: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
128: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
129: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
130: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
131: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
132: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 129: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

125: /* In general, we should use the following:
126: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
127: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
128: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
129: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
130: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
131: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
132: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
133: */

Line 130: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

126: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
127: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
128: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
129: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
130: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
131: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
132: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
133: */
134:

Line 131: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

127: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
128: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
129: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
130: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
131: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
132: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
133: */
134:
135: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

Line 132: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

128: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
129: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
130: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
131: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
132: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
133: */
134:
135: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
136: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

Line 135: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

131: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
132: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
133: */
134:
135: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
136: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
137: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
138: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
139:

Line 136: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

132: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
133: */
134:
135: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
136: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
137: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
138: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
139:
140: l_accrual_rec CST_PER_END_ACCRUALS_TEMP%ROWTYPE;

Line 137: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

133: */
134:
135: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
136: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
137: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
138: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
139:
140: l_accrual_rec CST_PER_END_ACCRUALS_TEMP%ROWTYPE;
141: l_end_date DATE;

Line 138: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

134:
135: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
136: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
137: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
138: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
139:
140: l_accrual_rec CST_PER_END_ACCRUALS_TEMP%ROWTYPE;
141: l_end_date DATE;
142: l_stmt_num NUMBER;

Line 694: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,'Create_PerEndAccruals << ');

690: l_stmt_num := 0;
691:
692: -- Procedure level log message for Entry point
693: IF (l_pLog) THEN
694: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,'Create_PerEndAccruals << ');
695: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_min_accrual_amount = '|| p_min_accrual_amount);
696: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_vendor_id = '|| p_vendor_id);
697: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_vendor_to = '|| p_vendor_to);
698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_id = '|| p_category_id);

Line 695: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_min_accrual_amount = '|| p_min_accrual_amount);

691:
692: -- Procedure level log message for Entry point
693: IF (l_pLog) THEN
694: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,'Create_PerEndAccruals << ');
695: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_min_accrual_amount = '|| p_min_accrual_amount);
696: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_vendor_id = '|| p_vendor_id);
697: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_vendor_to = '|| p_vendor_to);
698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_id = '|| p_category_id);
699: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_from = '|| p_category_from);

Line 696: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_vendor_id = '|| p_vendor_id);

692: -- Procedure level log message for Entry point
693: IF (l_pLog) THEN
694: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,'Create_PerEndAccruals << ');
695: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_min_accrual_amount = '|| p_min_accrual_amount);
696: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_vendor_id = '|| p_vendor_id);
697: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_vendor_to = '|| p_vendor_to);
698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_id = '|| p_category_id);
699: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_from = '|| p_category_from);
700: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_to = '|| p_category_to);

Line 697: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_vendor_to = '|| p_vendor_to);

693: IF (l_pLog) THEN
694: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,'Create_PerEndAccruals << ');
695: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_min_accrual_amount = '|| p_min_accrual_amount);
696: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_vendor_id = '|| p_vendor_id);
697: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_vendor_to = '|| p_vendor_to);
698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_id = '|| p_category_id);
699: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_from = '|| p_category_from);
700: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_to = '|| p_category_to);
701: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_end_date = '|| p_end_date);

Line 698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_id = '|| p_category_id);

694: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,'Create_PerEndAccruals << ');
695: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_min_accrual_amount = '|| p_min_accrual_amount);
696: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_vendor_id = '|| p_vendor_id);
697: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_vendor_to = '|| p_vendor_to);
698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_id = '|| p_category_id);
699: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_from = '|| p_category_from);
700: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_to = '|| p_category_to);
701: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_end_date = '|| p_end_date);
702: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_accrued_receipt = '|| p_accrued_receipt);

Line 699: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_from = '|| p_category_from);

695: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_min_accrual_amount = '|| p_min_accrual_amount);
696: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_vendor_id = '|| p_vendor_id);
697: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_vendor_to = '|| p_vendor_to);
698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_id = '|| p_category_id);
699: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_from = '|| p_category_from);
700: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_to = '|| p_category_to);
701: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_end_date = '|| p_end_date);
702: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_accrued_receipt = '|| p_accrued_receipt);
703: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_online_accruals = '|| p_online_accruals);

Line 700: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_to = '|| p_category_to);

696: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_vendor_id = '|| p_vendor_id);
697: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_vendor_to = '|| p_vendor_to);
698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_id = '|| p_category_id);
699: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_from = '|| p_category_from);
700: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_to = '|| p_category_to);
701: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_end_date = '|| p_end_date);
702: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_accrued_receipt = '|| p_accrued_receipt);
703: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_online_accruals = '|| p_online_accruals);
704: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_calling_api = '|| p_calling_api);

Line 701: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_end_date = '|| p_end_date);

697: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_vendor_to = '|| p_vendor_to);
698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_id = '|| p_category_id);
699: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_from = '|| p_category_from);
700: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_to = '|| p_category_to);
701: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_end_date = '|| p_end_date);
702: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_accrued_receipt = '|| p_accrued_receipt);
703: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_online_accruals = '|| p_online_accruals);
704: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_calling_api = '|| p_calling_api);
705: END IF;

Line 702: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_accrued_receipt = '|| p_accrued_receipt);

698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_id = '|| p_category_id);
699: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_from = '|| p_category_from);
700: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_to = '|| p_category_to);
701: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_end_date = '|| p_end_date);
702: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_accrued_receipt = '|| p_accrued_receipt);
703: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_online_accruals = '|| p_online_accruals);
704: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_calling_api = '|| p_calling_api);
705: END IF;
706:

Line 703: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_online_accruals = '|| p_online_accruals);

699: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_from = '|| p_category_from);
700: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_to = '|| p_category_to);
701: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_end_date = '|| p_end_date);
702: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_accrued_receipt = '|| p_accrued_receipt);
703: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_online_accruals = '|| p_online_accruals);
704: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_calling_api = '|| p_calling_api);
705: END IF;
706:
707: -- Standard call to check for call compatibility

Line 704: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_calling_api = '|| p_calling_api);

700: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_category_to = '|| p_category_to);
701: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_end_date = '|| p_end_date);
702: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_accrued_receipt = '|| p_accrued_receipt);
703: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_online_accruals = '|| p_online_accruals);
704: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_calling_api = '|| p_calling_api);
705: END IF;
706:
707: -- Standard call to check for call compatibility
708: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 735: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,'Determining the cursor');

731: --
732: --{Specialization BUG#7296737
733: --
734: IF (l_pLog) THEN
735: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,'Determining the cursor');
736: END IF;
737:
738: IF (p_vendor_id IS NULL AND
739: p_vendor_from IS NULL AND

Line 779: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,'l_use :'||l_use);

775: l_use := 'l_distribution_csr';
776: END IF;
777:
778: IF (l_pLog) THEN
779: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,'l_use :'||l_use);
780: END IF;
781:
782: IF l_use = 'c_no_vendor_no_category' THEN
783:

Line 1307: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,'Create_PerEndAccruals >>');

1303: );
1304:
1305: -- Procedure level log message for exit point
1306: IF (l_pLog) THEN
1307: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,'Create_PerEndAccruals >>');
1308: END IF;
1309:
1310: -- Get message count and if 1, return message data.
1311: FND_MSG_PUB.Count_And_Get

Line 1328: FND_LOG.STRING(

1324: ROLLBACK TO Create_PerEndAccruals_PVT;
1325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1326:
1327: IF (l_exceptionLog) THEN
1328: FND_LOG.STRING(
1329: FND_LOG.LEVEL_EXCEPTION,
1330: l_module || '.' || l_stmt_num,
1331: l_msg_data
1332: );

Line 1329: FND_LOG.LEVEL_EXCEPTION,

1325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1326:
1327: IF (l_exceptionLog) THEN
1328: FND_LOG.STRING(
1329: FND_LOG.LEVEL_EXCEPTION,
1330: l_module || '.' || l_stmt_num,
1331: l_msg_data
1332: );
1333: END IF;

Line 1346: FND_LOG.STRING(

1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1343:
1344: -- Unexpected level log message
1345: IF (l_uLog) THEN
1346: FND_LOG.STRING(
1347: FND_LOG.LEVEL_UNEXPECTED,
1348: l_module || '.' || l_stmt_num,
1349: SQLERRM
1350: );

Line 1347: FND_LOG.LEVEL_UNEXPECTED,

1343:
1344: -- Unexpected level log message
1345: IF (l_uLog) THEN
1346: FND_LOG.STRING(
1347: FND_LOG.LEVEL_UNEXPECTED,
1348: l_module || '.' || l_stmt_num,
1349: SQLERRM
1350: );
1351: END IF;

Line 1401: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

1397:
1398: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1399: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
1400:
1401: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1402: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1403: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1404: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1405:

Line 1402: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

1398: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1399: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
1400:
1401: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1402: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1403: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1404: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1405:
1406: l_stmt_num NUMBER;

Line 1403: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

1399: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
1400:
1401: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1402: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1403: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1404: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1405:
1406: l_stmt_num NUMBER;
1407: l_msg_data VARCHAR2(240);

Line 1404: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

1400:
1401: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1402: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1403: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1404: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1405:
1406: l_stmt_num NUMBER;
1407: l_msg_data VARCHAR2(240);
1408:

Line 1460: FND_LOG.STRING(

1456: l_stmt_num := 0;
1457:
1458: -- Procedure level log message for Entry point
1459: IF (l_pLog) THEN
1460: FND_LOG.STRING(
1461: FND_LOG.LEVEL_PROCEDURE,
1462: l_module || '.begin',
1463: 'Calculate_AccrualAmount <<' ||
1464: 'p_service_flag = ' || p_service_flag ||','||

Line 1461: FND_LOG.LEVEL_PROCEDURE,

1457:
1458: -- Procedure level log message for Entry point
1459: IF (l_pLog) THEN
1460: FND_LOG.STRING(
1461: FND_LOG.LEVEL_PROCEDURE,
1462: l_module || '.begin',
1463: 'Calculate_AccrualAmount <<' ||
1464: 'p_service_flag = ' || p_service_flag ||','||
1465: 'p_dist_qty = ' || p_dist_qty ||','||

Line 1896: FND_LOG.STRING(

1892: x_accrual_rec.encum_amount := x_accrual_rec.encum_quantity * x_accrual_rec.unit_price;
1893:
1894: -- Procedure level log message for exit point
1895: IF (l_pLog) THEN
1896: FND_LOG.STRING(
1897: FND_LOG.LEVEL_PROCEDURE,
1898: l_module || '.end',
1899: 'Calculate_AccrualAmount >> ' ||
1900: 'quantity_received = ' || x_accrual_rec.quantity_received ||','||

Line 1897: FND_LOG.LEVEL_PROCEDURE,

1893:
1894: -- Procedure level log message for exit point
1895: IF (l_pLog) THEN
1896: FND_LOG.STRING(
1897: FND_LOG.LEVEL_PROCEDURE,
1898: l_module || '.end',
1899: 'Calculate_AccrualAmount >> ' ||
1900: 'quantity_received = ' || x_accrual_rec.quantity_received ||','||
1901: 'quantity_billed = ' || x_accrual_rec.quantity_billed ||','||

Line 1922: FND_LOG.STRING(

1918:
1919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1920:
1921: IF (l_exceptionLog) THEN
1922: FND_LOG.STRING(
1923: FND_LOG.LEVEL_EXCEPTION,
1924: l_module || '.' || l_stmt_num,
1925: l_msg_data
1926: );

Line 1923: FND_LOG.LEVEL_EXCEPTION,

1919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1920:
1921: IF (l_exceptionLog) THEN
1922: FND_LOG.STRING(
1923: FND_LOG.LEVEL_EXCEPTION,
1924: l_module || '.' || l_stmt_num,
1925: l_msg_data
1926: );
1927: END IF;

Line 1939: FND_LOG.STRING(

1935:
1936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1937:
1938: IF (l_uLog) THEN
1939: FND_LOG.STRING(
1940: FND_LOG.LEVEL_UNEXPECTED,
1941: l_module || '.' || l_stmt_num,
1942: SQLERRM
1943: );

Line 1940: FND_LOG.LEVEL_UNEXPECTED,

1936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1937:
1938: IF (l_uLog) THEN
1939: FND_LOG.STRING(
1940: FND_LOG.LEVEL_UNEXPECTED,
1941: l_module || '.' || l_stmt_num,
1942: SQLERRM
1943: );
1944: END IF;

Line 1998: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

1994:
1995: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1996: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
1997:
1998: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1999: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2000: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2001: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2002:

Line 1999: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

1995: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1996: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
1997:
1998: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1999: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2000: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2001: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2002:
2003: l_stmt_num NUMBER;

Line 2000: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

1996: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
1997:
1998: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1999: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2000: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2001: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2002:
2003: l_stmt_num NUMBER;
2004: l_msg_data VARCHAR2(240);

Line 2001: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

1997:
1998: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1999: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2000: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2001: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2002:
2003: l_stmt_num NUMBER;
2004: l_msg_data VARCHAR2(240);
2005: l_accrual_rec CST_PER_END_ACCRUALS_TEMP%ROWTYPE;

Line 2013: FND_LOG.STRING(

2009: l_stmt_num := 0;
2010:
2011: -- Procedure level log message for Entry point
2012: IF (l_pLog) THEN
2013: FND_LOG.STRING(
2014: FND_LOG.LEVEL_PROCEDURE,
2015: l_module || '.begin',
2016: 'Calculate_AccrualAmount <<' ||
2017: 'p_match_option = ' || p_match_option ||','||

Line 2014: FND_LOG.LEVEL_PROCEDURE,

2010:
2011: -- Procedure level log message for Entry point
2012: IF (l_pLog) THEN
2013: FND_LOG.STRING(
2014: FND_LOG.LEVEL_PROCEDURE,
2015: l_module || '.begin',
2016: 'Calculate_AccrualAmount <<' ||
2017: 'p_match_option = ' || p_match_option ||','||
2018: 'p_distribution_id = ' || p_distribution_id ||','||

Line 2087: FND_LOG.STRING(

2083: x_encum_qty := l_accrual_rec.encum_quantity;
2084:
2085: -- Procedure level log message for exit point
2086: IF (l_pLog) THEN
2087: FND_LOG.STRING(
2088: FND_LOG.LEVEL_PROCEDURE,
2089: l_module || '.end',
2090: 'Calculate_AccrualAmount >>' ||
2091: 'x_accrual_qty = ' || x_accrual_qty ||','||

Line 2088: FND_LOG.LEVEL_PROCEDURE,

2084:
2085: -- Procedure level log message for exit point
2086: IF (l_pLog) THEN
2087: FND_LOG.STRING(
2088: FND_LOG.LEVEL_PROCEDURE,
2089: l_module || '.end',
2090: 'Calculate_AccrualAmount >>' ||
2091: 'x_accrual_qty = ' || x_accrual_qty ||','||
2092: 'x_encum_qty = ' || x_encum_qty

Line 2109: FND_LOG.STRING(

2105:
2106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2107:
2108: IF (l_exceptionLog) THEN
2109: FND_LOG.STRING(
2110: FND_LOG.LEVEL_EXCEPTION,
2111: l_module || '.' || l_stmt_num,
2112: l_msg_data
2113: );

Line 2110: FND_LOG.LEVEL_EXCEPTION,

2106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2107:
2108: IF (l_exceptionLog) THEN
2109: FND_LOG.STRING(
2110: FND_LOG.LEVEL_EXCEPTION,
2111: l_module || '.' || l_stmt_num,
2112: l_msg_data
2113: );
2114: END IF;

Line 2126: FND_LOG.STRING(

2122:
2123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2124:
2125: IF (l_uLog) THEN
2126: FND_LOG.STRING(
2127: FND_LOG.LEVEL_UNEXPECTED,
2128: l_module || '.' || l_stmt_num,
2129: SQLERRM
2130: );

Line 2127: FND_LOG.LEVEL_UNEXPECTED,

2123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2124:
2125: IF (l_uLog) THEN
2126: FND_LOG.STRING(
2127: FND_LOG.LEVEL_UNEXPECTED,
2128: l_module || '.' || l_stmt_num,
2129: SQLERRM
2130: );
2131: END IF;

Line 2188: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

2184:
2185: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
2186: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
2187:
2188: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2189: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2190: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2191:
2192: l_stmt_num NUMBER;

Line 2189: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

2185: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
2186: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
2187:
2188: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2189: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2190: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2191:
2192: l_stmt_num NUMBER;
2193: l_parent_type VARCHAR2(25);

Line 2190: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

2186: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
2187:
2188: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2189: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2190: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2191:
2192: l_stmt_num NUMBER;
2193: l_parent_type VARCHAR2(25);
2194: qty_received NUMBER;

Line 2250: FND_LOG.STRING(

2246:
2247: l_stmt_num := 0;
2248: -- Procedure level log message for Entry point
2249: IF (l_pLog) THEN
2250: FND_LOG.STRING(
2251: FND_LOG.LEVEL_PROCEDURE,
2252: l_module || '.begin',
2253: 'Get_RcvQuantity << ' ||
2254: 'p_line_location_id = ' || p_line_location_id ||','||

Line 2251: FND_LOG.LEVEL_PROCEDURE,

2247: l_stmt_num := 0;
2248: -- Procedure level log message for Entry point
2249: IF (l_pLog) THEN
2250: FND_LOG.STRING(
2251: FND_LOG.LEVEL_PROCEDURE,
2252: l_module || '.begin',
2253: 'Get_RcvQuantity << ' ||
2254: 'p_line_location_id = ' || p_line_location_id ||','||
2255: 'p_rcv_txn_id = ' || p_rcv_txn_id ||','||

Line 2475: FND_LOG.STRING(

2471: END IF;
2472:
2473: -- Procedure level log message for exit point
2474: IF (l_pLog) THEN
2475: FND_LOG.STRING(
2476: FND_LOG.LEVEL_PROCEDURE,
2477: l_module || '.end',
2478: 'Get_RcvQuantity >> ' ||
2479: 'g_nqr = ' || g_nqr ||','||

Line 2476: FND_LOG.LEVEL_PROCEDURE,

2472:
2473: -- Procedure level log message for exit point
2474: IF (l_pLog) THEN
2475: FND_LOG.STRING(
2476: FND_LOG.LEVEL_PROCEDURE,
2477: l_module || '.end',
2478: 'Get_RcvQuantity >> ' ||
2479: 'g_nqr = ' || g_nqr ||','||
2480: 'g_nqd = ' || g_nqd

Line 2506: FND_LOG.STRING(

2502:
2503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2504:
2505: IF (l_uLog) THEN
2506: FND_LOG.STRING(
2507: FND_LOG.LEVEL_UNEXPECTED,
2508: l_module || '.' || l_stmt_num,
2509: SQLERRM
2510: );

Line 2507: FND_LOG.LEVEL_UNEXPECTED,

2503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2504:
2505: IF (l_uLog) THEN
2506: FND_LOG.STRING(
2507: FND_LOG.LEVEL_UNEXPECTED,
2508: l_module || '.' || l_stmt_num,
2509: SQLERRM
2510: );
2511: END IF;

Line 2560: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

2556:
2557: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
2558: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
2559:
2560: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2561: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2562: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2563:
2564: l_quantity_invoiced NUMBER;

Line 2561: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

2557: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
2558: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
2559:
2560: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2561: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2562: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2563:
2564: l_quantity_invoiced NUMBER;
2565: l_txn_to_po_rate NUMBER;

Line 2562: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

2558: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
2559:
2560: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2561: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2562: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2563:
2564: l_quantity_invoiced NUMBER;
2565: l_txn_to_po_rate NUMBER;
2566: l_stmt_num NUMBER;

Line 2573: FND_LOG.STRING(

2569:
2570: l_stmt_num := 0;
2571: -- Procedure level log message for Entry point
2572: IF (l_pLog) THEN
2573: FND_LOG.STRING(
2574: FND_LOG.LEVEL_PROCEDURE,
2575: l_module || '.begin',
2576: 'Get_InvoiceQuantity <<' ||
2577: 'p_match_option = ' || p_match_option ||','||

Line 2574: FND_LOG.LEVEL_PROCEDURE,

2570: l_stmt_num := 0;
2571: -- Procedure level log message for Entry point
2572: IF (l_pLog) THEN
2573: FND_LOG.STRING(
2574: FND_LOG.LEVEL_PROCEDURE,
2575: l_module || '.begin',
2576: 'Get_InvoiceQuantity <<' ||
2577: 'p_match_option = ' || p_match_option ||','||
2578: 'p_dist_id = ' || p_dist_id ||','||

Line 2673: FND_LOG.STRING(

2669: x_quantity_invoiced := l_quantity_invoiced;
2670:
2671: -- Procedure level log message for exit point
2672: IF (l_pLog) THEN
2673: FND_LOG.STRING(
2674: FND_LOG.LEVEL_PROCEDURE,
2675: l_module || '.end',
2676: 'Get_InvoiceQuantity >> ' ||
2677: 'x_quantity_invoiced = ' || x_quantity_invoiced

Line 2674: FND_LOG.LEVEL_PROCEDURE,

2670:
2671: -- Procedure level log message for exit point
2672: IF (l_pLog) THEN
2673: FND_LOG.STRING(
2674: FND_LOG.LEVEL_PROCEDURE,
2675: l_module || '.end',
2676: 'Get_InvoiceQuantity >> ' ||
2677: 'x_quantity_invoiced = ' || x_quantity_invoiced
2678: );

Line 2702: FND_LOG.STRING(

2698: WHEN OTHERS THEN
2699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2700:
2701: IF (l_uLog) THEN
2702: FND_LOG.STRING(
2703: FND_LOG.LEVEL_UNEXPECTED,
2704: l_module || '.' || l_stmt_num,
2705: SQLERRM
2706: );

Line 2703: FND_LOG.LEVEL_UNEXPECTED,

2699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2700:
2701: IF (l_uLog) THEN
2702: FND_LOG.STRING(
2703: FND_LOG.LEVEL_UNEXPECTED,
2704: l_module || '.' || l_stmt_num,
2705: SQLERRM
2706: );
2707: END IF;