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_WARRANTY_UTILS_PVT dependencies on FND_LOG

Line 11: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

7:
8: ------------------------------------
9: -- Common constants and variables --
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: l_log_error NUMBER := fnd_log.level_error;
15: l_log_unexpected NUMBER := fnd_log.level_unexpected;

Line 12: l_log_statement NUMBER := fnd_log.level_statement;

8: ------------------------------------
9: -- Common constants and variables --
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: l_log_error NUMBER := fnd_log.level_error;
15: l_log_unexpected NUMBER := fnd_log.level_unexpected;
16: -----------------------------------------------------------------

Line 13: l_log_procedure NUMBER := fnd_log.level_procedure;

9: -- Common constants and variables --
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: l_log_error NUMBER := fnd_log.level_error;
15: l_log_unexpected NUMBER := fnd_log.level_unexpected;
16: -----------------------------------------------------------------
17:

Line 14: l_log_error NUMBER := fnd_log.level_error;

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: l_log_error NUMBER := fnd_log.level_error;
15: l_log_unexpected NUMBER := fnd_log.level_unexpected;
16: -----------------------------------------------------------------
17:
18: -------------------------------------------------------------------

Line 15: l_log_unexpected NUMBER := fnd_log.level_unexpected;

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: l_log_error NUMBER := fnd_log.level_error;
15: l_log_unexpected NUMBER := fnd_log.level_unexpected;
16: -----------------------------------------------------------------
17:
18: -------------------------------------------------------------------
19: -- Procedure name : Calc_Contract_Exp_Date

Line 119: fnd_log.string(l_log_procedure,L_DEBUG_KEY||'.begin','At the start of the PLSQL procedure');

115:
116: BEGIN
117:
118: IF (l_log_procedure >= l_log_current_level) THEN
119: fnd_log.string(l_log_procedure,L_DEBUG_KEY||'.begin','At the start of the PLSQL procedure');
120: END IF;
121:
122: -- initialize return status.
123: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 150: fnd_log.string

146: IF(p_warranty_contract_id_tbl.COUNT < 1) THEN
147: FND_MESSAGE.Set_Name('AHL','AHL_WARRANTY_CNTRCT_ID_MISS');
148: FND_MSG_PUB.ADD;
149: IF (l_log_unexpected >= l_log_current_level)THEN
150: fnd_log.string
151: (
152: l_log_unexpected,
153: 'ahl.plsql.Calc_Contract_Exp_Date',
154: 'For this API flow, Warranty Contract Id is mandatory but found null in input '

Line 161: fnd_log.string(l_log_statement,L_DEBUG_KEY,'p_warranty_contract_id_tbl.COUNT : '||p_warranty_contract_id_tbl.COUNT);

157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158: END IF;
159:
160: IF (l_log_statement >= l_log_current_level) THEN
161: fnd_log.string(l_log_statement,L_DEBUG_KEY,'p_warranty_contract_id_tbl.COUNT : '||p_warranty_contract_id_tbl.COUNT);
162: END IF;
163:
164: -- Logic
165: l_warranty_contract_id_tbl := p_warranty_contract_id_tbl;

Line 230: fnd_log.string(

226:
227: END IF; -- l_warranty_counter_tbl.COUNT > 0
228:
229: IF (l_log_statement >= l_log_current_level)THEN
230: fnd_log.string(
231: l_log_statement,
232: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
233: ' Contract End Date = '|| l_cont_end_date ||' and end date from counter = '|| l_least_ctr_exp_date
234: );

Line 252: fnd_log.string(

248: END IF;
249:
250:
251: IF (l_log_statement >= l_log_current_level)THEN
252: fnd_log.string(
253: l_log_statement,
254: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
255: 'Before updating a row in AHL_WARRANTY_CONTRACTS_B. where contract id = '|| l_warranty_contract_id ||' and new expiration date = '|| l_exp_date
256: );

Line 275: fnd_log.string ( l_log_procedure,L_DEBUG_KEY ||'.end','At the end of PLSQL procedure');

271: COMMIT WORK;
272: END IF;
273:
274: IF (l_log_procedure >= l_log_current_level)THEN
275: fnd_log.string ( l_log_procedure,L_DEBUG_KEY ||'.end','At the end of PLSQL procedure');
276: END IF;
277:
278:
279:

Line 656: fnd_log.string(l_log_procedure,L_DEBUG_KEY||'.begin','At the start of the PLSQL procedure, count = '||p_warranty_vendor_id_tbl.COUNT);

652:
653: BEGIN
654:
655: IF (l_log_procedure >= l_log_current_level) THEN
656: fnd_log.string(l_log_procedure,L_DEBUG_KEY||'.begin','At the start of the PLSQL procedure, count = '||p_warranty_vendor_id_tbl.COUNT);
657: END IF;
658:
659: -- Standard start of API savepoint
660: SAVEPOINT Disable_Tmpls_For_Vendor_Pvt;

Line 684: fnd_log.string

680: IF(p_warranty_vendor_id_tbl.COUNT < 1) THEN
681: FND_MESSAGE.Set_Name('AHL','AHL_SW_VENDOR_ID_NULL');
682: FND_MSG_PUB.ADD;
683: IF (l_log_unexpected >= l_log_current_level)THEN
684: fnd_log.string
685: (
686: l_log_unexpected,
687: 'ahl.plsql.Disable_Templates_For_Vendor',
688: 'For this API flow, Vendor Id in table is mandatory but found null in input '

Line 695: fnd_log.string(l_log_statement,L_DEBUG_KEY,'p_warranty_vendor_id count : '||p_warranty_vendor_id_tbl.COUNT);

691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
692: END IF;
693:
694: IF (l_log_statement >= l_log_current_level) THEN
695: fnd_log.string(l_log_statement,L_DEBUG_KEY,'p_warranty_vendor_id count : '||p_warranty_vendor_id_tbl.COUNT);
696: END IF;
697:
698: -- Logic
699: FORALL i in p_warranty_vendor_id_tbl.first .. p_warranty_vendor_id_tbl.last

Line 731: fnd_log.string ( l_log_procedure,L_DEBUG_KEY ||'.end','At the end of PLSQL procedure');

727: COMMIT WORK;
728: END IF;
729:
730: IF (l_log_procedure >= l_log_current_level)THEN
731: fnd_log.string ( l_log_procedure,L_DEBUG_KEY ||'.end','At the end of PLSQL procedure');
732: END IF;
733:
734:
735: EXCEPTION

Line 861: fnd_log.string(l_log_procedure,L_DEBUG_KEY||'.begin','At the start of the PLSQL procedure');

857:
858: BEGIN
859:
860: IF (l_log_procedure >= l_log_current_level) THEN
861: fnd_log.string(l_log_procedure,L_DEBUG_KEY||'.begin','At the start of the PLSQL procedure');
862: END IF;
863:
864: -- Standard start of API savepoint
865: SAVEPOINT Process_Attachments_Pvt;

Line 889: fnd_log.string

885: IF(p_dml_operation IS NULL OR p_entity_name IS NULL OR p_pk1_value IS NULL) THEN
886: FND_MESSAGE.Set_Name('AHL','AHL_SW_ATTCH_INPUT_INV');
887: FND_MSG_PUB.ADD;
888: IF (l_log_unexpected >= l_log_current_level)THEN
889: fnd_log.string
890: (
891: l_log_unexpected,
892: 'ahl.plsql.Process_Attachments',
893: 'For this API flow, mandatory input are p_entity_name = ' || p_entity_name || ' p_dml_operation = '||p_dml_operation||' p_pk1_value = '||p_pk1_value

Line 900: fnd_log.string(l_log_statement,L_DEBUG_KEY,'mandatory input are p_entity_name = ' || p_entity_name ||

896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
897: END IF;
898:
899: IF (l_log_statement >= l_log_current_level) THEN
900: fnd_log.string(l_log_statement,L_DEBUG_KEY,'mandatory input are p_entity_name = ' || p_entity_name ||
901: ' p_dml_operation = '||p_dml_operation||' p_pk1_value = '||p_pk1_value || ' p_copy_from_pk = ' || p_copy_from_pk ||
902: ' p_copy_from_entity = '||p_copy_from_entity);
903: END IF;
904:

Line 959: fnd_log.string(l_log_statement,L_DEBUG_KEY,'JKJ, fetched values are : csr_index.document_id = ' || csr_index.document_id ||

955: l_media_id := null;
956: END IF;
957:
958: IF (l_log_statement >= l_log_current_level) THEN
959: fnd_log.string(l_log_statement,L_DEBUG_KEY,'JKJ, fetched values are : csr_index.document_id = ' || csr_index.document_id ||
960: ' document_rec.media_id = '||document_rec.media_id||' document_rec.url = '||document_rec.url || ' document_rec.title = ' || document_rec.title ||
961: ' csr_index.datatype_id = '||csr_index.datatype_id);
962: END IF;
963:

Line 1036: fnd_log.string(l_log_statement,L_DEBUG_KEY,'JKJ, After insersion : l_doc_id = ' || l_doc_id || ' l_attch_doc_id = '||l_attch_doc_id||' document_rec.image_type = '||document_rec.image_type );

1032: X_url =>document_rec.url,
1033: X_title =>document_rec.title);
1034:
1035: IF (l_log_statement >= l_log_current_level) THEN
1036: fnd_log.string(l_log_statement,L_DEBUG_KEY,'JKJ, After insersion : l_doc_id = ' || l_doc_id || ' l_attch_doc_id = '||l_attch_doc_id||' document_rec.image_type = '||document_rec.image_type );
1037: END IF;
1038:
1039: -- datatype_id = 1 for Short Text (Taken care in FND_DOCUMENTS_PKG.Insert_Row if Media_Id is passed)
1040: -- datatype_id = 5 for url (Taken care directly if url is passed)

Line 1097: fnd_log.string ( l_log_procedure,L_DEBUG_KEY ||'.end','At the end of PLSQL procedure');

1093: COMMIT WORK;
1094: END IF;
1095:
1096: IF (l_log_procedure >= l_log_current_level)THEN
1097: fnd_log.string ( l_log_procedure,L_DEBUG_KEY ||'.end','At the end of PLSQL procedure');
1098: END IF;
1099:
1100:
1101: EXCEPTION

Line 1180: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1176: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Turnover_Notes';
1177:
1178: BEGIN
1179:
1180: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1181: fnd_log.string (fnd_log.level_procedure,
1182: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes.begin',
1183: 'At the start of PLSQL procedure'
1184: );

Line 1181: fnd_log.string (fnd_log.level_procedure,

1177:
1178: BEGIN
1179:
1180: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1181: fnd_log.string (fnd_log.level_procedure,
1182: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes.begin',
1183: 'At the start of PLSQL procedure'
1184: );
1185: END IF;

Line 1200: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1196: IF FND_API.To_Boolean( p_init_msg_list) THEN
1197: FND_MSG_PUB.Initialize;
1198: END IF;
1199:
1200: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1201: fnd_log.string(
1202: fnd_log.level_statement,
1203: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes',
1204: 'p_init_message_list : ' || p_init_msg_list

Line 1201: fnd_log.string(

1197: FND_MSG_PUB.Initialize;
1198: END IF;
1199:
1200: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1201: fnd_log.string(
1202: fnd_log.level_statement,
1203: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes',
1204: 'p_init_message_list : ' || p_init_msg_list
1205: );

Line 1202: fnd_log.level_statement,

1198: END IF;
1199:
1200: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1201: fnd_log.string(
1202: fnd_log.level_statement,
1203: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes',
1204: 'p_init_message_list : ' || p_init_msg_list
1205: );
1206:

Line 1207: fnd_log.string(

1203: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes',
1204: 'p_init_message_list : ' || p_init_msg_list
1205: );
1206:
1207: fnd_log.string(
1208: fnd_log.level_statement,
1209: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes',
1210: 'p_commit : ' || p_commit
1211: );

Line 1208: fnd_log.level_statement,

1204: 'p_init_message_list : ' || p_init_msg_list
1205: );
1206:
1207: fnd_log.string(
1208: fnd_log.level_statement,
1209: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes',
1210: 'p_commit : ' || p_commit
1211: );
1212:

Line 1225: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1221: IF(trunc(p_trunover_notes_tbl(i).entered_date) > trunc(SYSDATE))THEN
1222: FND_MESSAGE.Set_Name('AHL','AHL_PRD_WO_NOTES_INV_ENT_DT');
1223: FND_MESSAGE.Set_Token('ENTERED_DATE',p_trunover_notes_tbl(i).entered_date);
1224: FND_MSG_PUB.ADD;
1225: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1226: fnd_log.string(
1227: fnd_log.level_error,
1228: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes',
1229: 'Invalid enterded date' || to_char(p_trunover_notes_tbl(i).entered_date)

Line 1226: fnd_log.string(

1222: FND_MESSAGE.Set_Name('AHL','AHL_PRD_WO_NOTES_INV_ENT_DT');
1223: FND_MESSAGE.Set_Token('ENTERED_DATE',p_trunover_notes_tbl(i).entered_date);
1224: FND_MSG_PUB.ADD;
1225: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1226: fnd_log.string(
1227: fnd_log.level_error,
1228: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes',
1229: 'Invalid enterded date' || to_char(p_trunover_notes_tbl(i).entered_date)
1230: );

Line 1227: fnd_log.level_error,

1223: FND_MESSAGE.Set_Token('ENTERED_DATE',p_trunover_notes_tbl(i).entered_date);
1224: FND_MSG_PUB.ADD;
1225: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1226: fnd_log.string(
1227: fnd_log.level_error,
1228: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes',
1229: 'Invalid enterded date' || to_char(p_trunover_notes_tbl(i).entered_date)
1230: );
1231: END IF;

Line 1239: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1235: IF(p_trunover_notes_tbl(i).notes IS NULL)THEN
1236: FND_MESSAGE.Set_Name('AHL','AHL_PRD_WO_NOTES_INV_NOTES_NLL');
1237: FND_MSG_PUB.ADD;
1238:
1239: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1240: fnd_log.string(
1241: fnd_log.level_error,
1242: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes',
1243: 'Invalid enterded date' || to_char(p_trunover_notes_tbl(i).entered_date)

Line 1240: fnd_log.string(

1236: FND_MESSAGE.Set_Name('AHL','AHL_PRD_WO_NOTES_INV_NOTES_NLL');
1237: FND_MSG_PUB.ADD;
1238:
1239: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1240: fnd_log.string(
1241: fnd_log.level_error,
1242: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes',
1243: 'Invalid enterded date' || to_char(p_trunover_notes_tbl(i).entered_date)
1244: );

Line 1241: fnd_log.level_error,

1237: FND_MSG_PUB.ADD;
1238:
1239: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1240: fnd_log.string(
1241: fnd_log.level_error,
1242: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes',
1243: 'Invalid enterded date' || to_char(p_trunover_notes_tbl(i).entered_date)
1244: );
1245: END IF;

Line 1295: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1291: IF(x_msg_count > 0 )THEN
1292: RAISE FND_API.G_EXC_ERROR;
1293: END IF;
1294:
1295: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1296: fnd_log.string(
1297: fnd_log.level_procedure,
1298: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes.end',
1299: 'At the end of PLSQL procedure'

Line 1296: fnd_log.string(

1292: RAISE FND_API.G_EXC_ERROR;
1293: END IF;
1294:
1295: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1296: fnd_log.string(
1297: fnd_log.level_procedure,
1298: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes.end',
1299: 'At the end of PLSQL procedure'
1300: );

Line 1297: fnd_log.level_procedure,

1293: END IF;
1294:
1295: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1296: fnd_log.string(
1297: fnd_log.level_procedure,
1298: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes.end',
1299: 'At the end of PLSQL procedure'
1300: );
1301: