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

Line 224: FND_MSG_PUB.initialize;

220: END IF;
221:
222: --Initialize message list if p_init_msg_list is set to TRUE.
223: IF FND_API.to_boolean( p_init_msg_list ) THEN
224: FND_MSG_PUB.initialize;
225: END IF;
226:
227: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
228: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 240: FND_MSG_PUB.add;

236: FETCH get_job_attrs INTO l_job_attrs;
237: IF get_job_attrs%NOTFOUND THEN
238: FND_MESSAGE.set_name('AHL', 'AHL_PRD_DISP_JOB_ID_INVALID');
239: FND_MESSAGE.set_token('JOBID', p_workorder_id);
240: FND_MSG_PUB.add;
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: CLOSE get_job_attrs;
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: ELSE

Line 275: FND_MSG_PUB.add;

271: FETCH check_inv_item_id INTO l_inv_item_id;
272: IF check_inv_item_id%NOTFOUND THEN
273: FND_MESSAGE.set_name('AHL', 'AHL_PRD_ITEM_ID_INVALID');
274: FND_MESSAGE.set_token('ITEMID', p_disp_filter_rec.inventory_item_id);
275: FND_MSG_PUB.add;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: CLOSE check_inv_item_id;
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: ELSE

Line 290: FND_MSG_PUB.add;

286: FETCH get_inv_item_id INTO l_inv_item_id;
287: IF get_inv_item_id%NOTFOUND THEN
288: FND_MESSAGE.set_name('AHL', 'AHL_PRD_ITEM_NUM_INVALID');
289: FND_MESSAGE.set_token('ITEM', p_disp_filter_rec.item_number);
290: FND_MSG_PUB.add;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: CLOSE get_inv_item_id;
293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
294: ELSE

Line 305: FND_MSG_PUB.add;

301: FETCH check_con_status_id INTO l_con_status_id;
302: IF check_con_status_id%NOTFOUND THEN
303: FND_MESSAGE.set_name('AHL', 'AHL_PRD_CON_STATUS_ID_INVALID');
304: FND_MESSAGE.set_token('STATUSID', p_disp_filter_rec.condition_id);
305: FND_MSG_PUB.add;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: CLOSE check_con_status_id;
308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
309: ELSE

Line 320: FND_MSG_PUB.add;

316: FETCH get_con_status_id INTO l_con_status_id;
317: IF get_con_status_id%NOTFOUND THEN
318: FND_MESSAGE.set_name('AHL', 'AHL_PRD_CON_STATUS_INVALID');
319: FND_MESSAGE.set_token('STAUS', p_disp_filter_rec.condition_code);
320: FND_MSG_PUB.add;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: CLOSE get_con_status_id;
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: ELSE

Line 663: FND_MSG_PUB.add;

659: --but it is translatable, so we put it into the message table and fetch back
660: --the translated one. And then we need to remove this particular message from
661: --the message otherwise it will interfere with other regular meaningful messages.
662: FND_MESSAGE.set_name('AHL', 'AHL_PRD_CONST_MULTIPLE');
663: FND_MSG_PUB.add;
664: FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,
665: p_encoded => FND_API.G_FALSE,
666: p_data => l_translated_msg,
667: p_msg_index_out => l_msg_index);

Line 664: FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,

660: --the translated one. And then we need to remove this particular message from
661: --the message otherwise it will interfere with other regular meaningful messages.
662: FND_MESSAGE.set_name('AHL', 'AHL_PRD_CONST_MULTIPLE');
663: FND_MSG_PUB.add;
664: FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,
665: p_encoded => FND_API.G_FALSE,
666: p_data => l_translated_msg,
667: p_msg_index_out => l_msg_index);
668: FND_MSG_PUB.delete_msg(l_msg_index);

Line 668: FND_MSG_PUB.delete_msg(l_msg_index);

664: FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,
665: p_encoded => FND_API.G_FALSE,
666: p_data => l_translated_msg,
667: p_msg_index_out => l_msg_index);
668: FND_MSG_PUB.delete_msg(l_msg_index);
669: x_disp_list_tbl(i).on_item_number := l_translated_msg;
670: EXIT;
671: END IF;
672: END LOOP;

Line 687: FND_MSG_PUB.add;

683: --the translated one. And then we need to remove this particular message from
684: --the message otherwise it will interfere with other regular meaningful messages.
685: /* After discussion with Jay, now decided to display it just as (09/22/04)
686: FND_MESSAGE.set_name('AHL', 'AHL_PRD_CONST_IG_NAME');
687: FND_MSG_PUB.add;
688: FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,
689: p_encoded => FND_API.G_FALSE,
690: p_data => l_translated_msg,
691: p_msg_index_out => l_msg_index);

Line 688: FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,

684: --the message otherwise it will interfere with other regular meaningful messages.
685: /* After discussion with Jay, now decided to display it just as (09/22/04)
686: FND_MESSAGE.set_name('AHL', 'AHL_PRD_CONST_IG_NAME');
687: FND_MSG_PUB.add;
688: FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,
689: p_encoded => FND_API.G_FALSE,
690: p_data => l_translated_msg,
691: p_msg_index_out => l_msg_index);
692: FND_MSG_PUB.delete_msg(l_msg_index);

Line 692: FND_MSG_PUB.delete_msg(l_msg_index);

688: FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,
689: p_encoded => FND_API.G_FALSE,
690: p_data => l_translated_msg,
691: p_msg_index_out => l_msg_index);
692: FND_MSG_PUB.delete_msg(l_msg_index);
693: x_disp_list_tbl(i).off_item_number := '<'||l_translated_msg||'>:'||x_disp_list_tbl(i).item_group_name;
694: */
695: x_disp_list_tbl(i).off_item_number := '<'||x_disp_list_tbl(i).item_group_name||'>';
696:

Line 709: l_msg_count := FND_MSG_PUB.count_msg;

705: 'At the end of the procedure');
706: END IF;
707:
708: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
709: l_msg_count := FND_MSG_PUB.count_msg;
710: IF l_msg_count > 0 THEN
711: x_msg_count := l_msg_count;
712: RAISE FND_API.G_EXC_ERROR;
713: END IF;

Line 715: FND_MSG_PUB.count_and_get(

711: x_msg_count := l_msg_count;
712: RAISE FND_API.G_EXC_ERROR;
713: END IF;
714: -- Count and Get messages (optional)
715: FND_MSG_PUB.count_and_get(
716: p_encoded => FND_API.G_FALSE,
717: p_count => x_msg_count,
718: p_data => x_msg_data);
719:

Line 724: FND_MSG_PUB.count_and_get(

720: EXCEPTION
721: WHEN FND_API.G_EXC_ERROR THEN
722: --ROLLBACK TO get_disposition_list;
723: x_return_status := FND_API.G_RET_STS_ERROR ;
724: FND_MSG_PUB.count_and_get(
725: p_encoded => FND_API.G_FALSE,
726: p_count => x_msg_count,
727: p_data => x_msg_data);
728:

Line 732: FND_MSG_PUB.count_and_get(

728:
729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
730: --ROLLBACK TO get_disposition_list;
731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
732: FND_MSG_PUB.count_and_get(
733: p_encoded => FND_API.G_FALSE,
734: p_count => x_msg_count,
735: p_data => x_msg_data);
736:

Line 740: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

736:
737: WHEN OTHERS THEN
738: --ROLLBACK TO get_disposition_list;
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
740: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
741: THEN
742: FND_MSG_PUB.add_exc_msg(
743: p_pkg_name => G_PKG_NAME,
744: p_procedure_name => l_api_name,

Line 742: FND_MSG_PUB.add_exc_msg(

738: --ROLLBACK TO get_disposition_list;
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
740: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
741: THEN
742: FND_MSG_PUB.add_exc_msg(
743: p_pkg_name => G_PKG_NAME,
744: p_procedure_name => l_api_name,
745: p_error_text => SUBSTRB(SQLERRM,1,240));
746: END IF;

Line 747: FND_MSG_PUB.count_and_get(

743: p_pkg_name => G_PKG_NAME,
744: p_procedure_name => l_api_name,
745: p_error_text => SUBSTRB(SQLERRM,1,240));
746: END IF;
747: FND_MSG_PUB.count_and_get(
748: p_encoded => FND_API.G_FALSE,
749: p_count => x_msg_count,
750: p_data => x_msg_data);
751:

Line 1330: FND_MSG_PUB.initialize;

1326: 'Entering the Procedure.');
1327: END IF;
1328:
1329: IF (FND_API.to_boolean(p_init_msg_list)) THEN
1330: FND_MSG_PUB.initialize;
1331: END IF;
1332:
1333: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1334: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

1507: EXCEPTION
1508: WHEN FND_API.G_EXC_ERROR THEN
1509: Rollback to Get_Part_Change_Disp_Pvt;
1510: x_return_status := FND_API.G_RET_STS_ERROR;
1511: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1512: p_data => x_msg_data,
1513: p_encoded => fnd_api.g_false);
1514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1515: Rollback to Get_Part_Change_Disp_Pvt;

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

1513: p_encoded => fnd_api.g_false);
1514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1515: Rollback to Get_Part_Change_Disp_Pvt;
1516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1517: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1518: p_data => x_msg_data,
1519: p_encoded => fnd_api.g_false);
1520: WHEN OTHERS THEN
1521: Rollback to Get_Part_Change_Disp_Pvt;

Line 1523: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

1519: p_encoded => fnd_api.g_false);
1520: WHEN OTHERS THEN
1521: Rollback to Get_Part_Change_Disp_Pvt;
1522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1523: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1524: p_procedure_name => l_api_name,
1525: p_error_text => SQLERRM);
1526: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1527: p_data => x_msg_data,

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

1522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1523: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1524: p_procedure_name => l_api_name,
1525: p_error_text => SQLERRM);
1526: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1527: p_data => x_msg_data,
1528: p_encoded => fnd_api.g_false);
1529: END Get_Part_Change_Disposition;
1530:

Line 1604: FND_MSG_PUB.initialize;

1600: -- Initialize Procedure return status to success
1601: x_return_status := FND_API.G_RET_STS_SUCCESS;
1602:
1603: IF (FND_API.to_boolean(p_init_msg_list)) THEN
1604: FND_MSG_PUB.initialize;
1605: END IF;
1606:
1607: i:=0;
1608: --Fetch the current disposition types or ids

Line 1773: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

1769:
1770: EXCEPTION
1771: WHEN OTHERS THEN
1772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1773: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1774: p_procedure_name => l_api_name,
1775: p_error_text => SQLERRM);
1776: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1777: p_data => x_msg_data,

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

1772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1773: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1774: p_procedure_name => l_api_name,
1775: p_error_text => SQLERRM);
1776: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1777: p_data => x_msg_data,
1778: p_encoded => fnd_api.g_false);
1779: END Get_Available_Disp_Types;
1780:

Line 2006: FND_MSG_PUB.initialize;

2002: -- Initialize Procedure return status to success
2003: x_return_status := FND_API.G_RET_STS_SUCCESS;
2004:
2005: IF (FND_API.to_boolean(p_init_msg_list)) THEN
2006: FND_MSG_PUB.initialize;
2007: END IF;
2008:
2009: --Fetch the disposition for Part Removal
2010: OPEN get_disp_dtls_csr (p_disposition_id);

Line 2016: FND_MSG_PUB.ADD;

2012: --Check if matching disposition is found..
2013: IF (get_disp_dtls_csr%NOTFOUND) THEN
2014: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_ID_INVALID');
2015: FND_MESSAGE.Set_Token('DISPOSITION_ID', p_disposition_id);
2016: FND_MSG_PUB.ADD;
2017: CLOSE get_disp_dtls_csr;
2018: RAISE FND_API.G_EXC_ERROR;
2019: END IF;
2020: CLOSE get_disp_dtls_csr;

Line 2026: FND_MSG_PUB.ADD;

2022: --Throw an error if both item and position are null
2023: IF (l_disp_rec.inventory_item_id IS NULL AND
2024: l_disp_rec.path_position_id IS NULL) THEN
2025: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_ITEM_POS_NULL');
2026: FND_MSG_PUB.ADD;
2027: RAISE FND_API.G_EXC_ERROR;
2028: ELSIF (l_disp_rec.inventory_item_id IS NULL AND
2029: l_disp_rec.path_position_id IS NOT NULL) THEN
2030: --get the position relationship id (Use the 1st one)

Line 2058: FND_MSG_PUB.ADD;

2054:
2055: --Raise the exception because for workorder org, no matching item found.
2056: --Can not create Mtl Req because there is no inventory item
2057: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_ITEM_ORG_INV');
2058: FND_MSG_PUB.ADD;
2059: RAISE FND_API.G_EXC_ERROR;
2060: END IF;
2061: CLOSE get_pos_subut_item_csr;
2062: END IF;

Line 2157: x_msg_count := Fnd_Msg_Pub.count_msg;

2153: x_msg_count => x_msg_count,
2154: x_msg_data => x_msg_data);
2155: END IF;
2156: --Standard check to count messages
2157: x_msg_count := Fnd_Msg_Pub.count_msg;
2158: IF x_msg_count > 0 THEN
2159: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2160: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2161: G_LOG_PREFIX||l_api_name||': Within the API',

Line 2185: FND_MSG_PUB.ADD;

2181: l_req_material_rec.requested_quantity);
2182: FND_MESSAGE.Set_Token('UOM', l_req_material_rec.uom_code);
2183: END IF;
2184: FND_MESSAGE.Set_Token('ITEM', l_item_number);
2185: FND_MSG_PUB.ADD;
2186: END IF;
2187:
2188: --Standard check for commit
2189: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

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

2190: COMMIT;
2191: END IF;
2192:
2193: --Count and Get messages (optional)
2194: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2195: p_data => x_msg_data,
2196: p_encoded => fnd_api.g_false);
2197:
2198: EXCEPTION

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

2198: EXCEPTION
2199: WHEN FND_API.G_EXC_ERROR THEN
2200: Rollback to Create_Disp_Mtl_Req_Pvt;
2201: x_return_status := FND_API.G_RET_STS_ERROR;
2202: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2203: p_data => x_msg_data,
2204: p_encoded => fnd_api.g_false);
2205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2206: Rollback to Create_Disp_Mtl_Req_Pvt;

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

2204: p_encoded => fnd_api.g_false);
2205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2206: Rollback to Create_Disp_Mtl_Req_Pvt;
2207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2208: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2209: p_data => x_msg_data,
2210: p_encoded => fnd_api.g_false);
2211: WHEN OTHERS THEN
2212: Rollback to Create_Disp_Mtl_Req_Pvt;

Line 2214: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

2210: p_encoded => fnd_api.g_false);
2211: WHEN OTHERS THEN
2212: Rollback to Create_Disp_Mtl_Req_Pvt;
2213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2214: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
2215: p_procedure_name => l_api_name,
2216: p_error_text => SQLERRM);
2217: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2218: p_data => x_msg_data,

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

2213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2214: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
2215: p_procedure_name => l_api_name,
2216: p_error_text => SQLERRM);
2217: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2218: p_data => x_msg_data,
2219: p_encoded => fnd_api.g_false);
2220: END Create_Disp_Mtl_Requirement;
2221:

Line 2283: FND_MSG_PUB.initialize;

2279: -- Initialize Procedure return status to success
2280: x_return_status := FND_API.G_RET_STS_SUCCESS;
2281:
2282: IF (FND_API.to_boolean(p_init_msg_list)) THEN
2283: FND_MSG_PUB.initialize;
2284: END IF;
2285:
2286: IF (FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2287: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 2304: fnd_msg_pub.add;

2300: WHEN NO_DATA_FOUND THEN
2301: fnd_message.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
2302: fnd_message.set_token('NAME','p_disposition_id');
2303: fnd_message.set_token('VALUE',p_disposition_id);
2304: fnd_msg_pub.add;
2305: RAISE FND_API.G_EXC_ERROR;
2306: END;
2307:
2308: BEGIN

Line 2317: fnd_msg_pub.add;

2313: WHEN NO_DATA_FOUND THEN
2314: fnd_message.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
2315: fnd_message.set_token('NAME','p_service_request_id');
2316: fnd_message.set_token('VALUE',p_service_request_id);
2317: fnd_msg_pub.add;
2318: RAISE FND_API.G_EXC_ERROR;
2319: END;
2320:
2321: --- Create link between Disposition and Service Request

Line 2367: fnd_msg_pub.add;

2363: END IF;
2364: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) Then
2365: fnd_message.set_name('AHL','AHL_PRD_SR_LINK_CREATE_ERROR');
2366: fnd_message.set_token('VALUE1',p_disposition_id);
2367: fnd_msg_pub.add;
2368: RAISE FND_API.G_EXC_ERROR;
2369: End If;
2370:
2371: IF (FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2379: COMMIT;
2380: END IF;
2381:
2382: --Count and Get messages (optional)
2383: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2384: p_data => x_msg_data,
2385: p_encoded => fnd_api.g_false);
2386:
2387: EXCEPTION

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

2387: EXCEPTION
2388: WHEN FND_API.G_EXC_ERROR THEN
2389: Rollback to Create_SR_Disp_Link_Pvt;
2390: x_return_status := FND_API.G_RET_STS_ERROR;
2391: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2392: p_data => x_msg_data,
2393: p_encoded => fnd_api.g_false);
2394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2395: Rollback to Create_SR_Disp_Link_Pvt;

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

2393: p_encoded => fnd_api.g_false);
2394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2395: Rollback to Create_SR_Disp_Link_Pvt;
2396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2397: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2398: p_data => x_msg_data,
2399: p_encoded => fnd_api.g_false);
2400: WHEN OTHERS THEN
2401: Rollback to Create_SR_Disp_Link_Pvt;

Line 2403: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

2399: p_encoded => fnd_api.g_false);
2400: WHEN OTHERS THEN
2401: Rollback to Create_SR_Disp_Link_Pvt;
2402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2403: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
2404: p_procedure_name => l_api_name,
2405: p_error_text => SQLERRM);
2406: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2407: p_data => x_msg_data,

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

2402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2403: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
2404: p_procedure_name => l_api_name,
2405: p_error_text => SQLERRM);
2406: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2407: p_data => x_msg_data,
2408: p_encoded => fnd_api.g_false);
2409: END Create_SR_Disp_Link;
2410: