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_ARTICLE_PUB dependencies on OKC_DEBUG

Line 127: okc_debug.log( str, 2 );

123:
124: PROCEDURE Dump_Rec( p_catv_rec catv_11510_rec_type ) IS
125: PROCEDURE Print( str VARCHAR2 ) IS
126: BEGIN
127: okc_debug.log( str, 2 );
128: -- Dbms_Output.Put_line( str );
129: END;
130: BEGIN
131: Print( '-----------------------------------------------------------------');

Line 174: okc_debug.log( str, 2 );

170:
171: PROCEDURE Dump_Rec( p_catv_rec catv_rec_type ) IS
172: PROCEDURE Print( str VARCHAR2 ) IS
173: BEGIN
174: okc_debug.log( str, 2 );
175: -- Dbms_Output.Put_line( str );
176: END;
177: BEGIN
178: Print( '-----------------------------------------------------------------');

Line 292: okc_debug.Set_Indentation('KART');

288: l_catv_rec catv_rec_type;
289: BEGIN
290:
291: IF (l_debug = 'Y') THEN
292: okc_debug.Set_Indentation('KART');
293: okc_debug.log('1000: Entered get_rec', 2);
294: END IF;
295:
296: x_no_data_found := TRUE;

Line 293: okc_debug.log('1000: Entered get_rec', 2);

289: BEGIN
290:
291: IF (l_debug = 'Y') THEN
292: okc_debug.Set_Indentation('KART');
293: okc_debug.log('1000: Entered get_rec', 2);
294: END IF;
295:
296: x_no_data_found := TRUE;
297: -- Get current database values

Line 385: okc_debug.log('1000: Leaving Get_Rec ', 2);

381: CLOSE okc_catv_h_pk_csr;
382: END IF;
383:
384: IF (l_debug = 'Y') THEN
385: okc_debug.log('1000: Leaving Get_Rec ', 2);
386: okc_debug.Reset_Indentation;
387: END IF;
388:
389: RETURN(l_catv_rec);

Line 386: okc_debug.Reset_Indentation;

382: END IF;
383:
384: IF (l_debug = 'Y') THEN
385: okc_debug.log('1000: Leaving Get_Rec ', 2);
386: okc_debug.Reset_Indentation;
387: END IF;
388:
389: RETURN(l_catv_rec);
390:

Line 410: okc_debug.Set_Indentation('KART');

406: x_catv_rec catv_11510_rec_type;
407: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
408: BEGIN
409: IF (l_debug = 'Y') THEN
410: okc_debug.Set_Indentation('KART');
411: okc_debug.log('1000: Entered migrate1', 2);
412: END IF;
413:
414: IF p_catv_rec.ID IS NOT NULL AND p_catv_rec.id <> G_MISS_NUM THEN

Line 411: okc_debug.log('1000: Entered migrate1', 2);

407: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
408: BEGIN
409: IF (l_debug = 'Y') THEN
410: okc_debug.Set_Indentation('KART');
411: okc_debug.log('1000: Entered migrate1', 2);
412: END IF;
413:
414: IF p_catv_rec.ID IS NOT NULL AND p_catv_rec.id <> G_MISS_NUM THEN
415: IF (l_debug = 'Y') THEN

Line 416: okc_debug.log('1000: cat_id IS NOT NULL('||p_catv_rec.ID||')', 2);

412: END IF;
413:
414: IF p_catv_rec.ID IS NOT NULL AND p_catv_rec.id <> G_MISS_NUM THEN
415: IF (l_debug = 'Y') THEN
416: okc_debug.log('1000: cat_id IS NOT NULL('||p_catv_rec.ID||')', 2);
417: END IF;
418: -- Get current database values
419: l_return_status := OKC_K_ARTICLES_PVT.Get_Rec(
420: p_id => p_catv_rec.id,

Line 509: okc_debug.log('1000: Leaving migrate1', 2);

505: x_catv_rec.LAST_UPDATE_DATE := p_catv_rec.LAST_UPDATE_DATE;
506: x_catv_rec.LAST_UPDATE_LOGIN := p_catv_rec.LAST_UPDATE_LOGIN;
507:
508: IF (l_debug = 'Y') THEN
509: okc_debug.log('1000: Leaving migrate1', 2);
510: okc_debug.Reset_Indentation;
511: END IF;
512:
513: RETURN x_catv_rec;

Line 510: okc_debug.Reset_Indentation;

506: x_catv_rec.LAST_UPDATE_LOGIN := p_catv_rec.LAST_UPDATE_LOGIN;
507:
508: IF (l_debug = 'Y') THEN
509: okc_debug.log('1000: Leaving migrate1', 2);
510: okc_debug.Reset_Indentation;
511: END IF;
512:
513: RETURN x_catv_rec;
514: END migrate;

Line 520: okc_debug.Set_Indentation('KART');

516: FUNCTION migrate(p_catv_rec IN catv_11510_rec_type) RETURN catv_rec_type IS
517: x_catv_rec catv_rec_type;
518: BEGIN
519: IF (l_debug = 'Y') THEN
520: okc_debug.Set_Indentation('KART');
521: okc_debug.log('1000: Entered migrate2', 2);
522: END IF;
523: x_catv_rec.ID := p_catv_rec.ID;
524: x_catv_rec.CHR_ID := p_catv_rec.CHR_ID;

Line 521: okc_debug.log('1000: Entered migrate2', 2);

517: x_catv_rec catv_rec_type;
518: BEGIN
519: IF (l_debug = 'Y') THEN
520: okc_debug.Set_Indentation('KART');
521: okc_debug.log('1000: Entered migrate2', 2);
522: END IF;
523: x_catv_rec.ID := p_catv_rec.ID;
524: x_catv_rec.CHR_ID := p_catv_rec.CHR_ID;
525: x_catv_rec.CLE_ID := p_catv_rec.CLE_ID;

Line 561: okc_debug.log('1000: Leaving migrate2', 2);

557: x_catv_rec.LAST_UPDATED_BY := p_catv_rec.LAST_UPDATED_BY;
558: x_catv_rec.LAST_UPDATE_DATE := p_catv_rec.LAST_UPDATE_DATE;
559: x_catv_rec.LAST_UPDATE_LOGIN := p_catv_rec.LAST_UPDATE_LOGIN;
560: IF (l_debug = 'Y') THEN
561: okc_debug.log('1000: Leaving migrate2', 2);
562: okc_debug.Reset_Indentation;
563: END IF;
564:
565: RETURN x_catv_rec;

Line 562: okc_debug.Reset_Indentation;

558: x_catv_rec.LAST_UPDATE_DATE := p_catv_rec.LAST_UPDATE_DATE;
559: x_catv_rec.LAST_UPDATE_LOGIN := p_catv_rec.LAST_UPDATE_LOGIN;
560: IF (l_debug = 'Y') THEN
561: okc_debug.log('1000: Leaving migrate2', 2);
562: okc_debug.Reset_Indentation;
563: END IF;
564:
565: RETURN x_catv_rec;
566: END migrate;

Line 611: okc_debug.Set_Indentation(G_PKG_NAME);

607: SELECT TEMPLATE_ID FROM okc_terms_templates_all
608: WHERE template_name = l_tmpl_name and nvl(org_id,-99)=nvl(l_org_id,-99);
609: BEGIN
610: IF (l_debug = 'Y') THEN
611: okc_debug.Set_Indentation(G_PKG_NAME);
612: okc_debug.log('1000: Entered Get_Unassign_Section_ID', 2);
613: END IF;
614:
615: x_return_status := G_RET_STS_SUCCESS;

Line 612: okc_debug.log('1000: Entered Get_Unassign_Section_ID', 2);

608: WHERE template_name = l_tmpl_name and nvl(org_id,-99)=nvl(l_org_id,-99);
609: BEGIN
610: IF (l_debug = 'Y') THEN
611: okc_debug.Set_Indentation(G_PKG_NAME);
612: okc_debug.log('1000: Entered Get_Unassign_Section_ID', 2);
613: END IF;
614:
615: x_return_status := G_RET_STS_SUCCESS;
616:

Line 634: okc_debug.log('11400: Leaving Get_Unassign_Section_ID because of an exception in OKC_TERMS_UTIL_PVT.create_unassigned_section', 2);

630: x_scn_id => l_scn_id
631: );
632: IF (x_return_status <> G_RET_STS_SUCCESS) then
633: IF (l_debug = 'Y') THEN
634: okc_debug.log('11400: Leaving Get_Unassign_Section_ID because of an exception in OKC_TERMS_UTIL_PVT.create_unassigned_section', 2);
635: okc_debug.Reset_Indentation;
636: END IF;
637: RETURN NULL;
638: END IF;

Line 635: okc_debug.Reset_Indentation;

631: );
632: IF (x_return_status <> G_RET_STS_SUCCESS) then
633: IF (l_debug = 'Y') THEN
634: okc_debug.log('11400: Leaving Get_Unassign_Section_ID because of an exception in OKC_TERMS_UTIL_PVT.create_unassigned_section', 2);
635: okc_debug.Reset_Indentation;
636: END IF;
637: RETURN NULL;
638: END IF;
639: END IF;

Line 742: okc_debug.log('11400: Leaving Get_Unassign_Section_ID because of an exception in OKC_TEMPLATE_USAGES_GRP.create_template_usages', 2);

738: x_document_id => l_doc_id
739: );
740: IF (x_return_status <> G_RET_STS_SUCCESS) then
741: IF (l_debug = 'Y') THEN
742: okc_debug.log('11400: Leaving Get_Unassign_Section_ID because of an exception in OKC_TEMPLATE_USAGES_GRP.create_template_usages', 2);
743: okc_debug.Reset_Indentation;
744: END IF;
745: RETURN NULL;
746: END IF;

Line 743: okc_debug.Reset_Indentation;

739: );
740: IF (x_return_status <> G_RET_STS_SUCCESS) then
741: IF (l_debug = 'Y') THEN
742: okc_debug.log('11400: Leaving Get_Unassign_Section_ID because of an exception in OKC_TEMPLATE_USAGES_GRP.create_template_usages', 2);
743: okc_debug.Reset_Indentation;
744: END IF;
745: RETURN NULL;
746: END IF;
747: ELSE

Line 750: okc_debug.log('11400: Leaving Get_Unassign_Section_ID because there is no UPGRADE template for '||p_doc_type, 2);

746: END IF;
747: ELSE
748: -- It shouldn't ever happend
749: IF (l_debug = 'Y') THEN
750: okc_debug.log('11400: Leaving Get_Unassign_Section_ID because there is no UPGRADE template for '||p_doc_type, 2);
751: okc_debug.Reset_Indentation;
752: END IF;
753: OKC_API.SET_MESSAGE('OKC', 'OKC_NOTDEFINED_11510_UPG_TMPL','DOC_TYPE', p_doc_type);
754: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 751: okc_debug.Reset_Indentation;

747: ELSE
748: -- It shouldn't ever happend
749: IF (l_debug = 'Y') THEN
750: okc_debug.log('11400: Leaving Get_Unassign_Section_ID because there is no UPGRADE template for '||p_doc_type, 2);
751: okc_debug.Reset_Indentation;
752: END IF;
753: OKC_API.SET_MESSAGE('OKC', 'OKC_NOTDEFINED_11510_UPG_TMPL','DOC_TYPE', p_doc_type);
754: x_return_status := G_RET_STS_UNEXP_ERROR;
755: RETURN NULL;

Line 760: okc_debug.log('1000: Leaving Get_Unassign_Section_ID ', 2);

756: END IF;
757: END IF;
758:
759: IF (l_debug = 'Y') THEN
760: okc_debug.log('1000: Leaving Get_Unassign_Section_ID ', 2);
761: okc_debug.Reset_Indentation;
762: END IF;
763:
764: RETURN l_scn_id;

Line 761: okc_debug.Reset_Indentation;

757: END IF;
758:
759: IF (l_debug = 'Y') THEN
760: okc_debug.log('1000: Leaving Get_Unassign_Section_ID ', 2);
761: okc_debug.Reset_Indentation;
762: END IF;
763:
764: RETURN l_scn_id;
765: END Get_Unassign_Section_ID;

Line 815: okc_debug.log('11400: Entering Process_Non_Std_Article', 2);

811: SELECT intent FROM OKC_BUS_DOC_TYPES_B
812: WHERE DOCUMENT_TYPE=p_doc_type;
813: BEGIN
814: IF (l_debug = 'Y') THEN
815: okc_debug.log('11400: Entering Process_Non_Std_Article', 2);
816: END IF;
817: x_return_status := OKC_API.G_RET_STS_SUCCESS;
818: IF (p_catv_rec.id IS NOT NULL ) THEN
819: -- 1. Check current db state (is there std or nonstd)

Line 849: okc_debug.log('11400: non-std article is to be created.Version id of StdArt is '||l_art_ver_id, 2);

845: l_txt := p_catv_rec.TEXT;
846: END IF;
847:
848: IF (l_debug = 'Y') THEN
849: okc_debug.log('11400: non-std article is to be created.Version id of StdArt is '||l_art_ver_id, 2);
850: END IF;
851:
852: OKC_ARTICLES_GRP.create_article(
853: p_api_version => 1,

Line 913: okc_debug.log('300: non-std article created.Version id is '||x_art_ver_id, 2);

909: END IF;
910: --------------------------------------------
911:
912: IF (l_debug = 'Y') THEN
913: okc_debug.log('300: non-std article created.Version id is '||x_art_ver_id, 2);
914: END IF;
915:
916: ELSE
917: x_art_id := l_art_id;

Line 921: okc_debug.log('11400: non-std article is to be updated.Version id is '||l_art_ver_id, 2);

917: x_art_id := l_art_id;
918: x_art_ver_id := l_art_ver_id;
919:
920: IF (l_debug = 'Y') THEN
921: okc_debug.log('11400: non-std article is to be updated.Version id is '||l_art_ver_id, 2);
922: END IF;
923:
924: OKC_ARTICLES_GRP.update_article(
925: p_api_version => 1,

Line 979: okc_debug.log('300: non-std article updated.', 2);

975: END IF;
976: --------------------------------------------
977:
978: IF (l_debug = 'Y') THEN
979: okc_debug.log('300: non-std article updated.', 2);
980: END IF;
981:
982: END IF;
983:

Line 988: okc_debug.log('900: Leaving Process_Non_Std_Article.', 2);

984: -- Standard call to get message count and if count is 1, get message info.
985: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
986:
987: IF (l_debug = 'Y') THEN
988: okc_debug.log('900: Leaving Process_Non_Std_Article.', 2);
989: END IF;
990:
991: EXCEPTION
992: WHEN FND_API.G_EXC_ERROR THEN

Line 994: okc_debug.log('300: Leaving Process_Non_Std_Article: G_EXCEPTION_ERROR Exception', 2);

990:
991: EXCEPTION
992: WHEN FND_API.G_EXC_ERROR THEN
993: IF (l_debug = 'Y') THEN
994: okc_debug.log('300: Leaving Process_Non_Std_Article: G_EXCEPTION_ERROR Exception', 2);
995: END IF;
996:
997: IF l_get_intent_csr%ISOPEN THEN
998: CLOSE l_get_intent_csr;

Line 1006: okc_debug.log('400: Leaving Process_Non_Std_Article: G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1002: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1003:
1004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1005: IF (l_debug = 'Y') THEN
1006: okc_debug.log('400: Leaving Process_Non_Std_Article: G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1007: END IF;
1008:
1009: IF l_get_intent_csr%ISOPEN THEN
1010: CLOSE l_get_intent_csr;

Line 1018: okc_debug.log('500: Leaving Process_Non_Std_Article because of EXCEPTION: '||sqlerrm, 2);

1014: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1015:
1016: WHEN OTHERS THEN
1017: IF (l_debug = 'Y') THEN
1018: okc_debug.log('500: Leaving Process_Non_Std_Article because of EXCEPTION: '||sqlerrm, 2);
1019: END IF;
1020:
1021: IF l_get_intent_csr%ISOPEN THEN
1022: CLOSE l_get_intent_csr;

Line 1053: okc_debug.Set_Indentation(G_PKG_NAME);

1049: BEGIN
1050: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1051:
1052: IF (l_debug = 'Y') THEN
1053: okc_debug.Set_Indentation(G_PKG_NAME);
1054: okc_debug.log('11300: Entered Null_Out_Record', 2);
1055: END IF;
1056:
1057: -- Primary key - Should be NULL

Line 1054: okc_debug.log('11300: Entered Null_Out_Record', 2);

1050: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1051:
1052: IF (l_debug = 'Y') THEN
1053: okc_debug.Set_Indentation(G_PKG_NAME);
1054: okc_debug.log('11300: Entered Null_Out_Record', 2);
1055: END IF;
1056:
1057: -- Primary key - Should be NULL
1058: gi_catv_rec.id := NULL;

Line 1249: okc_debug.log('11400: Leaving Null_Out_Record ', 2);

1245: gi_catv_rec.attribute15 := NULL;
1246: END IF;
1247:
1248: IF (l_debug = 'Y') THEN
1249: okc_debug.log('11400: Leaving Null_Out_Record ', 2);
1250: okc_debug.Reset_Indentation;
1251: END IF;
1252:
1253: END Null_Out_Record;

Line 1250: okc_debug.Reset_Indentation;

1246: END IF;
1247:
1248: IF (l_debug = 'Y') THEN
1249: okc_debug.log('11400: Leaving Null_Out_Record ', 2);
1250: okc_debug.Reset_Indentation;
1251: END IF;
1252:
1253: END Null_Out_Record;
1254:

Line 1274: okc_debug.Set_Indentation(G_PKG_NAME);

1270: BEGIN
1271: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1272:
1273: IF (l_debug = 'Y') THEN
1274: okc_debug.Set_Indentation(G_PKG_NAME);
1275: okc_debug.log('11300: Entered Default_Record', 2);
1276: END IF;
1277:
1278: -------------------------------------------------

Line 1275: okc_debug.log('11300: Entered Default_Record', 2);

1271: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1272:
1273: IF (l_debug = 'Y') THEN
1274: okc_debug.Set_Indentation(G_PKG_NAME);
1275: okc_debug.log('11300: Entered Default_Record', 2);
1276: END IF;
1277:
1278: -------------------------------------------------
1279: -- Populating/Defaulting new API attributes

Line 1293: okc_debug.log('11400: Leaving Default_Record because of an exception in Get_Contract_Document_Type', 2);

1289: x_doc_type => gi_catv_rec.document_type
1290: );
1291: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1292: IF (l_debug = 'Y') THEN
1293: okc_debug.log('11400: Leaving Default_Record because of an exception in Get_Contract_Document_Type', 2);
1294: okc_debug.Reset_Indentation;
1295: END IF;
1296: RETURN;
1297: END IF;

Line 1294: okc_debug.Reset_Indentation;

1290: );
1291: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1292: IF (l_debug = 'Y') THEN
1293: okc_debug.log('11400: Leaving Default_Record because of an exception in Get_Contract_Document_Type', 2);
1294: okc_debug.Reset_Indentation;
1295: END IF;
1296: RETURN;
1297: END IF;
1298: END IF;

Line 1321: okc_debug.log('11400: Leaving Default_Record because of an exception in Get_Unassign_Section_ID', 2);

1317: p_doc_type => gi_catv_rec.document_type
1318: );
1319: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1320: IF (l_debug = 'Y') THEN
1321: okc_debug.log('11400: Leaving Default_Record because of an exception in Get_Unassign_Section_ID', 2);
1322: okc_debug.Reset_Indentation;
1323: END IF;
1324: RETURN;
1325: END IF;

Line 1322: okc_debug.Reset_Indentation;

1318: );
1319: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1320: IF (l_debug = 'Y') THEN
1321: okc_debug.log('11400: Leaving Default_Record because of an exception in Get_Unassign_Section_ID', 2);
1322: okc_debug.Reset_Indentation;
1323: END IF;
1324: RETURN;
1325: END IF;
1326: END IF;

Line 1356: okc_debug.log('11400: Leaving Default_Record because of an exception in Process_Non_Std_Article', 2);

1352: x_std_art_ver_id => gi_catv_rec.ref_article_version_id
1353: );
1354: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1355: IF (l_debug = 'Y') THEN
1356: okc_debug.log('11400: Leaving Default_Record because of an exception in Process_Non_Std_Article', 2);
1357: okc_debug.Reset_Indentation;
1358: END IF;
1359: RETURN;
1360: END IF;

Line 1357: okc_debug.Reset_Indentation;

1353: );
1354: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1355: IF (l_debug = 'Y') THEN
1356: okc_debug.log('11400: Leaving Default_Record because of an exception in Process_Non_Std_Article', 2);
1357: okc_debug.Reset_Indentation;
1358: END IF;
1359: RETURN;
1360: END IF;
1361:

Line 1376: okc_debug.log('11400: Leaving Default_Record ', 2);

1372:
1373: -------------------------------------------------
1374:
1375: IF (l_debug = 'Y') THEN
1376: okc_debug.log('11400: Leaving Default_Record ', 2);
1377: okc_debug.Reset_Indentation;
1378: END IF;
1379:
1380: END Default_Record;

Line 1377: okc_debug.Reset_Indentation;

1373: -------------------------------------------------
1374:
1375: IF (l_debug = 'Y') THEN
1376: okc_debug.log('11400: Leaving Default_Record ', 2);
1377: okc_debug.Reset_Indentation;
1378: END IF;
1379:
1380: END Default_Record;
1381:

Line 1432: okc_debug.log('1000: Entered '||l_api_name, 2);

1428: -- code for temporary clob ... end
1429: --
1430:
1431: IF (l_debug = 'Y') THEN
1432: okc_debug.log('1000: Entered '||l_api_name, 2);
1433: END IF;
1434:
1435: gi_catv_rec := Migrate( p_catv_rec );
1436:

Line 1530: okc_debug.log('1000: Leaving '||l_api_name, 2);

1526: x_catv_rec := get_rec( gi_catv_rec.id );
1527: g_catv_rec := x_catv_rec;
1528:
1529: IF (l_debug = 'Y') THEN
1530: okc_debug.log('1000: Leaving '||l_api_name, 2);
1531: Dump_Rec( x_catv_rec );
1532: END IF;
1533:
1534: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1733: okc_debug.Set_Indentation(G_PKG_NAME);

1729: PROCEDURE Flip_GMISS_Record IS
1730: BEGIN
1731:
1732: IF (l_debug = 'Y') THEN
1733: okc_debug.Set_Indentation(G_PKG_NAME);
1734: okc_debug.log('11300: Entered Flip_GMISS_Record', 2);
1735: END IF;
1736:
1737: ----------------------------------------------------------------

Line 1734: okc_debug.log('11300: Entered Flip_GMISS_Record', 2);

1730: BEGIN
1731:
1732: IF (l_debug = 'Y') THEN
1733: okc_debug.Set_Indentation(G_PKG_NAME);
1734: okc_debug.log('11300: Entered Flip_GMISS_Record', 2);
1735: END IF;
1736:
1737: ----------------------------------------------------------------
1738: -- Start of GMISS logic flipping

Line 2036: okc_debug.log('11400: Leaving Flip_GMISS_Record ', 2);

2032: -- End of GMISS logic flipping
2033: ----------------------------------------------------------------
2034:
2035: IF (l_debug = 'Y') THEN
2036: okc_debug.log('11400: Leaving Flip_GMISS_Record ', 2);
2037: okc_debug.Reset_Indentation;
2038: END IF;
2039:
2040: END Flip_GMISS_Record;

Line 2037: okc_debug.Reset_Indentation;

2033: ----------------------------------------------------------------
2034:
2035: IF (l_debug = 'Y') THEN
2036: okc_debug.log('11400: Leaving Flip_GMISS_Record ', 2);
2037: okc_debug.Reset_Indentation;
2038: END IF;
2039:
2040: END Flip_GMISS_Record;
2041:

Line 2091: okc_debug.log('1000: Entered '||l_api_name, 2);

2087: --
2088: -- code for temporary clob ... end
2089: --
2090: IF (l_debug = 'Y') THEN
2091: okc_debug.log('1000: Entered '||l_api_name, 2);
2092: Dump_Rec( p_catv_rec );
2093: END IF;
2094:
2095: g_catv_rec := p_catv_rec;

Line 2115: okc_debug.log('1000: before update_article', 2);

2111:
2112: Flip_GMISS_Record;
2113:
2114: IF (l_debug = 'Y') THEN
2115: okc_debug.log('1000: before update_article', 2);
2116: Dump_Rec( gi_catv_rec );
2117: END IF;
2118:
2119: OKC_K_ARTICLES_GRP.update_article(

Line 2174: okc_debug.log('1000: Leaving '||l_api_name, 2);

2170: x_catv_rec := get_rec( gi_catv_rec.id );
2171: g_catv_rec := x_catv_rec;
2172:
2173: IF (l_debug = 'Y') THEN
2174: okc_debug.log('1000: Leaving '||l_api_name, 2);
2175: Dump_Rec( x_catv_rec );
2176: END IF;
2177:
2178: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2182: okc_debug.log('1000: Leaving '||l_api_name||' because of G_EXCEPTION_ERROR ', 2);

2178: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2179: EXCEPTION
2180: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2181: IF (l_debug = 'Y') THEN
2182: okc_debug.log('1000: Leaving '||l_api_name||' because of G_EXCEPTION_ERROR ', 2);
2183: END IF;
2184: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2185: (substr(l_api_name,1,26),
2186: G_PKG_NAME,

Line 2193: okc_debug.log('1000: Leaving '||l_api_name||' because of G_EXCEPTION_UNEXPECTED_ERROR ', 2);

2189: x_msg_data,
2190: G_SCOPE);
2191: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2192: IF (l_debug = 'Y') THEN
2193: okc_debug.log('1000: Leaving '||l_api_name||' because of G_EXCEPTION_UNEXPECTED_ERROR ', 2);
2194: END IF;
2195: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2196: (substr(l_api_name,1,26),
2197: G_PKG_NAME,

Line 2204: okc_debug.log('500: Leaving '||l_api_name||' because of EXCEPTION: '||sqlerrm, 2);

2200: x_msg_data,
2201: G_SCOPE);
2202: WHEN OTHERS THEN
2203: IF (l_debug = 'Y') THEN
2204: okc_debug.log('500: Leaving '||l_api_name||' because of EXCEPTION: '||sqlerrm, 2);
2205: END IF;
2206: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2207: (substr(l_api_name,1,26),
2208: G_PKG_NAME,

Line 2547: Okc_Debug.Log('400: Entered create_article_translation - DUMMY procedure', 2);

2543: x_atnv_rec OUT NOCOPY atnv_rec_type) is
2544: begin
2545: OKC_API.init_msg_list(p_init_msg_list);
2546: IF (l_debug = 'Y') THEN
2547: Okc_Debug.Log('400: Entered create_article_translation - DUMMY procedure', 2);
2548: END IF;
2549: -- We won't create a record - keep g_atnv_rec empty
2550: -- g_atnv_rec := p_atnv_rec;
2551: -- x_atnv_rec := p_atnv_rec;

Line 2574: Okc_Debug.Log('400: Entered create_article_translation - DUMMY procedure', 2);

2570: x_atnv_tbl OUT NOCOPY atnv_tbl_type) is
2571: begin
2572: OKC_API.init_msg_list(p_init_msg_list);
2573: IF (l_debug = 'Y') THEN
2574: Okc_Debug.Log('400: Entered create_article_translation - DUMMY procedure', 2);
2575: END IF;
2576: -- We won't create a record - keep g_atnv_rec empty
2577: -- g_atnv_rec := p_atnv_rec;
2578: -- x_atnv_rec := p_atnv_rec;

Line 2600: Okc_Debug.Log('400: Entered lock_article_translation - DUMMY procedure', 2);

2596: p_atnv_rec IN atnv_rec_type) is
2597: begin
2598: OKC_API.init_msg_list(p_init_msg_list);
2599: IF (l_debug = 'Y') THEN
2600: Okc_Debug.Log('400: Entered lock_article_translation - DUMMY procedure', 2);
2601: END IF;
2602: x_msg_count := 0;
2603: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2604: end lock_article_translation;

Line 2623: Okc_Debug.Log('400: Entered lock_article_translation - DUMMY procedure', 2);

2619: p_atnv_tbl IN atnv_tbl_type) is
2620: begin
2621: OKC_API.init_msg_list(p_init_msg_list);
2622: IF (l_debug = 'Y') THEN
2623: Okc_Debug.Log('400: Entered lock_article_translation - DUMMY procedure', 2);
2624: END IF;
2625: x_msg_count := 0;
2626: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2627: end lock_article_translation;

Line 2646: Okc_Debug.Log('400: Entered delete_article_translation - DUMMY procedure', 2);

2642: p_atnv_rec IN atnv_rec_type) is
2643: begin
2644: OKC_API.init_msg_list(p_init_msg_list);
2645: IF (l_debug = 'Y') THEN
2646: Okc_Debug.Log('400: Entered delete_article_translation - DUMMY procedure', 2);
2647: END IF;
2648: x_msg_count := 0;
2649: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2650: end delete_article_translation;

Line 2669: Okc_Debug.Log('400: Entered delete_article_translation - DUMMY procedure', 2);

2665: p_atnv_tbl IN atnv_tbl_type) is
2666: begin
2667: OKC_API.init_msg_list(p_init_msg_list);
2668: IF (l_debug = 'Y') THEN
2669: Okc_Debug.Log('400: Entered delete_article_translation - DUMMY procedure', 2);
2670: END IF;
2671: x_msg_count := 0;
2672: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2673: end delete_article_translation;

Line 2692: Okc_Debug.Log('400: Entered validate_article_translation - DUMMY procedure', 2);

2688: p_atnv_rec IN atnv_rec_type) is
2689: begin
2690: OKC_API.init_msg_list(p_init_msg_list);
2691: IF (l_debug = 'Y') THEN
2692: Okc_Debug.Log('400: Entered validate_article_translation - DUMMY procedure', 2);
2693: END IF;
2694: x_msg_count := 0;
2695: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2696: end validate_article_translation;

Line 2715: Okc_Debug.Log('400: Entered validate_article_translation - DUMMY procedure', 2);

2711: p_atnv_tbl IN atnv_tbl_type) is
2712: begin
2713: OKC_API.init_msg_list(p_init_msg_list);
2714: IF (l_debug = 'Y') THEN
2715: Okc_Debug.Log('400: Entered validate_article_translation - DUMMY procedure', 2);
2716: END IF;
2717: x_msg_count := 0;
2718: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2719: end validate_article_translation;