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.JTF_RS_RESOURCE_EXTNS_AUD_PVT dependencies on FND_API

Line 66: x_return_status := fnd_api.g_ret_sts_success;

62:
63: --Standard Start of API SAVEPOINT
64: SAVEPOINT RESOURCE_EXTN_AUDIT;
65:
66: x_return_status := fnd_api.g_ret_sts_success;
67:
68: --Standard Call to check API compatibility
69: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
70: THEN

Line 69: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

65:
66: x_return_status := fnd_api.g_ret_sts_success;
67:
68: --Standard Call to check API compatibility
69: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
70: THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:

Line 71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

67:
68: --Standard Call to check API compatibility
69: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
70: THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:
74: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
75: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 75: IF FND_API.To_boolean(P_INIT_MSG_LIST)

71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:
74: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
75: IF FND_API.To_boolean(P_INIT_MSG_LIST)
76: THEN
77: FND_MSG_PUB.Initialize;
78: END IF;
79:

Line 159: IF fnd_api.to_boolean (p_commit)

155:
156:
157:
158:
159: IF fnd_api.to_boolean (p_commit)
160: THEN
161: COMMIT WORK;
162: END IF;
163:

Line 168: WHEN fnd_api.g_exc_unexpected_error

164: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
165:
166:
167: EXCEPTION
168: WHEN fnd_api.g_exc_unexpected_error
169: THEN
170: ROLLBACK TO resource_extn_audit;
171: x_return_status := fnd_api.g_ret_sts_unexp_error;
172: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');

Line 171: x_return_status := fnd_api.g_ret_sts_unexp_error;

167: EXCEPTION
168: WHEN fnd_api.g_exc_unexpected_error
169: THEN
170: ROLLBACK TO resource_extn_audit;
171: x_return_status := fnd_api.g_ret_sts_unexp_error;
172: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
173: FND_MSG_PUB.add;
174: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
175: WHEN OTHERS

Line 178: x_return_status := fnd_api.g_ret_sts_unexp_error;

174: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
175: WHEN OTHERS
176: THEN
177: ROLLBACK TO resource_extn_audit;
178: x_return_status := fnd_api.g_ret_sts_unexp_error;
179: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
180: FND_MSG_PUB.add;
181: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
182:

Line 275: x_return_status := fnd_api.g_ret_sts_success;

271:
272: --Standard Start of API SAVEPOINT
273: SAVEPOINT RESOURCE_EXTN_AUDIT;
274:
275: x_return_status := fnd_api.g_ret_sts_success;
276:
277: --Standard Call to check API compatibility
278: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
279: THEN

Line 278: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

274:
275: x_return_status := fnd_api.g_ret_sts_success;
276:
277: --Standard Call to check API compatibility
278: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
279: THEN
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:

Line 280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

276:
277: --Standard Call to check API compatibility
278: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
279: THEN
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:
283: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
284: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 284: IF FND_API.To_boolean(P_INIT_MSG_LIST)

280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:
283: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
284: IF FND_API.To_boolean(P_INIT_MSG_LIST)
285: THEN
286: FND_MSG_PUB.Initialize;
287: END IF;
288:

Line 436: IF fnd_api.to_boolean (p_commit)

432: X_OLD_SOURCE_PAGER => null
433: );
434:
435:
436: IF fnd_api.to_boolean (p_commit)
437: THEN
438: COMMIT WORK;
439: END IF;
440:

Line 445: WHEN fnd_api.g_exc_unexpected_error

441: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
442:
443:
444: EXCEPTION
445: WHEN fnd_api.g_exc_unexpected_error
446: THEN
447: ROLLBACK TO resource_extn_audit;
448: x_return_status := fnd_api.g_ret_sts_unexp_error;
449: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');

Line 448: x_return_status := fnd_api.g_ret_sts_unexp_error;

444: EXCEPTION
445: WHEN fnd_api.g_exc_unexpected_error
446: THEN
447: ROLLBACK TO resource_extn_audit;
448: x_return_status := fnd_api.g_ret_sts_unexp_error;
449: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
450: FND_MSG_PUB.add;
451: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
452: WHEN OTHERS

Line 455: x_return_status := fnd_api.g_ret_sts_unexp_error;

451: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
452: WHEN OTHERS
453: THEN
454: ROLLBACK TO resource_extn_audit;
455: x_return_status := fnd_api.g_ret_sts_unexp_error;
456: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
457: FND_MSG_PUB.add;
458: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
459:

Line 617: x_return_status := fnd_api.g_ret_sts_success;

613:
614: --Standard Start of API SAVEPOINT
615: SAVEPOINT RESOURCE_EXTN_AUDIT;
616:
617: x_return_status := fnd_api.g_ret_sts_success;
618:
619: --Standard Call to check API compatibility
620: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
621: THEN

Line 620: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

616:
617: x_return_status := fnd_api.g_ret_sts_success;
618:
619: --Standard Call to check API compatibility
620: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
621: THEN
622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:

Line 622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

618:
619: --Standard Call to check API compatibility
620: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
621: THEN
622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:
625: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
626: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 626: IF FND_API.To_boolean(P_INIT_MSG_LIST)

622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:
625: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
626: IF FND_API.To_boolean(P_INIT_MSG_LIST)
627: THEN
628: FND_MSG_PUB.Initialize;
629: END IF;
630:

Line 640: if nvl(p_category,fnd_api.g_miss_char) <> NVL(rr_old_rec.category,fnd_api.g_miss_char)

636: open rr_old_cur(p_resource_id);
637: FETCH rr_old_cur into rr_old_rec;
638: close rr_old_cur;
639:
640: if nvl(p_category,fnd_api.g_miss_char) <> NVL(rr_old_rec.category,fnd_api.g_miss_char)
641: then
642: l_category := rr_old_rec.category;
643: l_category_n := p_category;
644: end if;

Line 645: if nvl(p_resource_number,fnd_api.g_miss_char) <> nvl(rr_old_rec.resource_number, fnd_api.g_miss_char)

641: then
642: l_category := rr_old_rec.category;
643: l_category_n := p_category;
644: end if;
645: if nvl(p_resource_number,fnd_api.g_miss_char) <> nvl(rr_old_rec.resource_number, fnd_api.g_miss_char)
646: then
647: l_resource_number := rr_old_rec.resource_number;
648: l_resource_number_n:= p_resource_number;
649: end if;

Line 675: if nvl(p_end_date_active,fnd_api.g_miss_date)<> nvl(rr_old_rec.end_date_active,fnd_api.g_miss_date)

671: then
672: l_start_date_active := rr_old_rec.start_date_active;
673: l_start_date_active_n := p_start_date_active ;
674: end if;
675: if nvl(p_end_date_active,fnd_api.g_miss_date)<> nvl(rr_old_rec.end_date_active,fnd_api.g_miss_date)
676: then
677: l_end_date_active := rr_old_rec.end_date_active;
678: l_end_date_active_n := p_end_date_active ;
679: end if;

Line 690: if nvl(p_primary_language, fnd_api.g_miss_char) <> nvl(rr_old_rec.primary_language,fnd_api.g_miss_char)

686: then
687: l_cost_per_hr := rr_old_rec.cost_per_hr;
688: l_cost_per_hr_n := p_cost_per_hr ;
689: end if;
690: if nvl(p_primary_language, fnd_api.g_miss_char) <> nvl(rr_old_rec.primary_language,fnd_api.g_miss_char)
691: then
692: l_primary_language := rr_old_rec.primary_language;
693: l_primary_language_n := p_primary_language;
694: end if;

Line 695: if nvl(p_secondary_language,fnd_api.g_miss_char) <> nvl(rr_old_rec.secondary_language, fnd_api.g_miss_char)

691: then
692: l_primary_language := rr_old_rec.primary_language;
693: l_primary_language_n := p_primary_language;
694: end if;
695: if nvl(p_secondary_language,fnd_api.g_miss_char) <> nvl(rr_old_rec.secondary_language, fnd_api.g_miss_char)
696: then
697: l_secondary_language := rr_old_rec.secondary_language;
698: l_secondary_language_n := p_secondary_language;
699: end if;

Line 700: if nvl(p_support_site_id,fnd_api.g_miss_num) <> nvl(rr_old_rec.support_site_id,fnd_api.g_miss_num)

696: then
697: l_secondary_language := rr_old_rec.secondary_language;
698: l_secondary_language_n := p_secondary_language;
699: end if;
700: if nvl(p_support_site_id,fnd_api.g_miss_num) <> nvl(rr_old_rec.support_site_id,fnd_api.g_miss_num)
701: then
702: l_support_site_id := rr_old_rec.support_site_id;
703: l_support_site_id_n := p_support_site_id ;
704: end if;

Line 705: if nvl(p_ies_agent_login, fnd_api.g_miss_char)<> nvl(rr_old_rec.ies_agent_login, fnd_api.g_miss_char)

701: then
702: l_support_site_id := rr_old_rec.support_site_id;
703: l_support_site_id_n := p_support_site_id ;
704: end if;
705: if nvl(p_ies_agent_login, fnd_api.g_miss_char)<> nvl(rr_old_rec.ies_agent_login, fnd_api.g_miss_char)
706: then
707: l_ies_agent_login := rr_old_rec.ies_agent_login;
708: l_ies_agent_login_n := p_ies_agent_login ;
709: end if;

Line 710: if nvl(p_server_group_id ,fnd_api.g_miss_num) <> nvl(rr_old_rec.server_group_id, fnd_api.g_miss_num)

706: then
707: l_ies_agent_login := rr_old_rec.ies_agent_login;
708: l_ies_agent_login_n := p_ies_agent_login ;
709: end if;
710: if nvl(p_server_group_id ,fnd_api.g_miss_num) <> nvl(rr_old_rec.server_group_id, fnd_api.g_miss_num)
711: then
712: l_server_group_id := rr_old_rec.server_group_id;
713: l_server_group_id_n := p_server_group_id ;
714: end if;

Line 725: if nvl(p_cost_center,fnd_api.g_miss_char) <> nvl(rr_old_rec.cost_center, fnd_api.g_miss_char)

721: then
722: l_assigned_to_group_id := rr_old_rec.assigned_to_group_id;
723: l_assigned_to_group_id_n := p_assigned_to_group_id;
724: end if;
725: if nvl(p_cost_center,fnd_api.g_miss_char) <> nvl(rr_old_rec.cost_center, fnd_api.g_miss_char)
726: then
727: l_cost_center := rr_old_rec.cost_center;
728: l_cost_center_n := p_cost_center ;
729: end if;

Line 730: if nvl(p_charge_to_cost_center,fnd_api.g_miss_char) <> nvl(rr_old_rec.charge_to_cost_center, fnd_api.g_miss_char)

726: then
727: l_cost_center := rr_old_rec.cost_center;
728: l_cost_center_n := p_cost_center ;
729: end if;
730: if nvl(p_charge_to_cost_center,fnd_api.g_miss_char) <> nvl(rr_old_rec.charge_to_cost_center, fnd_api.g_miss_char)
731: then
732: l_charge_to_cost_center := rr_old_rec.charge_to_cost_center;
733: l_charge_to_cost_center_n := p_charge_to_cost_center ;
734: end if;

Line 735: if nvl(p_comp_currency_code,fnd_api.g_miss_char) <> nvl(rr_old_rec.compensation_currency_code,fnd_api.g_miss_char)

731: then
732: l_charge_to_cost_center := rr_old_rec.charge_to_cost_center;
733: l_charge_to_cost_center_n := p_charge_to_cost_center ;
734: end if;
735: if nvl(p_comp_currency_code,fnd_api.g_miss_char) <> nvl(rr_old_rec.compensation_currency_code,fnd_api.g_miss_char)
736: then
737: l_comp_currency_code := rr_old_rec.compensation_currency_code;
738: l_comp_currency_code_n := p_comp_currency_code ;
739: end if;

Line 740: if nvl(p_commissionable_flag,fnd_api.g_miss_char) <> nvl(rr_old_rec.commissionable_flag , fnd_api.g_miss_char)

736: then
737: l_comp_currency_code := rr_old_rec.compensation_currency_code;
738: l_comp_currency_code_n := p_comp_currency_code ;
739: end if;
740: if nvl(p_commissionable_flag,fnd_api.g_miss_char) <> nvl(rr_old_rec.commissionable_flag , fnd_api.g_miss_char)
741: then
742: l_commissionable_flag := rr_old_rec.commissionable_flag;
743: l_commissionable_flag_n := p_commissionable_flag ;
744: end if;

Line 745: if nvl(p_hold_reason_code,fnd_api.g_miss_char) <> nvl(rr_old_rec.hold_reason_code, fnd_api.g_miss_char)

741: then
742: l_commissionable_flag := rr_old_rec.commissionable_flag;
743: l_commissionable_flag_n := p_commissionable_flag ;
744: end if;
745: if nvl(p_hold_reason_code,fnd_api.g_miss_char) <> nvl(rr_old_rec.hold_reason_code, fnd_api.g_miss_char)
746: then
747: l_hold_reason_code := rr_old_rec.hold_reason_code;
748: l_hold_reason_code_n := p_hold_reason_code ;
749: end if;

Line 750: if nvl(p_hold_payment,fnd_api.g_miss_char) <> nvl(rr_old_rec.hold_payment, fnd_api.g_miss_char)

746: then
747: l_hold_reason_code := rr_old_rec.hold_reason_code;
748: l_hold_reason_code_n := p_hold_reason_code ;
749: end if;
750: if nvl(p_hold_payment,fnd_api.g_miss_char) <> nvl(rr_old_rec.hold_payment, fnd_api.g_miss_char)
751: then
752: l_hold_payment:= rr_old_rec.hold_payment;
753: l_hold_payment_n := p_hold_payment ;
754: end if;

Line 780: if nvl(p_user_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.user_id, fnd_api.g_miss_num)

776: then
777: l_object_version_number := rr_old_rec.object_version_number;
778: l_object_version_number_n := p_object_version_number;
779: end if;
780: if nvl(p_user_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.user_id, fnd_api.g_miss_num)
781: then
782: l_user_id_o := rr_old_rec.user_id;
783: l_user_id_n := p_user_id;
784: end if;

Line 859: IF fnd_api.to_boolean (p_commit)

855:
856:
857:
858:
859: IF fnd_api.to_boolean (p_commit)
860: THEN
861: COMMIT WORK;
862: END IF;
863:

Line 868: WHEN fnd_api.g_exc_unexpected_error

864: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
865:
866:
867: EXCEPTION
868: WHEN fnd_api.g_exc_unexpected_error
869: THEN
870: ROLLBACK TO resource_extn_audit;
871: x_return_status := fnd_api.g_ret_sts_unexp_error;
872: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');

Line 871: x_return_status := fnd_api.g_ret_sts_unexp_error;

867: EXCEPTION
868: WHEN fnd_api.g_exc_unexpected_error
869: THEN
870: ROLLBACK TO resource_extn_audit;
871: x_return_status := fnd_api.g_ret_sts_unexp_error;
872: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
873: FND_MSG_PUB.add;
874: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
875: WHEN OTHERS

Line 878: x_return_status := fnd_api.g_ret_sts_unexp_error;

874: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
875: WHEN OTHERS
876: THEN
877: ROLLBACK TO resource_extn_audit;
878: x_return_status := fnd_api.g_ret_sts_unexp_error;
879: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
880: FND_MSG_PUB.add;
881: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
882:

Line 1186: x_return_status := fnd_api.g_ret_sts_success;

1182:
1183: --Standard Start of API SAVEPOINT
1184: SAVEPOINT RESOURCE_EXTN_AUDIT;
1185:
1186: x_return_status := fnd_api.g_ret_sts_success;
1187:
1188: --Standard Call to check API compatibility
1189: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1190: THEN

Line 1189: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

1185:
1186: x_return_status := fnd_api.g_ret_sts_success;
1187:
1188: --Standard Call to check API compatibility
1189: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1190: THEN
1191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1192: END IF;
1193:

Line 1191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1187:
1188: --Standard Call to check API compatibility
1189: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1190: THEN
1191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1192: END IF;
1193:
1194: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1195: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 1195: IF FND_API.To_boolean(P_INIT_MSG_LIST)

1191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1192: END IF;
1193:
1194: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1195: IF FND_API.To_boolean(P_INIT_MSG_LIST)
1196: THEN
1197: FND_MSG_PUB.Initialize;
1198: END IF;
1199:

Line 1209: if nvl(p_category,fnd_api.g_miss_char) <> NVL(rr_old_rec.category,fnd_api.g_miss_char)

1205: open rr_old_cur(p_resource_id);
1206: FETCH rr_old_cur into rr_old_rec;
1207: close rr_old_cur;
1208:
1209: if nvl(p_category,fnd_api.g_miss_char) <> NVL(rr_old_rec.category,fnd_api.g_miss_char)
1210: then
1211: l_category := rr_old_rec.category;
1212: l_category_n := p_category;
1213: end if;

Line 1214: if nvl(p_resource_number,fnd_api.g_miss_char) <> nvl(rr_old_rec.resource_number, fnd_api.g_miss_char)

1210: then
1211: l_category := rr_old_rec.category;
1212: l_category_n := p_category;
1213: end if;
1214: if nvl(p_resource_number,fnd_api.g_miss_char) <> nvl(rr_old_rec.resource_number, fnd_api.g_miss_char)
1215: then
1216: l_resource_number := rr_old_rec.resource_number;
1217: l_resource_number_n:= p_resource_number;
1218: end if;

Line 1244: if nvl(p_end_date_active,fnd_api.g_miss_date)<> nvl(rr_old_rec.end_date_active,fnd_api.g_miss_date)

1240: then
1241: l_start_date_active := rr_old_rec.start_date_active;
1242: l_start_date_active_n := p_start_date_active ;
1243: end if;
1244: if nvl(p_end_date_active,fnd_api.g_miss_date)<> nvl(rr_old_rec.end_date_active,fnd_api.g_miss_date)
1245: then
1246: l_end_date_active := rr_old_rec.end_date_active;
1247: l_end_date_active_n := p_end_date_active ;
1248: end if;

Line 1259: if nvl(p_primary_language, fnd_api.g_miss_char) <> nvl(rr_old_rec.primary_language,fnd_api.g_miss_char)

1255: then
1256: l_cost_per_hr := rr_old_rec.cost_per_hr;
1257: l_cost_per_hr_n := p_cost_per_hr ;
1258: end if;
1259: if nvl(p_primary_language, fnd_api.g_miss_char) <> nvl(rr_old_rec.primary_language,fnd_api.g_miss_char)
1260: then
1261: l_primary_language := rr_old_rec.primary_language;
1262: l_primary_language_n := p_primary_language;
1263: end if;

Line 1264: if nvl(p_secondary_language,fnd_api.g_miss_char) <> nvl(rr_old_rec.secondary_language, fnd_api.g_miss_char)

1260: then
1261: l_primary_language := rr_old_rec.primary_language;
1262: l_primary_language_n := p_primary_language;
1263: end if;
1264: if nvl(p_secondary_language,fnd_api.g_miss_char) <> nvl(rr_old_rec.secondary_language, fnd_api.g_miss_char)
1265: then
1266: l_secondary_language := rr_old_rec.secondary_language;
1267: l_secondary_language_n := p_secondary_language;
1268: end if;

Line 1269: if nvl(p_support_site_id,fnd_api.g_miss_num) <> nvl(rr_old_rec.support_site_id,fnd_api.g_miss_num)

1265: then
1266: l_secondary_language := rr_old_rec.secondary_language;
1267: l_secondary_language_n := p_secondary_language;
1268: end if;
1269: if nvl(p_support_site_id,fnd_api.g_miss_num) <> nvl(rr_old_rec.support_site_id,fnd_api.g_miss_num)
1270: then
1271: l_support_site_id := rr_old_rec.support_site_id;
1272: l_support_site_id_n := p_support_site_id ;
1273: end if;

Line 1274: if nvl(p_ies_agent_login, fnd_api.g_miss_char)<> nvl(rr_old_rec.ies_agent_login, fnd_api.g_miss_char)

1270: then
1271: l_support_site_id := rr_old_rec.support_site_id;
1272: l_support_site_id_n := p_support_site_id ;
1273: end if;
1274: if nvl(p_ies_agent_login, fnd_api.g_miss_char)<> nvl(rr_old_rec.ies_agent_login, fnd_api.g_miss_char)
1275: then
1276: l_ies_agent_login := rr_old_rec.ies_agent_login;
1277: l_ies_agent_login_n := p_ies_agent_login ;
1278: end if;

Line 1279: if nvl(p_server_group_id ,fnd_api.g_miss_num) <> nvl(rr_old_rec.server_group_id, fnd_api.g_miss_num)

1275: then
1276: l_ies_agent_login := rr_old_rec.ies_agent_login;
1277: l_ies_agent_login_n := p_ies_agent_login ;
1278: end if;
1279: if nvl(p_server_group_id ,fnd_api.g_miss_num) <> nvl(rr_old_rec.server_group_id, fnd_api.g_miss_num)
1280: then
1281: l_server_group_id := rr_old_rec.server_group_id;
1282: l_server_group_id_n := p_server_group_id ;
1283: end if;

Line 1294: if nvl(p_cost_center,fnd_api.g_miss_char) <> nvl(rr_old_rec.cost_center, fnd_api.g_miss_char)

1290: then
1291: l_assigned_to_group_id := rr_old_rec.assigned_to_group_id;
1292: l_assigned_to_group_id_n := p_assigned_to_group_id;
1293: end if;
1294: if nvl(p_cost_center,fnd_api.g_miss_char) <> nvl(rr_old_rec.cost_center, fnd_api.g_miss_char)
1295: then
1296: l_cost_center := rr_old_rec.cost_center;
1297: l_cost_center_n := p_cost_center ;
1298: end if;

Line 1299: if nvl(p_charge_to_cost_center,fnd_api.g_miss_char) <> nvl(rr_old_rec.charge_to_cost_center, fnd_api.g_miss_char)

1295: then
1296: l_cost_center := rr_old_rec.cost_center;
1297: l_cost_center_n := p_cost_center ;
1298: end if;
1299: if nvl(p_charge_to_cost_center,fnd_api.g_miss_char) <> nvl(rr_old_rec.charge_to_cost_center, fnd_api.g_miss_char)
1300: then
1301: l_charge_to_cost_center := rr_old_rec.charge_to_cost_center;
1302: l_charge_to_cost_center_n := p_charge_to_cost_center ;
1303: end if;

Line 1304: if nvl(p_comp_currency_code,fnd_api.g_miss_char) <> nvl(rr_old_rec.compensation_currency_code,fnd_api.g_miss_char)

1300: then
1301: l_charge_to_cost_center := rr_old_rec.charge_to_cost_center;
1302: l_charge_to_cost_center_n := p_charge_to_cost_center ;
1303: end if;
1304: if nvl(p_comp_currency_code,fnd_api.g_miss_char) <> nvl(rr_old_rec.compensation_currency_code,fnd_api.g_miss_char)
1305: then
1306: l_comp_currency_code := rr_old_rec.compensation_currency_code;
1307: l_comp_currency_code_n := p_comp_currency_code ;
1308: end if;

Line 1309: if nvl(p_commissionable_flag,fnd_api.g_miss_char) <> nvl(rr_old_rec.commissionable_flag , fnd_api.g_miss_char)

1305: then
1306: l_comp_currency_code := rr_old_rec.compensation_currency_code;
1307: l_comp_currency_code_n := p_comp_currency_code ;
1308: end if;
1309: if nvl(p_commissionable_flag,fnd_api.g_miss_char) <> nvl(rr_old_rec.commissionable_flag , fnd_api.g_miss_char)
1310: then
1311: l_commissionable_flag := rr_old_rec.commissionable_flag;
1312: l_commissionable_flag_n := p_commissionable_flag ;
1313: end if;

Line 1314: if nvl(p_hold_reason_code,fnd_api.g_miss_char) <> nvl(rr_old_rec.hold_reason_code, fnd_api.g_miss_char)

1310: then
1311: l_commissionable_flag := rr_old_rec.commissionable_flag;
1312: l_commissionable_flag_n := p_commissionable_flag ;
1313: end if;
1314: if nvl(p_hold_reason_code,fnd_api.g_miss_char) <> nvl(rr_old_rec.hold_reason_code, fnd_api.g_miss_char)
1315: then
1316: l_hold_reason_code := rr_old_rec.hold_reason_code;
1317: l_hold_reason_code_n := p_hold_reason_code ;
1318: end if;

Line 1319: if nvl(p_hold_payment,fnd_api.g_miss_char) <> nvl(rr_old_rec.hold_payment, fnd_api.g_miss_char)

1315: then
1316: l_hold_reason_code := rr_old_rec.hold_reason_code;
1317: l_hold_reason_code_n := p_hold_reason_code ;
1318: end if;
1319: if nvl(p_hold_payment,fnd_api.g_miss_char) <> nvl(rr_old_rec.hold_payment, fnd_api.g_miss_char)
1320: then
1321: l_hold_payment:= rr_old_rec.hold_payment;
1322: l_hold_payment_n := p_hold_payment ;
1323: end if;

Line 1349: if nvl(p_user_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.user_id, fnd_api.g_miss_num)

1345: then
1346: l_object_version_number := rr_old_rec.object_version_number;
1347: l_object_version_number_n := p_object_version_number;
1348: end if;
1349: if nvl(p_user_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.user_id, fnd_api.g_miss_num)
1350: then
1351: l_user_id_o := rr_old_rec.user_id;
1352: l_user_id_n := p_user_id;
1353: end if;

Line 1355: if nvl(p_resource_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.resource_name, fnd_api.g_miss_char)

1351: l_user_id_o := rr_old_rec.user_id;
1352: l_user_id_n := p_user_id;
1353: end if;
1354:
1355: if nvl(p_resource_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.resource_name, fnd_api.g_miss_char)
1356: then
1357: l_resource_name := rr_old_rec.resource_name;
1358: l_resource_name_n := p_resource_name;
1359: end if;

Line 1361: if nvl(p_source_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_name, fnd_api.g_miss_char)

1357: l_resource_name := rr_old_rec.resource_name;
1358: l_resource_name_n := p_resource_name;
1359: end if;
1360:
1361: if nvl(p_source_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_name, fnd_api.g_miss_char)
1362: then
1363: l_source_name := rr_old_rec.source_name;
1364: l_source_name_n := p_source_name;
1365: end if;

Line 1367: if nvl(p_source_job_title, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_job_title, fnd_api.g_miss_char)

1363: l_source_name := rr_old_rec.source_name;
1364: l_source_name_n := p_source_name;
1365: end if;
1366:
1367: if nvl(p_source_job_title, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_job_title, fnd_api.g_miss_char)
1368: then
1369: l_source_job_title := rr_old_rec.source_job_title;
1370: l_source_job_title_n := p_source_job_title;
1371: end if;

Line 1373: if nvl(p_source_email, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_email, fnd_api.g_miss_char)

1369: l_source_job_title := rr_old_rec.source_job_title;
1370: l_source_job_title_n := p_source_job_title;
1371: end if;
1372:
1373: if nvl(p_source_email, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_email, fnd_api.g_miss_char)
1374: then
1375: l_source_email := rr_old_rec.source_email;
1376: l_source_email_n := p_source_email;
1377: end if;

Line 1379: if nvl(p_source_number, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_number, fnd_api.g_miss_char)

1375: l_source_email := rr_old_rec.source_email;
1376: l_source_email_n := p_source_email;
1377: end if;
1378:
1379: if nvl(p_source_number, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_number, fnd_api.g_miss_char)
1380: then
1381: l_source_number := rr_old_rec.source_number;
1382: l_source_number_n := p_source_number;
1383: end if;

Line 1385: if nvl(p_source_phone, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_phone, fnd_api.g_miss_char)

1381: l_source_number := rr_old_rec.source_number;
1382: l_source_number_n := p_source_number;
1383: end if;
1384:
1385: if nvl(p_source_phone, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_phone, fnd_api.g_miss_char)
1386: then
1387: l_source_phone := rr_old_rec.source_phone;
1388: l_source_phone_n := p_source_phone;
1389: end if;

Line 1391: if nvl(p_source_org_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.source_org_id, fnd_api.g_miss_num)

1387: l_source_phone := rr_old_rec.source_phone;
1388: l_source_phone_n := p_source_phone;
1389: end if;
1390:
1391: if nvl(p_source_org_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.source_org_id, fnd_api.g_miss_num)
1392: then
1393: l_source_org_id := rr_old_rec.source_org_id;
1394: l_source_org_id_n := p_source_org_id;
1395: end if;

Line 1397: if nvl(p_source_org_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_org_name, fnd_api.g_miss_char)

1393: l_source_org_id := rr_old_rec.source_org_id;
1394: l_source_org_id_n := p_source_org_id;
1395: end if;
1396:
1397: if nvl(p_source_org_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_org_name, fnd_api.g_miss_char)
1398: then
1399: l_source_org_name := rr_old_rec.source_org_name;
1400: l_source_org_name_n := p_source_org_name;
1401: end if;

Line 1403: if nvl(p_source_address1, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_address1, fnd_api.g_miss_char)

1399: l_source_org_name := rr_old_rec.source_org_name;
1400: l_source_org_name_n := p_source_org_name;
1401: end if;
1402:
1403: if nvl(p_source_address1, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_address1, fnd_api.g_miss_char)
1404: then
1405: l_source_address1 := rr_old_rec.source_address1;
1406: l_source_address1_n := p_source_address1;
1407: end if;

Line 1409: if nvl(p_source_address2, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_address2, fnd_api.g_miss_char)

1405: l_source_address1 := rr_old_rec.source_address1;
1406: l_source_address1_n := p_source_address1;
1407: end if;
1408:
1409: if nvl(p_source_address2, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_address2, fnd_api.g_miss_char)
1410: then
1411: l_source_address2 := rr_old_rec.source_address2;
1412: l_source_address2_n := p_source_address2;
1413: end if;

Line 1415: if nvl(p_source_address3, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_address3, fnd_api.g_miss_char)

1411: l_source_address2 := rr_old_rec.source_address2;
1412: l_source_address2_n := p_source_address2;
1413: end if;
1414:
1415: if nvl(p_source_address3, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_address3, fnd_api.g_miss_char)
1416: then
1417: l_source_address3 := rr_old_rec.source_address3;
1418: l_source_address3_n := p_source_address3;
1419: end if;

Line 1421: if nvl(p_source_address4, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_address4, fnd_api.g_miss_char)

1417: l_source_address3 := rr_old_rec.source_address3;
1418: l_source_address3_n := p_source_address3;
1419: end if;
1420:
1421: if nvl(p_source_address4, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_address4, fnd_api.g_miss_char)
1422: then
1423: l_source_address4 := rr_old_rec.source_address4;
1424: l_source_address4_n := p_source_address4;
1425: end if;

Line 1427: if nvl(p_source_city, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_city, fnd_api.g_miss_char)

1423: l_source_address4 := rr_old_rec.source_address4;
1424: l_source_address4_n := p_source_address4;
1425: end if;
1426:
1427: if nvl(p_source_city, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_city, fnd_api.g_miss_char)
1428: then
1429: l_source_city := rr_old_rec.source_city;
1430: l_source_city_n := p_source_city;
1431: end if;

Line 1433: if nvl(p_source_postal_code, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_postal_code, fnd_api.g_miss_char)

1429: l_source_city := rr_old_rec.source_city;
1430: l_source_city_n := p_source_city;
1431: end if;
1432:
1433: if nvl(p_source_postal_code, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_postal_code, fnd_api.g_miss_char)
1434: then
1435: l_source_postal_code := rr_old_rec.source_postal_code;
1436: l_source_postal_code_n := p_source_postal_code;
1437: end if;

Line 1439: if nvl(p_source_state, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_state, fnd_api.g_miss_char)

1435: l_source_postal_code := rr_old_rec.source_postal_code;
1436: l_source_postal_code_n := p_source_postal_code;
1437: end if;
1438:
1439: if nvl(p_source_state, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_state, fnd_api.g_miss_char)
1440: then
1441: l_source_state := rr_old_rec.source_state;
1442: l_source_state_n := p_source_state;
1443: end if;

Line 1445: if nvl(p_source_province, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_province, fnd_api.g_miss_char)

1441: l_source_state := rr_old_rec.source_state;
1442: l_source_state_n := p_source_state;
1443: end if;
1444:
1445: if nvl(p_source_province, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_province, fnd_api.g_miss_char)
1446: then
1447: l_source_province := rr_old_rec.source_province;
1448: l_source_province_n := p_source_province;
1449: end if;

Line 1451: if nvl(p_source_county, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_county, fnd_api.g_miss_char)

1447: l_source_province := rr_old_rec.source_province;
1448: l_source_province_n := p_source_province;
1449: end if;
1450:
1451: if nvl(p_source_county, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_county, fnd_api.g_miss_char)
1452: then
1453: l_source_county := rr_old_rec.source_county;
1454: l_source_county_n := p_source_county;
1455: end if;

Line 1457: if nvl(p_source_country, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_country, fnd_api.g_miss_char)

1453: l_source_county := rr_old_rec.source_county;
1454: l_source_county_n := p_source_county;
1455: end if;
1456:
1457: if nvl(p_source_country, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_country, fnd_api.g_miss_char)
1458: then
1459: l_source_country := rr_old_rec.source_country;
1460: l_source_country_n := p_source_country;
1461: end if;

Line 1463: if nvl(p_source_mgr_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.source_mgr_id, fnd_api.g_miss_num)

1459: l_source_country := rr_old_rec.source_country;
1460: l_source_country_n := p_source_country;
1461: end if;
1462:
1463: if nvl(p_source_mgr_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.source_mgr_id, fnd_api.g_miss_num)
1464: then
1465: l_source_mgr_id := rr_old_rec.source_mgr_id;
1466: l_source_mgr_id_n := p_source_mgr_id;
1467: end if;

Line 1469: if nvl(p_source_mgr_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_mgr_name, fnd_api.g_miss_char)

1465: l_source_mgr_id := rr_old_rec.source_mgr_id;
1466: l_source_mgr_id_n := p_source_mgr_id;
1467: end if;
1468:
1469: if nvl(p_source_mgr_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_mgr_name, fnd_api.g_miss_char)
1470: then
1471: l_source_mgr_name := rr_old_rec.source_mgr_name;
1472: l_source_mgr_name_n := p_source_mgr_name;
1473: end if;

Line 1475: if nvl(p_source_business_grp_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.source_business_grp_id, fnd_api.g_miss_num)

1471: l_source_mgr_name := rr_old_rec.source_mgr_name;
1472: l_source_mgr_name_n := p_source_mgr_name;
1473: end if;
1474:
1475: if nvl(p_source_business_grp_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.source_business_grp_id, fnd_api.g_miss_num)
1476: then
1477: l_source_business_grp_id := rr_old_rec.source_business_grp_id;
1478: l_source_business_grp_id_n := p_source_business_grp_id;
1479: end if;

Line 1481: if nvl(p_source_business_grp_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_business_grp_name, fnd_api.g_miss_char)

1477: l_source_business_grp_id := rr_old_rec.source_business_grp_id;
1478: l_source_business_grp_id_n := p_source_business_grp_id;
1479: end if;
1480:
1481: if nvl(p_source_business_grp_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_business_grp_name, fnd_api.g_miss_char)
1482: then
1483: l_source_business_grp_name := rr_old_rec.source_business_grp_name;
1484: l_source_business_grp_name_n := p_source_business_grp_name;
1485: end if;

Line 1487: if nvl(p_source_first_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_first_name, fnd_api.g_miss_char)

1483: l_source_business_grp_name := rr_old_rec.source_business_grp_name;
1484: l_source_business_grp_name_n := p_source_business_grp_name;
1485: end if;
1486:
1487: if nvl(p_source_first_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_first_name, fnd_api.g_miss_char)
1488: then
1489: l_source_first_name := rr_old_rec.source_first_name;
1490: l_source_first_name_n := p_source_first_name;
1491: end if;

Line 1493: if nvl(p_source_middle_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_middle_name, fnd_api.g_miss_char)

1489: l_source_first_name := rr_old_rec.source_first_name;
1490: l_source_first_name_n := p_source_first_name;
1491: end if;
1492:
1493: if nvl(p_source_middle_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_middle_name, fnd_api.g_miss_char)
1494: then
1495: l_source_middle_name := rr_old_rec.source_middle_name;
1496: l_source_middle_name_n := p_source_middle_name;
1497: end if;

Line 1499: if nvl(p_source_last_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_last_name, fnd_api.g_miss_char)

1495: l_source_middle_name := rr_old_rec.source_middle_name;
1496: l_source_middle_name_n := p_source_middle_name;
1497: end if;
1498:
1499: if nvl(p_source_last_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_last_name, fnd_api.g_miss_char)
1500: then
1501: l_source_last_name := rr_old_rec.source_last_name;
1502: l_source_last_name_n := p_source_last_name;
1503: end if;

Line 1505: if nvl(p_source_category, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_category, fnd_api.g_miss_char)

1501: l_source_last_name := rr_old_rec.source_last_name;
1502: l_source_last_name_n := p_source_last_name;
1503: end if;
1504:
1505: if nvl(p_source_category, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_category, fnd_api.g_miss_char)
1506: then
1507: l_source_category := rr_old_rec.source_category;
1508: l_source_category_n := p_source_category;
1509: end if;

Line 1511: if nvl(p_source_status, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_status, fnd_api.g_miss_char)

1507: l_source_category := rr_old_rec.source_category;
1508: l_source_category_n := p_source_category;
1509: end if;
1510:
1511: if nvl(p_source_status, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_status, fnd_api.g_miss_char)
1512: then
1513: l_source_status := rr_old_rec.source_status;
1514: l_source_status_n := p_source_status;
1515: end if;

Line 1517: if nvl(p_source_office, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_office, fnd_api.g_miss_char)

1513: l_source_status := rr_old_rec.source_status;
1514: l_source_status_n := p_source_status;
1515: end if;
1516:
1517: if nvl(p_source_office, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_office, fnd_api.g_miss_char)
1518: then
1519: l_source_office := rr_old_rec.source_office;
1520: l_source_office_n := p_source_office;
1521: end if;

Line 1523: if nvl(p_source_location, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_location, fnd_api.g_miss_char)

1519: l_source_office := rr_old_rec.source_office;
1520: l_source_office_n := p_source_office;
1521: end if;
1522:
1523: if nvl(p_source_location, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_location, fnd_api.g_miss_char)
1524: then
1525: l_source_location := rr_old_rec.source_location;
1526: l_source_location_n := p_source_location;
1527: end if;

Line 1529: if nvl(p_source_mailstop, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_mailstop, fnd_api.g_miss_char)

1525: l_source_location := rr_old_rec.source_location;
1526: l_source_location_n := p_source_location;
1527: end if;
1528:
1529: if nvl(p_source_mailstop, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_mailstop, fnd_api.g_miss_char)
1530: then
1531: l_source_mailstop := rr_old_rec.source_mailstop;
1532: l_source_mailstop_n := p_source_mailstop;
1533: end if;

Line 1535: if nvl(p_source_mobile_phone, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_mobile_phone, fnd_api.g_miss_char)

1531: l_source_mailstop := rr_old_rec.source_mailstop;
1532: l_source_mailstop_n := p_source_mailstop;
1533: end if;
1534:
1535: if nvl(p_source_mobile_phone, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_mobile_phone, fnd_api.g_miss_char)
1536: then
1537: l_source_mobile_phone := rr_old_rec.source_mobile_phone;
1538: l_source_mobile_phone_n := p_source_mobile_phone;
1539: end if;

Line 1541: if nvl(p_source_pager, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_pager, fnd_api.g_miss_char)

1537: l_source_mobile_phone := rr_old_rec.source_mobile_phone;
1538: l_source_mobile_phone_n := p_source_mobile_phone;
1539: end if;
1540:
1541: if nvl(p_source_pager, fnd_api.g_miss_char) <> nvl(rr_old_rec.source_pager, fnd_api.g_miss_char)
1542: then
1543: l_source_pager := rr_old_rec.source_pager;
1544: l_source_pager_n := p_source_pager;
1545: end if;

Line 1547: if nvl(p_user_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.user_name, fnd_api.g_miss_char)

1543: l_source_pager := rr_old_rec.source_pager;
1544: l_source_pager_n := p_source_pager;
1545: end if;
1546:
1547: if nvl(p_user_name, fnd_api.g_miss_char) <> nvl(rr_old_rec.user_name, fnd_api.g_miss_char)
1548: then
1549: l_user_name := rr_old_rec.user_name;
1550: l_user_name_n := p_user_name;
1551: end if;

Line 1553: if nvl(p_source_job_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.source_job_id, fnd_api.g_miss_num)

1549: l_user_name := rr_old_rec.user_name;
1550: l_user_name_n := p_user_name;
1551: end if;
1552:
1553: if nvl(p_source_job_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.source_job_id, fnd_api.g_miss_num)
1554: then
1555: l_source_job_id := rr_old_rec.source_job_id;
1556: l_source_job_id_n := p_source_job_id;
1557: end if;

Line 1559: if nvl(p_party_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.person_party_id, fnd_api.g_miss_num)

1555: l_source_job_id := rr_old_rec.source_job_id;
1556: l_source_job_id_n := p_source_job_id;
1557: end if;
1558:
1559: if nvl(p_party_id, fnd_api.g_miss_num) <> nvl(rr_old_rec.person_party_id, fnd_api.g_miss_num)
1560: then
1561: l_party_id := rr_old_rec.person_party_id;
1562: l_party_id_n := p_party_id;
1563: end if;

Line 1566: if nvl(p_fs_setup_complete, fnd_api.g_miss_char) <> nvl(rr_old_rec.fs_setup_complete, fnd_api.g_miss_char)

1562: l_party_id_n := p_party_id;
1563: end if;
1564:
1565:
1566: if nvl(p_fs_setup_complete, fnd_api.g_miss_char) <> nvl(rr_old_rec.fs_setup_complete, fnd_api.g_miss_char)
1567: then
1568: l_fs_setup_complete := rr_old_rec.fs_setup_complete;
1569: l_fs_setup_complete_n := p_fs_setup_complete;
1570: end if;

Line 1715: IF fnd_api.to_boolean (p_commit)

1711: X_OLD_FS_SETUP_COMPLETE => l_fs_setup_complete
1712: );
1713:
1714:
1715: IF fnd_api.to_boolean (p_commit)
1716: THEN
1717: COMMIT WORK;
1718: END IF;
1719:

Line 1724: WHEN fnd_api.g_exc_unexpected_error

1720: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1721:
1722:
1723: EXCEPTION
1724: WHEN fnd_api.g_exc_unexpected_error
1725: THEN
1726: ROLLBACK TO resource_extn_audit;
1727: x_return_status := fnd_api.g_ret_sts_unexp_error;
1728: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');

Line 1727: x_return_status := fnd_api.g_ret_sts_unexp_error;

1723: EXCEPTION
1724: WHEN fnd_api.g_exc_unexpected_error
1725: THEN
1726: ROLLBACK TO resource_extn_audit;
1727: x_return_status := fnd_api.g_ret_sts_unexp_error;
1728: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
1729: FND_MSG_PUB.add;
1730: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1731: WHEN OTHERS

Line 1734: x_return_status := fnd_api.g_ret_sts_unexp_error;

1730: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1731: WHEN OTHERS
1732: THEN
1733: ROLLBACK TO resource_extn_audit;
1734: x_return_status := fnd_api.g_ret_sts_unexp_error;
1735: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
1736: FND_MSG_PUB.add;
1737: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1738:

Line 1902: x_return_status := fnd_api.g_ret_sts_success;

1898:
1899: --Standard Start of API SAVEPOINT
1900: SAVEPOINT RESOURCE_EXTN_AUDIT;
1901:
1902: x_return_status := fnd_api.g_ret_sts_success;
1903:
1904: --Standard Call to check API compatibility
1905: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1906: THEN

Line 1905: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

1901:
1902: x_return_status := fnd_api.g_ret_sts_success;
1903:
1904: --Standard Call to check API compatibility
1905: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1906: THEN
1907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1908: END IF;
1909:

Line 1907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1903:
1904: --Standard Call to check API compatibility
1905: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1906: THEN
1907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1908: END IF;
1909:
1910: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1911: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 1911: IF FND_API.To_boolean(P_INIT_MSG_LIST)

1907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1908: END IF;
1909:
1910: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1911: IF FND_API.To_boolean(P_INIT_MSG_LIST)
1912: THEN
1913: FND_MSG_PUB.Initialize;
1914: END IF;
1915:

Line 2124: IF fnd_api.to_boolean (p_commit)

2120: X_OLD_SOURCE_PAGER => l_source_pager
2121: );
2122:
2123:
2124: IF fnd_api.to_boolean (p_commit)
2125: THEN
2126: COMMIT WORK;
2127: END IF;
2128:

Line 2133: WHEN fnd_api.g_exc_unexpected_error

2129: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2130:
2131:
2132: EXCEPTION
2133: WHEN fnd_api.g_exc_unexpected_error
2134: THEN
2135: ROLLBACK TO resource_extn_audit;
2136: x_return_status := fnd_api.g_ret_sts_unexp_error;
2137: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');

Line 2136: x_return_status := fnd_api.g_ret_sts_unexp_error;

2132: EXCEPTION
2133: WHEN fnd_api.g_exc_unexpected_error
2134: THEN
2135: ROLLBACK TO resource_extn_audit;
2136: x_return_status := fnd_api.g_ret_sts_unexp_error;
2137: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
2138: FND_MSG_PUB.add;
2139: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2140: WHEN OTHERS

Line 2143: x_return_status := fnd_api.g_ret_sts_unexp_error;

2139: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2140: WHEN OTHERS
2141: THEN
2142: ROLLBACK TO resource_extn_audit;
2143: x_return_status := fnd_api.g_ret_sts_unexp_error;
2144: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
2145: FND_MSG_PUB.add;
2146: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2147: