DBA Data[Home] [Help]

APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on FND_MSG_PUB

Line 841: fnd_msg_pub.ADD;

837: CLOSE l_cur;
838: x_return_status := fnd_api.g_ret_sts_error;
839: fnd_message.set_name('POS','POS_PRCR_BAD_ADDR_REQ_ID');
840: fnd_message.set_token('ADDRRESS_REQUEST_ID', p_request_id);
841: fnd_msg_pub.ADD;
842: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
843: rollback to approve_address_req;
844: RETURN;
845: END IF;

Line 842: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

838: x_return_status := fnd_api.g_ret_sts_error;
839: fnd_message.set_name('POS','POS_PRCR_BAD_ADDR_REQ_ID');
840: fnd_message.set_token('ADDRRESS_REQUEST_ID', p_request_id);
841: fnd_msg_pub.ADD;
842: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
843: rollback to approve_address_req;
844: RETURN;
845: END IF;
846: CLOSE l_cur;

Line 852: fnd_msg_pub.ADD;

848: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
849: x_return_status := fnd_api.g_ret_sts_error;
850: fnd_message.set_name('POS','POS_PRCR_ADDRREQ_NOT_PEND');
851: fnd_message.set_token('ADDRRESS_REQUEST_ID', p_request_id);
852: fnd_msg_pub.ADD;
853: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
854: rollback to approve_address_req;
855: RETURN;
856: END IF;

Line 853: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

849: x_return_status := fnd_api.g_ret_sts_error;
850: fnd_message.set_name('POS','POS_PRCR_ADDRREQ_NOT_PEND');
851: fnd_message.set_token('ADDRRESS_REQUEST_ID', p_request_id);
852: fnd_msg_pub.ADD;
853: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
854: rollback to approve_address_req;
855: RETURN;
856: END IF;
857:

Line 865: fnd_msg_pub.ADD;

861: CLOSE l_cur2;
862: x_return_status := fnd_api.g_ret_sts_error;
863: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
864: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
865: fnd_msg_pub.ADD;
866: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
867: rollback to approve_address_req;
868: RETURN;
869: END IF;

Line 866: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

862: x_return_status := fnd_api.g_ret_sts_error;
863: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
864: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
865: fnd_msg_pub.ADD;
866: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
867: rollback to approve_address_req;
868: RETURN;
869: END IF;
870: CLOSE l_cur2;

Line 1009: fnd_msg_pub.ADD;

1005: CLOSE l_cur;
1006: x_return_status := fnd_api.g_ret_sts_error;
1007: fnd_message.set_name('POS','POS_PRCR_BAD_CONT_REQ_ID');
1008: fnd_message.set_token('CONTACT_REQUEST_ID', p_request_id);
1009: fnd_msg_pub.ADD;
1010: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1011: rollback to approve_contact_req;
1012: RETURN;
1013: END IF;

Line 1010: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

1006: x_return_status := fnd_api.g_ret_sts_error;
1007: fnd_message.set_name('POS','POS_PRCR_BAD_CONT_REQ_ID');
1008: fnd_message.set_token('CONTACT_REQUEST_ID', p_request_id);
1009: fnd_msg_pub.ADD;
1010: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1011: rollback to approve_contact_req;
1012: RETURN;
1013: END IF;
1014: CLOSE l_cur;

Line 1020: fnd_msg_pub.ADD;

1016: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
1017: x_return_status := fnd_api.g_ret_sts_error;
1018: fnd_message.set_name('POS','POS_PRCR_CONTREQ_NOT_PEND');
1019: fnd_message.set_token('CONTACT_REQUEST_ID', p_request_id);
1020: fnd_msg_pub.ADD;
1021: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1022: rollback to approve_contact_req;
1023: RETURN;
1024: END IF;

Line 1021: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

1017: x_return_status := fnd_api.g_ret_sts_error;
1018: fnd_message.set_name('POS','POS_PRCR_CONTREQ_NOT_PEND');
1019: fnd_message.set_token('CONTACT_REQUEST_ID', p_request_id);
1020: fnd_msg_pub.ADD;
1021: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1022: rollback to approve_contact_req;
1023: RETURN;
1024: END IF;
1025:

Line 1033: fnd_msg_pub.ADD;

1029: CLOSE l_cur2;
1030: x_return_status := fnd_api.g_ret_sts_error;
1031: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1032: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1033: fnd_msg_pub.ADD;
1034: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1035: rollback to approve_contact_req;
1036: RETURN;
1037: END IF;

Line 1034: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

1030: x_return_status := fnd_api.g_ret_sts_error;
1031: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1032: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1033: fnd_msg_pub.ADD;
1034: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1035: rollback to approve_contact_req;
1036: RETURN;
1037: END IF;
1038: CLOSE l_cur2;

Line 1153: fnd_msg_pub.ADD;

1149: CLOSE l_cur;
1150: x_return_status := fnd_api.g_ret_sts_error;
1151: fnd_message.set_name('POS','POS_PRCR_BAD_BC_REQ_ID');
1152: fnd_message.set_token('BUS_CLASS_REQUEST_ID', p_request_id);
1153: fnd_msg_pub.ADD;
1154: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1155: rollback to approve_bus_class_req;
1156: RETURN;
1157: END IF;

Line 1154: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

1150: x_return_status := fnd_api.g_ret_sts_error;
1151: fnd_message.set_name('POS','POS_PRCR_BAD_BC_REQ_ID');
1152: fnd_message.set_token('BUS_CLASS_REQUEST_ID', p_request_id);
1153: fnd_msg_pub.ADD;
1154: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1155: rollback to approve_bus_class_req;
1156: RETURN;
1157: END IF;
1158: CLOSE l_cur;

Line 1164: fnd_msg_pub.ADD;

1160: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
1161: x_return_status := fnd_api.g_ret_sts_error;
1162: fnd_message.set_name('POS','POS_PRCR_BCREQ_NOT_PEND');
1163: fnd_message.set_token('BUS_CLASS_REQUEST_ID', p_request_id);
1164: fnd_msg_pub.ADD;
1165: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1166: rollback to approve_bus_class_req;
1167: RETURN;
1168: END IF;

Line 1165: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

1161: x_return_status := fnd_api.g_ret_sts_error;
1162: fnd_message.set_name('POS','POS_PRCR_BCREQ_NOT_PEND');
1163: fnd_message.set_token('BUS_CLASS_REQUEST_ID', p_request_id);
1164: fnd_msg_pub.ADD;
1165: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1166: rollback to approve_bus_class_req;
1167: RETURN;
1168: END IF;
1169:

Line 1177: fnd_msg_pub.ADD;

1173: CLOSE l_cur2;
1174: x_return_status := fnd_api.g_ret_sts_error;
1175: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1176: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1177: fnd_msg_pub.ADD;
1178: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1179: rollback to approve_bus_class_req;
1180: RETURN;
1181: END IF;

Line 1178: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

1174: x_return_status := fnd_api.g_ret_sts_error;
1175: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1176: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1177: fnd_msg_pub.ADD;
1178: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1179: rollback to approve_bus_class_req;
1180: RETURN;
1181: END IF;
1182: CLOSE l_cur2;

Line 1260: fnd_msg_pub.ADD;

1256: CLOSE l_cur;
1257: x_return_status := fnd_api.g_ret_sts_error;
1258: fnd_message.set_name('POS','POS_PRCR_BAD_PS_REQ_ID');
1259: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1260: fnd_msg_pub.ADD;
1261: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1262: rollback to approve_ps_req;
1263: RETURN;
1264: END IF;

Line 1261: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

1257: x_return_status := fnd_api.g_ret_sts_error;
1258: fnd_message.set_name('POS','POS_PRCR_BAD_PS_REQ_ID');
1259: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1260: fnd_msg_pub.ADD;
1261: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1262: rollback to approve_ps_req;
1263: RETURN;
1264: END IF;
1265: CLOSE l_cur;

Line 1271: fnd_msg_pub.ADD;

1267: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
1268: x_return_status := fnd_api.g_ret_sts_error;
1269: fnd_message.set_name('POS','POS_PRCR_PSREQ_NOT_PEND');
1270: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1271: fnd_msg_pub.ADD;
1272: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1273: rollback to approve_ps_req;
1274: RETURN;
1275: END IF;

Line 1272: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

1268: x_return_status := fnd_api.g_ret_sts_error;
1269: fnd_message.set_name('POS','POS_PRCR_PSREQ_NOT_PEND');
1270: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1271: fnd_msg_pub.ADD;
1272: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1273: rollback to approve_ps_req;
1274: RETURN;
1275: END IF;
1276:

Line 1281: fnd_msg_pub.ADD;

1277: IF l_rec.request_type IS NULL OR l_rec.request_type <> 'ADD' THEN
1278: x_return_status := fnd_api.g_ret_sts_error;
1279: fnd_message.set_name('POS','POS_PRCR_PSREQ_TYPE_NOT_ADD');
1280: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1281: fnd_msg_pub.ADD;
1282: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1283: rollback to approve_ps_req;
1284: RETURN;
1285: END IF;

Line 1282: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

1278: x_return_status := fnd_api.g_ret_sts_error;
1279: fnd_message.set_name('POS','POS_PRCR_PSREQ_TYPE_NOT_ADD');
1280: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1281: fnd_msg_pub.ADD;
1282: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1283: rollback to approve_ps_req;
1284: RETURN;
1285: END IF;
1286:

Line 1294: fnd_msg_pub.ADD;

1290: CLOSE l_cur2;
1291: x_return_status := fnd_api.g_ret_sts_error;
1292: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1293: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1294: fnd_msg_pub.ADD;
1295: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1296: rollback to approve_ps_req;
1297: RETURN;
1298: END IF;

Line 1295: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

1291: x_return_status := fnd_api.g_ret_sts_error;
1292: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1293: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1294: fnd_msg_pub.ADD;
1295: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1296: rollback to approve_ps_req;
1297: RETURN;
1298: END IF;
1299: CLOSE l_cur2;