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

Line 76: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

72: p_msg_count => x_msg_count,
73: p_msg_data => x_msg_data
74: );
75:
76: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
77: RETURN;
78: END IF;
79:
80: -- Send the email to user about the new password

Line 103: x_return_status := fnd_api.g_ret_sts_success;

99:
100: wf_engine.StartProcess(itemtype => l_itemtype,
101: itemkey => l_itemkey);
102:
103: x_return_status := fnd_api.g_ret_sts_success;
104:
105: EXCEPTION
106: WHEN OTHERS THEN
107: pos_log.log_sqlerrm('POSADMB', 'in reset_password');

Line 158: x_return_status := fnd_api.g_ret_sts_success;

154: );
155: end if;
156:
157:
158: x_return_status := fnd_api.g_ret_sts_success;
159:
160: EXCEPTION
161: WHEN OTHERS THEN
162: pos_log.log_sqlerrm('POSADMB', 'in reset_password');

Line 176: x_return_status := fnd_api.g_ret_sts_success;

172: , x_msg_data OUT NOCOPY VARCHAR2
173: )
174: IS
175: BEGIN
176: x_return_status := fnd_api.g_ret_sts_success;
177: fnd_user_resp_groups_api.upload_assignment
178: ( user_id => p_user_id,
179: responsibility_id => p_resp_id,
180: responsibility_application_id => p_resp_app_id,

Line 187: x_return_status := fnd_api.g_ret_sts_success;

183: end_date => NULL,
184: description => 'POS User Profile'
185: );
186:
187: x_return_status := fnd_api.g_ret_sts_success;
188:
189: EXCEPTION
190: WHEN OTHERS THEN
191: pos_log.log_sqlerrm

Line 210: x_return_status := fnd_api.g_ret_sts_success;

206: , x_msg_data OUT NOCOPY VARCHAR2
207: ) IS
208: l_resp_id NUMBER;
209: BEGIN
210: x_return_status := fnd_api.g_ret_sts_success;
211: SELECT responsibility_id INTO l_resp_id
212: FROM fnd_responsibility
213: WHERE responsibility_key = p_resp_key
214: AND application_id = p_resp_app_id;

Line 249: OR x_return_status <> fnd_api.g_ret_sts_success THEN

245: x_msg_count => x_msg_count,
246: x_msg_data => x_msg_data
247: );
248: IF x_return_status IS NULL
249: OR x_return_status <> fnd_api.g_ret_sts_success THEN
250: ROLLBACK TO grant_user_resps_sp;
251: RETURN;
252: END IF;
253: END LOOP;

Line 255: x_return_status := fnd_api.g_ret_sts_success;

251: RETURN;
252: END IF;
253: END LOOP;
254:
255: x_return_status := fnd_api.g_ret_sts_success;
256:
257: END grant_user_resps;
258:
259: procedure revoke_user_resp

Line 277: x_return_status := fnd_api.g_ret_sts_success;

273: OPEN l_cur;
274: FETCH l_cur INTO l_start_date;
275: IF l_cur%notfound THEN
276: CLOSE l_cur;
277: x_return_status := fnd_api.g_ret_sts_success;
278: RETURN;
279: END IF;
280: fnd_user_resp_groups_api.upload_assignment
281: ( user_id => p_user_id,

Line 289: x_return_status := fnd_api.g_ret_sts_success;

285: start_date => l_start_date,
286: end_date => sysdate,
287: description => 'POS User Profile'
288: );
289: x_return_status := fnd_api.g_ret_sts_success;
290:
291: EXCEPTION
292: WHEN OTHERS THEN
293: pos_log.log_sqlerrm('POSADMB', 'in revoke_user_resp');

Line 319: OR x_return_status <> fnd_api.g_ret_sts_success THEN

315: x_msg_count => x_msg_count,
316: x_msg_data => x_msg_data
317: );
318: IF x_return_status IS NULL
319: OR x_return_status <> fnd_api.g_ret_sts_success THEN
320: ROLLBACK TO revoke_user_resps_sp;
321: RETURN;
322: END IF;
323: END LOOP;

Line 325: x_return_status := fnd_api.g_ret_sts_success;

321: RETURN;
322: END IF;
323: END LOOP;
324:
325: x_return_status := fnd_api.g_ret_sts_success;
326:
327: END revoke_user_resps;
328:
329: procedure update_user_info

Line 368: x_return_status := fnd_api.g_ret_sts_error;

364: OPEN l_party_cur;
365: FETCH l_party_cur INTO l_party_rec;
366: IF l_party_cur%notfound THEN
367: CLOSE l_party_cur;
368: x_return_status := fnd_api.g_ret_sts_error;
369: x_msg_count := 1;
370: x_msg_data := 'invalid party id ' || p_party_id;
371: RETURN;
372: END IF;

Line 410: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

406: p_msg_count => x_msg_count,
407: p_msg_data => x_msg_data
408: );
409:
410: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
411: RETURN;
412: END IF;
413:
414: pos_hz_contact_point_pkg.update_party_phone

Line 425: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

421: x_msg_count => x_msg_count,
422: x_msg_data => x_msg_data
423: );
424:
425: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
426: RETURN;
427: END IF;
428:
429: pos_hz_contact_point_pkg.update_party_fax

Line 440: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

436: x_msg_count => x_msg_count,
437: x_msg_data => x_msg_data
438: );
439:
440: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
441: RETURN;
442: END IF;
443:
444: IF p_user_email IS NOT NULL THEN

Line 454: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

450: x_msg_data => x_msg_data
451: );
452: END IF;
453:
454: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
455: RETURN;
456: END IF;
457:
458: --set email address in fnd_user as well as TCA.

Line 469: x_return_status := fnd_api.g_ret_sts_success;

465: x_customer_id => p_party_id
466: );
467: END LOOP;
468:
469: x_return_status := fnd_api.g_ret_sts_success;
470:
471: EXCEPTION
472: WHEN OTHERS THEN
473: pos_log.log_sqlerrm('POSADMB', 'in update_user_info');

Line 516: IF l_return_status IS NULL OR l_return_status <> fnd_api.g_ret_sts_success THEN

512: p_msg_count => l_msg_count,
513: p_msg_data => l_msg_data
514: );
515:
516: IF l_return_status IS NULL OR l_return_status <> fnd_api.g_ret_sts_success THEN
517: IF l_msg_count > 0 THEN
518: pos_log.combine_fnd_msg(l_msg_count, l_msg_data);
519: END IF;
520:

Line 568: IF l_return_status IS NULL OR l_return_status <> fnd_api.g_ret_sts_success THEN

564: p_msg_count => l_msg_count,
565: p_msg_data => l_msg_data
566: );
567:
568: IF l_return_status IS NULL OR l_return_status <> fnd_api.g_ret_sts_success THEN
569: IF l_msg_count > 0 THEN
570: pos_log.combine_fnd_msg(l_msg_count, l_msg_data);
571: END IF;
572:

Line 616: IF l_return_status = fnd_api.g_ret_sts_success THEN

612: x_msg_data => l_msg_data
613: );
614:
615: x_status := l_return_status;
616: IF l_return_status = fnd_api.g_ret_sts_success THEN
617: x_exception_msg := NULL;
618: ELSE
619: IF l_msg_count = 1 THEN
620: x_exception_msg := l_msg_data;

Line 649: IF l_return_status = fnd_api.g_ret_sts_success THEN

645: x_msg_data => l_msg_data
646: );
647:
648: x_status := l_return_status;
649: IF l_return_status = fnd_api.g_ret_sts_success THEN
650: x_exception_msg := NULL;
651: ELSE
652: IF l_msg_count = 1 THEN
653: x_exception_msg := l_msg_data;

Line 696: IF l_return_status = fnd_api.g_ret_sts_success THEN

692: x_msg_data => l_msg_data
693: );
694:
695: x_status := l_return_status;
696: IF l_return_status = fnd_api.g_ret_sts_success THEN
697: x_exception_msg := NULL;
698: ELSE
699: IF l_msg_count = 1 THEN
700: x_exception_msg := l_msg_data;

Line 745: x_return_status := fnd_api.g_ret_sts_error;

741: BEGIN
742: SAVEPOINT create_supp_user_account_sp;
743:
744: IF p_user_name IS NULL THEN
745: x_return_status := fnd_api.g_ret_sts_error;
746: fnd_message.set_name('POS', 'POS_CRSUSER_USERNAME_NULL');
747: fnd_msg_pub.ADD;
748: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
749: RETURN;

Line 756: x_return_status := fnd_api.g_ret_sts_error;

752: OPEN l_fnd_user_cur;
753: FETCH l_fnd_user_cur INTO l_fnd_user_rec;
754: IF l_fnd_user_cur%found THEN
755: CLOSE l_fnd_user_cur;
756: x_return_status := fnd_api.g_ret_sts_error;
757: fnd_message.set_name('POS', 'POS_CRSUSER_USERNAME_EXISTS');
758: fnd_message.set_token('USER_NAME', p_user_name);
759: fnd_msg_pub.ADD;
760: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 766: x_return_status := fnd_api.g_ret_sts_error;

762: END IF;
763: CLOSE l_fnd_user_cur;
764:
765: IF p_user_email IS NULL THEN
766: x_return_status := fnd_api.g_ret_sts_error;
767: fnd_message.set_name('POS', 'POS_CRSUSER_EMAIL_NULL');
768: fnd_msg_pub.ADD;
769: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
770: RETURN;

Line 774: x_return_status := fnd_api.g_ret_sts_error;

770: RETURN;
771: END IF;
772:
773: IF p_person_party_id IS NULL THEN
774: x_return_status := fnd_api.g_ret_sts_error;
775: fnd_message.set_name('POS', 'POS_CRSUSER_PERSON_PARTY_NULL');
776: fnd_msg_pub.ADD;
777: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
778: RETURN;

Line 785: x_return_status := fnd_api.g_ret_sts_error;

781: OPEN l_party_cur;
782: FETCH l_party_cur INTO l_party_rec;
783: IF l_party_cur%notfound THEN
784: CLOSE l_party_cur;
785: x_return_status := fnd_api.g_ret_sts_error;
786: fnd_message.set_name('POS', 'POS_CRSUSER_BAD_PERSON_PARTYID');
787: fnd_message.set_token('PERSON_PARTY_ID', p_person_party_id);
788: fnd_msg_pub.ADD;
789: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 795: x_return_status := fnd_api.g_ret_sts_error;

791: END IF;
792: CLOSE l_party_cur;
793:
794: IF l_party_rec.status <> 'A' THEN
795: x_return_status := fnd_api.g_ret_sts_error;
796: fnd_message.set_name('POS', 'POS_CRSUSER_PERSON_PARTY_INACT');
797: fnd_message.set_token('PERSON_PARTY_ID', p_person_party_id);
798: fnd_msg_pub.ADD;
799: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 804: x_return_status := fnd_api.g_ret_sts_error;

800: RETURN;
801: END IF;
802:
803: IF l_party_rec.party_type <> 'PERSON' THEN
804: x_return_status := fnd_api.g_ret_sts_error;
805: fnd_message.set_name('POS', 'POS_CRSUSER_PARTY_NOT_PERSON');
806: fnd_message.set_token('PERSON_PARTY_ID', p_person_party_id);
807: fnd_msg_pub.ADD;
808: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 857: x_return_status <> fnd_api.g_ret_sts_success THEN

853: x_msg_count => x_msg_count,
854: x_msg_data => x_msg_data
855: );
856: IF x_return_status IS NULL OR
857: x_return_status <> fnd_api.g_ret_sts_success THEN
858: ROLLBACK TO create_supp_user_account_sp;
859: RETURN;
860: END IF;
861: END LOOP;

Line 878: x_return_status := fnd_api.g_ret_sts_success;

874: -- set profile options for external user
875: -- Namely: APPS_SERVLET_AGENT, APPS_WEB_AGENT
876: POS_SUPPLIER_USER_REG_PKG.set_profile_opt_ext_user(x_user_id);
877:
878: x_return_status := fnd_api.g_ret_sts_success;
879:
880: EXCEPTION
881: WHEN OTHERS THEN
882: ROLLBACK TO create_supp_user_account_sp;

Line 883: x_return_status := fnd_api.g_ret_sts_error;

879:
880: EXCEPTION
881: WHEN OTHERS THEN
882: ROLLBACK TO create_supp_user_account_sp;
883: x_return_status := fnd_api.g_ret_sts_error;
884: x_msg_count := 1;
885: x_msg_data := Sqlerrm;
886: pos_log.log_sqlerrm('POSADMB', 'in create_supplier_user_account');
887:

Line 1057: x_return_status := fnd_api.g_ret_sts_success;

1053: l_resp_key fnd_responsibility.responsibility_key%TYPE;
1054: l_resp_app_id NUMBER;
1055: l_step NUMBER;
1056: BEGIN
1057: x_return_status := fnd_api.g_ret_sts_success;
1058: l_step := 1;
1059: fnd_profile.get('POS_DEFAULT_SUP_REG_RESP', l_resp_profile);
1060:
1061: IF l_resp_profile IS NOT NULL THEN

Line 1075: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1071: x_msg_count => x_msg_count,
1072: x_msg_data => x_msg_data
1073: );
1074:
1075: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1076: RETURN;
1077: END IF;
1078: END IF;
1079:

Line 1103: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1099: x_msg_count => x_msg_count,
1100: x_msg_data => x_msg_data
1101: );
1102:
1103: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1104: RETURN;
1105: END IF;
1106: END IF;
1107: END IF;

Line 1110: x_return_status := fnd_api.g_ret_sts_error;

1106: END IF;
1107: END IF;
1108: EXCEPTION
1109: WHEN OTHERS THEN
1110: x_return_status := fnd_api.g_ret_sts_error;
1111: x_msg_count := 1;
1112: x_msg_data := Sqlerrm;
1113: pos_log.log_sqlerrm('POSADMB', 'in assign_vendor_reg_def_resp, step ' || l_step );
1114:

Line 1138: x_status := fnd_api.g_ret_sts_success;

1134: -- Insert new record in the spm notification events table for the
1135: -- business classification recert notifications
1136:
1137:
1138: x_status := fnd_api.g_ret_sts_success;
1139: open c1;
1140: fetch c1 into l_subscr_count;
1141: close c1;
1142:

Line 1163: x_status := fnd_api.g_ret_sts_success;

1159: fnd_global.login_id,
1160: 'SUPP_BUS_CLASS_RECERT_NTF',
1161: p_user_id);
1162: commit;
1163: x_status := fnd_api.g_ret_sts_success;
1164:
1165: end if;
1166: EXCEPTION
1167: WHEN OTHERS THEN

Line 1168: x_status := fnd_api.g_ret_sts_error;

1164:
1165: end if;
1166: EXCEPTION
1167: WHEN OTHERS THEN
1168: x_status := fnd_api.g_ret_sts_error;
1169: x_exception_msg := 'Error creating notification subscription'||Sqlerrm;
1170: pos_log.log_sqlerrm('POSADMB', x_exception_msg);
1171:
1172: END add_certntf_subscription;

Line 1190: x_status := fnd_api.g_ret_sts_success;

1186: l_subscr_count number := 0;
1187:
1188:
1189: BEGIN
1190: x_status := fnd_api.g_ret_sts_success;
1191:
1192: open c1;
1193: fetch c1 into l_subscr_count;
1194: close c1;

Line 1202: x_status := fnd_api.g_ret_sts_success;

1198: delete from pos_spmntf_subscription
1199: where event_type = 'SUPP_BUS_CLASS_RECERT_NTF'
1200: and user_id = p_user_id;
1201: commit;
1202: x_status := fnd_api.g_ret_sts_success;
1203: end if;
1204: EXCEPTION
1205: WHEN OTHERS THEN
1206: x_status := fnd_api.g_ret_sts_error;

Line 1206: x_status := fnd_api.g_ret_sts_error;

1202: x_status := fnd_api.g_ret_sts_success;
1203: end if;
1204: EXCEPTION
1205: WHEN OTHERS THEN
1206: x_status := fnd_api.g_ret_sts_error;
1207: x_exception_msg := 'Error removing notification subscription'||Sqlerrm;
1208: pos_log.log_sqlerrm('POSADMB', x_exception_msg);
1209:
1210: END remove_certntf_subscription;