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.ZX_API_PUB dependencies on ZX_SECURITY

Line 354: | Call to zx_security.set_security_context |

350:
351: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl := ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_trx_id_index).tax_regime_tbl;
352:
353: /*--------------------------------------------+
354: | Call to zx_security.set_security_context |
355: +--------------------------------------------*/
356: ZX_SECURITY.set_security_context(ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_trx_id_index).legal_entity_id,
357: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_trx_id_index).internal_organization_id,
358: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_trx_id_index).effective_date,

Line 356: ZX_SECURITY.set_security_context(ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_trx_id_index).legal_entity_id,

352:
353: /*--------------------------------------------+
354: | Call to zx_security.set_security_context |
355: +--------------------------------------------*/
356: ZX_SECURITY.set_security_context(ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_trx_id_index).legal_entity_id,
357: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_trx_id_index).internal_organization_id,
358: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_trx_id_index).effective_date,
359: l_return_status
360: );

Line 475: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;

471: */
472:
473: IF l_event_class_rec.QUOTE_FLAG = 'Y' and
474: l_event_class_rec.ICX_SESSION_ID is not null THEN
475: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;
476: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
477: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
478:
479: END IF;

Line 476: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

472:
473: IF l_event_class_rec.QUOTE_FLAG = 'Y' and
474: l_event_class_rec.ICX_SESSION_ID is not null THEN
475: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;
476: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
477: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
478:
479: END IF;
480:

Line 477: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

473: IF l_event_class_rec.QUOTE_FLAG = 'Y' and
474: l_event_class_rec.ICX_SESSION_ID is not null THEN
475: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;
476: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
477: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
478:
479: END IF;
480:
481: -- Bug 4948674: Following Delete will not work when there are different dbms sessions used for the same user

Line 1329: ZX_SECURITY.G_ICX_SESSION_ID := null;

1325: null;
1326: END;
1327:
1328: --Reset the icx_session_id at end of API
1329: ZX_SECURITY.G_ICX_SESSION_ID := null;
1330: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1331: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1332:
1333:

Line 1330: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

1326: END;
1327:
1328: --Reset the icx_session_id at end of API
1329: ZX_SECURITY.G_ICX_SESSION_ID := null;
1330: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1331: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1332:
1333:
1334: --Reset G_PUB_CALLING_SRVC at end of API

Line 1331: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

1327:
1328: --Reset the icx_session_id at end of API
1329: ZX_SECURITY.G_ICX_SESSION_ID := null;
1330: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1331: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1332:
1333:
1334: --Reset G_PUB_CALLING_SRVC at end of API
1335: ZX_API_PUB.G_PUB_CALLING_SRVC := null;

Line 1591: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;

1587:
1588: --Set the global variable if icx_session_id is not null
1589: IF l_event_class_rec.QUOTE_FLAG = 'Y' and
1590: l_event_class_rec.ICX_SESSION_ID is not null THEN
1591: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;
1592: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1593: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1594: ELSE
1595: ZX_SECURITY.G_ICX_SESSION_ID := null;

Line 1592: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

1588: --Set the global variable if icx_session_id is not null
1589: IF l_event_class_rec.QUOTE_FLAG = 'Y' and
1590: l_event_class_rec.ICX_SESSION_ID is not null THEN
1591: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;
1592: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1593: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1594: ELSE
1595: ZX_SECURITY.G_ICX_SESSION_ID := null;
1596: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

Line 1593: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

1589: IF l_event_class_rec.QUOTE_FLAG = 'Y' and
1590: l_event_class_rec.ICX_SESSION_ID is not null THEN
1591: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;
1592: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1593: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1594: ELSE
1595: ZX_SECURITY.G_ICX_SESSION_ID := null;
1596: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1597: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

Line 1595: ZX_SECURITY.G_ICX_SESSION_ID := null;

1591: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;
1592: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1593: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1594: ELSE
1595: ZX_SECURITY.G_ICX_SESSION_ID := null;
1596: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1597: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1598: END IF;
1599:

Line 1596: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

1592: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1593: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1594: ELSE
1595: ZX_SECURITY.G_ICX_SESSION_ID := null;
1596: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1597: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1598: END IF;
1599:
1600: -- Bug 4948674: Following Delete will not work when there are different dbms sessions used for the same user

Line 1597: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

1593: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1594: ELSE
1595: ZX_SECURITY.G_ICX_SESSION_ID := null;
1596: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1597: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1598: END IF;
1599:
1600: -- Bug 4948674: Following Delete will not work when there are different dbms sessions used for the same user
1601: -- session when call originates from a FWK UI. Moved the following Delete logic to the end of this API for O2C

Line 1790: := zx_security.g_effective_date;

1786: := l_event_class_rec.internal_organization_id;
1787: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_ptnr_index).legal_entity_id
1788: := l_event_class_rec.legal_entity_id;
1789: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_ptnr_index).effective_date
1790: := zx_security.g_effective_date;
1791: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_ptnr_index).tax_regime_tbl
1792: := ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl;
1793: END IF;
1794: END IF;

Line 2052: ZX_SECURITY.G_ICX_SESSION_ID := null;

2048: ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.GEOGRAPHY_ID.DELETE;
2049: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_HASH_TBL.DELETE;
2050:
2051: --Reset the icx_session_id at end of API
2052: ZX_SECURITY.G_ICX_SESSION_ID := null;
2053: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
2054: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
2055:
2056: --Reset the calling API info at end of API

Line 2053: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

2049: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_HASH_TBL.DELETE;
2050:
2051: --Reset the icx_session_id at end of API
2052: ZX_SECURITY.G_ICX_SESSION_ID := null;
2053: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
2054: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
2055:
2056: --Reset the calling API info at end of API
2057: ZX_API_PUB.G_PUB_CALLING_SRVC := null;

Line 2054: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

2050:
2051: --Reset the icx_session_id at end of API
2052: ZX_SECURITY.G_ICX_SESSION_ID := null;
2053: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
2054: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
2055:
2056: --Reset the calling API info at end of API
2057: ZX_API_PUB.G_PUB_CALLING_SRVC := null;
2058:

Line 4692: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;

4688: where rownum = 1;
4689:
4690: IF l_event_class_rec.QUOTE_FLAG = 'Y' and
4691: l_event_class_rec.ICX_SESSION_ID is not null THEN
4692: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;
4693: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
4694: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
4695:
4696: ELSE

Line 4693: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

4689:
4690: IF l_event_class_rec.QUOTE_FLAG = 'Y' and
4691: l_event_class_rec.ICX_SESSION_ID is not null THEN
4692: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;
4693: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
4694: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
4695:
4696: ELSE
4697: ZX_SECURITY.G_ICX_SESSION_ID := null;

Line 4694: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

4690: IF l_event_class_rec.QUOTE_FLAG = 'Y' and
4691: l_event_class_rec.ICX_SESSION_ID is not null THEN
4692: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;
4693: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
4694: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
4695:
4696: ELSE
4697: ZX_SECURITY.G_ICX_SESSION_ID := null;
4698: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

Line 4697: ZX_SECURITY.G_ICX_SESSION_ID := null;

4693: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
4694: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
4695:
4696: ELSE
4697: ZX_SECURITY.G_ICX_SESSION_ID := null;
4698: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
4699: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
4700:
4701: END IF;

Line 4698: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

4694: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
4695:
4696: ELSE
4697: ZX_SECURITY.G_ICX_SESSION_ID := null;
4698: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
4699: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
4700:
4701: END IF;
4702:

Line 4699: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

4695:
4696: ELSE
4697: ZX_SECURITY.G_ICX_SESSION_ID := null;
4698: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
4699: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
4700:
4701: END IF;
4702:
4703: -- Check if trx line dist qty is passed when variance calc flag is 'Y'

Line 5059: ZX_SECURITY.G_ICX_SESSION_ID := null;

5055:
5056: -- Bug fix 5417887 end
5057:
5058: --Reset the icx_session_id at end of API
5059: ZX_SECURITY.G_ICX_SESSION_ID := null;
5060: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5061: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5062:
5063:

Line 5060: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

5056: -- Bug fix 5417887 end
5057:
5058: --Reset the icx_session_id at end of API
5059: ZX_SECURITY.G_ICX_SESSION_ID := null;
5060: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5061: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5062:
5063:
5064: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 5061: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

5057:
5058: --Reset the icx_session_id at end of API
5059: ZX_SECURITY.G_ICX_SESSION_ID := null;
5060: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5061: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5062:
5063:
5064: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5065: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_API_PUB: '||l_api_name||'()-');

Line 7814: | Call to zx_security.set_security_context |

7810: x_return_status := FND_API.G_RET_STS_SUCCESS;
7811:
7812:
7813: /*--------------------------------------------+
7814: | Call to zx_security.set_security_context |
7815: +--------------------------------------------*/
7816:
7817: x_effective_date := determine_effective_date(p_transaction_date,
7818: p_related_doc_date,

Line 7822: ZX_SECURITY.set_security_context(p_legal_entity_id,

7818: p_related_doc_date,
7819: p_adjusted_doc_date);
7820: l_effective_date := x_effective_date;
7821:
7822: ZX_SECURITY.set_security_context(p_legal_entity_id,
7823: p_internal_org_id,
7824: l_effective_date,
7825: l_return_status
7826: );

Line 7830: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_SECURITY.set_security_context returned errors');

7826: );
7827:
7828: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7829: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7830: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_SECURITY.set_security_context returned errors');
7831: END IF;
7832: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7833: RAISE FND_API.G_EXC_ERROR;
7834: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 7977: | Call to zx_security.set_security_context |

7973: x_return_status := FND_API.G_RET_STS_SUCCESS;
7974:
7975:
7976: /*--------------------------------------------+
7977: | Call to zx_security.set_security_context |
7978: +--------------------------------------------*/
7979: ZX_SECURITY.set_security_context(p_legal_entity_id,
7980: p_internal_org_id,
7981: determine_effective_date(p_transaction_date,

Line 7979: ZX_SECURITY.set_security_context(p_legal_entity_id,

7975:
7976: /*--------------------------------------------+
7977: | Call to zx_security.set_security_context |
7978: +--------------------------------------------*/
7979: ZX_SECURITY.set_security_context(p_legal_entity_id,
7980: p_internal_org_id,
7981: determine_effective_date(p_transaction_date,
7982: p_related_doc_date,
7983: p_adjusted_doc_date,

Line 7988: x_effective_date := ZX_SECURITY.G_EFFECTIVE_DATE;

7984: p_provnl_tax_det_date),
7985: l_return_status
7986: );
7987:
7988: x_effective_date := ZX_SECURITY.G_EFFECTIVE_DATE;
7989:
7990: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7991: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7992: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_SECURITY.set_security_context returned errors');

Line 7992: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_SECURITY.set_security_context returned errors');

7988: x_effective_date := ZX_SECURITY.G_EFFECTIVE_DATE;
7989:
7990: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7991: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7992: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_SECURITY.set_security_context returned errors');
7993: END IF;
7994: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7995: RAISE FND_API.G_EXC_ERROR;
7996: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN