DBA Data[Home] [Help]

APPS.POS_SUPPLIER_USER_REG_PKG dependencies on FND_API

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

787: x_msg_count => x_msg_count,
788: x_msg_data => x_msg_data
789: );
790:
791: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
792: RETURN;
793: END IF;
794:
795: IF l_resp_app_id = 177 THEN -- pos application id is 177

Line 835: x_return_status := fnd_api.g_ret_sts_success;

831: p_app_id => 177,
832: p_number_value => l_rec.field_value_number
833: );
834: END LOOP;
835: x_return_status := fnd_api.g_ret_sts_success;
836: END set_sec_attrs;
837:
838: PROCEDURE set_user_profile
839: (p_user_id IN NUMBER,

Line 899: x_return_status := fnd_api.g_ret_sts_success;

895: x_level_value_app_id => NULL
896: );
897: END IF;
898:
899: x_return_status := fnd_api.g_ret_sts_success;
900:
901: END set_user_profile;
902:
903: FUNCTION gen_local_user_name

Line 1274: x_return_status := fnd_api.g_ret_sts_error;

1270: OPEN l_cur;
1271: FETCH l_cur INTO l_rec;
1272: IF l_cur%notfound THEN
1273: CLOSE l_cur;
1274: x_return_status := fnd_api.g_ret_sts_error;
1275: x_msg_count := 1;
1276: x_msg_data := 'Can not find registration data for registration ' || p_registration_id;
1277: RETURN;
1278: END IF;

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

1299: x_msg_data => x_msg_data,
1300: x_person_party_id => l_person_party_id
1301: );
1302:
1303: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1304: ROLLBACK TO supplier_user_reg_approve_sp;
1305: RETURN;
1306: END IF;
1307:

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

1322: x_user_id => l_user_id,
1323: x_password => l_password_returned
1324: );
1325:
1326: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1327: ROLLBACK TO supplier_user_reg_approve_sp;
1328: RETURN;
1329: END IF;
1330:

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

1335: x_msg_count => x_msg_count,
1336: x_msg_data => x_msg_data
1337: );
1338:
1339: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1340: ROLLBACK TO supplier_user_reg_approve_sp;
1341: RETURN;
1342: END IF;
1343:

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

1348: x_msg_count => x_msg_count,
1349: x_msg_data => x_msg_data
1350: );
1351:
1352: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1353: ROLLBACK TO supplier_user_reg_approve_sp;
1354: RETURN;
1355: END IF;
1356:

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

1360: x_msg_count => x_msg_count,
1361: x_msg_data => x_msg_data
1362: );
1363:
1364: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1365: ROLLBACK TO supplier_user_reg_approve_sp;
1366: RETURN;
1367: END IF;
1368:

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

1380: p_user_name => Upper(l_rec.requested_user_name),
1381: p_password => l_password
1382: );
1383:
1384: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1385: ROLLBACK TO supplier_user_reg_approve_sp;
1386: RETURN;
1387: END IF;
1388:

Line 1389: x_return_status := fnd_api.g_ret_sts_success;

1385: ROLLBACK TO supplier_user_reg_approve_sp;
1386: RETURN;
1387: END IF;
1388:
1389: x_return_status := fnd_api.g_ret_sts_success;
1390:
1391: EXCEPTION
1392: WHEN OTHERS THEN
1393: ROLLBACK TO supplier_user_reg_approve_sp;

Line 1394: x_return_status := fnd_api.g_ret_sts_unexp_error;

1390:
1391: EXCEPTION
1392: WHEN OTHERS THEN
1393: ROLLBACK TO supplier_user_reg_approve_sp;
1394: x_return_status := fnd_api.g_ret_sts_unexp_error;
1395: x_msg_data := Sqlerrm;
1396: x_msg_count := 1;
1397: RETURN;
1398: END approve;

Line 1429: x_return_status := fnd_api.g_ret_sts_success;

1425: p_email => l_email,
1426: p_language_code => l_language_code
1427: );
1428:
1429: x_return_status := fnd_api.g_ret_sts_success;
1430:
1431: EXCEPTION
1432: WHEN OTHERS THEN
1433: ROLLBACK TO supplier_user_reg_reject_sp;

Line 1434: x_return_status := fnd_api.g_ret_sts_unexp_error;

1430:
1431: EXCEPTION
1432: WHEN OTHERS THEN
1433: ROLLBACK TO supplier_user_reg_reject_sp;
1434: x_return_status := fnd_api.g_ret_sts_unexp_error;
1435: x_msg_data := Sqlerrm;
1436: x_msg_count := 1;
1437: RETURN;
1438: END reject;

Line 1471: x_return_status := fnd_api.g_ret_sts_success;

1467: p_language_code => l_language_code,
1468: p_note => get_note(p_registration_id),
1469: p_invitation_key => l_reg_key
1470: );
1471: x_return_status := fnd_api.g_ret_sts_success;
1472: EXCEPTION
1473: WHEN OTHERS THEN
1474: x_return_status := fnd_api.g_ret_sts_unexp_error;
1475: x_msg_count := 1;

Line 1474: x_return_status := fnd_api.g_ret_sts_unexp_error;

1470: );
1471: x_return_status := fnd_api.g_ret_sts_success;
1472: EXCEPTION
1473: WHEN OTHERS THEN
1474: x_return_status := fnd_api.g_ret_sts_unexp_error;
1475: x_msg_count := 1;
1476: x_msg_data := Sqlerrm;
1477: ROLLBACK TO supplier_user_invite_sp;
1478: END invite;

Line 1530: x_return_status := fnd_api.g_ret_sts_success;

1526: p_vendor_name => l_rec.vendor_name,
1527: p_approver_role => l_rec.user_name
1528: );
1529:
1530: x_return_status := fnd_api.g_ret_sts_success;
1531: EXCEPTION
1532: WHEN OTHERS THEN
1533: x_return_status := fnd_api.g_ret_sts_unexp_error;
1534: x_msg_count := 1;

Line 1533: x_return_status := fnd_api.g_ret_sts_unexp_error;

1529:
1530: x_return_status := fnd_api.g_ret_sts_success;
1531: EXCEPTION
1532: WHEN OTHERS THEN
1533: x_return_status := fnd_api.g_ret_sts_unexp_error;
1534: x_msg_count := 1;
1535: x_msg_data := Sqlerrm;
1536: ROLLBACK TO supplier_user_respond_sp;
1537: END respond;