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

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

10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.' || g_pkg_name || '.';
12: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
13:
14: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
15: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
16:
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

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

11: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.' || g_pkg_name || '.';
12: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
13:
14: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
15: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
16:
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

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

13:
14: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
15: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
16:
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
20:
21: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

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

14: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
15: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
16:
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
20:
21: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
22: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

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

15: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
16:
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
20:
21: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
22: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
23: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

Line 93: x_return_status := FND_API.G_RET_STS_SUCCESS;

89: l_parent_scn_id number;
90: l_grand_parent_id number;
91:
92: BEGIN
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
96: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
97: G_MODULE || l_api_name,

Line 222: p_commit => FND_API.G_FALSE,

218: If (Delete_Flag_tbl(l_sec_index) = 0) then
219: OKC_TERMS_SECTIONS_GRP.delete_section(
220: p_api_version => p_api_version,
221: p_init_msg_list => p_init_msg_list,
222: p_commit => FND_API.G_FALSE,
223: x_return_status => x_return_status,
224: x_msg_count => x_msg_count,
225: x_msg_data => x_msg_data,
226: p_mode => 'NORMAL',

Line 233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

229: p_object_version_number => OVN_tbl(l_sec_index)
230: );
231:
232: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
234: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
235: RAISE FND_API.G_EXC_ERROR ;
236: END IF;
237: l_section_deleted := 'Y';

Line 235: RAISE FND_API.G_EXC_ERROR ;

231:
232: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
234: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
235: RAISE FND_API.G_EXC_ERROR ;
236: END IF;
237: l_section_deleted := 'Y';
238:
239: End If;

Line 258: p_validate_commit => FND_API.G_FALSE,

254: p_init_msg_list => p_init_msg_list,
255: x_return_status => x_return_status,
256: x_msg_count => x_msg_count,
257: x_msg_data => x_msg_data,
258: p_validate_commit => FND_API.G_FALSE,
259: p_validation_string => NULL,
260: p_commit => FND_API.G_FALSE,
261: p_doc_type => p_document_type,
262: p_doc_id => p_document_id,

Line 260: p_commit => FND_API.G_FALSE,

256: x_msg_count => x_msg_count,
257: x_msg_data => x_msg_data,
258: p_validate_commit => FND_API.G_FALSE,
259: p_validation_string => NULL,
260: p_commit => FND_API.G_FALSE,
261: p_doc_type => p_document_type,
262: p_doc_id => p_document_id,
263: p_num_scheme_id => l_num_scheme_id
264: );

Line 267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

263: p_num_scheme_id => l_num_scheme_id
264: );
265:
266: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
268: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
269: RAISE FND_API.G_EXC_ERROR ;
270: END IF;
271: END IF; --l_num_scheme_id is not zero

Line 269: RAISE FND_API.G_EXC_ERROR ;

265:
266: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
268: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
269: RAISE FND_API.G_EXC_ERROR ;
270: END IF;
271: END IF; --l_num_scheme_id is not zero
272: END IF;
273:

Line 283: WHEN FND_API.G_EXC_ERROR THEN

279: END IF;
280:
281: EXCEPTION
282:
283: WHEN FND_API.G_EXC_ERROR THEN
284: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
285: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
286: G_MODULE || l_api_name,
287: '2000: Leaving ' || G_PKG_NAME || '.' || l_api_name);

Line 290: x_return_status := FND_API.G_RET_STS_ERROR ;

286: G_MODULE || l_api_name,
287: '2000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
288: END IF;
289:
290: x_return_status := FND_API.G_RET_STS_ERROR ;
291: FND_MSG_PUB.Count_And_Get(
292: p_count => x_msg_count,
293: p_data => x_msg_data
294: );

Line 296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

292: p_count => x_msg_count,
293: p_data => x_msg_data
294: );
295:
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
299: G_MODULE || l_api_name,
300: '3000: Leaving ' || G_PKG_NAME || '.' || l_api_name);

Line 303: x_return_status := FND_API.G_RET_STS_ERROR ;

299: G_MODULE || l_api_name,
300: '3000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
301: END IF;
302:
303: x_return_status := FND_API.G_RET_STS_ERROR ;
304: FND_MSG_PUB.Count_And_Get(
305: p_count => x_msg_count,
306: p_data => x_msg_data
307: );

Line 316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

312: G_MODULE || l_api_name,
313: '4000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
314: END IF;
315:
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
317:
318: IF FND_MSG_PUB.Check_Msg_Level
319: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
320: THEN

Line 408: x_return_status := FND_API.G_RET_STS_SUCCESS;

404: FROM aso_quote_headers
405: WHERE quote_header_id = p_document_id;
406:
407: BEGIN
408: x_return_status := FND_API.G_RET_STS_SUCCESS;
409:
410:
411: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
412: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 515: p_commit => FND_API.G_TRUE,

511: p_api_version => p_api_version,
512: x_return_status => x_return_status,
513: x_msg_data => x_msg_data,
514: x_msg_count => x_msg_count,
515: p_commit => FND_API.G_TRUE,
516: p_template_id => p_template_id,
517: p_target_doc_type => p_document_type,
518: p_target_doc_id => p_document_id,
519: p_article_effective_date => sysdate,

Line 524: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

520: p_validation_string => NULL
521: );
522:
523:
524: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
526: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
527: RAISE FND_API.G_EXC_ERROR ;
528: END IF;

Line 525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

521: );
522:
523:
524: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
526: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
527: RAISE FND_API.G_EXC_ERROR ;
528: END IF;
529: -- Begin: Added for bug 5344832

Line 526: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

522:
523:
524: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
526: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
527: RAISE FND_API.G_EXC_ERROR ;
528: END IF;
529: -- Begin: Added for bug 5344832
530: l_tmpl_id_for_bv := p_template_id;

Line 527: RAISE FND_API.G_EXC_ERROR ;

523:
524: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
526: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
527: RAISE FND_API.G_EXC_ERROR ;
528: END IF;
529: -- Begin: Added for bug 5344832
530: l_tmpl_id_for_bv := p_template_id;
531: ELSE

Line 598: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS OR l_cz_xml_init_msg IS NULL)

594: x_msg_data => x_msg_data,
595: x_msg_count => x_msg_count);
596:
597:
598: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS OR l_cz_xml_init_msg IS NULL)
599: THEN
600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
601: END IF;
602:

Line 600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

596:
597:
598: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS OR l_cz_xml_init_msg IS NULL)
599: THEN
600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
601: END IF;
602:
603: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
604: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 620: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS OR l_xml_terminate_msg IS NULL)

616: x_msg_data => x_msg_data,
617: x_msg_count => x_msg_count);
618:
619:
620: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS OR l_xml_terminate_msg IS NULL)
621: THEN
622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:

Line 622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

618:
619:
620: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS OR l_xml_terminate_msg IS NULL)
621: THEN
622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:
625: -- To parse x_cz_xml_terminate_msg and check if the CZ batch validate
626: -- was successful. If batch validate was successful, it would return

Line 646: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

642: x_return_status => x_return_status,
643: x_msg_data => x_msg_data,
644: x_msg_count => x_msg_count);
645:
646: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
647: THEN
648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
649: END IF;
650:

Line 648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

644: x_msg_count => x_msg_count);
645:
646: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
647: THEN
648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
649: END IF;
650:
651: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
652: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 672: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

668: x_msg_count => x_msg_count,
669: x_msg_data => x_msg_data
670: );
671:
672: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
673: THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676:

Line 674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

670: );
671:
672: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
673: THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676:
677: END IF; -- if l_expert_enabled is Yes
678:

Line 701: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

697: x_msg_count => x_msg_data,
698: x_msg_data => x_msg_data
699: );
700:
701: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
703: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
704: RAISE FND_API.G_EXC_ERROR ;
705: END IF;

Line 702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

698: x_msg_data => x_msg_data
699: );
700:
701: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
703: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
704: RAISE FND_API.G_EXC_ERROR ;
705: END IF;
706:

Line 703: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

699: );
700:
701: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
703: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
704: RAISE FND_API.G_EXC_ERROR ;
705: END IF;
706:
707:

Line 704: RAISE FND_API.G_EXC_ERROR ;

700:
701: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
703: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
704: RAISE FND_API.G_EXC_ERROR ;
705: END IF;
706:
707:
708: -- end debug log

Line 719: WHEN FND_API.G_EXC_ERROR THEN

715: COMMIT WORK;
716:
717: EXCEPTION
718:
719: WHEN FND_API.G_EXC_ERROR THEN
720: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
721: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
722: G_MODULE || l_api_name,
723: '2000: Leaving ' || G_PKG_NAME || '.' || l_api_name);

Line 726: x_return_status := FND_API.G_RET_STS_ERROR ;

722: G_MODULE || l_api_name,
723: '2000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
724: END IF;
725:
726: x_return_status := FND_API.G_RET_STS_ERROR ;
727: FND_MSG_PUB.Count_And_Get(
728: p_count => x_msg_count,
729: p_data => x_msg_data
730: );

Line 732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

728: p_count => x_msg_count,
729: p_data => x_msg_data
730: );
731:
732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
733: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
734: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
735: G_MODULE || l_api_name,
736: '3000: Leaving ' || G_PKG_NAME || '.' || l_api_name);

Line 739: x_return_status := FND_API.G_RET_STS_ERROR ;

735: G_MODULE || l_api_name,
736: '3000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
737: END IF;
738:
739: x_return_status := FND_API.G_RET_STS_ERROR ;
740: FND_MSG_PUB.Count_And_Get(
741: p_count => x_msg_count,
742: p_data => x_msg_data
743: );

Line 752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

748: G_MODULE || l_api_name,
749: '4000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
750: END IF;
751:
752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
753:
754: IF FND_MSG_PUB.Check_Msg_Level
755: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
756: THEN