131:
132: l_rule_cond_rec cur_get_rule_conditions%ROWTYPE;
133:
134: BEGIN
135: --* Standard Start of API savepoint
136: SAVEPOINT PROCESS_RULE_MATCHING_PVT;
137:
138: --* Standard call to check for call compatibility.
139: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,
134: BEGIN
135: --* Standard Start of API savepoint
136: SAVEPOINT PROCESS_RULE_MATCHING_PVT;
137:
138: --* Standard call to check for call compatibility.
139: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,
140: p_api_version_number,
141: c_API_NAME,
142: G_PKG_NAME)
257: END LOOP; --* end FOR l_rule_rec ... *--
258:
259: --* logic ends here *--
260:
261: --* Standard check for p_commit
262: IF FND_API.to_Boolean( p_commit ) THEN
263: COMMIT WORK;
264: END IF;
265:
266: --** debug starts!!
267: --dbms_output.put_line('PROCESS_RULE_MATCHING -> after commit work');
268: --** debug ends!!
269:
270: --* Standard call to get message count and if count is 1, get message info.
271: FND_MSG_PUB.Count_And_Get(
272: p_count => x_msg_count,
273: p_data => x_msg_data
274: );
273: p_data => x_msg_data
274: );
275:
276: --** debug starts!!
277: --dbms_output.put_line('PROCESS_RULE_MATCHING -> after standard call to message count');
278: --** debug ends!!
279:
280: EXCEPTION
281: WHEN FND_API.G_EXC_ERROR THEN
351: l_tbl_count NUMBER := 0;
352: l_default_rule_id NUMBER := NULL;
353:
354: BEGIN
355: --* Standard Start of API savepoint
356: SAVEPOINT GET_SOO_VALUES;
357:
358: --* Standard call to check for call compatibility.
359: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,
354: BEGIN
355: --* Standard Start of API savepoint
356: SAVEPOINT GET_SOO_VALUES;
357:
358: --* Standard call to check for call compatibility.
359: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,
360: p_api_version_number,
361: c_API_NAME,
362: G_PKG_NAME)
432:
433: x_rule_id := l_default_rule_id;
434: --* logic ends here *--
435:
436: -- Standard check of p_commit.
437: IF FND_API.To_Boolean( p_commit ) THEN
438: COMMIT WORK;
439: END IF;
440:
485:
486: BEGIN
487: SAVEPOINT PROCESS_SOO_RULE;
488:
489: --* Standard call to check for call compatibility.
490: IF NOT FND_API.Compatible_API_Call ( G_L_API_VERSION_NUMBER,
491: p_api_version_number,
492: c_API_NAME,
493: G_PKG_NAME)
547: END IF;
548:
549: END IF;
550:
551: -- Standard check of p_commit.
552: IF FND_API.To_Boolean( p_commit ) THEN
553: COMMIT WORK;
554: END IF;
555:
621: l_value_type VARCHAR(30) := NULL;
622: l_defaulting_value VARCHAR(150) := NULL;
623: l_default_rule_id NUMBER := NULL; -- swai: added for 12.1.1
624: BEGIN
625: --* Standard Start of API savepoint
626: SAVEPOINT GET_DFLT_VAL_FROM_RULE_PVT;
627:
628: --* Standard call to check for call compatibility.
629: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,
624: BEGIN
625: --* Standard Start of API savepoint
626: SAVEPOINT GET_DFLT_VAL_FROM_RULE_PVT;
627:
628: --* Standard call to check for call compatibility.
629: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,
630: p_api_version_number,
631: c_API_NAME,
632: G_PKG_NAME)
732: x_default_value := l_default_val_str;
733: --* logic ends here *--
734:
735:
736: --* Standard call to get message count and if count is 1, get message info.
737: FND_MSG_PUB.Count_And_Get(
738: p_count => x_msg_count,
739: p_data => x_msg_data
740: );
824:
825: ---- local variables ----
826: l_default_val_str VARCHAR2(150) := NULL;
827: BEGIN
828: --* Standard Start of API savepoint
829: SAVEPOINT GET_DFLT_VAL_FROM_RULE_PVT;
830:
831: --* call the string function
832: GET_DEFAULT_VALUE_FROM_RULE (
934: ---- local variables ----
935: l_default_val_str VARCHAR2(150) := NULL;
936:
937: BEGIN
938: --* Standard Start of API savepoint
939: SAVEPOINT GET_DFLT_VAL_FROM_RULE_PVT;
940: --* call the string function
941: GET_DEFAULT_VALUE_FROM_RULE (
942: p_api_version_number => p_api_version_number,