DBA Data[Home] [Help]

APPS.QLTDACTB dependencies on FND_MESSAGE

Line 751: fnd_message.set_name('QA', 'QA_INCONVERTIBLE_UOM');

747: null,
748: null);
749: END IF;
750: IF ((low_value_tab(i) = -99999) OR (high_value_tab(i) = -99999)) THEN
751: fnd_message.set_name('QA', 'QA_INCONVERTIBLE_UOM');
752: fnd_message.set_token('ENTITY1', prec.SPEC_CHAR_UOM);
753: fnd_message.set_token('ENTITY2', prec.PLAN_CHAR_UOM);
754: fnd_msg_pub.add();
755: END IF;

Line 752: fnd_message.set_token('ENTITY1', prec.SPEC_CHAR_UOM);

748: null);
749: END IF;
750: IF ((low_value_tab(i) = -99999) OR (high_value_tab(i) = -99999)) THEN
751: fnd_message.set_name('QA', 'QA_INCONVERTIBLE_UOM');
752: fnd_message.set_token('ENTITY1', prec.SPEC_CHAR_UOM);
753: fnd_message.set_token('ENTITY2', prec.PLAN_CHAR_UOM);
754: fnd_msg_pub.add();
755: END IF;
756: END IF; -- (Y_SPEC_ID <> 0)...

Line 753: fnd_message.set_token('ENTITY2', prec.PLAN_CHAR_UOM);

749: END IF;
750: IF ((low_value_tab(i) = -99999) OR (high_value_tab(i) = -99999)) THEN
751: fnd_message.set_name('QA', 'QA_INCONVERTIBLE_UOM');
752: fnd_message.set_token('ENTITY1', prec.SPEC_CHAR_UOM);
753: fnd_message.set_token('ENTITY2', prec.PLAN_CHAR_UOM);
754: fnd_msg_pub.add();
755: END IF;
756: END IF; -- (Y_SPEC_ID <> 0)...
757: END LOOP;

Line 876: X_message := FND_MESSAGE.GET;

872: EXCEPTION
873: WHEN OTHERS THEN
874: -- write exceptions to action log;
875: X_ERROR := FALSE;
876: X_message := FND_MESSAGE.GET;
877: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
878: X_CREATION_DATE,char_id_tab(i),
879: operator_tab(i),low_value_tab(i),
880: high_value_tab(i),X_message,

Line 923: X_message := FND_MESSAGE.GET;

919: EXCEPTION
920: WHEN OTHERS THEN
921: -- write exceptions to action log;
922: X_ERROR := FALSE;
923: X_message := FND_MESSAGE.GET;
924: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
925: X_CREATION_DATE,char_id_tab(i),
926: operator_tab(i),low_value_tab(i),
927: high_value_tab(i),X_message,

Line 971: FND_MESSAGE.SET_NAME('QA', 'QA_LOT_STATUS_ACTION_FAIL');

967:
968: EXCEPTION
969: WHEN fail_setting_lot_status THEN
970:
971: FND_MESSAGE.SET_NAME('QA', 'QA_LOT_STATUS_ACTION_FAIL');
972: X_message := FND_MESSAGE.GET;
973: X_message := X_message ||X_msg_data;
974:
975: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,

Line 972: X_message := FND_MESSAGE.GET;

968: EXCEPTION
969: WHEN fail_setting_lot_status THEN
970:
971: FND_MESSAGE.SET_NAME('QA', 'QA_LOT_STATUS_ACTION_FAIL');
972: X_message := FND_MESSAGE.GET;
973: X_message := X_message ||X_msg_data;
974:
975: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
976: X_CREATION_DATE,char_id_tab(i),

Line 983: X_message := FND_MESSAGE.GET;

979: result,X_CONCURRENT);
980: WHEN OTHERS THEN
981: -- write exceptions to action log;
982: X_ERROR := FALSE;
983: X_message := FND_MESSAGE.GET;
984: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
985: X_CREATION_DATE,char_id_tab(i),
986: operator_tab(i),low_value_tab(i),
987: high_value_tab(i),X_message,

Line 1031: FND_MESSAGE.SET_NAME('QA', 'QA_SERIAL_STATUS_ACTION_FAIL');

1027:
1028: EXCEPTION
1029: WHEN fail_setting_serial_status THEN
1030:
1031: FND_MESSAGE.SET_NAME('QA', 'QA_SERIAL_STATUS_ACTION_FAIL');
1032: X_message := FND_MESSAGE.GET;
1033: X_message := X_message || X_msg_data;
1034:
1035: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,

Line 1032: X_message := FND_MESSAGE.GET;

1028: EXCEPTION
1029: WHEN fail_setting_serial_status THEN
1030:
1031: FND_MESSAGE.SET_NAME('QA', 'QA_SERIAL_STATUS_ACTION_FAIL');
1032: X_message := FND_MESSAGE.GET;
1033: X_message := X_message || X_msg_data;
1034:
1035: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1036: X_CREATION_DATE,char_id_tab(i),

Line 1043: X_message := FND_MESSAGE.GET;

1039: result,X_CONCURRENT);
1040: WHEN OTHERS THEN
1041: -- write exceptions to action log;
1042: X_ERROR := FALSE;
1043: X_message := FND_MESSAGE.GET;
1044: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1045: X_CREATION_DATE,char_id_tab(i),
1046: operator_tab(i),low_value_tab(i),
1047: high_value_tab(i),X_message,

Line 1083: X_message := FND_MESSAGE.GET;

1079: EXCEPTION
1080: WHEN OTHERS THEN
1081: -- write exceptions to action log;
1082: X_ERROR := FALSE;
1083: X_message := FND_MESSAGE.GET;
1084: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1085: X_CREATION_DATE,char_id_tab(i),
1086: operator_tab(i),low_value_tab(i),
1087: high_value_tab(i),X_message,

Line 1112: X_message := FND_MESSAGE.GET;

1108: EXCEPTION
1109: WHEN po_api_failed THEN
1110: -- write exceptions to action log;
1111: X_ERROR := FALSE;
1112: X_message := FND_MESSAGE.GET;
1113: X_message := X_message || X_msg_data;
1114: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1115: X_CREATION_DATE,char_id_tab(i),
1116: operator_tab(i),low_value_tab(i),

Line 1158: X_message := FND_MESSAGE.GET;

1154: EXCEPTION
1155: WHEN OTHERS THEN
1156: -- write exceptions to action log;
1157: X_ERROR := FALSE;
1158: X_message := FND_MESSAGE.GET;
1159: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1160: X_CREATION_DATE,char_id_tab(i),
1161: operator_tab(i),low_value_tab(i),
1162: high_value_tab(i),X_message,

Line 1211: X_message := FND_MESSAGE.GET;

1207: EXCEPTION
1208: WHEN OTHERS THEN
1209: -- write exceptions to action log;
1210: X_ERROR := FALSE;
1211: X_message := FND_MESSAGE.GET;
1212: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1213: X_CREATION_DATE,char_id_tab(i),
1214: operator_tab(i),low_value_tab(i),
1215: high_value_tab(i),X_message,

Line 1622: FND_MESSAGE.SET_NAME('QA', 'QA_PO_INSP_ACTION_NULL_TXN_ID');

1618:
1619: WHEN null_txn_id THEN
1620: --dbms_output.put_line('x progress is '||to_char(x_progress));
1621: X_ERROR := FALSE;
1622: FND_MESSAGE.SET_NAME('QA', 'QA_PO_INSP_ACTION_NULL_TXN_ID');
1623: X_message := FND_MESSAGE.GET;
1624: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1625: X_CREATION_DATE,char_id_tab(i),
1626: operator_tab(i),low_value_tab(i),

Line 1623: X_message := FND_MESSAGE.GET;

1619: WHEN null_txn_id THEN
1620: --dbms_output.put_line('x progress is '||to_char(x_progress));
1621: X_ERROR := FALSE;
1622: FND_MESSAGE.SET_NAME('QA', 'QA_PO_INSP_ACTION_NULL_TXN_ID');
1623: X_message := FND_MESSAGE.GET;
1624: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1625: X_CREATION_DATE,char_id_tab(i),
1626: operator_tab(i),low_value_tab(i),
1627: high_value_tab(i),X_message,

Line 1633: FND_MESSAGE.SET_NAME('QA', 'QA_PO_INSP_ACTION_COL_MISSING');

1629:
1630: WHEN column_missing THEN
1631: --dbms_output.put_line('x progress is '||to_char(x_progress));
1632: X_ERROR := FALSE;
1633: FND_MESSAGE.SET_NAME('QA', 'QA_PO_INSP_ACTION_COL_MISSING');
1634: X_message := FND_MESSAGE.GET;
1635: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1636: X_CREATION_DATE,char_id_tab(i),
1637: operator_tab(i),low_value_tab(i),

Line 1634: X_message := FND_MESSAGE.GET;

1630: WHEN column_missing THEN
1631: --dbms_output.put_line('x progress is '||to_char(x_progress));
1632: X_ERROR := FALSE;
1633: FND_MESSAGE.SET_NAME('QA', 'QA_PO_INSP_ACTION_COL_MISSING');
1634: X_message := FND_MESSAGE.GET;
1635: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1636: X_CREATION_DATE,char_id_tab(i),
1637: operator_tab(i),low_value_tab(i),
1638: high_value_tab(i),X_message,

Line 1644: FND_MESSAGE.SET_NAME('QA', 'QA_PO_INSP_ACTION_FAIL');

1640:
1641: WHEN fail_po_insertion THEN
1642: --dbms_output.put_line('x progress is '||to_char(x_progress));
1643: X_ERROR := FALSE;
1644: FND_MESSAGE.SET_NAME('QA', 'QA_PO_INSP_ACTION_FAIL');
1645: X_message := FND_MESSAGE.GET;
1646: X_message := X_message || X_msg_data;
1647: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1648: X_CREATION_DATE,char_id_tab(i),

Line 1645: X_message := FND_MESSAGE.GET;

1641: WHEN fail_po_insertion THEN
1642: --dbms_output.put_line('x progress is '||to_char(x_progress));
1643: X_ERROR := FALSE;
1644: FND_MESSAGE.SET_NAME('QA', 'QA_PO_INSP_ACTION_FAIL');
1645: X_message := FND_MESSAGE.GET;
1646: X_message := X_message || X_msg_data;
1647: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1648: X_CREATION_DATE,char_id_tab(i),
1649: operator_tab(i),low_value_tab(i),

Line 1655: FND_MESSAGE.SET_NAME('QA', 'QA_WMS_SER_INSERT_FAIL');

1651: result,X_CONCURRENT);
1652:
1653: WHEN fail_serial_insertion THEN
1654: X_ERROR := FALSE;
1655: FND_MESSAGE.SET_NAME('QA', 'QA_WMS_SER_INSERT_FAIL');
1656: X_message := FND_MESSAGE.GET;
1657: X_message := X_message || X_msg_data;
1658: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1659: X_CREATION_DATE,char_id_tab(i),

Line 1656: X_message := FND_MESSAGE.GET;

1652:
1653: WHEN fail_serial_insertion THEN
1654: X_ERROR := FALSE;
1655: FND_MESSAGE.SET_NAME('QA', 'QA_WMS_SER_INSERT_FAIL');
1656: X_message := FND_MESSAGE.GET;
1657: X_message := X_message || X_msg_data;
1658: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1659: X_CREATION_DATE,char_id_tab(i),
1660: operator_tab(i),low_value_tab(i),

Line 1666: FND_MESSAGE.SET_NAME('QA', 'QA_WMS_LOT_INSERT_FAIL');

1662: result,X_CONCURRENT);
1663:
1664: WHEN fail_lot_insertion THEN
1665: X_ERROR := FALSE;
1666: FND_MESSAGE.SET_NAME('QA', 'QA_WMS_LOT_INSERT_FAIL');
1667: X_message := FND_MESSAGE.GET;
1668: X_message := X_message || X_msg_data;
1669: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1670: X_CREATION_DATE,char_id_tab(i),

Line 1667: X_message := FND_MESSAGE.GET;

1663:
1664: WHEN fail_lot_insertion THEN
1665: X_ERROR := FALSE;
1666: FND_MESSAGE.SET_NAME('QA', 'QA_WMS_LOT_INSERT_FAIL');
1667: X_message := FND_MESSAGE.GET;
1668: X_message := X_message || X_msg_data;
1669: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1670: X_CREATION_DATE,char_id_tab(i),
1671: operator_tab(i),low_value_tab(i),

Line 1680: X_message := FND_MESSAGE.GET;

1676: WHEN OTHERS THEN
1677: --dbms_output.put_line('x progress is '||to_char(x_progress));
1678: -- write exceptions to action log;
1679: X_ERROR := FALSE;
1680: X_message := FND_MESSAGE.GET;
1681: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1682: X_CREATION_DATE,char_id_tab(i),
1683: operator_tab(i),low_value_tab(i),
1684: high_value_tab(i),X_message,

Line 1789: -- build the message for request_log by concatenating fnd_message and user input text message.

1785:
1786: -- get user id
1787: user_id := NVL(FND_PROFILE.VALUE('USER_ID'), 0);
1788:
1789: -- build the message for request_log by concatenating fnd_message and user input text message.
1790:
1791: -- Commented the usage of the cursor get_user_message and added code to use the cursor
1792: -- my_message, as the cursor get_user_message was showing up the message of the first
1793: -- trigger action of an element only in the EAM work requests even though the second or

Line 1808: request_log := fnd_message.get_string('QA', 'QA_WORK_REQUEST_LOG');

1804: OPEN MY_MESSAGE(pca_id_tab(i));
1805: FETCH MY_MESSAGE INTO X_MESSAGE, X_ASSIGN_TYPE;
1806: CLOSE MY_MESSAGE;
1807:
1808: request_log := fnd_message.get_string('QA', 'QA_WORK_REQUEST_LOG');
1809: request_log := request_log || ' ' || x_message;
1810:
1811:
1812:

Line 2016: X_message := FND_MESSAGE.GET;

2012: EXCEPTION
2013: WHEN OTHERS THEN
2014: -- write exceptions to action log;
2015: X_ERROR := FALSE;
2016: X_message := FND_MESSAGE.GET;
2017: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
2018: X_CREATION_DATE,char_id_tab(i),
2019: operator_tab(i),low_value_tab(i),
2020: high_value_tab(i),X_message,