DBA Data[Home] [Help]

APPS.FUN_SEQ dependencies on APP_EXCEPTION

Line 190: app_exception.raise_exception;

186:
187: --
188: -- Raise Exception
189: --
190: app_exception.raise_exception;
191: END Get_Sequence_Number;
192:
193: --
194: -- Procedure Name: get_assigned_sequence_info

Line 406: app_exception.raise_exception;

402: fnd_message.set_name ('FUN','FUN_SEQ_NO_ACTIVE_ASSGN_FOUND');
403: fnd_message.set_token ('SEQ_CONTEXT_NAME',
404: get_seq_context_name(l_seq_context_id));
405: IF p_suppress_error = 'N' THEN
406: app_exception.raise_exception;
407: END IF;
408: WHEN OTHERS THEN
409: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
410: fnd_log.string(

Line 416: app_exception.raise_exception;

412: 'fun.plsql.fun_seq.get_assigned_sequence_info.exception',
413: 'l_seq_context_id :' || l_seq_context_id ||', ' ||
414: 'SQLERRM: ' || SQLERRM);
415: END IF;
416: app_exception.raise_exception;
417: END Get_Assigned_Sequence_Info;
418:
419: --
420: -- PROCEDURE NAME:

Line 500: app_exception.raise_exception;

496: module => 'fun.plsql.fun_seq.generate_sequence_number',
497: message => 'Invalid Sequence Type: ' || ', ' ||
498: 'SQLERRM: ' || SQLERRM);
499: END IF;
500: app_exception.raise_exception;
501: WHEN OTHERS THEN
502: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
503: fnd_log.string(
504: log_level => fnd_log.level_exception,

Line 509: app_exception.raise_exception;

505: module => 'fun.plsql.fun_seq.generate_sequence_number',
506: message =>
507: 'SQLERRM: ' || SQLERRM);
508: END IF;
509: app_exception.raise_exception;
510: END Generate_Sequence_Number;
511:
512: --
513: -- PROCEDURE NAME: reset

Line 538: app_exception.raise_exception;

534: module => 'fun.plsql.fun_seq.reset',
535: message =>
536: 'SQLERRM: ' || SQLERRM);
537: END IF;
538: app_exception.raise_exception;
539: END Reset;
540:
541: --
542: -- Retrieve an Active Sequence Assignment Context

Line 651: app_exception.raise_exception;

647: FND_MESSAGE.SET_TOKEN('ROUTINE', 'p_context_value: ' || p_context_value);
648: FND_MESSAGE.SET_TOKEN('ERRNO', '100');
649: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
650: FND_MESSAGE.RAISE_ERROR;
651: app_exception.raise_exception;
652: END get_assign_context_info;
653:
654:
655: --

Line 833: app_exception.raise_exception;

829: -- The message is put on the stack in Get_Assigned_Sequence_Info
830: --
831: x_error_code := 'ENFORCED_NO_ASSIGNMENT';
832: IF p_suppress_error = 'N' THEN
833: app_exception.raise_exception;
834: END IF;
835: WHEN OTHERS THEN
836: --
837: -- Logging

Line 868: app_exception.raise_exception;

864: END IF;
865: --
866: -- Raise Exception
867: --
868: app_exception.raise_exception;
869: END Get_Sequence_Number_No_Commit;
870:
871: --
872: -- Get Sequence Number (without Autonmous Commit)

Line 965: app_exception.raise_exception;

961: END IF;
962:
963: EXCEPTION
964: WHEN OTHERS THEN
965: app_exception.raise_exception;
966: END get_cached_context_info;
967:
968: --
969: -- Retrieve Assigned Sequences of Assignment / Exception

Line 1044: app_exception.raise_exception;

1040: x_seq_header_id := l_exp_seq_header_id;
1041: END IF;
1042: EXCEPTION
1043: WHEN OTHERS THEN
1044: app_exception.raise_exception;
1045: END get_assigned_sequence_header;
1046:
1047: --
1048: -- Retrieve Assignment Information of Intercompany Transactions

Line 1078: app_exception.raise_exception;

1074: AND p_control_date_value <= NVL(sa.end_date, p_control_date_value + 1);
1075: -- END IF;
1076: EXCEPTION
1077: WHEN OTHERS THEN
1078: app_exception.raise_exception;
1079: END get_ic_assigned_seq_header;
1080:
1081: --
1082: -- Retrieve Assignment Id and its Sequence Header Id of Assignments.

Line 1157: app_exception.raise_exception;

1153: EXCEPTION
1154: WHEN NO_DATA_FOUND THEN
1155: x_assignment_id := NULL;
1156: WHEN OTHERS THEN
1157: app_exception.raise_exception;
1158: END get_seq_header_assignment;
1159:
1160: --
1161: -- Retrieve Assignment Id and Sequence Header Id from the Cache

Line 1231: app_exception.raise_exception;

1227: END IF;
1228:
1229: EXCEPTION
1230: WHEN OTHERS THEN
1231: app_exception.raise_exception;
1232: END get_cached_seq_header_assign;
1233: --
1234: -- Retrieve Assignment Id and its Sequence Header Id of Exceptions.
1235: -- Note:

Line 1335: app_exception.raise_exception;

1331: x_exp_assignment_id := NULL;
1332: x_exp_sequence_type := NULL;
1333: x_exp_seq_header_id := NULL;
1334: WHEN OTHERS THEN
1335: app_exception.raise_exception;
1336: END get_seq_header_exception;
1337:
1338: --
1339: -- Get_Seq_Context_Name

Line 1442: app_exception.raise_exception;

1438: END IF;
1439:
1440: EXCEPTION
1441: WHEN OTHERS THEN
1442: app_exception.raise_exception;
1443: END get_cached_seq_header_exp;
1444:
1445: -- Program Name: Get_Seq_Version
1446: -- Description:

Line 1482: app_exception.raise_exception;

1478: fnd_message.set_token ('SEQ_NAME',get_seq_header_name(p_seq_header_id));
1479: --
1480: -- Cannot suppress this exception
1481: --
1482: app_exception.raise_exception;
1483: END get_seq_version;
1484:
1485: --
1486: --

Line 1502: app_exception.raise_exception;

1498:
1499: RETURN l_control_date_value;
1500: EXCEPTION
1501: WHEN OTHERS THEN
1502: app_exception.raise_exception;
1503: END get_control_date_value;
1504:
1505: --
1506: -- Updat_Gapless_Status

Line 1523: app_exception.raise_exception;

1519: --
1520: update_assign_status (p_assignment_id => p_assignment_id);
1521: EXCEPTION
1522: WHEN OTHERS THEN
1523: app_exception.raise_exception;
1524: END update_gapless_status;
1525:
1526: --
1527: -- Update the Status of Versions with Database Sequence

Line 1550: app_exception.raise_exception;

1546: --
1547: COMMIT;
1548: EXCEPTION
1549: WHEN OTHERS THEN
1550: app_exception.raise_exception;
1551: END update_db_status;
1552:
1553: --
1554: -- Update_Assign_Status

Line 1586: app_exception.raise_exception;

1582: WHERE assignment_id = l_assign_id_tbl(i);
1583: END IF;
1584: EXCEPTION
1585: WHEN OTHERS THEN
1586: app_exception.raise_exception;
1587: END update_assign_status;
1588: --
1589: -- Update_Seq_Ver_Status
1590: --

Line 1616: app_exception.raise_exception;

1612: EXCEPTION
1613: WHEN NO_DATA_FOUND THEN
1614: NULL;
1615: WHEN OTHERS THEN
1616: app_exception.raise_exception;
1617: END update_seq_ver_status;
1618: --
1619: -- Find a Sequencing Context in the Cache
1620: --

Line 1687: app_exception.raise_exception;

1683: --
1684: l_context_ctrl_rec := NULL;
1685: RETURN l_context_ctrl_rec;
1686: WHEN OTHERS THEN
1687: app_exception.raise_exception;
1688: END find_seq_context_in_db;
1689:
1690: --
1691: -- Find an Assigned Sequence Header in the Cache

Line 1795: app_exception.raise_exception;

1791: --
1792: l_assign_seq_head_rec := NULL;
1793: RETURN l_assign_seq_head_rec;
1794: WHEN OTHERS THEN
1795: app_exception.raise_exception;
1796: END find_seq_head_assign_in_db;
1797:
1798: --
1799: -- Find an Exception in the database