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 126: okc_debug.log( str, 2 );

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

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

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

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

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

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

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

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

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

Line 384: okc_debug.Reset_Indentation;

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

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

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

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

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

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

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

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

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

Line 507: okc_debug.Reset_Indentation;

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

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

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

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

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

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

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

Line 559: okc_debug.Reset_Indentation;

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

Line 608: okc_debug.Set_Indentation(G_PKG_NAME);

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

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

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

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

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

Line 632: okc_debug.Reset_Indentation;

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

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

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

Line 740: okc_debug.Reset_Indentation;

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

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

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

Line 748: okc_debug.Reset_Indentation;

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

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

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

Line 758: okc_debug.Reset_Indentation;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1050: okc_debug.Set_Indentation(G_PKG_NAME);

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

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

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

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

1238: gi_catv_rec.attribute15 := NULL;
1239: END IF;
1240:
1241: IF (l_debug = 'Y') THEN
1242: okc_debug.log('11400: Leaving Null_Out_Record ', 2);
1243: okc_debug.Reset_Indentation;
1244: END IF;
1245:
1246: END Null_Out_Record;

Line 1243: okc_debug.Reset_Indentation;

1239: END IF;
1240:
1241: IF (l_debug = 'Y') THEN
1242: okc_debug.log('11400: Leaving Null_Out_Record ', 2);
1243: okc_debug.Reset_Indentation;
1244: END IF;
1245:
1246: END Null_Out_Record;
1247:

Line 1267: okc_debug.Set_Indentation(G_PKG_NAME);

1263: BEGIN
1264: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1265:
1266: IF (l_debug = 'Y') THEN
1267: okc_debug.Set_Indentation(G_PKG_NAME);
1268: okc_debug.log('11300: Entered Default_Record', 2);
1269: END IF;
1270:
1271: -------------------------------------------------

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

1264: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1265:
1266: IF (l_debug = 'Y') THEN
1267: okc_debug.Set_Indentation(G_PKG_NAME);
1268: okc_debug.log('11300: Entered Default_Record', 2);
1269: END IF;
1270:
1271: -------------------------------------------------
1272: -- Populating/Defaulting new API attributes

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

1282: x_doc_type => gi_catv_rec.document_type
1283: );
1284: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1285: IF (l_debug = 'Y') THEN
1286: okc_debug.log('11400: Leaving Default_Record because of an exception in Get_Contract_Document_Type', 2);
1287: okc_debug.Reset_Indentation;
1288: END IF;
1289: RETURN;
1290: END IF;

Line 1287: okc_debug.Reset_Indentation;

1283: );
1284: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1285: IF (l_debug = 'Y') THEN
1286: okc_debug.log('11400: Leaving Default_Record because of an exception in Get_Contract_Document_Type', 2);
1287: okc_debug.Reset_Indentation;
1288: END IF;
1289: RETURN;
1290: END IF;
1291: END IF;

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

1310: p_doc_type => gi_catv_rec.document_type
1311: );
1312: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1313: IF (l_debug = 'Y') THEN
1314: okc_debug.log('11400: Leaving Default_Record because of an exception in Get_Unassign_Section_ID', 2);
1315: okc_debug.Reset_Indentation;
1316: END IF;
1317: RETURN;
1318: END IF;

Line 1315: okc_debug.Reset_Indentation;

1311: );
1312: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1313: IF (l_debug = 'Y') THEN
1314: okc_debug.log('11400: Leaving Default_Record because of an exception in Get_Unassign_Section_ID', 2);
1315: okc_debug.Reset_Indentation;
1316: END IF;
1317: RETURN;
1318: END IF;
1319: END IF;

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

1345: x_std_art_ver_id => gi_catv_rec.ref_article_version_id
1346: );
1347: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1348: IF (l_debug = 'Y') THEN
1349: okc_debug.log('11400: Leaving Default_Record because of an exception in Process_Non_Std_Article', 2);
1350: okc_debug.Reset_Indentation;
1351: END IF;
1352: RETURN;
1353: END IF;

Line 1350: okc_debug.Reset_Indentation;

1346: );
1347: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1348: IF (l_debug = 'Y') THEN
1349: okc_debug.log('11400: Leaving Default_Record because of an exception in Process_Non_Std_Article', 2);
1350: okc_debug.Reset_Indentation;
1351: END IF;
1352: RETURN;
1353: END IF;
1354:

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

1365:
1366: -------------------------------------------------
1367:
1368: IF (l_debug = 'Y') THEN
1369: okc_debug.log('11400: Leaving Default_Record ', 2);
1370: okc_debug.Reset_Indentation;
1371: END IF;
1372:
1373: END Default_Record;

Line 1370: okc_debug.Reset_Indentation;

1366: -------------------------------------------------
1367:
1368: IF (l_debug = 'Y') THEN
1369: okc_debug.log('11400: Leaving Default_Record ', 2);
1370: okc_debug.Reset_Indentation;
1371: END IF;
1372:
1373: END Default_Record;
1374:

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

1421: -- code for temporary clob ... end
1422: --
1423:
1424: IF (l_debug = 'Y') THEN
1425: okc_debug.log('1000: Entered '||l_api_name, 2);
1426: END IF;
1427:
1428: gi_catv_rec := Migrate( p_catv_rec );
1429:

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

1518: x_catv_rec := get_rec( gi_catv_rec.id );
1519: g_catv_rec := x_catv_rec;
1520:
1521: IF (l_debug = 'Y') THEN
1522: okc_debug.log('1000: Leaving '||l_api_name, 2);
1523: Dump_Rec( x_catv_rec );
1524: END IF;
1525:
1526: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1725: okc_debug.Set_Indentation(G_PKG_NAME);

1721: PROCEDURE Flip_GMISS_Record IS
1722: BEGIN
1723:
1724: IF (l_debug = 'Y') THEN
1725: okc_debug.Set_Indentation(G_PKG_NAME);
1726: okc_debug.log('11300: Entered Flip_GMISS_Record', 2);
1727: END IF;
1728:
1729: ----------------------------------------------------------------

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

1722: BEGIN
1723:
1724: IF (l_debug = 'Y') THEN
1725: okc_debug.Set_Indentation(G_PKG_NAME);
1726: okc_debug.log('11300: Entered Flip_GMISS_Record', 2);
1727: END IF;
1728:
1729: ----------------------------------------------------------------
1730: -- Start of GMISS logic flipping

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

2018: -- End of GMISS logic flipping
2019: ----------------------------------------------------------------
2020:
2021: IF (l_debug = 'Y') THEN
2022: okc_debug.log('11400: Leaving Flip_GMISS_Record ', 2);
2023: okc_debug.Reset_Indentation;
2024: END IF;
2025:
2026: END Flip_GMISS_Record;

Line 2023: okc_debug.Reset_Indentation;

2019: ----------------------------------------------------------------
2020:
2021: IF (l_debug = 'Y') THEN
2022: okc_debug.log('11400: Leaving Flip_GMISS_Record ', 2);
2023: okc_debug.Reset_Indentation;
2024: END IF;
2025:
2026: END Flip_GMISS_Record;
2027:

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

2073: --
2074: -- code for temporary clob ... end
2075: --
2076: IF (l_debug = 'Y') THEN
2077: okc_debug.log('1000: Entered '||l_api_name, 2);
2078: Dump_Rec( p_catv_rec );
2079: END IF;
2080:
2081: g_catv_rec := p_catv_rec;

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

2097:
2098: Flip_GMISS_Record;
2099:
2100: IF (l_debug = 'Y') THEN
2101: okc_debug.log('1000: before update_article', 2);
2102: Dump_Rec( gi_catv_rec );
2103: END IF;
2104:
2105: OKC_K_ARTICLES_GRP.update_article(

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

2154: x_catv_rec := get_rec( gi_catv_rec.id );
2155: g_catv_rec := x_catv_rec;
2156:
2157: IF (l_debug = 'Y') THEN
2158: okc_debug.log('1000: Leaving '||l_api_name, 2);
2159: Dump_Rec( x_catv_rec );
2160: END IF;
2161:
2162: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2162: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2163: EXCEPTION
2164: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2165: IF (l_debug = 'Y') THEN
2166: okc_debug.log('1000: Leaving '||l_api_name||' because of G_EXCEPTION_ERROR ', 2);
2167: END IF;
2168: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2169: (substr(l_api_name,1,26),
2170: G_PKG_NAME,

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

2173: x_msg_data,
2174: G_SCOPE);
2175: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2176: IF (l_debug = 'Y') THEN
2177: okc_debug.log('1000: Leaving '||l_api_name||' because of G_EXCEPTION_UNEXPECTED_ERROR ', 2);
2178: END IF;
2179: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2180: (substr(l_api_name,1,26),
2181: G_PKG_NAME,

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

2184: x_msg_data,
2185: G_SCOPE);
2186: WHEN OTHERS THEN
2187: IF (l_debug = 'Y') THEN
2188: okc_debug.log('500: Leaving '||l_api_name||' because of EXCEPTION: '||sqlerrm, 2);
2189: END IF;
2190: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2191: (substr(l_api_name,1,26),
2192: G_PKG_NAME,

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

2526: x_atnv_rec OUT NOCOPY atnv_rec_type) is
2527: begin
2528: OKC_API.init_msg_list(p_init_msg_list);
2529: IF (l_debug = 'Y') THEN
2530: Okc_Debug.Log('400: Entered create_article_translation - DUMMY procedure', 2);
2531: END IF;
2532: -- We won't create a record - keep g_atnv_rec empty
2533: -- g_atnv_rec := p_atnv_rec;
2534: -- x_atnv_rec := p_atnv_rec;

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

2553: x_atnv_tbl OUT NOCOPY atnv_tbl_type) is
2554: begin
2555: OKC_API.init_msg_list(p_init_msg_list);
2556: IF (l_debug = 'Y') THEN
2557: Okc_Debug.Log('400: Entered create_article_translation - DUMMY procedure', 2);
2558: END IF;
2559: -- We won't create a record - keep g_atnv_rec empty
2560: -- g_atnv_rec := p_atnv_rec;
2561: -- x_atnv_rec := p_atnv_rec;

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

2579: p_atnv_rec IN atnv_rec_type) is
2580: begin
2581: OKC_API.init_msg_list(p_init_msg_list);
2582: IF (l_debug = 'Y') THEN
2583: Okc_Debug.Log('400: Entered lock_article_translation - DUMMY procedure', 2);
2584: END IF;
2585: x_msg_count := 0;
2586: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2587: end lock_article_translation;

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

2602: p_atnv_tbl IN atnv_tbl_type) is
2603: begin
2604: OKC_API.init_msg_list(p_init_msg_list);
2605: IF (l_debug = 'Y') THEN
2606: Okc_Debug.Log('400: Entered lock_article_translation - DUMMY procedure', 2);
2607: END IF;
2608: x_msg_count := 0;
2609: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2610: end lock_article_translation;

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

2625: p_atnv_rec IN atnv_rec_type) is
2626: begin
2627: OKC_API.init_msg_list(p_init_msg_list);
2628: IF (l_debug = 'Y') THEN
2629: Okc_Debug.Log('400: Entered delete_article_translation - DUMMY procedure', 2);
2630: END IF;
2631: x_msg_count := 0;
2632: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2633: end delete_article_translation;

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

2648: p_atnv_tbl IN atnv_tbl_type) is
2649: begin
2650: OKC_API.init_msg_list(p_init_msg_list);
2651: IF (l_debug = 'Y') THEN
2652: Okc_Debug.Log('400: Entered delete_article_translation - DUMMY procedure', 2);
2653: END IF;
2654: x_msg_count := 0;
2655: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2656: end delete_article_translation;

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

2671: p_atnv_rec IN atnv_rec_type) is
2672: begin
2673: OKC_API.init_msg_list(p_init_msg_list);
2674: IF (l_debug = 'Y') THEN
2675: Okc_Debug.Log('400: Entered validate_article_translation - DUMMY procedure', 2);
2676: END IF;
2677: x_msg_count := 0;
2678: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2679: end validate_article_translation;

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

2694: p_atnv_tbl IN atnv_tbl_type) is
2695: begin
2696: OKC_API.init_msg_list(p_init_msg_list);
2697: IF (l_debug = 'Y') THEN
2698: Okc_Debug.Log('400: Entered validate_article_translation - DUMMY procedure', 2);
2699: END IF;
2700: x_msg_count := 0;
2701: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2702: end validate_article_translation;