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

1288: OPEN l_cur;
1289: FETCH l_cur INTO l_rec;
1290: IF l_cur%notfound THEN
1291: CLOSE l_cur;
1292: x_return_status := fnd_api.g_ret_sts_error;
1293: x_msg_count := 1;
1294: x_msg_data := 'Can not find registration data for registration ' || p_registration_id;
1295: RETURN;
1296: END IF;

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

1317: x_msg_data => x_msg_data,
1318: x_person_party_id => l_person_party_id
1319: );
1320:
1321: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1322: ROLLBACK TO supplier_user_reg_approve_sp;
1323: RETURN;
1324: END IF;
1325:

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

1340: x_user_id => l_user_id,
1341: x_password => l_password_returned
1342: );
1343:
1344: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1345: ROLLBACK TO supplier_user_reg_approve_sp;
1346: RETURN;
1347: END IF;
1348:

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

1353: x_msg_count => x_msg_count,
1354: x_msg_data => x_msg_data
1355: );
1356:
1357: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1358: ROLLBACK TO supplier_user_reg_approve_sp;
1359: RETURN;
1360: END IF;
1361:

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

1366: x_msg_count => x_msg_count,
1367: x_msg_data => x_msg_data
1368: );
1369:
1370: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1371: ROLLBACK TO supplier_user_reg_approve_sp;
1372: RETURN;
1373: END IF;
1374:

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

1378: x_msg_count => x_msg_count,
1379: x_msg_data => x_msg_data
1380: );
1381:
1382: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1383: ROLLBACK TO supplier_user_reg_approve_sp;
1384: RETURN;
1385: END IF;
1386:

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

1398: p_user_name => Upper(l_rec.requested_user_name),
1399: p_password => l_password
1400: );
1401:
1402: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1403: ROLLBACK TO supplier_user_reg_approve_sp;
1404: RETURN;
1405: END IF;
1406:

Line 1407: x_return_status := fnd_api.g_ret_sts_success;

1403: ROLLBACK TO supplier_user_reg_approve_sp;
1404: RETURN;
1405: END IF;
1406:
1407: x_return_status := fnd_api.g_ret_sts_success;
1408:
1409: EXCEPTION
1410: WHEN OTHERS THEN
1411: ROLLBACK TO supplier_user_reg_approve_sp;

Line 1412: x_return_status := fnd_api.g_ret_sts_unexp_error;

1408:
1409: EXCEPTION
1410: WHEN OTHERS THEN
1411: ROLLBACK TO supplier_user_reg_approve_sp;
1412: x_return_status := fnd_api.g_ret_sts_unexp_error;
1413: x_msg_data := Sqlerrm;
1414: x_msg_count := 1;
1415: RETURN;
1416: END approve;

Line 1448: x_return_status := fnd_api.g_ret_sts_success;

1444: p_email => l_email,
1445: p_language_code => l_language_code
1446: );
1447:
1448: x_return_status := fnd_api.g_ret_sts_success;
1449:
1450: /* Begin Supplier Hub - Supplier Data Publication */
1451: /* Raise Supplier User Creation event*/
1452: event_id:= pos_appr_rej_supp_event_raise.raise_appr_rej_supp_event('oracle.apps.pos.supplier.rejectsupplieruser', p_registration_id, '');

Line 1459: x_return_status := fnd_api.g_ret_sts_unexp_error;

1455:
1456: EXCEPTION
1457: WHEN OTHERS THEN
1458: ROLLBACK TO supplier_user_reg_reject_sp;
1459: x_return_status := fnd_api.g_ret_sts_unexp_error;
1460: x_msg_data := Sqlerrm;
1461: x_msg_count := 1;
1462: RETURN;
1463: END reject;

Line 1496: x_return_status := fnd_api.g_ret_sts_success;

1492: p_language_code => l_language_code,
1493: p_note => get_note(p_registration_id),
1494: p_invitation_key => l_reg_key
1495: );
1496: x_return_status := fnd_api.g_ret_sts_success;
1497: EXCEPTION
1498: WHEN OTHERS THEN
1499: x_return_status := fnd_api.g_ret_sts_unexp_error;
1500: x_msg_count := 1;

Line 1499: x_return_status := fnd_api.g_ret_sts_unexp_error;

1495: );
1496: x_return_status := fnd_api.g_ret_sts_success;
1497: EXCEPTION
1498: WHEN OTHERS THEN
1499: x_return_status := fnd_api.g_ret_sts_unexp_error;
1500: x_msg_count := 1;
1501: x_msg_data := Sqlerrm;
1502: ROLLBACK TO supplier_user_invite_sp;
1503: END invite;

Line 1555: x_return_status := fnd_api.g_ret_sts_success;

1551: p_vendor_name => l_rec.vendor_name,
1552: p_approver_role => l_rec.user_name
1553: );
1554:
1555: x_return_status := fnd_api.g_ret_sts_success;
1556: EXCEPTION
1557: WHEN OTHERS THEN
1558: x_return_status := fnd_api.g_ret_sts_unexp_error;
1559: x_msg_count := 1;

Line 1558: x_return_status := fnd_api.g_ret_sts_unexp_error;

1554:
1555: x_return_status := fnd_api.g_ret_sts_success;
1556: EXCEPTION
1557: WHEN OTHERS THEN
1558: x_return_status := fnd_api.g_ret_sts_unexp_error;
1559: x_msg_count := 1;
1560: x_msg_data := Sqlerrm;
1561: ROLLBACK TO supplier_user_respond_sp;
1562: END respond;