DBA Data[Home] [Help]

APPS.ECX_TP_MERGE_PKG dependencies on FND_MESSAGE

Line 45: fnd_message.set_name('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');

41: where party_id = to_char(p_from_fk_id)
42: and party_type in ('C', 'E', 'CARRIER');
43: exception
44: when others then
45: fnd_message.set_name('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');
46: fnd_message.set_token('ERROR_CODE', SQLCODE);
47: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
48: fnd_msg_pub.add;
49: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 46: fnd_message.set_token('ERROR_CODE', SQLCODE);

42: and party_type in ('C', 'E', 'CARRIER');
43: exception
44: when others then
45: fnd_message.set_name('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');
46: fnd_message.set_token('ERROR_CODE', SQLCODE);
47: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
48: fnd_msg_pub.add;
49: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
50: end ecx_party_merge;

Line 47: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);

43: exception
44: when others then
45: fnd_message.set_name('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');
46: fnd_message.set_token('ERROR_CODE', SQLCODE);
47: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
48: fnd_msg_pub.add;
49: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
50: end ecx_party_merge;
51:

Line 121: fnd_message.set_name('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');

117: loop
118: for j in 1..v_tp_details_target_tab.count
119: loop
120: if v_tp_details_source_tab(i).v_ext_process_id= v_tp_details_target_tab(j).v_ext_process_id and v_tp_details_source_tab(i).v_source_tp_location_code= v_tp_details_target_tab(j).v_source_tp_location_code then
121: fnd_message.set_name('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');
122: -- fnd_message.set_token('ERROR_CODE', SQLCODE);
123: fnd_message.set_token('ERROR_MESSAGE', 'Source and Destination TPs with Common TP Details');
124: fnd_msg_pub.add;
125: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 122: -- fnd_message.set_token('ERROR_CODE', SQLCODE);

118: for j in 1..v_tp_details_target_tab.count
119: loop
120: if v_tp_details_source_tab(i).v_ext_process_id= v_tp_details_target_tab(j).v_ext_process_id and v_tp_details_source_tab(i).v_source_tp_location_code= v_tp_details_target_tab(j).v_source_tp_location_code then
121: fnd_message.set_name('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');
122: -- fnd_message.set_token('ERROR_CODE', SQLCODE);
123: fnd_message.set_token('ERROR_MESSAGE', 'Source and Destination TPs with Common TP Details');
124: fnd_msg_pub.add;
125: x_return_status := fnd_api.g_ret_sts_unexp_error;
126: return; --abort the procedure execution

Line 123: fnd_message.set_token('ERROR_MESSAGE', 'Source and Destination TPs with Common TP Details');

119: loop
120: if v_tp_details_source_tab(i).v_ext_process_id= v_tp_details_target_tab(j).v_ext_process_id and v_tp_details_source_tab(i).v_source_tp_location_code= v_tp_details_target_tab(j).v_source_tp_location_code then
121: fnd_message.set_name('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');
122: -- fnd_message.set_token('ERROR_CODE', SQLCODE);
123: fnd_message.set_token('ERROR_MESSAGE', 'Source and Destination TPs with Common TP Details');
124: fnd_msg_pub.add;
125: x_return_status := fnd_api.g_ret_sts_unexp_error;
126: return; --abort the procedure execution
127: end if;

Line 164: FND_MESSAGE.SET_NAME('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');

160: where party_site_id = to_char(p_from_fk_id)
161: and party_type in ('C', 'E', 'CARRIER');
162: exception
163: when others then
164: FND_MESSAGE.SET_NAME('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');
165: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
166: fnd_message.set_token('ERROR_MESSAGE', sqlerrm);
167: fnd_msg_pub.add;
168: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 165: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);

161: and party_type in ('C', 'E', 'CARRIER');
162: exception
163: when others then
164: FND_MESSAGE.SET_NAME('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');
165: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
166: fnd_message.set_token('ERROR_MESSAGE', sqlerrm);
167: fnd_msg_pub.add;
168: x_return_status := fnd_api.g_ret_sts_unexp_error;
169: end ecx_party_sites_merge;

Line 166: fnd_message.set_token('ERROR_MESSAGE', sqlerrm);

162: exception
163: when others then
164: FND_MESSAGE.SET_NAME('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');
165: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
166: fnd_message.set_token('ERROR_MESSAGE', sqlerrm);
167: fnd_msg_pub.add;
168: x_return_status := fnd_api.g_ret_sts_unexp_error;
169: end ecx_party_sites_merge;
170: end ecx_tp_merge_pkg;