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.OKL_AM_QUOTES_WF dependencies on OKC_API

Line 1966: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1962: ,x_msg_data => x_msg_data
1963: ,p_xmp_rec => l_xmp_rec
1964: ,x_xmp_rec => lx_xmp_rec
1965: );
1966: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1967: RAISE ERR;
1968: END IF;
1969:
1970:

Line 1971: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

1967: RAISE ERR;
1968: END IF;
1969:
1970:
1971: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1972: l_batch_id := lx_xmp_rec.batch_id;
1973: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1974: itemkey => itemkey,
1975: aname => 'BATCH_ID',

Line 2480: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

2476: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2477: 'after call to OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec :'||l_return_status);
2478: END IF;
2479:
2480: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2481: RAISE ERR;
2482: END IF;
2483:
2484:

Line 2485: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

2481: RAISE ERR;
2482: END IF;
2483:
2484:
2485: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2486: l_batch_id := lx_xmp_rec.batch_id;
2487: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2488: itemkey => itemkey,
2489: aname => 'BATCH_ID',

Line 3007: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

3003: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3004: 'after call to OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec :'||l_return_status);
3005: END IF;
3006:
3007: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
3008: RAISE ERR;
3009: END IF;
3010:
3011:

Line 3012: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3008: RAISE ERR;
3009: END IF;
3010:
3011:
3012: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3013: l_batch_id := lx_xmp_rec.batch_id;
3014: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3015: itemkey => itemkey,
3016: aname => 'BATCH_ID',

Line 3285: IF (l_art_id is null or l_art_id = OKC_API.G_MISS_NUM) THEN

3281: OPEN fetch_art_id(cp_qte_id => l_transaction_id);
3282: FETCH fetch_art_id INTO l_art_id;
3283: CLOSE fetch_art_id;
3284:
3285: IF (l_art_id is null or l_art_id = OKC_API.G_MISS_NUM) THEN
3286: resultout := 'COMPLETE:N';
3287: RAISE G_EXCEPTION;
3288: END IF;
3289:

Line 3290: /*IF (l_art_id is null or l_art_id = OKC_API.G_MISS_NUM) THEN

3286: resultout := 'COMPLETE:N';
3287: RAISE G_EXCEPTION;
3288: END IF;
3289:
3290: /*IF (l_art_id is null or l_art_id = OKC_API.G_MISS_NUM) THEN
3291: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
3292: p_msg_name => g_required_value,
3293: p_token1 => g_col_name_token,
3294: p_token1_value => 'l_art_id');

Line 3295: RAISE OKC_API.G_EXCEPTION_ERROR;

3291: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
3292: p_msg_name => g_required_value,
3293: p_token1 => g_col_name_token,
3294: p_token1_value => 'l_art_id');
3295: RAISE OKC_API.G_EXCEPTION_ERROR;
3296: END IF;*/
3297:
3298: OPEN fetch_legal_entity_id(cp_art_id => l_art_id);
3299: FETCH fetch_legal_entity_id INTO l_legal_entity_id;

Line 3302: IF (l_legal_entity_id is null or l_legal_entity_id = OKC_API.G_MISS_NUM) THEN

3298: OPEN fetch_legal_entity_id(cp_art_id => l_art_id);
3299: FETCH fetch_legal_entity_id INTO l_legal_entity_id;
3300: CLOSE fetch_legal_entity_id;
3301:
3302: IF (l_legal_entity_id is null or l_legal_entity_id = OKC_API.G_MISS_NUM) THEN
3303: resultout := 'COMPLETE:N';
3304: RAISE G_EXCEPTION;
3305: END IF;
3306: /*IF (l_legal_entity_id is null or l_legal_entity_id = OKC_API.G_MISS_NUM) THEN

Line 3306: /*IF (l_legal_entity_id is null or l_legal_entity_id = OKC_API.G_MISS_NUM) THEN

3302: IF (l_legal_entity_id is null or l_legal_entity_id = OKC_API.G_MISS_NUM) THEN
3303: resultout := 'COMPLETE:N';
3304: RAISE G_EXCEPTION;
3305: END IF;
3306: /*IF (l_legal_entity_id is null or l_legal_entity_id = OKC_API.G_MISS_NUM) THEN
3307: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
3308: p_msg_name => g_required_value,
3309: p_token1 => g_col_name_token,
3310: p_token1_value => 'l_legal_entity_id');

Line 3311: RAISE OKC_API.G_EXCEPTION_ERROR;

3307: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
3308: p_msg_name => g_required_value,
3309: p_token1 => g_col_name_token,
3310: p_token1_value => 'l_legal_entity_id');
3311: RAISE OKC_API.G_EXCEPTION_ERROR;
3312: END IF; */
3313: -- Legal Entity Changes End
3314:
3315: FOR l_amt_rec IN l_amt_csr ( l_transaction_id ) LOOP -- SECHAWLA 11-MAR-03 Changed the cursor name

Line 4257: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

4253: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
4254: 'after call to OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec :'||l_return_status);
4255: END IF;
4256:
4257: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
4258: RAISE ERR;
4259: END IF;
4260:
4261:

Line 4262: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

4258: RAISE ERR;
4259: END IF;
4260:
4261:
4262: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
4263: l_batch_id := lx_xmp_rec.batch_id;
4264: wf_engine.SetItemAttrText ( itemtype=> itemtype,
4265: itemkey => itemkey,
4266: aname => 'BATCH_ID',

Line 4540: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

4536:
4537: l_id VARCHAR2(100);
4538: l_approved VARCHAR2(1);
4539:
4540: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4541: x_msg_count NUMBER;
4542: x_msg_data VARCHAR2(2000);
4543: p_qtev_rec OKL_QTE_PVT.qtev_rec_type;
4544: x_qtev_rec OKL_QTE_PVT.qtev_rec_type;

Line 4601: IF x_return_status = OKC_API.G_RET_STS_SUCCESS THEN

4597: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
4598: 'after call to okl_qte_pvt.update_row :'||x_return_status);
4599: END IF;
4600:
4601: IF x_return_status = OKC_API.G_RET_STS_SUCCESS THEN
4602: IF nvl(l_approved, 'Y') = 'Y' THEN
4603: resultout := 'COMPLETE:APPROVED';
4604: ELSE
4605: resultout := 'COMPLETE:REJECTED';

Line 4839: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

4835: l_current_party NUMBER;
4836:
4837: l_quote_number VARCHAR2(100);
4838:
4839: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4840: x_msg_count NUMBER;
4841: x_msg_data VARCHAR2(2000);
4842: p_qtev_rec OKL_QTE_PVT.qtev_rec_type;
4843: x_qtev_rec OKL_QTE_PVT.qtev_rec_type;

Line 4851: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

4847: API_ERROR EXCEPTION;
4848: --19-jul-2007 ansethur R12B XML Publisher starts
4849: l_api_version NUMBER := 1;
4850: l_init_msg_list VARCHAR2(1) := 'T';
4851: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4852: ERR EXCEPTION;
4853: l_batch_id NUMBER;
4854: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
4855: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

Line 4928: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

4924: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
4925: 'after call to okl_qte_pvt.update_row :'||x_return_status);
4926: END IF;
4927:
4928: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
4929: RAISE API_ERROR;
4930: END IF;
4931: -- end of 20-Mar-06 rmunjulu 5087501
4932:

Line 5002: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

4998: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
4999: 'after call to okl_qte_pvt.update_row :'||x_return_status);
5000: END IF;
5001:
5002: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
5003: RAISE API_ERROR;
5004: END IF;
5005: --19-jul-2007 ansethur R12B XML Publisher Starts
5006: OPEN get_quote_xmlp_csr(l_quote_id);

Line 5022: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

5018: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
5019: 'after call to OKL_AM_PARTIES_PVT.get_party_details :'||l_return_status);
5020: END IF;
5021:
5022: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
5023: RAISE API_ERROR;
5024: END IF;
5025:
5026: -- Populate Item Attributes for Fulfillment

Line 5082: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

5078: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
5079: 'after call to OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec :'||l_return_status);
5080: END IF;
5081:
5082: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
5083: RAISE ERR;
5084: END IF;
5085:
5086:

Line 5087: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

5083: RAISE ERR;
5084: END IF;
5085:
5086:
5087: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
5088: l_batch_id := lx_xmp_rec.batch_id;
5089: wf_engine.SetItemAttrText ( itemtype=> itemtype,
5090: itemkey => itemkey,
5091: aname => 'BATCH_ID',

Line 5327: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

5323: SELECT partial_yn, khr_id, qtp_code
5324: FROM OKL_TRX_QUOTES_B
5325: WHERE id = c_id;
5326:
5327: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5328: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
5329:
5330: API_ERROR EXCEPTION;
5331: -- for debug logging

Line 5465: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

5461: l_quote_ctr c_quote_ctr%rowtype;
5462: l_quote_id NUMBER;
5463: l_rgd_code VARCHAR2(30);
5464: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
5465: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5466: l_message VARCHAR2(32000);
5467:
5468: l_tolerance_option VARCHAR2(150);
5469: l_tolerance_value NUMBER;

Line 5589: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

5585: SELECT *
5586: FROM OKL_TXL_QUOTE_LINES_B
5587: WHERE qte_id =c_id;
5588:
5589: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5590: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
5591:
5592: API_ERROR EXCEPTION;
5593:

Line 6011: OKC_API.SET_MESSAGE (

6007:
6008: l_recipient_desc := l_q_party_uv_tbl(l_party_count).po_party_name;
6009:
6010: ELSE
6011: OKC_API.SET_MESSAGE (
6012: p_app_name => OKC_API.G_APP_NAME,
6013: p_msg_name => 'NO_RECIPIENT',
6014: p_token1 => 'PARAM',
6015: p_token1_value => l_quote_id);

Line 6012: p_app_name => OKC_API.G_APP_NAME,

6008: l_recipient_desc := l_q_party_uv_tbl(l_party_count).po_party_name;
6009:
6010: ELSE
6011: OKC_API.SET_MESSAGE (
6012: p_app_name => OKC_API.G_APP_NAME,
6013: p_msg_name => 'NO_RECIPIENT',
6014: p_token1 => 'PARAM',
6015: p_token1_value => l_quote_id);
6016:

Line 6030: OKC_API.SET_MESSAGE (

6026: itemkey => itemkey,
6027: aname => 'RECIPIENT_TYPE',
6028: avalue => l_recipient_type);
6029: ELSE
6030: OKC_API.SET_MESSAGE (
6031: p_app_name => OKC_API.G_APP_NAME,
6032: p_msg_name => 'NO_RECIPIENT_TYPE',
6033: p_token1 => 'PARAM',
6034: p_token1_value => l_quote_id);

Line 6031: p_app_name => OKC_API.G_APP_NAME,

6027: aname => 'RECIPIENT_TYPE',
6028: avalue => l_recipient_type);
6029: ELSE
6030: OKC_API.SET_MESSAGE (
6031: p_app_name => OKC_API.G_APP_NAME,
6032: p_msg_name => 'NO_RECIPIENT_TYPE',
6033: p_token1 => 'PARAM',
6034: p_token1_value => l_quote_id);
6035:

Line 6046: OKC_API.SET_MESSAGE (

6042: itemkey => itemkey,
6043: aname => 'RECIPIENT_ID',
6044: avalue => l_recipient_id);
6045: ELSE
6046: OKC_API.SET_MESSAGE (
6047: p_app_name => OKC_API.G_APP_NAME,
6048: p_msg_name => 'NO_RECIPIENT_ID',
6049: p_token1 => 'PARAM',
6050: p_token1_value => l_quote_id);

Line 6047: p_app_name => OKC_API.G_APP_NAME,

6043: aname => 'RECIPIENT_ID',
6044: avalue => l_recipient_id);
6045: ELSE
6046: OKC_API.SET_MESSAGE (
6047: p_app_name => OKC_API.G_APP_NAME,
6048: p_msg_name => 'NO_RECIPIENT_ID',
6049: p_token1 => 'PARAM',
6050: p_token1_value => l_quote_id);
6051:

Line 6081: OKC_API.SET_MESSAGE (

6077: itemkey => itemkey,
6078: aname => 'RECIPIENT_TYPE',
6079: avalue => l_recipient_type);
6080: ELSE
6081: OKC_API.SET_MESSAGE (
6082: p_app_name => OKC_API.G_APP_NAME,
6083: p_msg_name => 'NO_RECIPIENT_TYPE',
6084: p_token1 => 'PARAM',
6085: p_token1_value => l_quote_id);

Line 6082: p_app_name => OKC_API.G_APP_NAME,

6078: aname => 'RECIPIENT_TYPE',
6079: avalue => l_recipient_type);
6080: ELSE
6081: OKC_API.SET_MESSAGE (
6082: p_app_name => OKC_API.G_APP_NAME,
6083: p_msg_name => 'NO_RECIPIENT_TYPE',
6084: p_token1 => 'PARAM',
6085: p_token1_value => l_quote_id);
6086:

Line 6096: OKC_API.SET_MESSAGE (

6092: itemkey => itemkey,
6093: aname => 'RECIPIENT_ID',
6094: avalue => l_recipient_id);
6095: ELSE
6096: OKC_API.SET_MESSAGE (
6097: p_app_name => OKC_API.G_APP_NAME,
6098: p_msg_name => 'NO_RECIPIENT_ID',
6099: p_token1 => 'PARAM',
6100: p_token1_value => l_quote_id);

Line 6097: p_app_name => OKC_API.G_APP_NAME,

6093: aname => 'RECIPIENT_ID',
6094: avalue => l_recipient_id);
6095: ELSE
6096: OKC_API.SET_MESSAGE (
6097: p_app_name => OKC_API.G_APP_NAME,
6098: p_msg_name => 'NO_RECIPIENT_ID',
6099: p_token1 => 'PARAM',
6100: p_token1_value => l_quote_id);
6101:

Line 6715: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

6711: l_approval_formula VARCHAR2(150);
6712:
6713: l_result VARCHAR2(50) := 'COMPLETE:NO';
6714:
6715: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6716: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
6717:
6718: -- rkuttiya 16-SEP-2003 Bug:2794685
6719: l_gain_loss_approval VARCHAR2(100);

Line 7303: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

7299:
7300: l_id VARCHAR2(100);
7301: l_approved VARCHAR2(1);
7302:
7303: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7304: x_msg_count NUMBER;
7305: x_msg_data VARCHAR2(2000);
7306: p_qtev_rec OKL_QTE_PVT.qtev_rec_type;
7307: x_qtev_rec OKL_QTE_PVT.qtev_rec_type;

Line 7361: IF x_return_status = OKC_API.G_RET_STS_SUCCESS THEN

7357: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
7358: 'after call to okl_qte_pvt.update_row :'||x_return_status);
7359: END IF;
7360:
7361: IF x_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7362: IF nvl(l_approved, 'Y') = 'Y' THEN
7363: resultout := 'COMPLETE:SUCCESS';
7364: ELSE
7365: resultout := 'COMPLETE:ERROR';