1102: -- unrecoverable (check x_msg_count)
1103: --
1104: -- x_msg_count OUT NUMBER
1105: -- Count of messages returned. If x_msg_count = 1, then the message is returned
1106: -- in x_msg_data. If x_msg_count > 1, then messages are returned via FND_MSG_PUB.
1107: --
1108: -- x_msg_data OUT VARCHAR2
1109: -- Error message returned.
1110: **************************************************************************/
1160: -- initialize our status to 'we are good!'
1161: x_return_status := FND_API.G_RET_STS_SUCCESS;
1162:
1163: -- Initialize FND message queue
1164: FND_MSG_PUB.Initialize;
1165:
1166: savepoint register_request_pub;
1167:
1168: -- Get the object definition id of the process
1461: p_token3 => 'RETURN_STATUS',
1462: p_value3 => x_return_status
1463: );*/
1464: l_table_names.DELETE;
1465: FND_MSG_PUB.Count_And_Get
1466: (p_encoded => 'F',
1467: p_count => x_msg_count,
1468: p_data => x_msg_data);
1469: EXCEPTION
1467: p_count => x_msg_count,
1468: p_data => x_msg_data);
1469: EXCEPTION
1470: WHEN FND_API.G_EXC_ERROR THEN
1471: FND_MSG_PUB.Count_And_Get
1472: (p_encoded => 'F',
1473: p_count => x_msg_count,
1474: p_data => x_msg_data);
1475: x_return_status := FND_API.G_RET_STS_ERROR;
1484: p_msg_name => 'UNEXP EXCEPTION',
1485: p_token1 => 'SQLERRM',
1486: p_value1 => l_msg
1487: );
1488: FND_MSG_PUB.Count_And_Get
1489: (p_encoded => 'F',
1490: p_count => x_msg_count,
1491: p_data => x_msg_data);
1492: rollback to register_request_pub;
1504: p_value1 => trunc(p_effective_date),
1505: p_token2 => 'SQLERRM',
1506: p_value2 => SQLERRM
1507: );
1508: FND_MSG_PUB.Count_And_Get
1509: (p_encoded => 'F',
1510: p_count => x_msg_count,
1511: p_data => x_msg_data);
1512:
1591: BEGIN
1592:
1593: -- initialize our status to 'we are good!'
1594: x_return_status := FND_API.G_RET_STS_SUCCESS;
1595: FND_MSG_PUB.Delete_Msg();
1596: --Initialize sum variables
1597: l_total_inp := 0;
1598: l_total_out := 0;
1599: l_input_cnt := 0;
2081: RAISE FND_API.G_EXC_ERROR;
2082: END IF;
2083:
2084: l_table_names.DELETE;
2085: FND_MSG_PUB.Count_And_Get
2086: (p_encoded => 'F',
2087: p_count => x_msg_count,
2088: p_data => x_msg_data);
2089: EXCEPTION
2087: p_count => x_msg_count,
2088: p_data => x_msg_data);
2089: EXCEPTION
2090: WHEN FND_API.G_EXC_ERROR THEN
2091: FND_MSG_PUB.Count_And_Get
2092: (p_encoded => 'F',
2093: p_count => x_msg_count,
2094: p_data => x_msg_data);
2095: x_return_status := FND_API.G_RET_STS_ERROR;
2132: x_msg_count => x_msg_count,
2133: x_msg_data => x_msg_data,
2134: x_return_status => x_return_status
2135: );
2136: FND_MSG_PUB.Count_And_Get
2137: (p_encoded => 'F',
2138: p_count => x_msg_count,
2139: p_data => x_msg_data);
2140:
2172: x_msg_count => x_msg_count,
2173: x_msg_data => x_msg_data,
2174: x_return_status => x_return_status
2175: );
2176: FND_MSG_PUB.Count_And_Get
2177: (p_encoded => 'F',
2178: p_count => x_msg_count,
2179: p_data => x_msg_data);
2180:
2386: /*DELETE from fem_balances where created_by_object_id = p_object_id AND
2387: (DATASET_CODE = l_output_ds) AND (LEDGER_ID = p_ledger_id) AND
2388: (CAL_PERIOD_ID = p_cal_period_id);*/
2389: --END IF;
2390: FND_MSG_PUB.Count_And_Get
2391: (p_encoded => 'F',
2392: p_count => x_msg_count,
2393: p_data => x_msg_data);
2394: EXCEPTION
2392: p_count => x_msg_count,
2393: p_data => x_msg_data);
2394: EXCEPTION
2395: WHEN FND_API.G_EXC_ERROR THEN
2396: FND_MSG_PUB.Count_And_Get
2397: (p_encoded => 'F',
2398: p_count => x_msg_count,
2399: p_data => x_msg_data);
2400: x_return_status := FND_API.G_RET_STS_ERROR;
2399: p_data => x_msg_data);
2400: x_return_status := FND_API.G_RET_STS_ERROR;
2401:
2402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2403: FND_MSG_PUB.Count_And_Get
2404: (p_encoded => 'F',
2405: p_count => x_msg_count,
2406: p_data => x_msg_data);
2407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2406: p_data => x_msg_data);
2407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2408:
2409: WHEN OTHERS THEN
2410: FND_MSG_PUB.Count_And_Get
2411: (p_encoded => 'F',
2412: p_count => x_msg_count,
2413: p_data => x_msg_data);
2414:
2496: begin
2497:
2498: -- initialize our status to 'we are good!'
2499: x_return_status := FND_API.G_RET_STS_SUCCESS;
2500: FND_MSG_PUB.Delete_Msg();
2501: adj_type_code := '';
2502:
2503: get_obj_def(obj_id, effective_date, process_info);
2504:
2521: IF ( rate_output_rule_obj_id IS NULL ) THEN
2522: valid_table_list := '';
2523: LAST_OBJID_COL := 'last_updated_by_object_id';
2524: LAST_REQID_COL := 'last_updated_by_request_id';
2525: FND_MSG_PUB.Count_And_Get
2526: (p_encoded => 'F',
2527: p_count => x_msg_count,
2528: p_data => x_msg_data);
2529:
2689:
2690: select RTRIM(valid_table_list,',') into new_valid_table_list from dual;
2691: valid_table_list := new_valid_table_list;
2692:
2693: FND_MSG_PUB.Count_And_Get
2694: (p_encoded => 'F',
2695: p_count => x_msg_count,
2696: p_data => x_msg_data);
2697: