APPS.AHL_APPROVALS_PVT dependencies on AHL_UTILITY_PVT

Line 495: Ahl_Utility_Pvt.debug_message('SQL statement: '||l_sql);

491: ELSE
492: l_sql := l_sql ;
493: END IF;
494:
495: Ahl_Utility_Pvt.debug_message('SQL statement: '||l_sql);
496: --
497: -- Modify here if number of WHERE conditions
498: -- supported changes.
499: BEGIN

Line 1023: Ahl_Utility_Pvt.check_status_order_change (

1019: END IF;
1020:
1021: IF UPPER(l_status) <> UPPER(p_Approval_Rules_rec.status_code) THEN
1022:
1023: Ahl_Utility_Pvt.check_status_order_change (
1024: 'AHL_APPR_STATUS_TYPE',
1025: l_status,
1026: p_Approval_Rules_rec.status_code,
1027: l_return_status

Line 2163: IF Ahl_Utility_Pvt.check_uniqueness(

2159: -- check if this ID is unique.
2160: IF p_validation_mode = Jtf_Plsql_Api.g_create
2161: AND p_Approval_Rules_rec.Approval_Rule_id IS NOT NULL
2162: THEN
2163: IF Ahl_Utility_Pvt.check_uniqueness(
2164: 'Ahl_Approval_Rules_v',
2165: 'Approval_Rule_Id = ' || p_Approval_Rules_rec.Approval_Rule_id
2166: ) = Fnd_Api.g_false
2167: THEN

Line 2179: l_valid_flag := Ahl_Utility_Pvt.Check_Uniqueness (

2175: END IF;
2176:
2177: -- check if NAME is UNIQUE
2178: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
2179: l_valid_flag := Ahl_Utility_Pvt.Check_Uniqueness (
2180: 'Ahl_Approval_Rules_v',
2181: 'approval_rule_name = ''' || p_Approval_Rules_rec.approval_rule_name || ''''
2182: -- ''' AND language = ''' || p_Approval_Rules_rec.language || ''''
2183: );

Line 2185: l_valid_flag := Ahl_Utility_Pvt.Check_Uniqueness (

2181: 'approval_rule_name = ''' || p_Approval_Rules_rec.approval_rule_name || ''''
2182: -- ''' AND language = ''' || p_Approval_Rules_rec.language || ''''
2183: );
2184: ELSE
2185: l_valid_flag := Ahl_Utility_Pvt.Check_Uniqueness (
2186: 'Ahl_Approval_Rules_v',
2187: 'approval_rule_name = ''' || p_Approval_Rules_rec.approval_rule_name ||
2188: -- ''' AND language = ''' || p_Approval_Rules_rec.language ||
2189: ''' AND approval_rule_id <> ' || p_Approval_Rules_rec.approval_rule_id

Line 3387: IF Ahl_Utility_Pvt.check_uniqueness(

3383: -- check if this ID is unique.
3384: IF p_validation_mode = Jtf_Plsql_Api.g_create
3385: AND p_Approvers_rec.Approval_Approver_Id IS NOT NULL
3386: THEN
3387: IF Ahl_Utility_Pvt.check_uniqueness(
3388: 'AHL_Approvers',
3389: 'APPROVAL_APPROVER_ID = ' || p_Approvers_rec.Approval_Approver_Id
3390: ) = Fnd_Api.g_false
3391: THEN

Line 3403: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (

3399: END IF;
3400: -- check if Approval_Rule_Id,Approver_Sequence and Approver_Id is UNIQUE
3401:
3402: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
3403: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (
3404: 'AHL_Approvers',
3405: 'Approval_Rule_Id = ' || p_Approvers_rec.Approval_Rule_Id ||
3406: ' AND Approver_Sequence = ' || p_Approvers_rec.Approver_Sequence
3407: );

Line 3409: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (

3405: 'Approval_Rule_Id = ' || p_Approvers_rec.Approval_Rule_Id ||
3406: ' AND Approver_Sequence = ' || p_Approvers_rec.Approver_Sequence
3407: );
3408: ELSE
3409: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (
3410: 'AHL_Approvers',
3411: 'Approval_Rule_Id = ' || p_Approvers_rec.Approval_Rule_Id ||
3412: ' AND Approver_Sequence = ' || p_Approvers_rec.Approver_Sequence ||
3413: ' AND Approval_Approver_id <> ' || p_Approvers_rec.Approval_Approver_id