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 747: x_return_status := fnd_api.g_ret_sts_error;

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

Line 758: x_return_status := fnd_api.g_ret_sts_error;

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

Line 768: x_return_status := fnd_api.g_ret_sts_error;

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

Line 776: x_return_status := fnd_api.g_ret_sts_error;

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

Line 787: x_return_status := fnd_api.g_ret_sts_error;

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

Line 797: x_return_status := fnd_api.g_ret_sts_error;

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

Line 806: x_return_status := fnd_api.g_ret_sts_error;

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

Line 839: x_return_status := fnd_api.g_ret_sts_error;

835: EXCEPTION
836: WHEN VALUE_ERROR THEN
837: --Throwing error if the conversion to number didn't happen due to invalid characters
838: --Only VALUE_ERROR can occur while conversion
839: x_return_status := fnd_api.g_ret_sts_error;
840: fnd_message.set_name('POS', 'POS_SUPP_USER_PWD_EXP_ERROR');
841: fnd_message.set_token('POS_PROFILE_OPTION_NAME', 'POS: Supplier User Account Password Expiration Days');
842: x_msg_data := fnd_message.get;
843: raise_application_error(-20001,x_msg_data,false);

Line 881: x_return_status <> fnd_api.g_ret_sts_success THEN

877: x_msg_count => x_msg_count,
878: x_msg_data => x_msg_data
879: );
880: IF x_return_status IS NULL OR
881: x_return_status <> fnd_api.g_ret_sts_success THEN
882: ROLLBACK TO create_supp_user_account_sp;
883: RETURN;
884: END IF;
885: END LOOP;

Line 902: x_return_status := fnd_api.g_ret_sts_success;

898: -- set profile options for external user
899: -- Namely: APPS_SERVLET_AGENT, APPS_WEB_AGENT
900: POS_SUPPLIER_USER_REG_PKG.set_profile_opt_ext_user(x_user_id);
901:
902: x_return_status := fnd_api.g_ret_sts_success;
903:
904: /* Begin Supplier Hub - Supplier Data Publication */
905: /* Raise Supplier User Creation event*/
906: event_id:= pos_appr_rej_supp_event_raise.raise_appr_rej_supp_event('oracle.apps.pos.supplier.approvesupplieruser', p_person_party_id, x_user_id);

Line 913: x_return_status := fnd_api.g_ret_sts_error;

909:
910: EXCEPTION
911: WHEN OTHERS THEN
912: ROLLBACK TO create_supp_user_account_sp;
913: x_return_status := fnd_api.g_ret_sts_error;
914: x_msg_count := 1;
915: x_msg_data := Sqlerrm;
916: pos_log.log_sqlerrm('POSADMB', 'in create_supplier_user_account');
917:

Line 1117: x_return_status := fnd_api.g_ret_sts_success;

1113: l_resp_key fnd_responsibility.responsibility_key%TYPE;
1114: l_resp_app_id NUMBER;
1115: l_step NUMBER;
1116: BEGIN
1117: x_return_status := fnd_api.g_ret_sts_success;
1118: l_step := 1;
1119: fnd_profile.get('POS_DEFAULT_SUP_REG_RESP', l_resp_profile);
1120:
1121: IF l_resp_profile IS NOT NULL THEN

Line 1135: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1131: x_msg_count => x_msg_count,
1132: x_msg_data => x_msg_data
1133: );
1134:
1135: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1136: RETURN;
1137: END IF;
1138: END IF;
1139:

Line 1163: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1159: x_msg_count => x_msg_count,
1160: x_msg_data => x_msg_data
1161: );
1162:
1163: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1164: RETURN;
1165: END IF;
1166: END IF;
1167: END IF;

Line 1170: x_return_status := fnd_api.g_ret_sts_error;

1166: END IF;
1167: END IF;
1168: EXCEPTION
1169: WHEN OTHERS THEN
1170: x_return_status := fnd_api.g_ret_sts_error;
1171: x_msg_count := 1;
1172: x_msg_data := Sqlerrm;
1173: pos_log.log_sqlerrm('POSADMB', 'in assign_vendor_reg_def_resp, step ' || l_step );
1174:

Line 1198: x_status := fnd_api.g_ret_sts_success;

1194: -- Insert new record in the spm notification events table for the
1195: -- business classification recert notifications
1196:
1197:
1198: x_status := fnd_api.g_ret_sts_success;
1199: open c1;
1200: fetch c1 into l_subscr_count;
1201: close c1;
1202:

Line 1223: x_status := fnd_api.g_ret_sts_success;

1219: fnd_global.login_id,
1220: 'SUPP_BUS_CLASS_RECERT_NTF',
1221: p_user_id);
1222: commit;
1223: x_status := fnd_api.g_ret_sts_success;
1224:
1225: end if;
1226: EXCEPTION
1227: WHEN OTHERS THEN

Line 1228: x_status := fnd_api.g_ret_sts_error;

1224:
1225: end if;
1226: EXCEPTION
1227: WHEN OTHERS THEN
1228: x_status := fnd_api.g_ret_sts_error;
1229: x_exception_msg := 'Error creating notification subscription'||Sqlerrm;
1230: pos_log.log_sqlerrm('POSADMB', x_exception_msg);
1231:
1232: END add_certntf_subscription;

Line 1250: x_status := fnd_api.g_ret_sts_success;

1246: l_subscr_count number := 0;
1247:
1248:
1249: BEGIN
1250: x_status := fnd_api.g_ret_sts_success;
1251:
1252: open c1;
1253: fetch c1 into l_subscr_count;
1254: close c1;

Line 1262: x_status := fnd_api.g_ret_sts_success;

1258: delete from pos_spmntf_subscription
1259: where event_type = 'SUPP_BUS_CLASS_RECERT_NTF'
1260: and user_id = p_user_id;
1261: commit;
1262: x_status := fnd_api.g_ret_sts_success;
1263: end if;
1264: EXCEPTION
1265: WHEN OTHERS THEN
1266: x_status := fnd_api.g_ret_sts_error;

Line 1266: x_status := fnd_api.g_ret_sts_error;

1262: x_status := fnd_api.g_ret_sts_success;
1263: end if;
1264: EXCEPTION
1265: WHEN OTHERS THEN
1266: x_status := fnd_api.g_ret_sts_error;
1267: x_exception_msg := 'Error removing notification subscription'||Sqlerrm;
1268: pos_log.log_sqlerrm('POSADMB', x_exception_msg);
1269:
1270: END remove_certntf_subscription;