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_PRD_PRINT_PVT dependencies on FND_MSG_PUB

Line 488: FND_MSG_PUB.initialize;

484: END IF;
485:
486: -- Initialize message list if p_init_msg_list is set to TRUE.
487: IF FND_API.to_boolean(p_init_msg_list) THEN
488: FND_MSG_PUB.initialize;
489: END IF;
490:
491: -- Open a temporary lob for merging the contents.
492: dbms_lob.createTemporary( l_merged_lob, true );

Line 1074: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

1070: 'xml data ->'||dbms_lob.substr(x_xml_data, dbms_lob.getlength(x_xml_data), 1)
1071: );
1072: END IF;
1073:
1074: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1075: THEN
1076: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1077: END IF;
1078:

Line 1076: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);

1072: END IF;
1073:
1074: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1075: THEN
1076: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1077: END IF;
1078:
1079: Fnd_Msg_Pub.count_and_get (
1080: p_encoded => Fnd_Api.g_false,

Line 1079: Fnd_Msg_Pub.count_and_get (

1075: THEN
1076: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1077: END IF;
1078:
1079: Fnd_Msg_Pub.count_and_get (
1080: p_encoded => Fnd_Api.g_false,
1081: p_count => x_msg_count,
1082: p_data => x_msg_data
1083: );

Line 1274: FND_MSG_PUB.Initialize;

1270: -- this step is not required. peforming since was not getting the output.
1271: -- dbms_application_info.set_client_info('600');
1272:
1273: -- Initialize error message stack by default
1274: FND_MSG_PUB.Initialize;
1275:
1276: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
1277: fnd_file.put_line(fnd_file.log, 'API inputs p_api_version -> '||p_api_version);
1278: fnd_file.put_line(fnd_file.log, 'API inputs p_visit_id -> '||p_visit_id);

Line 1383: l_msg_count := FND_MSG_PUB.Count_Msg;

1379: l_clob_size := l_clob_size - l_chunk_size;
1380: l_offset := l_offset + l_chunk_size;
1381: END LOOP;
1382:
1383: l_msg_count := FND_MSG_PUB.Count_Msg;
1384: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1385: THEN
1386: retcode := 2; -- error based only on return status
1387: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS)

Line 1498: FND_MSG_PUB.initialize;

1494: END IF;
1495:
1496: -- Initialize message list if p_init_msg_list is set to TRUE.
1497: IF FND_API.to_boolean(p_init_msg_list) THEN
1498: FND_MSG_PUB.initialize;
1499: END IF;
1500:
1501: IF (l_log_statement >= l_log_current_level)THEN
1502: fnd_log.string(

Line 1512: FND_MSG_PUB.ADD;

1508:
1509: -- Baisc Validation
1510: IF(p_operation_flag IS NULL) THEN
1511: FND_MESSAGE.Set_Name('AHL','AHL_PRD_JCG_DML_FLAG_NULL');
1512: FND_MSG_PUB.ADD;
1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1514: END IF;
1515:
1516: IF (p_status_code IS NULL) THEN

Line 1527: FND_MSG_PUB.ADD;

1523: );
1524: END IF;
1525:
1526: FND_MESSAGE.Set_Name('AHL','AHL_PRD_JCG_STATUS_CODE_NULL');
1527: FND_MSG_PUB.ADD;
1528: RAISE FND_API.G_EXC_ERROR;
1529: END IF;
1530:
1531: IF (p_operation_flag = 'C') THEN

Line 1535: FND_MSG_PUB.ADD;

1531: IF (p_operation_flag = 'C') THEN
1532:
1533: IF (p_object_type IS NULL) THEN
1534: FND_MESSAGE.Set_Name('AHL','AHL_PRD_JCG_OBJECT_TYPE_NULL');
1535: FND_MSG_PUB.ADD;
1536: RAISE FND_API.G_EXC_ERROR;
1537: END IF;
1538: IF (p_object_id IS NULL) THEN
1539: FND_MESSAGE.Set_Name('AHL','AHL_PRD_JCG_OBJECT_ID_NULL');

Line 1540: FND_MSG_PUB.ADD;

1536: RAISE FND_API.G_EXC_ERROR;
1537: END IF;
1538: IF (p_object_id IS NULL) THEN
1539: FND_MESSAGE.Set_Name('AHL','AHL_PRD_JCG_OBJECT_ID_NULL');
1540: FND_MSG_PUB.ADD;
1541: RAISE FND_API.G_EXC_ERROR;
1542: END IF;
1543:
1544: ELSIF (p_operation_flag = 'U') THEN

Line 1548: FND_MSG_PUB.ADD;

1544: ELSIF (p_operation_flag = 'U') THEN
1545:
1546: IF (p_x_jcg_id IS NULL) THEN
1547: FND_MESSAGE.Set_Name('AHL','AHL_PRD_JCG_ID_NULL');
1548: FND_MSG_PUB.ADD;
1549: RAISE FND_API.G_EXC_ERROR;
1550: END IF;
1551:
1552: IF (p_file_location IS NULL AND (p_status_code = 'S' OR p_status_code = 'Complete' )) THEN

Line 1554: FND_MSG_PUB.ADD;

1550: END IF;
1551:
1552: IF (p_file_location IS NULL AND (p_status_code = 'S' OR p_status_code = 'Complete' )) THEN
1553: FND_MESSAGE.Set_Name('AHL','AHL_PRD_JCG_FILE_LOC_NULL');
1554: FND_MSG_PUB.ADD;
1555: RAISE FND_API.G_EXC_ERROR;
1556: END IF;
1557:
1558: END IF;

Line 1652: FND_MSG_PUB.ADD;

1648: CLOSE get_jcg_req_rec_csr;
1649: return;
1650: /*
1651: FND_MESSAGE.Set_Name('AHL','AHL_PRD_JCG_ID_INVALID');
1652: FND_MSG_PUB.ADD;
1653: CLOSE get_jcg_req_rec_csr;
1654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1655: */
1656: END IF;

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

1715: EXCEPTION
1716: WHEN FND_API.G_EXC_ERROR THEN
1717: x_return_status := FND_API.G_RET_STS_ERROR;
1718: Rollback to Process_JCG_Request_PVT;
1719: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1720: p_data => x_msg_data,
1721: p_encoded => fnd_api.g_false);
1722:
1723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1729: );
1730: END IF;
1731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1732: Rollback to Process_JCG_Request_PVT;
1733: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1734: p_data => x_msg_data,
1735: p_encoded => fnd_api.g_false);
1736:
1737: WHEN OTHERS THEN

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

1736:
1737: WHEN OTHERS THEN
1738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1739: Rollback to Process_JCG_Request_PVT;
1740: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1741: p_procedure_name => 'Process_JCG_Request',
1742: p_error_text => SUBSTR(SQLERRM,1,240));
1743: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1744: p_data => x_msg_data,

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

1739: Rollback to Process_JCG_Request_PVT;
1740: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1741: p_procedure_name => 'Process_JCG_Request',
1742: p_error_text => SUBSTR(SQLERRM,1,240));
1743: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1744: p_data => x_msg_data,
1745: p_encoded => fnd_api.g_false);
1746: IF (l_log_unexpected >= l_log_current_level)THEN
1747: fnd_log.string(

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

3926: EXCEPTION
3927: WHEN FND_API.G_EXC_ERROR THEN
3928: x_return_status := FND_API.G_RET_STS_ERROR;
3929: Rollback to Generate_JCG_XML_PVT;
3930: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3931: p_data => x_msg_data,
3932: p_encoded => fnd_api.g_false);
3933: IF (l_log_unexpected >= l_log_current_level)THEN
3934: fnd_log.string(

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

3939: END IF;
3940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3942: Rollback to Generate_JCG_XML_PVT;
3943: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3944: p_data => x_msg_data,
3945: p_encoded => fnd_api.g_false);
3946: IF (l_log_unexpected >= l_log_current_level)THEN
3947: fnd_log.string(

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

3953:
3954: WHEN OTHERS THEN
3955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3956: Rollback to Generate_JCG_XML_PVT;
3957: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
3958: p_procedure_name => 'Generate_JCG_XML',
3959: p_error_text => SUBSTR(SQLERRM,1,240));
3960: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3961: p_data => x_msg_data,

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

3956: Rollback to Generate_JCG_XML_PVT;
3957: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
3958: p_procedure_name => 'Generate_JCG_XML',
3959: p_error_text => SUBSTR(SQLERRM,1,240));
3960: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3961: p_data => x_msg_data,
3962: p_encoded => fnd_api.g_false);
3963: IF (l_log_unexpected >= l_log_current_level)THEN
3964: fnd_log.string(

Line 4067: l_msg_count := FND_MSG_PUB.Count_Msg;

4063: x_msg_count => l_msg_count ,
4064: x_file_name => l_xml_file_name
4065: -- l_merged_lob OUT NOCOPY CLOB -- for testing purpose only ,not required
4066: );
4067: l_msg_count := FND_MSG_PUB.Count_Msg;
4068: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4069: retcode := 2; -- error based only on return status
4070: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4071: retcode := 1; -- warning based on return status + msg count

Line 4119: l_msg_count := FND_MSG_PUB.Count_Msg;

4115: p_xml_data_filename => l_xml_file_name,
4116: p_error_message => NULL,
4117: p_CONCURRENT_REQUEST_ID => l_conc_request_id --fnd_global.conc_request_id
4118: );
4119: l_msg_count := FND_MSG_PUB.Count_Msg;
4120: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4121: retcode := 2; -- error based only on return status
4122: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4123: retcode := 1; -- warning based on return status + msg count

Line 4198: FND_MSG_PUB.count_and_get( p_count => l_msg_count,

4194:
4195: EXCEPTION
4196: WHEN FND_API.G_EXC_ERROR THEN
4197: retcode := 2;
4198: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4199: p_data => l_msg_data,
4200: p_encoded => fnd_api.g_false);
4201: errbuf := l_msg_data;
4202: l_err_update_status := HANDLE_JCG_ERRORS(l_enigma_request_id , to_char(l_conc_request_id) || ':' || l_msg_data);

Line 4209: FND_MSG_PUB.count_and_get( p_count => l_msg_count,

4205: fnd_file.new_line(FND_FILE.LOG,1);
4206:
4207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4208: retcode := 2;
4209: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4210: p_data => l_msg_data,
4211: p_encoded => fnd_api.g_false);
4212: errbuf := l_msg_data;
4213: l_err_update_status := HANDLE_JCG_ERRORS(l_enigma_request_id , to_char(l_conc_request_id) || ':' || l_msg_data);

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

4216: fnd_file.new_line(FND_FILE.LOG,1);
4217:
4218: WHEN OTHERS THEN
4219: retcode := 2;
4220: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
4221: p_procedure_name => 'generate_jcg_request',
4222: p_error_text => SUBSTR(SQLERRM,1,240));
4223: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4224: p_data => l_msg_data,

Line 4223: FND_MSG_PUB.count_and_get( p_count => l_msg_count,

4219: retcode := 2;
4220: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
4221: p_procedure_name => 'generate_jcg_request',
4222: p_error_text => SUBSTR(SQLERRM,1,240));
4223: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4224: p_data => l_msg_data,
4225: p_encoded => fnd_api.g_false);
4226: errbuf := l_msg_data;
4227: l_err_update_status := HANDLE_JCG_ERRORS(l_enigma_request_id , to_char(l_conc_request_id) || ':' || l_msg_data);

Line 4304: FND_MSG_PUB.Initialize;

4300: END IF;
4301:
4302: -- Initialize message list if p_init_msg_list is set to TRUE
4303: IF FND_API.To_Boolean(p_init_msg_list) THEN
4304: FND_MSG_PUB.Initialize;
4305: END IF;
4306:
4307: l_user_id := FND_GLOBAL.USER_ID;
4308: l_resp_id := FND_GLOBAL.RESP_ID;

Line 4378: FND_MSG_PUB.Count_And_Get

4374: COMMIT WORK;
4375: END IF;
4376:
4377: -- Standard call to get message count and if count is 1, get message info
4378: FND_MSG_PUB.Count_And_Get
4379: ( p_count => x_msg_count,
4380: p_data => x_msg_data,
4381: p_encoded => fnd_api.g_false
4382: );

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

4385: EXCEPTION
4386: WHEN FND_API.G_EXC_ERROR THEN
4387: x_return_status := FND_API.G_RET_STS_ERROR;
4388: Rollback to GENERATE_JCG_REQUEST_PVT;
4389: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4390: p_data => x_msg_data,
4391: p_encoded => fnd_api.g_false);
4392:
4393:

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

4393:
4394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4396: Rollback to GENERATE_JCG_REQUEST_PVT;
4397: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4398: p_data => x_msg_data,
4399: p_encoded => fnd_api.g_false);
4400:
4401: WHEN OTHERS THEN

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

4400:
4401: WHEN OTHERS THEN
4402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4403: Rollback to GENERATE_JCG_REQUEST_PVT;
4404: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4405: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
4406: p_procedure_name => 'print_workcard',
4407: p_error_text => SUBSTR(SQLERRM,1,240));
4408: END IF;

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

4401: WHEN OTHERS THEN
4402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4403: Rollback to GENERATE_JCG_REQUEST_PVT;
4404: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4405: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
4406: p_procedure_name => 'print_workcard',
4407: p_error_text => SUBSTR(SQLERRM,1,240));
4408: END IF;
4409: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

4405: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
4406: p_procedure_name => 'print_workcard',
4407: p_error_text => SUBSTR(SQLERRM,1,240));
4408: END IF;
4409: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4410: p_data => x_msg_data,
4411: p_encoded => fnd_api.g_false);
4412:
4413: END print_workcard;

Line 4735: FND_MSG_PUB.count_and_get( p_count => l_msg_count,

4731: EXCEPTION
4732: WHEN FND_API.G_EXC_ERROR THEN
4733: Rollback to HANDLE_JCG_RESPONSE;
4734:
4735: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4736: p_data => l_msg_data,
4737: p_encoded => fnd_api.g_false);
4738: RETURN HANDLE_JCG_ERRORS(p_request_id, l_msg_data );
4739:

Line 4742: FND_MSG_PUB.count_and_get( p_count => l_msg_count,

4738: RETURN HANDLE_JCG_ERRORS(p_request_id, l_msg_data );
4739:
4740: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4741: Rollback to HANDLE_JCG_RESPONSE;
4742: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4743: p_data => l_msg_data,
4744: p_encoded => fnd_api.g_false);
4745: RETURN HANDLE_JCG_ERRORS(p_request_id, l_msg_data );
4746:

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

4745: RETURN HANDLE_JCG_ERRORS(p_request_id, l_msg_data );
4746:
4747: WHEN OTHERS THEN
4748: Rollback to HANDLE_JCG_RESPONSE;
4749: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
4750: p_procedure_name => l_api_name,
4751: p_error_text => SUBSTR(SQLERRM,1,240));
4752: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4753: p_data => l_msg_data,

Line 4752: FND_MSG_PUB.count_and_get( p_count => l_msg_count,

4748: Rollback to HANDLE_JCG_RESPONSE;
4749: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
4750: p_procedure_name => l_api_name,
4751: p_error_text => SUBSTR(SQLERRM,1,240));
4752: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4753: p_data => l_msg_data,
4754: p_encoded => fnd_api.g_false);
4755: RETURN HANDLE_JCG_ERRORS(p_request_id, l_msg_data );
4756: END HANDLE_JCG_RESPONSE;

Line 4885: FND_MSG_PUB.count_and_get( p_count => l_msg_count,

4881: EXCEPTION
4882: WHEN FND_API.G_EXC_ERROR THEN
4883: Rollback to HANDLE_JCG_ERRORS;
4884:
4885: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4886: p_data => l_msg_data,
4887: p_encoded => fnd_api.g_false);
4888: IF (l_log_error >= l_log_current_level)THEN
4889: fnd_log.string( l_log_error,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 4898: FND_MSG_PUB.count_and_get( p_count => l_msg_count,

4894: RETURN 'ERROR';
4895:
4896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4897: Rollback to HANDLE_JCG_ERRORS;
4898: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4899: p_data => l_msg_data,
4900: p_encoded => fnd_api.g_false);
4901: IF (l_log_unexpected >= l_log_current_level)THEN
4902: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

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

4906: END IF;
4907: RETURN 'ERROR';
4908: WHEN OTHERS THEN
4909: Rollback to HANDLE_JCG_ERRORS;
4910: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
4911: p_procedure_name => l_api_name,
4912: p_error_text => SUBSTR(SQLERRM,1,240));
4913: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4914: p_data => l_msg_data,

Line 4913: FND_MSG_PUB.count_and_get( p_count => l_msg_count,

4909: Rollback to HANDLE_JCG_ERRORS;
4910: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
4911: p_procedure_name => l_api_name,
4912: p_error_text => SUBSTR(SQLERRM,1,240));
4913: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4914: p_data => l_msg_data,
4915: p_encoded => fnd_api.g_false);
4916: IF (l_log_unexpected >= l_log_current_level)THEN
4917: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

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

5084: END IF;
5085: EXCEPTION
5086: WHEN OTHERS THEN
5087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5088: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
5089: p_procedure_name => 'APPLY_TRANSFORMATION',
5090: p_error_text => SUBSTR(SQLERRM,1,240));
5091: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
5092: p_data => x_msg_data,

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

5087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5088: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
5089: p_procedure_name => 'APPLY_TRANSFORMATION',
5090: p_error_text => SUBSTR(SQLERRM,1,240));
5091: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
5092: p_data => x_msg_data,
5093: p_encoded => fnd_api.g_false);
5094:
5095: END APPLY_TRANSFORMATION;

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

5159: END IF;
5160: EXCEPTION
5161: WHEN OTHERS THEN
5162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5163: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
5164: p_procedure_name => 'APPLY_TRANSFORMATION',
5165: p_error_text => SUBSTR(SQLERRM,1,240));
5166: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
5167: p_data => x_msg_data,

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

5162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5163: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
5164: p_procedure_name => 'APPLY_TRANSFORMATION',
5165: p_error_text => SUBSTR(SQLERRM,1,240));
5166: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
5167: p_data => x_msg_data,
5168: p_encoded => fnd_api.g_false);
5169:
5170: END APPLY_TRANSFORMATION;

Line 7701: FND_MSG_PUB.ADD;

7697: x_return_status := FND_API.G_RET_STS_ERROR;
7698: /*
7699: FND_MESSAGE.Set_Name('AHL','AHL_INPUT_NUM_LOC_SEGS_INVALID');
7700: FND_MESSAGE.Set_Token('LOC_SEG',p_concat_segs);
7701: FND_MSG_PUB.ADD;
7702: --dbms_output.put_line('ERROR:'|| fnd_flex_keyval.error_message);
7703: --dbms_output.put_line('ERROR:'|| fnd_flex_keyval.error_segment);
7704: */
7705: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN