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.AHL_OSP_ACCOMP_PVT dependencies on FND_LOG

Line 11: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_OSP_ACCOMP_PVT';
8: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
9: G_LOG_PREFIX CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME;
10:
11: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
12: l_log_statement NUMBER := fnd_log.level_statement;
13: l_log_procedure NUMBER := fnd_log.level_procedure;
14:
15:

Line 12: l_log_statement NUMBER := fnd_log.level_statement;

8: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
9: G_LOG_PREFIX CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME;
10:
11: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
12: l_log_statement NUMBER := fnd_log.level_statement;
13: l_log_procedure NUMBER := fnd_log.level_procedure;
14:
15:
16: ------------------------

Line 13: l_log_procedure NUMBER := fnd_log.level_procedure;

9: G_LOG_PREFIX CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME;
10:
11: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
12: l_log_statement NUMBER := fnd_log.level_statement;
13: l_log_procedure NUMBER := fnd_log.level_procedure;
14:
15:
16: ------------------------
17: -- Declare Local Functions --

Line 94: FND_LOG.STRING(l_log_procedure, L_FULL_NAME || '.begin',

90: --Initialize API return status to success
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: IF (l_log_procedure >= l_log_current_level) THEN
94: FND_LOG.STRING(l_log_procedure, L_FULL_NAME || '.begin',
95: 'At the start of the procedure. p_instance_id = ' || p_instance_id ||
96: ', p_mr_header_id = ' || p_mr_header_id ||
97: ', p_accomplishment_date = ' || p_accomplishment_date);
98: END IF;

Line 106: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Validating accomplishment date.');

102: FETCH get_mr_dtls_csr INTO l_mr_dtls;
103: CLOSE get_mr_dtls_csr;
104:
105: IF (l_log_statement >= l_log_current_level) THEN
106: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Validating accomplishment date.');
107: END IF;
108: --Validate that the date accomplishment date is between the effective to and from dates of the MR
109: IF (p_accomplishment_date < l_mr_dtls.effective_from OR p_accomplishment_date > nvl(l_mr_dtls.effective_to,SYSDATE)) THEN
110: IF (l_log_statement >= l_log_current_level) THEN

Line 111: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Invalid accomplishment date.');

107: END IF;
108: --Validate that the date accomplishment date is between the effective to and from dates of the MR
109: IF (p_accomplishment_date < l_mr_dtls.effective_from OR p_accomplishment_date > nvl(l_mr_dtls.effective_to,SYSDATE)) THEN
110: IF (l_log_statement >= l_log_current_level) THEN
111: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Invalid accomplishment date.');
112: END IF;
113: FND_MESSAGE.set_name('AHL','AHL_OSP_ACC_INV_DATE');
114: FND_MESSAGE.set_token('TITLE',l_mr_dtls.title);
115: FND_MSG_PUB.add;

Line 120: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Validating MR status.');

116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118:
119: IF (l_log_statement >= l_log_current_level) THEN
120: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Validating MR status.');
121: END IF;
122: --Validate that the mr is in the complete status
123: IF (l_mr_dtls.mr_status_code <> 'COMPLETE' ) THEN
124: IF (l_log_statement >= l_log_current_level) THEN

Line 125: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Invalid MR Status.');

121: END IF;
122: --Validate that the mr is in the complete status
123: IF (l_mr_dtls.mr_status_code <> 'COMPLETE' ) THEN
124: IF (l_log_statement >= l_log_current_level) THEN
125: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Invalid MR Status.');
126: END IF;
127: FND_MESSAGE.set_name('AHL','AHL_OSP_ACC_INV_STATUS');
128: FND_MESSAGE.set_token('TITLE',l_mr_dtls.title);
129: FND_MSG_PUB.add;

Line 138: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'About to call AHL_UMP_UNPLANNED_PVT.CREATE_UNIT_EFFECTIVITY.');

134:
135:
136:
137: IF (l_log_statement >= l_log_current_level) THEN
138: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'About to call AHL_UMP_UNPLANNED_PVT.CREATE_UNIT_EFFECTIVITY.');
139: END IF;
140: AHL_UMP_UNPLANNED_PVT.CREATE_UNIT_EFFECTIVITY(
141: p_api_version => 1.0,
142: x_return_status => l_return_status,

Line 149: fnd_log.string(l_log_statement, L_FULL_NAME, 'Returned from call to AHL_UMP_UNPLANNED_PVT.CREATE_UNIT_EFFECTIVITY. x_return_status = ' || l_return_status || ' and x_orig_ue_id = ' || l_ue_id);

145: p_mr_header_id => p_mr_header_id,
146: p_instance_id => p_instance_id,
147: x_orig_ue_id => l_ue_id);
148: IF (l_log_statement >= l_log_current_level) THEN
149: fnd_log.string(l_log_statement, L_FULL_NAME, 'Returned from call to AHL_UMP_UNPLANNED_PVT.CREATE_UNIT_EFFECTIVITY. x_return_status = ' || l_return_status || ' and x_orig_ue_id = ' || l_ue_id);
150: END IF;
151:
152: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN
153: x_msg_count := l_msg_count;

Line 164: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'About to call Accomplish_UMP');

160: RETURN;
161: END IF;
162:
163: IF (l_log_statement >= l_log_current_level) THEN
164: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'About to call Accomplish_UMP');
165: END IF;
166: Accomplish_UMP(
167: p_unit_effectivity_id => l_ue_id,
168: p_accomplishment_date => p_accomplishment_date,

Line 174: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Returned from call to Accomplish_UMP. x_return_status = ' || l_return_status);

170: x_msg_count => l_msg_count,
171: x_msg_data => l_msg_data
172: );
173: IF (l_log_statement >= l_log_current_level) THEN
174: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Returned from call to Accomplish_UMP. x_return_status = ' || l_return_status);
175: END IF;
176:
177: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN
178: x_msg_count := l_msg_count;

Line 191: FND_LOG.STRING(l_log_procedure, L_FULL_NAME||'.end', 'At the end of the procedure. Returning x_ue_id as ' || x_ue_id);

187: -- Return the UE Id created and accomplished
188: x_ue_id := l_ue_id;
189:
190: IF (l_log_procedure >= l_log_current_level) THEN
191: FND_LOG.STRING(l_log_procedure, L_FULL_NAME||'.end', 'At the end of the procedure. Returning x_ue_id as ' || x_ue_id);
192: END IF;
193:
194: END Create_And_Accomplish_Mr;
195:

Line 248: FND_LOG.STRING(l_log_procedure, L_FULL_NAME || '.begin',

244: --Initialize API return status to success
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246:
247: IF (l_log_procedure >= l_log_current_level) THEN
248: FND_LOG.STRING(l_log_procedure, L_FULL_NAME || '.begin',
249: 'At the start of the procedure. p_unit_effectivity_id = ' || p_unit_effectivity_id ||
250: ', p_accomplishment_date = ' || p_accomplishment_date);
251: END IF;
252:

Line 258: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'l_child_ue_ids_tbl.COUNT = ' || l_child_ue_ids_tbl.COUNT);

254: FETCH get_descendant_UEs_csr BULK COLLECT INTO l_child_ue_ids_tbl;
255: CLOSE get_descendant_UEs_csr;
256:
257: IF (l_log_statement >= l_log_current_level) THEN
258: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'l_child_ue_ids_tbl.COUNT = ' || l_child_ue_ids_tbl.COUNT);
259: END IF;
260: -- Append the current (root) UE Id at the end
261: i := NVL(l_child_ue_ids_tbl.LAST, 0) + 1;
262: l_child_ue_ids_tbl(i) := p_unit_effectivity_id;

Line 268: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Processing index ' || i || ', Unit Effectivity Id = ' || l_child_ue_ids_tbl(i));

264: -- Process each Unit Effectivity in the hierarchy (order by descending LEVEL)
265: i := l_child_ue_ids_tbl.FIRST;
266: WHILE (i IS NOT NULL) LOOP
267: IF (l_log_statement >= l_log_current_level) THEN
268: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Processing index ' || i || ', Unit Effectivity Id = ' || l_child_ue_ids_tbl(i));
269: END IF;
270:
271: OPEN get_ue_dtls_csr(c_unit_effectivity_id => l_child_ue_ids_tbl(i));
272: FETCH get_ue_dtls_csr INTO l_mr_id, l_instance_id, l_ue_ovn;

Line 291: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Resetting Counters...');

287: END IF;
288:
289: IF (l_reset_counter_tbl IS NOT NULL AND l_reset_counter_tbl.COUNT > 0) THEN
290: IF (l_log_statement >= l_log_current_level) THEN
291: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Resetting Counters...');
292: END IF;
293: -- Reset all the Counters with Reset Values specified in FMP
294: l_mr_rec.mr_header_id := l_mr_id;
295: l_mr_rec.unit_effectivity_id := l_child_ue_ids_tbl(i);

Line 316: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Getting CP Counters...');

312: END IF; -- There are reset counters
313: l_reset_counter_tbl.DELETE;
314:
315: IF (l_log_statement >= l_log_current_level) THEN
316: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Getting CP Counters...');
317: END IF;
318: -- Get the Current Counter Readings for all Counters associted with the Item Instance.
319: l_return_status := AHL_COMPLETIONS_PVT.get_cp_counters(p_item_instance_id => l_instance_id,
320: p_wip_entity_id => null,

Line 330: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Updating UMP...');

326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328:
329: IF (l_log_statement >= l_log_current_level) THEN
330: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Updating UMP...');
331: END IF;
332: -- Record Accomplishment in UMP
333: l_return_status := AHL_COMPLETIONS_PVT.update_ump(p_unit_effectivity_id => l_child_ue_ids_tbl(i),
334: p_ue_object_version => l_ue_ovn,

Line 358: FND_LOG.STRING(l_log_procedure, L_FULL_NAME||'.end', 'At the end of the procedure.');

354:
355: END LOOP; -- For all Unit Effectivities
356:
357: IF (l_log_procedure >= l_log_current_level) THEN
358: FND_LOG.STRING(l_log_procedure, L_FULL_NAME||'.end', 'At the end of the procedure.');
359: END IF;
360:
361: END Accomplish_UMP;
362:

Line 482: FND_LOG.STRING(l_log_procedure, L_FULL_NAME || '.begin', 'Entering Procedure. p_accomplishment_id = ' || p_accomplishment_id ||

478:
479: -- Standard start of API savepoint
480: SAVEPOINT accomplish_osp_mrs_pvt;
481: IF (l_log_procedure >= l_log_current_level) THEN
482: FND_LOG.STRING(l_log_procedure, L_FULL_NAME || '.begin', 'Entering Procedure. p_accomplishment_id = ' || p_accomplishment_id ||
483: ', p_osp_order_line_id = ' || p_osp_order_line_id);
484: END IF;
485:
486: -- Standard call to check for call compatibility

Line 584: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Processing index ' || i || ', Accomplishment Id = ' || l_accomplishment_ids_tbl(i));

580:
581: i := l_accomplishment_ids_tbl.FIRST;
582: WHILE (i IS NOT NULL) LOOP
583: IF (l_log_statement >= l_log_current_level) THEN
584: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Processing index ' || i || ', Accomplishment Id = ' || l_accomplishment_ids_tbl(i));
585: END IF;
586: -- Retrieve details from AHL_OSP_ACCOMPLISHMENTS and lock the row for update
587: OPEN get_accomplishment_dtls_csr(c_accomplishment_id => l_accomplishment_ids_tbl(i));
588: FETCH get_accomplishment_dtls_csr INTO l_accomplishment_dtls;

Line 600: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Returned from call to Create_And_Accomplish_Mr. x_return_status = ' || l_return_status);

596: x_msg_count => l_msg_count,
597: x_msg_data => l_msg_data);
598:
599: IF (l_log_statement >= l_log_current_level) THEN
600: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Returned from call to Create_And_Accomplish_Mr. x_return_status = ' || l_return_status);
601: END IF;
602:
603: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN
604: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 612: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'About to update Accomplishments table for row with accomplishment_id ' || l_accomplishment_ids_tbl(i) ||

608: END IF;
609: END IF;
610:
611: IF (l_log_statement >= l_log_current_level) THEN
612: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'About to update Accomplishments table for row with accomplishment_id ' || l_accomplishment_ids_tbl(i) ||
613: ' : Setting UNIT_EFFECTIVITY_ID as ' || l_unit_effectivity_id);
614: END IF;
615:
616: UPDATE AHL_OSP_ACCOMPLISHMENTS

Line 633: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Accomplishment for Group MR. l_child_ue_ids_tbl.COUNT = ' || l_child_ue_ids_tbl.COUNT);

629: FETCH get_descendant_UEs_csr BULK COLLECT INTO l_child_ue_ids_tbl, l_instance_ids_tbl, l_mr_ids_tbl, l_accomp_dates_tbl;
630: CLOSE get_descendant_UEs_csr;
631: IF (l_child_ue_ids_tbl IS NOT NULL AND l_child_ue_ids_tbl.COUNT > 0) THEN
632: IF (l_log_statement >= l_log_current_level) THEN
633: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Accomplishment for Group MR. l_child_ue_ids_tbl.COUNT = ' || l_child_ue_ids_tbl.COUNT);
634: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'About to insert additional records into AHL_OSP_ACCOMPLISHMENTS.');
635: END IF;
636: FOR j IN l_child_ue_ids_tbl.FIRST..l_child_ue_ids_tbl.LAST LOOP
637: INSERT INTO AHL_OSP_ACCOMPLISHMENTS(ACCOMPLISHMENT_ID,

Line 634: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'About to insert additional records into AHL_OSP_ACCOMPLISHMENTS.');

630: CLOSE get_descendant_UEs_csr;
631: IF (l_child_ue_ids_tbl IS NOT NULL AND l_child_ue_ids_tbl.COUNT > 0) THEN
632: IF (l_log_statement >= l_log_current_level) THEN
633: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Accomplishment for Group MR. l_child_ue_ids_tbl.COUNT = ' || l_child_ue_ids_tbl.COUNT);
634: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'About to insert additional records into AHL_OSP_ACCOMPLISHMENTS.');
635: END IF;
636: FOR j IN l_child_ue_ids_tbl.FIRST..l_child_ue_ids_tbl.LAST LOOP
637: INSERT INTO AHL_OSP_ACCOMPLISHMENTS(ACCOMPLISHMENT_ID,
638: OBJECT_VERSION_NUMBER,

Line 688: FND_LOG.STRING(l_log_procedure, L_FULL_NAME || '.end', 'End Procedure');

684: p_encoded => fnd_api.g_false
685: );
686:
687: IF (l_log_procedure >= l_log_current_level) THEN
688: FND_LOG.STRING(l_log_procedure, L_FULL_NAME || '.end', 'End Procedure');
689: END IF;
690:
691: EXCEPTION
692: WHEN FND_API.G_EXC_ERROR THEN

Line 698: IF (FND_LOG.LEVEL_EXCEPTION >= l_log_current_level) THEN

694: x_return_status := FND_API.G_RET_STS_ERROR;
695: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
696: p_data => x_msg_data,
697: p_encoded => fnd_api.g_false);
698: IF (FND_LOG.LEVEL_EXCEPTION >= l_log_current_level) THEN
699: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_FULL_NAME, 'Execution Exception: ' || x_msg_data);
700: END IF;
701:
702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 699: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_FULL_NAME, 'Execution Exception: ' || x_msg_data);

695: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
696: p_data => x_msg_data,
697: p_encoded => fnd_api.g_false);
698: IF (FND_LOG.LEVEL_EXCEPTION >= l_log_current_level) THEN
699: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_FULL_NAME, 'Execution Exception: ' || x_msg_data);
700: END IF;
701:
702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
703: Rollback to accomplish_osp_mrs_pvt;

Line 709: IF (FND_LOG.LEVEL_UNEXPECTED >= l_log_current_level) THEN

705: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
706: p_data => x_msg_data,
707: p_encoded => fnd_api.g_false);
708:
709: IF (FND_LOG.LEVEL_UNEXPECTED >= l_log_current_level) THEN
710: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_FULL_NAME, 'Unexpected Exception: ' || x_msg_data);
711: END IF;
712:
713: WHEN OTHERS THEN

Line 710: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_FULL_NAME, 'Unexpected Exception: ' || x_msg_data);

706: p_data => x_msg_data,
707: p_encoded => fnd_api.g_false);
708:
709: IF (FND_LOG.LEVEL_UNEXPECTED >= l_log_current_level) THEN
710: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_FULL_NAME, 'Unexpected Exception: ' || x_msg_data);
711: END IF;
712:
713: WHEN OTHERS THEN
714: Rollback to accomplish_osp_mrs_pvt;

Line 725: IF (FND_LOG.LEVEL_UNEXPECTED >= l_log_current_level) THEN

721: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
722: p_data => x_msg_data,
723: p_encoded => fnd_api.g_false);
724:
725: IF (FND_LOG.LEVEL_UNEXPECTED >= l_log_current_level) THEN
726: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_FULL_NAME, 'Other Exception: ' || x_msg_data);
727: END IF;
728:
729: END accomplish_osp_mrs;

Line 726: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_FULL_NAME, 'Other Exception: ' || x_msg_data);

722: p_data => x_msg_data,
723: p_encoded => fnd_api.g_false);
724:
725: IF (FND_LOG.LEVEL_UNEXPECTED >= l_log_current_level) THEN
726: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_FULL_NAME, 'Other Exception: ' || x_msg_data);
727: END IF;
728:
729: END accomplish_osp_mrs;
730:

Line 815: FND_LOG.string(l_log_procedure, L_FULL_NAME||'.begin', 'Function called with p_osp_order_line_id: ' || p_osp_order_line_id);

811: --
812:
813: BEGIN
814: IF (l_log_procedure >= l_log_current_level) THEN
815: FND_LOG.string(l_log_procedure, L_FULL_NAME||'.begin', 'Function called with p_osp_order_line_id: ' || p_osp_order_line_id);
816: END IF;
817:
818: OPEN get_received_quantity_csr;
819: FETCH get_received_quantity_csr INTO l_received_quantity;

Line 824: FND_LOG.string(l_log_statement, L_FULL_NAME, 'Returned quantity for OSP Order Line is ' || l_received_quantity);

820: CLOSE get_received_quantity_csr;
821:
822: IF (l_received_quantity IS NULL OR l_received_quantity < 1) THEN
823: IF (l_log_statement >= l_log_current_level) THEN
824: FND_LOG.string(l_log_statement, L_FULL_NAME, 'Returned quantity for OSP Order Line is ' || l_received_quantity);
825: END IF;
826: -- Return True if there is no receipt
827: RETURN FND_API.G_TRUE;
828: END IF;

Line 835: FND_LOG.string(l_log_statement, L_FULL_NAME, 'Recorded instances l_instance_ids_tbl.COUNT = ' || l_instance_ids_tbl.COUNT);

831: FETCH get_recorded_instances_csr BULK COLLECT INTO l_instance_ids_tbl;
832: CLOSE get_recorded_instances_csr;
833:
834: IF (l_log_statement >= l_log_current_level) THEN
835: FND_LOG.string(l_log_statement, L_FULL_NAME, 'Recorded instances l_instance_ids_tbl.COUNT = ' || l_instance_ids_tbl.COUNT);
836: END IF;
837: IF (l_instance_ids_tbl.COUNT = 0) THEN
838: IF (l_log_statement >= l_log_current_level) THEN
839: FND_LOG.string(l_log_statement, L_FULL_NAME, 'No recorded accomplishments for the OSP Order Line.');

Line 839: FND_LOG.string(l_log_statement, L_FULL_NAME, 'No recorded accomplishments for the OSP Order Line.');

835: FND_LOG.string(l_log_statement, L_FULL_NAME, 'Recorded instances l_instance_ids_tbl.COUNT = ' || l_instance_ids_tbl.COUNT);
836: END IF;
837: IF (l_instance_ids_tbl.COUNT = 0) THEN
838: IF (l_log_statement >= l_log_current_level) THEN
839: FND_LOG.string(l_log_statement, L_FULL_NAME, 'No recorded accomplishments for the OSP Order Line.');
840: END IF;
841: -- Return True if there is no recorded accomplishments
842: RETURN FND_API.G_TRUE;
843: END IF;

Line 850: FND_LOG.string(l_log_statement, L_FULL_NAME, 'Received instance for OSP Order Line is ' || l_received_instance_id);

846: OPEN get_received_instance_csr;
847: FETCH get_received_instance_csr INTO l_received_instance_id;
848: CLOSE get_received_instance_csr;
849: IF (l_log_statement >= l_log_current_level) THEN
850: FND_LOG.string(l_log_statement, L_FULL_NAME, 'Received instance for OSP Order Line is ' || l_received_instance_id);
851: END IF;
852: IF (l_received_instance_id IS NULL) THEN
853: -- Return True if there is no receipt
854: RETURN FND_API.G_TRUE;

Line 862: FND_LOG.string(l_log_statement, L_FULL_NAME, 'Received Instances l_rcv_instance_ids_tbl.COUNT = ' || l_rcv_instance_ids_tbl.COUNT);

858: OPEN get_instance_descendants_csr(l_received_instance_id);
859: FETCH get_instance_descendants_csr BULK COLLECT INTO l_rcv_instance_ids_tbl;
860: CLOSE get_instance_descendants_csr;
861: IF (l_log_statement >= l_log_current_level) THEN
862: FND_LOG.string(l_log_statement, L_FULL_NAME, 'Received Instances l_rcv_instance_ids_tbl.COUNT = ' || l_rcv_instance_ids_tbl.COUNT);
863: END IF;
864:
865: IF (l_rcv_instance_ids_tbl.COUNT = 1) THEN
866: IF ((l_instance_ids_tbl.COUNT = 1) AND (l_instance_ids_tbl(l_instance_ids_tbl.FIRST)) = l_received_instance_id) THEN

Line 888: FND_LOG.string(l_log_statement, L_FULL_NAME, 'The instance ' || l_curr_inst_id || ' was not received.');

884: j := l_rcv_instance_ids_tbl.NEXT(j);
885: END LOOP; -- For all received instances
886: IF (l_found_flag = false) THEN
887: IF (l_log_statement >= l_log_current_level) THEN
888: FND_LOG.string(l_log_statement, L_FULL_NAME, 'The instance ' || l_curr_inst_id || ' was not received.');
889: END IF;
890: RETURN FND_API.G_FALSE;
891: END IF;
892: