DBA Data[Home] [Help]

APPS.FTP_TP_PKG dependencies on FND_MSG_PUB

Line 1106: -- in x_msg_data. If x_msg_count > 1, then messages are returned via FND_MSG_PUB.

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: **************************************************************************/

Line 1164: FND_MSG_PUB.Initialize;

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

Line 1465: FND_MSG_PUB.Count_And_Get

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

Line 1471: FND_MSG_PUB.Count_And_Get

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;

Line 1488: FND_MSG_PUB.Count_And_Get

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;

Line 1508: FND_MSG_PUB.Count_And_Get

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:

Line 1595: FND_MSG_PUB.Delete_Msg();

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;

Line 2085: FND_MSG_PUB.Count_And_Get

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

Line 2091: FND_MSG_PUB.Count_And_Get

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;

Line 2136: FND_MSG_PUB.Count_And_Get

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:

Line 2176: FND_MSG_PUB.Count_And_Get

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:

Line 2390: FND_MSG_PUB.Count_And_Get

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

Line 2396: FND_MSG_PUB.Count_And_Get

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;

Line 2403: FND_MSG_PUB.Count_And_Get

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;

Line 2410: FND_MSG_PUB.Count_And_Get

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:

Line 2500: FND_MSG_PUB.Delete_Msg();

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:

Line 2525: FND_MSG_PUB.Count_And_Get

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:

Line 2693: FND_MSG_PUB.Count_And_Get

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: