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

Line 101: -- be FND_API.G_RET_STS_SUCCESS (success),

97: -- px_parent_osr Parent original system reference.
98: -- p_person_obj_type Parent object type.
99: -- OUT:
100: -- x_return_status Return status after the call. The status can
101: -- be FND_API.G_RET_STS_SUCCESS (success),
102: -- FND_API.G_RET_STS_ERROR (error),
103: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
104: -- x_msg_count Return total number of message.
105: -- x_msg_data Return message content.

Line 102: -- FND_API.G_RET_STS_ERROR (error),

98: -- p_person_obj_type Parent object type.
99: -- OUT:
100: -- x_return_status Return status after the call. The status can
101: -- be FND_API.G_RET_STS_SUCCESS (success),
102: -- FND_API.G_RET_STS_ERROR (error),
103: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
104: -- x_msg_count Return total number of message.
105: -- x_msg_data Return message content.
106: -- NOTES

Line 103: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

99: -- OUT:
100: -- x_return_status Return status after the call. The status can
101: -- be FND_API.G_RET_STS_SUCCESS (success),
102: -- FND_API.G_RET_STS_ERROR (error),
103: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
104: -- x_msg_count Return total number of message.
105: -- x_msg_data Return message content.
106: -- NOTES
107: --

Line 158: x_return_status := FND_API.G_RET_STS_SUCCESS;

154: p_prefix=>l_debug_prefix,
155: p_msg_level=>fnd_log.level_procedure);
156: END IF;
157:
158: x_return_status := FND_API.G_RET_STS_SUCCESS;
159:
160: l_parent_ss_flag := is_ss_provided(p_os => px_parent_os,
161: p_osr => px_parent_osr);
162:

Line 196: RAISE fnd_api.g_exc_error;

192: CLOSE is_acct_site_parent_valid;
193: END IF;
194: -- if px_parent_id is invalid, raise error
195: IF(l_valid_parent = 'N') THEN
196: RAISE fnd_api.g_exc_error;
197: END IF;
198: END IF;
199:
200: -- if px_parent_os/px_parent_osr is not null, get owner_table_id and

Line 225: IF(l_count = 0) OR (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

221: IF(px_parent_id IS NOT NULL) THEN
222: -- check if px_parent_os/px_parent_osr is passed
223: IF(l_parent_ss_flag = 'Y') THEN
224: -- if px_parent_os/px_parent_osr is not valid, raise error
225: IF(l_count = 0) OR (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
226: RAISE fnd_api.g_exc_error;
227: END IF;
228: -- if px_parent_os/px_parent_osr is valid, but not same as px_parent_id
229: IF(l_owner_table_id <> px_parent_id) THEN

Line 226: RAISE fnd_api.g_exc_error;

222: -- check if px_parent_os/px_parent_osr is passed
223: IF(l_parent_ss_flag = 'Y') THEN
224: -- if px_parent_os/px_parent_osr is not valid, raise error
225: IF(l_count = 0) OR (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
226: RAISE fnd_api.g_exc_error;
227: END IF;
228: -- if px_parent_os/px_parent_osr is valid, but not same as px_parent_id
229: IF(l_owner_table_id <> px_parent_id) THEN
230: RAISE fnd_api.g_exc_error;

Line 230: RAISE fnd_api.g_exc_error;

226: RAISE fnd_api.g_exc_error;
227: END IF;
228: -- if px_parent_os/px_parent_osr is valid, but not same as px_parent_id
229: IF(l_owner_table_id <> px_parent_id) THEN
230: RAISE fnd_api.g_exc_error;
231: END IF;
232: END IF;
233: -- if px_parent_id is not passed in
234: ELSE

Line 239: IF(l_count = 0) OR (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

235: -- check if px_parent_os/px_parent_osr can find TCA identifier, owner_table_id
236: -- if not found, raise error
237: -- else, get owner_table_id and assign it to px_parent_id
238: IF(l_parent_ss_flag = 'Y') THEN
239: IF(l_count = 0) OR (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
240: RAISE fnd_api.g_exc_error;
241: ELSE
242: px_parent_id := l_owner_table_id;
243: END IF;

Line 240: RAISE fnd_api.g_exc_error;

236: -- if not found, raise error
237: -- else, get owner_table_id and assign it to px_parent_id
238: IF(l_parent_ss_flag = 'Y') THEN
239: IF(l_count = 0) OR (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
240: RAISE fnd_api.g_exc_error;
241: ELSE
242: px_parent_id := l_owner_table_id;
243: END IF;
244: ELSE

Line 245: RAISE fnd_api.g_exc_error;

241: ELSE
242: px_parent_id := l_owner_table_id;
243: END IF;
244: ELSE
245: RAISE fnd_api.g_exc_error;
246: END IF;
247: END IF;
248: EXCEPTION
249: WHEN fnd_api.g_exc_error THEN

Line 249: WHEN fnd_api.g_exc_error THEN

245: RAISE fnd_api.g_exc_error;
246: END IF;
247: END IF;
248: EXCEPTION
249: WHEN fnd_api.g_exc_error THEN
250: x_return_status := fnd_api.g_ret_sts_error;
251:
252: -- put error message "Error: Invalid Identifier";
253: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_PARENT_ID');

Line 250: x_return_status := fnd_api.g_ret_sts_error;

246: END IF;
247: END IF;
248: EXCEPTION
249: WHEN fnd_api.g_exc_error THEN
250: x_return_status := fnd_api.g_ret_sts_error;
251:
252: -- put error message "Error: Invalid Identifier";
253: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_PARENT_ID');
254: FND_MSG_PUB.ADD();

Line 256: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

252: -- put error message "Error: Invalid Identifier";
253: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_PARENT_ID');
254: FND_MSG_PUB.ADD();
255:
256: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
257: p_count => x_msg_count,
258: p_data => x_msg_data);
259:
260: -- Debug info.

Line 272: WHEN fnd_api.g_exc_unexpected_error THEN

268: hz_utility_v2pub.debug(p_message=>'validate_parent_id(-)',
269: p_prefix=>l_debug_prefix,
270: p_msg_level=>fnd_log.level_procedure);
271: END IF;
272: WHEN fnd_api.g_exc_unexpected_error THEN
273: x_return_status := fnd_api.g_ret_sts_unexp_error;
274:
275: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
276: p_count => x_msg_count,

Line 273: x_return_status := fnd_api.g_ret_sts_unexp_error;

269: p_prefix=>l_debug_prefix,
270: p_msg_level=>fnd_log.level_procedure);
271: END IF;
272: WHEN fnd_api.g_exc_unexpected_error THEN
273: x_return_status := fnd_api.g_ret_sts_unexp_error;
274:
275: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
276: p_count => x_msg_count,
277: p_data => x_msg_data);

Line 275: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

271: END IF;
272: WHEN fnd_api.g_exc_unexpected_error THEN
273: x_return_status := fnd_api.g_ret_sts_unexp_error;
274:
275: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
276: p_count => x_msg_count,
277: p_data => x_msg_data);
278:
279: -- Debug info.

Line 293: x_return_status := fnd_api.g_ret_sts_unexp_error;

289: p_msg_level=>fnd_log.level_procedure);
290: END IF;
291:
292: WHEN OTHERS THEN
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294:
295: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
296: fnd_message.set_token('ERROR' ,SQLERRM);
297: fnd_msg_pub.add;

Line 299: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

295: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
296: fnd_message.set_token('ERROR' ,SQLERRM);
297: fnd_msg_pub.add;
298:
299: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
300: p_count => x_msg_count,
301: p_data => x_msg_data);
302:
303: -- Debug info.

Line 335: -- be FND_API.G_RET_STS_SUCCESS (success),

331: -- p_obj_type Business object type.
332: -- p_create_or_update Flag to indicate create or update.
333: -- OUT:
334: -- x_return_status Return status after the call. The status can
335: -- be FND_API.G_RET_STS_SUCCESS (success),
336: -- FND_API.G_RET_STS_ERROR (error),
337: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
338: -- x_msg_count Return total number of message.
339: -- x_msg_data Return message content.

Line 336: -- FND_API.G_RET_STS_ERROR (error),

332: -- p_create_or_update Flag to indicate create or update.
333: -- OUT:
334: -- x_return_status Return status after the call. The status can
335: -- be FND_API.G_RET_STS_SUCCESS (success),
336: -- FND_API.G_RET_STS_ERROR (error),
337: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
338: -- x_msg_count Return total number of message.
339: -- x_msg_data Return message content.
340: -- NOTES

Line 337: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

333: -- OUT:
334: -- x_return_status Return status after the call. The status can
335: -- be FND_API.G_RET_STS_SUCCESS (success),
336: -- FND_API.G_RET_STS_ERROR (error),
337: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
338: -- x_msg_count Return total number of message.
339: -- x_msg_data Return message content.
340: -- NOTES
341: --

Line 423: x_return_status := FND_API.G_RET_STS_SUCCESS;

419: p_prefix=>l_debug_prefix,
420: p_msg_level=>fnd_log.level_procedure);
421: END IF;
422:
423: x_return_status := FND_API.G_RET_STS_SUCCESS;
424:
425: -- check if os+osr are provided
426: l_ss_flag := is_ss_provided(p_os => px_os,
427: p_osr => px_osr);

Line 436: RAISE FND_API.G_EXC_ERROR;

432: -- return error
433: IF(p_create_or_update = 'C') THEN
434: FND_MESSAGE.SET_NAME('AR','HZ_API_CANNOT_PASS_PK');
435: FND_MSG_PUB.ADD();
436: RAISE FND_API.G_EXC_ERROR;
437: END IF;
438: IF(p_obj_type in ('PHONE','TLX','EMAIL','WEB','EFT','EDI','SMS')) THEN
439: OPEN is_cp_valid(px_id, p_obj_type);
440: FETCH is_cp_valid INTO l_valid_id;

Line 510: RAISE fnd_api.g_exc_error;

506: CLOSE is_cp_valid;
507: IF(l_dummy IS NULL) THEN
508: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
509: FND_MSG_PUB.ADD;
510: RAISE fnd_api.g_exc_error;
511: END IF;
512: END IF;
513: END IF;
514: END IF;

Line 524: RAISE fnd_api.g_exc_error;

520: -- if px_id is invalid, raise error
521: IF(l_valid_id IS NULL) THEN
522: FND_MESSAGE.SET_NAME('AR','HZ_API_UPDATE_NOT_EXIST');
523: FND_MSG_PUB.ADD();
524: RAISE fnd_api.g_exc_error;
525: -- if px_id is valid
526: ELSE
527: -- check if px_os/px_osr is passed
528: IF(l_ss_flag = 'Y') THEN

Line 534: RAISE fnd_api.g_exc_error;

530: -- we should not create ssm mapping, error out
531: IF(l_count = 0) THEN
532: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_ID');
533: FND_MSG_PUB.ADD();
534: RAISE fnd_api.g_exc_error;
535: -- if px_os/px_osr is valid
536: ELSE
537: -- if px_os/px_osr is valid, but not same as px_id
538: IF(l_owner_table_id <> px_id) OR (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 538: IF(l_owner_table_id <> px_id) OR (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

534: RAISE fnd_api.g_exc_error;
535: -- if px_os/px_osr is valid
536: ELSE
537: -- if px_os/px_osr is valid, but not same as px_id
538: IF(l_owner_table_id <> px_id) OR (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
539: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_ID');
540: FND_MSG_PUB.ADD();
541: RAISE fnd_api.g_exc_error;
542: END IF;

Line 541: RAISE fnd_api.g_exc_error;

537: -- if px_os/px_osr is valid, but not same as px_id
538: IF(l_owner_table_id <> px_id) OR (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
539: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_ID');
540: FND_MSG_PUB.ADD();
541: RAISE fnd_api.g_exc_error;
542: END IF;
543: END IF;
544: -- if px_os/px_osr is valid and return value is same as px_id
545: -- do nothing

Line 553: IF(l_ss_flag = 'Y') AND (l_count = 1) AND (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

549: ELSE
550: -- check if px_os/px_osr can find TCA identifier, owner_table_id
551: -- if not found, raise error
552: -- else, get owner_table_id and assign it to px_id
553: IF(l_ss_flag = 'Y') AND (l_count = 1) AND (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
554: px_id := l_owner_table_id;
555: ELSE
556: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_ID');
557: FND_MSG_PUB.ADD();

Line 558: RAISE fnd_api.g_exc_error;

554: px_id := l_owner_table_id;
555: ELSE
556: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_ID');
557: FND_MSG_PUB.ADD();
558: RAISE fnd_api.g_exc_error;
559: END IF;
560: END IF;
561: -- for create
562: ELSIF(p_create_or_update = 'C') THEN

Line 564: IF(l_ss_flag = 'Y') AND (l_count > 0) AND (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

560: END IF;
561: -- for create
562: ELSIF(p_create_or_update = 'C') THEN
563: -- if os+osr is valid, raise error
564: IF(l_ss_flag = 'Y') AND (l_count > 0) AND (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
565: FND_MESSAGE.SET_NAME('AR','HZ_API_CREATE_ALREADY_EXISTS');
566: FND_MSG_PUB.ADD();
567: RAISE fnd_api.g_exc_error;
568: END IF;

Line 567: RAISE fnd_api.g_exc_error;

563: -- if os+osr is valid, raise error
564: IF(l_ss_flag = 'Y') AND (l_count > 0) AND (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
565: FND_MESSAGE.SET_NAME('AR','HZ_API_CREATE_ALREADY_EXISTS');
566: FND_MSG_PUB.ADD();
567: RAISE fnd_api.g_exc_error;
568: END IF;
569: END IF; -- if p_create_or_update
570:
571: EXCEPTION

Line 572: WHEN fnd_api.g_exc_error THEN

568: END IF;
569: END IF; -- if p_create_or_update
570:
571: EXCEPTION
572: WHEN fnd_api.g_exc_error THEN
573: x_return_status := fnd_api.g_ret_sts_error;
574:
575: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
576: p_count => x_msg_count,

Line 573: x_return_status := fnd_api.g_ret_sts_error;

569: END IF; -- if p_create_or_update
570:
571: EXCEPTION
572: WHEN fnd_api.g_exc_error THEN
573: x_return_status := fnd_api.g_ret_sts_error;
574:
575: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
576: p_count => x_msg_count,
577: p_data => x_msg_data);

Line 575: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

571: EXCEPTION
572: WHEN fnd_api.g_exc_error THEN
573: x_return_status := fnd_api.g_ret_sts_error;
574:
575: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
576: p_count => x_msg_count,
577: p_data => x_msg_data);
578:
579: -- Debug info.

Line 591: WHEN fnd_api.g_exc_unexpected_error THEN

587: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
588: p_prefix=>l_debug_prefix,
589: p_msg_level=>fnd_log.level_procedure);
590: END IF;
591: WHEN fnd_api.g_exc_unexpected_error THEN
592: x_return_status := fnd_api.g_ret_sts_unexp_error;
593:
594: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
595: p_count => x_msg_count,

Line 592: x_return_status := fnd_api.g_ret_sts_unexp_error;

588: p_prefix=>l_debug_prefix,
589: p_msg_level=>fnd_log.level_procedure);
590: END IF;
591: WHEN fnd_api.g_exc_unexpected_error THEN
592: x_return_status := fnd_api.g_ret_sts_unexp_error;
593:
594: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
595: p_count => x_msg_count,
596: p_data => x_msg_data);

Line 594: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

590: END IF;
591: WHEN fnd_api.g_exc_unexpected_error THEN
592: x_return_status := fnd_api.g_ret_sts_unexp_error;
593:
594: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
595: p_count => x_msg_count,
596: p_data => x_msg_data);
597:
598: -- Debug info.

Line 611: x_return_status := fnd_api.g_ret_sts_unexp_error;

607: p_prefix=>l_debug_prefix,
608: p_msg_level=>fnd_log.level_procedure);
609: END IF;
610: WHEN OTHERS THEN
611: x_return_status := fnd_api.g_ret_sts_unexp_error;
612:
613: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
614: fnd_message.set_token('ERROR' ,SQLERRM);
615: fnd_msg_pub.add;

Line 617: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

613: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
614: fnd_message.set_token('ERROR' ,SQLERRM);
615: fnd_msg_pub.add;
616:
617: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
618: p_count => x_msg_count,
619: p_data => x_msg_data);
620:
621: -- Debug info.

Line 1317: x_return_status := FND_API.G_RET_STS_SUCCESS;

1313: AND rownum = 1;
1314:
1315: l_party_id NUMBER;
1316: BEGIN
1317: x_return_status := FND_API.G_RET_STS_SUCCESS;
1318: IF(px_certification_id IS NULL) THEN
1319: OPEN is_cert_exist(p_party_id, p_certification_name);
1320: FETCH is_cert_exist INTO x_last_update_date, px_certification_id;
1321: CLOSE is_cert_exist;

Line 1328: x_return_status := FND_API.G_RET_STS_ERROR;

1324: FETCH is_cert_id_exist INTO x_last_update_date, l_party_id;
1325: CLOSE is_cert_id_exist;
1326: IF(l_party_id <> p_party_id) OR (l_party_id IS NULL AND p_party_id IS NOT NULL) THEN
1327: -- return -1 to indicate that the combination of parent and object id do not match
1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329: END IF;
1330: END IF;
1331: END check_certification_op;
1332:

Line 1366: x_return_status := FND_API.G_RET_STS_SUCCESS;

1362: AND rownum = 1;
1363:
1364: l_party_id NUMBER;
1365: BEGIN
1366: x_return_status := FND_API.G_RET_STS_SUCCESS;
1367: IF(p_financial_profile_id IS NULL) THEN
1368: x_last_update_date := NULL;
1369: ELSE
1370: OPEN is_fin_exist(p_financial_profile_id);

Line 1374: x_return_status := FND_API.G_RET_STS_ERROR;

1370: OPEN is_fin_exist(p_financial_profile_id);
1371: FETCH is_fin_exist INTO x_last_update_date, l_party_id;
1372: CLOSE is_fin_exist;
1373: IF(l_party_id <> p_party_id) OR (l_party_id IS NULL AND p_party_id IS NOT NULL) THEN
1374: x_return_status := FND_API.G_RET_STS_ERROR;
1375: END IF;
1376: END IF;
1377: END check_financial_prof_op;
1378:

Line 2164: IF(l_ss_flag = 'Y') AND (l_count > 0) AND (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2160: IF(l_ss_flag = 'Y') AND (l_count = 0) THEN
2161: RETURN 'C';
2162: END IF;
2163: -- ssm is valid
2164: IF(l_ss_flag = 'Y') AND (l_count > 0) AND (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2165: RETURN 'U';
2166: ELSE
2167: RETURN 'E';
2168: END IF;

Line 2173: IF(l_ss_flag = 'Y') AND (l_count > 0) AND (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2169: ELSE
2170: -- invalid TCA id
2171: IF(l_dummy IS NULL) THEN
2172: -- ssm is valid
2173: IF(l_ss_flag = 'Y') AND (l_count > 0) AND (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2174: RETURN 'E';
2175: END IF;
2176: RETURN 'C';
2177: -- valid TCA id

Line 2222: x_return_status := FND_API.G_RET_STS_SUCCESS;

2218: AND rownum = 1;
2219:
2220: l_party_id NUMBER;
2221: BEGIN
2222: x_return_status := FND_API.G_RET_STS_SUCCESS;
2223: IF(p_party_usage_code IS NULL OR p_party_id IS NULL) THEN
2224: x_last_update_date := NULL;
2225: ELSE
2226: OPEN is_usg_exist(p_party_id,p_party_usage_code);

Line 2234: x_return_status := FND_API.G_RET_STS_ERROR;

2230: EXCEPTION
2231: when NO_DATA_FOUND then
2232: x_last_update_date := NULL;
2233: when OTHERS then
2234: x_return_status := FND_API.G_RET_STS_ERROR;
2235:
2236: END check_party_usage_op;
2237:
2238:

Line 2262: IF((p_os is null or p_os = fnd_api.g_miss_char)

2258: p_os IN VARCHAR2,
2259: p_osr IN VARCHAR2
2260: ) RETURN VARCHAR2 IS
2261: BEGIN
2262: IF((p_os is null or p_os = fnd_api.g_miss_char)
2263: and (p_osr is null or p_osr = fnd_api.g_miss_char))THEN
2264: RETURN 'N';
2265: ELSE
2266: RETURN 'Y';

Line 2263: and (p_osr is null or p_osr = fnd_api.g_miss_char))THEN

2259: p_osr IN VARCHAR2
2260: ) RETURN VARCHAR2 IS
2261: BEGIN
2262: IF((p_os is null or p_os = fnd_api.g_miss_char)
2263: and (p_osr is null or p_osr = fnd_api.g_miss_char))THEN
2264: RETURN 'N';
2265: ELSE
2266: RETURN 'Y';
2267: END IF;