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

Line 34: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

30:
31:
32: PROCEDURE ok_to_commit(
33: p_api_version IN NUMBER,
34: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
35: p_doctype_id IN VARCHAR2,
36: p_doc_id IN NUMBER,
37: x_update_allowed OUT NOCOPY VARCHAR2,
38: x_return_status OUT NOCOPY VARCHAR2,

Line 48: x_update_allowed := fnd_api.g_false;

44: l_auction_header_id pon_auction_headers_all.auction_header_id%type;
45: l_auction_status pon_auction_headers_all.auction_status%type;
46: BEGIN
47: -- Initialize API return status to unexpected error
48: x_update_allowed := fnd_api.g_false;
49: x_return_status := fnd_api.g_ret_sts_unexp_error;
50: x_msg_data := 'pon_conterms_utl_grp.ok_to_commit() unexpected error';
51: x_msg_count := 1;
52:

Line 49: x_return_status := fnd_api.g_ret_sts_unexp_error;

45: l_auction_status pon_auction_headers_all.auction_status%type;
46: BEGIN
47: -- Initialize API return status to unexpected error
48: x_update_allowed := fnd_api.g_false;
49: x_return_status := fnd_api.g_ret_sts_unexp_error;
50: x_msg_data := 'pon_conterms_utl_grp.ok_to_commit() unexpected error';
51: x_msg_count := 1;
52:
53: -- Standard call to check for call compatibility.

Line 54: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

50: x_msg_data := 'pon_conterms_utl_grp.ok_to_commit() unexpected error';
51: x_msg_count := 1;
52:
53: -- Standard call to check for call compatibility.
54: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
55: l_api_name, l_api_name) THEN
56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: END IF;
58:

Line 56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

52:
53: -- Standard call to check for call compatibility.
54: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
55: l_api_name, l_api_name) THEN
56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: END IF;
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 60: IF FND_API.to_Boolean(p_init_msg_list) THEN

56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: END IF;
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.to_Boolean(p_init_msg_list) THEN
61: FND_MSG_PUB.initialize();
62: END IF;
63:
64: -- get auction_header_id

Line 71: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

67: l_auction_header_id,
68: x_return_status,
69: x_msg_data,
70: x_msg_count);
71: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
72: return ;
73: END IF;
74:
75: -- check whether the current user holds the lock on the draft

Line 110: x_update_allowed := fnd_api.g_false;

106: and auction.trading_partner_id = company_parties.party_id
107: and auction.auction_status = 'DRAFT';
108: EXCEPTION
109: WHEN no_data_found THEN
110: x_update_allowed := fnd_api.g_false;
111: x_return_status := fnd_api.g_ret_sts_success;
112: x_msg_data := 'pon_conterms_utl_grp.ok_to_commit() - user doesn''t have lock for draft: ' || l_auction_header_id;
113: x_msg_count := 1;
114: return;

Line 111: x_return_status := fnd_api.g_ret_sts_success;

107: and auction.auction_status = 'DRAFT';
108: EXCEPTION
109: WHEN no_data_found THEN
110: x_update_allowed := fnd_api.g_false;
111: x_return_status := fnd_api.g_ret_sts_success;
112: x_msg_data := 'pon_conterms_utl_grp.ok_to_commit() - user doesn''t have lock for draft: ' || l_auction_header_id;
113: x_msg_count := 1;
114: return;
115: END;

Line 117: x_update_allowed := fnd_api.g_true;

113: x_msg_count := 1;
114: return;
115: END;
116:
117: x_update_allowed := fnd_api.g_true;
118: x_return_status := fnd_api.g_ret_sts_success;
119: x_msg_data := 'Success!';
120: x_msg_count := 1;
121: END ok_to_commit;

Line 118: x_return_status := fnd_api.g_ret_sts_success;

114: return;
115: END;
116:
117: x_update_allowed := fnd_api.g_true;
118: x_return_status := fnd_api.g_ret_sts_success;
119: x_msg_data := 'Success!';
120: x_msg_count := 1;
121: END ok_to_commit;
122:

Line 151: * FND_API.G_RET_STS_ERROR - for expected error

147: * x_msg_data
148: * message data
149: * x_return_status
150: * Status Returned to calling API. Possible values are following
151: * FND_API.G_RET_STS_ERROR - for expected error
152: * FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
153: * FND_API.G_RET_STS_SUCCESS - for success
154: */
155: PROCEDURE get_article_variable_values(

Line 152: * FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

148: * message data
149: * x_return_status
150: * Status Returned to calling API. Possible values are following
151: * FND_API.G_RET_STS_ERROR - for expected error
152: * FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
153: * FND_API.G_RET_STS_SUCCESS - for success
154: */
155: PROCEDURE get_article_variable_values(
156: p_api_version IN NUMBER,

Line 153: * FND_API.G_RET_STS_SUCCESS - for success

149: * x_return_status
150: * Status Returned to calling API. Possible values are following
151: * FND_API.G_RET_STS_ERROR - for expected error
152: * FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
153: * FND_API.G_RET_STS_SUCCESS - for success
154: */
155: PROCEDURE get_article_variable_values(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 157: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

153: * FND_API.G_RET_STS_SUCCESS - for success
154: */
155: PROCEDURE get_article_variable_values(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
158: p_doctype_id IN VARCHAR2,
159: p_doc_id IN NUMBER,
160: p_sys_var_value_tbl IN OUT NOCOPY OKC_TERMS_UTIL_GRP.sys_var_value_tbl_type,
161: x_return_status OUT NOCOPY VARCHAR2,

Line 174: x_return_status := fnd_api.g_ret_sts_unexp_error;

170: l_progress NUMBER := 0;
171: l_dummy_value VARCHAR2(10) := 'NOT_NULL';
172: BEGIN
173: -- Initialize API return status to unexpected error
174: x_return_status := fnd_api.g_ret_sts_unexp_error;
175: x_msg_data := 'pon_conterms_utl_grp.get_article_variable_values() unexpected error';
176: x_msg_count := 1;
177:
178: -- Standard call to check for call compatibility.

Line 179: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

175: x_msg_data := 'pon_conterms_utl_grp.get_article_variable_values() unexpected error';
176: x_msg_count := 1;
177:
178: -- Standard call to check for call compatibility.
179: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
180: l_api_name, l_api_name) THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;
183:

Line 181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

177:
178: -- Standard call to check for call compatibility.
179: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
180: l_api_name, l_api_name) THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;
183:
184: l_progress := 50;
185:

Line 187: IF FND_API.to_Boolean(p_init_msg_list) THEN

183:
184: l_progress := 50;
185:
186: -- Initialize message list if p_init_msg_list is set to TRUE.
187: IF FND_API.to_Boolean(p_init_msg_list) THEN
188: FND_MSG_PUB.initialize();
189: END IF;
190:
191: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 201: x_return_status := fnd_api.g_ret_sts_success;

197: -- bug 3264980
198: -- if we're not passed and variables, then return immediately
199: if (p_sys_var_value_tbl is null OR
200: p_sys_var_value_tbl.count <= 0) then
201: x_return_status := fnd_api.g_ret_sts_success;
202: x_msg_data := null;
203: x_msg_count := 0;
204: return ;
205: end if;

Line 457: x_return_status := fnd_api.g_ret_sts_error;

453: 'no data found for ' || p_doc_id);
454: end if;
455:
456: x_msg_data := 'no data found for ' || p_doc_id;
457: x_return_status := fnd_api.g_ret_sts_error;
458: return;
459: end;
460: elsif (p_doctype_id = PON_CONTERMS_UTL_PVT.AUCTION or
461: p_doctype_id = PON_CONTERMS_UTL_PVT.REQUEST_FOR_QUOTE or

Line 709: x_return_status := fnd_api.g_ret_sts_error;

705: 'no data found for ' || p_doc_id);
706: end if;
707:
708: x_msg_data := 'no data found for ' || p_doc_id;
709: x_return_status := fnd_api.g_ret_sts_error;
710: return;
711: end ;
712: else
713: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then

Line 719: x_return_status := fnd_api.g_ret_sts_error;

715: l_api_name,
716: 'unknown doctype ' || p_doctype_id);
717: end if;
718:
719: x_return_status := fnd_api.g_ret_sts_error;
720: x_msg_data := l_api_name || ' unknown doctype ' || p_doctype_id;
721: x_msg_count := 1;
722: return;
723: end if;

Line 768: x_return_status := fnd_api.g_ret_sts_success;

764: end if;
765: end loop;
766: end loop;
767:
768: x_return_status := fnd_api.g_ret_sts_success;
769: x_msg_data := null;
770: x_msg_count := 0;
771:
772: EXCEPTION when others then

Line 821: * FND_API.G_RET_STS_ERROR - for expected error

817: * x_msg_data
818: * message data
819: * x_return_status
820: * Status Returned to calling API. Possible values are following
821: * FND_API.G_RET_STS_ERROR - for expected error
822: * FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
823: * FND_API.G_RET_STS_SUCCESS - for success
824: */
825: PROCEDURE get_changed_variables(

Line 822: * FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

818: * message data
819: * x_return_status
820: * Status Returned to calling API. Possible values are following
821: * FND_API.G_RET_STS_ERROR - for expected error
822: * FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
823: * FND_API.G_RET_STS_SUCCESS - for success
824: */
825: PROCEDURE get_changed_variables(
826: p_api_version IN NUMBER,

Line 823: * FND_API.G_RET_STS_SUCCESS - for success

819: * x_return_status
820: * Status Returned to calling API. Possible values are following
821: * FND_API.G_RET_STS_ERROR - for expected error
822: * FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
823: * FND_API.G_RET_STS_SUCCESS - for success
824: */
825: PROCEDURE get_changed_variables(
826: p_api_version IN NUMBER,
827: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 827: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

823: * FND_API.G_RET_STS_SUCCESS - for success
824: */
825: PROCEDURE get_changed_variables(
826: p_api_version IN NUMBER,
827: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
828: p_doctype_id IN VARCHAR2,
829: p_doc_id IN NUMBER,
830: p_sys_var_tbl IN OUT NOCOPY OKC_TERMS_UTIL_GRP.variable_code_tbl_type,
831: x_return_status OUT NOCOPY VARCHAR2,

Line 847: x_return_status := fnd_api.g_ret_sts_unexp_error;

843: l_progress NUMBER := 0;
844: l_found BOOLEAN;
845: BEGIN
846: -- Initialize API return status to unexpected error
847: x_return_status := fnd_api.g_ret_sts_unexp_error;
848: x_msg_data := l_api_name || ' unexpected error';
849: x_msg_count := 1;
850:
851: -- Standard call to check for call compatibility.

Line 852: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

848: x_msg_data := l_api_name || ' unexpected error';
849: x_msg_count := 1;
850:
851: -- Standard call to check for call compatibility.
852: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
853: l_api_name, l_api_name) THEN
854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
855: END IF;
856:

Line 854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

850:
851: -- Standard call to check for call compatibility.
852: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
853: l_api_name, l_api_name) THEN
854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
855: END IF;
856:
857: l_progress := 50;
858:

Line 860: IF FND_API.to_Boolean(p_init_msg_list) THEN

856:
857: l_progress := 50;
858:
859: -- Initialize message list if p_init_msg_list is set to TRUE.
860: IF FND_API.to_Boolean(p_init_msg_list) THEN
861: FND_MSG_PUB.initialize();
862: END IF;
863:
864: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 874: x_return_status := fnd_api.g_ret_sts_success;

870: -- bug 3264980
871: -- if we're not passed and variables, then return immediately
872: if (p_sys_var_tbl is null OR
873: p_sys_var_tbl.count <= 0) then
874: x_return_status := fnd_api.g_ret_sts_success;
875: x_msg_data := null;
876: x_msg_count := 0;
877: return ;
878: end if;

Line 902: x_return_status := fnd_api.g_ret_sts_error;

898: for l_sys_var_index in p_sys_var_tbl.first..p_sys_var_tbl.last loop
899: p_sys_var_tbl.delete(l_sys_var_index);
900: end loop;
901:
902: x_return_status := fnd_api.g_ret_sts_error;
903: x_msg_data := l_api_name || ' did not expect call with doctype ' || p_doctype_id;
904: return;
905: elsif (p_doctype_id = PON_CONTERMS_UTL_PVT.AUCTION or
906: p_doctype_id = PON_CONTERMS_UTL_PVT.REQUEST_FOR_QUOTE or

Line 933: x_return_status := fnd_api.g_ret_sts_error;

929: 'no data found for ' || p_doc_id);
930: end if;
931:
932: x_msg_data := 'no data found for ' || p_doc_id;
933: x_return_status := fnd_api.g_ret_sts_error;
934: return;
935: end ;
936:
937: l_progress := 132;

Line 957: x_return_status := fnd_api.g_ret_sts_success;

953: for l_sys_var_index in p_sys_var_tbl.first..p_sys_var_tbl.last loop
954: p_sys_var_tbl.delete(l_sys_var_index);
955: end loop;
956:
957: x_return_status := fnd_api.g_ret_sts_success;
958: x_msg_data := null;
959: x_msg_count := 0;
960: return ;
961: end if;

Line 1081: x_return_status := fnd_api.g_ret_sts_error;

1077: l_api_name,
1078: 'unknown doctype ' || p_doctype_id);
1079: end if;
1080:
1081: x_return_status := fnd_api.g_ret_sts_error;
1082: x_msg_data := l_api_name || ' unknown doctype ' || p_doctype_id;
1083: x_msg_count := 1;
1084: return;
1085: end if;

Line 1152: x_return_status := fnd_api.g_ret_sts_success;

1148:
1149: l_sys_var_index := p_sys_var_tbl.next(l_sys_var_index);
1150: end loop;
1151:
1152: x_return_status := fnd_api.g_ret_sts_success;
1153: x_msg_data := null;
1154: x_msg_count := 0;
1155:
1156: EXCEPTION when others then

Line 1177: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1173:
1174:
1175: PROCEDURE get_item_category(
1176: p_api_version IN NUMBER,
1177: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1178: p_doctype_id IN VARCHAR2,
1179: p_doc_id IN NUMBER,
1180: x_category_tbl OUT NOCOPY OKC_TERMS_UTIL_GRP.item_tbl_type,
1181: x_item_tbl OUT NOCOPY OKC_TERMS_UTIL_GRP.item_tbl_type,

Line 1198: x_return_status := fnd_api.g_ret_sts_unexp_error;

1194: BEGIN
1195: -- Initialize API return status to unexpected error
1196: x_category_tbl.delete();
1197: x_item_tbl.delete();
1198: x_return_status := fnd_api.g_ret_sts_unexp_error;
1199: x_msg_data := 'pon_conterms_utl_grp.ok_to_commit() unexpected error';
1200: x_msg_count := 1;
1201:
1202: -- Standard call to check for call compatibility.

Line 1203: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

1199: x_msg_data := 'pon_conterms_utl_grp.ok_to_commit() unexpected error';
1200: x_msg_count := 1;
1201:
1202: -- Standard call to check for call compatibility.
1203: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1204: l_api_name, l_api_name) THEN
1205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1206: END IF;
1207:

Line 1205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1201:
1202: -- Standard call to check for call compatibility.
1203: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1204: l_api_name, l_api_name) THEN
1205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1206: END IF;
1207:
1208: -- Initialize message list if p_init_msg_list is set to TRUE.
1209: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1209: IF FND_API.to_Boolean(p_init_msg_list) THEN

1205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1206: END IF;
1207:
1208: -- Initialize message list if p_init_msg_list is set to TRUE.
1209: IF FND_API.to_Boolean(p_init_msg_list) THEN
1210: FND_MSG_PUB.initialize();
1211: END IF;
1212:
1213: -- get auction_header_id

Line 1220: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

1216: l_auction_header_id,
1217: x_return_status,
1218: x_msg_data,
1219: x_msg_count);
1220: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1221: return ;
1222: END IF;
1223:
1224: -- insert categories

Line 1281: x_return_status := fnd_api.g_ret_sts_success;

1277: end loop;
1278: end if;
1279:
1280: -- return success
1281: x_return_status := fnd_api.g_ret_sts_success;
1282: x_msg_data := null;
1283: x_msg_count := 0;
1284:
1285: END get_item_category;