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_MSG_PUB

Line 130: FND_MSG_PUB.Initialize;

126: SAVEPOINT Calc_Contract_Exp_Date_Pvt;
127:
128: -- Initialize message list if p_init_msg_list is set to TRUE
129: IF FND_API.To_Boolean(p_init_msg_list) THEN
130: FND_MSG_PUB.Initialize;
131: END IF;
132:
133: -- Initialize API return status to success
134: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 148: FND_MSG_PUB.ADD;

144:
145: -- Check for Required Parameters
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,

Line 176: FND_MSG_PUB.ADD;

172: OPEN get_cont_details (l_warranty_contract_id);
173: FETCH get_cont_details INTO l_cont_start_date, l_cont_end_date,l_cont_exp_type,l_cont_ovn,l_item_instance_id ;
174: IF (get_cont_details%NOTFOUND) THEN
175: FND_MESSAGE.Set_Name('AHL','AHL_WARRANTY_CNTRCT_ID_INVALID');
176: FND_MSG_PUB.ADD;
177: CLOSE get_cont_details;
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: END IF;
180: CLOSE get_cont_details;

Line 284: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

280: EXCEPTION
281: WHEN FND_API.G_EXC_ERROR THEN
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: ROLLBACK TO Calc_Contract_Exp_Date_Pvt;
284: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
285: p_data => x_msg_data,
286: p_encoded => fnd_api.g_false);
287:
288:

Line 292: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
291: ROLLBACK TO Calc_Contract_Exp_Date_Pvt;
292: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
293: p_data => x_msg_data,
294: p_encoded => fnd_api.g_false);
295:
296:

Line 300: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

296:
297: WHEN OTHERS THEN
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: ROLLBACK TO Calc_Contract_Exp_Date_Pvt;
300: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
301: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
302: p_procedure_name => 'Calc_Contract_Exp_Date',
303: p_error_text => SUBSTR(SQLERRM,1,500));
304: END IF;

Line 301: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

297: WHEN OTHERS THEN
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: ROLLBACK TO Calc_Contract_Exp_Date_Pvt;
300: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
301: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
302: p_procedure_name => 'Calc_Contract_Exp_Date',
303: p_error_text => SUBSTR(SQLERRM,1,500));
304: END IF;
305: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 305: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

301: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
302: p_procedure_name => 'Calc_Contract_Exp_Date',
303: p_error_text => SUBSTR(SQLERRM,1,500));
304: END IF;
305: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
306: p_data => x_msg_data,
307: p_encoded => fnd_api.g_false);
308:
309: END Calc_Contract_Exp_Date;

Line 358: FND_MSG_PUB.Initialize;

354: -- Standard start of API savepoint
355: SAVEPOINT Calc_Contract_Exp_Date_CP;
356:
357: -- 1. Initialize error message stack by default
358: FND_MSG_PUB.Initialize;
359:
360: -- initialize return status to success
361: retcode := 0;
362:

Line 366: errbuf := FND_MSG_PUB.Get;

362:
363: -- Standard call to check for call compatibility
364: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
365: retcode := 2;
366: errbuf := FND_MSG_PUB.Get;
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: END IF;
369:
370: -- 2. Dump all input parameters

Line 394: l_msg_count := FND_MSG_PUB.Count_Msg;

390: x_msg_count => l_msg_count,
391: x_msg_data => l_msg_data);
392:
393:
394: l_msg_count := FND_MSG_PUB.Count_Msg;
395: IF (l_msg_count > 0) THEN
396: fnd_file.put_line(fnd_file.log, 'Following error occured while calculating Warranty Expiration...');
397: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
398: RAISE FND_API.G_EXC_ERROR;

Line 417: fnd_msg_pub.get( p_msg_index => i,

413: retcode := 2;
414: errbuf := l_api_name || ':ERR_EXP:' || substrb(sqlerrm,1,60);
415: FOR i IN 1..l_msg_count
416: LOOP
417: fnd_msg_pub.get( p_msg_index => i,
418: p_encoded => FND_API.G_FALSE,
419: p_data => l_err_msg,
420: p_msg_index_out => l_msg_index_out);
421:

Line 430: l_msg_count := Fnd_Msg_Pub.count_msg;

426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
427: ROLLBACK TO Calc_Contract_Exp_Date_CP;
428: retcode := 2;
429: errbuf := l_api_name || ':ERR_UNEXP:' || substrb(sqlerrm,1,60);
430: l_msg_count := Fnd_Msg_Pub.count_msg;
431: FOR i IN 1..l_msg_count
432: LOOP
433: fnd_msg_pub.get( p_msg_index => i,
434: p_encoded => FND_API.G_FALSE,

Line 433: fnd_msg_pub.get( p_msg_index => i,

429: errbuf := l_api_name || ':ERR_UNEXP:' || substrb(sqlerrm,1,60);
430: l_msg_count := Fnd_Msg_Pub.count_msg;
431: FOR i IN 1..l_msg_count
432: LOOP
433: fnd_msg_pub.get( p_msg_index => i,
434: p_encoded => FND_API.G_FALSE,
435: p_data => l_err_msg,
436: p_msg_index_out => l_msg_index_out);
437:

Line 446: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

442: WHEN OTHERS THEN
443: ROLLBACK TO Calc_Contract_Exp_Date_CP;
444: retcode := 2;
445: errbuf := l_api_name || ':EXP_OTH:' || substrb(sqlerrm,1,60);
446: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
447: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
448: p_procedure_name => 'Calc_Contract_Exp_Date_CP',
449: p_error_text => SUBSTR(SQLERRM,1,500));
450: END IF;

Line 447: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

443: ROLLBACK TO Calc_Contract_Exp_Date_CP;
444: retcode := 2;
445: errbuf := l_api_name || ':EXP_OTH:' || substrb(sqlerrm,1,60);
446: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
447: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
448: p_procedure_name => 'Calc_Contract_Exp_Date_CP',
449: p_error_text => SUBSTR(SQLERRM,1,500));
450: END IF;
451: l_msg_count := Fnd_Msg_Pub.count_msg;

Line 451: l_msg_count := Fnd_Msg_Pub.count_msg;

447: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
448: p_procedure_name => 'Calc_Contract_Exp_Date_CP',
449: p_error_text => SUBSTR(SQLERRM,1,500));
450: END IF;
451: l_msg_count := Fnd_Msg_Pub.count_msg;
452: FOR i IN 1..l_msg_count
453: LOOP
454: fnd_msg_pub.get( p_msg_index => i,
455: p_encoded => FND_API.G_FALSE,

Line 454: fnd_msg_pub.get( p_msg_index => i,

450: END IF;
451: l_msg_count := Fnd_Msg_Pub.count_msg;
452: FOR i IN 1..l_msg_count
453: LOOP
454: fnd_msg_pub.get( p_msg_index => i,
455: p_encoded => FND_API.G_FALSE,
456: p_data => l_err_msg,
457: p_msg_index_out => l_msg_index_out);
458:

Line 518: FND_MSG_PUB.Initialize;

514: -- Standard start of API savepoint
515: SAVEPOINT Disable_Templates_CP_PVT;
516:
517: -- 1. Initialize error message stack by default
518: FND_MSG_PUB.Initialize;
519:
520: -- initialize return status to success
521: retcode := 0;
522:

Line 526: errbuf := FND_MSG_PUB.Get;

522:
523: -- Standard call to check for call compatibility
524: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
525: retcode := 2;
526: errbuf := FND_MSG_PUB.Get;
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: END IF;
529:
530: -- 2. Dump all input parameters

Line 570: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

566: WHEN OTHERS THEN
567: ROLLBACK TO Disable_Templates_CP_PVT;
568: retcode := 2;
569: errbuf := l_api_name || ':EXP_OTH:' || substrb(sqlerrm,1,60);
570: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
571: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
572: p_procedure_name => 'Disable_Templates_CP',
573: p_error_text => SUBSTR(SQLERRM,1,500));
574: END IF;

Line 571: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

567: ROLLBACK TO Disable_Templates_CP_PVT;
568: retcode := 2;
569: errbuf := l_api_name || ':EXP_OTH:' || substrb(sqlerrm,1,60);
570: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
571: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
572: p_procedure_name => 'Disable_Templates_CP',
573: p_error_text => SUBSTR(SQLERRM,1,500));
574: END IF;
575: l_msg_count := Fnd_Msg_Pub.count_msg;

Line 575: l_msg_count := Fnd_Msg_Pub.count_msg;

571: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
572: p_procedure_name => 'Disable_Templates_CP',
573: p_error_text => SUBSTR(SQLERRM,1,500));
574: END IF;
575: l_msg_count := Fnd_Msg_Pub.count_msg;
576: FOR i IN 1..l_msg_count
577: LOOP
578: fnd_msg_pub.get( p_msg_index => i,
579: p_encoded => FND_API.G_FALSE,

Line 578: fnd_msg_pub.get( p_msg_index => i,

574: END IF;
575: l_msg_count := Fnd_Msg_Pub.count_msg;
576: FOR i IN 1..l_msg_count
577: LOOP
578: fnd_msg_pub.get( p_msg_index => i,
579: p_encoded => FND_API.G_FALSE,
580: p_data => l_err_msg,
581: p_msg_index_out => l_msg_index_out);
582:

Line 664: FND_MSG_PUB.Initialize;

660: SAVEPOINT Disable_Tmpls_For_Vendor_Pvt;
661:
662: -- Initialize message list if p_init_msg_list is set to TRUE
663: IF FND_API.To_Boolean(p_init_msg_list) THEN
664: FND_MSG_PUB.Initialize;
665: END IF;
666:
667: -- Initialize API return status to success
668: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 682: FND_MSG_PUB.ADD;

678:
679: -- Check for Required Parameters
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,

Line 739: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

735: EXCEPTION
736: WHEN FND_API.G_EXC_ERROR THEN
737: x_return_status := FND_API.G_RET_STS_ERROR;
738: ROLLBACK TO Disable_Tmpls_For_Vendor_Pvt;
739: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
740: p_data => x_msg_data,
741: p_encoded => fnd_api.g_false);
742:
743:

Line 747: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

743:
744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746: ROLLBACK TO Disable_Tmpls_For_Vendor_Pvt;
747: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
748: p_data => x_msg_data,
749: p_encoded => fnd_api.g_false);
750:
751:

Line 755: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

751:
752: WHEN OTHERS THEN
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
754: ROLLBACK TO Disable_Tmpls_For_Vendor_Pvt;
755: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
756: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
757: p_procedure_name => 'Disable_Templates_For_Vendor',
758: p_error_text => SUBSTR(SQLERRM,1,500));
759: END IF;

Line 756: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

752: WHEN OTHERS THEN
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
754: ROLLBACK TO Disable_Tmpls_For_Vendor_Pvt;
755: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
756: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
757: p_procedure_name => 'Disable_Templates_For_Vendor',
758: p_error_text => SUBSTR(SQLERRM,1,500));
759: END IF;
760: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 760: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

756: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
757: p_procedure_name => 'Disable_Templates_For_Vendor',
758: p_error_text => SUBSTR(SQLERRM,1,500));
759: END IF;
760: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
761: p_data => x_msg_data,
762: p_encoded => fnd_api.g_false);
763:
764: END Disable_Templates_For_Vendor;

Line 869: FND_MSG_PUB.Initialize;

865: SAVEPOINT Process_Attachments_Pvt;
866:
867: -- Initialize message list if p_init_msg_list is set to TRUE
868: IF FND_API.To_Boolean(p_init_msg_list) THEN
869: FND_MSG_PUB.Initialize;
870: END IF;
871:
872: -- Initialize API return status to success
873: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 887: FND_MSG_PUB.ADD;

883:
884: -- Check for Required Parameters
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,

Line 924: FND_MSG_PUB.ADD;

920:
921: -- Copy from p_copy_from_pk
922: IF(p_copy_from_pk IS NULL OR p_copy_from_entity IS NULL)THEN
923: FND_MESSAGE.Set_Name('AHL','AHL_SW_ATTCH_INPUT_INV');
924: FND_MSG_PUB.ADD;
925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
926: END IF;
927:
928: FOR csr_index in attachment_csr(p_copy_from_entity,p_copy_from_pk)

Line 1105: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

1101: EXCEPTION
1102: WHEN FND_API.G_EXC_ERROR THEN
1103: x_return_status := FND_API.G_RET_STS_ERROR;
1104: ROLLBACK TO Process_Attachments_Pvt;
1105: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1106: p_data => x_msg_data,
1107: p_encoded => fnd_api.g_false);
1108:
1109:

Line 1113: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

1109:
1110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1112: ROLLBACK TO Process_Attachments_Pvt;
1113: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1114: p_data => x_msg_data,
1115: p_encoded => fnd_api.g_false);
1116:
1117:

Line 1121: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1117:
1118: WHEN OTHERS THEN
1119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1120: ROLLBACK TO Process_Attachments_Pvt;
1121: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1122: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1123: p_procedure_name => 'Process_Attachments',
1124: p_error_text => SUBSTR(SQLERRM,1,500));
1125: END IF;

Line 1122: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

1118: WHEN OTHERS THEN
1119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1120: ROLLBACK TO Process_Attachments_Pvt;
1121: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1122: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1123: p_procedure_name => 'Process_Attachments',
1124: p_error_text => SUBSTR(SQLERRM,1,500));
1125: END IF;
1126: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 1126: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

1122: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1123: p_procedure_name => 'Process_Attachments',
1124: p_error_text => SUBSTR(SQLERRM,1,500));
1125: END IF;
1126: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1127: p_data => x_msg_data,
1128: p_encoded => fnd_api.g_false);
1129:
1130: END Process_Attachments;

Line 1197: FND_MSG_PUB.Initialize;

1193: END IF;
1194:
1195: -- Initialize message list if p_init_msg_list is set to TRUE
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(

Line 1224: FND_MSG_PUB.ADD;

1220: -- validate entered data
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',

Line 1237: FND_MSG_PUB.ADD;

1233:
1234: -- validate that notes cant not be null
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,

Line 1250: FND_MSG_PUB.ADD;

1246: END IF;
1247:
1248: IF p_trunover_notes_tbl(i).employee_name IS NULL THEN
1249: FND_MESSAGE.set_name('AHL','AHL_PRD_EMP_NULL_TRNTS');
1250: FND_MSG_PUB.ADD;
1251: END IF;
1252:
1253: -- add notes if no messages
1254: IF(FND_MSG_PUB.count_msg = 0)THEN

Line 1254: IF(FND_MSG_PUB.count_msg = 0)THEN

1250: FND_MSG_PUB.ADD;
1251: END IF;
1252:
1253: -- add notes if no messages
1254: IF(FND_MSG_PUB.count_msg = 0)THEN
1255: JTF_NOTES_PUB.Create_note(
1256: p_api_version => 1.0,
1257: p_init_msg_list => FND_API.G_FALSE,
1258: p_commit => FND_API.G_FALSE,

Line 1275: x_msg_count := FND_MSG_PUB.count_msg;

1271:
1272: END LOOP;
1273:
1274: -- Check Error Message stack.
1275: x_msg_count := FND_MSG_PUB.count_msg;
1276: IF x_msg_count > 0 THEN
1277: RAISE FND_API.G_EXC_ERROR;
1278: END IF;
1279:

Line 1286: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1282: COMMIT WORK;
1283: END IF;
1284:
1285: -- Standard call to get message count and if count is 1, get message info
1286: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1287: p_data => x_msg_data,
1288: p_encoded => fnd_api.g_false
1289: );
1290:

Line 1309: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1305:
1306: WHEN FND_API.G_EXC_ERROR THEN
1307: Rollback to Insert_Turnover_Notes;
1308: x_return_status := FND_API.G_RET_STS_ERROR;
1309: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1310: p_data => x_msg_data,
1311: p_encoded => fnd_api.g_false);
1312:
1313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1316: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1312:
1313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1314: Rollback to Insert_Turnover_Notes;
1315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1316: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1317: p_data => x_msg_data,
1318: p_encoded => fnd_api.g_false);
1319:
1320: WHEN OTHERS THEN

Line 1323: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1319:
1320: WHEN OTHERS THEN
1321: Rollback to Insert_Turnover_Notes;
1322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1323: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1324: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1325: p_procedure_name => l_api_name,
1326: p_error_text => SUBSTRB(SQLERRM,1,500));
1327: END IF;

Line 1324: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

1320: WHEN OTHERS THEN
1321: Rollback to Insert_Turnover_Notes;
1322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1323: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1324: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1325: p_procedure_name => l_api_name,
1326: p_error_text => SUBSTRB(SQLERRM,1,500));
1327: END IF;
1328: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1328: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1324: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1325: p_procedure_name => l_api_name,
1326: p_error_text => SUBSTRB(SQLERRM,1,500));
1327: END IF;
1328: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1329: p_data => x_msg_data,
1330: p_encoded => fnd_api.g_false);
1331: END Insert_Turnover_Notes;
1332: