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 5901: --l_contact_point_rec.contact_point_id := FND_API.G_MISS_NUM;

5897:
5898: BEGIN
5899:
5900: --commented out intialization for bug#3392035
5901: --l_contact_point_rec.contact_point_id := FND_API.G_MISS_NUM;
5902:
5903: l_contact_point_rec.contact_point_id := p_contact_point_rec.contact_point_id;
5904: l_contact_point_rec.contact_point_type := p_contact_point_rec.contact_point_type;
5905: l_contact_point_rec.status := p_contact_point_rec.status;

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

5924: l_phone_rec_type.phone_number := p_contact_point_rec.email_address;
5925: --Added following codition to make area code null if area code having no value 3392035
5926: IF p_contact_point_rec.area_code IS NULL
5927: THEN
5928: l_phone_rec_type.phone_area_code := FND_API.G_MISS_CHAR;
5929: ELSE
5930: l_phone_rec_type.phone_area_code := p_contact_point_rec.area_code;
5931: END IF;
5932: -- added for contact creation

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

5931: END IF;
5932: -- added for contact creation
5933: IF p_contact_point_rec.phone_country_code IS NULL
5934: THEN
5935: l_phone_rec_type.phone_country_code := FND_API.G_MISS_CHAR; -- added for contact creation
5936: ELSE
5937: l_phone_rec_type.phone_country_code := p_contact_point_rec.phone_country_code; -- added for contact creation
5938: END IF;
5939: --contact creation end

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

6007:
6008: --ADDED following condition to make area code null 3392035
6009: IF p_contact_point_rec.area_code IS NULL
6010: THEN
6011: l_phone_rec_type.phone_area_code := FND_API.G_MISS_CHAR;
6012: ELSE
6013: l_phone_rec_type.phone_area_code := p_contact_point_rec.area_code;
6014: END IF;
6015: -- added for contact creation OCT 2004

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

6014: END IF;
6015: -- added for contact creation OCT 2004
6016: IF p_contact_point_rec.phone_country_code IS NULL
6017: THEN
6018: l_phone_rec_type.phone_country_code := FND_API.G_MISS_CHAR; -- added for contact creation
6019: ELSE
6020: l_phone_rec_type.phone_country_code := p_contact_point_rec.phone_country_code; -- added for contact creation
6021: END IF;
6022: --contact creation end OCT 2004

Line 6597: , FND_API.G_FALSE

6593: THEN
6594: FOR j IN 1 .. x_msg_count LOOP
6595: fnd_msg_pub.get
6596: (j
6597: , FND_API.G_FALSE
6598: , x_msg_data
6599: , t_msg_dummy
6600: );
6601: t_output := ('Msg'

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

7945:
7946: END update_quantity;
7947: -- added for contact creation OCT2004
7948: PROCEDURE create_person (
7949: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7950: p_person_tbl IN PERSON_TBL_TYPE,
7951: x_party_id OUT NOCOPY NUMBER,
7952: x_party_number OUT NOCOPY VARCHAR2,
7953: x_profile_id OUT NOCOPY NUMBER,

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

7990: SQLERRM);
7991: END;
7992:
7993: PROCEDURE update_person (
7994: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7995: p_person_tbl IN PERSON_TBL_TYPE,
7996: p_party_object_version_number IN NUMBER,
7997: x_profile_id OUT NOCOPY NUMBER,
7998: x_return_status OUT NOCOPY VARCHAR2,

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

8035:
8036: END;
8037:
8038: PROCEDURE create_org_contact (
8039: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8040: p_org_contact_tbl IN ORG_CONTACT_TBL_TYPE,
8041: p_relationship_tbl_type IN relationship_tbl_type,
8042: x_org_contact_id OUT NOCOPY NUMBER,
8043: x_party_rel_id OUT NOCOPY NUMBER,

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

8090: SQLERRM);
8091: END;
8092:
8093: PROCEDURE update_org_contact (
8094: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8095: p_org_contact_tbl IN ORG_CONTACT_TBL_TYPE,
8096: p_relationship_tbl_type IN relationship_tbl_type,
8097: p_cont_object_version_number IN OUT NOCOPY NUMBER,
8098: p_rel_object_version_number IN OUT NOCOPY NUMBER,

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

8150: SQLERRM);
8151: END;
8152:
8153: PROCEDURE create_party_site (
8154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8155: p_party_site_tbl IN PARTY_SITE_TBL_TYPE,
8156: x_party_site_id OUT NOCOPY NUMBER,
8157: x_party_site_number OUT NOCOPY VARCHAR2,
8158: x_return_status OUT NOCOPY VARCHAR2,

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

8212: SQLERRM);
8213: END;
8214:
8215: PROCEDURE update_party_site (
8216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8217: p_party_site_tbl IN PARTY_SITE_TBL_TYPE,
8218: p_object_version_number IN OUT NOCOPY NUMBER,
8219: x_return_status OUT NOCOPY VARCHAR2,
8220: x_msg_count OUT NOCOPY NUMBER,

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

8249: SQLERRM);
8250: END;
8251:
8252: PROCEDURE create_cust_account_role (
8253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8254: p_cust_account_role_tbl IN CUST_ACCOUNT_ROLE_tbl_TYPE,
8255: x_cust_account_role_id OUT NOCOPY NUMBER,
8256: x_return_status OUT NOCOPY VARCHAR2,
8257: x_msg_count OUT NOCOPY NUMBER,

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

8288: SQLERRM);
8289: END;
8290:
8291: PROCEDURE update_cust_account_role (
8292: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8293: p_cust_account_role_tbl IN CUST_ACCOUNT_ROLE_tbl_TYPE,
8294: p_object_version_number IN OUT NOCOPY NUMBER,
8295: x_return_status OUT NOCOPY VARCHAR2,
8296: x_msg_count OUT NOCOPY NUMBER,

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

8328: SQLERRM);
8329: END;
8330:
8331: PROCEDURE create_cust_acct_site (
8332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8333: p_cust_acct_site_tbl IN CUST_ACCT_SITE_TBL_TYPE,
8334: x_cust_acct_site_id OUT NOCOPY NUMBER,
8335: x_return_status OUT NOCOPY VARCHAR2,
8336: x_msg_count OUT NOCOPY NUMBER,

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

8365:
8366: END;
8367:
8368: PROCEDURE update_cust_acct_site (
8369: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8370: p_cust_acct_site_tbl IN CUST_ACCT_SITE_TBL_TYPE,
8371: p_object_version_number IN OUT NOCOPY NUMBER,
8372: x_return_status OUT NOCOPY VARCHAR2,
8373: x_msg_count OUT NOCOPY NUMBER,

Line 8575: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

8571: */
8572: PROCEDURE CHECK_UPDATE_AMOUNTS
8573: (
8574: p_api_version IN NUMBER,
8575: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
8576: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
8577: p_chr_id IN NUMBER,
8578: x_msg_count OUT NOCOPY NUMBER,
8579: x_msg_data OUT NOCOPY VARCHAR2,

Line 8576: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

8572: PROCEDURE CHECK_UPDATE_AMOUNTS
8573: (
8574: p_api_version IN NUMBER,
8575: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
8576: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
8577: p_chr_id IN NUMBER,
8578: x_msg_count OUT NOCOPY NUMBER,
8579: x_msg_data OUT NOCOPY VARCHAR2,
8580: x_return_status OUT NOCOPY VARCHAR2

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

8719: END IF;
8720:
8721: --standard api initilization and checks
8722: SAVEPOINT check_update_amounts_PVT;
8723: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
8724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8725: END IF;
8726: IF FND_API.to_boolean(p_init_msg_list ) THEN
8727: FND_MSG_PUB.initialize;

Line 8724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8720:
8721: --standard api initilization and checks
8722: SAVEPOINT check_update_amounts_PVT;
8723: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
8724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8725: END IF;
8726: IF FND_API.to_boolean(p_init_msg_list ) THEN
8727: FND_MSG_PUB.initialize;
8728: END IF;

Line 8726: IF FND_API.to_boolean(p_init_msg_list ) THEN

8722: SAVEPOINT check_update_amounts_PVT;
8723: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
8724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8725: END IF;
8726: IF FND_API.to_boolean(p_init_msg_list ) THEN
8727: FND_MSG_PUB.initialize;
8728: END IF;
8729: x_return_status := FND_API.G_RET_STS_SUCCESS;
8730:

Line 8729: x_return_status := FND_API.G_RET_STS_SUCCESS;

8725: END IF;
8726: IF FND_API.to_boolean(p_init_msg_list ) THEN
8727: FND_MSG_PUB.initialize;
8728: END IF;
8729: x_return_status := FND_API.G_RET_STS_SUCCESS;
8730:
8731: --get all toplines that are out of sync with sublines
8732: OPEN c_k_toplines(p_chr_id);
8733: LOOP

Line 8781: RAISE FND_API.g_exc_error;

8777: l_sl_amt_tbl.delete;
8778: l_tl_amt_tax_tbl.delete;
8779: l_sl_amt_tax_tbl.delete;
8780:
8781: RAISE FND_API.g_exc_error;
8782:
8783: END; --of anonymous block checking topline locks
8784:
8785: END LOOP;

Line 8864: RAISE FND_API.g_exc_error;

8860: l_sl_amt_tbl.delete;
8861: l_tl_amt_tax_tbl.delete;
8862: l_sl_amt_tax_tbl.delete;
8863:
8864: RAISE FND_API.g_exc_error;
8865:
8866: END; --of anonymous block checking topline locks
8867: END LOOP;
8868:

Line 8947: RAISE FND_API.g_exc_error;

8943: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);
8944: END IF;
8945: FND_MSG_PUB.ADD;
8946:
8947: RAISE FND_API.g_exc_error;
8948:
8949: END; --of anonymous block checking header lock
8950:
8951: END IF; --of (l_hdr_amt <> l_tl_amt) OR(l_hdr_amt_tax <> l_tl_amt_tax) THEN

Line 9004: RAISE FND_API.g_exc_error;

9000: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);
9001: END IF;
9002: FND_MSG_PUB.ADD;
9003:
9004: RAISE FND_API.g_exc_error;
9005:
9006: END; --of anonymous block checking header lock
9007:
9008: END IF; --of (l_hdr_amt <> l_tl_amt) OR(l_hdr_amt_tax <> l_tl_amt_tax)

Line 9058: RAISE FND_API.g_exc_error;

9054: l_tl_id_tbl.delete;
9055: l_tl_amt_tbl.delete;
9056: l_sl_amt_tbl.delete;
9057:
9058: RAISE FND_API.g_exc_error;
9059:
9060: END; --of anonymous block checking topline locks
9061:
9062: END LOOP;

Line 9127: RAISE FND_API.g_exc_error;

9123: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);
9124: END IF;
9125: FND_MSG_PUB.ADD;
9126:
9127: RAISE FND_API.g_exc_error;
9128:
9129: END; --of anonymous block checking header lock
9130:
9131: END IF; --of (l_header_cancelled <> l_topline_cancelled) THEN

Line 9133: IF FND_API.to_boolean(p_commit) THEN

9129: END; --of anonymous block checking header lock
9130:
9131: END IF; --of (l_header_cancelled <> l_topline_cancelled) THEN
9132:
9133: IF FND_API.to_boolean(p_commit) THEN
9134: COMMIT;
9135: END IF;
9136:
9137: --exit

Line 9144: WHEN FND_API.g_exc_error THEN

9140: END IF;
9141: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
9142:
9143: EXCEPTION
9144: WHEN FND_API.g_exc_error THEN
9145: ROLLBACK TO check_update_amounts_PVT;
9146: x_return_status := FND_API.g_ret_sts_error ;
9147:
9148: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

Line 9146: x_return_status := FND_API.g_ret_sts_error ;

9142:
9143: EXCEPTION
9144: WHEN FND_API.g_exc_error THEN
9145: ROLLBACK TO check_update_amounts_PVT;
9146: x_return_status := FND_API.g_ret_sts_error ;
9147:
9148: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
9149: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
9150: END IF;

Line 9169: WHEN FND_API.g_exc_unexpected_error THEN

9165: CLOSE c_lock_hdr;
9166: END IF;
9167:
9168:
9169: WHEN FND_API.g_exc_unexpected_error THEN
9170: ROLLBACK TO check_update_amounts_PVT;
9171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9172:
9173: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

Line 9171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9167:
9168:
9169: WHEN FND_API.g_exc_unexpected_error THEN
9170: ROLLBACK TO check_update_amounts_PVT;
9171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9172:
9173: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
9174: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
9175: END IF;

Line 9195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9191: END IF;
9192:
9193: WHEN OTHERS THEN
9194: ROLLBACK TO check_update_amounts_PVT;
9195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9196:
9197: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
9198: --first log the sqlerrm
9199: l_error_text := substr (SQLERRM, 1, 240);

Line 9290: x_return_status := FND_API.G_RET_STS_SUCCESS;

9286: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9287: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', ' p_chr_id='|| p_chr_id);
9288: END IF;
9289:
9290: x_return_status := FND_API.G_RET_STS_SUCCESS;
9291:
9292:
9293: SELECT concurrent_program_id, p.application_id
9294: INTO program_id, prog_appl_id

Line 9307: x_return_status := FND_API.G_RET_STS_ERROR;

9303: FETCH c_reprice_req INTO req_id;
9304: CLOSE c_reprice_req;
9305:
9306: IF req_id is not null THEN
9307: x_return_status := FND_API.G_RET_STS_ERROR;
9308: ELSE
9309: x_return_status := FND_API.G_RET_STS_SUCCESS;
9310: END IF;
9311:

Line 9309: x_return_status := FND_API.G_RET_STS_SUCCESS;

9305:
9306: IF req_id is not null THEN
9307: x_return_status := FND_API.G_RET_STS_ERROR;
9308: ELSE
9309: x_return_status := FND_API.G_RET_STS_SUCCESS;
9310: END IF;
9311:
9312: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9313: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);

Line 9318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9314: END IF;
9315:
9316: EXCEPTION
9317: WHEN OTHERS THEN
9318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9319: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9320: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
9321: END IF;
9322:

Line 9368: x_return_status := FND_API.G_RET_STS_SUCCESS;

9364: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9365: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', ' p_chr_id='|| p_chr_id);
9366: END IF;
9367:
9368: x_return_status := FND_API.G_RET_STS_SUCCESS;
9369:
9370:
9371: SELECT concurrent_program_id, p.application_id
9372: INTO program_id, prog_appl_id

Line 9385: x_return_status := FND_API.G_RET_STS_ERROR;

9381: FETCH c_cascade_req INTO req_id;
9382: CLOSE c_cascade_req;
9383:
9384: IF req_id is not null THEN
9385: x_return_status := FND_API.G_RET_STS_ERROR;
9386: ELSE
9387: x_return_status := FND_API.G_RET_STS_SUCCESS;
9388: END IF;
9389:

Line 9387: x_return_status := FND_API.G_RET_STS_SUCCESS;

9383:
9384: IF req_id is not null THEN
9385: x_return_status := FND_API.G_RET_STS_ERROR;
9386: ELSE
9387: x_return_status := FND_API.G_RET_STS_SUCCESS;
9388: END IF;
9389:
9390: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9391: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);

Line 9396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9392: END IF;
9393:
9394: EXCEPTION
9395: WHEN OTHERS THEN
9396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9397: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9398: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
9399: END IF;
9400:

Line 9820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9816:
9817: DBMS_TRANSACTION.rollback_savepoint('REVALUE_PRICE');
9818:
9819: WHEN OTHERS THEN
9820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9821: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9822: FND_LOG.string(FND_LOG.level_procedure,
9823: l_mod_name || '.end',
9824: 'error at revalue contract l_return_status=' ||

Line 9874: x_return_status := FND_API.G_RET_STS_SUCCESS;

9870: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9871: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', ' p_chr_id='|| p_chr_id);
9872: END IF;
9873:
9874: x_return_status := FND_API.G_RET_STS_SUCCESS;
9875:
9876:
9877: SELECT concurrent_program_id, p.application_id
9878: INTO program_id, prog_appl_id

Line 9891: x_return_status := FND_API.G_RET_STS_ERROR;

9887: FETCH c_massupd_req INTO req_id;
9888: CLOSE c_massupd_req;
9889:
9890: IF req_id is not null THEN
9891: x_return_status := FND_API.G_RET_STS_ERROR;
9892: ELSE
9893: x_return_status := FND_API.G_RET_STS_SUCCESS;
9894: END IF;
9895:

Line 9893: x_return_status := FND_API.G_RET_STS_SUCCESS;

9889:
9890: IF req_id is not null THEN
9891: x_return_status := FND_API.G_RET_STS_ERROR;
9892: ELSE
9893: x_return_status := FND_API.G_RET_STS_SUCCESS;
9894: END IF;
9895:
9896: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9897: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);

Line 9902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9898: END IF;
9899:
9900: EXCEPTION
9901: WHEN OTHERS THEN
9902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9903: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9904: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
9905: END IF;
9906: