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 45: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

41:
42:
43: PROCEDURE ok_to_commit(
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
46: p_doctype_id IN VARCHAR2,
47: p_doc_id IN NUMBER,
48: x_update_allowed OUT NOCOPY VARCHAR2,
49: x_return_status OUT NOCOPY VARCHAR2,

Line 59: x_update_allowed := fnd_api.g_false;

55: l_auction_header_id pon_auction_headers_all.auction_header_id%type;
56: l_auction_status pon_auction_headers_all.auction_status%type;
57: BEGIN
58: -- Initialize API return status to unexpected error
59: x_update_allowed := fnd_api.g_false;
60: x_return_status := fnd_api.g_ret_sts_unexp_error;
61: x_msg_data := 'pon_conterms_utl_grp.ok_to_commit() unexpected error';
62: x_msg_count := 1;
63:

Line 60: x_return_status := fnd_api.g_ret_sts_unexp_error;

56: l_auction_status pon_auction_headers_all.auction_status%type;
57: BEGIN
58: -- Initialize API return status to unexpected error
59: x_update_allowed := fnd_api.g_false;
60: x_return_status := fnd_api.g_ret_sts_unexp_error;
61: x_msg_data := 'pon_conterms_utl_grp.ok_to_commit() unexpected error';
62: x_msg_count := 1;
63:
64: -- Standard call to check for call compatibility.

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

61: x_msg_data := 'pon_conterms_utl_grp.ok_to_commit() unexpected error';
62: x_msg_count := 1;
63:
64: -- Standard call to check for call compatibility.
65: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
66: l_api_name, l_api_name) THEN
67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: END IF;
69:

Line 67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

63:
64: -- Standard call to check for call compatibility.
65: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
66: l_api_name, l_api_name) THEN
67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: END IF;
69:
70: -- Initialize message list if p_init_msg_list is set to TRUE.
71: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 71: IF FND_API.to_Boolean(p_init_msg_list) THEN

67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: END IF;
69:
70: -- Initialize message list if p_init_msg_list is set to TRUE.
71: IF FND_API.to_Boolean(p_init_msg_list) THEN
72: FND_MSG_PUB.initialize();
73: END IF;
74:
75: -- get auction_header_id

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

78: l_auction_header_id,
79: x_return_status,
80: x_msg_data,
81: x_msg_count);
82: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
83: return ;
84: END IF;
85:
86: /*ELINs & CDRLs project : When updating cdrl's in offers, no need

Line 125: x_update_allowed := fnd_api.g_false;

121: and auction.trading_partner_id = company_parties.party_id
122: and auction.auction_status = 'DRAFT';
123: EXCEPTION
124: WHEN no_data_found THEN
125: x_update_allowed := fnd_api.g_false;
126: x_return_status := fnd_api.g_ret_sts_success;
127: x_msg_data := 'pon_conterms_utl_grp.ok_to_commit() - user doesn''t have lock for draft: ' || l_auction_header_id;
128: x_msg_count := 1;
129: return;

Line 126: x_return_status := fnd_api.g_ret_sts_success;

122: and auction.auction_status = 'DRAFT';
123: EXCEPTION
124: WHEN no_data_found THEN
125: x_update_allowed := fnd_api.g_false;
126: x_return_status := fnd_api.g_ret_sts_success;
127: x_msg_data := 'pon_conterms_utl_grp.ok_to_commit() - user doesn''t have lock for draft: ' || l_auction_header_id;
128: x_msg_count := 1;
129: return;
130: END;

Line 133: x_update_allowed := fnd_api.g_true;

129: return;
130: END;
131: END IF;
132:
133: x_update_allowed := fnd_api.g_true;
134: x_return_status := fnd_api.g_ret_sts_success;
135: x_msg_data := 'Success!';
136: x_msg_count := 1;
137: END ok_to_commit;

Line 134: x_return_status := fnd_api.g_ret_sts_success;

130: END;
131: END IF;
132:
133: x_update_allowed := fnd_api.g_true;
134: x_return_status := fnd_api.g_ret_sts_success;
135: x_msg_data := 'Success!';
136: x_msg_count := 1;
137: END ok_to_commit;
138:

Line 167: * FND_API.G_RET_STS_ERROR - for expected error

163: * x_msg_data
164: * message data
165: * x_return_status
166: * Status Returned to calling API. Possible values are following
167: * FND_API.G_RET_STS_ERROR - for expected error
168: * FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
169: * FND_API.G_RET_STS_SUCCESS - for success
170: */
171: PROCEDURE get_article_variable_values(

Line 168: * FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

164: * message data
165: * x_return_status
166: * Status Returned to calling API. Possible values are following
167: * FND_API.G_RET_STS_ERROR - for expected error
168: * FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
169: * FND_API.G_RET_STS_SUCCESS - for success
170: */
171: PROCEDURE get_article_variable_values(
172: p_api_version IN NUMBER,

Line 169: * FND_API.G_RET_STS_SUCCESS - for success

165: * x_return_status
166: * Status Returned to calling API. Possible values are following
167: * FND_API.G_RET_STS_ERROR - for expected error
168: * FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
169: * FND_API.G_RET_STS_SUCCESS - for success
170: */
171: PROCEDURE get_article_variable_values(
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 173: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

169: * FND_API.G_RET_STS_SUCCESS - for success
170: */
171: PROCEDURE get_article_variable_values(
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
174: p_doctype_id IN VARCHAR2,
175: p_doc_id IN NUMBER,
176: p_sys_var_value_tbl IN OUT NOCOPY OKC_TERMS_UTIL_GRP.sys_var_value_tbl_type,
177: x_return_status OUT NOCOPY VARCHAR2,

Line 190: x_return_status := fnd_api.g_ret_sts_unexp_error;

186: l_progress NUMBER := 0;
187: l_dummy_value VARCHAR2(10) := 'NOT_NULL';
188: BEGIN
189: -- Initialize API return status to unexpected error
190: x_return_status := fnd_api.g_ret_sts_unexp_error;
191: x_msg_data := 'pon_conterms_utl_grp.get_article_variable_values() unexpected error';
192: x_msg_count := 1;
193:
194: -- Standard call to check for call compatibility.

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

191: x_msg_data := 'pon_conterms_utl_grp.get_article_variable_values() unexpected error';
192: x_msg_count := 1;
193:
194: -- Standard call to check for call compatibility.
195: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
196: l_api_name, l_api_name) THEN
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: END IF;
199:

Line 197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

193:
194: -- Standard call to check for call compatibility.
195: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
196: l_api_name, l_api_name) THEN
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: END IF;
199:
200: l_progress := 50;
201:

Line 203: IF FND_API.to_Boolean(p_init_msg_list) THEN

199:
200: l_progress := 50;
201:
202: -- Initialize message list if p_init_msg_list is set to TRUE.
203: IF FND_API.to_Boolean(p_init_msg_list) THEN
204: FND_MSG_PUB.initialize();
205: END IF;
206:
207: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 217: x_return_status := fnd_api.g_ret_sts_success;

213: -- bug 3264980
214: -- if we're not passed and variables, then return immediately
215: if (p_sys_var_value_tbl is null OR
216: p_sys_var_value_tbl.count <= 0) then
217: x_return_status := fnd_api.g_ret_sts_success;
218: x_msg_data := null;
219: x_msg_count := 0;
220: return ;
221: end if;

Line 475: x_return_status := fnd_api.g_ret_sts_error;

471: 'no data found for ' || p_doc_id);
472: end if;
473:
474: x_msg_data := 'no data found for ' || p_doc_id;
475: x_return_status := fnd_api.g_ret_sts_error;
476: return;
477: end;
478: elsif (p_doctype_id = PON_CONTERMS_UTL_PVT.AUCTION or
479: p_doctype_id = PON_CONTERMS_UTL_PVT.REQUEST_FOR_QUOTE or

Line 729: x_return_status := fnd_api.g_ret_sts_error;

725: 'no data found for ' || p_doc_id);
726: end if;
727:
728: x_msg_data := 'no data found for ' || p_doc_id;
729: x_return_status := fnd_api.g_ret_sts_error;
730: return;
731: end ;
732: else
733: if (fnd_log.level_exception >= fnd_log.g_current_runtime_level) then

Line 739: x_return_status := fnd_api.g_ret_sts_error;

735: l_api_name,
736: 'unknown doctype ' || p_doctype_id);
737: end if;
738:
739: x_return_status := fnd_api.g_ret_sts_error;
740: x_msg_data := l_api_name || ' unknown doctype ' || p_doctype_id;
741: x_msg_count := 1;
742: return;
743: end if;

Line 788: x_return_status := fnd_api.g_ret_sts_success;

784: end if;
785: end loop;
786: end loop;
787:
788: x_return_status := fnd_api.g_ret_sts_success;
789: x_msg_data := null;
790: x_msg_count := 0;
791:
792: EXCEPTION when others then

Line 841: * FND_API.G_RET_STS_ERROR - for expected error

837: * x_msg_data
838: * message data
839: * x_return_status
840: * Status Returned to calling API. Possible values are following
841: * FND_API.G_RET_STS_ERROR - for expected error
842: * FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
843: * FND_API.G_RET_STS_SUCCESS - for success
844: */
845: PROCEDURE get_changed_variables(

Line 842: * FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

838: * message data
839: * x_return_status
840: * Status Returned to calling API. Possible values are following
841: * FND_API.G_RET_STS_ERROR - for expected error
842: * FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
843: * FND_API.G_RET_STS_SUCCESS - for success
844: */
845: PROCEDURE get_changed_variables(
846: p_api_version IN NUMBER,

Line 843: * FND_API.G_RET_STS_SUCCESS - for success

839: * x_return_status
840: * Status Returned to calling API. Possible values are following
841: * FND_API.G_RET_STS_ERROR - for expected error
842: * FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
843: * FND_API.G_RET_STS_SUCCESS - for success
844: */
845: PROCEDURE get_changed_variables(
846: p_api_version IN NUMBER,
847: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 847: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

843: * FND_API.G_RET_STS_SUCCESS - for success
844: */
845: PROCEDURE get_changed_variables(
846: p_api_version IN NUMBER,
847: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
848: p_doctype_id IN VARCHAR2,
849: p_doc_id IN NUMBER,
850: p_sys_var_tbl IN OUT NOCOPY OKC_TERMS_UTIL_GRP.variable_code_tbl_type,
851: x_return_status OUT NOCOPY VARCHAR2,

Line 867: x_return_status := fnd_api.g_ret_sts_unexp_error;

863: l_progress NUMBER := 0;
864: l_found BOOLEAN;
865: BEGIN
866: -- Initialize API return status to unexpected error
867: x_return_status := fnd_api.g_ret_sts_unexp_error;
868: x_msg_data := l_api_name || ' unexpected error';
869: x_msg_count := 1;
870:
871: -- Standard call to check for call compatibility.

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

868: x_msg_data := l_api_name || ' unexpected error';
869: x_msg_count := 1;
870:
871: -- Standard call to check for call compatibility.
872: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
873: l_api_name, l_api_name) THEN
874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
875: END IF;
876:

Line 874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

870:
871: -- Standard call to check for call compatibility.
872: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
873: l_api_name, l_api_name) THEN
874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
875: END IF;
876:
877: l_progress := 50;
878:

Line 880: IF FND_API.to_Boolean(p_init_msg_list) THEN

876:
877: l_progress := 50;
878:
879: -- Initialize message list if p_init_msg_list is set to TRUE.
880: IF FND_API.to_Boolean(p_init_msg_list) THEN
881: FND_MSG_PUB.initialize();
882: END IF;
883:
884: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 894: x_return_status := fnd_api.g_ret_sts_success;

890: -- bug 3264980
891: -- if we're not passed and variables, then return immediately
892: if (p_sys_var_tbl is null OR
893: p_sys_var_tbl.count <= 0) then
894: x_return_status := fnd_api.g_ret_sts_success;
895: x_msg_data := null;
896: x_msg_count := 0;
897: return ;
898: end if;

Line 923: x_return_status := fnd_api.g_ret_sts_error;

919: for l_sys_var_index in p_sys_var_tbl.first..p_sys_var_tbl.last loop
920: p_sys_var_tbl.delete(l_sys_var_index);
921: end loop;
922:
923: x_return_status := fnd_api.g_ret_sts_error;
924: x_msg_data := l_api_name || ' did not expect call with doctype ' || p_doctype_id;
925: return;
926: elsif (p_doctype_id = PON_CONTERMS_UTL_PVT.AUCTION or
927: p_doctype_id = PON_CONTERMS_UTL_PVT.REQUEST_FOR_QUOTE or

Line 955: x_return_status := fnd_api.g_ret_sts_error;

951: 'no data found for ' || p_doc_id);
952: end if;
953:
954: x_msg_data := 'no data found for ' || p_doc_id;
955: x_return_status := fnd_api.g_ret_sts_error;
956: return;
957: end ;
958:
959: l_progress := 132;

Line 979: x_return_status := fnd_api.g_ret_sts_success;

975: for l_sys_var_index in p_sys_var_tbl.first..p_sys_var_tbl.last loop
976: p_sys_var_tbl.delete(l_sys_var_index);
977: end loop;
978:
979: x_return_status := fnd_api.g_ret_sts_success;
980: x_msg_data := null;
981: x_msg_count := 0;
982: return ;
983: end if;

Line 1103: x_return_status := fnd_api.g_ret_sts_error;

1099: l_api_name,
1100: 'unknown doctype ' || p_doctype_id);
1101: end if;
1102:
1103: x_return_status := fnd_api.g_ret_sts_error;
1104: x_msg_data := l_api_name || ' unknown doctype ' || p_doctype_id;
1105: x_msg_count := 1;
1106: return;
1107: end if;

Line 1174: x_return_status := fnd_api.g_ret_sts_success;

1170:
1171: l_sys_var_index := p_sys_var_tbl.next(l_sys_var_index);
1172: end loop;
1173:
1174: x_return_status := fnd_api.g_ret_sts_success;
1175: x_msg_data := null;
1176: x_msg_count := 0;
1177:
1178: EXCEPTION when others then

Line 1199: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1195:
1196:
1197: PROCEDURE get_item_category(
1198: p_api_version IN NUMBER,
1199: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1200: p_doctype_id IN VARCHAR2,
1201: p_doc_id IN NUMBER,
1202: x_category_tbl OUT NOCOPY OKC_TERMS_UTIL_GRP.item_tbl_type,
1203: x_item_tbl OUT NOCOPY OKC_TERMS_UTIL_GRP.item_tbl_type,

Line 1220: x_return_status := fnd_api.g_ret_sts_unexp_error;

1216: BEGIN
1217: -- Initialize API return status to unexpected error
1218: x_category_tbl.delete();
1219: x_item_tbl.delete();
1220: x_return_status := fnd_api.g_ret_sts_unexp_error;
1221: x_msg_data := 'pon_conterms_utl_grp.ok_to_commit() unexpected error';
1222: x_msg_count := 1;
1223:
1224: -- Standard call to check for call compatibility.

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

1221: x_msg_data := 'pon_conterms_utl_grp.ok_to_commit() unexpected error';
1222: x_msg_count := 1;
1223:
1224: -- Standard call to check for call compatibility.
1225: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1226: l_api_name, l_api_name) THEN
1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1228: END IF;
1229:

Line 1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1223:
1224: -- Standard call to check for call compatibility.
1225: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1226: l_api_name, l_api_name) THEN
1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1228: END IF;
1229:
1230: -- Initialize message list if p_init_msg_list is set to TRUE.
1231: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1231: IF FND_API.to_Boolean(p_init_msg_list) THEN

1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1228: END IF;
1229:
1230: -- Initialize message list if p_init_msg_list is set to TRUE.
1231: IF FND_API.to_Boolean(p_init_msg_list) THEN
1232: FND_MSG_PUB.initialize();
1233: END IF;
1234:
1235: -- get auction_header_id

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

1238: l_auction_header_id,
1239: x_return_status,
1240: x_msg_data,
1241: x_msg_count);
1242: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1243: return ;
1244: END IF;
1245:
1246: -- insert categories

Line 1303: x_return_status := fnd_api.g_ret_sts_success;

1299: end loop;
1300: end if;
1301:
1302: -- return success
1303: x_return_status := fnd_api.g_ret_sts_success;
1304: x_msg_data := null;
1305: x_msg_count := 0;
1306:
1307: END get_item_category;