APPS.RCV_RECEIPTS_QUERY_SV dependencies on FND_API

Line 1099: * x_exist - FND_API.G_TRUE if sql is executed successfully without any error

1095: * Modifies: None
1096: * Effects: Executes a dynamic sql defined in p_query. the value of bind
1097: * variables will be defined in p_val
1098: * Returns:
1099: * x_exist - FND_API.G_TRUE if sql is executed successfully without any error
1100: * FND_API.G_FALSE if sql returns NO_DATA_FOUND
1101: * The procedure raises an exception if p_query returns an error other than
1102: * NO_DATA_FOUND
1103: */

Line 1100: * FND_API.G_FALSE if sql returns NO_DATA_FOUND

1096: * Effects: Executes a dynamic sql defined in p_query. the value of bind
1097: * variables will be defined in p_val
1098: * Returns:
1099: * x_exist - FND_API.G_TRUE if sql is executed successfully without any error
1100: * FND_API.G_FALSE if sql returns NO_DATA_FOUND
1101: * The procedure raises an exception if p_query returns an error other than
1102: * NO_DATA_FOUND
1103: */
1104:

Line 1157: x_exist := FND_API.G_TRUE;

1153: l_progress := '080';
1154: RAISE l_exception;
1155: END IF;
1156:
1157: x_exist := FND_API.G_TRUE;
1158: EXCEPTION
1159: WHEN NO_DATA_FOUND THEN
1160: x_exist := FND_API.G_FALSE;
1161: WHEN OTHERS THEN

Line 1160: x_exist := FND_API.G_FALSE;

1156:
1157: x_exist := FND_API.G_TRUE;
1158: EXCEPTION
1159: WHEN NO_DATA_FOUND THEN
1160: x_exist := FND_API.G_FALSE;
1161: WHEN OTHERS THEN
1162: PO_MESSAGE_S.sql_error('exec_dynamic_sql', l_progress, sqlcode);
1163: RAISE;
1164: END exec_dynamic_sql;