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 STANDARD

Line 879: --to determine whether any non standard articles exists for the BSA or Sales Order

875:
876: END qa_articles;
877:
878:
879: --to determine whether any non standard articles exists for the BSA or Sales Order
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,

Line 880: --called from the approval workflow to determine whether non standard articles exist for the BSA or Sales Orders being approved

876: END qa_articles;
877:
878:
879: --to determine whether any non standard articles exists for the BSA or Sales Order
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,

Line 881: FUNCTION non_standard_article_exists

877:
878:
879: --to determine whether any non standard articles exists for the BSA or Sales Order
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,

Line 899: oe_debug_pub.add('In OE_Contracts_util.non_standard_article_exists ', 1);

895: l_article_type VARCHAR2(50);
896: BEGIN
897:
898: IF l_debug_level > 0 THEN
899: oe_debug_pub.add('In OE_Contracts_util.non_standard_article_exists ', 1);
900: oe_debug_pub.add('p_api_version: ' || p_api_version,3);
901: oe_debug_pub.add('p_init_msg_list: ' || p_init_msg_list,3);
902: oe_debug_pub.add('Calling OKC_TERMS_UTIL_GRP.is_article_exist',3);
903: oe_debug_pub.add('p_doc_type: ' || p_doc_type,3);

Line 912: oe_debug_pub.add('Contractual option not licensed, hence not performing non_standard_article_exists check ', 3);

908:
909: --Check for licensing
910: IF OE_Contracts_util.check_license() <> 'Y' THEN
911: IF l_debug_level > 0 THEN
912: oe_debug_pub.add('Contractual option not licensed, hence not performing non_standard_article_exists check ', 3);
913: END IF;
914: ---RETURN NULL;
915: RETURN 'N';
916: END IF;

Line 942: IF l_article_type = OKC_TERMS_UTIL_GRP.G_NON_STANDARD_ART_EXIST THEN --i.e. 'NON_STANDARD_EXIST'

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'
943: IF l_debug_level > 0 THEN
944: oe_debug_pub.add('End of OE_Contracts_util.non_standard_article_exists , returning Y');
945: END IF;
946: RETURN 'Y';

Line 944: oe_debug_pub.add('End of OE_Contracts_util.non_standard_article_exists , returning Y');

940: --ETR
941:
942: IF l_article_type = OKC_TERMS_UTIL_GRP.G_NON_STANDARD_ART_EXIST THEN --i.e. 'NON_STANDARD_EXIST'
943: IF l_debug_level > 0 THEN
944: oe_debug_pub.add('End of OE_Contracts_util.non_standard_article_exists , returning Y');
945: END IF;
946: RETURN 'Y';
947: ELSE
948: IF l_debug_level > 0 THEN

Line 949: oe_debug_pub.add('End of OE_Contracts_util.non_standard_article_exists , returning N');

945: END IF;
946: RETURN 'Y';
947: ELSE
948: IF l_debug_level > 0 THEN
949: oe_debug_pub.add('End of OE_Contracts_util.non_standard_article_exists , returning N');
950: END IF;
951: RETURN 'N';
952: END IF;
953:

Line 959: oe_debug_pub.add('WHEN G_EXC_ERROR in non_standard_article_exists ', 3);

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;
961:
962: x_return_status := FND_API.G_RET_STS_ERROR;
963:

Line 980: oe_debug_pub.add('WHEN G_EXC_UNEXPECTED_ERROR in non_standard_article_exists ', 3);

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;
982:
983: --close any cursors
984:

Line 1003: oe_debug_pub.add('WHEN OTHERS in non_standard_article_exists ', 3);

999:
1000:
1001: WHEN OTHERS THEN
1002: IF l_debug_level > 0 THEN
1003: oe_debug_pub.add('WHEN OTHERS in non_standard_article_exists ', 3);
1004: END IF;
1005:
1006: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1007: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

Line 1008: 'non_standard_article_exists'

1004: END IF;
1005:
1006: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
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:

Line 1020: END non_standard_article_exists;

1016: p_data => x_msg_data
1017: );
1018:
1019:
1020: END non_standard_article_exists;
1021:
1022:
1023: --workflow wrapper procedure for non_standard_article_exists()
1024: PROCEDURE WF_non_stndrd_article_exists (

Line 1023: --workflow wrapper procedure for non_standard_article_exists()

1019:
1020: END non_standard_article_exists;
1021:
1022:
1023: --workflow wrapper procedure for non_standard_article_exists()
1024: PROCEDURE WF_non_stndrd_article_exists (
1025: itemtype IN VARCHAR2,
1026: itemkey IN VARCHAR2,
1027: actid IN NUMBER,

Line 1031: l_non_standard_article_exists VARCHAR2(1);

1027: actid IN NUMBER,
1028: funcmode IN VARCHAR2,
1029: resultout OUT NOCOPY VARCHAR2) IS
1030:
1031: l_non_standard_article_exists VARCHAR2(1);
1032: l_doc_id NUMBER; -- header id of BSA or sales order
1033: l_sales_document_type_code VARCHAR2(30); -- i.e. either 'B' or 'O'
1034:
1035: l_api_version CONSTANT NUMBER := 1;

Line 1036: l_api_name CONSTANT VARCHAR2(30) := 'WF_non_standard_article_exists';

1032: l_doc_id NUMBER; -- header id of BSA or sales order
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:

Line 1046: oe_debug_pub.add( 'ENTERING WF_non_standard_article_exists',1) ;

1042:
1043: BEGIN
1044:
1045: IF l_debug_level > 0 THEN
1046: oe_debug_pub.add( 'ENTERING WF_non_standard_article_exists',1) ;
1047: END IF;
1048:
1049: OE_STANDARD_WF.Set_Msg_Context(actid);
1050:

Line 1049: OE_STANDARD_WF.Set_Msg_Context(actid);

1045: IF l_debug_level > 0 THEN
1046: oe_debug_pub.add( 'ENTERING WF_non_standard_article_exists',1) ;
1047: END IF;
1048:
1049: OE_STANDARD_WF.Set_Msg_Context(actid);
1050:
1051: --get the header id of the BSA
1052: --header_id is the itemkey of the workflow
1053: l_doc_id := to_number(itemkey);

Line 1064: oe_debug_pub.add('Calling non_standard_article_exists()',3);

1060: itemkey,
1061: 'SALES_DOCUMENT_TYPE_CODE');
1062: IF l_debug_level > 0 THEN
1063: oe_debug_pub.add('l_sales_document_type_code: ' || l_sales_document_type_code,3);
1064: oe_debug_pub.add('Calling non_standard_article_exists()',3);
1065: END IF;
1066:
1067:
1068:

Line 1069: l_non_standard_article_exists :=

1065: END IF;
1066:
1067:
1068:
1069: l_non_standard_article_exists :=
1070: non_standard_article_exists (
1071: p_api_version => l_api_version,
1072: p_doc_type => l_sales_document_type_code,
1073: p_doc_id => l_doc_id,

Line 1070: non_standard_article_exists (

1066:
1067:
1068:
1069: l_non_standard_article_exists :=
1070: non_standard_article_exists (
1071: p_api_version => l_api_version,
1072: p_doc_type => l_sales_document_type_code,
1073: p_doc_id => l_doc_id,
1074: x_return_status => lx_return_status,

Line 1081: oe_debug_pub.add('l_non_standard_article_exists: ' || l_non_standard_article_exists, 3);

1077: );
1078:
1079:
1080: IF l_debug_level > 0 THEN
1081: oe_debug_pub.add('l_non_standard_article_exists: ' || l_non_standard_article_exists, 3);
1082: oe_debug_pub.add('lx_return_status: ' || lx_return_status, 3);
1083: END IF;
1084:
1085:

Line 1087: resultout := 'COMPLETE:' || l_non_standard_article_exists; --'Y' or 'N'

1083: END IF;
1084:
1085:
1086: IF (funcmode = 'RUN') then
1087: resultout := 'COMPLETE:' || l_non_standard_article_exists; --'Y' or 'N'
1088: RETURN;
1089: END IF;
1090:
1091: IF (funcmode = 'CANCEL') THEN

Line 1109: 'WF_non_standard_article_exists',

1105: oe_debug_pub.add('In WHEN OTHERS: ', 3);
1106: END IF;
1107:
1108: wf_core.context('OE_CONTRACTS_UTIL',
1109: 'WF_non_standard_article_exists',
1110: itemtype,
1111: itemkey,
1112: to_char(actid),
1113: funcmode);

Line 2916: 'non_standard_article_exists'

2912: END IF;
2913:
2914: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2915: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2916: 'non_standard_article_exists'
2917: );
2918: END IF;
2919:
2920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;