DBA Data[Home] [Help]

APPS.JTF_RS_PARTY_MERGE_PUB dependencies on FND_MESSAGE

Line 127: fnd_message.set_name ('JTF', 'JTF_RS_ENTITY_NAME_ERR');

123:
124: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')
125: or (p_parent_entity_name <> 'HZ_PARTIES')
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;

Line 128: fnd_message.set_token('P_ENTITY',p_entity_name);

124: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')
125: or (p_parent_entity_name <> 'HZ_PARTIES')
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;

Line 129: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);

125: or (p_parent_entity_name <> 'HZ_PARTIES')
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:

Line 183: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');

179: X_MSG_DATA => l_msg_data ) ;
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:

Line 191: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');

187:
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: ----------------------------------------------------

Line 335: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');

331: X_MSG_DATA => l_msg_data ) ;
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:

Line 343: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');

339:
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: ----------------------------------------------------

Line 461: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

457: x_return_status := fnd_api.g_ret_sts_error;
458: WHEN OTHERS
459: THEN
460: ROLLBACK TO PARTY_MERGE_SP;
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;

Line 462: fnd_message.set_token('P_SQLCODE',SQLCODE);

458: WHEN OTHERS
459: THEN
460: ROLLBACK TO PARTY_MERGE_SP;
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;

Line 463: fnd_message.set_token('P_SQLERRM',SQLERRM);

459: THEN
460: ROLLBACK TO PARTY_MERGE_SP;
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;

Line 464: fnd_message.set_token('P_API_NAME', l_api_name);

460: ROLLBACK TO PARTY_MERGE_SP;
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:

Line 550: fnd_message.set_name ('JTF', 'JTF_RS_ENTITY_NAME_ERR');

546:
547: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')
548: or (p_parent_entity_name <> 'HZ_PARTY_SITES')
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;

Line 551: fnd_message.set_token('P_ENTITY',p_entity_name);

547: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')
548: or (p_parent_entity_name <> 'HZ_PARTY_SITES')
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;

Line 552: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);

548: or (p_parent_entity_name <> 'HZ_PARTY_SITES')
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:

Line 607: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');

603: X_MSG_DATA => l_msg_data ) ;
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:

Line 615: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');

611:
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: ----------------------------------------------------

Line 689: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

685: x_return_status := fnd_api.g_ret_sts_error;
686: WHEN OTHERS
687: THEN
688: ROLLBACK TO site_merge_sp;
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;

Line 690: fnd_message.set_token('P_SQLCODE',SQLCODE);

686: WHEN OTHERS
687: THEN
688: ROLLBACK TO site_merge_sp;
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;

Line 691: fnd_message.set_token('P_SQLERRM',SQLERRM);

687: THEN
688: ROLLBACK TO site_merge_sp;
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;

Line 692: fnd_message.set_token('P_API_NAME', l_api_name);

688: ROLLBACK TO site_merge_sp;
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:

Line 758: fnd_message.set_name ('JTF', 'JTF_RS_ENTITY_NAME_ERR');

754:
755: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')
756: or (p_parent_entity_name <> 'HZ_ORG_CONTACTS')
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;

Line 759: fnd_message.set_token('P_ENTITY',p_entity_name);

755: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')
756: or (p_parent_entity_name <> 'HZ_ORG_CONTACTS')
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;

Line 760: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);

756: or (p_parent_entity_name <> 'HZ_ORG_CONTACTS')
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:

Line 774: fnd_message.set_name ('JTF', 'JTF_RS_VALID_TO_ID_ERR');

770: res_rec.address_id,
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

Line 832: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

828: x_return_status := fnd_api.g_ret_sts_error;
829: WHEN OTHERS
830: THEN
831: ROLLBACK TO cont_merge_sp;
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;

Line 833: fnd_message.set_token('P_SQLCODE',SQLCODE);

829: WHEN OTHERS
830: THEN
831: ROLLBACK TO cont_merge_sp;
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;

Line 834: fnd_message.set_token('P_SQLERRM',SQLERRM);

830: THEN
831: ROLLBACK TO cont_merge_sp;
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;

Line 835: fnd_message.set_token('P_API_NAME', l_api_name);

831: ROLLBACK TO cont_merge_sp;
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:

Line 1154: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

1150: x_ret_status := fnd_api.g_ret_sts_error;
1151: WHEN OTHERS
1152: THEN
1153: ROLLBACK TO synchronize_resource_sp;
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;

Line 1155: fnd_message.set_token('P_SQLCODE',SQLCODE);

1151: WHEN OTHERS
1152: THEN
1153: ROLLBACK TO synchronize_resource_sp;
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;

Line 1156: fnd_message.set_token('P_SQLERRM',SQLERRM);

1152: THEN
1153: ROLLBACK TO synchronize_resource_sp;
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:

Line 1157: fnd_message.set_token('P_API_NAME', l_api_name);

1153: ROLLBACK TO synchronize_resource_sp;
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;

Line 1221: fnd_message.set_name ('JTF', 'JTF_RS_ENTITY_NAME_ERR');

1217:
1218: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')
1219: or (p_parent_entity_name <> 'HZ_PARTY_SITES')
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;

Line 1222: fnd_message.set_token('P_ENTITY',p_entity_name);

1218: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')
1219: or (p_parent_entity_name <> 'HZ_PARTY_SITES')
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;

Line 1223: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);

1219: or (p_parent_entity_name <> 'HZ_PARTY_SITES')
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:

Line 1232: -- fnd_message.set_name ('JTF', 'JTF_RS_VALID_TO_ID_ERR');

1228: FOR res_rec IN res_cur(p_from_fk_id) LOOP
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

Line 1288: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

1284: x_return_status := fnd_api.g_ret_sts_error;
1285: WHEN OTHERS
1286: THEN
1287: ROLLBACK TO support_site_merge_sp;
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;

Line 1289: fnd_message.set_token('P_SQLCODE',SQLCODE);

1285: WHEN OTHERS
1286: THEN
1287: ROLLBACK TO support_site_merge_sp;
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;

Line 1290: fnd_message.set_token('P_SQLERRM',SQLERRM);

1286: THEN
1287: ROLLBACK TO support_site_merge_sp;
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;

Line 1291: fnd_message.set_token('P_API_NAME', l_api_name);

1287: ROLLBACK TO support_site_merge_sp;
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: