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_TERMS_DEVIATIONS_PVT dependencies on FND_API

Line 18: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

14: G_UNASSIGNED_SECTION_CODE CONSTANT VARCHAR2(30) := 'UNASSIGNED';
15: ------------------------------------------------------------------------------
16: -- GLOBAL CONSTANTS
17: ------------------------------------------------------------------------------
18: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
19: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
20:
21: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
22: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 19: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

15: ------------------------------------------------------------------------------
16: -- GLOBAL CONSTANTS
17: ------------------------------------------------------------------------------
18: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
19: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
20:
21: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
22: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
23: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 21: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

17: ------------------------------------------------------------------------------
18: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
19: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
20:
21: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
22: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
23: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
24:
25: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

Line 22: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

18: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
19: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
20:
21: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
22: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
23: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
24:
25: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
26: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

Line 23: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

19: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
20:
21: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
22: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
23: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
24:
25: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
26: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
27: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

Line 235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

231: l_msg_data );
232:
233: if (l_return_status = G_RET_STS_UNEXP_ERROR) then
234: p_include_exp := 'N';
235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
236: end if;
237:
238: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
239: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,

Line 279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then

275:
276: x_return_status := l_return_status;
277:
278: Exception
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
280: x_return_status := G_RET_STS_UNEXP_ERROR;
281: When OTHERS then
282:
283: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 503: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'730: Leaving Update_Deviation_details : FND_API.G_EXC_UNEXPECTED_ERROR');

499: EXCEPTION
500: When OTHERS then
501:
502: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
503: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'730: Leaving Update_Deviation_details : FND_API.G_EXC_UNEXPECTED_ERROR');
504: END IF;
505: x_return_status := G_RET_STS_UNEXP_ERROR;
506: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
507: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

Line 547: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'810: Leaving remove_duplicate_deviations : FND_API.G_EXC_UNEXPECTED_ERROR');

543: EXCEPTION
544: When OTHERS then
545:
546: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
547: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'810: Leaving remove_duplicate_deviations : FND_API.G_EXC_UNEXPECTED_ERROR');
548: END IF;
549: x_return_status := G_RET_STS_UNEXP_ERROR;
550: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
551: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

Line 563: l_init_msg_list := FND_API.G_FALSE;

559:
560: l_compare_flag := 'N';
561: l_xprt_enabled := 'N';
562: x_include_exp := 'N';
563: l_init_msg_list := FND_API.G_FALSE;
564: l_api_version := 1;
565:
566: FND_MSG_PUB.initialize;
567: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

580: '310: return status for populate_template_articles is : '|| x_return_status);
581: END IF;
582:
583: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
585: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
586: RAISE FND_API.G_EXC_ERROR ;
587: END IF;
588:

Line 586: RAISE FND_API.G_EXC_ERROR ;

582:
583: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
585: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
586: RAISE FND_API.G_EXC_ERROR ;
587: END IF;
588:
589: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
590: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,

Line 608: l_xprt_enabled, -- FND_API.G_FALSE or G_TRUE

604: l_init_msg_list,
605: p_template_id,
606: p_doc_id,
607: p_doc_type,
608: l_xprt_enabled, -- FND_API.G_FALSE or G_TRUE
609: x_return_status,
610: x_msg_count,
611: x_msg_data
612: );

Line 620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

616: '314: XPRT Enabled on Template: '||l_xprt_enabled);
617: END IF;
618:
619: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
621: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
622: RAISE FND_API.G_EXC_ERROR ;
623: END IF;
624:

Line 622: RAISE FND_API.G_EXC_ERROR ;

618:
619: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
621: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
622: RAISE FND_API.G_EXC_ERROR ;
623: END IF;
624:
625: SELECT OKC_TERMS_DEVIATIONS_S1.nextval INTO l_seq_id from DUAL;
626:

Line 635: if (l_xprt_enabled = FND_API.G_TRUE) then

631: END IF;
632:
633: -- Bug #4115488
634:
635: if (l_xprt_enabled = FND_API.G_TRUE) then
636:
637: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
638: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
639: '318: Calling populate_expert_articles');

Line 656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

652: '320: value of x_include_exp is: '|| x_include_exp);
653: END IF;
654:
655: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
657: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
658: RAISE FND_API.G_EXC_ERROR ;
659: END IF;
660:

Line 658: RAISE FND_API.G_EXC_ERROR ;

654:
655: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
657: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
658: RAISE FND_API.G_EXC_ERROR ;
659: END IF;
660:
661: end if; -- end of xprt_enabled
662:

Line 1231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1227: p_doc_type,
1228: p_doc_id);
1229:
1230: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1232: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1233: RAISE FND_API.G_EXC_ERROR ;
1234: END IF;
1235:

Line 1233: RAISE FND_API.G_EXC_ERROR ;

1229:
1230: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1232: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1233: RAISE FND_API.G_EXC_ERROR ;
1234: END IF;
1235:
1236: end loop;
1237:

Line 1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1243: END IF;
1244:
1245: Update_deviation_details(x_return_status, l_seq_id);
1246: If (x_return_status = G_RET_STS_UNEXP_ERROR) then
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: End if;
1249:
1250: Remove_duplicate_deviations(x_return_status, l_seq_id);
1251: If (x_return_status = G_RET_STS_UNEXP_ERROR) then

Line 1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1248: End if;
1249:
1250: Remove_duplicate_deviations(x_return_status, l_seq_id);
1251: If (x_return_status = G_RET_STS_UNEXP_ERROR) then
1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1253: End if;
1254:
1255: p_run_id := l_seq_id;
1256:

Line 1261: WHEN FND_API.G_EXC_ERROR THEN

1257: x_return_status := G_RET_STS_SUCCESS;
1258: commit;
1259:
1260: EXCEPTION
1261: WHEN FND_API.G_EXC_ERROR THEN
1262: IF (dev_cat%ISOPEN) THEN
1263: CLOSE dev_cat;
1264: END IF;
1265:

Line 1267: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'100: Leaving Generate_deviations :FND_API.G_EXC_ERROR');

1263: CLOSE dev_cat;
1264: END IF;
1265:
1266: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1267: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'100: Leaving Generate_deviations :FND_API.G_EXC_ERROR');
1268: END IF;
1269: x_return_status := G_RET_STS_ERROR ;
1270:
1271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1267: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'100: Leaving Generate_deviations :FND_API.G_EXC_ERROR');
1268: END IF;
1269: x_return_status := G_RET_STS_ERROR ;
1270:
1271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1272: IF (dev_cat%ISOPEN) THEN
1273: CLOSE dev_cat;
1274: END IF;
1275:

Line 1277: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'200: Leaving Generate_Deviations : FND_API.G_EXC_UNEXPECTED_ERROR');

1273: CLOSE dev_cat;
1274: END IF;
1275:
1276: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1277: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'200: Leaving Generate_Deviations : FND_API.G_EXC_UNEXPECTED_ERROR');
1278: END IF;
1279: x_return_status := G_RET_STS_UNEXP_ERROR ;
1280: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1281: