DBA Data[Home] [Help]

APPS.FTE_TL_LOADER dependencies on FTE_VALIDATION_PKG

Line 1847: -- For instance, FTE.VALIDATION_PKG.VALIDATE_RATE_CHART stores the header info

1843: --
1844: -- PURPOSE: Calls FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS, to popupulate the interface
1845: -- tables and call corresponginf QP API. The values for headers,lines, attribs,
1846: -- qualifiers have already been stored through the validation procedures.
1847: -- For instance, FTE.VALIDATION_PKG.VALIDATE_RATE_CHART stores the header info
1848: -- after all validations for header in temporary pl/sql tables.
1849: -- Inspite of name, validation procedures stores the data in temp pl/sql tables.
1850: --
1851: -- PARAMETERS

Line 3810: l_service_level := FTE_VALIDATION_PKG.VALIDATE_SERVICE_LEVEL(p_carrier_id => NULL,

3806: END;
3807:
3808: IF ( p_doValidate ) THEN
3809: IF (p_chart_type <> 'FAC_MODIFIER') THEN
3810: l_service_level := FTE_VALIDATION_PKG.VALIDATE_SERVICE_LEVEL(p_carrier_id => NULL,
3811: p_carrier_name => l_carrier_name,
3812: p_service_level => l_service_level,
3813: p_line_number => p_line_number,
3814: x_error_msg => x_error_msg,

Line 4327: FTE_VALIDATION_PKG.VALIDATE_COLUMNS(p_keys => p_block_header,

4323: RETURN;
4324: END IF;
4325: END IF;
4326:
4327: FTE_VALIDATION_PKG.VALIDATE_COLUMNS(p_keys => p_block_header,
4328: p_type => l_type,
4329: p_line_number => p_line_number-1,
4330: x_status => x_status,
4331: x_error_msg => x_error_msg);

Line 4731: FTE_VALIDATION_PKG.VALIDATE_COLUMNS(p_keys => p_block_header,

4727: FTE_UTIL_PKG.Write_LogFile(l_module_name,'g_unit_uom',g_unit_uom);
4728: END IF;
4729:
4730: IF( p_doValidate ) THEN
4731: FTE_VALIDATION_PKG.VALIDATE_COLUMNS(p_keys => p_block_header,
4732: p_type => l_block_type,
4733: p_line_number => p_line_number-1,
4734: x_status => x_status,
4735: x_error_msg => x_error_msg);

Line 4737: FTE_UTIL_PKG.Write_LogFile(l_module_name,'Return status from FTE_VALIDATION_PKG.VALIDATE_COLUMNS ', x_status);

4733: p_line_number => p_line_number-1,
4734: x_status => x_status,
4735: x_error_msg => x_error_msg);
4736: IF (x_status <> -1) THEN
4737: FTE_UTIL_PKG.Write_LogFile(l_module_name,'Return status from FTE_VALIDATION_PKG.VALIDATE_COLUMNS ', x_status);
4738: RETURN;
4739: END IF;
4740: END IF;
4741:

Line 4819: FTE_VALIDATION_PKG.VALIDATE_ACTION(p_action => G_ACTION,

4815: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_end_date ',l_end_date);
4816: END IF;
4817:
4818: IF (p_doValidate) THEN
4819: FTE_VALIDATION_PKG.VALIDATE_ACTION(p_action => G_ACTION,
4820: p_type => l_block_type,
4821: p_line_number => p_line_number + i + 1,
4822: x_status => x_status,
4823: x_error_msg => x_error_msg);

Line 4825: FTE_UTIL_PKG.Write_LogFile(l_module_name,'FTE_VALIDATION_PKG.VALIDATE_ACTION failed');

4821: p_line_number => p_line_number + i + 1,
4822: x_status => x_status,
4823: x_error_msg => x_error_msg);
4824: IF (x_status <> -1) THEN
4825: FTE_UTIL_PKG.Write_LogFile(l_module_name,'FTE_VALIDATION_PKG.VALIDATE_ACTION failed');
4826: FTE_UTIL_PKG.Exit_Debug(l_module_name);
4827: RETURN;
4828: END IF;
4829: END IF;

Line 4871: l_service_level := FTE_VALIDATION_PKG.VALIDATE_SERVICE_LEVEL(p_carrier_id => NULL,

4867: END IF;
4868: END IF;
4869:
4870: IF (p_doValidate) THEN
4871: l_service_level := FTE_VALIDATION_PKG.VALIDATE_SERVICE_LEVEL(p_carrier_id => NULL,
4872: p_carrier_name => l_carrier_name,
4873: p_service_level => l_service_level,
4874: p_line_number => p_line_number + i + 1,
4875: x_error_msg => x_error_msg,

Line 5400: FTE_VALIDATION_PKG.VALIDATE_COLUMNS(p_keys => p_block_header,

5396: END IF;
5397: END IF;
5398:
5399: IF (p_doValidate) THEN
5400: FTE_VALIDATION_PKG.VALIDATE_COLUMNS(p_keys => p_block_header,
5401: p_type => l_type,
5402: p_line_number => p_line_number-1,
5403: x_status => x_status,
5404: x_error_msg => x_error_msg);

Line 5525: FTE_VALIDATION_PKG.VALIDATE_ACTION(p_action => G_ACTION,

5521: l_min_charge := Fnd_Number.Canonical_To_Number(l_min_charge);
5522:
5523: IF (p_doValidate) THEN
5524:
5525: FTE_VALIDATION_PKG.VALIDATE_ACTION(p_action => G_ACTION,
5526: p_type => l_type,
5527: p_line_number => p_line_number + i + 1,
5528: x_status => x_status,
5529: x_error_msg => x_error_msg);

Line 5532: FTE_UTIL_PKG.Write_LogFile(l_module_name,'FTE_VALIDATION_PKG.VALIDATE_ACTION failed');

5528: x_status => x_status,
5529: x_error_msg => x_error_msg);
5530:
5531: IF (x_status <> -1) THEN
5532: FTE_UTIL_PKG.Write_LogFile(l_module_name,'FTE_VALIDATION_PKG.VALIDATE_ACTION failed');
5533: RETURN;
5534: END IF;
5535:
5536: END IF;

Line 5795: l_service_level := FTE_VALIDATION_PKG.VALIDATE_SERVICE_LEVEL(p_carrier_id => NULL,

5791:
5792: --+
5793: -- Service Level is required.
5794: --+
5795: l_service_level := FTE_VALIDATION_PKG.VALIDATE_SERVICE_LEVEL(p_carrier_id => NULL,
5796: p_carrier_name => l_carrier_name,
5797: p_service_level => l_service_level,
5798: p_line_number => p_line_number + i + 1,
5799: x_error_msg => x_error_msg,

Line 6483: FTE_VALIDATION_PKG.VALIDATE_COLUMNS(p_keys => p_block_header,

6479:
6480: FTE_UTIL_PKG.Enter_Debug(l_module_name);
6481: x_status := -1;
6482:
6483: FTE_VALIDATION_PKG.VALIDATE_COLUMNS(p_keys => p_block_header,
6484: p_type => l_type,
6485: p_line_number => p_line_number+1,
6486: x_status => x_status,
6487: x_error_msg => x_error_msg);

Line 6503: FTE_VALIDATION_PKG.VALIDATE_ACTION(p_action => l_action,

6499: -- The valid actions for TL are ADD, DELETE and UPDATE.
6500: l_action := FTE_UTIL_PKG.GET_DATA('ACTION', l_values);
6501:
6502:
6503: FTE_VALIDATION_PKG.VALIDATE_ACTION(p_action => l_action,
6504: p_type => l_type,
6505: p_line_number => p_line_number + i + 1,
6506: x_status => x_status,
6507: x_error_msg => x_error_msg);

Line 6519: FTE_VALIDATION_PKG.VALIDATE_TL_SERVICE(p_values => l_values,

6515: -- VALIDATE_TL_SERVICE validates CARRIER,MODE etc., of the line
6516: -- and put the values in the pl/sql tables passed. We collect the values in these pl/sql
6517: -- tables and do a bulk insert after the processing all the lines.
6518: --+
6519: FTE_VALIDATION_PKG.VALIDATE_TL_SERVICE(p_values => l_values,
6520: p_line_number => p_line_number + i + 1,
6521: p_type => l_type,
6522: p_action => l_action,
6523: p_lane_tbl => g_lane_tbl,