DBA Data[Home] [Help]

APPS.JTF_RS_PARTY_MERGE_PUB dependencies on FND_MSG_PUB

Line 130: FND_MSG_PUB.add;

126: then
127: fnd_message.set_name ('JTF', 'JTF_RS_ENTITY_NAME_ERR');
128: fnd_message.set_token('P_ENTITY',p_entity_name);
129: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
130: FND_MSG_PUB.add;
131: RAISE fnd_api.g_exc_error;
132: end if;
133:
134: FOR cat_rec IN cat_cur(p_from_fk_id) LOOP

Line 184: FND_MSG_PUB.add;

180:
181: IF (nvl(l_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success) then
182: x_return_status := l_return_status ;
183: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');
184: FND_MSG_PUB.add;
185: RAISE fnd_api.g_exc_error;
186: END IF;
187:
188: ELSIF (l_error_handle = 'ERROR') THEN

Line 192: FND_MSG_PUB.add;

188: ELSIF (l_error_handle = 'ERROR') THEN
189: ----------------------------------------------------
190: -- reject merge
191: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');
192: FND_MSG_PUB.add;
193: x_return_status := fnd_api.g_ret_sts_error;
194: RAISE fnd_api.g_exc_error;
195: ----------------------------------------------------
196: END IF;

Line 336: FND_MSG_PUB.add;

332:
333: IF (nvl(l_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success) then
334: x_return_status := l_return_status ;
335: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');
336: FND_MSG_PUB.add;
337: RAISE fnd_api.g_exc_error;
338: END IF;
339:
340: ELSIF (l_error_handle = 'ERROR') THEN

Line 344: FND_MSG_PUB.add;

340: ELSIF (l_error_handle = 'ERROR') THEN
341: ----------------------------------------------------
342: -- reject merge
343: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');
344: FND_MSG_PUB.add;
345: x_return_status := fnd_api.g_ret_sts_error;
346: RAISE fnd_api.g_exc_error;
347: ----------------------------------------------------
348: END IF;

Line 465: FND_MSG_PUB.add;

461: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
462: fnd_message.set_token('P_SQLCODE',SQLCODE);
463: fnd_message.set_token('P_SQLERRM',SQLERRM);
464: fnd_message.set_token('P_API_NAME', l_api_name);
465: FND_MSG_PUB.add;
466: x_return_status := fnd_api.g_ret_sts_unexp_error;
467: END resource_party_merge;
468:
469:

Line 553: FND_MSG_PUB.add;

549: then
550: fnd_message.set_name ('JTF', 'JTF_RS_ENTITY_NAME_ERR');
551: fnd_message.set_token('P_ENTITY',p_entity_name);
552: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
553: FND_MSG_PUB.add;
554: RAISE fnd_api.g_exc_error;
555: end if;
556:
557: -- get the values of the from record

Line 608: FND_MSG_PUB.add;

604:
605: IF (nvl(l_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success) then
606: x_return_status := l_return_status ;
607: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');
608: FND_MSG_PUB.add;
609: RAISE fnd_api.g_exc_error;
610: END IF;
611:
612: ELSIF (l_error_handle = 'ERROR') THEN

Line 616: FND_MSG_PUB.add;

612: ELSIF (l_error_handle = 'ERROR') THEN
613: ----------------------------------------------------
614: --reject merge
615: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');
616: FND_MSG_PUB.add;
617: x_return_status := fnd_api.g_ret_sts_error;
618: RAISE fnd_api.g_exc_error;
619: ----------------------------------------------------
620: END IF;

Line 693: FND_MSG_PUB.add;

689: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
690: fnd_message.set_token('P_SQLCODE',SQLCODE);
691: fnd_message.set_token('P_SQLERRM',SQLERRM);
692: fnd_message.set_token('P_API_NAME', l_api_name);
693: FND_MSG_PUB.add;
694: x_return_status := fnd_api.g_ret_sts_unexp_error;
695: end resource_party_site_merge;
696:
697: PROCEDURE resource_party_cont_merge(

Line 761: FND_MSG_PUB.add;

757: then
758: fnd_message.set_name ('JTF', 'JTF_RS_ENTITY_NAME_ERR');
759: fnd_message.set_token('P_ENTITY',p_entity_name);
760: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
761: FND_MSG_PUB.add;
762: RAISE fnd_api.g_exc_error;
763: end if;
764:
765: FOR res_rec IN res_cur(p_from_fk_id) LOOP

Line 775: FND_MSG_PUB.add;

771: p_to_fk_id) ;
772: fetch cont_cur into dummy ;
773: if cont_cur%NOTFOUND then
774: fnd_message.set_name ('JTF', 'JTF_RS_VALID_TO_ID_ERR');
775: FND_MSG_PUB.add;
776: x_return_status := fnd_api.g_ret_sts_error;
777: RAISE fnd_api.g_exc_error;
778: else
779: */

Line 836: FND_MSG_PUB.add;

832: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
833: fnd_message.set_token('P_SQLCODE',SQLCODE);
834: fnd_message.set_token('P_SQLERRM',SQLERRM);
835: fnd_message.set_token('P_API_NAME', l_api_name);
836: FND_MSG_PUB.add;
837: x_return_status := fnd_api.g_ret_sts_unexp_error;
838: end resource_party_cont_merge;
839:
840: PROCEDURE synchronize_resource(p_resource_id IN NUMBER,

Line 1158: FND_MSG_PUB.add;

1154: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1155: fnd_message.set_token('P_SQLCODE',SQLCODE);
1156: fnd_message.set_token('P_SQLERRM',SQLERRM);
1157: fnd_message.set_token('P_API_NAME', l_api_name);
1158: FND_MSG_PUB.add;
1159: x_ret_status := fnd_api.g_ret_sts_error;
1160:
1161: end synchronize_resource;
1162:

Line 1224: FND_MSG_PUB.add;

1220: then
1221: fnd_message.set_name ('JTF', 'JTF_RS_ENTITY_NAME_ERR');
1222: fnd_message.set_token('P_ENTITY',p_entity_name);
1223: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
1224: FND_MSG_PUB.add;
1225: RAISE fnd_api.g_exc_error;
1226: end if;
1227:
1228: FOR res_rec IN res_cur(p_from_fk_id) LOOP

Line 1233: -- FND_MSG_PUB.add;

1229: -- open support_site_cur(p_to_fk_id) ;
1230: -- fetch support_site_cur into dummy ;
1231: -- if support_site_cur%NOTFOUND then
1232: -- fnd_message.set_name ('JTF', 'JTF_RS_VALID_TO_ID_ERR');
1233: -- FND_MSG_PUB.add;
1234: -- x_return_status := fnd_api.g_ret_sts_error;
1235: -- RAISE fnd_api.g_exc_error;
1236: -- else
1237: update jtf_rs_resource_extns

Line 1292: FND_MSG_PUB.add;

1288: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1289: fnd_message.set_token('P_SQLCODE',SQLCODE);
1290: fnd_message.set_token('P_SQLERRM',SQLERRM);
1291: fnd_message.set_token('P_API_NAME', l_api_name);
1292: FND_MSG_PUB.add;
1293: x_return_status := fnd_api.g_ret_sts_unexp_error;
1294: end resource_support_site_merge;
1295:
1296: end;