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 4841: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

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

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

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

Line 4930: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

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

Line 5004: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

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

Line 5024: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

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

Line 5084: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

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

Line 5089: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

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

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

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

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

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

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

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

Line 6013: OKC_API.SET_MESSAGE (

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

Line 6014: p_app_name => OKC_API.G_APP_NAME,

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

Line 6032: OKC_API.SET_MESSAGE (

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

Line 6033: p_app_name => OKC_API.G_APP_NAME,

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

Line 6048: OKC_API.SET_MESSAGE (

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

Line 6049: p_app_name => OKC_API.G_APP_NAME,

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

Line 6083: OKC_API.SET_MESSAGE (

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

Line 6084: p_app_name => OKC_API.G_APP_NAME,

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

Line 6098: OKC_API.SET_MESSAGE (

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

Line 6099: p_app_name => OKC_API.G_APP_NAME,

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

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

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

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

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

Line 7363: IF x_return_status = OKC_API.G_RET_STS_SUCCESS THEN

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