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.OE_CONTRACTS_UTIL dependencies on FND_API

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

4: --ETR
5: ------------------------------------------------------------------------------
6: -- GLOBAL CONSTANTS
7: ------------------------------------------------------------------------------
8: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
9: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
10:
11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

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

5: ------------------------------------------------------------------------------
6: -- GLOBAL CONSTANTS
7: ------------------------------------------------------------------------------
8: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
9: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
10:
11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
13: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

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

7: ------------------------------------------------------------------------------
8: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
9: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
10:
11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
13: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
14:
15: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Contracts_Util';

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

8: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
9: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
10:
11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
13: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
14:
15: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Contracts_Util';
16: --ETR

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

9: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
10:
11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
13: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
14:
15: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Contracts_Util';
16: --ETR
17:

Line 133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

129: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
130: 'check_license'
131: );
132: END IF;
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134:
135: END check_license;
136:
137:

Line 143: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

139: --Copy Document Articles
140: PROCEDURE copy_articles
141: (
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144: p_commit IN VARCHAR2 := FND_API.G_FALSE,
145:
146: p_doc_type IN VARCHAR2,
147: p_copy_from_doc_id IN NUMBER,

Line 144: p_commit IN VARCHAR2 := FND_API.G_FALSE,

140: PROCEDURE copy_articles
141: (
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144: p_commit IN VARCHAR2 := FND_API.G_FALSE,
145:
146: p_doc_type IN VARCHAR2,
147: p_copy_from_doc_id IN NUMBER,
148: p_version_number IN VARCHAR2 DEFAULT NULL,

Line 175: x_return_status := FND_API.G_RET_STS_SUCCESS;

171: oe_debug_pub.add('In OE_Contracts_util.copy_articles ', 1);
172: END IF;
173:
174:
175: x_return_status := FND_API.G_RET_STS_SUCCESS;
176:
177: IF p_init_msg_list = FND_API.G_TRUE THEN
178: oe_msg_pub.initialize;
179: END IF;

Line 177: IF p_init_msg_list = FND_API.G_TRUE THEN

173:
174:
175: x_return_status := FND_API.G_RET_STS_SUCCESS;
176:
177: IF p_init_msg_list = FND_API.G_TRUE THEN
178: oe_msg_pub.initialize;
179: END IF;
180:
181:

Line 215: -----IF p_version_number = FND_API.G_MISS_CHAR THEN

211: END IF;
212:
213:
214:
215: -----IF p_version_number = FND_API.G_MISS_CHAR THEN
216: IF p_version_number IS NULL OR
217: p_version_number = l_latest_version_number THEN
218: --we are in the context of copying from a BSA or Sales Order to create a new BSA or Sales Order
219:

Line 258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

254: END IF;
255:
256: --ETR
257: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
259: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
260: RAISE FND_API.G_EXC_ERROR ;
261: END IF;
262: --ETR

Line 260: RAISE FND_API.G_EXC_ERROR ;

256: --ETR
257: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
259: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
260: RAISE FND_API.G_EXC_ERROR ;
261: END IF;
262: --ETR
263:
264: ELSIF p_version_number <> FND_API.G_MISS_CHAR AND

Line 264: ELSIF p_version_number <> FND_API.G_MISS_CHAR AND

260: RAISE FND_API.G_EXC_ERROR ;
261: END IF;
262: --ETR
263:
264: ELSIF p_version_number <> FND_API.G_MISS_CHAR AND
265: p_version_number <> l_latest_version_number THEN
266: --we are in the context of copying from an archived version of a BSA Sales Order to create a new BSA Sales Order
267:
268: IF l_debug_level > 0 THEN

Line 302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

298: END IF;
299:
300: --ETR
301: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
303: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
304: RAISE FND_API.G_EXC_ERROR ;
305: END IF;
306: --ETR

Line 304: RAISE FND_API.G_EXC_ERROR ;

300: --ETR
301: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
303: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
304: RAISE FND_API.G_EXC_ERROR ;
305: END IF;
306: --ETR
307:
308: END IF;

Line 316: WHEN FND_API.G_EXC_ERROR THEN

312: oe_debug_pub.add('End of OE_Contracts_util.copy_articles, x_return_status ' || x_return_status, 1);
313: END IF;
314:
315: EXCEPTION
316: WHEN FND_API.G_EXC_ERROR THEN
317:
318: IF l_debug_level > 0 THEN
319: oe_debug_pub.add('WHEN G_EXC_ERROR in copy_articles ', 3);
320: END IF;

Line 322: x_return_status := FND_API.G_RET_STS_ERROR;

318: IF l_debug_level > 0 THEN
319: oe_debug_pub.add('WHEN G_EXC_ERROR in copy_articles ', 3);
320: END IF;
321:
322: x_return_status := FND_API.G_RET_STS_ERROR;
323:
324: /*****
325: not needed as per meeting
326: --transfer error messages on OKC stack to OM stack

Line 337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

333: p_data => x_msg_data
334: );
335:
336:
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
338:
339: IF l_debug_level > 0 THEN
340: oe_debug_pub.add('WHEN G_EXC_UNEXPECTED_ERROR in copy_articles ', 3);
341: END IF;

Line 345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

341: END IF;
342:
343: --close any cursors
344:
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
346:
347: /*****
348: not needed as per meeting
349: --transfer error messages on OKC stack to OM stack

Line 366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

362: IF l_debug_level > 0 THEN
363: oe_debug_pub.add('WHEN OTHERS in copy_articles ', 3);
364: END IF;
365:
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
367:
368: /*****
369: not needed as per meeting
370: --transfer error messages on OKC stack to OM stack

Line 398: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

394: --Version articles of BSA or Sales Order
395: PROCEDURE version_articles
396: (
397: p_api_version IN NUMBER,
398: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
399: p_commit IN VARCHAR2 := FND_API.G_FALSE,
400:
401: p_doc_type IN VARCHAR2,
402: p_doc_id IN NUMBER,

Line 399: p_commit IN VARCHAR2 := FND_API.G_FALSE,

395: PROCEDURE version_articles
396: (
397: p_api_version IN NUMBER,
398: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
399: p_commit IN VARCHAR2 := FND_API.G_FALSE,
400:
401: p_doc_type IN VARCHAR2,
402: p_doc_id IN NUMBER,
403: p_version_number IN VARCHAR2,

Line 419: x_return_status := FND_API.G_RET_STS_SUCCESS;

415: IF l_debug_level > 0 THEN
416: oe_debug_pub.add('In OE_Contracts_util.version_articles ', 1);
417: END IF;
418:
419: x_return_status := FND_API.G_RET_STS_SUCCESS;
420:
421: IF p_init_msg_list = FND_API.G_TRUE THEN
422: oe_msg_pub.initialize;
423: END IF;

Line 421: IF p_init_msg_list = FND_API.G_TRUE THEN

417: END IF;
418:
419: x_return_status := FND_API.G_RET_STS_SUCCESS;
420:
421: IF p_init_msg_list = FND_API.G_TRUE THEN
422: oe_msg_pub.initialize;
423: END IF;
424:
425:

Line 464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

460: END IF;
461:
462: --ETR
463: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
465: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
466: RAISE FND_API.G_EXC_ERROR ;
467: END IF;
468: --ETR

Line 466: RAISE FND_API.G_EXC_ERROR ;

462: --ETR
463: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
465: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
466: RAISE FND_API.G_EXC_ERROR ;
467: END IF;
468: --ETR
469:
470: IF l_debug_level > 0 THEN

Line 475: WHEN FND_API.G_EXC_ERROR THEN

471: oe_debug_pub.add('End of OE_Contracts_util.version_articles , x_return_status ' || x_return_status, 1);
472: END IF;
473:
474: EXCEPTION
475: WHEN FND_API.G_EXC_ERROR THEN
476:
477: IF l_debug_level > 0 THEN
478: oe_debug_pub.add('WHEN G_EXC_ERROR in version_articles ', 3);
479: END IF;

Line 483: x_return_status := FND_API.G_RET_STS_ERROR;

479: END IF;
480:
481: --close any cursors
482:
483: x_return_status := FND_API.G_RET_STS_ERROR;
484:
485: /*****
486: not needed as per meeting
487: --transfer error messages on OKC stack to OM stack

Line 498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

494: p_data => x_msg_data
495: );
496:
497:
498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
499:
500: IF l_debug_level > 0 THEN
501: oe_debug_pub.add('WHEN G_EXC_UNEXPECTED_ERROR in version_articles ', 3);
502: END IF;

Line 506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

502: END IF;
503:
504: --close any cursors
505:
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
507:
508: /*****
509: not needed as per meeting
510: --transfer error messages on OKC stack to OM stack

Line 527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

523: IF l_debug_level > 0 THEN
524: oe_debug_pub.add('WHEN OTHERS in version_articles ', 3);
525: END IF;
526:
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
528:
529: /*****
530: not needed as per meeting
531: --transfer error messages on OKC stack to OM stack

Line 559: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

555: --perform QA checks upon the articles belonging to a BSA or Sales Order
556: PROCEDURE qa_articles
557: (
558: p_api_version IN NUMBER,
559: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
560: p_commit IN VARCHAR2 := FND_API.G_FALSE,
561:
562: p_qa_mode IN VARCHAR2 := OKC_TERMS_QA_GRP.G_NORMAL_QA,
563: p_doc_type IN VARCHAR2,

Line 560: p_commit IN VARCHAR2 := FND_API.G_FALSE,

556: PROCEDURE qa_articles
557: (
558: p_api_version IN NUMBER,
559: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
560: p_commit IN VARCHAR2 := FND_API.G_FALSE,
561:
562: p_qa_mode IN VARCHAR2 := OKC_TERMS_QA_GRP.G_NORMAL_QA,
563: p_doc_type IN VARCHAR2,
564: p_doc_id IN NUMBER,

Line 593: x_return_status := FND_API.G_RET_STS_SUCCESS;

589: IF l_debug_level > 0 THEN
590: oe_debug_pub.add('In OE_Contracts_util.qa_articles ', 1);
591: END IF;
592:
593: x_return_status := FND_API.G_RET_STS_SUCCESS;
594:
595: IF p_init_msg_list = FND_API.G_TRUE THEN
596: oe_msg_pub.initialize;
597: END IF;

Line 595: IF p_init_msg_list = FND_API.G_TRUE THEN

591: END IF;
592:
593: x_return_status := FND_API.G_RET_STS_SUCCESS;
594:
595: IF p_init_msg_list = FND_API.G_TRUE THEN
596: oe_msg_pub.initialize;
597: END IF;
598:
599:

Line 634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

630: END IF;
631:
632: --ETR
633: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
635: END IF;
636: --ETR
637:
638: IF l_order_signed = 'Y' THEN

Line 673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

669: END IF;
670:
671: --ETR
672: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
674: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
675: RAISE FND_API.G_EXC_ERROR ;
676: END IF;
677: --ETR

Line 675: RAISE FND_API.G_EXC_ERROR ;

671: --ETR
672: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
674: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
675: RAISE FND_API.G_EXC_ERROR ;
676: END IF;
677: --ETR
678:
679: IF l_article_exist <> OKC_TERMS_UTIL_GRP.G_NO_ARTICLE_EXIST THEN --i.e. 'NONE'

Line 698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

694: x_msg_data => x_msg_data
695: );
696:
697: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
699: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
700: RAISE FND_API.G_EXC_ERROR ;
701: END IF;
702:

Line 700: RAISE FND_API.G_EXC_ERROR ;

696:
697: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
699: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
700: RAISE FND_API.G_EXC_ERROR ;
701: END IF;
702:
703:
704: IF l_debug_level > 0 THEN

Line 754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

750: END IF;
751:
752: --ETR
753: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
755: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
756: RAISE FND_API.G_EXC_ERROR ;
757: END IF;
758: --ETR

Line 756: RAISE FND_API.G_EXC_ERROR ;

752: --ETR
753: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
755: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
756: RAISE FND_API.G_EXC_ERROR ;
757: END IF;
758: --ETR
759:
760: IF l_debug_level > 0 THEN

Line 799: WHEN FND_API.G_EXC_ERROR THEN

795: oe_debug_pub.add('End of OE_Contracts_util.qa_articles , x_return_status ' || x_return_status, 1);
796: END IF;
797:
798: EXCEPTION
799: WHEN FND_API.G_EXC_ERROR THEN
800:
801: IF l_debug_level > 0 THEN
802: oe_debug_pub.add('WHEN G_EXC_ERROR in qa_articles ', 3);
803: END IF;

Line 807: x_return_status := FND_API.G_RET_STS_ERROR;

803: END IF;
804:
805: --close any cursors
806:
807: x_return_status := FND_API.G_RET_STS_ERROR;
808:
809: /*****
810: not needed as per meeting
811: --transfer error messages on OKC stack to OM stack

Line 822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

818: p_data => x_msg_data
819: );
820:
821:
822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
823:
824: IF l_debug_level > 0 THEN
825: oe_debug_pub.add('WHEN G_EXC_UNEXPECTED_ERROR in qa_articles ', 3);
826: END IF;

Line 830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

826: END IF;
827:
828: --close any cursors
829:
830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
831:
832:
833: /*****
834: not needed as per meeting

Line 852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

848: IF l_debug_level > 0 THEN
849: oe_debug_pub.add('WHEN OTHERS in qa_articles ', 3);
850: END IF;
851:
852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
853:
854:
855: /*****
856: not needed as per meeting

Line 884: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

880: --called from the approval workflow to determine whether non standard articles exist for the BSA or Sales Orders being approved
881: FUNCTION non_standard_article_exists
882: (
883: p_api_version IN NUMBER,
884: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
885: p_commit IN VARCHAR2 := FND_API.G_FALSE,
886: p_doc_type IN VARCHAR2,
887: p_doc_id IN NUMBER,
888: x_return_status OUT NOCOPY VARCHAR2,

Line 885: p_commit IN VARCHAR2 := FND_API.G_FALSE,

881: FUNCTION non_standard_article_exists
882: (
883: p_api_version IN NUMBER,
884: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
885: p_commit IN VARCHAR2 := FND_API.G_FALSE,
886: p_doc_type IN VARCHAR2,
887: p_doc_id IN NUMBER,
888: x_return_status OUT NOCOPY VARCHAR2,
889: x_msg_count OUT NOCOPY NUMBER,

Line 907: x_return_status := FND_API.G_RET_STS_SUCCESS;

903: oe_debug_pub.add('p_doc_type: ' || p_doc_type,3);
904: oe_debug_pub.add('p_doc_id: ' || p_doc_id,3);
905: END IF;
906:
907: x_return_status := FND_API.G_RET_STS_SUCCESS;
908:
909: --Check for licensing
910: IF OE_Contracts_util.check_license() <> 'Y' THEN
911: IF l_debug_level > 0 THEN

Line 936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

932: END IF;
933:
934: --ETR
935: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
937: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
938: RAISE FND_API.G_EXC_ERROR ;
939: END IF;
940: --ETR

Line 938: RAISE FND_API.G_EXC_ERROR ;

934: --ETR
935: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
937: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
938: RAISE FND_API.G_EXC_ERROR ;
939: END IF;
940: --ETR
941:
942: IF l_article_type = OKC_TERMS_UTIL_GRP.G_NON_STANDARD_ART_EXIST THEN --i.e. 'NON_STANDARD_EXIST'

Line 956: WHEN FND_API.G_EXC_ERROR THEN

952: END IF;
953:
954:
955: EXCEPTION
956: WHEN FND_API.G_EXC_ERROR THEN
957:
958: IF l_debug_level > 0 THEN
959: oe_debug_pub.add('WHEN G_EXC_ERROR in non_standard_article_exists ', 3);
960: END IF;

Line 962: x_return_status := FND_API.G_RET_STS_ERROR;

958: IF l_debug_level > 0 THEN
959: oe_debug_pub.add('WHEN G_EXC_ERROR in non_standard_article_exists ', 3);
960: END IF;
961:
962: x_return_status := FND_API.G_RET_STS_ERROR;
963:
964: /*****
965: not needed as per meeting
966: --transfer error messages on OKC stack to OM stack

Line 977: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

973: p_data => x_msg_data
974: );
975:
976:
977: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
978:
979: IF l_debug_level > 0 THEN
980: oe_debug_pub.add('WHEN G_EXC_UNEXPECTED_ERROR in non_standard_article_exists ', 3);
981: END IF;

Line 985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

981: END IF;
982:
983: --close any cursors
984:
985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
986:
987: /*****
988: not needed as per meeting
989: --transfer error messages on OKC stack to OM stack

Line 1011: -----RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1007: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1008: 'non_standard_article_exists'
1009: );
1010: END IF;
1011: -----RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1012:
1013: --Get message count and data
1014: OE_MSG_PUB.Count_And_Get (
1015: p_count => x_msg_count,

Line 1037: lx_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1033: l_sales_document_type_code VARCHAR2(30); -- i.e. either 'B' or 'O'
1034:
1035: l_api_version CONSTANT NUMBER := 1;
1036: l_api_name CONSTANT VARCHAR2(30) := 'WF_non_standard_article_exists';
1037: lx_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1038: lx_msg_count NUMBER := 0;
1039: lx_msg_data VARCHAR2(2000);
1040:
1041: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1128: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1124: to the OM entity or contract entity attachment representing the BSA/Sales Order. */
1125: PROCEDURE attachment_location
1126: (
1127: p_api_version IN NUMBER,
1128: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1129:
1130: p_doc_type IN VARCHAR2,
1131: p_doc_id IN NUMBER,
1132:

Line 1198: x_return_status := FND_API.G_RET_STS_SUCCESS;

1194: oe_debug_pub.add('p_doc_type: '|| p_doc_type, 3);
1195: oe_debug_pub.add('p_doc_id: '|| p_doc_id, 3);
1196: END IF;
1197:
1198: x_return_status := FND_API.G_RET_STS_SUCCESS;
1199:
1200: IF p_init_msg_list = FND_API.G_TRUE THEN
1201: oe_msg_pub.initialize;
1202: END IF;

Line 1200: IF p_init_msg_list = FND_API.G_TRUE THEN

1196: END IF;
1197:
1198: x_return_status := FND_API.G_RET_STS_SUCCESS;
1199:
1200: IF p_init_msg_list = FND_API.G_TRUE THEN
1201: oe_msg_pub.initialize;
1202: END IF;
1203:
1204: --Check for licensing, proceed with procesing only if licensed

Line 1328: WHEN FND_API.G_EXC_ERROR THEN

1324: x_workflow_string := l_workflow_string;
1325:
1326:
1327: EXCEPTION
1328: WHEN FND_API.G_EXC_ERROR THEN
1329:
1330: IF l_debug_level > 0 THEN
1331: oe_debug_pub.add('WHEN OTHERS in attachment_location ', 3);
1332: END IF;

Line 1349: x_return_status := FND_API.G_RET_STS_ERROR;

1345: END IF;
1346: ********/
1347:
1348:
1349: x_return_status := FND_API.G_RET_STS_ERROR;
1350:
1351: /*****
1352: not needed as per meeting
1353: --transfer error messages on OKC stack to OM stack

Line 1364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1360: p_data => x_msg_data
1361: );
1362:
1363:
1364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1365:
1366: IF l_debug_level > 0 THEN
1367: oe_debug_pub.add('WHEN G_EXC_UNEXPECTED_ERROR in attachment_location ', 3);
1368: END IF;

Line 1384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1380: CLOSE c_get_so_version;
1381: END IF;
1382: ********/
1383:
1384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1385:
1386: /*****
1387: not needed as per meeting
1388: --transfer error messages on OKC stack to OM stack

Line 1419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1415: CLOSE c_get_so_version;
1416: END IF;
1417: ********/
1418:
1419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1420:
1421: /*****
1422: not needed as per meeting
1423: --transfer error messages on OKC stack to OM stack

Line 1553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1549: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1550: 'terms_exists'
1551: );
1552: END IF;
1553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1554:
1555:
1556: END terms_exists;
1557:

Line 1564: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1560: --delete articles belonging to the BSA or Sales Order
1561: PROCEDURE delete_articles
1562: (
1563: p_api_version IN NUMBER,
1564: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1565: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1566:
1567: p_doc_type IN VARCHAR2,
1568: p_doc_id IN NUMBER,

Line 1565: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1561: PROCEDURE delete_articles
1562: (
1563: p_api_version IN NUMBER,
1564: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1565: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1566:
1567: p_doc_type IN VARCHAR2,
1568: p_doc_id IN NUMBER,
1569:

Line 1583: x_return_status := FND_API.G_RET_STS_SUCCESS;

1579: IF l_debug_level > 0 THEN
1580: oe_debug_pub.add('In OE_Contracts_util.delete_articles ', 1);
1581: END IF;
1582:
1583: x_return_status := FND_API.G_RET_STS_SUCCESS;
1584:
1585: IF p_init_msg_list = FND_API.G_TRUE THEN
1586: oe_msg_pub.initialize;
1587: END IF;

Line 1585: IF p_init_msg_list = FND_API.G_TRUE THEN

1581: END IF;
1582:
1583: x_return_status := FND_API.G_RET_STS_SUCCESS;
1584:
1585: IF p_init_msg_list = FND_API.G_TRUE THEN
1586: oe_msg_pub.initialize;
1587: END IF;
1588:
1589: --Check for licensing

Line 1625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1621: END IF;
1622:
1623: --ETR
1624: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1626: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1627: RAISE FND_API.G_EXC_ERROR ;
1628: END IF;
1629: --ETR

Line 1627: RAISE FND_API.G_EXC_ERROR ;

1623: --ETR
1624: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1626: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1627: RAISE FND_API.G_EXC_ERROR ;
1628: END IF;
1629: --ETR
1630:
1631: IF l_debug_level > 0 THEN

Line 1636: WHEN FND_API.G_EXC_ERROR THEN

1632: oe_debug_pub.add('End of OE_Contracts_util.delete_articles, x_return_status ' || x_return_status, 1);
1633: END IF;
1634:
1635: EXCEPTION
1636: WHEN FND_API.G_EXC_ERROR THEN
1637:
1638: IF l_debug_level > 0 THEN
1639: oe_debug_pub.add('WHEN G_EXC_ERROR in delete_articles ', 3);
1640: END IF;

Line 1644: x_return_status := FND_API.G_RET_STS_ERROR;

1640: END IF;
1641:
1642: --close any cursors
1643:
1644: x_return_status := FND_API.G_RET_STS_ERROR;
1645:
1646: /*****
1647: not needed as per meeting
1648: --transfer error messages on OKC stack to OM stack

Line 1659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1655: p_data => x_msg_data
1656: );
1657:
1658:
1659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1660:
1661: IF l_debug_level > 0 THEN
1662: oe_debug_pub.add('WHEN G_EXC_UNEXPECTED_ERROR in delete_articles ', 3);
1663: END IF;

Line 1667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1663: END IF;
1664:
1665: --close any cursors
1666:
1667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1668:
1669: /*****
1670: not needed as per meeting
1671: --transfer error messages on OKC stack to OM stack

Line 1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1684: IF l_debug_level > 0 THEN
1685: oe_debug_pub.add('WHEN OTHERS in delete_articles ', 3);
1686: END IF;
1687:
1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1689:
1690: /*****
1691: not needed as per meeting
1692: --transfer error messages on OKC stack to OM stack

Line 1717: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1713: --purge articles belonging to the BSA's or Sales Orders
1714: PROCEDURE purge_articles
1715: (
1716: p_api_version IN NUMBER,
1717: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1718: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1719:
1720: p_doc_tbl IN doc_tbl_type,
1721:

Line 1718: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1714: PROCEDURE purge_articles
1715: (
1716: p_api_version IN NUMBER,
1717: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1718: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1719:
1720: p_doc_tbl IN doc_tbl_type,
1721:
1722: x_return_status OUT NOCOPY VARCHAR2,

Line 1735: x_return_status := FND_API.G_RET_STS_SUCCESS;

1731: IF l_debug_level > 0 THEN
1732: oe_debug_pub.add('In OE_Contracts_util.purge_articles ', 1);
1733: END IF;
1734:
1735: x_return_status := FND_API.G_RET_STS_SUCCESS;
1736:
1737: IF p_init_msg_list = FND_API.G_TRUE THEN
1738: oe_msg_pub.initialize;
1739: END IF;

Line 1737: IF p_init_msg_list = FND_API.G_TRUE THEN

1733: END IF;
1734:
1735: x_return_status := FND_API.G_RET_STS_SUCCESS;
1736:
1737: IF p_init_msg_list = FND_API.G_TRUE THEN
1738: oe_msg_pub.initialize;
1739: END IF;
1740:
1741: --Check for licensing

Line 1774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1770: END IF;
1771:
1772: --ETR
1773: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1775: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1776: RAISE FND_API.G_EXC_ERROR ;
1777: END IF;
1778: --ETR

Line 1776: RAISE FND_API.G_EXC_ERROR ;

1772: --ETR
1773: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1775: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1776: RAISE FND_API.G_EXC_ERROR ;
1777: END IF;
1778: --ETR
1779:
1780: IF l_debug_level > 0 THEN

Line 1785: WHEN FND_API.G_EXC_ERROR THEN

1781: oe_debug_pub.add('End of OE_Contracts_util.purge_articles, x_return_status ' || x_return_status, 1);
1782: END IF;
1783:
1784: EXCEPTION
1785: WHEN FND_API.G_EXC_ERROR THEN
1786:
1787: IF l_debug_level > 0 THEN
1788: oe_debug_pub.add('WHEN G_EXC_ERROR in purge_articles ', 3);
1789: END IF;

Line 1793: x_return_status := FND_API.G_RET_STS_ERROR;

1789: END IF;
1790:
1791: --close any cursors
1792:
1793: x_return_status := FND_API.G_RET_STS_ERROR;
1794:
1795: /*****
1796: not needed as per meeting
1797: --transfer error messages on OKC stack to OM stack

Line 1808: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1804: p_data => x_msg_data
1805: );
1806:
1807:
1808: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1809:
1810: IF l_debug_level > 0 THEN
1811: oe_debug_pub.add('WHEN G_EXC_UNEXPECTED_ERROR in purge_articles ', 3);
1812: END IF;

Line 1816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1812: END IF;
1813:
1814: --close any cursors
1815:
1816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1817:
1818: /*****
1819: not needed as per meeting
1820: --transfer error messages on OKC stack to OM stack

Line 1837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1833: IF l_debug_level > 0 THEN
1834: oe_debug_pub.add('WHEN OTHERS in purge_articles ', 3);
1835: END IF;
1836:
1837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1838:
1839: /*****
1840: not needed as per meeting
1841: --transfer error messages on OKC stack to OM stack

Line 1865: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1861:
1862: PROCEDURE get_article_variable_values
1863: (
1864: p_api_version IN NUMBER,
1865: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1866: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1867:
1868: p_doc_type IN VARCHAR2,
1869: p_doc_id IN NUMBER,

Line 1866: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1862: PROCEDURE get_article_variable_values
1863: (
1864: p_api_version IN NUMBER,
1865: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1866: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1867:
1868: p_doc_type IN VARCHAR2,
1869: p_doc_id IN NUMBER,
1870: p_sys_var_value_tbl IN OUT NOCOPY sys_var_value_tbl_type,

Line 1947: x_return_status := FND_API.G_RET_STS_SUCCESS;

1943: oe_debug_pub.add('p_doc_type: ' || p_doc_type,3);
1944: oe_debug_pub.add('p_doc_id: ' || p_doc_id,3);
1945: END IF;
1946:
1947: x_return_status := FND_API.G_RET_STS_SUCCESS;
1948:
1949: IF p_init_msg_list = FND_API.G_TRUE THEN
1950: oe_msg_pub.initialize;
1951: END IF;

Line 1949: IF p_init_msg_list = FND_API.G_TRUE THEN

1945: END IF;
1946:
1947: x_return_status := FND_API.G_RET_STS_SUCCESS;
1948:
1949: IF p_init_msg_list = FND_API.G_TRUE THEN
1950: oe_msg_pub.initialize;
1951: END IF;
1952:
1953:

Line 2202: WHEN FND_API.G_EXC_ERROR THEN

2198: END IF;
2199:
2200:
2201: EXCEPTION
2202: WHEN FND_API.G_EXC_ERROR THEN
2203:
2204: IF l_debug_level > 0 THEN
2205: oe_debug_pub.add('WHEN G_EXC_ERROR in get_article_variable_values ', 3);
2206: END IF;

Line 2213: x_return_status := FND_API.G_RET_STS_ERROR;

2209: IF c_get_bsa_header_variables%ISOPEN THEN
2210: CLOSE c_get_bsa_header_variables;
2211: END IF;
2212:
2213: x_return_status := FND_API.G_RET_STS_ERROR;
2214:
2215: /*****
2216: not needed as per meeting
2217: --transfer error messages on OKC stack to OM stack

Line 2228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2224: p_data => x_msg_data
2225: );
2226:
2227:
2228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2229:
2230: IF l_debug_level > 0 THEN
2231: oe_debug_pub.add('WHEN G_EXC_UNEXPECTED_ERROR in get_article_variable_values ', 3);
2232: END IF;

Line 2239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2235: IF c_get_bsa_header_variables%ISOPEN THEN
2236: CLOSE c_get_bsa_header_variables;
2237: END IF;
2238:
2239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2240:
2241: /*****
2242: not needed as per meeting
2243: --transfer error messages on OKC stack to OM stack

Line 2264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2260: IF c_get_bsa_header_variables%ISOPEN THEN
2261: CLOSE c_get_bsa_header_variables;
2262: END IF;
2263:
2264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2265:
2266: /*****
2267: not needed as per meeting
2268: --transfer error messages on OKC stack to OM stack

Line 2295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2291: --this overloaded signature is called from the contract expert
2292: PROCEDURE get_article_variable_values
2293: (
2294: p_api_version IN NUMBER,
2295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2296: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2297:
2298: p_doc_type IN VARCHAR2,
2299: p_doc_id IN NUMBER,

Line 2296: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2292: PROCEDURE get_article_variable_values
2293: (
2294: p_api_version IN NUMBER,
2295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2296: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2297:
2298: p_doc_type IN VARCHAR2,
2299: p_doc_id IN NUMBER,
2300: p_line_var_tbl IN line_var_tbl_type,

Line 2395: x_return_status := FND_API.G_RET_STS_SUCCESS;

2391: oe_debug_pub.add('p_line_var_tbl.COUNT: ' || p_line_var_tbl.COUNT, 1);
2392: END IF;
2393:
2394:
2395: x_return_status := FND_API.G_RET_STS_SUCCESS;
2396:
2397: IF p_init_msg_list = FND_API.G_TRUE THEN
2398: oe_msg_pub.initialize;
2399: END IF;

Line 2397: IF p_init_msg_list = FND_API.G_TRUE THEN

2393:
2394:
2395: x_return_status := FND_API.G_RET_STS_SUCCESS;
2396:
2397: IF p_init_msg_list = FND_API.G_TRUE THEN
2398: oe_msg_pub.initialize;
2399: END IF;
2400:
2401:

Line 2542: WHEN FND_API.G_EXC_ERROR THEN

2538: oe_debug_pub.add('End of OE_Contracts_util.get_article_variable_values for line level variables, x_return_status: '|| x_return_status, 1);
2539: END IF;
2540:
2541: EXCEPTION
2542: WHEN FND_API.G_EXC_ERROR THEN
2543:
2544: IF l_debug_level > 0 THEN
2545: oe_debug_pub.add('WHEN G_EXC_ERROR in get_article_variable_values ', 3);
2546: END IF;

Line 2553: x_return_status := FND_API.G_RET_STS_ERROR;

2549: IF c_get_derived_item_category%ISOPEN THEN
2550: CLOSE c_get_derived_item_category;
2551: END IF;
2552:
2553: x_return_status := FND_API.G_RET_STS_ERROR;
2554:
2555: /*****
2556: not needed as per meeting
2557: --transfer error messages on OKC stack to OM stack

Line 2569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2565: p_data => x_msg_data
2566: );
2567:
2568:
2569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2570:
2571: IF l_debug_level > 0 THEN
2572: oe_debug_pub.add('WHEN G_EXC_UNEXPECTED_ERROR in get_article_variable_values ', 3);
2573: END IF;

Line 2580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2576: IF c_get_derived_item_category%ISOPEN THEN
2577: CLOSE c_get_derived_item_category;
2578: END IF;
2579:
2580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2581:
2582: /*****
2583: not needed as per meeting
2584: --transfer error messages on OKC stack to OM stack

Line 2606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2602: IF c_get_derived_item_category%ISOPEN THEN
2603: CLOSE c_get_derived_item_category;
2604: END IF;
2605:
2606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2607:
2608: /*****
2609: not needed as per meeting
2610: --transfer error messages on OKC stack to OM stack

Line 2638: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2634: --to return details about an article template being used by a particular BSA or Sales Order
2635: PROCEDURE get_terms_template
2636: (
2637: p_api_version IN NUMBER,
2638: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2639: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2640:
2641: p_doc_type IN VARCHAR2,
2642: p_doc_id IN NUMBER,

Line 2639: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2635: PROCEDURE get_terms_template
2636: (
2637: p_api_version IN NUMBER,
2638: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2639: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2640:
2641: p_doc_type IN VARCHAR2,
2642: p_doc_id IN NUMBER,
2643:

Line 2663: x_return_status := FND_API.G_RET_STS_SUCCESS;

2659: IF l_debug_level > 0 THEN
2660: oe_debug_pub.add('In OE_Contracts_util.get_terms_template ', 1);
2661: END IF;
2662:
2663: x_return_status := FND_API.G_RET_STS_SUCCESS;
2664:
2665: IF p_init_msg_list = FND_API.G_TRUE THEN
2666: oe_msg_pub.initialize;
2667: END IF;

Line 2665: IF p_init_msg_list = FND_API.G_TRUE THEN

2661: END IF;
2662:
2663: x_return_status := FND_API.G_RET_STS_SUCCESS;
2664:
2665: IF p_init_msg_list = FND_API.G_TRUE THEN
2666: oe_msg_pub.initialize;
2667: END IF;
2668:
2669: --Check for licensing

Line 2709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2705: END IF;
2706:
2707: --ETR
2708: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2710: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2711: RAISE FND_API.G_EXC_ERROR ;
2712: END IF;
2713: --ETR

Line 2711: RAISE FND_API.G_EXC_ERROR ;

2707: --ETR
2708: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2710: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2711: RAISE FND_API.G_EXC_ERROR ;
2712: END IF;
2713: --ETR
2714:
2715: IF l_debug_level > 0 THEN

Line 2720: WHEN FND_API.G_EXC_ERROR THEN

2716: oe_debug_pub.add('End of OE_Contracts_util.get_terms_template , x_return_status ' || x_return_status, 1);
2717: END IF;
2718:
2719: EXCEPTION
2720: WHEN FND_API.G_EXC_ERROR THEN
2721:
2722: IF l_debug_level > 0 THEN
2723: oe_debug_pub.add('WHEN G_EXC_ERROR in get_terms_template ', 3);
2724: END IF;

Line 2726: x_return_status := FND_API.G_RET_STS_ERROR;

2722: IF l_debug_level > 0 THEN
2723: oe_debug_pub.add('WHEN G_EXC_ERROR in get_terms_template ', 3);
2724: END IF;
2725:
2726: x_return_status := FND_API.G_RET_STS_ERROR;
2727:
2728: /*****
2729: not needed as per meeting
2730: --transfer error messages on OKC stack to OM stack

Line 2741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2737: p_data => x_msg_data
2738: );
2739:
2740:
2741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2742:
2743: IF l_debug_level > 0 THEN
2744: oe_debug_pub.add('WHEN G_EXC_UNEXPECTED_ERROR in get_terms_template ', 3);
2745: END IF;

Line 2749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2745: END IF;
2746:
2747: --close any cursors
2748:
2749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2750:
2751: /*****
2752: not needed as per meeting
2753: --transfer error messages on OKC stack to OM stack

Line 2770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2766: IF l_debug_level > 0 THEN
2767: oe_debug_pub.add('WHEN OTHERS in get_terms_template ', 3);
2768: END IF;
2769:
2770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2771:
2772: /*****
2773: not needed as per meeting
2774: --transfer error messages on OKC stack to OM stack

Line 2800: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2796:
2797: /* Gets the name of a contract template. It does not have to be instantiated against anything. */
2798: FUNCTION Get_Template_Name(
2799: p_api_version IN NUMBER,
2800: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2801: p_template_id IN NUMBER,
2802:
2803: x_return_status OUT NOCOPY VARCHAR2,
2804: x_msg_data OUT NOCOPY VARCHAR2,

Line 2823: x_return_status := FND_API.G_RET_STS_SUCCESS;

2819: oe_debug_pub.add('Calling OKC_TERMS_UTIL_GRP.Get_Template_Name',3);
2820: oe_debug_pub.add('p_tempate_id: ' || p_template_id,3);
2821: END IF;
2822:
2823: x_return_status := FND_API.G_RET_STS_SUCCESS;
2824:
2825: --Check for licensing
2826: IF OE_Contracts_util.check_license() <> 'Y' THEN
2827: IF l_debug_level > 0 THEN

Line 2851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2847: END IF;
2848:
2849: --ETR
2850: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2852: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2853: RAISE FND_API.G_EXC_ERROR ;
2854: END IF;
2855: --ETR

Line 2853: RAISE FND_API.G_EXC_ERROR ;

2849: --ETR
2850: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2852: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2853: RAISE FND_API.G_EXC_ERROR ;
2854: END IF;
2855: --ETR
2856:
2857: IF l_debug_level > 0 THEN

Line 2865: WHEN FND_API.G_EXC_ERROR THEN

2861: RETURN l_template_name;
2862:
2863:
2864: EXCEPTION
2865: WHEN FND_API.G_EXC_ERROR THEN
2866:
2867: IF l_debug_level > 0 THEN
2868: oe_debug_pub.add('WHEN G_EXC_ERROR in Get_Template_Name ', 3);
2869: END IF;

Line 2871: x_return_status := FND_API.G_RET_STS_ERROR;

2867: IF l_debug_level > 0 THEN
2868: oe_debug_pub.add('WHEN G_EXC_ERROR in Get_Template_Name ', 3);
2869: END IF;
2870:
2871: x_return_status := FND_API.G_RET_STS_ERROR;
2872:
2873: /*****
2874: not needed as per meeting
2875: --transfer error messages on OKC stack to OM stack

Line 2886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2882: p_data => x_msg_data
2883: );
2884:
2885:
2886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2887:
2888: IF l_debug_level > 0 THEN
2889: oe_debug_pub.add('WHEN G_EXC_UNEXPECTED_ERROR in Get_Template_Name ', 3);
2890: END IF;

Line 2894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2890: END IF;
2891:
2892: --close any cursors
2893:
2894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2895:
2896: /*****
2897: not needed as per meeting
2898: --transfer error messages on OKC stack to OM stack

Line 2920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2916: 'non_standard_article_exists'
2917: );
2918: END IF;
2919:
2920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2921:
2922: --Get message count and data
2923: OE_MSG_PUB.Count_And_Get (
2924: p_count => x_msg_count,

Line 2938: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2934: --used internally by instantiate_doc_terms
2935: PROCEDURE instantiate_terms
2936: (
2937: p_api_version IN NUMBER,
2938: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2939: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2940:
2941: p_template_id IN NUMBER,
2942: p_doc_type IN VARCHAR2,

Line 2939: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2935: PROCEDURE instantiate_terms
2936: (
2937: p_api_version IN NUMBER,
2938: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2939: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2940:
2941: p_template_id IN NUMBER,
2942: p_doc_type IN VARCHAR2,
2943: p_doc_id IN NUMBER,

Line 2961: x_return_status := FND_API.G_RET_STS_SUCCESS;

2957: IF l_debug_level > 0 THEN
2958: oe_debug_pub.add('In OE_Contracts_util.instantiate_terms ', 1);
2959: END IF;
2960:
2961: x_return_status := FND_API.G_RET_STS_SUCCESS;
2962:
2963: IF p_init_msg_list = FND_API.G_TRUE THEN
2964: oe_msg_pub.initialize;
2965: END IF;

Line 2963: IF p_init_msg_list = FND_API.G_TRUE THEN

2959: END IF;
2960:
2961: x_return_status := FND_API.G_RET_STS_SUCCESS;
2962:
2963: IF p_init_msg_list = FND_API.G_TRUE THEN
2964: oe_msg_pub.initialize;
2965: END IF;
2966:
2967: --Check for licensing

Line 3011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3007: END IF;
3008:
3009: --ETR
3010: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3012: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3013: RAISE FND_API.G_EXC_ERROR ;
3014: END IF;
3015: --ETR

Line 3013: RAISE FND_API.G_EXC_ERROR ;

3009: --ETR
3010: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3012: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3013: RAISE FND_API.G_EXC_ERROR ;
3014: END IF;
3015: --ETR
3016:
3017: IF l_debug_level > 0 THEN

Line 3022: WHEN FND_API.G_EXC_ERROR THEN

3018: oe_debug_pub.add('End of OE_Contracts_util.instantiate_terms , x_return_status ' || x_return_status, 1);
3019: END IF;
3020:
3021: EXCEPTION
3022: WHEN FND_API.G_EXC_ERROR THEN
3023:
3024: IF l_debug_level > 0 THEN
3025: oe_debug_pub.add('WHEN G_EXC_ERROR in instantiate_terms ', 3);
3026: END IF;

Line 3028: x_return_status := FND_API.G_RET_STS_ERROR;

3024: IF l_debug_level > 0 THEN
3025: oe_debug_pub.add('WHEN G_EXC_ERROR in instantiate_terms ', 3);
3026: END IF;
3027:
3028: x_return_status := FND_API.G_RET_STS_ERROR;
3029:
3030: /*****
3031: not needed as per meeting
3032: --transfer error messages on OKC stack to OM stack

Line 3043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3039: p_data => x_msg_data
3040: );
3041:
3042:
3043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3044:
3045: IF l_debug_level > 0 THEN
3046: oe_debug_pub.add('WHEN G_EXC_UNEXPECTED_ERROR in instantiate_terms ', 3);
3047: END IF;

Line 3051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3047: END IF;
3048:
3049: --close any cursors
3050:
3051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3052:
3053: /*****
3054: not needed as per meeting
3055: --transfer error messages on OKC stack to OM stack

Line 3072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3068: IF l_debug_level > 0 THEN
3069: oe_debug_pub.add('WHEN OTHERS in instantiate_terms ', 3);
3070: END IF;
3071:
3072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3073:
3074: /*****
3075: not needed as per meeting
3076: --transfer error messages on OKC stack to OM stack

Line 3103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3099: --the contract template id is defaulted for a new BSA or Sales Order
3100: PROCEDURE instantiate_doc_terms
3101: (
3102: p_api_version IN NUMBER,
3103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3104: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3105:
3106: p_template_id IN NUMBER,
3107: p_doc_type IN VARCHAR2,

Line 3104: p_commit IN VARCHAR2 := FND_API.G_FALSE,

3100: PROCEDURE instantiate_doc_terms
3101: (
3102: p_api_version IN NUMBER,
3103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3104: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3105:
3106: p_template_id IN NUMBER,
3107: p_doc_type IN VARCHAR2,
3108: p_doc_id IN NUMBER,

Line 3130: x_return_status := FND_API.G_RET_STS_SUCCESS;

3126: IF l_debug_level > 0 THEN
3127: oe_debug_pub.add('In OE_Contracts_util.instantiate_doc_terms ', 1);
3128: END IF;
3129:
3130: x_return_status := FND_API.G_RET_STS_SUCCESS;
3131:
3132: IF p_init_msg_list = FND_API.G_TRUE THEN
3133: oe_msg_pub.initialize;
3134: END IF;

Line 3132: IF p_init_msg_list = FND_API.G_TRUE THEN

3128: END IF;
3129:
3130: x_return_status := FND_API.G_RET_STS_SUCCESS;
3131:
3132: IF p_init_msg_list = FND_API.G_TRUE THEN
3133: oe_msg_pub.initialize;
3134: END IF;
3135:
3136: --Check for licensing

Line 3171: p_init_msg_list => FND_API.G_FALSE,

3167:
3168: --first determine whether any terms and conditions have been instantiated for the BSA or Sales Order
3169: oe_contracts_util.get_terms_template (
3170: p_api_version => 1.0,
3171: p_init_msg_list => FND_API.G_FALSE,
3172: p_commit => FND_API.G_FALSE,
3173:
3174: p_doc_type => p_doc_type,
3175: p_doc_id => p_doc_id,

Line 3172: p_commit => FND_API.G_FALSE,

3168: --first determine whether any terms and conditions have been instantiated for the BSA or Sales Order
3169: oe_contracts_util.get_terms_template (
3170: p_api_version => 1.0,
3171: p_init_msg_list => FND_API.G_FALSE,
3172: p_commit => FND_API.G_FALSE,
3173:
3174: p_doc_type => p_doc_type,
3175: p_doc_id => p_doc_id,
3176:

Line 3200: p_init_msg_list => FND_API.G_FALSE,

3196: END IF;
3197:
3198: oe_contracts_util.instantiate_terms (
3199: p_api_version => 1.0,
3200: p_init_msg_list => FND_API.G_FALSE,
3201: p_commit => FND_API.G_TRUE, --important: need to save before invoking articles UI
3202:
3203: p_template_id => p_template_id,
3204: p_doc_type => p_doc_type,

Line 3201: p_commit => FND_API.G_TRUE, --important: need to save before invoking articles UI

3197:
3198: oe_contracts_util.instantiate_terms (
3199: p_api_version => 1.0,
3200: p_init_msg_list => FND_API.G_FALSE,
3201: p_commit => FND_API.G_TRUE, --important: need to save before invoking articles UI
3202:
3203: p_template_id => p_template_id,
3204: p_doc_type => p_doc_type,
3205: p_doc_id => p_doc_id,

Line 3233: WHEN FND_API.G_EXC_ERROR THEN

3229: oe_debug_pub.add('End of OE_Contracts_util.instantiate_doc_terms , x_return_status ' || x_return_status, 1);
3230: END IF;
3231:
3232: EXCEPTION
3233: WHEN FND_API.G_EXC_ERROR THEN
3234:
3235: IF l_debug_level > 0 THEN
3236: oe_debug_pub.add('WHEN G_EXC_ERROR in instantiate_doc_terms ', 3);
3237: END IF;

Line 3239: x_return_status := FND_API.G_RET_STS_ERROR;

3235: IF l_debug_level > 0 THEN
3236: oe_debug_pub.add('WHEN G_EXC_ERROR in instantiate_doc_terms ', 3);
3237: END IF;
3238:
3239: x_return_status := FND_API.G_RET_STS_ERROR;
3240:
3241: /*****
3242: not needed as per meeting
3243: --transfer error messages on OKC stack to OM stack

Line 3254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3250: p_data => x_msg_data
3251: );
3252:
3253:
3254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3255:
3256: IF l_debug_level > 0 THEN
3257: oe_debug_pub.add('WHEN G_EXC_UNEXPECTED_ERROR in instantiate_doc_terms ', 3);
3258: END IF;

Line 3262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3258: END IF;
3259:
3260: --close any cursors
3261:
3262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3263:
3264: /*****
3265: not needed as per meeting
3266: --transfer error messages on OKC stack to OM stack

Line 3283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3279: IF l_debug_level > 0 THEN
3280: oe_debug_pub.add('WHEN OTHERS in instantiate_doc_terms ', 3);
3281: END IF;
3282:
3283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3284:
3285: /*****
3286: not needed as per meeting
3287: --transfer error messages on OKC stack to OM stack

Line 3316: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3312: --This function is to check whether or not the given order has already been
3313: --accepted (i.e signed). Returns 'Y' if accepted, and 'N' otherwise.
3314: FUNCTION Is_order_signed(
3315: p_api_version IN NUMBER,
3316: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3317:
3318: x_return_status OUT NOCOPY VARCHAR2,
3319: x_msg_data OUT NOCOPY VARCHAR2,
3320: x_msg_count OUT NOCOPY NUMBER,

Line 3345: IF p_init_msg_list = FND_API.G_TRUE THEN

3341: IF (l_debug_level > 0) THEN
3342: oe_debug_pub.add('In OE_Contracts_util.is_order_signed', 2);
3343: END IF;
3344: -- Initialize message list if p_init_msg_list is set to TRUE.
3345: IF p_init_msg_list = FND_API.G_TRUE THEN
3346: oe_msg_pub.initialize;
3347: END IF;
3348: -- Initialize API return status to success
3349: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3349: x_return_status := FND_API.G_RET_STS_SUCCESS;

3345: IF p_init_msg_list = FND_API.G_TRUE THEN
3346: oe_msg_pub.initialize;
3347: END IF;
3348: -- Initialize API return status to success
3349: x_return_status := FND_API.G_RET_STS_SUCCESS;
3350: IF l_debug_level > 0 THEN
3351: oe_debug_pub.add('Fetching customer_signature and customer_signature_date from oe_order_headers_all ', 3);
3352: oe_debug_pub.add('p_api_version: ' || p_api_version,3);
3353: oe_debug_pub.add('p_init_msg_list: ' || p_init_msg_list,3);

Line 3442: x_return_status := FND_API.G_RET_STS_SUCCESS;

3438: IF l_debug_level > 0 THEN
3439: oe_debug_pub.add('In OE_Contracts_util.copy_doc ', 1);
3440: END IF;
3441:
3442: x_return_status := FND_API.G_RET_STS_SUCCESS;
3443:
3444: IF p_init_msg_list = FND_API.G_TRUE THEN
3445: oe_msg_pub.initialize;
3446: END IF;

Line 3444: IF p_init_msg_list = FND_API.G_TRUE THEN

3440: END IF;
3441:
3442: x_return_status := FND_API.G_RET_STS_SUCCESS;
3443:
3444: IF p_init_msg_list = FND_API.G_TRUE THEN
3445: oe_msg_pub.initialize;
3446: END IF;
3447:
3448: --Check contract Licence

Line 3513: IF x_return_status = FND_API.G_RET_STS_ERROR Then

3509: x_msg_count => x_msg_count,
3510: x_msg_data => x_msg_data);
3511:
3512:
3513: IF x_return_status = FND_API.G_RET_STS_ERROR Then
3514: RAISE FND_API.G_EXC_ERROR;
3515: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3517: END IF;

Line 3514: RAISE FND_API.G_EXC_ERROR;

3510: x_msg_data => x_msg_data);
3511:
3512:
3513: IF x_return_status = FND_API.G_RET_STS_ERROR Then
3514: RAISE FND_API.G_EXC_ERROR;
3515: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3517: END IF;
3518:

Line 3515: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3511:
3512:
3513: IF x_return_status = FND_API.G_RET_STS_ERROR Then
3514: RAISE FND_API.G_EXC_ERROR;
3515: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3517: END IF;
3518:
3519: End If;

Line 3516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3512:
3513: IF x_return_status = FND_API.G_RET_STS_ERROR Then
3514: RAISE FND_API.G_EXC_ERROR;
3515: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3517: END IF;
3518:
3519: End If;
3520: ELSE

Line 3566: IF x_return_status = FND_API.G_RET_STS_ERROR Then

3562: x_msg_count => x_msg_count,
3563: p_copy_abstract_yn => 'Y');
3564:
3565:
3566: IF x_return_status = FND_API.G_RET_STS_ERROR Then
3567: RAISE FND_API.G_EXC_ERROR;
3568: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3570: END IF;

Line 3567: RAISE FND_API.G_EXC_ERROR;

3563: p_copy_abstract_yn => 'Y');
3564:
3565:
3566: IF x_return_status = FND_API.G_RET_STS_ERROR Then
3567: RAISE FND_API.G_EXC_ERROR;
3568: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3570: END IF;
3571:

Line 3568: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3564:
3565:
3566: IF x_return_status = FND_API.G_RET_STS_ERROR Then
3567: RAISE FND_API.G_EXC_ERROR;
3568: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3570: END IF;
3571:
3572:

Line 3569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3565:
3566: IF x_return_status = FND_API.G_RET_STS_ERROR Then
3567: RAISE FND_API.G_EXC_ERROR;
3568: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3570: END IF;
3571:
3572:
3573: END IF;

Line 3581: WHEN FND_API.G_EXC_ERROR THEN

3577: End If;
3578:
3579:
3580: EXCEPTION
3581: WHEN FND_API.G_EXC_ERROR THEN
3582:
3583: IF l_debug_level > 0 THEN
3584: oe_debug_pub.add('WHEN G_EXC_ERROR in copy_doc ', 3);
3585: END IF;

Line 3591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3587: OE_MSG_PUB.Count_And_Get (
3588: p_count => x_msg_count,
3589: p_data => x_msg_data);
3590:
3591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3592:
3593: IF l_debug_level > 0 THEN
3594: oe_debug_pub.add('WHEN G_EXC_UNEXPECTED_ERROR in copy_doc ', 3);
3595: END IF;

Line 3608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3604: IF l_debug_level > 0 THEN
3605: oe_debug_pub.add('WHEN OTHERS in copy_doc ', 3);
3606: END IF;
3607:
3608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3609:
3610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3611: OE_MSG_PUB.Add_Exc_Msg (
3612: G_PKG_NAME,

Line 3684: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3680: IF l_debug_level > 0 THEN
3681: oe_debug_pub.add('Return status from OE_LINE_UTIL.GET_ITEM_INFO is '||l_return_status) ;
3682: END IF;
3683:
3684: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3686: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3687: RAISE FND_API.G_EXC_ERROR;
3688: END IF;

Line 3685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3681: oe_debug_pub.add('Return status from OE_LINE_UTIL.GET_ITEM_INFO is '||l_return_status) ;
3682: END IF;
3683:
3684: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3686: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3687: RAISE FND_API.G_EXC_ERROR;
3688: END IF;
3689:

Line 3686: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3682: END IF;
3683:
3684: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3686: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3687: RAISE FND_API.G_EXC_ERROR;
3688: END IF;
3689:
3690: IF p_item_or_desc = 'I' THEN

Line 3687: RAISE FND_API.G_EXC_ERROR;

3683:
3684: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3686: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3687: RAISE FND_API.G_EXC_ERROR;
3688: END IF;
3689:
3690: IF p_item_or_desc = 'I' THEN
3691: l_value := l_inventory_item;

Line 3707: WHEN FND_API.G_EXC_ERROR THEN

3703:
3704: RETURN l_value;
3705:
3706: EXCEPTION
3707: WHEN FND_API.G_EXC_ERROR THEN
3708: IF l_debug_level > 0 THEN
3709: oe_debug_pub.add('In oe_contracts_util.get_item_info:g_exc_error section') ;
3710: END IF;
3711: RAISE FND_API.G_EXC_ERROR;

Line 3711: RAISE FND_API.G_EXC_ERROR;

3707: WHEN FND_API.G_EXC_ERROR THEN
3708: IF l_debug_level > 0 THEN
3709: oe_debug_pub.add('In oe_contracts_util.get_item_info:g_exc_error section') ;
3710: END IF;
3711: RAISE FND_API.G_EXC_ERROR;
3712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3713: IF l_debug_level > 0 THEN
3714: oe_debug_pub.add('In oe_contracts_util.get_item_info:g_exc_unexpected_error section') ;
3715: END IF;

Line 3712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3708: IF l_debug_level > 0 THEN
3709: oe_debug_pub.add('In oe_contracts_util.get_item_info:g_exc_error section') ;
3710: END IF;
3711: RAISE FND_API.G_EXC_ERROR;
3712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3713: IF l_debug_level > 0 THEN
3714: oe_debug_pub.add('In oe_contracts_util.get_item_info:g_exc_unexpected_error section') ;
3715: END IF;
3716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3713: IF l_debug_level > 0 THEN
3714: oe_debug_pub.add('In oe_contracts_util.get_item_info:g_exc_unexpected_error section') ;
3715: END IF;
3716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3717: WHEN OTHERS THEN
3718: IF l_debug_level > 0 THEN
3719: oe_debug_pub.add('In oe_contracts_util.get_item_info: when others section') ;
3720: END IF;

Line 3725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3721: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3722: THEN
3723: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'GET_ITEM_INFO');
3724: END IF;
3725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3726: END GET_ITEM_INFO;
3727:
3728: --FP word integration
3729: PROCEDURE get_contract_defaults

Line 3732: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3728: --FP word integration
3729: PROCEDURE get_contract_defaults
3730: (
3731: p_api_version IN NUMBER,
3732: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3733: p_doc_type IN VARCHAR2,
3734: p_template_id IN NUMBER,
3735: x_authoring_party OUT NOCOPY VARCHAR2,
3736: x_contract_source OUT NOCOPY VARCHAR2,

Line 3753: x_return_status := FND_API.G_RET_STS_SUCCESS;

3749: IF l_debug_level > 0 THEN
3750: oe_debug_pub.add('In OE_Contracts_util.get_contract_defaults ', 1);
3751: END IF;
3752:
3753: x_return_status := FND_API.G_RET_STS_SUCCESS;
3754:
3755: IF p_init_msg_list = FND_API.G_TRUE THEN
3756: oe_msg_pub.initialize;
3757: END IF;

Line 3755: IF p_init_msg_list = FND_API.G_TRUE THEN

3751: END IF;
3752:
3753: x_return_status := FND_API.G_RET_STS_SUCCESS;
3754:
3755: IF p_init_msg_list = FND_API.G_TRUE THEN
3756: oe_msg_pub.initialize;
3757: END IF;
3758:
3759: --Check for licensing

Line 3802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3798: oe_debug_pub.add('x_return_status: '|| x_return_status, 3);
3799: END IF;
3800:
3801: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3803: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3804: RAISE FND_API.G_EXC_ERROR ;
3805: END IF;
3806:

Line 3804: RAISE FND_API.G_EXC_ERROR ;

3800:
3801: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3803: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3804: RAISE FND_API.G_EXC_ERROR ;
3805: END IF;
3806:
3807: IF l_debug_level > 0 THEN
3808: oe_debug_pub.add('End of OE_Contracts_util.get_contract_defaults , x_return_status ' || x_return_status, 1);

Line 3812: WHEN FND_API.G_EXC_ERROR THEN

3808: oe_debug_pub.add('End of OE_Contracts_util.get_contract_defaults , x_return_status ' || x_return_status, 1);
3809: END IF;
3810:
3811: EXCEPTION
3812: WHEN FND_API.G_EXC_ERROR THEN
3813:
3814: IF l_debug_level > 0 THEN
3815: oe_debug_pub.add('WHEN G_EXC_ERROR in get_contract_defaults ', 3);
3816: END IF;

Line 3818: x_return_status := FND_API.G_RET_STS_ERROR;

3814: IF l_debug_level > 0 THEN
3815: oe_debug_pub.add('WHEN G_EXC_ERROR in get_contract_defaults ', 3);
3816: END IF;
3817:
3818: x_return_status := FND_API.G_RET_STS_ERROR;
3819:
3820: --Get message count and data
3821: OE_MSG_PUB.Count_And_Get (
3822: p_count => x_msg_count,

Line 3827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3823: p_data => x_msg_data
3824: );
3825:
3826:
3827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3828:
3829: IF l_debug_level > 0 THEN
3830: oe_debug_pub.add('WHEN G_EXC_UNEXPECTED_ERROR in get_contract_defaults ', 3);
3831: END IF;

Line 3835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3831: END IF;
3832:
3833: --close any cursors
3834:
3835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3836:
3837: --Get message count and data
3838: OE_MSG_PUB.Count_And_Get (
3839: p_count => x_msg_count,

Line 3850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3846: IF l_debug_level > 0 THEN
3847: oe_debug_pub.add('WHEN OTHERS in get_contract_defaults ', 3);
3848: END IF;
3849:
3850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3851:
3852: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3853: OE_MSG_PUB.Add_Exc_Msg (
3854: G_PKG_NAME,

Line 3873: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3869: --get the template name, id, source and authoring party for the doc id
3870: PROCEDURE get_contract_details_all
3871: (
3872: p_api_version IN NUMBER,
3873: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3874: p_doc_type IN VARCHAR2,
3875: p_doc_id IN NUMBER,
3876: p_document_version IN NUMBER := NULL,
3877: x_template_id OUT NOCOPY NUMBER,

Line 3905: x_return_status := FND_API.G_RET_STS_SUCCESS;

3901: IF l_debug_level > 0 THEN
3902: oe_debug_pub.add('In OE_Contracts_util.get_contract_details_all ', 1);
3903: END IF;
3904:
3905: x_return_status := FND_API.G_RET_STS_SUCCESS;
3906:
3907: IF p_init_msg_list = FND_API.G_TRUE THEN
3908: oe_msg_pub.initialize;
3909: END IF;

Line 3907: IF p_init_msg_list = FND_API.G_TRUE THEN

3903: END IF;
3904:
3905: x_return_status := FND_API.G_RET_STS_SUCCESS;
3906:
3907: IF p_init_msg_list = FND_API.G_TRUE THEN
3908: oe_msg_pub.initialize;
3909: END IF;
3910:
3911: --Check for licensing

Line 3967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3963: oe_debug_pub.add('x_return_status: '|| x_return_status, 3);
3964: END IF;
3965:
3966: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3968: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3969: RAISE FND_API.G_EXC_ERROR ;
3970: END IF;
3971:

Line 3969: RAISE FND_API.G_EXC_ERROR ;

3965:
3966: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3968: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3969: RAISE FND_API.G_EXC_ERROR ;
3970: END IF;
3971:
3972: IF l_debug_level > 0 THEN
3973: oe_debug_pub.add('End of OE_Contracts_util.get_contract_details_all , x_return_status ' || x_return_status, 1);

Line 3977: WHEN FND_API.G_EXC_ERROR THEN

3973: oe_debug_pub.add('End of OE_Contracts_util.get_contract_details_all , x_return_status ' || x_return_status, 1);
3974: END IF;
3975:
3976: EXCEPTION
3977: WHEN FND_API.G_EXC_ERROR THEN
3978:
3979: IF l_debug_level > 0 THEN
3980: oe_debug_pub.add('WHEN G_EXC_ERROR in get_contract_details_all ', 3);
3981: END IF;

Line 3983: x_return_status := FND_API.G_RET_STS_ERROR;

3979: IF l_debug_level > 0 THEN
3980: oe_debug_pub.add('WHEN G_EXC_ERROR in get_contract_details_all ', 3);
3981: END IF;
3982:
3983: x_return_status := FND_API.G_RET_STS_ERROR;
3984:
3985: --Get message count and data
3986: OE_MSG_PUB.Count_And_Get (
3987: p_count => x_msg_count,

Line 3992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3988: p_data => x_msg_data
3989: );
3990:
3991:
3992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3993:
3994: IF l_debug_level > 0 THEN
3995: oe_debug_pub.add('WHEN G_EXC_UNEXPECTED_ERROR in get_contract_details_all ', 3);
3996: END IF;

Line 4000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3996: END IF;
3997:
3998: --close any cursors
3999:
4000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4001:
4002: --Get message count and data
4003: OE_MSG_PUB.Count_And_Get (
4004: p_count => x_msg_count,

Line 4015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4011: IF l_debug_level > 0 THEN
4012: oe_debug_pub.add('WHEN OTHERS in get_contract_details_all ', 3);
4013: END IF;
4014:
4015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4016:
4017: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4018: OE_MSG_PUB.Add_Exc_Msg (
4019: G_PKG_NAME,

Line 4040: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4036: --check if template attached to order type is valid or not
4037: Function Is_Terms_Template_Valid
4038: (
4039: p_api_version IN NUMBER,
4040: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4041: x_return_status OUT NOCOPY VARCHAR2,
4042: x_msg_count OUT NOCOPY NUMBER,
4043: x_msg_data OUT NOCOPY VARCHAR2,
4044: p_doc_type IN VARCHAR2,

Line 4058: x_return_status := FND_API.G_RET_STS_SUCCESS;

4054: IF l_debug_level > 0 THEN
4055: oe_debug_pub.add('In OE_Contracts_util.Is_Terms_Template_Valid ', 1);
4056: END IF;
4057:
4058: x_return_status := FND_API.G_RET_STS_SUCCESS;
4059:
4060: IF p_init_msg_list = FND_API.G_TRUE THEN
4061: oe_msg_pub.initialize;
4062: END IF;

Line 4060: IF p_init_msg_list = FND_API.G_TRUE THEN

4056: END IF;
4057:
4058: x_return_status := FND_API.G_RET_STS_SUCCESS;
4059:
4060: IF p_init_msg_list = FND_API.G_TRUE THEN
4061: oe_msg_pub.initialize;
4062: END IF;
4063:
4064: --Check for licensing

Line 4101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4097: oe_debug_pub.add(' l_result: '|| l_result, 3);
4098: END IF;
4099:
4100: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4102: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4103: RAISE FND_API.G_EXC_ERROR ;
4104: END IF;
4105:

Line 4103: RAISE FND_API.G_EXC_ERROR ;

4099:
4100: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4102: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4103: RAISE FND_API.G_EXC_ERROR ;
4104: END IF;
4105:
4106: IF l_debug_level > 0 THEN
4107: oe_debug_pub.add('End of OE_Contracts_util.Is_Terms_Template_Valid , x_return_status ' || x_return_status, 1);

Line 4113: WHEN FND_API.G_EXC_ERROR THEN

4109:
4110: RETURN l_result;
4111:
4112: EXCEPTION
4113: WHEN FND_API.G_EXC_ERROR THEN
4114:
4115: IF l_debug_level > 0 THEN
4116: oe_debug_pub.add('WHEN G_EXC_ERROR in Is_Terms_Template_Valid ', 3);
4117: END IF;

Line 4119: x_return_status := FND_API.G_RET_STS_ERROR;

4115: IF l_debug_level > 0 THEN
4116: oe_debug_pub.add('WHEN G_EXC_ERROR in Is_Terms_Template_Valid ', 3);
4117: END IF;
4118:
4119: x_return_status := FND_API.G_RET_STS_ERROR;
4120:
4121: --Get message count and data
4122: OE_MSG_PUB.Count_And_Get (
4123: p_count => x_msg_count,

Line 4128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4124: p_data => x_msg_data
4125: );
4126:
4127:
4128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4129:
4130: IF l_debug_level > 0 THEN
4131: oe_debug_pub.add('WHEN G_EXC_UNEXPECTED_ERROR in Is_Terms_Template_Valid ', 3);
4132: END IF;

Line 4136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4132: END IF;
4133:
4134: --close any cursors
4135:
4136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4137:
4138: --Get message count and data
4139: OE_MSG_PUB.Count_And_Get (
4140: p_count => x_msg_count,

Line 4151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4147: IF l_debug_level > 0 THEN
4148: oe_debug_pub.add('WHEN OTHERS in Is_Terms_Template_Valid ', 3);
4149: END IF;
4150:
4151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4152:
4153: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4154: OE_MSG_PUB.Add_Exc_Msg (
4155: G_PKG_NAME,

Line 4228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4224: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4225: 'Is_Auth_Party_Internal'
4226: );
4227: END IF;
4228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4229:
4230: END Is_Auth_Party_Internal;
4231:
4232: --Function to check if Recurring Charges is Enabled, required by Preview and Print

Line 4288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4284: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4285: 'Is_RChg_Enabled'
4286: );
4287: END IF;
4288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4289:
4290: END Is_RChg_Enabled;
4291:
4292: END OE_Contracts_util;