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

Line 5287: --l_contact_point_rec.contact_point_id := FND_API.G_MISS_NUM;

5283:
5284: BEGIN
5285:
5286: --commented out intialization for bug#3392035
5287: --l_contact_point_rec.contact_point_id := FND_API.G_MISS_NUM;
5288:
5289: l_contact_point_rec.contact_point_id := p_contact_point_rec.contact_point_id;
5290: l_contact_point_rec.contact_point_type := p_contact_point_rec.contact_point_type;
5291: l_contact_point_rec.status := p_contact_point_rec.status;

Line 5314: l_phone_rec_type.phone_area_code := FND_API.G_MISS_CHAR;

5310: l_phone_rec_type.phone_number := p_contact_point_rec.email_address;
5311: --Added following codition to make area code null if area code having no value 3392035
5312: IF p_contact_point_rec.area_code IS NULL
5313: THEN
5314: l_phone_rec_type.phone_area_code := FND_API.G_MISS_CHAR;
5315: ELSE
5316: l_phone_rec_type.phone_area_code := p_contact_point_rec.area_code;
5317: END IF;
5318: -- added for contact creation

Line 5321: l_phone_rec_type.phone_country_code := FND_API.G_MISS_CHAR; -- added for contact creation

5317: END IF;
5318: -- added for contact creation
5319: IF p_contact_point_rec.phone_country_code IS NULL
5320: THEN
5321: l_phone_rec_type.phone_country_code := FND_API.G_MISS_CHAR; -- added for contact creation
5322: ELSE
5323: l_phone_rec_type.phone_country_code := p_contact_point_rec.phone_country_code; -- added for contact creation
5324: END IF;
5325: --contact creation end

Line 5397: l_phone_rec_type.phone_area_code := FND_API.G_MISS_CHAR;

5393:
5394: --ADDED following condition to make area code null 3392035
5395: IF p_contact_point_rec.area_code IS NULL
5396: THEN
5397: l_phone_rec_type.phone_area_code := FND_API.G_MISS_CHAR;
5398: ELSE
5399: l_phone_rec_type.phone_area_code := p_contact_point_rec.area_code;
5400: END IF;
5401: -- added for contact creation OCT 2004

Line 5404: l_phone_rec_type.phone_country_code := FND_API.G_MISS_CHAR; -- added for contact creation

5400: END IF;
5401: -- added for contact creation OCT 2004
5402: IF p_contact_point_rec.phone_country_code IS NULL
5403: THEN
5404: l_phone_rec_type.phone_country_code := FND_API.G_MISS_CHAR; -- added for contact creation
5405: ELSE
5406: l_phone_rec_type.phone_country_code := p_contact_point_rec.phone_country_code; -- added for contact creation
5407: END IF;
5408: --contact creation end OCT 2004

Line 5977: , FND_API.G_FALSE

5973: THEN
5974: FOR j IN 1 .. x_msg_count LOOP
5975: fnd_msg_pub.get
5976: (j
5977: , FND_API.G_FALSE
5978: , x_msg_data
5979: , t_msg_dummy
5980: );
5981: t_output := ('Msg'

Line 7285: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

7281:
7282: END update_quantity;
7283: -- added for contact creation OCT2004
7284: PROCEDURE create_person (
7285: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7286: p_person_tbl IN PERSON_TBL_TYPE,
7287: x_party_id OUT NOCOPY NUMBER,
7288: x_party_number OUT NOCOPY VARCHAR2,
7289: x_profile_id OUT NOCOPY NUMBER,

Line 7330: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

7326: SQLERRM);
7327: END;
7328:
7329: PROCEDURE update_person (
7330: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7331: p_person_tbl IN PERSON_TBL_TYPE,
7332: p_party_object_version_number IN NUMBER,
7333: x_profile_id OUT NOCOPY NUMBER,
7334: x_return_status OUT NOCOPY VARCHAR2,

Line 7375: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

7371:
7372: END;
7373:
7374: PROCEDURE create_org_contact (
7375: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7376: p_org_contact_tbl IN ORG_CONTACT_TBL_TYPE,
7377: p_relationship_tbl_type IN relationship_tbl_type,
7378: x_org_contact_id OUT NOCOPY NUMBER,
7379: x_party_rel_id OUT NOCOPY NUMBER,

Line 7430: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

7426: SQLERRM);
7427: END;
7428:
7429: PROCEDURE update_org_contact (
7430: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7431: p_org_contact_tbl IN ORG_CONTACT_TBL_TYPE,
7432: p_relationship_tbl_type IN relationship_tbl_type,
7433: p_cont_object_version_number IN OUT NOCOPY NUMBER,
7434: p_rel_object_version_number IN OUT NOCOPY NUMBER,

Line 7490: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

7486: SQLERRM);
7487: END;
7488:
7489: PROCEDURE create_party_site (
7490: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7491: p_party_site_tbl IN PARTY_SITE_TBL_TYPE,
7492: x_party_site_id OUT NOCOPY NUMBER,
7493: x_party_site_number OUT NOCOPY VARCHAR2,
7494: x_return_status OUT NOCOPY VARCHAR2,

Line 7552: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

7548: SQLERRM);
7549: END;
7550:
7551: PROCEDURE update_party_site (
7552: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7553: p_party_site_tbl IN PARTY_SITE_TBL_TYPE,
7554: p_object_version_number IN OUT NOCOPY NUMBER,
7555: x_return_status OUT NOCOPY VARCHAR2,
7556: x_msg_count OUT NOCOPY NUMBER,

Line 7589: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

7585: SQLERRM);
7586: END;
7587:
7588: PROCEDURE create_cust_account_role (
7589: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7590: p_cust_account_role_tbl IN CUST_ACCOUNT_ROLE_tbl_TYPE,
7591: x_cust_account_role_id OUT NOCOPY NUMBER,
7592: x_return_status OUT NOCOPY VARCHAR2,
7593: x_msg_count OUT NOCOPY NUMBER,

Line 7628: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

7624: SQLERRM);
7625: END;
7626:
7627: PROCEDURE update_cust_account_role (
7628: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7629: p_cust_account_role_tbl IN CUST_ACCOUNT_ROLE_tbl_TYPE,
7630: p_object_version_number IN OUT NOCOPY NUMBER,
7631: x_return_status OUT NOCOPY VARCHAR2,
7632: x_msg_count OUT NOCOPY NUMBER,

Line 7668: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

7664: SQLERRM);
7665: END;
7666:
7667: PROCEDURE create_cust_acct_site (
7668: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7669: p_cust_acct_site_tbl IN CUST_ACCT_SITE_TBL_TYPE,
7670: x_cust_acct_site_id OUT NOCOPY NUMBER,
7671: x_return_status OUT NOCOPY VARCHAR2,
7672: x_msg_count OUT NOCOPY NUMBER,

Line 7705: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

7701:
7702: END;
7703:
7704: PROCEDURE update_cust_acct_site (
7705: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7706: p_cust_acct_site_tbl IN CUST_ACCT_SITE_TBL_TYPE,
7707: p_object_version_number IN OUT NOCOPY NUMBER,
7708: x_return_status OUT NOCOPY VARCHAR2,
7709: x_msg_count OUT NOCOPY NUMBER,

Line 7910: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

7906: */
7907: PROCEDURE CHECK_UPDATE_AMOUNTS
7908: (
7909: p_api_version IN NUMBER,
7910: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
7911: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
7912: p_chr_id IN NUMBER,
7913: x_msg_count OUT NOCOPY NUMBER,
7914: x_msg_data OUT NOCOPY VARCHAR2,

Line 7911: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

7907: PROCEDURE CHECK_UPDATE_AMOUNTS
7908: (
7909: p_api_version IN NUMBER,
7910: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
7911: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
7912: p_chr_id IN NUMBER,
7913: x_msg_count OUT NOCOPY NUMBER,
7914: x_msg_data OUT NOCOPY VARCHAR2,
7915: x_return_status OUT NOCOPY VARCHAR2

Line 8024: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN

8020: END IF;
8021:
8022: --standard api initilization and checks
8023: SAVEPOINT check_update_amounts_PVT;
8024: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
8025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8026: END IF;
8027: IF FND_API.to_boolean(p_init_msg_list ) THEN
8028: FND_MSG_PUB.initialize;

Line 8025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8021:
8022: --standard api initilization and checks
8023: SAVEPOINT check_update_amounts_PVT;
8024: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
8025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8026: END IF;
8027: IF FND_API.to_boolean(p_init_msg_list ) THEN
8028: FND_MSG_PUB.initialize;
8029: END IF;

Line 8027: IF FND_API.to_boolean(p_init_msg_list ) THEN

8023: SAVEPOINT check_update_amounts_PVT;
8024: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
8025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8026: END IF;
8027: IF FND_API.to_boolean(p_init_msg_list ) THEN
8028: FND_MSG_PUB.initialize;
8029: END IF;
8030: x_return_status := FND_API.G_RET_STS_SUCCESS;
8031:

Line 8030: x_return_status := FND_API.G_RET_STS_SUCCESS;

8026: END IF;
8027: IF FND_API.to_boolean(p_init_msg_list ) THEN
8028: FND_MSG_PUB.initialize;
8029: END IF;
8030: x_return_status := FND_API.G_RET_STS_SUCCESS;
8031:
8032: --get all toplines that are out of sync with sublines
8033: OPEN c_k_toplines(p_chr_id);
8034: LOOP

Line 8082: RAISE FND_API.g_exc_error;

8078: l_sl_amt_tbl.delete;
8079: l_tl_amt_tax_tbl.delete;
8080: l_sl_amt_tax_tbl.delete;
8081:
8082: RAISE FND_API.g_exc_error;
8083:
8084: END; --of anonymous block checking topline locks
8085:
8086: END LOOP;

Line 8165: RAISE FND_API.g_exc_error;

8161: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);
8162: END IF;
8163: FND_MSG_PUB.ADD;
8164:
8165: RAISE FND_API.g_exc_error;
8166:
8167: END; --of anonymous block checking header lock
8168:
8169: END IF; --of (l_hdr_amt <> l_tl_amt) OR(l_hdr_amt_tax <> l_tl_amt_tax) THEN

Line 8218: RAISE FND_API.g_exc_error;

8214: l_tl_id_tbl.delete;
8215: l_tl_amt_tbl.delete;
8216: l_sl_amt_tbl.delete;
8217:
8218: RAISE FND_API.g_exc_error;
8219:
8220: END; --of anonymous block checking topline locks
8221:
8222: END LOOP;

Line 8287: RAISE FND_API.g_exc_error;

8283: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);
8284: END IF;
8285: FND_MSG_PUB.ADD;
8286:
8287: RAISE FND_API.g_exc_error;
8288:
8289: END; --of anonymous block checking header lock
8290:
8291: END IF; --of (l_header_cancelled <> l_topline_cancelled) THEN

Line 8293: IF FND_API.to_boolean(p_commit) THEN

8289: END; --of anonymous block checking header lock
8290:
8291: END IF; --of (l_header_cancelled <> l_topline_cancelled) THEN
8292:
8293: IF FND_API.to_boolean(p_commit) THEN
8294: COMMIT;
8295: END IF;
8296:
8297: --exit

Line 8304: WHEN FND_API.g_exc_error THEN

8300: END IF;
8301: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
8302:
8303: EXCEPTION
8304: WHEN FND_API.g_exc_error THEN
8305: ROLLBACK TO check_update_amounts_PVT;
8306: x_return_status := FND_API.g_ret_sts_error ;
8307:
8308: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

Line 8306: x_return_status := FND_API.g_ret_sts_error ;

8302:
8303: EXCEPTION
8304: WHEN FND_API.g_exc_error THEN
8305: ROLLBACK TO check_update_amounts_PVT;
8306: x_return_status := FND_API.g_ret_sts_error ;
8307:
8308: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8309: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
8310: END IF;

Line 8329: WHEN FND_API.g_exc_unexpected_error THEN

8325: CLOSE c_lock_hdr;
8326: END IF;
8327:
8328:
8329: WHEN FND_API.g_exc_unexpected_error THEN
8330: ROLLBACK TO check_update_amounts_PVT;
8331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8332:
8333: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

Line 8331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8327:
8328:
8329: WHEN FND_API.g_exc_unexpected_error THEN
8330: ROLLBACK TO check_update_amounts_PVT;
8331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8332:
8333: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
8334: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
8335: END IF;

Line 8355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8351: END IF;
8352:
8353: WHEN OTHERS THEN
8354: ROLLBACK TO check_update_amounts_PVT;
8355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8356:
8357: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
8358: --first log the sqlerrm
8359: l_error_text := substr (SQLERRM, 1, 240);