DBA Data[Home] [Help]

APPS.CSM_MULTI_MOBQRY_PKG dependencies on FND_MSG_PUB

Line 568: l_msg_data := replace(fnd_msg_pub.get(l_msg_count,'F'),fnd_global.local_chr(10), ' ');

564: x_msg_data => l_msg_data
565: );
566:
567: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
568: l_msg_data := replace(fnd_msg_pub.get(l_msg_count,'F'),fnd_global.local_chr(10), ' ');
569: x_error_message := 'Error in CSP_TRANSACTIONS_PUB.receive_requirement_trans' || ' for PK : ' || r_part_line.line_id || ' Details:' || l_msg_data ;
570: CSM_UTIL_PKG.LOG( x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_ERROR);
571: l_result:=l_result||''||translateString(l_msg_data)||''||'';
572: ELSE

Line 608: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');

604: WHEN FND_API.G_EXC_ERROR THEN
605: ROLLBACK;
606: x_return_status := FND_API.G_RET_STS_SUCCESS;
607: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts',FND_LOG.LEVEL_PROCEDURE);
608: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
609: p_result:='E:'||translateString(x_error_message);
610: WHEN OTHERS THEN
611: ROLLBACK;
612: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 837: l_msg_data := replace(fnd_msg_pub.get(l_msg_count,'F'),fnd_global.local_chr(10), ' ');

833: x_msg_data => l_msg_data
834: );
835:
836: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
837: l_msg_data := replace(fnd_msg_pub.get(l_msg_count,'F'),fnd_global.local_chr(10), ' ');
838: x_error_message := 'Error in CSP_TRANSACTIONS_PUB.receive_requirement_trans' || ' for PK : ' || r_part_line.line_id || ' Details:' || l_msg_data ;
839: CSM_UTIL_PKG.LOG( x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_ERROR);
840: IF(r_part_line.serial_number IS NOT NULL) THEN
841: l_result:=l_result||''||r_part_line.serial_number||''||translateString(l_msg_data)||'';

Line 889: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');

885: WHEN FND_API.G_EXC_ERROR THEN
886: ROLLBACK;
887: x_return_status := FND_API.G_RET_STS_SUCCESS;
888: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts',FND_LOG.LEVEL_PROCEDURE);
889: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
890: p_result:='E:'||translateString(x_error_message);
891: WHEN OTHERS THEN
892: ROLLBACK;
893: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 971: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');

967: CSM_UTIL_PKG.LOG('Leaving after successful execution', 'CSM_MULTI_MOBQRY_PKG.q_upd_rqmt_ship_to',FND_LOG.LEVEL_PROCEDURE);
968: EXCEPTION
969: WHEN FND_API.G_EXC_ERROR THEN
970: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_upd_rqmt_ship_to',FND_LOG.LEVEL_PROCEDURE);
971: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
972: p_result:='E:'||translateString(x_error_message);
973: WHEN OTHERS THEN
974: x_error_message := 'Exception occurred in q_upd_rqmt_ship_to: ' || substr(sqlerrm,1,3900);
975: p_result:='E:'||translateString(x_error_message);

Line 1052: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');

1048: p_result:='S:'||to_char(l_return_status);
1049: EXCEPTION
1050: WHEN FND_API.G_EXC_ERROR THEN
1051: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo',FND_LOG.LEVEL_PROCEDURE);
1052: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
1053: p_result:='E:'||translateString(x_error_message);
1054: WHEN OTHERS THEN
1055: x_error_message := 'Exception occurred in q_upd_oe_shipTo: ' || substr(sqlerrm,0,1000);
1056: p_result:='E:'||translateString(x_error_message);

Line 1110: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');

1106: p_result:='S:'||to_char(l_return_status);
1107: EXCEPTION
1108: WHEN FND_API.G_EXC_ERROR THEN
1109: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_line_shipMethod',FND_LOG.LEVEL_PROCEDURE);
1110: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
1111: p_result:='E:'||translateString(x_error_message);
1112: WHEN OTHERS THEN
1113: x_error_message := 'Exception occurred in q_upd_oe_line_shipMethod: ' || substr(sqlerrm,0,1000);
1114: p_result:='E:'||translateString(x_error_message);

Line 1193: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||fnd_msg_pub.get(l_msg_count,'F'), 'CSM_MULTI_MOBQRY_PKG.get_hr_location',FND_LOG.LEVEL_PROCEDURE);

1189:
1190: CSM_UTIL_PKG.LOG('After call to CSP: x_loc_id:-'||x_loc_id ||' -:-ret status:'||l_ret, 'CSM_MULTI_MOBQRY_PKG.get_hr_location',FND_LOG.LEVEL_PROCEDURE);
1191:
1192: if ((l_ret IS NULL AND x_loc_id = l_hz_loc_id) OR (l_ret <> FND_API.G_RET_STS_SUCCESS)) THEN
1193: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||fnd_msg_pub.get(l_msg_count,'F'), 'CSM_MULTI_MOBQRY_PKG.get_hr_location',FND_LOG.LEVEL_PROCEDURE);
1194: RAISE FND_API.G_EXC_ERROR;
1195: END IF;
1196:
1197: RETURN x_loc_id;

Line 1378: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');

1374: ||':'||to_char(l_org_id)||':'||to_char(x_cust_id);
1375: EXCEPTION
1376: WHEN FND_API.G_EXC_ERROR THEN
1377: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_create_shipTo',FND_LOG.LEVEL_PROCEDURE);
1378: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
1379: p_result:='E:'||translateString(x_error_message);
1380: WHEN OTHERS THEN
1381: x_error_message := 'Exception occurred in q_create_shipTo: ' || substr(sqlerrm,0,1000);
1382: p_result:='E:'||translateString(x_error_message);

Line 1666: x_error_message := 'Part Search Api Failed with error: ' || fnd_msg_pub.get(l_msg_count,'F');

1662: x_msg_data => l_msg_data,
1663: x_msg_count => l_msg_count);
1664:
1665: IF L_RETURN_STATUS<> FND_API.G_RET_STS_SUCCESS THEN
1666: x_error_message := 'Part Search Api Failed with error: ' || fnd_msg_pub.get(l_msg_count,'F');
1667: p_result:='E:'||translateString(x_error_message);
1668: CSM_UTIL_PKG.LOG( x_error_message,'CSM_MULTI_MOBQRY_PKG.q_available_parts', FND_LOG.LEVEL_ERROR);
1669: RETURN; --this is meant for error callback
1670: ELSE

Line 1988: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');

1984: CSM_UTIL_PKG.LOG('Leaving after successful execution', 'CSM_MULTI_MOBQRY_PKG.q_upd_task_status',FND_LOG.LEVEL_PROCEDURE);
1985: EXCEPTION
1986: WHEN FND_API.G_EXC_ERROR THEN
1987: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_upd_task_status',FND_LOG.LEVEL_PROCEDURE);
1988: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
1989: p_result:='E:'||translateString(x_error_message);
1990: WHEN OTHERS THEN
1991: x_error_message := 'Exception occurred in q_upd_task_status: ' || substr(sqlerrm,1,3900);
1992: p_result:='E:'||translateString(x_error_message);