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_CRJ_PVT dependencies on OKC_UTIL

Line 709: x_return_status := OKC_UTIL.check_lookup_code

705: raise g_exception_halt_validation;
706: END IF;
707: END IF;
708: */
709: x_return_status := OKC_UTIL.check_lookup_code
710: (
711: 'OKC_REL_OBJ'
712: ,p_crjv_rec.rty_code
713: );

Line 1629: okc_util.print_trace(5, ' ');

1625: RETURN(l_return_status);
1626: END Set_Attributes;
1627: BEGIN
1628: IF (l_debug = 'Y') THEN
1629: okc_util.print_trace(5, ' ');
1630: okc_util.print_trace(5, '>START - OKC_CRJ_PVT.INSERT_ROW -');
1631: END IF;
1632: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1633: p_init_msg_list,

Line 1630: okc_util.print_trace(5, '>START - OKC_CRJ_PVT.INSERT_ROW -');

1626: END Set_Attributes;
1627: BEGIN
1628: IF (l_debug = 'Y') THEN
1629: okc_util.print_trace(5, ' ');
1630: okc_util.print_trace(5, '>START - OKC_CRJ_PVT.INSERT_ROW -');
1631: END IF;
1632: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1633: p_init_msg_list,
1634: '_PVT',

Line 1713: okc_util.print_trace(5, 'Insertion into OKC_K_REL_OBJS:');

1709: l_crj_rec.attribute13,
1710: l_crj_rec.attribute14,
1711: l_crj_rec.attribute15);
1712: IF (l_debug = 'Y') THEN
1713: okc_util.print_trace(5, 'Insertion into OKC_K_REL_OBJS:');
1714: okc_util.print_trace(5, '==============================');
1715: okc_util.print_trace(6, 'Id = '||l_crj_rec.id);
1716: okc_util.print_trace(6, 'Contract Id = '||l_crj_rec.chr_id);
1717: okc_util.print_trace(6, 'Contract Line Id = '||l_crj_rec.cle_id);

Line 1714: okc_util.print_trace(5, '==============================');

1710: l_crj_rec.attribute14,
1711: l_crj_rec.attribute15);
1712: IF (l_debug = 'Y') THEN
1713: okc_util.print_trace(5, 'Insertion into OKC_K_REL_OBJS:');
1714: okc_util.print_trace(5, '==============================');
1715: okc_util.print_trace(6, 'Id = '||l_crj_rec.id);
1716: okc_util.print_trace(6, 'Contract Id = '||l_crj_rec.chr_id);
1717: okc_util.print_trace(6, 'Contract Line Id = '||l_crj_rec.cle_id);
1718: okc_util.print_trace(6, 'Relation type = '||l_crj_rec.rty_code);

Line 1715: okc_util.print_trace(6, 'Id = '||l_crj_rec.id);

1711: l_crj_rec.attribute15);
1712: IF (l_debug = 'Y') THEN
1713: okc_util.print_trace(5, 'Insertion into OKC_K_REL_OBJS:');
1714: okc_util.print_trace(5, '==============================');
1715: okc_util.print_trace(6, 'Id = '||l_crj_rec.id);
1716: okc_util.print_trace(6, 'Contract Id = '||l_crj_rec.chr_id);
1717: okc_util.print_trace(6, 'Contract Line Id = '||l_crj_rec.cle_id);
1718: okc_util.print_trace(6, 'Relation type = '||l_crj_rec.rty_code);
1719: okc_util.print_trace(6, 'Quote object = '||l_crj_rec.jtot_object1_code);

Line 1716: okc_util.print_trace(6, 'Contract Id = '||l_crj_rec.chr_id);

1712: IF (l_debug = 'Y') THEN
1713: okc_util.print_trace(5, 'Insertion into OKC_K_REL_OBJS:');
1714: okc_util.print_trace(5, '==============================');
1715: okc_util.print_trace(6, 'Id = '||l_crj_rec.id);
1716: okc_util.print_trace(6, 'Contract Id = '||l_crj_rec.chr_id);
1717: okc_util.print_trace(6, 'Contract Line Id = '||l_crj_rec.cle_id);
1718: okc_util.print_trace(6, 'Relation type = '||l_crj_rec.rty_code);
1719: okc_util.print_trace(6, 'Quote object = '||l_crj_rec.jtot_object1_code);
1720: END IF;

Line 1717: okc_util.print_trace(6, 'Contract Line Id = '||l_crj_rec.cle_id);

1713: okc_util.print_trace(5, 'Insertion into OKC_K_REL_OBJS:');
1714: okc_util.print_trace(5, '==============================');
1715: okc_util.print_trace(6, 'Id = '||l_crj_rec.id);
1716: okc_util.print_trace(6, 'Contract Id = '||l_crj_rec.chr_id);
1717: okc_util.print_trace(6, 'Contract Line Id = '||l_crj_rec.cle_id);
1718: okc_util.print_trace(6, 'Relation type = '||l_crj_rec.rty_code);
1719: okc_util.print_trace(6, 'Quote object = '||l_crj_rec.jtot_object1_code);
1720: END IF;
1721: IF l_crj_rec.jtot_object1_code = 'OKX_QUOTEHEAD' THEN

Line 1718: okc_util.print_trace(6, 'Relation type = '||l_crj_rec.rty_code);

1714: okc_util.print_trace(5, '==============================');
1715: okc_util.print_trace(6, 'Id = '||l_crj_rec.id);
1716: okc_util.print_trace(6, 'Contract Id = '||l_crj_rec.chr_id);
1717: okc_util.print_trace(6, 'Contract Line Id = '||l_crj_rec.cle_id);
1718: okc_util.print_trace(6, 'Relation type = '||l_crj_rec.rty_code);
1719: okc_util.print_trace(6, 'Quote object = '||l_crj_rec.jtot_object1_code);
1720: END IF;
1721: IF l_crj_rec.jtot_object1_code = 'OKX_QUOTEHEAD' THEN
1722: IF (l_debug = 'Y') THEN

Line 1719: okc_util.print_trace(6, 'Quote object = '||l_crj_rec.jtot_object1_code);

1715: okc_util.print_trace(6, 'Id = '||l_crj_rec.id);
1716: okc_util.print_trace(6, 'Contract Id = '||l_crj_rec.chr_id);
1717: okc_util.print_trace(6, 'Contract Line Id = '||l_crj_rec.cle_id);
1718: okc_util.print_trace(6, 'Relation type = '||l_crj_rec.rty_code);
1719: okc_util.print_trace(6, 'Quote object = '||l_crj_rec.jtot_object1_code);
1720: END IF;
1721: IF l_crj_rec.jtot_object1_code = 'OKX_QUOTEHEAD' THEN
1722: IF (l_debug = 'Y') THEN
1723: okc_util.print_trace(6, 'Quote id1 = '||l_crj_rec.object1_id1);

Line 1723: okc_util.print_trace(6, 'Quote id1 = '||l_crj_rec.object1_id1);

1719: okc_util.print_trace(6, 'Quote object = '||l_crj_rec.jtot_object1_code);
1720: END IF;
1721: IF l_crj_rec.jtot_object1_code = 'OKX_QUOTEHEAD' THEN
1722: IF (l_debug = 'Y') THEN
1723: okc_util.print_trace(6, 'Quote id1 = '||l_crj_rec.object1_id1);
1724: okc_util.print_trace(6, 'Quote id2 = '||l_crj_rec.object1_id2);
1725: END IF;
1726: ELSE
1727: IF (l_debug = 'Y') THEN

Line 1724: okc_util.print_trace(6, 'Quote id2 = '||l_crj_rec.object1_id2);

1720: END IF;
1721: IF l_crj_rec.jtot_object1_code = 'OKX_QUOTEHEAD' THEN
1722: IF (l_debug = 'Y') THEN
1723: okc_util.print_trace(6, 'Quote id1 = '||l_crj_rec.object1_id1);
1724: okc_util.print_trace(6, 'Quote id2 = '||l_crj_rec.object1_id2);
1725: END IF;
1726: ELSE
1727: IF (l_debug = 'Y') THEN
1728: okc_util.print_trace(6, 'Quote Line id1 = '||l_crj_rec.object1_id1);

Line 1728: okc_util.print_trace(6, 'Quote Line id1 = '||l_crj_rec.object1_id1);

1724: okc_util.print_trace(6, 'Quote id2 = '||l_crj_rec.object1_id2);
1725: END IF;
1726: ELSE
1727: IF (l_debug = 'Y') THEN
1728: okc_util.print_trace(6, 'Quote Line id1 = '||l_crj_rec.object1_id1);
1729: okc_util.print_trace(6, 'Quote Line id2 = '||l_crj_rec.object1_id2);
1730: END IF;
1731: END IF;
1732:

Line 1729: okc_util.print_trace(6, 'Quote Line id2 = '||l_crj_rec.object1_id2);

1725: END IF;
1726: ELSE
1727: IF (l_debug = 'Y') THEN
1728: okc_util.print_trace(6, 'Quote Line id1 = '||l_crj_rec.object1_id1);
1729: okc_util.print_trace(6, 'Quote Line id2 = '||l_crj_rec.object1_id2);
1730: END IF;
1731: END IF;
1732:
1733: -- Set OUT values

Line 1737: okc_util.print_trace(5, '

1733: -- Set OUT values
1734: x_crj_rec := l_crj_rec;
1735: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1736: IF (l_debug = 'Y') THEN
1737: okc_util.print_trace(5, ' 1738: END IF;
1739: EXCEPTION
1740: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1741: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1822: okc_util.print_trace(4, ' ');

1818: END Set_Attributes;
1819: BEGIN
1820:
1821: IF (l_debug = 'Y') THEN
1822: okc_util.print_trace(4, ' ');
1823: okc_util.print_trace(4, '>START - OKC_CRJ_PVT.INSERT_ROW -');
1824: END IF;
1825: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1826: G_PKG_NAME,

Line 1823: okc_util.print_trace(4, '>START - OKC_CRJ_PVT.INSERT_ROW -');

1819: BEGIN
1820:
1821: IF (l_debug = 'Y') THEN
1822: okc_util.print_trace(4, ' ');
1823: okc_util.print_trace(4, '>START - OKC_CRJ_PVT.INSERT_ROW -');
1824: END IF;
1825: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1826: G_PKG_NAME,
1827: p_init_msg_list,

Line 1852: okc_util.print_trace(5, 'calling fill_who_columns');

1848: RAISE OKC_API.G_EXCEPTION_ERROR;
1849: END IF;
1850:
1851: IF (l_debug = 'Y') THEN
1852: okc_util.print_trace(5, 'calling fill_who_columns');
1853: END IF;
1854: l_def_crjv_rec := fill_who_columns(l_def_crjv_rec);
1855: --- Validate all non-missing attributes (Item Level Validation)
1856:

Line 1858: okc_util.print_trace(5, 'calling Validate_Attributes');

1854: l_def_crjv_rec := fill_who_columns(l_def_crjv_rec);
1855: --- Validate all non-missing attributes (Item Level Validation)
1856:
1857: IF (l_debug = 'Y') THEN
1858: okc_util.print_trace(5, 'calling Validate_Attributes');
1859: okc_util.print_trace(6, 'l_def_crjv_rec.id:' || l_def_crjv_rec.id);
1860: okc_util.print_trace(6, 'l_def_crjv_rec.cle_id:' || l_def_crjv_rec.cle_id);
1861: okc_util.print_trace(6, 'l_def_crjv_rec.chr_id:' || l_def_crjv_rec.chr_id);
1862: okc_util.print_trace(6, 'l_def_crjv_rec.rty_code:' || l_def_crjv_rec.rty_code);

Line 1859: okc_util.print_trace(6, 'l_def_crjv_rec.id:' || l_def_crjv_rec.id);

1855: --- Validate all non-missing attributes (Item Level Validation)
1856:
1857: IF (l_debug = 'Y') THEN
1858: okc_util.print_trace(5, 'calling Validate_Attributes');
1859: okc_util.print_trace(6, 'l_def_crjv_rec.id:' || l_def_crjv_rec.id);
1860: okc_util.print_trace(6, 'l_def_crjv_rec.cle_id:' || l_def_crjv_rec.cle_id);
1861: okc_util.print_trace(6, 'l_def_crjv_rec.chr_id:' || l_def_crjv_rec.chr_id);
1862: okc_util.print_trace(6, 'l_def_crjv_rec.rty_code:' || l_def_crjv_rec.rty_code);
1863: okc_util.print_trace(6, 'l_def_crjv_rec.object1_id1:' || l_def_crjv_rec.object1_id1);

Line 1860: okc_util.print_trace(6, 'l_def_crjv_rec.cle_id:' || l_def_crjv_rec.cle_id);

1856:
1857: IF (l_debug = 'Y') THEN
1858: okc_util.print_trace(5, 'calling Validate_Attributes');
1859: okc_util.print_trace(6, 'l_def_crjv_rec.id:' || l_def_crjv_rec.id);
1860: okc_util.print_trace(6, 'l_def_crjv_rec.cle_id:' || l_def_crjv_rec.cle_id);
1861: okc_util.print_trace(6, 'l_def_crjv_rec.chr_id:' || l_def_crjv_rec.chr_id);
1862: okc_util.print_trace(6, 'l_def_crjv_rec.rty_code:' || l_def_crjv_rec.rty_code);
1863: okc_util.print_trace(6, 'l_def_crjv_rec.object1_id1:' || l_def_crjv_rec.object1_id1);
1864: okc_util.print_trace(6, 'l_def_crjv_rec.jtot_object1_id:' || l_def_crjv_rec.jtot_object1_id);

Line 1861: okc_util.print_trace(6, 'l_def_crjv_rec.chr_id:' || l_def_crjv_rec.chr_id);

1857: IF (l_debug = 'Y') THEN
1858: okc_util.print_trace(5, 'calling Validate_Attributes');
1859: okc_util.print_trace(6, 'l_def_crjv_rec.id:' || l_def_crjv_rec.id);
1860: okc_util.print_trace(6, 'l_def_crjv_rec.cle_id:' || l_def_crjv_rec.cle_id);
1861: okc_util.print_trace(6, 'l_def_crjv_rec.chr_id:' || l_def_crjv_rec.chr_id);
1862: okc_util.print_trace(6, 'l_def_crjv_rec.rty_code:' || l_def_crjv_rec.rty_code);
1863: okc_util.print_trace(6, 'l_def_crjv_rec.object1_id1:' || l_def_crjv_rec.object1_id1);
1864: okc_util.print_trace(6, 'l_def_crjv_rec.jtot_object1_id:' || l_def_crjv_rec.jtot_object1_id);
1865: okc_util.print_trace(6, 'l_def_crjv_rec.jtot_object1_code:' || l_def_crjv_rec.jtot_object1_code);

Line 1862: okc_util.print_trace(6, 'l_def_crjv_rec.rty_code:' || l_def_crjv_rec.rty_code);

1858: okc_util.print_trace(5, 'calling Validate_Attributes');
1859: okc_util.print_trace(6, 'l_def_crjv_rec.id:' || l_def_crjv_rec.id);
1860: okc_util.print_trace(6, 'l_def_crjv_rec.cle_id:' || l_def_crjv_rec.cle_id);
1861: okc_util.print_trace(6, 'l_def_crjv_rec.chr_id:' || l_def_crjv_rec.chr_id);
1862: okc_util.print_trace(6, 'l_def_crjv_rec.rty_code:' || l_def_crjv_rec.rty_code);
1863: okc_util.print_trace(6, 'l_def_crjv_rec.object1_id1:' || l_def_crjv_rec.object1_id1);
1864: okc_util.print_trace(6, 'l_def_crjv_rec.jtot_object1_id:' || l_def_crjv_rec.jtot_object1_id);
1865: okc_util.print_trace(6, 'l_def_crjv_rec.jtot_object1_code:' || l_def_crjv_rec.jtot_object1_code);
1866: okc_util.print_trace(6, '');

Line 1863: okc_util.print_trace(6, 'l_def_crjv_rec.object1_id1:' || l_def_crjv_rec.object1_id1);

1859: okc_util.print_trace(6, 'l_def_crjv_rec.id:' || l_def_crjv_rec.id);
1860: okc_util.print_trace(6, 'l_def_crjv_rec.cle_id:' || l_def_crjv_rec.cle_id);
1861: okc_util.print_trace(6, 'l_def_crjv_rec.chr_id:' || l_def_crjv_rec.chr_id);
1862: okc_util.print_trace(6, 'l_def_crjv_rec.rty_code:' || l_def_crjv_rec.rty_code);
1863: okc_util.print_trace(6, 'l_def_crjv_rec.object1_id1:' || l_def_crjv_rec.object1_id1);
1864: okc_util.print_trace(6, 'l_def_crjv_rec.jtot_object1_id:' || l_def_crjv_rec.jtot_object1_id);
1865: okc_util.print_trace(6, 'l_def_crjv_rec.jtot_object1_code:' || l_def_crjv_rec.jtot_object1_code);
1866: okc_util.print_trace(6, '');
1867: END IF;

Line 1864: okc_util.print_trace(6, 'l_def_crjv_rec.jtot_object1_id:' || l_def_crjv_rec.jtot_object1_id);

1860: okc_util.print_trace(6, 'l_def_crjv_rec.cle_id:' || l_def_crjv_rec.cle_id);
1861: okc_util.print_trace(6, 'l_def_crjv_rec.chr_id:' || l_def_crjv_rec.chr_id);
1862: okc_util.print_trace(6, 'l_def_crjv_rec.rty_code:' || l_def_crjv_rec.rty_code);
1863: okc_util.print_trace(6, 'l_def_crjv_rec.object1_id1:' || l_def_crjv_rec.object1_id1);
1864: okc_util.print_trace(6, 'l_def_crjv_rec.jtot_object1_id:' || l_def_crjv_rec.jtot_object1_id);
1865: okc_util.print_trace(6, 'l_def_crjv_rec.jtot_object1_code:' || l_def_crjv_rec.jtot_object1_code);
1866: okc_util.print_trace(6, '');
1867: END IF;
1868: l_return_status := Validate_Attributes(l_def_crjv_rec, l_api_name);

Line 1865: okc_util.print_trace(6, 'l_def_crjv_rec.jtot_object1_code:' || l_def_crjv_rec.jtot_object1_code);

1861: okc_util.print_trace(6, 'l_def_crjv_rec.chr_id:' || l_def_crjv_rec.chr_id);
1862: okc_util.print_trace(6, 'l_def_crjv_rec.rty_code:' || l_def_crjv_rec.rty_code);
1863: okc_util.print_trace(6, 'l_def_crjv_rec.object1_id1:' || l_def_crjv_rec.object1_id1);
1864: okc_util.print_trace(6, 'l_def_crjv_rec.jtot_object1_id:' || l_def_crjv_rec.jtot_object1_id);
1865: okc_util.print_trace(6, 'l_def_crjv_rec.jtot_object1_code:' || l_def_crjv_rec.jtot_object1_code);
1866: okc_util.print_trace(6, '');
1867: END IF;
1868: l_return_status := Validate_Attributes(l_def_crjv_rec, l_api_name);
1869:

Line 1866: okc_util.print_trace(6, '');

1862: okc_util.print_trace(6, 'l_def_crjv_rec.rty_code:' || l_def_crjv_rec.rty_code);
1863: okc_util.print_trace(6, 'l_def_crjv_rec.object1_id1:' || l_def_crjv_rec.object1_id1);
1864: okc_util.print_trace(6, 'l_def_crjv_rec.jtot_object1_id:' || l_def_crjv_rec.jtot_object1_id);
1865: okc_util.print_trace(6, 'l_def_crjv_rec.jtot_object1_code:' || l_def_crjv_rec.jtot_object1_code);
1866: okc_util.print_trace(6, '');
1867: END IF;
1868: l_return_status := Validate_Attributes(l_def_crjv_rec, l_api_name);
1869:
1870: --- If any errors happen abort API

Line 1880: okc_util.print_trace(5, 'calling migrate');

1876: --------------------------------------
1877: -- Move VIEW record to "Child" records
1878: --------------------------------------
1879: IF (l_debug = 'Y') THEN
1880: okc_util.print_trace(5, 'calling migrate');
1881: END IF;
1882: migrate(l_def_crjv_rec, l_crj_rec);
1883: --------------------------------------------
1884: -- Call the INSERT_ROW for each child record

Line 1888: okc_util.print_trace(5, 'before insert');

1884: -- Call the INSERT_ROW for each child record
1885: --------------------------------------------
1886:
1887: IF (l_debug = 'Y') THEN
1888: okc_util.print_trace(5, 'before insert');
1889: END IF;
1890: insert_row(
1891: p_init_msg_list,
1892: x_return_status,

Line 1908: okc_util.print_trace(4, '

1904: -- Set OUT values
1905: x_crjv_rec := l_def_crjv_rec;
1906: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1907: IF (l_debug = 'Y') THEN
1908: okc_util.print_trace(4, ' 1909: END IF;
1910: EXCEPTION
1911: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1912: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 4049: okc_util.print_trace(6, 'l_sql_stmt:' || l_sql_stmt);

4045: l_id2 := '#';
4046: end if;
4047:
4048: IF (l_debug = 'Y') THEN
4049: okc_util.print_trace(6, 'l_sql_stmt:' || l_sql_stmt);
4050: okc_util.print_trace(6, 'p_id1: ' || p_id1 || ', l_id2: ' || l_id2);
4051: okc_util.print_trace(6, 'Operating Unit = '|| sys_context('OKC_CONTEXT','ORG_ID'));
4052: END IF;
4053: open c for l_sql_stmt using p_id1, l_id2;

Line 4050: okc_util.print_trace(6, 'p_id1: ' || p_id1 || ', l_id2: ' || l_id2);

4046: end if;
4047:
4048: IF (l_debug = 'Y') THEN
4049: okc_util.print_trace(6, 'l_sql_stmt:' || l_sql_stmt);
4050: okc_util.print_trace(6, 'p_id1: ' || p_id1 || ', l_id2: ' || l_id2);
4051: okc_util.print_trace(6, 'Operating Unit = '|| sys_context('OKC_CONTEXT','ORG_ID'));
4052: END IF;
4053: open c for l_sql_stmt using p_id1, l_id2;
4054: fetch c into l_num;

Line 4051: okc_util.print_trace(6, 'Operating Unit = '|| sys_context('OKC_CONTEXT','ORG_ID'));

4047:
4048: IF (l_debug = 'Y') THEN
4049: okc_util.print_trace(6, 'l_sql_stmt:' || l_sql_stmt);
4050: okc_util.print_trace(6, 'p_id1: ' || p_id1 || ', l_id2: ' || l_id2);
4051: okc_util.print_trace(6, 'Operating Unit = '|| sys_context('OKC_CONTEXT','ORG_ID'));
4052: END IF;
4053: open c for l_sql_stmt using p_id1, l_id2;
4054: fetch c into l_num;
4055: l_not_found := c%NOTFOUND;

Line 4062: okc_util.print_trace(6, 'temp: not found');

4058: If (
4059: l_not_found
4060: ) Then
4061: IF (l_debug = 'Y') THEN
4062: okc_util.print_trace(6, 'temp: not found');
4063: END IF;
4064: OKC_API.set_message
4065: (
4066: G_APP_NAME

Line 4124: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;

4120: -- Procedure for mass insert in OKC_K_REL_OBJS _B and TL tables
4121: ---------------------------------------------------------------
4122: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_crjv_tbl crjv_tbl_type) IS
4123: l_tabsize NUMBER := p_crjv_tbl.COUNT;
4124: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
4125:
4126: in_id OKC_DATATYPES.NumberTabTyp;
4127: in_object_version_number OKC_DATATYPES.NumberTabTyp;
4128: in_cle_id OKC_DATATYPES.NumberTabTyp;