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.OKC_K_REL_OBJS_PUB dependencies on OKC_K_REL_OBJS_PUB

Line 1: PACKAGE BODY OKC_K_REL_OBJS_PUB AS

1: PACKAGE BODY OKC_K_REL_OBJS_PUB AS
2: /* $Header: OKCPCRJB.pls 120.0 2005/05/25 19:31:41 appldev noship $ */
3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4:
5: -- Start of comments

Line 40: okc_util.print_trace(2, '>START - OKC_K_REL_OBJS_PUB.CREATE_K_REL_OBJ -');

36:
37: BEGIN
38: IF (l_debug = 'Y') THEN
39: okc_util.print_trace(2, ' ');
40: okc_util.print_trace(2, '>START - OKC_K_REL_OBJS_PUB.CREATE_K_REL_OBJ -');
41: END IF;
42: l_return_status := OKC_API.START_ACTIVITY
43: (
44: l_api_name

Line 137: OKC_K_REL_OBJS_PUB.create_row

133: WHILE(-- line data exists
134: l_crjv_tbl.EXISTS(i)
135: and x_return_status = OKC_API.G_RET_STS_SUCCESS
136: ) LOOP
137: OKC_K_REL_OBJS_PUB.create_row
138: (
139: p_api_version => l_api_version
140: ,p_init_msg_list => OKC_API.G_FALSE
141: ,x_return_status => x_return_status

Line 166: OKC_K_REL_OBJS_PUB.create_row

162: i:= i + 1;
163: END LOOP;
164:
165: /* loop in pvt insert does not check every record for status so do rows individually as above
166: OKC_K_REL_OBJS_PUB.create_row
167: (
168: p_api_version => l_api_version
169: ,p_init_msg_list => OKC_API.G_FALSE
170: -- ,x_return_status => l_return_status

Line 216: okc_util.print_trace(2, '

212: x_msg_count
213: ,x_msg_data
214: );
215: IF (l_debug = 'Y') THEN
216: okc_util.print_trace(2, ' 217: END IF;
218: EXCEPTION
219: WHEN OKC_API.G_EXCEPTION_ERROR THEN
220: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 297: okc_util.print_trace(1, '>START - OKC_K_REL_OBJS_PUB.CREATE_QUOTE_RENEWS_CONTRACT -');

293:
294: BEGIN
295: IF (l_debug = 'Y') THEN
296: okc_util.print_trace(1, ' ');
297: okc_util.print_trace(1, '>START - OKC_K_REL_OBJS_PUB.CREATE_QUOTE_RENEWS_CONTRACT -');
298: END IF;
299: l_return_status := OKC_API.START_ACTIVITY
300: (
301: substr(l_api_name,1,26)

Line 347: OKC_K_REL_OBJS_PUB.create_k_rel_obj

343: l_crj_rel_hdr_full_rec.chr_id := p_crj_rel_hdr_rec.chr_id;
344: l_crj_rel_hdr_full_rec.object1_id1 := p_crj_rel_hdr_rec.object1_id1;
345: l_crj_rel_hdr_full_rec.object1_id2 := p_crj_rel_hdr_rec.object1_id2;
346:
347: OKC_K_REL_OBJS_PUB.create_k_rel_obj
348: (
349: p_api_version => 1
350: ,p_init_msg_list => OKC_API.G_FALSE
351: ,x_return_status => x_return_status

Line 401: okc_util.print_trace(1, '

397: x_msg_count
398: ,x_msg_data
399: );
400: IF (l_debug = 'Y') THEN
401: okc_util.print_trace(1, ' 402: END IF;
403: EXCEPTION
404: WHEN OKC_API.G_EXCEPTION_ERROR THEN
405: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 538: OKC_K_REL_OBJS_PUB.create_k_rel_obj

534: l_crj_rel_hdr_full_rec.chr_id := p_crj_rel_hdr_rec.chr_id;
535: l_crj_rel_hdr_full_rec.object1_id1 := p_crj_rel_hdr_rec.object1_id1;
536: l_crj_rel_hdr_full_rec.object1_id2 := p_crj_rel_hdr_rec.object1_id2;
537:
538: OKC_K_REL_OBJS_PUB.create_k_rel_obj
539: (
540: p_api_version => 1
541: ,p_init_msg_list => OKC_API.G_FALSE
542: ,x_return_status => x_return_status

Line 677: okc_util.print_trace(1, '>START - OKC_K_REL_OBJS_PUB.CREATE_ORDER_SHIPS_CONTRACT -');

673:
674: BEGIN
675: IF (l_debug = 'Y') THEN
676: okc_util.print_trace(1, ' ');
677: okc_util.print_trace(1, '>START - OKC_K_REL_OBJS_PUB.CREATE_ORDER_SHIPS_CONTRACT -');
678: END IF;
679: l_return_status := OKC_API.START_ACTIVITY
680: (
681: substr(l_api_name,1,26)

Line 727: OKC_K_REL_OBJS_PUB.create_k_rel_obj

723: l_crj_rel_hdr_full_rec.chr_id := p_crj_rel_hdr_rec.chr_id;
724: l_crj_rel_hdr_full_rec.object1_id1 := p_crj_rel_hdr_rec.object1_id1;
725: l_crj_rel_hdr_full_rec.object1_id2 := p_crj_rel_hdr_rec.object1_id2;
726:
727: OKC_K_REL_OBJS_PUB.create_k_rel_obj
728: (
729: p_api_version => 1
730: ,p_init_msg_list => OKC_API.G_FALSE
731: ,x_return_status => x_return_status

Line 781: okc_util.print_trace(1, '

777: x_msg_count
778: ,x_msg_data
779: );
780: IF (l_debug = 'Y') THEN
781: okc_util.print_trace(1, ' 782: END IF;
783: EXCEPTION
784: WHEN OKC_API.G_EXCEPTION_ERROR THEN
785: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 875: okc_util.print_trace(1, '>START - OKC_K_REL_OBJS_PUB.CREATE_CORE_ORDERS_SERVICE -');

871:
872: BEGIN
873: IF (l_debug = 'Y') THEN
874: okc_util.print_trace(1, ' ');
875: okc_util.print_trace(1, '>START - OKC_K_REL_OBJS_PUB.CREATE_CORE_ORDERS_SERVICE -');
876: END IF;
877: l_return_status := OKC_API.START_ACTIVITY
878: (
879: substr(l_api_name,1,26)

Line 931: OKC_K_REL_OBJS_PUB.create_k_rel_obj

927: l_crj_rel_hdr_full_rec.chr_id := p_crj_rel_hdr_rec.chr_id;
928: l_crj_rel_hdr_full_rec.object1_id1 := p_crj_rel_hdr_rec.object1_id1;
929: l_crj_rel_hdr_full_rec.object1_id2 := p_crj_rel_hdr_rec.object1_id2;
930:
931: OKC_K_REL_OBJS_PUB.create_k_rel_obj
932: (
933: p_api_version => 1
934: ,p_init_msg_list => OKC_API.G_FALSE
935: ,x_return_status => x_return_status

Line 985: okc_util.print_trace(1, '

981: x_msg_count
982: ,x_msg_data
983: );
984: IF (l_debug = 'Y') THEN
985: okc_util.print_trace(1, ' 986: END IF;
987: EXCEPTION
988: WHEN OKC_API.G_EXCEPTION_ERROR THEN
989: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1155: OKC_K_REL_OBJS_PUB.create_k_rel_obj

1151: l_crj_rel_hdr_full_rec.chr_id := p_crj_rel_hdr_rec.chr_id;
1152: l_crj_rel_hdr_full_rec.object1_id1 := p_crj_rel_hdr_rec.object1_id1;
1153: l_crj_rel_hdr_full_rec.object1_id2 := p_crj_rel_hdr_rec.object1_id2;
1154:
1155: OKC_K_REL_OBJS_PUB.create_k_rel_obj
1156: (
1157: p_api_version => 1
1158: ,p_init_msg_list => OKC_API.G_FALSE
1159: ,x_return_status => x_return_status

Line 1326: OKC_K_REL_OBJS_PUB.create_k_rel_obj

1322: l_crj_rel_hdr_full_rec.chr_id := p_crj_rel_hdr_rec.chr_id;
1323: l_crj_rel_hdr_full_rec.object1_id1 := p_crj_rel_hdr_rec.object1_id1;
1324: l_crj_rel_hdr_full_rec.object1_id2 := p_crj_rel_hdr_rec.object1_id2;
1325:
1326: OKC_K_REL_OBJS_PUB.create_k_rel_obj
1327: (
1328: p_api_version => 1
1329: ,p_init_msg_list => OKC_API.G_FALSE
1330: ,x_return_status => x_return_status

Line 1470: okc_util.print_trace(1, '>START - OKC_K_REL_OBJS_PUB.CREATE_QUOTE_SUBJECT_CONTRACT -');

1466:
1467: BEGIN
1468: IF (l_debug = 'Y') THEN
1469: okc_util.print_trace(1, ' ');
1470: okc_util.print_trace(1, '>START - OKC_K_REL_OBJS_PUB.CREATE_QUOTE_SUBJECT_CONTRACT -');
1471: END IF;
1472: l_return_status := OKC_API.START_ACTIVITY
1473: (
1474: substr(l_api_name,1,26)

Line 1520: OKC_K_REL_OBJS_PUB.create_k_rel_obj

1516: l_crj_rel_hdr_full_rec.chr_id := p_crj_rel_hdr_rec.chr_id;
1517: l_crj_rel_hdr_full_rec.object1_id1 := p_crj_rel_hdr_rec.object1_id1;
1518: l_crj_rel_hdr_full_rec.object1_id2 := p_crj_rel_hdr_rec.object1_id2;
1519:
1520: OKC_K_REL_OBJS_PUB.create_k_rel_obj
1521: (
1522: p_api_version => 1
1523: ,p_init_msg_list => OKC_API.G_FALSE
1524: ,x_return_status => x_return_status

Line 1574: okc_util.print_trace(1, '

1570: x_msg_count
1571: ,x_msg_data
1572: );
1573: IF (l_debug = 'Y') THEN
1574: okc_util.print_trace(1, ' 1575: END IF;
1576: EXCEPTION
1577: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1578: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1712: OKC_K_REL_OBJS_PUB.create_k_rel_obj

1708: l_crj_rel_hdr_full_rec.chr_id := p_crj_rel_hdr_rec.chr_id;
1709: l_crj_rel_hdr_full_rec.object1_id1 := p_crj_rel_hdr_rec.object1_id1;
1710: l_crj_rel_hdr_full_rec.object1_id2 := p_crj_rel_hdr_rec.object1_id2;
1711:
1712: OKC_K_REL_OBJS_PUB.create_k_rel_obj
1713: (
1714: p_api_version => 1
1715: ,p_init_msg_list => OKC_API.G_FALSE
1716: ,x_return_status => x_return_status

Line 1902: OKC_K_REL_OBJS_PUB.create_k_rel_obj

1898: l_crj_rel_hdr_full_rec.chr_id := p_crj_rel_hdr_rec.chr_id;
1899: l_crj_rel_hdr_full_rec.object1_id1 := p_crj_rel_hdr_rec.object1_id1;
1900: l_crj_rel_hdr_full_rec.object1_id2 := p_crj_rel_hdr_rec.object1_id2;
1901:
1902: OKC_K_REL_OBJS_PUB.create_k_rel_obj
1903: (
1904: p_api_version => 1
1905: ,p_init_msg_list => OKC_API.G_FALSE
1906: ,x_return_status => x_return_status

Line 2026: okc_util.print_trace(3, '>START - OKC_K_REL_OBJS_PUB.CREATE_ROW -');

2022: -----------------------------------------
2023: BEGIN
2024: IF (l_debug = 'Y') THEN
2025: okc_util.print_trace(3, ' ');
2026: okc_util.print_trace(3, '>START - OKC_K_REL_OBJS_PUB.CREATE_ROW -');
2027: END IF;
2028: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2029: G_PKG_NAME,
2030: p_init_msg_list,

Line 2064: okc_util.print_trace(3, '

2060: RAISE OKC_API.G_EXCEPTION_ERROR;
2061: END IF;
2062: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2063: IF (l_debug = 'Y') THEN
2064: okc_util.print_trace(3, ' 2065: END IF;
2066: EXCEPTION
2067: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2068: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3628: END OKC_K_REL_OBJS_PUB;

3624: ,l_api_name
3625: );
3626: end quote_contract_is_ordered;
3627:
3628: END OKC_K_REL_OBJS_PUB;