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_PARTIES_PVT dependencies on OKL_AM_UTIL_PVT

Line 156: okl_am_util_pvt.get_rule_record (

152: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_rdf_code :'||p_rdf_code);
153: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_qpt_code :'||p_qpt_code);
154: END IF;
155:
156: okl_am_util_pvt.get_rule_record (
157: p_rgd_code => p_rgd_code,
158: p_rdf_code => p_rdf_code,
159: p_chr_id => p_rule_chr_id,
160: p_cle_id => NULL,

Line 167: 'after call to okl_am_util_pvt.get_rule_record :'||l_return_status);

163: p_message_yn => FALSE);
164:
165: IF (is_debug_statement_on) THEN
166: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
167: 'after call to okl_am_util_pvt.get_rule_record :'||l_return_status);
168: END IF;
169:
170: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
171: IF l_rulv_rec.rule_information1 IS NOT NULL

Line 315: l_rule_chr_id := okl_am_util_pvt.get_rule_chr_id (p_qtev_rec);

311: p_token2_value => 'GET_RULE_QUOTE_PARTIES');
312:
313: END IF;
314:
315: l_rule_chr_id := okl_am_util_pvt.get_rule_chr_id (p_qtev_rec);
316:
317: IF p_qtev_rec.qtp_code LIKE 'TER_RECOURSE%' THEN
318: l_recipient_rg := 'AVQR1R';
319: l_approver_rg := 'AVQR5A';

Line 352: okl_am_util_pvt.set_message (

348: END IF;
349:
350: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
351: OR l_qpyv_tbl.COUNT = 0 THEN
352: okl_am_util_pvt.set_message (
353: p_app_name => G_APP_NAME
354: ,p_msg_name => 'OKL_AM_QTE_RECIPIENT_NOT_FOUND'
355: ,p_token1 => 'QUOTE_PARTY_TYPE'
356: ,p_token1_value => 'RECIPIENT');

Line 469: l_object_tbl okl_am_util_pvt.jtf_object_tbl_type;

465: x_q_party_uv_tbl OUT NOCOPY q_party_uv_tbl_type,
466: x_record_count OUT NOCOPY NUMBER) IS
467:
468: l_q_party_tbl q_party_uv_tbl_type;
469: l_object_tbl okl_am_util_pvt.jtf_object_tbl_type;
470: l_qpyv_tbl qpyv_tbl_type;
471: l_cnt NUMBER := 0;
472:
473: CURSOR l_q_party_role_csr (

Line 613: okl_am_util_pvt.get_object_details (

609:
610: IF l_q_role_rec.kp_role_code IS NOT NULL THEN
611:
612: -- Get Party Object
613: okl_am_util_pvt.get_object_details (
614: p_object_code => l_qpyv_tbl(i).party_jtot_object1_code,
615: p_object_id1 => l_qpyv_tbl(i).party_object1_id1,
616: p_object_id2 => l_qpyv_tbl(i).party_object1_id2,
617: x_object_tbl => l_object_tbl,

Line 622: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);

618: x_return_status => l_return_status);
619:
620: IF (is_debug_statement_on) THEN
621: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
622: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);
623: END IF;
624:
625: IF l_return_status = OKL_API.G_RET_STS_SUCCESS
626: AND l_object_tbl.COUNT > 0 THEN

Line 901: okl_am_util_pvt.set_message(

897: p_token1 => G_COL_NAME_TOKEN,
898: p_token1_value => 'Contract Id');
899: ELSIF l_partner_rec.par_id IS NULL THEN
900: l_return_status := OKL_API.G_RET_STS_ERROR;
901: okl_am_util_pvt.set_message(
902: p_app_name => G_APP_NAME
903: ,p_msg_name => 'OKL_VP_INVALID_PARENT_AGRMNT');
904: ELSIF l_partner_rec.kpr_id IS NULL THEN
905: l_overall_status := OKL_API.G_RET_STS_ERROR;

Line 1303: l_party_name := okl_am_util_pvt.get_jtf_object_name (

1299: -- Only Lessee and Vendor have setup for billing rules
1300: IF l_k_role_rec.rle_code NOT IN ('OKL_VENDOR','LESSEE') THEN
1301:
1302: l_overall_status := OKL_API.G_RET_STS_ERROR;
1303: l_party_name := okl_am_util_pvt.get_jtf_object_name (
1304: l_k_role_rec.object1_code,
1305: l_k_role_rec.object1_id1,
1306: l_k_role_rec.object1_id2);
1307: OKC_API.SET_MESSAGE (

Line 1410: okl_am_util_pvt.set_message (

1406: l_return_status := OKL_API.G_RET_STS_ERROR;
1407: -- Only display message if user-defined parties
1408: -- Rule-defined parties have its own message
1409: IF p_qpyv_tbl.COUNT > 0 THEN
1410: okl_am_util_pvt.set_message (
1411: p_app_name => G_APP_NAME
1412: ,p_msg_name => 'OKL_AM_QTE_RECIPIENT_NOT_FOUND'
1413: ,p_token1 => 'QUOTE_PARTY_TYPE'
1414: ,p_token1_value => 'RECIPIENT');

Line 1552: l_object_tbl okl_am_util_pvt.jtf_object_tbl_type;

1548: x_q_party_uv_tbl OUT NOCOPY q_party_uv_tbl_type,
1549: x_record_count OUT NOCOPY NUMBER) IS
1550:
1551: l_q_party_tbl q_party_uv_tbl_type;
1552: l_object_tbl okl_am_util_pvt.jtf_object_tbl_type;
1553: l_cnt NUMBER := 0;
1554: l_quote_id NUMBER;
1555:
1556: --PAGARG 4299668 Modify the curosr to restrict the records for a given party if

Line 1716: okl_am_util_pvt.get_object_details (

1712: --pagarg 4299668 pass party id also to the quote party role cursor
1713: FOR l_q_role_rec IN l_q_party_role_csr (l_quote_id, l_qpt_code, l_party_id) LOOP
1714: IF l_q_role_rec.kp_party_id IS NOT NULL THEN
1715: -- Get Contract Party Object
1716: okl_am_util_pvt.get_object_details (
1717: p_object_code => l_q_role_rec.po_party_object,
1718: p_object_id1 => l_q_role_rec.po_party_id1,
1719: p_object_id2 => l_q_role_rec.po_party_id2,
1720: x_object_tbl => l_object_tbl,

Line 1725: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);

1721: x_return_status => l_return_status);
1722:
1723: IF (is_debug_statement_on) THEN
1724: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1725: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);
1726: END IF;
1727:
1728: ELSE
1729: -- Get Quote Party Object

Line 1730: okl_am_util_pvt.get_object_details (

1726: END IF;
1727:
1728: ELSE
1729: -- Get Quote Party Object
1730: okl_am_util_pvt.get_object_details (
1731: p_object_code => l_q_role_rec.qp_party_object,
1732: p_object_id1 => l_q_role_rec.qp_party_id1,
1733: p_object_id2 => l_q_role_rec.qp_party_id2,
1734: x_object_tbl => l_object_tbl,

Line 1739: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);

1735: x_return_status => l_return_status);
1736:
1737: IF (is_debug_statement_on) THEN
1738: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1739: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);
1740: END IF;
1741:
1742: END IF;
1743:

Line 1885: l_object_tbl okl_am_util_pvt.jtf_object_tbl_type;

1881: l_q_party_tbl q_party_uv_tbl_type;
1882: l_temp_q_party_tbl q_party_uv_tbl_type;
1883: l_curr_qp_rec q_party_uv_rec_type;
1884:
1885: l_object_tbl okl_am_util_pvt.jtf_object_tbl_type;
1886: l_t_object_tbl okl_am_util_pvt.jtf_object_tbl_type;
1887: l_where_cond okl_am_util_pvt.where_tbl_type;
1888: l_other_cols okl_am_util_pvt.select_tbl_type;
1889:

Line 1886: l_t_object_tbl okl_am_util_pvt.jtf_object_tbl_type;

1882: l_temp_q_party_tbl q_party_uv_tbl_type;
1883: l_curr_qp_rec q_party_uv_rec_type;
1884:
1885: l_object_tbl okl_am_util_pvt.jtf_object_tbl_type;
1886: l_t_object_tbl okl_am_util_pvt.jtf_object_tbl_type;
1887: l_where_cond okl_am_util_pvt.where_tbl_type;
1888: l_other_cols okl_am_util_pvt.select_tbl_type;
1889:
1890: l_cnt NUMBER := 0;

Line 1887: l_where_cond okl_am_util_pvt.where_tbl_type;

1883: l_curr_qp_rec q_party_uv_rec_type;
1884:
1885: l_object_tbl okl_am_util_pvt.jtf_object_tbl_type;
1886: l_t_object_tbl okl_am_util_pvt.jtf_object_tbl_type;
1887: l_where_cond okl_am_util_pvt.where_tbl_type;
1888: l_other_cols okl_am_util_pvt.select_tbl_type;
1889:
1890: l_cnt NUMBER := 0;
1891: l_obj NUMBER;

Line 1888: l_other_cols okl_am_util_pvt.select_tbl_type;

1884:
1885: l_object_tbl okl_am_util_pvt.jtf_object_tbl_type;
1886: l_t_object_tbl okl_am_util_pvt.jtf_object_tbl_type;
1887: l_where_cond okl_am_util_pvt.where_tbl_type;
1888: l_other_cols okl_am_util_pvt.select_tbl_type;
1889:
1890: l_cnt NUMBER := 0;
1891: l_obj NUMBER;
1892: l_quote_id NUMBER;

Line 2106: okl_am_util_pvt.get_object_details (

2102: -- Get Contact Object from TCA (Quote Contact)
2103: -- *******************************************
2104:
2105: -- Get all contacts for a quote
2106: okl_am_util_pvt.get_object_details (
2107: p_object_code => l_curr_qp_rec.co_contact_object,
2108: p_object_id1 => l_curr_qp_rec.co_contact_id1,
2109: p_object_id2 => l_curr_qp_rec.co_contact_id2,
2110: p_other_select => l_other_cols,

Line 2116: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);

2112: x_return_status => l_return_status);
2113:
2114: IF (is_debug_statement_on) THEN
2115: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2116: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);
2117: END IF;
2118:
2119: ELSIF l_contact_source_count <> 0 THEN
2120:

Line 2136: 'before call to okl_am_util_pvt.get_object_details :'||l_return_status);

2132: LOOP
2133:
2134: IF (is_debug_statement_on) THEN
2135: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2136: 'before call to okl_am_util_pvt.get_object_details :'||l_return_status);
2137: END IF;
2138: -- Get Contact Object
2139: okl_am_util_pvt.get_object_details (
2140: p_object_code => l_cntct_rec.jtot_object1_code,

Line 2139: okl_am_util_pvt.get_object_details (

2135: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2136: 'before call to okl_am_util_pvt.get_object_details :'||l_return_status);
2137: END IF;
2138: -- Get Contact Object
2139: okl_am_util_pvt.get_object_details (
2140: p_object_code => l_cntct_rec.jtot_object1_code,
2141: p_other_select => l_other_cols,
2142: p_object_id1 => l_cntct_rec.object1_id1,
2143: p_object_id2 => l_cntct_rec.object1_id2,

Line 2149: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);

2145: x_return_status => l_return_status);
2146:
2147: IF (is_debug_statement_on) THEN
2148: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2149: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);
2150: END IF;
2151:
2152: FOR l_ind3 IN l_t_object_tbl.FIRST..l_t_object_tbl.LAST LOOP
2153: l_obj := l_obj + 1;

Line 2170: 'before call to okl_am_util_pvt.get_object_details :'||l_return_status);

2166: l_where_cond(2).condition_value := l_curr_qp_rec.po_party_id2;
2167:
2168: IF (is_debug_statement_on) THEN
2169: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2170: 'before call to okl_am_util_pvt.get_object_details :'||l_return_status);
2171: END IF;
2172:
2173: -- Get all contacts for a party
2174: okl_am_util_pvt.get_object_details (

Line 2174: okl_am_util_pvt.get_object_details (

2170: 'before call to okl_am_util_pvt.get_object_details :'||l_return_status);
2171: END IF;
2172:
2173: -- Get all contacts for a party
2174: okl_am_util_pvt.get_object_details (
2175: p_object_code => l_contact_object,
2176: p_other_select => l_other_cols,
2177: p_other_where => l_where_cond,
2178: p_check_status => 'Y',

Line 2184: 'before call to okl_am_util_pvt.get_object_details :'||l_return_status);

2180: x_return_status => l_return_status);
2181:
2182: IF (is_debug_statement_on) THEN
2183: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2184: 'before call to okl_am_util_pvt.get_object_details :'||l_return_status);
2185: END IF;
2186:
2187: END IF;
2188:

Line 2672: l_obj1 okl_am_util_pvt.jtf_object_tbl_type;

2668: l_added_yn2 BOOLEAN;
2669: l_pos NUMBER;
2670:
2671: l_party_tbl party_object_tbl_type;
2672: l_obj1 okl_am_util_pvt.jtf_object_tbl_type;
2673: l_obj2 okl_am_util_pvt.jtf_object_tbl_type;
2674: l_obj3 okl_am_util_pvt.jtf_object_tbl_type;
2675: l_other_cols okl_am_util_pvt.select_tbl_type;
2676: l_where_cond okl_am_util_pvt.where_tbl_type;

Line 2673: l_obj2 okl_am_util_pvt.jtf_object_tbl_type;

2669: l_pos NUMBER;
2670:
2671: l_party_tbl party_object_tbl_type;
2672: l_obj1 okl_am_util_pvt.jtf_object_tbl_type;
2673: l_obj2 okl_am_util_pvt.jtf_object_tbl_type;
2674: l_obj3 okl_am_util_pvt.jtf_object_tbl_type;
2675: l_other_cols okl_am_util_pvt.select_tbl_type;
2676: l_where_cond okl_am_util_pvt.where_tbl_type;
2677:

Line 2674: l_obj3 okl_am_util_pvt.jtf_object_tbl_type;

2670:
2671: l_party_tbl party_object_tbl_type;
2672: l_obj1 okl_am_util_pvt.jtf_object_tbl_type;
2673: l_obj2 okl_am_util_pvt.jtf_object_tbl_type;
2674: l_obj3 okl_am_util_pvt.jtf_object_tbl_type;
2675: l_other_cols okl_am_util_pvt.select_tbl_type;
2676: l_where_cond okl_am_util_pvt.where_tbl_type;
2677:
2678: CURSOR l_c_points_csr (cp_object_id VARCHAR2) IS

Line 2675: l_other_cols okl_am_util_pvt.select_tbl_type;

2671: l_party_tbl party_object_tbl_type;
2672: l_obj1 okl_am_util_pvt.jtf_object_tbl_type;
2673: l_obj2 okl_am_util_pvt.jtf_object_tbl_type;
2674: l_obj3 okl_am_util_pvt.jtf_object_tbl_type;
2675: l_other_cols okl_am_util_pvt.select_tbl_type;
2676: l_where_cond okl_am_util_pvt.where_tbl_type;
2677:
2678: CURSOR l_c_points_csr (cp_object_id VARCHAR2) IS
2679: SELECT c.contact_point_id,

Line 2676: l_where_cond okl_am_util_pvt.where_tbl_type;

2672: l_obj1 okl_am_util_pvt.jtf_object_tbl_type;
2673: l_obj2 okl_am_util_pvt.jtf_object_tbl_type;
2674: l_obj3 okl_am_util_pvt.jtf_object_tbl_type;
2675: l_other_cols okl_am_util_pvt.select_tbl_type;
2676: l_where_cond okl_am_util_pvt.where_tbl_type;
2677:
2678: CURSOR l_c_points_csr (cp_object_id VARCHAR2) IS
2679: SELECT c.contact_point_id,
2680: c.email_address,

Line 2760: okl_am_util_pvt.get_object_details (

2756: l_other_cols(2) := 'PERSON_ID';
2757:
2758: FOR l_chr_c_rec IN l_chr_contacts_csr (p_id_value) LOOP
2759:
2760: okl_am_util_pvt.get_object_details (
2761: p_object_code => l_chr_c_rec.jtot_object1_code,
2762: p_object_id1 => l_chr_c_rec.object1_id1,
2763: p_object_id2 => l_chr_c_rec.object1_id2,
2764: p_other_select => l_other_cols,

Line 2771: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);

2767:
2768:
2769: IF (is_debug_statement_on) THEN
2770: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2771: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);
2772: END IF;
2773:
2774: IF l_return_status = OKL_API.G_RET_STS_SUCCESS
2775: AND l_obj1.COUNT > 0 THEN

Line 2778: l_pos := Instr (l_obj1(l_ind).other_values, okl_am_util_pvt.G_DELIM);

2774: IF l_return_status = OKL_API.G_RET_STS_SUCCESS
2775: AND l_obj1.COUNT > 0 THEN
2776: FOR l_ind IN l_obj1.FIRST..l_obj1.LAST LOOP
2777: l_cnt := l_cnt + 1;
2778: l_pos := Instr (l_obj1(l_ind).other_values, okl_am_util_pvt.G_DELIM);
2779: l_party_tbl(l_cnt).c_code := l_obj1(l_ind).object_code;
2780: l_party_tbl(l_cnt).c_id1 := l_obj1(l_ind).id1;
2781: l_party_tbl(l_cnt).c_id2 := l_obj1(l_ind).id2;
2782: l_party_tbl(l_cnt).c_name := l_obj1(l_ind).name;

Line 2797: okl_am_util_pvt.get_object_details (

2793: ELSIF l_id_code = 'PC' THEN
2794:
2795: l_other_cols(1) := 'EMAIL_ADDRESS';
2796:
2797: okl_am_util_pvt.get_object_details (
2798: p_object_code => l_code1,
2799: p_object_id1 => p_id_value,
2800: p_other_select => l_other_cols,
2801: x_object_tbl => l_obj1,

Line 2806: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);

2802: x_return_status => l_return_status);
2803:
2804: IF (is_debug_statement_on) THEN
2805: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2806: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);
2807: END IF;
2808:
2809: IF l_return_status = OKL_API.G_RET_STS_SUCCESS
2810: AND l_obj1.COUNT > 0 THEN

Line 2845: okl_am_util_pvt.get_object_details (

2841: END IF;
2842:
2843: ELSIF l_id_code = 'P' THEN
2844:
2845: okl_am_util_pvt.get_object_details (
2846: p_object_code => l_code1,
2847: p_object_id1 => p_id_value,
2848: x_object_tbl => l_obj1,
2849: x_return_status => l_return_status);

Line 2853: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);

2849: x_return_status => l_return_status);
2850:
2851: IF (is_debug_statement_on) THEN
2852: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2853: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);
2854: END IF;
2855:
2856: IF l_return_status = OKL_API.G_RET_STS_SUCCESS
2857: AND l_obj1.COUNT > 0 THEN

Line 2868: okl_am_util_pvt.get_object_details (

2864: l_where_cond(2).column_name := 'PARTY_ID2';
2865: l_where_cond(1).condition_value := l_obj1(l_ind1).id1;
2866: l_where_cond(2).condition_value := l_obj1(l_ind1).id2;
2867:
2868: okl_am_util_pvt.get_object_details (
2869: p_object_code => l_code2,
2870: p_other_select => l_other_cols,
2871: p_other_where => l_where_cond,
2872: p_check_status => 'Y',

Line 2878: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);

2874: x_return_status => l_return_status);
2875:
2876: IF (is_debug_statement_on) THEN
2877: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2878: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);
2879: END IF;
2880:
2881: IF l_return_status = OKL_API.G_RET_STS_SUCCESS
2882: AND l_obj2.COUNT > 0 THEN

Line 2958: okl_am_util_pvt.get_object_details (

2954: ELSIF l_id_code = 'VC' THEN
2955:
2956: l_other_cols(1) := 'EMAIL_ADDRESS';
2957:
2958: okl_am_util_pvt.get_object_details (
2959: p_object_code => l_code1,
2960: p_object_id1 => p_id_value,
2961: p_other_select => l_other_cols,
2962: x_object_tbl => l_obj1,

Line 2967: 'after call to okl_am_util_pvt.get_object_details in VC :'||l_return_status);

2963: x_return_status => l_return_status);
2964:
2965: IF (is_debug_statement_on) THEN
2966: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2967: 'after call to okl_am_util_pvt.get_object_details in VC :'||l_return_status);
2968: END IF;
2969:
2970: IF l_return_status = OKL_API.G_RET_STS_SUCCESS
2971: AND l_obj1.COUNT > 0 THEN

Line 2985: okl_am_util_pvt.get_object_details (

2981: END IF;
2982:
2983: ELSIF l_id_code = 'VS' THEN
2984:
2985: okl_am_util_pvt.get_object_details (
2986: p_object_code => l_code1,
2987: p_object_id1 => p_id_value,
2988: x_object_tbl => l_obj1,
2989: x_return_status => l_return_status);

Line 2993: 'after call to okl_am_util_pvt.get_object_details in VS :'||l_return_status);

2989: x_return_status => l_return_status);
2990:
2991: IF (is_debug_statement_on) THEN
2992: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2993: 'after call to okl_am_util_pvt.get_object_details in VS :'||l_return_status);
2994: END IF;
2995:
2996: IF l_return_status = OKL_API.G_RET_STS_SUCCESS
2997: AND l_obj1.COUNT > 0 THEN

Line 3005: okl_am_util_pvt.get_object_details (

3001: l_other_cols(1) := 'EMAIL_ADDRESS';
3002: l_where_cond(1).column_name := 'VENDOR_SITE_ID';
3003: l_where_cond(1).condition_value := l_obj1(l_ind1).id1;
3004:
3005: okl_am_util_pvt.get_object_details (
3006: p_object_code => l_code2,
3007: p_other_select => l_other_cols,
3008: p_other_where => l_where_cond,
3009: p_check_status => 'Y',

Line 3015: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);

3011: x_return_status => l_return_status);
3012:
3013: IF (is_debug_statement_on) THEN
3014: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3015: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);
3016: END IF;
3017:
3018:
3019: IF l_return_status = OKL_API.G_RET_STS_SUCCESS

Line 3050: okl_am_util_pvt.get_object_details (

3046: END IF;
3047:
3048: ELSIF l_id_code = 'V' THEN
3049:
3050: okl_am_util_pvt.get_object_details (
3051: p_object_code => l_code1,
3052: p_object_id1 => p_id_value,
3053: x_object_tbl => l_obj1,
3054: x_return_status => l_return_status);

Line 3058: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);

3054: x_return_status => l_return_status);
3055:
3056: IF (is_debug_statement_on) THEN
3057: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3058: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);
3059: END IF;
3060:
3061:
3062: IF l_return_status = OKL_API.G_RET_STS_SUCCESS

Line 3070: okl_am_util_pvt.get_object_details (

3066:
3067: l_where_cond(1).column_name := 'VENDOR_ID';
3068: l_where_cond(1).condition_value := l_obj1(l_ind1).id1;
3069:
3070: okl_am_util_pvt.get_object_details (
3071: p_object_code => l_code2,
3072: p_other_where => l_where_cond,
3073: p_check_status => 'Y',
3074: x_object_tbl => l_obj2,

Line 3079: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);

3075: x_return_status => l_return_status);
3076:
3077: IF (is_debug_statement_on) THEN
3078: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3079: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);
3080: END IF;
3081:
3082:
3083: IF l_return_status = OKL_API.G_RET_STS_SUCCESS

Line 3092: okl_am_util_pvt.get_object_details (

3088: l_other_cols(1) := 'EMAIL_ADDRESS';
3089: l_where_cond(1).column_name := 'VENDOR_SITE_ID';
3090: l_where_cond(1).condition_value := l_obj2(l_ind2).id1;
3091:
3092: okl_am_util_pvt.get_object_details (
3093: p_object_code => l_code3,
3094: p_other_select => l_other_cols,
3095: p_other_where => l_where_cond,
3096: p_check_status => 'Y',

Line 3102: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);

3098: x_return_status => l_return_status);
3099:
3100: IF (is_debug_statement_on) THEN
3101: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3102: 'after call to okl_am_util_pvt.get_object_details :'||l_return_status);
3103: END IF;
3104:
3105: IF l_return_status = OKL_API.G_RET_STS_SUCCESS
3106: AND l_obj3.COUNT > 0 THEN